Code Context
<?php if(count($productCategories) > 0){ ?>
<?php
$viewFile = '/home/lakshopdev/web/stg.lakshop.lk/public_html/src/Template/Layout/lakshop_template_layouts/8/wonderland/layout.ctp'
$dataForView = [
'websiteBrands' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.photo AS `Brands__photo`, Brands.photo_dir AS `Brands__photo_dir`, Brands.website_id AS `Brands__website_id`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM brands Brands WHERE (Brands.website_id = :c0 AND Brands.id in (:c1,:c2)) ORDER BY Brands.name ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\BrandsTable) {}
},
'websiteBrandList' => [],
'searchQuery' => null,
'lastProductId' => null,
'products' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.featured_item AS `Products__featured_item`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.price AS `Products__price`, Products.quantity AS `Products__quantity`, Products.vendor_id AS `Products__vendor_id`, Products.weight AS `Products__weight`, Products.volume AS `Products__volume`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.stock_available AS `Products__stock_available`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.product_type AS `Products__product_type`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.free_delivery AS `Products__free_delivery`, Products.active AS `Products__active`, Products.created AS `Products__created`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.private_info AS `Products__private_info`, Products.discount_value AS `Products__discount_value`, Products.discount_percentage AS `Products__discount_percentage`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.currency AS `Products__currency`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, Websites.id AS `Websites__id`, Websites.user_id AS `Websites__user_id`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.name AS `ProductCategories__name`, ProductCategories.photo AS `ProductCategories__photo`, ProductCategories.photo_dir AS `ProductCategories__photo_dir`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductCategories.custom_field_1_label AS `ProductCategories__custom_field_1_label`, ProductCategories.custom_field_2_label AS `ProductCategories__custom_field_2_label`, ProductCategories.custom_field_3_label AS `ProductCategories__custom_field_3_label`, ProductCategories.custom_field_4_label AS `ProductCategories__custom_field_4_label`, ProductCategories.custom_field_5_label AS `ProductCategories__custom_field_5_label`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.name AS `ProductSubCategories__name`, ProductSubCategories.product_category_id AS `ProductSubCategories__product_category_id`, ProductSubCategories.photo AS `ProductSubCategories__photo`, ProductSubCategories.photo_dir AS `ProductSubCategories__photo_dir`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSubCategories.custom_field_1_label AS `ProductSubCategories__custom_field_1_label`, ProductSubCategories.custom_field_2_label AS `ProductSubCategories__custom_field_2_label`, ProductSubCategories.custom_field_3_label AS `ProductSubCategories__custom_field_3_label`, ProductSubCategories.custom_field_4_label AS `ProductSubCategories__custom_field_4_label`, ProductSubCategories.custom_field_5_label AS `ProductSubCategories__custom_field_5_label`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.name AS `ProductSuperSubCategories__name`, ProductSuperSubCategories.product_sub_category_id AS `ProductSuperSubCategories__product_sub_category_id`, ProductSuperSubCategories.photo AS `ProductSuperSubCategories__photo`, ProductSuperSubCategories.photo_dir AS `ProductSuperSubCategories__photo_dir`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, ProductSuperSubCategories.custom_field_1_label AS `ProductSuperSubCategories__custom_field_1_label`, ProductSuperSubCategories.custom_field_2_label AS `ProductSuperSubCategories__custom_field_2_label`, ProductSuperSubCategories.custom_field_3_label AS `ProductSuperSubCategories__custom_field_3_label`, ProductSuperSubCategories.custom_field_4_label AS `ProductSuperSubCategories__custom_field_4_label`, ProductSuperSubCategories.custom_field_5_label AS `ProductSuperSubCategories__custom_field_5_label`, Users.id AS `Users__id`, Users.username AS `Users__username`, Users.name AS `Users__name`, Users.user_type AS `Users__user_type`, Districts.id AS `Districts__id`, Districts.name AS `Districts__name`, Cities.id AS `Cities__id`, Cities.name AS `Cities__name`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value`, Brands.photo_dir AS `Brands__photo_dir`, Brands.photo AS `Brands__photo`, ProductModels.id AS `ProductModels__id`, ProductModels.name AS `ProductModels__name` FROM products Products INNER JOIN websites Websites ON Websites.id = (Products.website_id) LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN users Users ON Users.id = (Products.vendor_id) LEFT JOIN districts Districts ON Districts.id = (Products.district_id) LEFT JOIN cities Cities ON Cities.id = (Products.city_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) LEFT JOIN product_models ProductModels ON ProductModels.id = (Products.product_model_id) WHERE (Products.active = :c0 AND Products.website_id = :c1 AND (Products.product_type = :c2 OR Products.product_type = :c3 OR Products.product_type = :c4) AND Users.user_type = :c5) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 24 OFFSET 0',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ProductsTable) {}
},
'website' => object(App\Model\Entity\Website) {
'id' => (int) 182,
'website_key' => null,
'domain_name' => 'stgsite182.lakshop.lk',
'user_id' => (int) 333,
'domain_name_alias' => null,
'domain_dns_key' => 'd9a9e0d60328fb3910d527069150caafb08d256d',
'domain_verified' => (int) 1,
'email_sent_by_verified' => (int) 0,
'published' => (int) 0,
'name' => 'testcb00003',
'address' => 'testcb00003',
'email' => 'testcb00003@css.lk',
'show_email_on_website' => (int) 0,
'telephone_no' => '0765321084',
'mobile_no' => '0765321084',
'fax_no' => '',
'whatsapp_no' => null,
'latitude' => null,
'longitude' => null,
'logo' => null,
'logo_dir' => null,
'favicon' => null,
'favicon_dir' => null,
'tag_line' => null,
'facebook_link' => null,
'twitter_link' => null,
'linkedin_link' => null,
'facebook_api_key' => null,
'facebook_api_secret' => null,
'facebook_script' => null,
'facebook_div' => null,
'fb_og_url' => null,
'fb_og_type' => null,
'fb_og_title' => null,
'fb_og_description' => null,
'instagram_url' => null,
'linkedin_url' => null,
'houzz_url' => null,
'main_description' => null,
'main_image' => null,
'main_image_dir' => null,
'feature_image' => null,
'feature_image_dir' => null,
'product_bg' => null,
'product_bg_dir' => null,
'service_bg' => null,
'service_bg_dir' => null,
'portfolio_bg' => null,
'portfolio_bg_dir' => null,
'testimonial_bg' => null,
'testimonial_bg_dir' => null,
'contact_us_bg' => null,
'contact_us_bg_dir' => null,
'footer_bg' => null,
'footer_bg_dir' => null,
'main_banner_bg' => null,
'main_banner_bg_dir' => null,
'subscription_bg' => null,
'subscription_bg_dir' => null,
'theme_color' => null,
'secondary_color' => null,
'currency' => 'LKR',
'about_us_menu_name' => null,
'shop_menu_name' => null,
'about_us_heading_name' => null,
'products_menu_name' => null,
'products_heading_name' => null,
'services_menu_name' => null,
'services_heading_name' => null,
'portfolio_menu_name' => null,
'portfolio_heading_name' => null,
'testimonial_menu_name' => null,
'testimonial_heading_name' => null,
'features_menu_name' => null,
'features_heading_name' => null,
'staff_page_enabled' => (int) 0,
'staff_menu_name' => 'Staff',
'what_we_do_page_enabled' => null,
'what_we_do_page_menu_name' => 'What we do',
'how_it_works_page_enabled' => (int) 0,
'how_it_works_menu_name' => null,
'blog_menu_name' => null,
'template_id' => (int) 37,
'business_id' => (int) 8,
'login_id' => null,
'sample' => (int) 0,
'login_feature' => (int) 0,
'cart_feature' => (int) 0,
'ecom_live_mode' => (int) 0,
'pay_here_merchantid' => '',
'pay_here_merchant_secret' => '',
'product_quantity_feature' => 'SINGLE',
'service_quantity_feature' => 'SINGLE',
'min_delivery_weight' => null,
'min_delivery_price' => null,
'incremental_weight' => null,
'incremental_weight_price' => null,
'tax_rate' => null,
'max_delivery_day_count' => null,
'pick_up_location' => null,
'commission_percentage' => null,
'seller_payment_dispatch_processing_fee' => null,
'payment_processing_fee' => null,
'payment_processing_percentage' => null,
'processing_fee_application_max_value' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'created_by' => null,
'modified' => object(Cake\I18n\FrozenTime) {},
'modified_by' => null,
'force_ssl' => (int) 0,
'custom_field_1_label' => '',
'custom_field_2_label' => null,
'custom_field_3_label' => null,
'custom_field_4_label' => null,
'custom_field_5_label' => null,
'payhere_enabled' => (int) 0,
'multi_vendor_enabled' => (int) 0,
'website_type' => 'LOCAL_WEBSITE',
'payment_made' => (int) 0,
'payment_details' => null,
'auto_login_code' => '58aa5094-e49e-43a4-a601-1e2214984445',
'contact_us_top_text' => null,
'header_id' => null,
'service_id' => null,
'slider_id' => null,
'product_id' => null,
'custom_css' => null,
'custom_script' => null,
'product_title_prefix' => null,
'product_title_suffix' => null,
'contact_us_text' => null,
'show_contact_button_on_banner' => (int) 1,
'show_all_elements_in_menu' => (int) 0,
'site_wide_discount_percentage' => (float) 0,
'site_wide_discount_value' => (float) 0,
'suspended' => (int) 0,
'sms_credit_id' => null,
'check_stock_when_ordering' => (int) 1,
'min_order_value' => (float) 0,
'order_instructions' => null,
'require_customer_map_location' => (int) 0,
'require_additional_checkout_info' => (int) 0,
'require_shipping_address_info' => (int) 0,
'bank_account_details_for_orders' => 'Account Name : Account Number : Bank Name : Bank Branch :',
'shop_url' => null,
'shop_url_text' => null,
'buyer_needs_to_accept_terms' => (int) 0,
'custom_product_field_1_label' => null,
'custom_product_field_2_label' => null,
'custom_product_field_3_label' => null,
'custom_product_field_4_label' => null,
'custom_product_field_5_label' => null,
'join_us_page_enabled' => (int) 0,
'events_page_enabled' => (int) 0,
'android_app_url' => null,
'ios_app_url' => null,
'main_video_youttube_url' => null,
'app_preview_image' => null,
'app_preview_image_dir' => null,
'monthly_fee' => null,
'yearly_fee' => null,
'renewal_fee_description' => null,
'expiry_date' => object(Cake\I18n\FrozenDate) {},
'services' => [[maximum depth reached]],
'products' => [[maximum depth reached]],
'brands' => [[maximum depth reached]],
'documents' => [[maximum depth reached]],
'additional_sections' => [[maximum depth reached]],
'user' => object(App\Model\Entity\User) {},
'cart_items' => [[maximum depth reached]],
'testimonials' => [[maximum depth reached]],
'pricings' => [[maximum depth reached]],
'features' => [[maximum depth reached]],
'portfolios' => [[maximum depth reached]],
'side_banners' => [[maximum depth reached]],
'main_banners' => [[maximum depth reached]],
'payment_gateways' => [[maximum depth reached]],
'payment_services' => [[maximum depth reached]],
'template' => object(App\Model\Entity\Template) {},
'modules' => [[maximum depth reached]],
'courier_companies' => [[maximum depth reached]],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [
[maximum depth reached]
],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Websites'
},
'templateFolderPath' => 'lakshop_template_layouts/8/wonderland',
'templateCssFolderPath' => 'lakshop_template_css/8/wonderland',
'templateImgFolderPath' => 'lakshop_template_img/8/wonderland',
'templateJsFolderPath' => 'lakshop_template_js/8/wonderland',
'selectedVendorId' => null,
'clients' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Clients.id AS `Clients__id`, Clients.website_id AS `Clients__website_id`, Clients.name AS `Clients__name`, Clients.description AS `Clients__description`, Clients.photo_dir AS `Clients__photo_dir`, Clients.photo AS `Clients__photo`, Clients.created AS `Clients__created` FROM clients Clients WHERE website_id = :c0 LIMIT 60',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ClientsTable) {}
},
'districts' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Districts.id AS `Districts__id`, Districts.name AS `Districts__name` FROM districts Districts WHERE Districts.id in (:c0,:c1) ORDER BY Districts.name ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\DistrictsTable) {}
},
'productConditions' => [
'Products.active' => (int) 1,
'Products.website_id' => (int) 182,
(int) 1 => [
'OR' => [
[maximum depth reached]
]
]
],
'featuredProducts' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductCategories.name AS `ProductCategories__name`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSubCategories.name AS `ProductSubCategories__name`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value`, Websites.id AS `Websites__id`, Websites.website_type AS `Websites__website_type`, Websites.user_id AS `Websites__user_id` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) INNER JOIN websites Websites ON Websites.id = (Products.website_id) WHERE (Products.website_id = :c0 AND Products.featured_item = :c1 AND Products.active = :c2 AND (Websites.website_type != :c3 OR (Websites.website_type = :c4 AND Products.quantity > :c5))) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 50',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ProductsTable) {}
},
'bestSellingProducts' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) WHERE (Products.website_id = :c0 AND Products.best_selling_item = :c1 AND Products.active = :c2) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 5',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ProductsTable) {}
},
'newlyArrivedProducts' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) WHERE (Products.website_id = :c0 AND Products.active = :c1 AND Products.quantity > :c2 AND (Products.product_type = :c3 OR Products.product_type = :c4 OR Products.product_type = :c5)) ORDER BY Products.id DESC LIMIT 5',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ProductsTable) {}
},
'categoriesWithProducts' => [],
'productCategories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT ProductCategories.id AS `ProductCategories__id`, ProductCategories.name AS `ProductCategories__name`, ProductCategories.photo AS `ProductCategories__photo`, ProductCategories.photo_dir AS `ProductCategories__photo_dir`, ProductCategories.large_photo AS `ProductCategories__large_photo`, ProductCategories.large_photo_dir AS `ProductCategories__large_photo_dir`, ProductCategories.enabled AS `ProductCategories__enabled`, ProductCategories.show_in_home_page AS `ProductCategories__show_in_home_page`, ProductCategories.custom_field_1_label AS `ProductCategories__custom_field_1_label`, ProductCategories.custom_field_2_label AS `ProductCategories__custom_field_2_label`, ProductCategories.custom_field_3_label AS `ProductCategories__custom_field_3_label`, ProductCategories.custom_field_4_label AS `ProductCategories__custom_field_4_label`, ProductCategories.custom_field_5_label AS `ProductCategories__custom_field_5_label` FROM product_categories ProductCategories WHERE (ProductCategories.website_id = :c0 AND ProductCategories.enabled = :c1 AND ProductCategories.show_in_home_page = :c2) ORDER BY ProductCategories.sort_order DESC, ProductCategories.id DESC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ProductCategoriesTable) {}
},
'selectedProductCategoryId' => null,
'selectedProductSubCategoryId' => null,
'selectedProductSuperSubCategoryId' => null,
'selectedDistrictId' => null,
'productCategoryCustomFieldLabels' => [
'website_labels' => [
(int) 182 => [
[maximum depth reached]
]
],
'category_labels' => [],
'sub_category_labels' => [],
'super_sub_category_labels' => []
],
'viewElements' => [
(int) 1 => 'header_1',
(int) 2 => 'header_2',
(int) 3 => 'slider_1',
(int) 4 => 'slider_2',
(int) 5 => 'header_text_based_custom',
(int) 6 => 'slider_brand_model_year_form',
(int) 7 => 'login_classified'
],
'isEcommerce' => false,
'countries' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Countries.id AS `Countries__id`, Countries.name AS `Countries__name` FROM countries Countries WHERE Countries.name = :c0',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CountriesTable) {}
},
'minContentAction' => 'login',
'tabName' => null,
'deliveryAvailableDistricts' => [],
'websiteId' => (int) 182,
'poweredBy' => '<span id="powered-by-text"><span style="color:#C5C5C5;">Powered by </span><a href="https://lakshop.lk/" style="color:#fff;" target="_blank" class="powered-by-link">LakSHOP website builder</a></span>',
'websiteSettings' => object(App\Model\Entity\WebsiteSetting) {
'id' => (int) 38,
'website_id' => (int) 182,
'user_reg_sms_validation' => (int) 0,
'vendor_reg_method' => 'USERNAME',
'auto_activate_vendors' => (int) 0,
'auto_activate_customers' => (int) 1,
'auto_approve_vendors' => (int) 0,
'auto_approve_vendor_products' => (int) 0,
'pre_approve_vendors' => (int) 0,
'pre_approve_products' => (int) 0,
'vendor_bank_account_required' => (int) 1,
'buyers_can_register' => (int) 1,
'sellers_can_register' => (int) 0,
'courier_can_register' => (int) 0,
'product_based_owner_commission' => (int) 0,
'staff_members' => (int) 0,
'make_model_based_products' => (int) 1,
'show_custom_product_field_1_in_home' => (int) 0,
'show_custom_product_field_2_in_home' => (int) 0,
'show_custom_product_field_3_in_home' => (int) 0,
'single_shipping_location' => (int) 1,
'product_weight_is_important_to_show' => (int) 0,
'location_mark_type' => 'CITY',
'international_shipping' => (int) 0,
'usd_rate' => (float) 230,
'show_product_price_to_public' => (int) 1,
'customer_auto_activate' => (int) 1,
'show_order_id_qr_in_confirmation_email' => (int) 0,
'show_order_user_details_qr_in_confirmation_email' => (int) 0,
'contact_us_popup' => null,
'show_google_translate' => (int) 0,
'text_to_speech_product_desc' => (int) 0,
'show_lakshop_branding' => (int) 1,
'product_img_watermark_opacity' => null,
'subscriptions_enable' => (int) 0,
'append_blog_in_content_min' => (int) 0,
'append_gallery_in_content_min' => (int) 0,
'append_subscription_box_in_content_min' => (int) 0,
'append_featured_products_in_content_min' => (int) 0,
'show_sl_map_in_home' => (int) 0,
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'WebsiteSettings'
},
'loggedUserId' => null,
'loggedUserType' => null
]
$websiteBrands = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.photo AS `Brands__photo`, Brands.photo_dir AS `Brands__photo_dir`, Brands.website_id AS `Brands__website_id`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM brands Brands WHERE (Brands.website_id = :c0 AND Brands.id in (:c1,:c2)) ORDER BY Brands.name ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'biginteger',
'Brands.id' => 'biginteger',
'id' => 'biginteger',
'Brands__name' => 'string',
'Brands.name' => 'string',
'name' => 'string',
'Brands__photo' => 'proffer.file',
'Brands.photo' => 'proffer.file',
'photo' => 'proffer.file',
'Brands__photo_dir' => 'string',
'Brands.photo_dir' => 'string',
'photo_dir' => 'string',
'Brands__website_id' => 'biginteger',
'Brands.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Brands__discount_percentage' => 'decimal',
'Brands.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'Brands__discount_value' => 'decimal',
'Brands.discount_value' => 'decimal',
'discount_value' => 'decimal',
'ProductModels__id' => 'biginteger',
'ProductModels.id' => 'biginteger',
'ProductModels__brand_id' => 'biginteger',
'ProductModels.brand_id' => 'biginteger',
'brand_id' => 'biginteger',
'ProductModels__name' => 'string',
'ProductModels.name' => 'string',
'ProductModels__website_id' => 'biginteger',
'ProductModels.website_id' => 'biginteger'
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'ProductModels' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$websiteBrandList = []
$searchQuery = null
$lastProductId = null
$products = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.featured_item AS `Products__featured_item`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.price AS `Products__price`, Products.quantity AS `Products__quantity`, Products.vendor_id AS `Products__vendor_id`, Products.weight AS `Products__weight`, Products.volume AS `Products__volume`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.stock_available AS `Products__stock_available`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.product_type AS `Products__product_type`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.free_delivery AS `Products__free_delivery`, Products.active AS `Products__active`, Products.created AS `Products__created`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.private_info AS `Products__private_info`, Products.discount_value AS `Products__discount_value`, Products.discount_percentage AS `Products__discount_percentage`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.currency AS `Products__currency`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, Websites.id AS `Websites__id`, Websites.user_id AS `Websites__user_id`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.name AS `ProductCategories__name`, ProductCategories.photo AS `ProductCategories__photo`, ProductCategories.photo_dir AS `ProductCategories__photo_dir`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductCategories.custom_field_1_label AS `ProductCategories__custom_field_1_label`, ProductCategories.custom_field_2_label AS `ProductCategories__custom_field_2_label`, ProductCategories.custom_field_3_label AS `ProductCategories__custom_field_3_label`, ProductCategories.custom_field_4_label AS `ProductCategories__custom_field_4_label`, ProductCategories.custom_field_5_label AS `ProductCategories__custom_field_5_label`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.name AS `ProductSubCategories__name`, ProductSubCategories.product_category_id AS `ProductSubCategories__product_category_id`, ProductSubCategories.photo AS `ProductSubCategories__photo`, ProductSubCategories.photo_dir AS `ProductSubCategories__photo_dir`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSubCategories.custom_field_1_label AS `ProductSubCategories__custom_field_1_label`, ProductSubCategories.custom_field_2_label AS `ProductSubCategories__custom_field_2_label`, ProductSubCategories.custom_field_3_label AS `ProductSubCategories__custom_field_3_label`, ProductSubCategories.custom_field_4_label AS `ProductSubCategories__custom_field_4_label`, ProductSubCategories.custom_field_5_label AS `ProductSubCategories__custom_field_5_label`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.name AS `ProductSuperSubCategories__name`, ProductSuperSubCategories.product_sub_category_id AS `ProductSuperSubCategories__product_sub_category_id`, ProductSuperSubCategories.photo AS `ProductSuperSubCategories__photo`, ProductSuperSubCategories.photo_dir AS `ProductSuperSubCategories__photo_dir`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, ProductSuperSubCategories.custom_field_1_label AS `ProductSuperSubCategories__custom_field_1_label`, ProductSuperSubCategories.custom_field_2_label AS `ProductSuperSubCategories__custom_field_2_label`, ProductSuperSubCategories.custom_field_3_label AS `ProductSuperSubCategories__custom_field_3_label`, ProductSuperSubCategories.custom_field_4_label AS `ProductSuperSubCategories__custom_field_4_label`, ProductSuperSubCategories.custom_field_5_label AS `ProductSuperSubCategories__custom_field_5_label`, Users.id AS `Users__id`, Users.username AS `Users__username`, Users.name AS `Users__name`, Users.user_type AS `Users__user_type`, Districts.id AS `Districts__id`, Districts.name AS `Districts__name`, Cities.id AS `Cities__id`, Cities.name AS `Cities__name`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value`, Brands.photo_dir AS `Brands__photo_dir`, Brands.photo AS `Brands__photo`, ProductModels.id AS `ProductModels__id`, ProductModels.name AS `ProductModels__name` FROM products Products INNER JOIN websites Websites ON Websites.id = (Products.website_id) LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN users Users ON Users.id = (Products.vendor_id) LEFT JOIN districts Districts ON Districts.id = (Products.district_id) LEFT JOIN cities Cities ON Cities.id = (Products.city_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) LEFT JOIN product_models ProductModels ON ProductModels.id = (Products.product_model_id) WHERE (Products.active = :c0 AND Products.website_id = :c1 AND (Products.product_type = :c2 OR Products.product_type = :c3 OR Products.product_type = :c4) AND Users.user_type = :c5) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 24 OFFSET 0',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Products__id' => 'biginteger',
'Products.id' => 'biginteger',
'id' => 'biginteger',
'Products__sku' => 'string',
'Products.sku' => 'string',
'sku' => 'string',
'Products__name' => 'string',
'Products.name' => 'string',
'name' => 'string',
'Products__price' => 'decimal',
'Products.price' => 'decimal',
'price' => 'decimal',
'Products__bought_price' => 'decimal',
'Products.bought_price' => 'decimal',
'bought_price' => 'decimal',
'Products__discount_percentage' => 'decimal',
'Products.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'Products__discount_value' => 'decimal',
'Products.discount_value' => 'decimal',
'discount_value' => 'decimal',
'Products__description' => 'text',
'Products.description' => 'text',
'description' => 'text',
'Products__brand_id' => 'biginteger',
'Products.brand_id' => 'biginteger',
'brand_id' => 'biginteger',
'Products__product_model_id' => 'biginteger',
'Products.product_model_id' => 'biginteger',
'product_model_id' => 'biginteger',
'Products__product_year' => 'integer',
'Products.product_year' => 'integer',
'product_year' => 'integer',
'Products__product_category_id' => 'biginteger',
'Products.product_category_id' => 'biginteger',
'product_category_id' => 'biginteger',
'Products__product_sub_category_id' => 'biginteger',
'Products.product_sub_category_id' => 'biginteger',
'product_sub_category_id' => 'biginteger',
'Products__product_super_sub_category_id' => 'biginteger',
'Products.product_super_sub_category_id' => 'biginteger',
'product_super_sub_category_id' => 'biginteger',
'Products__quantity' => 'integer',
'Products.quantity' => 'integer',
'quantity' => 'integer',
'Products__website_id' => 'biginteger',
'Products.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Products__vendor_id' => 'biginteger',
'Products.vendor_id' => 'biginteger',
'vendor_id' => 'biginteger',
'Products__vendor_item_approved' => 'tinyinteger',
'Products.vendor_item_approved' => 'tinyinteger',
'vendor_item_approved' => 'tinyinteger',
'Products__vendor_item_pre_approved' => 'tinyinteger',
'Products.vendor_item_pre_approved' => 'tinyinteger',
'vendor_item_pre_approved' => 'tinyinteger',
'Products__vendor_item_pre_approve_user_id' => 'biginteger',
'Products.vendor_item_pre_approve_user_id' => 'biginteger',
'vendor_item_pre_approve_user_id' => 'biginteger',
'Products__vendor_item_pre_approve_datetime' => 'datetime',
'Products.vendor_item_pre_approve_datetime' => 'datetime',
'vendor_item_pre_approve_datetime' => 'datetime',
'Products__featured_item' => 'tinyinteger',
'Products.featured_item' => 'tinyinteger',
'featured_item' => 'tinyinteger',
'Products__best_selling_item' => 'tinyinteger',
'Products.best_selling_item' => 'tinyinteger',
'best_selling_item' => 'tinyinteger',
'Products__delivery_method' => 'string',
'Products.delivery_method' => 'string',
'delivery_method' => 'string',
'Products__pickup' => 'tinyinteger',
'Products.pickup' => 'tinyinteger',
'pickup' => 'tinyinteger',
'Products__deliver' => 'tinyinteger',
'Products.deliver' => 'tinyinteger',
'deliver' => 'tinyinteger',
'Products__weight' => 'decimal',
'Products.weight' => 'decimal',
'weight' => 'decimal',
'Products__sort_order' => 'integer',
'Products.sort_order' => 'integer',
'sort_order' => 'integer',
'Products__free_delivery' => 'tinyinteger',
'Products.free_delivery' => 'tinyinteger',
'free_delivery' => 'tinyinteger',
'Products__free_international_delivery' => 'tinyinteger',
'Products.free_international_delivery' => 'tinyinteger',
'free_international_delivery' => 'tinyinteger',
'Products__stock_available' => 'tinyinteger',
'Products.stock_available' => 'tinyinteger',
'stock_available' => 'tinyinteger',
'Products__product_type' => 'string',
'Products.product_type' => 'string',
'product_type' => 'string',
'Products__parent_product_id' => 'biginteger',
'Products.parent_product_id' => 'biginteger',
'parent_product_id' => 'biginteger',
'Products__attr_color_id' => 'biginteger',
'Products.attr_color_id' => 'biginteger',
'attr_color_id' => 'biginteger',
'Products__attr_size_id' => 'biginteger',
'Products.attr_size_id' => 'biginteger',
'attr_size_id' => 'biginteger',
'Products__attr_material_id' => 'biginteger',
'Products.attr_material_id' => 'biginteger',
'attr_material_id' => 'biginteger',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__created_by' => 'biginteger',
'Products.created_by' => 'biginteger',
'created_by' => 'biginteger',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__modified_by' => 'biginteger',
'Products.modified_by' => 'biginteger',
'modified_by' => 'biginteger',
'Products__add_to_cart_text' => 'string',
'Products.add_to_cart_text' => 'string',
'add_to_cart_text' => 'string',
'Products__out_of_stock_text' => 'string',
'Products.out_of_stock_text' => 'string',
'out_of_stock_text' => 'string',
'Products__length' => 'decimal',
'Products.length' => 'decimal',
'length' => 'decimal',
'Products__width' => 'decimal',
'Products.width' => 'decimal',
'width' => 'decimal',
'Products__height' => 'decimal',
'Products.height' => 'decimal',
'height' => 'decimal',
'Products__volume' => 'string',
'Products.volume' => 'string',
'volume' => 'string',
'Products__active' => 'tinyinteger',
'Products.active' => 'tinyinteger',
'active' => 'tinyinteger',
'Products__custom_product_field_1_value' => 'string',
'Products.custom_product_field_1_value' => 'string',
'custom_product_field_1_value' => 'string',
'Products__custom_product_field_2_value' => 'string',
'Products.custom_product_field_2_value' => 'string',
'custom_product_field_2_value' => 'string',
'Products__custom_product_field_3_value' => 'string',
'Products.custom_product_field_3_value' => 'string',
'custom_product_field_3_value' => 'string',
'Products__custom_product_field_4_value' => 'string',
'Products.custom_product_field_4_value' => 'string',
'custom_product_field_4_value' => 'string',
'Products__custom_product_field_5_value' => 'string',
'Products.custom_product_field_5_value' => 'string',
'custom_product_field_5_value' => 'string',
'Products__district_id' => 'biginteger',
'Products.district_id' => 'biginteger',
'district_id' => 'biginteger',
'Products__city_id' => 'biginteger',
'Products.city_id' => 'biginteger',
'city_id' => 'biginteger',
'Products__shop_owner_commission_percentage' => 'decimal',
'Products.shop_owner_commission_percentage' => 'decimal',
'shop_owner_commission_percentage' => 'decimal',
'Products__website_price' => 'decimal',
'Products.website_price' => 'decimal',
'website_price' => 'decimal',
'Products__currency' => 'string',
'Products.currency' => 'string',
'currency' => 'string',
'Products__private_info' => 'text',
'Products.private_info' => 'text',
'private_info' => 'text',
'Products__attached_file' => 'proffer.file',
'Products.attached_file' => 'proffer.file',
'attached_file' => 'proffer.file',
'Products__attached_file_dir' => 'string',
'Products.attached_file_dir' => 'string',
'attached_file_dir' => 'string',
'Products__attached_file2' => 'proffer.file',
'Products.attached_file2' => 'proffer.file',
'attached_file2' => 'proffer.file',
'Products__attached_file_dir2' => 'string',
'Products.attached_file_dir2' => 'string',
'attached_file_dir2' => 'string',
'Products__size_chart' => 'proffer.file',
'Products.size_chart' => 'proffer.file',
'size_chart' => 'proffer.file',
'Products__size_chart_dir' => 'string',
'Products.size_chart_dir' => 'string',
'size_chart_dir' => 'string',
'Products__seo_url' => 'string',
'Products.seo_url' => 'string',
'seo_url' => 'string',
'Products__contact_name' => 'string',
'Products.contact_name' => 'string',
'contact_name' => 'string',
'Products__contact_mobile' => 'string',
'Products.contact_mobile' => 'string',
'contact_mobile' => 'string',
'Products__contact_whatsapp' => 'string',
'Products.contact_whatsapp' => 'string',
'contact_whatsapp' => 'string',
'Products__view_count' => 'biginteger',
'Products.view_count' => 'biginteger',
'view_count' => 'biginteger',
'Websites__id' => 'biginteger',
'Websites.id' => 'biginteger',
'Websites__website_key' => 'string',
'Websites.website_key' => 'string',
'website_key' => 'string',
'Websites__domain_name' => 'string',
'Websites.domain_name' => 'string',
'domain_name' => 'string',
'Websites__user_id' => 'biginteger',
'Websites.user_id' => 'biginteger',
'user_id' => 'biginteger',
'Websites__domain_name_alias' => 'string',
'Websites.domain_name_alias' => 'string',
'domain_name_alias' => 'string',
'Websites__domain_dns_key' => 'string',
'Websites.domain_dns_key' => 'string',
'domain_dns_key' => 'string',
'Websites__domain_verified' => 'tinyinteger',
'Websites.domain_verified' => 'tinyinteger',
'domain_verified' => 'tinyinteger',
'Websites__email_sent_by_verified' => 'tinyinteger',
'Websites.email_sent_by_verified' => 'tinyinteger',
'email_sent_by_verified' => 'tinyinteger',
'Websites__published' => 'tinyinteger',
'Websites.published' => 'tinyinteger',
'published' => 'tinyinteger',
'Websites__name' => 'string',
'Websites.name' => 'string',
'Websites__address' => 'text',
'Websites.address' => 'text',
'address' => 'text',
'Websites__email' => 'string',
'Websites.email' => 'string',
'email' => 'string',
'Websites__show_email_on_website' => 'tinyinteger',
'Websites.show_email_on_website' => 'tinyinteger',
'show_email_on_website' => 'tinyinteger',
'Websites__telephone_no' => 'string',
'Websites.telephone_no' => 'string',
'telephone_no' => 'string',
'Websites__mobile_no' => 'string',
'Websites.mobile_no' => 'string',
'mobile_no' => 'string',
'Websites__fax_no' => 'string',
'Websites.fax_no' => 'string',
'fax_no' => 'string',
'Websites__whatsapp_no' => 'string',
'Websites.whatsapp_no' => 'string',
'whatsapp_no' => 'string',
'Websites__latitude' => 'float',
'Websites.latitude' => 'float',
'latitude' => 'float',
'Websites__longitude' => 'float',
'Websites.longitude' => 'float',
'longitude' => 'float',
'Websites__logo' => 'proffer.file',
'Websites.logo' => 'proffer.file',
'logo' => 'proffer.file',
'Websites__logo_dir' => 'string',
'Websites.logo_dir' => 'string',
'logo_dir' => 'string',
'Websites__favicon' => 'proffer.file',
'Websites.favicon' => 'proffer.file',
'favicon' => 'proffer.file',
'Websites__favicon_dir' => 'string',
'Websites.favicon_dir' => 'string',
'favicon_dir' => 'string',
'Websites__tag_line' => 'string',
'Websites.tag_line' => 'string',
'tag_line' => 'string',
'Websites__facebook_link' => 'string',
'Websites.facebook_link' => 'string',
'facebook_link' => 'string',
'Websites__twitter_link' => 'string',
'Websites.twitter_link' => 'string',
'twitter_link' => 'string',
'Websites__linkedin_link' => 'string',
'Websites.linkedin_link' => 'string',
'linkedin_link' => 'string',
'Websites__facebook_api_key' => 'string',
'Websites.facebook_api_key' => 'string',
'facebook_api_key' => 'string',
'Websites__facebook_api_secret' => 'string',
'Websites.facebook_api_secret' => 'string',
'facebook_api_secret' => 'string',
'Websites__facebook_script' => 'string',
'Websites.facebook_script' => 'string',
'facebook_script' => 'string',
'Websites__facebook_div' => 'string',
'Websites.facebook_div' => 'string',
'facebook_div' => 'string',
'Websites__fb_og_url' => 'string',
'Websites.fb_og_url' => 'string',
'fb_og_url' => 'string',
'Websites__fb_og_type' => 'string',
'Websites.fb_og_type' => 'string',
'fb_og_type' => 'string',
'Websites__fb_og_title' => 'string',
'Websites.fb_og_title' => 'string',
'fb_og_title' => 'string',
'Websites__fb_og_description' => 'string',
'Websites.fb_og_description' => 'string',
'fb_og_description' => 'string',
'Websites__instagram_url' => 'string',
'Websites.instagram_url' => 'string',
'instagram_url' => 'string',
'Websites__linkedin_url' => 'string',
'Websites.linkedin_url' => 'string',
'linkedin_url' => 'string',
'Websites__houzz_url' => 'string',
'Websites.houzz_url' => 'string',
'houzz_url' => 'string',
'Websites__main_description' => 'text',
'Websites.main_description' => 'text',
'main_description' => 'text',
'Websites__main_image' => 'proffer.file',
'Websites.main_image' => 'proffer.file',
'main_image' => 'proffer.file',
'Websites__main_image_dir' => 'string',
'Websites.main_image_dir' => 'string',
'main_image_dir' => 'string',
'Websites__feature_image' => 'proffer.file',
'Websites.feature_image' => 'proffer.file',
'feature_image' => 'proffer.file',
'Websites__feature_image_dir' => 'string',
'Websites.feature_image_dir' => 'string',
'feature_image_dir' => 'string',
'Websites__product_bg' => 'proffer.file',
'Websites.product_bg' => 'proffer.file',
'product_bg' => 'proffer.file',
'Websites__product_bg_dir' => 'string',
'Websites.product_bg_dir' => 'string',
'product_bg_dir' => 'string',
'Websites__service_bg' => 'proffer.file',
'Websites.service_bg' => 'proffer.file',
'service_bg' => 'proffer.file',
'Websites__service_bg_dir' => 'string',
'Websites.service_bg_dir' => 'string',
'service_bg_dir' => 'string',
'Websites__portfolio_bg' => 'proffer.file',
'Websites.portfolio_bg' => 'proffer.file',
'portfolio_bg' => 'proffer.file',
'Websites__portfolio_bg_dir' => 'string',
'Websites.portfolio_bg_dir' => 'string',
'portfolio_bg_dir' => 'string',
'Websites__testimonial_bg' => 'proffer.file',
'Websites.testimonial_bg' => 'proffer.file',
'testimonial_bg' => 'proffer.file',
'Websites__testimonial_bg_dir' => 'string',
'Websites.testimonial_bg_dir' => 'string',
'testimonial_bg_dir' => 'string',
'Websites__contact_us_bg' => 'proffer.file',
'Websites.contact_us_bg' => 'proffer.file',
'contact_us_bg' => 'proffer.file',
'Websites__contact_us_bg_dir' => 'string',
'Websites.contact_us_bg_dir' => 'string',
'contact_us_bg_dir' => 'string',
'Websites__footer_bg' => 'proffer.file',
'Websites.footer_bg' => 'proffer.file',
'footer_bg' => 'proffer.file',
'Websites__footer_bg_dir' => 'string',
'Websites.footer_bg_dir' => 'string',
'footer_bg_dir' => 'string',
'Websites__main_banner_bg' => 'proffer.file',
'Websites.main_banner_bg' => 'proffer.file',
'main_banner_bg' => 'proffer.file',
'Websites__main_banner_bg_dir' => 'string',
'Websites.main_banner_bg_dir' => 'string',
'main_banner_bg_dir' => 'string',
'Websites__subscription_bg' => 'string',
'Websites.subscription_bg' => 'string',
'subscription_bg' => 'string',
'Websites__subscription_bg_dir' => 'string',
'Websites.subscription_bg_dir' => 'string',
'subscription_bg_dir' => 'string',
'Websites__theme_color' => 'string',
'Websites.theme_color' => 'string',
'theme_color' => 'string',
'Websites__secondary_color' => 'string',
'Websites.secondary_color' => 'string',
'secondary_color' => 'string',
'Websites__currency' => 'string',
'Websites.currency' => 'string',
'Websites__about_us_menu_name' => 'string',
'Websites.about_us_menu_name' => 'string',
'about_us_menu_name' => 'string',
'Websites__shop_menu_name' => 'string',
'Websites.shop_menu_name' => 'string',
'shop_menu_name' => 'string',
'Websites__about_us_heading_name' => 'string',
'Websites.about_us_heading_name' => 'string',
'about_us_heading_name' => 'string',
'Websites__products_menu_name' => 'string',
'Websites.products_menu_name' => 'string',
'products_menu_name' => 'string',
'Websites__products_heading_name' => 'string',
'Websites.products_heading_name' => 'string',
'products_heading_name' => 'string',
'Websites__services_menu_name' => 'string',
'Websites.services_menu_name' => 'string',
'services_menu_name' => 'string',
'Websites__services_heading_name' => 'string',
'Websites.services_heading_name' => 'string',
'services_heading_name' => 'string',
'Websites__portfolio_menu_name' => 'string',
'Websites.portfolio_menu_name' => 'string',
'portfolio_menu_name' => 'string',
'Websites__portfolio_heading_name' => 'string',
'Websites.portfolio_heading_name' => 'string',
'portfolio_heading_name' => 'string',
'Websites__testimonial_menu_name' => 'string',
'Websites.testimonial_menu_name' => 'string',
'testimonial_menu_name' => 'string',
'Websites__testimonial_heading_name' => 'string',
'Websites.testimonial_heading_name' => 'string',
'testimonial_heading_name' => 'string',
'Websites__features_menu_name' => 'string',
'Websites.features_menu_name' => 'string',
'features_menu_name' => 'string',
'Websites__features_heading_name' => 'string',
'Websites.features_heading_name' => 'string',
'features_heading_name' => 'string',
'Websites__staff_page_enabled' => 'tinyinteger',
'Websites.staff_page_enabled' => 'tinyinteger',
'staff_page_enabled' => 'tinyinteger',
'Websites__staff_menu_name' => 'string',
'Websites.staff_menu_name' => 'string',
'staff_menu_name' => 'string',
'Websites__what_we_do_page_enabled' => 'tinyinteger',
'Websites.what_we_do_page_enabled' => 'tinyinteger',
'what_we_do_page_enabled' => 'tinyinteger',
'Websites__what_we_do_page_menu_name' => 'string',
'Websites.what_we_do_page_menu_name' => 'string',
'what_we_do_page_menu_name' => 'string',
'Websites__how_it_works_page_enabled' => 'tinyinteger',
'Websites.how_it_works_page_enabled' => 'tinyinteger',
'how_it_works_page_enabled' => 'tinyinteger',
'Websites__how_it_works_menu_name' => 'string',
'Websites.how_it_works_menu_name' => 'string',
'how_it_works_menu_name' => 'string',
'Websites__blog_menu_name' => 'string',
'Websites.blog_menu_name' => 'string',
'blog_menu_name' => 'string',
'Websites__template_id' => 'biginteger',
'Websites.template_id' => 'biginteger',
'template_id' => 'biginteger',
'Websites__business_id' => 'biginteger',
'Websites.business_id' => 'biginteger',
'business_id' => 'biginteger',
'Websites__login_id' => 'biginteger',
'Websites.login_id' => 'biginteger',
'login_id' => 'biginteger',
'Websites__sample' => 'tinyinteger',
'Websites.sample' => 'tinyinteger',
'sample' => 'tinyinteger',
'Websites__login_feature' => 'tinyinteger',
'Websites.login_feature' => 'tinyinteger',
'login_feature' => 'tinyinteger',
'Websites__cart_feature' => 'tinyinteger',
'Websites.cart_feature' => 'tinyinteger',
'cart_feature' => 'tinyinteger',
'Websites__ecom_live_mode' => 'tinyinteger',
'Websites.ecom_live_mode' => 'tinyinteger',
'ecom_live_mode' => 'tinyinteger',
'Websites__pay_here_merchantid' => 'string',
'Websites.pay_here_merchantid' => 'string',
'pay_here_merchantid' => 'string',
'Websites__pay_here_merchant_secret' => 'string',
'Websites.pay_here_merchant_secret' => 'string',
'pay_here_merchant_secret' => 'string',
'Websites__product_quantity_feature' => 'string',
'Websites.product_quantity_feature' => 'string',
'product_quantity_feature' => 'string',
'Websites__service_quantity_feature' => 'string',
'Websites.service_quantity_feature' => 'string',
'service_quantity_feature' => 'string',
'Websites__min_delivery_weight' => 'decimal',
'Websites.min_delivery_weight' => 'decimal',
'min_delivery_weight' => 'decimal',
'Websites__min_delivery_price' => 'decimal',
'Websites.min_delivery_price' => 'decimal',
'min_delivery_price' => 'decimal',
'Websites__incremental_weight' => 'decimal',
'Websites.incremental_weight' => 'decimal',
'incremental_weight' => 'decimal',
'Websites__incremental_weight_price' => 'decimal',
'Websites.incremental_weight_price' => 'decimal',
'incremental_weight_price' => 'decimal',
'Websites__tax_rate' => 'decimal',
'Websites.tax_rate' => 'decimal',
'tax_rate' => 'decimal',
'Websites__max_delivery_day_count' => 'integer',
'Websites.max_delivery_day_count' => 'integer',
'max_delivery_day_count' => 'integer',
'Websites__pick_up_location' => 'text',
'Websites.pick_up_location' => 'text',
'pick_up_location' => 'text',
'Websites__commission_percentage' => 'decimal',
'Websites.commission_percentage' => 'decimal',
'commission_percentage' => 'decimal',
'Websites__seller_payment_dispatch_processing_fee' => 'decimal',
'Websites.seller_payment_dispatch_processing_fee' => 'decimal',
'seller_payment_dispatch_processing_fee' => 'decimal',
'Websites__payment_processing_fee' => 'decimal',
'Websites.payment_processing_fee' => 'decimal',
'payment_processing_fee' => 'decimal',
'Websites__payment_processing_percentage' => 'decimal',
'Websites.payment_processing_percentage' => 'decimal',
'payment_processing_percentage' => 'decimal',
'Websites__processing_fee_application_max_value' => 'decimal',
'Websites.processing_fee_application_max_value' => 'decimal',
'processing_fee_application_max_value' => 'decimal',
'Websites__created' => 'datetime',
'Websites.created' => 'datetime',
'Websites__created_by' => 'biginteger',
'Websites.created_by' => 'biginteger',
'Websites__modified' => 'datetime',
'Websites.modified' => 'datetime',
'Websites__modified_by' => 'biginteger',
'Websites.modified_by' => 'biginteger',
'Websites__force_ssl' => 'tinyinteger',
'Websites.force_ssl' => 'tinyinteger',
'force_ssl' => 'tinyinteger',
'Websites__custom_field_1_label' => 'string',
'Websites.custom_field_1_label' => 'string',
'custom_field_1_label' => 'string',
'Websites__custom_field_2_label' => 'string',
'Websites.custom_field_2_label' => 'string',
'custom_field_2_label' => 'string',
'Websites__custom_field_3_label' => 'string',
'Websites.custom_field_3_label' => 'string',
'custom_field_3_label' => 'string',
'Websites__custom_field_4_label' => 'string',
'Websites.custom_field_4_label' => 'string',
'custom_field_4_label' => 'string',
'Websites__custom_field_5_label' => 'string',
'Websites.custom_field_5_label' => 'string',
'custom_field_5_label' => 'string',
'Websites__payhere_enabled' => 'tinyinteger',
'Websites.payhere_enabled' => 'tinyinteger',
'payhere_enabled' => 'tinyinteger',
'Websites__multi_vendor_enabled' => 'tinyinteger',
'Websites.multi_vendor_enabled' => 'tinyinteger',
'multi_vendor_enabled' => 'tinyinteger',
'Websites__website_type' => 'string',
'Websites.website_type' => 'string',
'website_type' => 'string',
'Websites__payment_made' => 'tinyinteger',
'Websites.payment_made' => 'tinyinteger',
'payment_made' => 'tinyinteger',
'Websites__payment_details' => 'text',
'Websites.payment_details' => 'text',
'payment_details' => 'text',
'Websites__auto_login_code' => 'string',
'Websites.auto_login_code' => 'string',
'auto_login_code' => 'string',
'Websites__contact_us_top_text' => 'string',
'Websites.contact_us_top_text' => 'string',
'contact_us_top_text' => 'string',
'Websites__header_id' => 'biginteger',
'Websites.header_id' => 'biginteger',
'header_id' => 'biginteger',
'Websites__service_id' => 'biginteger',
'Websites.service_id' => 'biginteger',
'service_id' => 'biginteger',
'Websites__slider_id' => 'biginteger',
'Websites.slider_id' => 'biginteger',
'slider_id' => 'biginteger',
'Websites__product_id' => 'biginteger',
'Websites.product_id' => 'biginteger',
'product_id' => 'biginteger',
'Websites__custom_css' => 'text',
'Websites.custom_css' => 'text',
'custom_css' => 'text',
'Websites__custom_script' => 'text',
'Websites.custom_script' => 'text',
'custom_script' => 'text',
'Websites__product_title_prefix' => 'string',
'Websites.product_title_prefix' => 'string',
'product_title_prefix' => 'string',
'Websites__product_title_suffix' => 'string',
'Websites.product_title_suffix' => 'string',
'product_title_suffix' => 'string',
'Websites__contact_us_text' => 'string',
'Websites.contact_us_text' => 'string',
'contact_us_text' => 'string',
'Websites__show_contact_button_on_banner' => 'tinyinteger',
'Websites.show_contact_button_on_banner' => 'tinyinteger',
'show_contact_button_on_banner' => 'tinyinteger',
'Websites__show_all_elements_in_menu' => 'tinyinteger',
'Websites.show_all_elements_in_menu' => 'tinyinteger',
'show_all_elements_in_menu' => 'tinyinteger',
'Websites__site_wide_discount_percentage' => 'decimal',
'Websites.site_wide_discount_percentage' => 'decimal',
'site_wide_discount_percentage' => 'decimal',
'Websites__site_wide_discount_value' => 'decimal',
'Websites.site_wide_discount_value' => 'decimal',
'site_wide_discount_value' => 'decimal',
'Websites__suspended' => 'tinyinteger',
'Websites.suspended' => 'tinyinteger',
'suspended' => 'tinyinteger',
'Websites__sms_credit_id' => 'biginteger',
'Websites.sms_credit_id' => 'biginteger',
'sms_credit_id' => 'biginteger',
'Websites__check_stock_when_ordering' => 'tinyinteger',
'Websites.check_stock_when_ordering' => 'tinyinteger',
'check_stock_when_ordering' => 'tinyinteger',
'Websites__min_order_value' => 'decimal',
'Websites.min_order_value' => 'decimal',
'min_order_value' => 'decimal',
'Websites__order_instructions' => 'string',
'Websites.order_instructions' => 'string',
'order_instructions' => 'string',
'Websites__require_customer_map_location' => 'tinyinteger',
'Websites.require_customer_map_location' => 'tinyinteger',
'require_customer_map_location' => 'tinyinteger',
'Websites__require_additional_checkout_info' => 'tinyinteger',
'Websites.require_additional_checkout_info' => 'tinyinteger',
'require_additional_checkout_info' => 'tinyinteger',
'Websites__require_shipping_address_info' => 'tinyinteger',
'Websites.require_shipping_address_info' => 'tinyinteger',
'require_shipping_address_info' => 'tinyinteger',
'Websites__bank_account_details_for_orders' => 'string',
'Websites.bank_account_details_for_orders' => 'string',
'bank_account_details_for_orders' => 'string',
'Websites__shop_url' => 'string',
'Websites.shop_url' => 'string',
'shop_url' => 'string',
'Websites__shop_url_text' => 'string',
'Websites.shop_url_text' => 'string',
'shop_url_text' => 'string',
'Websites__buyer_needs_to_accept_terms' => 'tinyinteger',
'Websites.buyer_needs_to_accept_terms' => 'tinyinteger',
'buyer_needs_to_accept_terms' => 'tinyinteger',
'Websites__custom_product_field_1_label' => 'string',
'Websites.custom_product_field_1_label' => 'string',
'custom_product_field_1_label' => 'string',
'Websites__custom_product_field_2_label' => 'string',
'Websites.custom_product_field_2_label' => 'string',
'custom_product_field_2_label' => 'string',
'Websites__custom_product_field_3_label' => 'string',
'Websites.custom_product_field_3_label' => 'string',
'custom_product_field_3_label' => 'string',
'Websites__custom_product_field_4_label' => 'string',
'Websites.custom_product_field_4_label' => 'string',
'custom_product_field_4_label' => 'string',
'Websites__custom_product_field_5_label' => 'string',
'Websites.custom_product_field_5_label' => 'string',
'custom_product_field_5_label' => 'string',
'Websites__join_us_page_enabled' => 'tinyinteger',
'Websites.join_us_page_enabled' => 'tinyinteger',
'join_us_page_enabled' => 'tinyinteger',
'Websites__events_page_enabled' => 'tinyinteger',
'Websites.events_page_enabled' => 'tinyinteger',
'events_page_enabled' => 'tinyinteger',
'Websites__android_app_url' => 'string',
'Websites.android_app_url' => 'string',
'android_app_url' => 'string',
'Websites__ios_app_url' => 'string',
'Websites.ios_app_url' => 'string',
'ios_app_url' => 'string',
'Websites__main_video_youttube_url' => 'string',
'Websites.main_video_youttube_url' => 'string',
'main_video_youttube_url' => 'string',
'Websites__app_preview_image' => 'proffer.file',
'Websites.app_preview_image' => 'proffer.file',
'app_preview_image' => 'proffer.file',
'Websites__app_preview_image_dir' => 'string',
'Websites.app_preview_image_dir' => 'string',
'app_preview_image_dir' => 'string',
'Websites__monthly_fee' => 'decimal',
'Websites.monthly_fee' => 'decimal',
'monthly_fee' => 'decimal',
'Websites__yearly_fee' => 'decimal',
'Websites.yearly_fee' => 'decimal',
'yearly_fee' => 'decimal',
'Websites__renewal_fee_description' => 'text',
'Websites.renewal_fee_description' => 'text',
'renewal_fee_description' => 'text',
'Websites__expiry_date' => 'date',
'Websites.expiry_date' => 'date',
'expiry_date' => 'date',
'ProductCategories__id' => 'biginteger',
'ProductCategories.id' => 'biginteger',
'ProductCategories__name' => 'string',
'ProductCategories.name' => 'string',
'ProductCategories__photo' => 'proffer.file',
'ProductCategories.photo' => 'proffer.file',
'photo' => 'proffer.file',
'ProductCategories__photo_dir' => 'string',
'ProductCategories.photo_dir' => 'string',
'photo_dir' => 'string',
'ProductCategories__large_photo' => 'proffer.file',
'ProductCategories.large_photo' => 'proffer.file',
'large_photo' => 'proffer.file',
'ProductCategories__large_photo_dir' => 'string',
'ProductCategories.large_photo_dir' => 'string',
'large_photo_dir' => 'string',
'ProductCategories__discount_percentage' => 'decimal',
'ProductCategories.discount_percentage' => 'decimal',
'ProductCategories__discount_value' => 'decimal',
'ProductCategories.discount_value' => 'decimal',
'ProductCategories__website_id' => 'biginteger',
'ProductCategories.website_id' => 'biginteger',
'ProductCategories__created' => 'datetime',
'ProductCategories.created' => 'datetime',
'ProductCategories__created_by' => 'biginteger',
'ProductCategories.created_by' => 'biginteger',
'ProductCategories__modified' => 'datetime',
'ProductCategories.modified' => 'datetime',
'ProductCategories__modified_by' => 'biginteger',
'ProductCategories.modified_by' => 'biginteger',
'ProductCategories__sort_order' => 'integer',
'ProductCategories.sort_order' => 'integer',
'ProductCategories__enabled' => 'integer',
'ProductCategories.enabled' => 'integer',
'enabled' => 'integer',
'ProductCategories__show_in_home_page' => 'integer',
'ProductCategories.show_in_home_page' => 'integer',
'show_in_home_page' => 'integer',
'ProductCategories__custom_field_1_label' => 'string',
'ProductCategories.custom_field_1_label' => 'string',
'ProductCategories__custom_field_2_label' => 'string',
'ProductCategories.custom_field_2_label' => 'string',
'ProductCategories__custom_field_3_label' => 'string',
'ProductCategories.custom_field_3_label' => 'string',
'ProductCategories__custom_field_4_label' => 'string',
'ProductCategories.custom_field_4_label' => 'string',
'ProductCategories__custom_field_5_label' => 'string',
'ProductCategories.custom_field_5_label' => 'string',
'ProductSubCategories__id' => 'biginteger',
'ProductSubCategories.id' => 'biginteger',
'ProductSubCategories__name' => 'string',
'ProductSubCategories.name' => 'string',
'ProductSubCategories__description' => 'string',
'ProductSubCategories.description' => 'string',
'ProductSubCategories__product_category_id' => 'biginteger',
'ProductSubCategories.product_category_id' => 'biginteger',
'ProductSubCategories__discount_percentage' => 'decimal',
'ProductSubCategories.discount_percentage' => 'decimal',
'ProductSubCategories__discount_value' => 'decimal',
'ProductSubCategories.discount_value' => 'decimal',
'ProductSubCategories__website_id' => 'biginteger',
'ProductSubCategories.website_id' => 'biginteger',
'ProductSubCategories__photo' => 'proffer.file',
'ProductSubCategories.photo' => 'proffer.file',
'ProductSubCategories__photo_dir' => 'string',
'ProductSubCategories.photo_dir' => 'string',
'ProductSubCategories__created' => 'datetime',
'ProductSubCategories.created' => 'datetime',
'ProductSubCategories__created_by' => 'biginteger',
'ProductSubCategories.created_by' => 'biginteger',
'ProductSubCategories__modified' => 'datetime',
'ProductSubCategories.modified' => 'datetime',
'ProductSubCategories__modified_by' => 'biginteger',
'ProductSubCategories.modified_by' => 'biginteger',
'ProductSubCategories__custom_field_1_label' => 'string',
'ProductSubCategories.custom_field_1_label' => 'string',
'ProductSubCategories__custom_field_2_label' => 'string',
'ProductSubCategories.custom_field_2_label' => 'string',
'ProductSubCategories__custom_field_3_label' => 'string',
'ProductSubCategories.custom_field_3_label' => 'string',
'ProductSubCategories__custom_field_4_label' => 'string',
'ProductSubCategories.custom_field_4_label' => 'string',
'ProductSubCategories__custom_field_5_label' => 'string',
'ProductSubCategories.custom_field_5_label' => 'string',
'ProductSuperSubCategories__id' => 'biginteger',
'ProductSuperSubCategories.id' => 'biginteger',
'ProductSuperSubCategories__product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories.product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories__website_id' => 'biginteger',
'ProductSuperSubCategories.website_id' => 'biginteger',
'ProductSuperSubCategories__discount_percentage' => 'decimal',
'ProductSuperSubCategories.discount_percentage' => 'decimal',
'ProductSuperSubCategories__discount_value' => 'decimal',
'ProductSuperSubCategories.discount_value' => 'decimal',
'ProductSuperSubCategories__name' => 'string',
'ProductSuperSubCategories.name' => 'string',
'ProductSuperSubCategories__photo' => 'proffer.file',
'ProductSuperSubCategories.photo' => 'proffer.file',
'ProductSuperSubCategories__photo_dir' => 'string',
'ProductSuperSubCategories.photo_dir' => 'string',
'ProductSuperSubCategories__created' => 'datetime',
'ProductSuperSubCategories.created' => 'datetime',
'ProductSuperSubCategories__created_by' => 'biginteger',
'ProductSuperSubCategories.created_by' => 'biginteger',
'ProductSuperSubCategories__modified' => 'datetime',
'ProductSuperSubCategories.modified' => 'datetime',
'ProductSuperSubCategories__modified_by' => 'biginteger',
'ProductSuperSubCategories.modified_by' => 'biginteger',
'ProductSuperSubCategories__custom_field_1_label' => 'string',
'ProductSuperSubCategories.custom_field_1_label' => 'string',
'ProductSuperSubCategories__custom_field_2_label' => 'string',
'ProductSuperSubCategories.custom_field_2_label' => 'string',
'ProductSuperSubCategories__custom_field_3_label' => 'string',
'ProductSuperSubCategories.custom_field_3_label' => 'string',
'ProductSuperSubCategories__custom_field_4_label' => 'string',
'ProductSuperSubCategories.custom_field_4_label' => 'string',
'ProductSuperSubCategories__custom_field_5_label' => 'string',
'ProductSuperSubCategories.custom_field_5_label' => 'string',
'ProductImages__id' => 'biginteger',
'ProductImages.id' => 'biginteger',
'ProductImages__photo' => 'proffer.file',
'ProductImages.photo' => 'proffer.file',
'ProductImages__photo_dir' => 'string',
'ProductImages.photo_dir' => 'string',
'ProductImages__product_id' => 'biginteger',
'ProductImages.product_id' => 'biginteger',
'ProductImages__is_default' => 'tinyinteger',
'ProductImages.is_default' => 'tinyinteger',
'is_default' => 'tinyinteger',
'Users__id' => 'biginteger',
'Users.id' => 'biginteger',
'Users__name' => 'string',
'Users.name' => 'string',
'Users__username' => 'string',
'Users.username' => 'string',
'username' => 'string',
'Users__email' => 'string',
'Users.email' => 'string',
'Users__password' => 'string',
'Users.password' => 'string',
'password' => 'string',
'Users__telephone_no' => 'string',
'Users.telephone_no' => 'string',
'Users__verification_code' => 'string',
'Users.verification_code' => 'string',
'verification_code' => 'string',
'Users__active' => 'tinyinteger',
'Users.active' => 'tinyinteger',
'Users__remember_me_code' => 'string',
'Users.remember_me_code' => 'string',
'remember_me_code' => 'string',
'Users__forgot_password_code' => 'string',
'Users.forgot_password_code' => 'string',
'forgot_password_code' => 'string',
'Users__forgot_password_request_date' => 'datetime',
'Users.forgot_password_request_date' => 'datetime',
'forgot_password_request_date' => 'datetime',
'Users__user_type' => 'string',
'Users.user_type' => 'string',
'user_type' => 'string',
'Users__custom_role_id' => 'biginteger',
'Users.custom_role_id' => 'biginteger',
'custom_role_id' => 'biginteger',
'Users__vendor_approved' => 'tinyinteger',
'Users.vendor_approved' => 'tinyinteger',
'vendor_approved' => 'tinyinteger',
'Users__vendor_pre_approved' => 'tinyinteger',
'Users.vendor_pre_approved' => 'tinyinteger',
'vendor_pre_approved' => 'tinyinteger',
'Users__vendor_pre_approved_user_id' => 'biginteger',
'Users.vendor_pre_approved_user_id' => 'biginteger',
'vendor_pre_approved_user_id' => 'biginteger',
'Users__vendor_pre_approved_datetime' => 'datetime',
'Users.vendor_pre_approved_datetime' => 'datetime',
'vendor_pre_approved_datetime' => 'datetime',
'Users__website_id' => 'biginteger',
'Users.website_id' => 'biginteger',
'Users__delivery_area' => 'string',
'Users.delivery_area' => 'string',
'delivery_area' => 'string',
'Users__street_address' => 'string',
'Users.street_address' => 'string',
'street_address' => 'string',
'Users__city' => 'string',
'Users.city' => 'string',
'city' => 'string',
'Users__city_id' => 'biginteger',
'Users.city_id' => 'biginteger',
'Users__district_id' => 'biginteger',
'Users.district_id' => 'biginteger',
'Users__country_id' => 'biginteger',
'Users.country_id' => 'biginteger',
'country_id' => 'biginteger',
'Users__post_code' => 'string',
'Users.post_code' => 'string',
'post_code' => 'string',
'Users__mapgridid' => 'biginteger',
'Users.mapgridid' => 'biginteger',
'mapgridid' => 'biginteger',
'Users__marked_longitude' => 'decimal',
'Users.marked_longitude' => 'decimal',
'marked_longitude' => 'decimal',
'Users__marked_latitude' => 'decimal',
'Users.marked_latitude' => 'decimal',
'marked_latitude' => 'decimal',
'Users__created' => 'datetime',
'Users.created' => 'datetime',
'Users__modified' => 'datetime',
'Users.modified' => 'datetime',
'Users__modified_by' => 'biginteger',
'Users.modified_by' => 'biginteger',
'Users__default_web_url' => 'string',
'Users.default_web_url' => 'string',
'default_web_url' => 'string',
'Users__custom_field_1_text' => 'string',
'Users.custom_field_1_text' => 'string',
'custom_field_1_text' => 'string',
'Users__custom_field_1_value' => 'string',
'Users.custom_field_1_value' => 'string',
'custom_field_1_value' => 'string',
'Users__photo' => 'proffer.file',
'Users.photo' => 'proffer.file',
'Users__photo_dir' => 'string',
'Users.photo_dir' => 'string',
'Users__valid_doc' => 'proffer.file',
'Users.valid_doc' => 'proffer.file',
'valid_doc' => 'proffer.file',
'Users__valid_doc_2' => 'proffer.file',
'Users.valid_doc_2' => 'proffer.file',
'valid_doc_2' => 'proffer.file',
'Users__valid_doc_dir' => 'string',
'Users.valid_doc_dir' => 'string',
'valid_doc_dir' => 'string',
'Users__valid_doc_2_dir' => 'string',
'Users.valid_doc_2_dir' => 'string',
'valid_doc_2_dir' => 'string',
'Users__referral_code' => 'string',
'Users.referral_code' => 'string',
'referral_code' => 'string',
'Users__used_referral_code' => 'string',
'Users.used_referral_code' => 'string',
'used_referral_code' => 'string',
'Users__referral_discount_percentage' => 'smallinteger',
'Users.referral_discount_percentage' => 'smallinteger',
'referral_discount_percentage' => 'smallinteger',
'Users__terms_and_conditions_agreed' => 'integer',
'Users.terms_and_conditions_agreed' => 'integer',
'terms_and_conditions_agreed' => 'integer',
'Users__international_delivery' => 'tinyinteger',
'Users.international_delivery' => 'tinyinteger',
'international_delivery' => 'tinyinteger',
'Users__international_delivery_area' => 'string',
'Users.international_delivery_area' => 'string',
'international_delivery_area' => 'string',
'Users__sms_verify_code' => 'string',
'Users.sms_verify_code' => 'string',
'sms_verify_code' => 'string',
'Users__sms_verify_attempts' => 'tinyinteger',
'Users.sms_verify_attempts' => 'tinyinteger',
'sms_verify_attempts' => 'tinyinteger',
'Users__supervisor_user_id' => 'biginteger',
'Users.supervisor_user_id' => 'biginteger',
'supervisor_user_id' => 'biginteger',
'Users__shop_front_picture' => 'proffer.file',
'Users.shop_front_picture' => 'proffer.file',
'shop_front_picture' => 'proffer.file',
'Users__shop_front_picture_dir' => 'string',
'Users.shop_front_picture_dir' => 'string',
'shop_front_picture_dir' => 'string',
'Users__international_shipping' => 'tinyinteger',
'Users.international_shipping' => 'tinyinteger',
'international_shipping' => 'tinyinteger',
'Users__reg_fee_photo' => 'proffer.file',
'Users.reg_fee_photo' => 'proffer.file',
'reg_fee_photo' => 'proffer.file',
'Users__reg_fee_photo_dir' => 'string',
'Users.reg_fee_photo_dir' => 'string',
'reg_fee_photo_dir' => 'string',
'SubAttrProducts__id' => 'biginteger',
'SubAttrProducts.id' => 'biginteger',
'SubAttrProducts__sku' => 'string',
'SubAttrProducts.sku' => 'string',
'SubAttrProducts__name' => 'string',
'SubAttrProducts.name' => 'string',
'SubAttrProducts__price' => 'decimal',
'SubAttrProducts.price' => 'decimal',
'SubAttrProducts__bought_price' => 'decimal',
'SubAttrProducts.bought_price' => 'decimal',
'SubAttrProducts__discount_percentage' => 'decimal',
'SubAttrProducts.discount_percentage' => 'decimal',
'SubAttrProducts__discount_value' => 'decimal',
'SubAttrProducts.discount_value' => 'decimal',
'SubAttrProducts__description' => 'text',
'SubAttrProducts.description' => 'text',
'SubAttrProducts__brand_id' => 'biginteger',
'SubAttrProducts.brand_id' => 'biginteger',
'SubAttrProducts__product_model_id' => 'biginteger',
'SubAttrProducts.product_model_id' => 'biginteger',
'SubAttrProducts__product_year' => 'integer',
'SubAttrProducts.product_year' => 'integer',
'SubAttrProducts__product_category_id' => 'biginteger',
'SubAttrProducts.product_category_id' => 'biginteger',
'SubAttrProducts__product_sub_category_id' => 'biginteger',
'SubAttrProducts.product_sub_category_id' => 'biginteger',
'SubAttrProducts__product_super_sub_category_id' => 'biginteger',
'SubAttrProducts.product_super_sub_category_id' => 'biginteger',
'SubAttrProducts__quantity' => 'integer',
'SubAttrProducts.quantity' => 'integer',
'SubAttrProducts__website_id' => 'biginteger',
'SubAttrProducts.website_id' => 'biginteger',
'SubAttrProducts__vendor_id' => 'biginteger',
'SubAttrProducts.vendor_id' => 'biginteger',
'SubAttrProducts__vendor_item_approved' => 'tinyinteger',
'SubAttrProducts.vendor_item_approved' => 'tinyinteger',
'SubAttrProducts__vendor_item_pre_approved' => 'tinyinteger',
'SubAttrProducts.vendor_item_pre_approved' => 'tinyinteger',
'SubAttrProducts__vendor_item_pre_approve_user_id' => 'biginteger',
'SubAttrProducts.vendor_item_pre_approve_user_id' => 'biginteger',
'SubAttrProducts__vendor_item_pre_approve_datetime' => 'datetime',
'SubAttrProducts.vendor_item_pre_approve_datetime' => 'datetime',
'SubAttrProducts__featured_item' => 'tinyinteger',
'SubAttrProducts.featured_item' => 'tinyinteger',
'SubAttrProducts__best_selling_item' => 'tinyinteger',
'SubAttrProducts.best_selling_item' => 'tinyinteger',
'SubAttrProducts__delivery_method' => 'string',
'SubAttrProducts.delivery_method' => 'string',
'SubAttrProducts__pickup' => 'tinyinteger',
'SubAttrProducts.pickup' => 'tinyinteger',
'SubAttrProducts__deliver' => 'tinyinteger',
'SubAttrProducts.deliver' => 'tinyinteger',
'SubAttrProducts__weight' => 'decimal',
'SubAttrProducts.weight' => 'decimal',
'SubAttrProducts__sort_order' => 'integer',
'SubAttrProducts.sort_order' => 'integer',
'SubAttrProducts__free_delivery' => 'tinyinteger',
'SubAttrProducts.free_delivery' => 'tinyinteger',
'SubAttrProducts__free_international_delivery' => 'tinyinteger',
'SubAttrProducts.free_international_delivery' => 'tinyinteger',
'SubAttrProducts__stock_available' => 'tinyinteger',
'SubAttrProducts.stock_available' => 'tinyinteger',
'SubAttrProducts__product_type' => 'string',
'SubAttrProducts.product_type' => 'string',
'SubAttrProducts__parent_product_id' => 'biginteger',
'SubAttrProducts.parent_product_id' => 'biginteger',
'SubAttrProducts__attr_color_id' => 'biginteger',
'SubAttrProducts.attr_color_id' => 'biginteger',
'SubAttrProducts__attr_size_id' => 'biginteger',
'SubAttrProducts.attr_size_id' => 'biginteger',
'SubAttrProducts__attr_material_id' => 'biginteger',
'SubAttrProducts.attr_material_id' => 'biginteger',
'SubAttrProducts__created' => 'datetime',
'SubAttrProducts.created' => 'datetime',
'SubAttrProducts__created_by' => 'biginteger',
'SubAttrProducts.created_by' => 'biginteger',
'SubAttrProducts__modified' => 'datetime',
'SubAttrProducts.modified' => 'datetime',
'SubAttrProducts__modified_by' => 'biginteger',
'SubAttrProducts.modified_by' => 'biginteger',
'SubAttrProducts__add_to_cart_text' => 'string',
'SubAttrProducts.add_to_cart_text' => 'string',
'SubAttrProducts__out_of_stock_text' => 'string',
'SubAttrProducts.out_of_stock_text' => 'string',
'SubAttrProducts__length' => 'decimal',
'SubAttrProducts.length' => 'decimal',
'SubAttrProducts__width' => 'decimal',
'SubAttrProducts.width' => 'decimal',
'SubAttrProducts__height' => 'decimal',
'SubAttrProducts.height' => 'decimal',
'SubAttrProducts__volume' => 'string',
'SubAttrProducts.volume' => 'string',
'SubAttrProducts__active' => 'tinyinteger',
'SubAttrProducts.active' => 'tinyinteger',
'SubAttrProducts__custom_product_field_1_value' => 'string',
'SubAttrProducts.custom_product_field_1_value' => 'string',
'SubAttrProducts__custom_product_field_2_value' => 'string',
'SubAttrProducts.custom_product_field_2_value' => 'string',
'SubAttrProducts__custom_product_field_3_value' => 'string',
'SubAttrProducts.custom_product_field_3_value' => 'string',
'SubAttrProducts__custom_product_field_4_value' => 'string',
'SubAttrProducts.custom_product_field_4_value' => 'string',
'SubAttrProducts__custom_product_field_5_value' => 'string',
'SubAttrProducts.custom_product_field_5_value' => 'string',
'SubAttrProducts__district_id' => 'biginteger',
'SubAttrProducts.district_id' => 'biginteger',
'SubAttrProducts__city_id' => 'biginteger',
'SubAttrProducts.city_id' => 'biginteger',
'SubAttrProducts__shop_owner_commission_percentage' => 'decimal',
'SubAttrProducts.shop_owner_commission_percentage' => 'decimal',
'SubAttrProducts__website_price' => 'decimal',
'SubAttrProducts.website_price' => 'decimal',
'SubAttrProducts__currency' => 'string',
'SubAttrProducts.currency' => 'string',
'SubAttrProducts__private_info' => 'text',
'SubAttrProducts.private_info' => 'text',
'SubAttrProducts__attached_file' => 'proffer.file',
'SubAttrProducts.attached_file' => 'proffer.file',
'SubAttrProducts__attached_file_dir' => 'string',
'SubAttrProducts.attached_file_dir' => 'string',
'SubAttrProducts__attached_file2' => 'proffer.file',
'SubAttrProducts.attached_file2' => 'proffer.file',
'SubAttrProducts__attached_file_dir2' => 'string',
'SubAttrProducts.attached_file_dir2' => 'string',
'SubAttrProducts__size_chart' => 'proffer.file',
'SubAttrProducts.size_chart' => 'proffer.file',
'SubAttrProducts__size_chart_dir' => 'string',
'SubAttrProducts.size_chart_dir' => 'string',
'SubAttrProducts__seo_url' => 'string',
'SubAttrProducts.seo_url' => 'string',
'SubAttrProducts__contact_name' => 'string',
'SubAttrProducts.contact_name' => 'string',
'SubAttrProducts__contact_mobile' => 'string',
'SubAttrProducts.contact_mobile' => 'string',
'SubAttrProducts__contact_whatsapp' => 'string',
'SubAttrProducts.contact_whatsapp' => 'string',
'SubAttrProducts__view_count' => 'biginteger',
'SubAttrProducts.view_count' => 'biginteger',
'Districts__id' => 'biginteger',
'Districts.id' => 'biginteger',
'Districts__name' => 'string',
'Districts.name' => 'string',
'Districts__province_id' => 'biginteger',
'Districts.province_id' => 'biginteger',
'province_id' => 'biginteger',
'Cities__id' => 'biginteger',
'Cities.id' => 'biginteger',
'Cities__district_id' => 'biginteger',
'Cities.district_id' => 'biginteger',
'Cities__name' => 'string',
'Cities.name' => 'string',
'Brands__id' => 'biginteger',
'Brands.id' => 'biginteger',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__photo' => 'proffer.file',
'Brands.photo' => 'proffer.file',
'Brands__photo_dir' => 'string',
'Brands.photo_dir' => 'string',
'Brands__website_id' => 'biginteger',
'Brands.website_id' => 'biginteger',
'Brands__discount_percentage' => 'decimal',
'Brands.discount_percentage' => 'decimal',
'Brands__discount_value' => 'decimal',
'Brands.discount_value' => 'decimal',
'ProductModels__id' => 'biginteger',
'ProductModels.id' => 'biginteger',
'ProductModels__brand_id' => 'biginteger',
'ProductModels.brand_id' => 'biginteger',
'ProductModels__name' => 'string',
'ProductModels.name' => 'string',
'ProductModels__website_id' => 'biginteger',
'ProductModels.website_id' => 'biginteger'
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Websites' => [
[maximum depth reached]
],
'ProductCategories' => [
[maximum depth reached]
],
'ProductSubCategories' => [
[maximum depth reached]
],
'ProductSuperSubCategories' => [
[maximum depth reached]
],
'ProductImages' => [[maximum depth reached]],
'Users' => [
[maximum depth reached]
],
'SubAttrProducts' => [
[maximum depth reached]
],
'Districts' => [
[maximum depth reached]
],
'Cities' => [
[maximum depth reached]
],
'Brands' => [
[maximum depth reached]
],
'ProductModels' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$website = object(App\Model\Entity\Website) {
'id' => (int) 182,
'website_key' => null,
'domain_name' => 'stgsite182.lakshop.lk',
'user_id' => (int) 333,
'domain_name_alias' => null,
'domain_dns_key' => 'd9a9e0d60328fb3910d527069150caafb08d256d',
'domain_verified' => (int) 1,
'email_sent_by_verified' => (int) 0,
'published' => (int) 0,
'name' => 'testcb00003',
'address' => 'testcb00003',
'email' => 'testcb00003@css.lk',
'show_email_on_website' => (int) 0,
'telephone_no' => '0765321084',
'mobile_no' => '0765321084',
'fax_no' => '',
'whatsapp_no' => null,
'latitude' => null,
'longitude' => null,
'logo' => null,
'logo_dir' => null,
'favicon' => null,
'favicon_dir' => null,
'tag_line' => null,
'facebook_link' => null,
'twitter_link' => null,
'linkedin_link' => null,
'facebook_api_key' => null,
'facebook_api_secret' => null,
'facebook_script' => null,
'facebook_div' => null,
'fb_og_url' => null,
'fb_og_type' => null,
'fb_og_title' => null,
'fb_og_description' => null,
'instagram_url' => null,
'linkedin_url' => null,
'houzz_url' => null,
'main_description' => null,
'main_image' => null,
'main_image_dir' => null,
'feature_image' => null,
'feature_image_dir' => null,
'product_bg' => null,
'product_bg_dir' => null,
'service_bg' => null,
'service_bg_dir' => null,
'portfolio_bg' => null,
'portfolio_bg_dir' => null,
'testimonial_bg' => null,
'testimonial_bg_dir' => null,
'contact_us_bg' => null,
'contact_us_bg_dir' => null,
'footer_bg' => null,
'footer_bg_dir' => null,
'main_banner_bg' => null,
'main_banner_bg_dir' => null,
'subscription_bg' => null,
'subscription_bg_dir' => null,
'theme_color' => null,
'secondary_color' => null,
'currency' => 'LKR',
'about_us_menu_name' => null,
'shop_menu_name' => null,
'about_us_heading_name' => null,
'products_menu_name' => null,
'products_heading_name' => null,
'services_menu_name' => null,
'services_heading_name' => null,
'portfolio_menu_name' => null,
'portfolio_heading_name' => null,
'testimonial_menu_name' => null,
'testimonial_heading_name' => null,
'features_menu_name' => null,
'features_heading_name' => null,
'staff_page_enabled' => (int) 0,
'staff_menu_name' => 'Staff',
'what_we_do_page_enabled' => null,
'what_we_do_page_menu_name' => 'What we do',
'how_it_works_page_enabled' => (int) 0,
'how_it_works_menu_name' => null,
'blog_menu_name' => null,
'template_id' => (int) 37,
'business_id' => (int) 8,
'login_id' => null,
'sample' => (int) 0,
'login_feature' => (int) 0,
'cart_feature' => (int) 0,
'ecom_live_mode' => (int) 0,
'pay_here_merchantid' => '',
'pay_here_merchant_secret' => '',
'product_quantity_feature' => 'SINGLE',
'service_quantity_feature' => 'SINGLE',
'min_delivery_weight' => null,
'min_delivery_price' => null,
'incremental_weight' => null,
'incremental_weight_price' => null,
'tax_rate' => null,
'max_delivery_day_count' => null,
'pick_up_location' => null,
'commission_percentage' => null,
'seller_payment_dispatch_processing_fee' => null,
'payment_processing_fee' => null,
'payment_processing_percentage' => null,
'processing_fee_application_max_value' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'created_by' => null,
'modified' => object(Cake\I18n\FrozenTime) {},
'modified_by' => null,
'force_ssl' => (int) 0,
'custom_field_1_label' => '',
'custom_field_2_label' => null,
'custom_field_3_label' => null,
'custom_field_4_label' => null,
'custom_field_5_label' => null,
'payhere_enabled' => (int) 0,
'multi_vendor_enabled' => (int) 0,
'website_type' => 'LOCAL_WEBSITE',
'payment_made' => (int) 0,
'payment_details' => null,
'auto_login_code' => '58aa5094-e49e-43a4-a601-1e2214984445',
'contact_us_top_text' => null,
'header_id' => null,
'service_id' => null,
'slider_id' => null,
'product_id' => null,
'custom_css' => null,
'custom_script' => null,
'product_title_prefix' => null,
'product_title_suffix' => null,
'contact_us_text' => null,
'show_contact_button_on_banner' => (int) 1,
'show_all_elements_in_menu' => (int) 0,
'site_wide_discount_percentage' => (float) 0,
'site_wide_discount_value' => (float) 0,
'suspended' => (int) 0,
'sms_credit_id' => null,
'check_stock_when_ordering' => (int) 1,
'min_order_value' => (float) 0,
'order_instructions' => null,
'require_customer_map_location' => (int) 0,
'require_additional_checkout_info' => (int) 0,
'require_shipping_address_info' => (int) 0,
'bank_account_details_for_orders' => 'Account Name : Account Number : Bank Name : Bank Branch :',
'shop_url' => null,
'shop_url_text' => null,
'buyer_needs_to_accept_terms' => (int) 0,
'custom_product_field_1_label' => null,
'custom_product_field_2_label' => null,
'custom_product_field_3_label' => null,
'custom_product_field_4_label' => null,
'custom_product_field_5_label' => null,
'join_us_page_enabled' => (int) 0,
'events_page_enabled' => (int) 0,
'android_app_url' => null,
'ios_app_url' => null,
'main_video_youttube_url' => null,
'app_preview_image' => null,
'app_preview_image_dir' => null,
'monthly_fee' => null,
'yearly_fee' => null,
'renewal_fee_description' => null,
'expiry_date' => object(Cake\I18n\FrozenDate) {},
'services' => [],
'products' => [],
'brands' => [],
'documents' => [],
'additional_sections' => [],
'user' => object(App\Model\Entity\User) {},
'cart_items' => [],
'testimonials' => [],
'pricings' => [],
'features' => [],
'portfolios' => [],
'side_banners' => [],
'main_banners' => [],
'payment_gateways' => [],
'payment_services' => [],
'template' => object(App\Model\Entity\Template) {},
'modules' => [],
'courier_companies' => [],
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false,
'payment_made' => false,
'website_type' => false,
'domain_name' => false,
'domain_name_alias' => false,
'domain_dns_key' => false,
'domain_verified' => false,
'sample' => false,
'auto_login_code' => false,
'suspended' => false,
'sms_credit_id' => false,
'user_id' => false,
'expiry_date' => false,
'template_id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [
(int) 0 => 'logo_base_path',
(int) 1 => 'logo_prefixes',
(int) 2 => 'favicon_base_path',
(int) 3 => 'favicon_prefixes',
(int) 4 => 'main_image_base_path',
(int) 5 => 'main_image_prefixes',
(int) 6 => 'contact_bg_image_base_path',
(int) 7 => 'contact_bg_image_prefixes',
(int) 8 => 'is_discounted',
(int) 9 => 'website_theme_colour',
(int) 10 => 'website_domain'
],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Websites'
}
$templateFolderPath = 'lakshop_template_layouts/8/wonderland'
$templateCssFolderPath = 'lakshop_template_css/8/wonderland'
$templateImgFolderPath = 'lakshop_template_img/8/wonderland'
$templateJsFolderPath = 'lakshop_template_js/8/wonderland'
$selectedVendorId = null
$clients = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Clients.id AS `Clients__id`, Clients.website_id AS `Clients__website_id`, Clients.name AS `Clients__name`, Clients.description AS `Clients__description`, Clients.photo_dir AS `Clients__photo_dir`, Clients.photo AS `Clients__photo`, Clients.created AS `Clients__created` FROM clients Clients WHERE website_id = :c0 LIMIT 60',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Clients__id' => 'biginteger',
'Clients.id' => 'biginteger',
'id' => 'biginteger',
'Clients__website_id' => 'biginteger',
'Clients.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Clients__name' => 'string',
'Clients.name' => 'string',
'name' => 'string',
'Clients__description' => 'string',
'Clients.description' => 'string',
'description' => 'string',
'Clients__photo_dir' => 'string',
'Clients.photo_dir' => 'string',
'photo_dir' => 'string',
'Clients__photo' => 'proffer.file',
'Clients.photo' => 'proffer.file',
'photo' => 'proffer.file',
'Clients__created' => 'timestamp',
'Clients.created' => 'timestamp',
'created' => 'timestamp'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ClientsTable) {}
}
$districts = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Districts.id AS `Districts__id`, Districts.name AS `Districts__name` FROM districts Districts WHERE Districts.id in (:c0,:c1) ORDER BY Districts.name ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Districts__id' => 'biginteger',
'Districts.id' => 'biginteger',
'id' => 'biginteger',
'Districts__name' => 'string',
'Districts.name' => 'string',
'name' => 'string',
'Districts__province_id' => 'biginteger',
'Districts.province_id' => 'biginteger',
'province_id' => 'biginteger'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\DistrictsTable) {}
}
$productConditions = [
'Products.active' => (int) 1,
'Products.website_id' => (int) 182,
(int) 1 => [
'OR' => [
(int) 0 => [
[maximum depth reached]
],
(int) 1 => [
[maximum depth reached]
],
(int) 2 => [
[maximum depth reached]
]
]
]
]
$featuredProducts = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductCategories.name AS `ProductCategories__name`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSubCategories.name AS `ProductSubCategories__name`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value`, Websites.id AS `Websites__id`, Websites.website_type AS `Websites__website_type`, Websites.user_id AS `Websites__user_id` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) INNER JOIN websites Websites ON Websites.id = (Products.website_id) WHERE (Products.website_id = :c0 AND Products.featured_item = :c1 AND Products.active = :c2 AND (Websites.website_type != :c3 OR (Websites.website_type = :c4 AND Products.quantity > :c5))) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 50',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Products__id' => 'biginteger',
'Products.id' => 'biginteger',
'id' => 'biginteger',
'Products__sku' => 'string',
'Products.sku' => 'string',
'sku' => 'string',
'Products__name' => 'string',
'Products.name' => 'string',
'name' => 'string',
'Products__price' => 'decimal',
'Products.price' => 'decimal',
'price' => 'decimal',
'Products__bought_price' => 'decimal',
'Products.bought_price' => 'decimal',
'bought_price' => 'decimal',
'Products__discount_percentage' => 'decimal',
'Products.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'Products__discount_value' => 'decimal',
'Products.discount_value' => 'decimal',
'discount_value' => 'decimal',
'Products__description' => 'text',
'Products.description' => 'text',
'description' => 'text',
'Products__brand_id' => 'biginteger',
'Products.brand_id' => 'biginteger',
'brand_id' => 'biginteger',
'Products__product_model_id' => 'biginteger',
'Products.product_model_id' => 'biginteger',
'product_model_id' => 'biginteger',
'Products__product_year' => 'integer',
'Products.product_year' => 'integer',
'product_year' => 'integer',
'Products__product_category_id' => 'biginteger',
'Products.product_category_id' => 'biginteger',
'product_category_id' => 'biginteger',
'Products__product_sub_category_id' => 'biginteger',
'Products.product_sub_category_id' => 'biginteger',
'product_sub_category_id' => 'biginteger',
'Products__product_super_sub_category_id' => 'biginteger',
'Products.product_super_sub_category_id' => 'biginteger',
'product_super_sub_category_id' => 'biginteger',
'Products__quantity' => 'integer',
'Products.quantity' => 'integer',
'quantity' => 'integer',
'Products__website_id' => 'biginteger',
'Products.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Products__vendor_id' => 'biginteger',
'Products.vendor_id' => 'biginteger',
'vendor_id' => 'biginteger',
'Products__vendor_item_approved' => 'tinyinteger',
'Products.vendor_item_approved' => 'tinyinteger',
'vendor_item_approved' => 'tinyinteger',
'Products__vendor_item_pre_approved' => 'tinyinteger',
'Products.vendor_item_pre_approved' => 'tinyinteger',
'vendor_item_pre_approved' => 'tinyinteger',
'Products__vendor_item_pre_approve_user_id' => 'biginteger',
'Products.vendor_item_pre_approve_user_id' => 'biginteger',
'vendor_item_pre_approve_user_id' => 'biginteger',
'Products__vendor_item_pre_approve_datetime' => 'datetime',
'Products.vendor_item_pre_approve_datetime' => 'datetime',
'vendor_item_pre_approve_datetime' => 'datetime',
'Products__featured_item' => 'tinyinteger',
'Products.featured_item' => 'tinyinteger',
'featured_item' => 'tinyinteger',
'Products__best_selling_item' => 'tinyinteger',
'Products.best_selling_item' => 'tinyinteger',
'best_selling_item' => 'tinyinteger',
'Products__delivery_method' => 'string',
'Products.delivery_method' => 'string',
'delivery_method' => 'string',
'Products__pickup' => 'tinyinteger',
'Products.pickup' => 'tinyinteger',
'pickup' => 'tinyinteger',
'Products__deliver' => 'tinyinteger',
'Products.deliver' => 'tinyinteger',
'deliver' => 'tinyinteger',
'Products__weight' => 'decimal',
'Products.weight' => 'decimal',
'weight' => 'decimal',
'Products__sort_order' => 'integer',
'Products.sort_order' => 'integer',
'sort_order' => 'integer',
'Products__free_delivery' => 'tinyinteger',
'Products.free_delivery' => 'tinyinteger',
'free_delivery' => 'tinyinteger',
'Products__free_international_delivery' => 'tinyinteger',
'Products.free_international_delivery' => 'tinyinteger',
'free_international_delivery' => 'tinyinteger',
'Products__stock_available' => 'tinyinteger',
'Products.stock_available' => 'tinyinteger',
'stock_available' => 'tinyinteger',
'Products__product_type' => 'string',
'Products.product_type' => 'string',
'product_type' => 'string',
'Products__parent_product_id' => 'biginteger',
'Products.parent_product_id' => 'biginteger',
'parent_product_id' => 'biginteger',
'Products__attr_color_id' => 'biginteger',
'Products.attr_color_id' => 'biginteger',
'attr_color_id' => 'biginteger',
'Products__attr_size_id' => 'biginteger',
'Products.attr_size_id' => 'biginteger',
'attr_size_id' => 'biginteger',
'Products__attr_material_id' => 'biginteger',
'Products.attr_material_id' => 'biginteger',
'attr_material_id' => 'biginteger',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__created_by' => 'biginteger',
'Products.created_by' => 'biginteger',
'created_by' => 'biginteger',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__modified_by' => 'biginteger',
'Products.modified_by' => 'biginteger',
'modified_by' => 'biginteger',
'Products__add_to_cart_text' => 'string',
'Products.add_to_cart_text' => 'string',
'add_to_cart_text' => 'string',
'Products__out_of_stock_text' => 'string',
'Products.out_of_stock_text' => 'string',
'out_of_stock_text' => 'string',
'Products__length' => 'decimal',
'Products.length' => 'decimal',
'length' => 'decimal',
'Products__width' => 'decimal',
'Products.width' => 'decimal',
'width' => 'decimal',
'Products__height' => 'decimal',
'Products.height' => 'decimal',
'height' => 'decimal',
'Products__volume' => 'string',
'Products.volume' => 'string',
'volume' => 'string',
'Products__active' => 'tinyinteger',
'Products.active' => 'tinyinteger',
'active' => 'tinyinteger',
'Products__custom_product_field_1_value' => 'string',
'Products.custom_product_field_1_value' => 'string',
'custom_product_field_1_value' => 'string',
'Products__custom_product_field_2_value' => 'string',
'Products.custom_product_field_2_value' => 'string',
'custom_product_field_2_value' => 'string',
'Products__custom_product_field_3_value' => 'string',
'Products.custom_product_field_3_value' => 'string',
'custom_product_field_3_value' => 'string',
'Products__custom_product_field_4_value' => 'string',
'Products.custom_product_field_4_value' => 'string',
'custom_product_field_4_value' => 'string',
'Products__custom_product_field_5_value' => 'string',
'Products.custom_product_field_5_value' => 'string',
'custom_product_field_5_value' => 'string',
'Products__district_id' => 'biginteger',
'Products.district_id' => 'biginteger',
'district_id' => 'biginteger',
'Products__city_id' => 'biginteger',
'Products.city_id' => 'biginteger',
'city_id' => 'biginteger',
'Products__shop_owner_commission_percentage' => 'decimal',
'Products.shop_owner_commission_percentage' => 'decimal',
'shop_owner_commission_percentage' => 'decimal',
'Products__website_price' => 'decimal',
'Products.website_price' => 'decimal',
'website_price' => 'decimal',
'Products__currency' => 'string',
'Products.currency' => 'string',
'currency' => 'string',
'Products__private_info' => 'text',
'Products.private_info' => 'text',
'private_info' => 'text',
'Products__attached_file' => 'proffer.file',
'Products.attached_file' => 'proffer.file',
'attached_file' => 'proffer.file',
'Products__attached_file_dir' => 'string',
'Products.attached_file_dir' => 'string',
'attached_file_dir' => 'string',
'Products__attached_file2' => 'proffer.file',
'Products.attached_file2' => 'proffer.file',
'attached_file2' => 'proffer.file',
'Products__attached_file_dir2' => 'string',
'Products.attached_file_dir2' => 'string',
'attached_file_dir2' => 'string',
'Products__size_chart' => 'proffer.file',
'Products.size_chart' => 'proffer.file',
'size_chart' => 'proffer.file',
'Products__size_chart_dir' => 'string',
'Products.size_chart_dir' => 'string',
'size_chart_dir' => 'string',
'Products__seo_url' => 'string',
'Products.seo_url' => 'string',
'seo_url' => 'string',
'Products__contact_name' => 'string',
'Products.contact_name' => 'string',
'contact_name' => 'string',
'Products__contact_mobile' => 'string',
'Products.contact_mobile' => 'string',
'contact_mobile' => 'string',
'Products__contact_whatsapp' => 'string',
'Products.contact_whatsapp' => 'string',
'contact_whatsapp' => 'string',
'Products__view_count' => 'biginteger',
'Products.view_count' => 'biginteger',
'view_count' => 'biginteger',
'ProductCategories__id' => 'biginteger',
'ProductCategories.id' => 'biginteger',
'ProductCategories__name' => 'string',
'ProductCategories.name' => 'string',
'ProductCategories__photo' => 'proffer.file',
'ProductCategories.photo' => 'proffer.file',
'photo' => 'proffer.file',
'ProductCategories__photo_dir' => 'string',
'ProductCategories.photo_dir' => 'string',
'photo_dir' => 'string',
'ProductCategories__large_photo' => 'proffer.file',
'ProductCategories.large_photo' => 'proffer.file',
'large_photo' => 'proffer.file',
'ProductCategories__large_photo_dir' => 'string',
'ProductCategories.large_photo_dir' => 'string',
'large_photo_dir' => 'string',
'ProductCategories__discount_percentage' => 'decimal',
'ProductCategories.discount_percentage' => 'decimal',
'ProductCategories__discount_value' => 'decimal',
'ProductCategories.discount_value' => 'decimal',
'ProductCategories__website_id' => 'biginteger',
'ProductCategories.website_id' => 'biginteger',
'ProductCategories__created' => 'datetime',
'ProductCategories.created' => 'datetime',
'ProductCategories__created_by' => 'biginteger',
'ProductCategories.created_by' => 'biginteger',
'ProductCategories__modified' => 'datetime',
'ProductCategories.modified' => 'datetime',
'ProductCategories__modified_by' => 'biginteger',
'ProductCategories.modified_by' => 'biginteger',
'ProductCategories__sort_order' => 'integer',
'ProductCategories.sort_order' => 'integer',
'ProductCategories__enabled' => 'integer',
'ProductCategories.enabled' => 'integer',
'enabled' => 'integer',
'ProductCategories__show_in_home_page' => 'integer',
'ProductCategories.show_in_home_page' => 'integer',
'show_in_home_page' => 'integer',
'ProductCategories__custom_field_1_label' => 'string',
'ProductCategories.custom_field_1_label' => 'string',
'custom_field_1_label' => 'string',
'ProductCategories__custom_field_2_label' => 'string',
'ProductCategories.custom_field_2_label' => 'string',
'custom_field_2_label' => 'string',
'ProductCategories__custom_field_3_label' => 'string',
'ProductCategories.custom_field_3_label' => 'string',
'custom_field_3_label' => 'string',
'ProductCategories__custom_field_4_label' => 'string',
'ProductCategories.custom_field_4_label' => 'string',
'custom_field_4_label' => 'string',
'ProductCategories__custom_field_5_label' => 'string',
'ProductCategories.custom_field_5_label' => 'string',
'custom_field_5_label' => 'string',
'ProductSubCategories__id' => 'biginteger',
'ProductSubCategories.id' => 'biginteger',
'ProductSubCategories__name' => 'string',
'ProductSubCategories.name' => 'string',
'ProductSubCategories__description' => 'string',
'ProductSubCategories.description' => 'string',
'ProductSubCategories__product_category_id' => 'biginteger',
'ProductSubCategories.product_category_id' => 'biginteger',
'ProductSubCategories__discount_percentage' => 'decimal',
'ProductSubCategories.discount_percentage' => 'decimal',
'ProductSubCategories__discount_value' => 'decimal',
'ProductSubCategories.discount_value' => 'decimal',
'ProductSubCategories__website_id' => 'biginteger',
'ProductSubCategories.website_id' => 'biginteger',
'ProductSubCategories__photo' => 'proffer.file',
'ProductSubCategories.photo' => 'proffer.file',
'ProductSubCategories__photo_dir' => 'string',
'ProductSubCategories.photo_dir' => 'string',
'ProductSubCategories__created' => 'datetime',
'ProductSubCategories.created' => 'datetime',
'ProductSubCategories__created_by' => 'biginteger',
'ProductSubCategories.created_by' => 'biginteger',
'ProductSubCategories__modified' => 'datetime',
'ProductSubCategories.modified' => 'datetime',
'ProductSubCategories__modified_by' => 'biginteger',
'ProductSubCategories.modified_by' => 'biginteger',
'ProductSubCategories__custom_field_1_label' => 'string',
'ProductSubCategories.custom_field_1_label' => 'string',
'ProductSubCategories__custom_field_2_label' => 'string',
'ProductSubCategories.custom_field_2_label' => 'string',
'ProductSubCategories__custom_field_3_label' => 'string',
'ProductSubCategories.custom_field_3_label' => 'string',
'ProductSubCategories__custom_field_4_label' => 'string',
'ProductSubCategories.custom_field_4_label' => 'string',
'ProductSubCategories__custom_field_5_label' => 'string',
'ProductSubCategories.custom_field_5_label' => 'string',
'ProductSuperSubCategories__id' => 'biginteger',
'ProductSuperSubCategories.id' => 'biginteger',
'ProductSuperSubCategories__product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories.product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories__website_id' => 'biginteger',
'ProductSuperSubCategories.website_id' => 'biginteger',
'ProductSuperSubCategories__discount_percentage' => 'decimal',
'ProductSuperSubCategories.discount_percentage' => 'decimal',
'ProductSuperSubCategories__discount_value' => 'decimal',
'ProductSuperSubCategories.discount_value' => 'decimal',
'ProductSuperSubCategories__name' => 'string',
'ProductSuperSubCategories.name' => 'string',
'ProductSuperSubCategories__photo' => 'proffer.file',
'ProductSuperSubCategories.photo' => 'proffer.file',
'ProductSuperSubCategories__photo_dir' => 'string',
'ProductSuperSubCategories.photo_dir' => 'string',
'ProductSuperSubCategories__created' => 'datetime',
'ProductSuperSubCategories.created' => 'datetime',
'ProductSuperSubCategories__created_by' => 'biginteger',
'ProductSuperSubCategories.created_by' => 'biginteger',
'ProductSuperSubCategories__modified' => 'datetime',
'ProductSuperSubCategories.modified' => 'datetime',
'ProductSuperSubCategories__modified_by' => 'biginteger',
'ProductSuperSubCategories.modified_by' => 'biginteger',
'ProductSuperSubCategories__custom_field_1_label' => 'string',
'ProductSuperSubCategories.custom_field_1_label' => 'string',
'ProductSuperSubCategories__custom_field_2_label' => 'string',
'ProductSuperSubCategories.custom_field_2_label' => 'string',
'ProductSuperSubCategories__custom_field_3_label' => 'string',
'ProductSuperSubCategories.custom_field_3_label' => 'string',
'ProductSuperSubCategories__custom_field_4_label' => 'string',
'ProductSuperSubCategories.custom_field_4_label' => 'string',
'ProductSuperSubCategories__custom_field_5_label' => 'string',
'ProductSuperSubCategories.custom_field_5_label' => 'string',
'Brands__id' => 'biginteger',
'Brands.id' => 'biginteger',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__photo' => 'proffer.file',
'Brands.photo' => 'proffer.file',
'Brands__photo_dir' => 'string',
'Brands.photo_dir' => 'string',
'Brands__website_id' => 'biginteger',
'Brands.website_id' => 'biginteger',
'Brands__discount_percentage' => 'decimal',
'Brands.discount_percentage' => 'decimal',
'Brands__discount_value' => 'decimal',
'Brands.discount_value' => 'decimal',
'ProductImages__id' => 'biginteger',
'ProductImages.id' => 'biginteger',
'ProductImages__photo' => 'proffer.file',
'ProductImages.photo' => 'proffer.file',
'ProductImages__photo_dir' => 'string',
'ProductImages.photo_dir' => 'string',
'ProductImages__product_id' => 'biginteger',
'ProductImages.product_id' => 'biginteger',
'product_id' => 'biginteger',
'ProductImages__is_default' => 'tinyinteger',
'ProductImages.is_default' => 'tinyinteger',
'is_default' => 'tinyinteger',
'Websites__id' => 'biginteger',
'Websites.id' => 'biginteger',
'Websites__website_key' => 'string',
'Websites.website_key' => 'string',
'website_key' => 'string',
'Websites__domain_name' => 'string',
'Websites.domain_name' => 'string',
'domain_name' => 'string',
'Websites__user_id' => 'biginteger',
'Websites.user_id' => 'biginteger',
'user_id' => 'biginteger',
'Websites__domain_name_alias' => 'string',
'Websites.domain_name_alias' => 'string',
'domain_name_alias' => 'string',
'Websites__domain_dns_key' => 'string',
'Websites.domain_dns_key' => 'string',
'domain_dns_key' => 'string',
'Websites__domain_verified' => 'tinyinteger',
'Websites.domain_verified' => 'tinyinteger',
'domain_verified' => 'tinyinteger',
'Websites__email_sent_by_verified' => 'tinyinteger',
'Websites.email_sent_by_verified' => 'tinyinteger',
'email_sent_by_verified' => 'tinyinteger',
'Websites__published' => 'tinyinteger',
'Websites.published' => 'tinyinteger',
'published' => 'tinyinteger',
'Websites__name' => 'string',
'Websites.name' => 'string',
'Websites__address' => 'text',
'Websites.address' => 'text',
'address' => 'text',
'Websites__email' => 'string',
'Websites.email' => 'string',
'email' => 'string',
'Websites__show_email_on_website' => 'tinyinteger',
'Websites.show_email_on_website' => 'tinyinteger',
'show_email_on_website' => 'tinyinteger',
'Websites__telephone_no' => 'string',
'Websites.telephone_no' => 'string',
'telephone_no' => 'string',
'Websites__mobile_no' => 'string',
'Websites.mobile_no' => 'string',
'mobile_no' => 'string',
'Websites__fax_no' => 'string',
'Websites.fax_no' => 'string',
'fax_no' => 'string',
'Websites__whatsapp_no' => 'string',
'Websites.whatsapp_no' => 'string',
'whatsapp_no' => 'string',
'Websites__latitude' => 'float',
'Websites.latitude' => 'float',
'latitude' => 'float',
'Websites__longitude' => 'float',
'Websites.longitude' => 'float',
'longitude' => 'float',
'Websites__logo' => 'proffer.file',
'Websites.logo' => 'proffer.file',
'logo' => 'proffer.file',
'Websites__logo_dir' => 'string',
'Websites.logo_dir' => 'string',
'logo_dir' => 'string',
'Websites__favicon' => 'proffer.file',
'Websites.favicon' => 'proffer.file',
'favicon' => 'proffer.file',
'Websites__favicon_dir' => 'string',
'Websites.favicon_dir' => 'string',
'favicon_dir' => 'string',
'Websites__tag_line' => 'string',
'Websites.tag_line' => 'string',
'tag_line' => 'string',
'Websites__facebook_link' => 'string',
'Websites.facebook_link' => 'string',
'facebook_link' => 'string',
'Websites__twitter_link' => 'string',
'Websites.twitter_link' => 'string',
'twitter_link' => 'string',
'Websites__linkedin_link' => 'string',
'Websites.linkedin_link' => 'string',
'linkedin_link' => 'string',
'Websites__facebook_api_key' => 'string',
'Websites.facebook_api_key' => 'string',
'facebook_api_key' => 'string',
'Websites__facebook_api_secret' => 'string',
'Websites.facebook_api_secret' => 'string',
'facebook_api_secret' => 'string',
'Websites__facebook_script' => 'string',
'Websites.facebook_script' => 'string',
'facebook_script' => 'string',
'Websites__facebook_div' => 'string',
'Websites.facebook_div' => 'string',
'facebook_div' => 'string',
'Websites__fb_og_url' => 'string',
'Websites.fb_og_url' => 'string',
'fb_og_url' => 'string',
'Websites__fb_og_type' => 'string',
'Websites.fb_og_type' => 'string',
'fb_og_type' => 'string',
'Websites__fb_og_title' => 'string',
'Websites.fb_og_title' => 'string',
'fb_og_title' => 'string',
'Websites__fb_og_description' => 'string',
'Websites.fb_og_description' => 'string',
'fb_og_description' => 'string',
'Websites__instagram_url' => 'string',
'Websites.instagram_url' => 'string',
'instagram_url' => 'string',
'Websites__linkedin_url' => 'string',
'Websites.linkedin_url' => 'string',
'linkedin_url' => 'string',
'Websites__houzz_url' => 'string',
'Websites.houzz_url' => 'string',
'houzz_url' => 'string',
'Websites__main_description' => 'text',
'Websites.main_description' => 'text',
'main_description' => 'text',
'Websites__main_image' => 'proffer.file',
'Websites.main_image' => 'proffer.file',
'main_image' => 'proffer.file',
'Websites__main_image_dir' => 'string',
'Websites.main_image_dir' => 'string',
'main_image_dir' => 'string',
'Websites__feature_image' => 'proffer.file',
'Websites.feature_image' => 'proffer.file',
'feature_image' => 'proffer.file',
'Websites__feature_image_dir' => 'string',
'Websites.feature_image_dir' => 'string',
'feature_image_dir' => 'string',
'Websites__product_bg' => 'proffer.file',
'Websites.product_bg' => 'proffer.file',
'product_bg' => 'proffer.file',
'Websites__product_bg_dir' => 'string',
'Websites.product_bg_dir' => 'string',
'product_bg_dir' => 'string',
'Websites__service_bg' => 'proffer.file',
'Websites.service_bg' => 'proffer.file',
'service_bg' => 'proffer.file',
'Websites__service_bg_dir' => 'string',
'Websites.service_bg_dir' => 'string',
'service_bg_dir' => 'string',
'Websites__portfolio_bg' => 'proffer.file',
'Websites.portfolio_bg' => 'proffer.file',
'portfolio_bg' => 'proffer.file',
'Websites__portfolio_bg_dir' => 'string',
'Websites.portfolio_bg_dir' => 'string',
'portfolio_bg_dir' => 'string',
'Websites__testimonial_bg' => 'proffer.file',
'Websites.testimonial_bg' => 'proffer.file',
'testimonial_bg' => 'proffer.file',
'Websites__testimonial_bg_dir' => 'string',
'Websites.testimonial_bg_dir' => 'string',
'testimonial_bg_dir' => 'string',
'Websites__contact_us_bg' => 'proffer.file',
'Websites.contact_us_bg' => 'proffer.file',
'contact_us_bg' => 'proffer.file',
'Websites__contact_us_bg_dir' => 'string',
'Websites.contact_us_bg_dir' => 'string',
'contact_us_bg_dir' => 'string',
'Websites__footer_bg' => 'proffer.file',
'Websites.footer_bg' => 'proffer.file',
'footer_bg' => 'proffer.file',
'Websites__footer_bg_dir' => 'string',
'Websites.footer_bg_dir' => 'string',
'footer_bg_dir' => 'string',
'Websites__main_banner_bg' => 'proffer.file',
'Websites.main_banner_bg' => 'proffer.file',
'main_banner_bg' => 'proffer.file',
'Websites__main_banner_bg_dir' => 'string',
'Websites.main_banner_bg_dir' => 'string',
'main_banner_bg_dir' => 'string',
'Websites__subscription_bg' => 'string',
'Websites.subscription_bg' => 'string',
'subscription_bg' => 'string',
'Websites__subscription_bg_dir' => 'string',
'Websites.subscription_bg_dir' => 'string',
'subscription_bg_dir' => 'string',
'Websites__theme_color' => 'string',
'Websites.theme_color' => 'string',
'theme_color' => 'string',
'Websites__secondary_color' => 'string',
'Websites.secondary_color' => 'string',
'secondary_color' => 'string',
'Websites__currency' => 'string',
'Websites.currency' => 'string',
'Websites__about_us_menu_name' => 'string',
'Websites.about_us_menu_name' => 'string',
'about_us_menu_name' => 'string',
'Websites__shop_menu_name' => 'string',
'Websites.shop_menu_name' => 'string',
'shop_menu_name' => 'string',
'Websites__about_us_heading_name' => 'string',
'Websites.about_us_heading_name' => 'string',
'about_us_heading_name' => 'string',
'Websites__products_menu_name' => 'string',
'Websites.products_menu_name' => 'string',
'products_menu_name' => 'string',
'Websites__products_heading_name' => 'string',
'Websites.products_heading_name' => 'string',
'products_heading_name' => 'string',
'Websites__services_menu_name' => 'string',
'Websites.services_menu_name' => 'string',
'services_menu_name' => 'string',
'Websites__services_heading_name' => 'string',
'Websites.services_heading_name' => 'string',
'services_heading_name' => 'string',
'Websites__portfolio_menu_name' => 'string',
'Websites.portfolio_menu_name' => 'string',
'portfolio_menu_name' => 'string',
'Websites__portfolio_heading_name' => 'string',
'Websites.portfolio_heading_name' => 'string',
'portfolio_heading_name' => 'string',
'Websites__testimonial_menu_name' => 'string',
'Websites.testimonial_menu_name' => 'string',
'testimonial_menu_name' => 'string',
'Websites__testimonial_heading_name' => 'string',
'Websites.testimonial_heading_name' => 'string',
'testimonial_heading_name' => 'string',
'Websites__features_menu_name' => 'string',
'Websites.features_menu_name' => 'string',
'features_menu_name' => 'string',
'Websites__features_heading_name' => 'string',
'Websites.features_heading_name' => 'string',
'features_heading_name' => 'string',
'Websites__staff_page_enabled' => 'tinyinteger',
'Websites.staff_page_enabled' => 'tinyinteger',
'staff_page_enabled' => 'tinyinteger',
'Websites__staff_menu_name' => 'string',
'Websites.staff_menu_name' => 'string',
'staff_menu_name' => 'string',
'Websites__what_we_do_page_enabled' => 'tinyinteger',
'Websites.what_we_do_page_enabled' => 'tinyinteger',
'what_we_do_page_enabled' => 'tinyinteger',
'Websites__what_we_do_page_menu_name' => 'string',
'Websites.what_we_do_page_menu_name' => 'string',
'what_we_do_page_menu_name' => 'string',
'Websites__how_it_works_page_enabled' => 'tinyinteger',
'Websites.how_it_works_page_enabled' => 'tinyinteger',
'how_it_works_page_enabled' => 'tinyinteger',
'Websites__how_it_works_menu_name' => 'string',
'Websites.how_it_works_menu_name' => 'string',
'how_it_works_menu_name' => 'string',
'Websites__blog_menu_name' => 'string',
'Websites.blog_menu_name' => 'string',
'blog_menu_name' => 'string',
'Websites__template_id' => 'biginteger',
'Websites.template_id' => 'biginteger',
'template_id' => 'biginteger',
'Websites__business_id' => 'biginteger',
'Websites.business_id' => 'biginteger',
'business_id' => 'biginteger',
'Websites__login_id' => 'biginteger',
'Websites.login_id' => 'biginteger',
'login_id' => 'biginteger',
'Websites__sample' => 'tinyinteger',
'Websites.sample' => 'tinyinteger',
'sample' => 'tinyinteger',
'Websites__login_feature' => 'tinyinteger',
'Websites.login_feature' => 'tinyinteger',
'login_feature' => 'tinyinteger',
'Websites__cart_feature' => 'tinyinteger',
'Websites.cart_feature' => 'tinyinteger',
'cart_feature' => 'tinyinteger',
'Websites__ecom_live_mode' => 'tinyinteger',
'Websites.ecom_live_mode' => 'tinyinteger',
'ecom_live_mode' => 'tinyinteger',
'Websites__pay_here_merchantid' => 'string',
'Websites.pay_here_merchantid' => 'string',
'pay_here_merchantid' => 'string',
'Websites__pay_here_merchant_secret' => 'string',
'Websites.pay_here_merchant_secret' => 'string',
'pay_here_merchant_secret' => 'string',
'Websites__product_quantity_feature' => 'string',
'Websites.product_quantity_feature' => 'string',
'product_quantity_feature' => 'string',
'Websites__service_quantity_feature' => 'string',
'Websites.service_quantity_feature' => 'string',
'service_quantity_feature' => 'string',
'Websites__min_delivery_weight' => 'decimal',
'Websites.min_delivery_weight' => 'decimal',
'min_delivery_weight' => 'decimal',
'Websites__min_delivery_price' => 'decimal',
'Websites.min_delivery_price' => 'decimal',
'min_delivery_price' => 'decimal',
'Websites__incremental_weight' => 'decimal',
'Websites.incremental_weight' => 'decimal',
'incremental_weight' => 'decimal',
'Websites__incremental_weight_price' => 'decimal',
'Websites.incremental_weight_price' => 'decimal',
'incremental_weight_price' => 'decimal',
'Websites__tax_rate' => 'decimal',
'Websites.tax_rate' => 'decimal',
'tax_rate' => 'decimal',
'Websites__max_delivery_day_count' => 'integer',
'Websites.max_delivery_day_count' => 'integer',
'max_delivery_day_count' => 'integer',
'Websites__pick_up_location' => 'text',
'Websites.pick_up_location' => 'text',
'pick_up_location' => 'text',
'Websites__commission_percentage' => 'decimal',
'Websites.commission_percentage' => 'decimal',
'commission_percentage' => 'decimal',
'Websites__seller_payment_dispatch_processing_fee' => 'decimal',
'Websites.seller_payment_dispatch_processing_fee' => 'decimal',
'seller_payment_dispatch_processing_fee' => 'decimal',
'Websites__payment_processing_fee' => 'decimal',
'Websites.payment_processing_fee' => 'decimal',
'payment_processing_fee' => 'decimal',
'Websites__payment_processing_percentage' => 'decimal',
'Websites.payment_processing_percentage' => 'decimal',
'payment_processing_percentage' => 'decimal',
'Websites__processing_fee_application_max_value' => 'decimal',
'Websites.processing_fee_application_max_value' => 'decimal',
'processing_fee_application_max_value' => 'decimal',
'Websites__created' => 'datetime',
'Websites.created' => 'datetime',
'Websites__created_by' => 'biginteger',
'Websites.created_by' => 'biginteger',
'Websites__modified' => 'datetime',
'Websites.modified' => 'datetime',
'Websites__modified_by' => 'biginteger',
'Websites.modified_by' => 'biginteger',
'Websites__force_ssl' => 'tinyinteger',
'Websites.force_ssl' => 'tinyinteger',
'force_ssl' => 'tinyinteger',
'Websites__custom_field_1_label' => 'string',
'Websites.custom_field_1_label' => 'string',
'Websites__custom_field_2_label' => 'string',
'Websites.custom_field_2_label' => 'string',
'Websites__custom_field_3_label' => 'string',
'Websites.custom_field_3_label' => 'string',
'Websites__custom_field_4_label' => 'string',
'Websites.custom_field_4_label' => 'string',
'Websites__custom_field_5_label' => 'string',
'Websites.custom_field_5_label' => 'string',
'Websites__payhere_enabled' => 'tinyinteger',
'Websites.payhere_enabled' => 'tinyinteger',
'payhere_enabled' => 'tinyinteger',
'Websites__multi_vendor_enabled' => 'tinyinteger',
'Websites.multi_vendor_enabled' => 'tinyinteger',
'multi_vendor_enabled' => 'tinyinteger',
'Websites__website_type' => 'string',
'Websites.website_type' => 'string',
'website_type' => 'string',
'Websites__payment_made' => 'tinyinteger',
'Websites.payment_made' => 'tinyinteger',
'payment_made' => 'tinyinteger',
'Websites__payment_details' => 'text',
'Websites.payment_details' => 'text',
'payment_details' => 'text',
'Websites__auto_login_code' => 'string',
'Websites.auto_login_code' => 'string',
'auto_login_code' => 'string',
'Websites__contact_us_top_text' => 'string',
'Websites.contact_us_top_text' => 'string',
'contact_us_top_text' => 'string',
'Websites__header_id' => 'biginteger',
'Websites.header_id' => 'biginteger',
'header_id' => 'biginteger',
'Websites__service_id' => 'biginteger',
'Websites.service_id' => 'biginteger',
'service_id' => 'biginteger',
'Websites__slider_id' => 'biginteger',
'Websites.slider_id' => 'biginteger',
'slider_id' => 'biginteger',
'Websites__product_id' => 'biginteger',
'Websites.product_id' => 'biginteger',
'Websites__custom_css' => 'text',
'Websites.custom_css' => 'text',
'custom_css' => 'text',
'Websites__custom_script' => 'text',
'Websites.custom_script' => 'text',
'custom_script' => 'text',
'Websites__product_title_prefix' => 'string',
'Websites.product_title_prefix' => 'string',
'product_title_prefix' => 'string',
'Websites__product_title_suffix' => 'string',
'Websites.product_title_suffix' => 'string',
'product_title_suffix' => 'string',
'Websites__contact_us_text' => 'string',
'Websites.contact_us_text' => 'string',
'contact_us_text' => 'string',
'Websites__show_contact_button_on_banner' => 'tinyinteger',
'Websites.show_contact_button_on_banner' => 'tinyinteger',
'show_contact_button_on_banner' => 'tinyinteger',
'Websites__show_all_elements_in_menu' => 'tinyinteger',
'Websites.show_all_elements_in_menu' => 'tinyinteger',
'show_all_elements_in_menu' => 'tinyinteger',
'Websites__site_wide_discount_percentage' => 'decimal',
'Websites.site_wide_discount_percentage' => 'decimal',
'site_wide_discount_percentage' => 'decimal',
'Websites__site_wide_discount_value' => 'decimal',
'Websites.site_wide_discount_value' => 'decimal',
'site_wide_discount_value' => 'decimal',
'Websites__suspended' => 'tinyinteger',
'Websites.suspended' => 'tinyinteger',
'suspended' => 'tinyinteger',
'Websites__sms_credit_id' => 'biginteger',
'Websites.sms_credit_id' => 'biginteger',
'sms_credit_id' => 'biginteger',
'Websites__check_stock_when_ordering' => 'tinyinteger',
'Websites.check_stock_when_ordering' => 'tinyinteger',
'check_stock_when_ordering' => 'tinyinteger',
'Websites__min_order_value' => 'decimal',
'Websites.min_order_value' => 'decimal',
'min_order_value' => 'decimal',
'Websites__order_instructions' => 'string',
'Websites.order_instructions' => 'string',
'order_instructions' => 'string',
'Websites__require_customer_map_location' => 'tinyinteger',
'Websites.require_customer_map_location' => 'tinyinteger',
'require_customer_map_location' => 'tinyinteger',
'Websites__require_additional_checkout_info' => 'tinyinteger',
'Websites.require_additional_checkout_info' => 'tinyinteger',
'require_additional_checkout_info' => 'tinyinteger',
'Websites__require_shipping_address_info' => 'tinyinteger',
'Websites.require_shipping_address_info' => 'tinyinteger',
'require_shipping_address_info' => 'tinyinteger',
'Websites__bank_account_details_for_orders' => 'string',
'Websites.bank_account_details_for_orders' => 'string',
'bank_account_details_for_orders' => 'string',
'Websites__shop_url' => 'string',
'Websites.shop_url' => 'string',
'shop_url' => 'string',
'Websites__shop_url_text' => 'string',
'Websites.shop_url_text' => 'string',
'shop_url_text' => 'string',
'Websites__buyer_needs_to_accept_terms' => 'tinyinteger',
'Websites.buyer_needs_to_accept_terms' => 'tinyinteger',
'buyer_needs_to_accept_terms' => 'tinyinteger',
'Websites__custom_product_field_1_label' => 'string',
'Websites.custom_product_field_1_label' => 'string',
'custom_product_field_1_label' => 'string',
'Websites__custom_product_field_2_label' => 'string',
'Websites.custom_product_field_2_label' => 'string',
'custom_product_field_2_label' => 'string',
'Websites__custom_product_field_3_label' => 'string',
'Websites.custom_product_field_3_label' => 'string',
'custom_product_field_3_label' => 'string',
'Websites__custom_product_field_4_label' => 'string',
'Websites.custom_product_field_4_label' => 'string',
'custom_product_field_4_label' => 'string',
'Websites__custom_product_field_5_label' => 'string',
'Websites.custom_product_field_5_label' => 'string',
'custom_product_field_5_label' => 'string',
'Websites__join_us_page_enabled' => 'tinyinteger',
'Websites.join_us_page_enabled' => 'tinyinteger',
'join_us_page_enabled' => 'tinyinteger',
'Websites__events_page_enabled' => 'tinyinteger',
'Websites.events_page_enabled' => 'tinyinteger',
'events_page_enabled' => 'tinyinteger',
'Websites__android_app_url' => 'string',
'Websites.android_app_url' => 'string',
'android_app_url' => 'string',
'Websites__ios_app_url' => 'string',
'Websites.ios_app_url' => 'string',
'ios_app_url' => 'string',
'Websites__main_video_youttube_url' => 'string',
'Websites.main_video_youttube_url' => 'string',
'main_video_youttube_url' => 'string',
'Websites__app_preview_image' => 'proffer.file',
'Websites.app_preview_image' => 'proffer.file',
'app_preview_image' => 'proffer.file',
'Websites__app_preview_image_dir' => 'string',
'Websites.app_preview_image_dir' => 'string',
'app_preview_image_dir' => 'string',
'Websites__monthly_fee' => 'decimal',
'Websites.monthly_fee' => 'decimal',
'monthly_fee' => 'decimal',
'Websites__yearly_fee' => 'decimal',
'Websites.yearly_fee' => 'decimal',
'yearly_fee' => 'decimal',
'Websites__renewal_fee_description' => 'text',
'Websites.renewal_fee_description' => 'text',
'renewal_fee_description' => 'text',
'Websites__expiry_date' => 'date',
'Websites.expiry_date' => 'date',
'expiry_date' => 'date'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'ProductCategories' => [
[maximum depth reached]
],
'ProductSubCategories' => [
[maximum depth reached]
],
'ProductSuperSubCategories' => [
[maximum depth reached]
],
'Brands' => [
[maximum depth reached]
],
'ProductImages' => [[maximum depth reached]],
'Websites' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$bestSellingProducts = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) WHERE (Products.website_id = :c0 AND Products.best_selling_item = :c1 AND Products.active = :c2) ORDER BY Products.stock_available DESC, Products.featured_item DESC, Products.sort_order DESC, Products.id DESC, Products.product_category_id ASC, Products.product_sub_category_id ASC, Products.product_super_sub_category_id ASC, Products.brand_id ASC LIMIT 5',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Products__id' => 'biginteger',
'Products.id' => 'biginteger',
'id' => 'biginteger',
'Products__sku' => 'string',
'Products.sku' => 'string',
'sku' => 'string',
'Products__name' => 'string',
'Products.name' => 'string',
'name' => 'string',
'Products__price' => 'decimal',
'Products.price' => 'decimal',
'price' => 'decimal',
'Products__bought_price' => 'decimal',
'Products.bought_price' => 'decimal',
'bought_price' => 'decimal',
'Products__discount_percentage' => 'decimal',
'Products.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'Products__discount_value' => 'decimal',
'Products.discount_value' => 'decimal',
'discount_value' => 'decimal',
'Products__description' => 'text',
'Products.description' => 'text',
'description' => 'text',
'Products__brand_id' => 'biginteger',
'Products.brand_id' => 'biginteger',
'brand_id' => 'biginteger',
'Products__product_model_id' => 'biginteger',
'Products.product_model_id' => 'biginteger',
'product_model_id' => 'biginteger',
'Products__product_year' => 'integer',
'Products.product_year' => 'integer',
'product_year' => 'integer',
'Products__product_category_id' => 'biginteger',
'Products.product_category_id' => 'biginteger',
'product_category_id' => 'biginteger',
'Products__product_sub_category_id' => 'biginteger',
'Products.product_sub_category_id' => 'biginteger',
'product_sub_category_id' => 'biginteger',
'Products__product_super_sub_category_id' => 'biginteger',
'Products.product_super_sub_category_id' => 'biginteger',
'product_super_sub_category_id' => 'biginteger',
'Products__quantity' => 'integer',
'Products.quantity' => 'integer',
'quantity' => 'integer',
'Products__website_id' => 'biginteger',
'Products.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Products__vendor_id' => 'biginteger',
'Products.vendor_id' => 'biginteger',
'vendor_id' => 'biginteger',
'Products__vendor_item_approved' => 'tinyinteger',
'Products.vendor_item_approved' => 'tinyinteger',
'vendor_item_approved' => 'tinyinteger',
'Products__vendor_item_pre_approved' => 'tinyinteger',
'Products.vendor_item_pre_approved' => 'tinyinteger',
'vendor_item_pre_approved' => 'tinyinteger',
'Products__vendor_item_pre_approve_user_id' => 'biginteger',
'Products.vendor_item_pre_approve_user_id' => 'biginteger',
'vendor_item_pre_approve_user_id' => 'biginteger',
'Products__vendor_item_pre_approve_datetime' => 'datetime',
'Products.vendor_item_pre_approve_datetime' => 'datetime',
'vendor_item_pre_approve_datetime' => 'datetime',
'Products__featured_item' => 'tinyinteger',
'Products.featured_item' => 'tinyinteger',
'featured_item' => 'tinyinteger',
'Products__best_selling_item' => 'tinyinteger',
'Products.best_selling_item' => 'tinyinteger',
'best_selling_item' => 'tinyinteger',
'Products__delivery_method' => 'string',
'Products.delivery_method' => 'string',
'delivery_method' => 'string',
'Products__pickup' => 'tinyinteger',
'Products.pickup' => 'tinyinteger',
'pickup' => 'tinyinteger',
'Products__deliver' => 'tinyinteger',
'Products.deliver' => 'tinyinteger',
'deliver' => 'tinyinteger',
'Products__weight' => 'decimal',
'Products.weight' => 'decimal',
'weight' => 'decimal',
'Products__sort_order' => 'integer',
'Products.sort_order' => 'integer',
'sort_order' => 'integer',
'Products__free_delivery' => 'tinyinteger',
'Products.free_delivery' => 'tinyinteger',
'free_delivery' => 'tinyinteger',
'Products__free_international_delivery' => 'tinyinteger',
'Products.free_international_delivery' => 'tinyinteger',
'free_international_delivery' => 'tinyinteger',
'Products__stock_available' => 'tinyinteger',
'Products.stock_available' => 'tinyinteger',
'stock_available' => 'tinyinteger',
'Products__product_type' => 'string',
'Products.product_type' => 'string',
'product_type' => 'string',
'Products__parent_product_id' => 'biginteger',
'Products.parent_product_id' => 'biginteger',
'parent_product_id' => 'biginteger',
'Products__attr_color_id' => 'biginteger',
'Products.attr_color_id' => 'biginteger',
'attr_color_id' => 'biginteger',
'Products__attr_size_id' => 'biginteger',
'Products.attr_size_id' => 'biginteger',
'attr_size_id' => 'biginteger',
'Products__attr_material_id' => 'biginteger',
'Products.attr_material_id' => 'biginteger',
'attr_material_id' => 'biginteger',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__created_by' => 'biginteger',
'Products.created_by' => 'biginteger',
'created_by' => 'biginteger',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__modified_by' => 'biginteger',
'Products.modified_by' => 'biginteger',
'modified_by' => 'biginteger',
'Products__add_to_cart_text' => 'string',
'Products.add_to_cart_text' => 'string',
'add_to_cart_text' => 'string',
'Products__out_of_stock_text' => 'string',
'Products.out_of_stock_text' => 'string',
'out_of_stock_text' => 'string',
'Products__length' => 'decimal',
'Products.length' => 'decimal',
'length' => 'decimal',
'Products__width' => 'decimal',
'Products.width' => 'decimal',
'width' => 'decimal',
'Products__height' => 'decimal',
'Products.height' => 'decimal',
'height' => 'decimal',
'Products__volume' => 'string',
'Products.volume' => 'string',
'volume' => 'string',
'Products__active' => 'tinyinteger',
'Products.active' => 'tinyinteger',
'active' => 'tinyinteger',
'Products__custom_product_field_1_value' => 'string',
'Products.custom_product_field_1_value' => 'string',
'custom_product_field_1_value' => 'string',
'Products__custom_product_field_2_value' => 'string',
'Products.custom_product_field_2_value' => 'string',
'custom_product_field_2_value' => 'string',
'Products__custom_product_field_3_value' => 'string',
'Products.custom_product_field_3_value' => 'string',
'custom_product_field_3_value' => 'string',
'Products__custom_product_field_4_value' => 'string',
'Products.custom_product_field_4_value' => 'string',
'custom_product_field_4_value' => 'string',
'Products__custom_product_field_5_value' => 'string',
'Products.custom_product_field_5_value' => 'string',
'custom_product_field_5_value' => 'string',
'Products__district_id' => 'biginteger',
'Products.district_id' => 'biginteger',
'district_id' => 'biginteger',
'Products__city_id' => 'biginteger',
'Products.city_id' => 'biginteger',
'city_id' => 'biginteger',
'Products__shop_owner_commission_percentage' => 'decimal',
'Products.shop_owner_commission_percentage' => 'decimal',
'shop_owner_commission_percentage' => 'decimal',
'Products__website_price' => 'decimal',
'Products.website_price' => 'decimal',
'website_price' => 'decimal',
'Products__currency' => 'string',
'Products.currency' => 'string',
'currency' => 'string',
'Products__private_info' => 'text',
'Products.private_info' => 'text',
'private_info' => 'text',
'Products__attached_file' => 'proffer.file',
'Products.attached_file' => 'proffer.file',
'attached_file' => 'proffer.file',
'Products__attached_file_dir' => 'string',
'Products.attached_file_dir' => 'string',
'attached_file_dir' => 'string',
'Products__attached_file2' => 'proffer.file',
'Products.attached_file2' => 'proffer.file',
'attached_file2' => 'proffer.file',
'Products__attached_file_dir2' => 'string',
'Products.attached_file_dir2' => 'string',
'attached_file_dir2' => 'string',
'Products__size_chart' => 'proffer.file',
'Products.size_chart' => 'proffer.file',
'size_chart' => 'proffer.file',
'Products__size_chart_dir' => 'string',
'Products.size_chart_dir' => 'string',
'size_chart_dir' => 'string',
'Products__seo_url' => 'string',
'Products.seo_url' => 'string',
'seo_url' => 'string',
'Products__contact_name' => 'string',
'Products.contact_name' => 'string',
'contact_name' => 'string',
'Products__contact_mobile' => 'string',
'Products.contact_mobile' => 'string',
'contact_mobile' => 'string',
'Products__contact_whatsapp' => 'string',
'Products.contact_whatsapp' => 'string',
'contact_whatsapp' => 'string',
'Products__view_count' => 'biginteger',
'Products.view_count' => 'biginteger',
'view_count' => 'biginteger',
'ProductCategories__id' => 'biginteger',
'ProductCategories.id' => 'biginteger',
'ProductCategories__name' => 'string',
'ProductCategories.name' => 'string',
'ProductCategories__photo' => 'proffer.file',
'ProductCategories.photo' => 'proffer.file',
'photo' => 'proffer.file',
'ProductCategories__photo_dir' => 'string',
'ProductCategories.photo_dir' => 'string',
'photo_dir' => 'string',
'ProductCategories__large_photo' => 'proffer.file',
'ProductCategories.large_photo' => 'proffer.file',
'large_photo' => 'proffer.file',
'ProductCategories__large_photo_dir' => 'string',
'ProductCategories.large_photo_dir' => 'string',
'large_photo_dir' => 'string',
'ProductCategories__discount_percentage' => 'decimal',
'ProductCategories.discount_percentage' => 'decimal',
'ProductCategories__discount_value' => 'decimal',
'ProductCategories.discount_value' => 'decimal',
'ProductCategories__website_id' => 'biginteger',
'ProductCategories.website_id' => 'biginteger',
'ProductCategories__created' => 'datetime',
'ProductCategories.created' => 'datetime',
'ProductCategories__created_by' => 'biginteger',
'ProductCategories.created_by' => 'biginteger',
'ProductCategories__modified' => 'datetime',
'ProductCategories.modified' => 'datetime',
'ProductCategories__modified_by' => 'biginteger',
'ProductCategories.modified_by' => 'biginteger',
'ProductCategories__sort_order' => 'integer',
'ProductCategories.sort_order' => 'integer',
'ProductCategories__enabled' => 'integer',
'ProductCategories.enabled' => 'integer',
'enabled' => 'integer',
'ProductCategories__show_in_home_page' => 'integer',
'ProductCategories.show_in_home_page' => 'integer',
'show_in_home_page' => 'integer',
'ProductCategories__custom_field_1_label' => 'string',
'ProductCategories.custom_field_1_label' => 'string',
'custom_field_1_label' => 'string',
'ProductCategories__custom_field_2_label' => 'string',
'ProductCategories.custom_field_2_label' => 'string',
'custom_field_2_label' => 'string',
'ProductCategories__custom_field_3_label' => 'string',
'ProductCategories.custom_field_3_label' => 'string',
'custom_field_3_label' => 'string',
'ProductCategories__custom_field_4_label' => 'string',
'ProductCategories.custom_field_4_label' => 'string',
'custom_field_4_label' => 'string',
'ProductCategories__custom_field_5_label' => 'string',
'ProductCategories.custom_field_5_label' => 'string',
'custom_field_5_label' => 'string',
'ProductSubCategories__id' => 'biginteger',
'ProductSubCategories.id' => 'biginteger',
'ProductSubCategories__name' => 'string',
'ProductSubCategories.name' => 'string',
'ProductSubCategories__description' => 'string',
'ProductSubCategories.description' => 'string',
'ProductSubCategories__product_category_id' => 'biginteger',
'ProductSubCategories.product_category_id' => 'biginteger',
'ProductSubCategories__discount_percentage' => 'decimal',
'ProductSubCategories.discount_percentage' => 'decimal',
'ProductSubCategories__discount_value' => 'decimal',
'ProductSubCategories.discount_value' => 'decimal',
'ProductSubCategories__website_id' => 'biginteger',
'ProductSubCategories.website_id' => 'biginteger',
'ProductSubCategories__photo' => 'proffer.file',
'ProductSubCategories.photo' => 'proffer.file',
'ProductSubCategories__photo_dir' => 'string',
'ProductSubCategories.photo_dir' => 'string',
'ProductSubCategories__created' => 'datetime',
'ProductSubCategories.created' => 'datetime',
'ProductSubCategories__created_by' => 'biginteger',
'ProductSubCategories.created_by' => 'biginteger',
'ProductSubCategories__modified' => 'datetime',
'ProductSubCategories.modified' => 'datetime',
'ProductSubCategories__modified_by' => 'biginteger',
'ProductSubCategories.modified_by' => 'biginteger',
'ProductSubCategories__custom_field_1_label' => 'string',
'ProductSubCategories.custom_field_1_label' => 'string',
'ProductSubCategories__custom_field_2_label' => 'string',
'ProductSubCategories.custom_field_2_label' => 'string',
'ProductSubCategories__custom_field_3_label' => 'string',
'ProductSubCategories.custom_field_3_label' => 'string',
'ProductSubCategories__custom_field_4_label' => 'string',
'ProductSubCategories.custom_field_4_label' => 'string',
'ProductSubCategories__custom_field_5_label' => 'string',
'ProductSubCategories.custom_field_5_label' => 'string',
'ProductSuperSubCategories__id' => 'biginteger',
'ProductSuperSubCategories.id' => 'biginteger',
'ProductSuperSubCategories__product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories.product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories__website_id' => 'biginteger',
'ProductSuperSubCategories.website_id' => 'biginteger',
'ProductSuperSubCategories__discount_percentage' => 'decimal',
'ProductSuperSubCategories.discount_percentage' => 'decimal',
'ProductSuperSubCategories__discount_value' => 'decimal',
'ProductSuperSubCategories.discount_value' => 'decimal',
'ProductSuperSubCategories__name' => 'string',
'ProductSuperSubCategories.name' => 'string',
'ProductSuperSubCategories__photo' => 'proffer.file',
'ProductSuperSubCategories.photo' => 'proffer.file',
'ProductSuperSubCategories__photo_dir' => 'string',
'ProductSuperSubCategories.photo_dir' => 'string',
'ProductSuperSubCategories__created' => 'datetime',
'ProductSuperSubCategories.created' => 'datetime',
'ProductSuperSubCategories__created_by' => 'biginteger',
'ProductSuperSubCategories.created_by' => 'biginteger',
'ProductSuperSubCategories__modified' => 'datetime',
'ProductSuperSubCategories.modified' => 'datetime',
'ProductSuperSubCategories__modified_by' => 'biginteger',
'ProductSuperSubCategories.modified_by' => 'biginteger',
'ProductSuperSubCategories__custom_field_1_label' => 'string',
'ProductSuperSubCategories.custom_field_1_label' => 'string',
'ProductSuperSubCategories__custom_field_2_label' => 'string',
'ProductSuperSubCategories.custom_field_2_label' => 'string',
'ProductSuperSubCategories__custom_field_3_label' => 'string',
'ProductSuperSubCategories.custom_field_3_label' => 'string',
'ProductSuperSubCategories__custom_field_4_label' => 'string',
'ProductSuperSubCategories.custom_field_4_label' => 'string',
'ProductSuperSubCategories__custom_field_5_label' => 'string',
'ProductSuperSubCategories.custom_field_5_label' => 'string',
'Brands__id' => 'biginteger',
'Brands.id' => 'biginteger',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__photo' => 'proffer.file',
'Brands.photo' => 'proffer.file',
'Brands__photo_dir' => 'string',
'Brands.photo_dir' => 'string',
'Brands__website_id' => 'biginteger',
'Brands.website_id' => 'biginteger',
'Brands__discount_percentage' => 'decimal',
'Brands.discount_percentage' => 'decimal',
'Brands__discount_value' => 'decimal',
'Brands.discount_value' => 'decimal',
'ProductImages__id' => 'biginteger',
'ProductImages.id' => 'biginteger',
'ProductImages__photo' => 'proffer.file',
'ProductImages.photo' => 'proffer.file',
'ProductImages__photo_dir' => 'string',
'ProductImages.photo_dir' => 'string',
'ProductImages__product_id' => 'biginteger',
'ProductImages.product_id' => 'biginteger',
'product_id' => 'biginteger',
'ProductImages__is_default' => 'tinyinteger',
'ProductImages.is_default' => 'tinyinteger',
'is_default' => 'tinyinteger'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'ProductCategories' => [
[maximum depth reached]
],
'ProductSubCategories' => [
[maximum depth reached]
],
'ProductSuperSubCategories' => [
[maximum depth reached]
],
'Brands' => [
[maximum depth reached]
],
'ProductImages' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$newlyArrivedProducts = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.name AS `Products__name`, Products.price AS `Products__price`, Products.bought_price AS `Products__bought_price`, Products.discount_percentage AS `Products__discount_percentage`, Products.discount_value AS `Products__discount_value`, Products.description AS `Products__description`, Products.brand_id AS `Products__brand_id`, Products.product_model_id AS `Products__product_model_id`, Products.product_year AS `Products__product_year`, Products.product_category_id AS `Products__product_category_id`, Products.product_sub_category_id AS `Products__product_sub_category_id`, Products.product_super_sub_category_id AS `Products__product_super_sub_category_id`, Products.quantity AS `Products__quantity`, Products.website_id AS `Products__website_id`, Products.vendor_id AS `Products__vendor_id`, Products.vendor_item_approved AS `Products__vendor_item_approved`, Products.vendor_item_pre_approved AS `Products__vendor_item_pre_approved`, Products.vendor_item_pre_approve_user_id AS `Products__vendor_item_pre_approve_user_id`, Products.vendor_item_pre_approve_datetime AS `Products__vendor_item_pre_approve_datetime`, Products.featured_item AS `Products__featured_item`, Products.best_selling_item AS `Products__best_selling_item`, Products.delivery_method AS `Products__delivery_method`, Products.pickup AS `Products__pickup`, Products.deliver AS `Products__deliver`, Products.weight AS `Products__weight`, Products.sort_order AS `Products__sort_order`, Products.free_delivery AS `Products__free_delivery`, Products.free_international_delivery AS `Products__free_international_delivery`, Products.stock_available AS `Products__stock_available`, Products.product_type AS `Products__product_type`, Products.parent_product_id AS `Products__parent_product_id`, Products.attr_color_id AS `Products__attr_color_id`, Products.attr_size_id AS `Products__attr_size_id`, Products.attr_material_id AS `Products__attr_material_id`, Products.created AS `Products__created`, Products.created_by AS `Products__created_by`, Products.modified AS `Products__modified`, Products.modified_by AS `Products__modified_by`, Products.add_to_cart_text AS `Products__add_to_cart_text`, Products.out_of_stock_text AS `Products__out_of_stock_text`, Products.length AS `Products__length`, Products.width AS `Products__width`, Products.height AS `Products__height`, Products.volume AS `Products__volume`, Products.active AS `Products__active`, Products.custom_product_field_1_value AS `Products__custom_product_field_1_value`, Products.custom_product_field_2_value AS `Products__custom_product_field_2_value`, Products.custom_product_field_3_value AS `Products__custom_product_field_3_value`, Products.custom_product_field_4_value AS `Products__custom_product_field_4_value`, Products.custom_product_field_5_value AS `Products__custom_product_field_5_value`, Products.district_id AS `Products__district_id`, Products.city_id AS `Products__city_id`, Products.shop_owner_commission_percentage AS `Products__shop_owner_commission_percentage`, Products.website_price AS `Products__website_price`, Products.currency AS `Products__currency`, Products.private_info AS `Products__private_info`, Products.attached_file AS `Products__attached_file`, Products.attached_file_dir AS `Products__attached_file_dir`, Products.attached_file2 AS `Products__attached_file2`, Products.attached_file_dir2 AS `Products__attached_file_dir2`, Products.size_chart AS `Products__size_chart`, Products.size_chart_dir AS `Products__size_chart_dir`, Products.seo_url AS `Products__seo_url`, Products.contact_name AS `Products__contact_name`, Products.contact_mobile AS `Products__contact_mobile`, Products.contact_whatsapp AS `Products__contact_whatsapp`, Products.view_count AS `Products__view_count`, ProductCategories.id AS `ProductCategories__id`, ProductCategories.discount_percentage AS `ProductCategories__discount_percentage`, ProductCategories.discount_value AS `ProductCategories__discount_value`, ProductSubCategories.id AS `ProductSubCategories__id`, ProductSubCategories.discount_percentage AS `ProductSubCategories__discount_percentage`, ProductSubCategories.discount_value AS `ProductSubCategories__discount_value`, ProductSuperSubCategories.id AS `ProductSuperSubCategories__id`, ProductSuperSubCategories.discount_percentage AS `ProductSuperSubCategories__discount_percentage`, ProductSuperSubCategories.discount_value AS `ProductSuperSubCategories__discount_value`, Brands.id AS `Brands__id`, Brands.name AS `Brands__name`, Brands.discount_percentage AS `Brands__discount_percentage`, Brands.discount_value AS `Brands__discount_value` FROM products Products LEFT JOIN product_categories ProductCategories ON ProductCategories.id = (Products.product_category_id) LEFT JOIN product_sub_categories ProductSubCategories ON ProductSubCategories.id = (Products.product_sub_category_id) LEFT JOIN product_super_sub_categories ProductSuperSubCategories ON ProductSuperSubCategories.id = (Products.product_super_sub_category_id) LEFT JOIN brands Brands ON Brands.id = (Products.brand_id) WHERE (Products.website_id = :c0 AND Products.active = :c1 AND Products.quantity > :c2 AND (Products.product_type = :c3 OR Products.product_type = :c4 OR Products.product_type = :c5)) ORDER BY Products.id DESC LIMIT 5',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Products__id' => 'biginteger',
'Products.id' => 'biginteger',
'id' => 'biginteger',
'Products__sku' => 'string',
'Products.sku' => 'string',
'sku' => 'string',
'Products__name' => 'string',
'Products.name' => 'string',
'name' => 'string',
'Products__price' => 'decimal',
'Products.price' => 'decimal',
'price' => 'decimal',
'Products__bought_price' => 'decimal',
'Products.bought_price' => 'decimal',
'bought_price' => 'decimal',
'Products__discount_percentage' => 'decimal',
'Products.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'Products__discount_value' => 'decimal',
'Products.discount_value' => 'decimal',
'discount_value' => 'decimal',
'Products__description' => 'text',
'Products.description' => 'text',
'description' => 'text',
'Products__brand_id' => 'biginteger',
'Products.brand_id' => 'biginteger',
'brand_id' => 'biginteger',
'Products__product_model_id' => 'biginteger',
'Products.product_model_id' => 'biginteger',
'product_model_id' => 'biginteger',
'Products__product_year' => 'integer',
'Products.product_year' => 'integer',
'product_year' => 'integer',
'Products__product_category_id' => 'biginteger',
'Products.product_category_id' => 'biginteger',
'product_category_id' => 'biginteger',
'Products__product_sub_category_id' => 'biginteger',
'Products.product_sub_category_id' => 'biginteger',
'product_sub_category_id' => 'biginteger',
'Products__product_super_sub_category_id' => 'biginteger',
'Products.product_super_sub_category_id' => 'biginteger',
'product_super_sub_category_id' => 'biginteger',
'Products__quantity' => 'integer',
'Products.quantity' => 'integer',
'quantity' => 'integer',
'Products__website_id' => 'biginteger',
'Products.website_id' => 'biginteger',
'website_id' => 'biginteger',
'Products__vendor_id' => 'biginteger',
'Products.vendor_id' => 'biginteger',
'vendor_id' => 'biginteger',
'Products__vendor_item_approved' => 'tinyinteger',
'Products.vendor_item_approved' => 'tinyinteger',
'vendor_item_approved' => 'tinyinteger',
'Products__vendor_item_pre_approved' => 'tinyinteger',
'Products.vendor_item_pre_approved' => 'tinyinteger',
'vendor_item_pre_approved' => 'tinyinteger',
'Products__vendor_item_pre_approve_user_id' => 'biginteger',
'Products.vendor_item_pre_approve_user_id' => 'biginteger',
'vendor_item_pre_approve_user_id' => 'biginteger',
'Products__vendor_item_pre_approve_datetime' => 'datetime',
'Products.vendor_item_pre_approve_datetime' => 'datetime',
'vendor_item_pre_approve_datetime' => 'datetime',
'Products__featured_item' => 'tinyinteger',
'Products.featured_item' => 'tinyinteger',
'featured_item' => 'tinyinteger',
'Products__best_selling_item' => 'tinyinteger',
'Products.best_selling_item' => 'tinyinteger',
'best_selling_item' => 'tinyinteger',
'Products__delivery_method' => 'string',
'Products.delivery_method' => 'string',
'delivery_method' => 'string',
'Products__pickup' => 'tinyinteger',
'Products.pickup' => 'tinyinteger',
'pickup' => 'tinyinteger',
'Products__deliver' => 'tinyinteger',
'Products.deliver' => 'tinyinteger',
'deliver' => 'tinyinteger',
'Products__weight' => 'decimal',
'Products.weight' => 'decimal',
'weight' => 'decimal',
'Products__sort_order' => 'integer',
'Products.sort_order' => 'integer',
'sort_order' => 'integer',
'Products__free_delivery' => 'tinyinteger',
'Products.free_delivery' => 'tinyinteger',
'free_delivery' => 'tinyinteger',
'Products__free_international_delivery' => 'tinyinteger',
'Products.free_international_delivery' => 'tinyinteger',
'free_international_delivery' => 'tinyinteger',
'Products__stock_available' => 'tinyinteger',
'Products.stock_available' => 'tinyinteger',
'stock_available' => 'tinyinteger',
'Products__product_type' => 'string',
'Products.product_type' => 'string',
'product_type' => 'string',
'Products__parent_product_id' => 'biginteger',
'Products.parent_product_id' => 'biginteger',
'parent_product_id' => 'biginteger',
'Products__attr_color_id' => 'biginteger',
'Products.attr_color_id' => 'biginteger',
'attr_color_id' => 'biginteger',
'Products__attr_size_id' => 'biginteger',
'Products.attr_size_id' => 'biginteger',
'attr_size_id' => 'biginteger',
'Products__attr_material_id' => 'biginteger',
'Products.attr_material_id' => 'biginteger',
'attr_material_id' => 'biginteger',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__created_by' => 'biginteger',
'Products.created_by' => 'biginteger',
'created_by' => 'biginteger',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__modified_by' => 'biginteger',
'Products.modified_by' => 'biginteger',
'modified_by' => 'biginteger',
'Products__add_to_cart_text' => 'string',
'Products.add_to_cart_text' => 'string',
'add_to_cart_text' => 'string',
'Products__out_of_stock_text' => 'string',
'Products.out_of_stock_text' => 'string',
'out_of_stock_text' => 'string',
'Products__length' => 'decimal',
'Products.length' => 'decimal',
'length' => 'decimal',
'Products__width' => 'decimal',
'Products.width' => 'decimal',
'width' => 'decimal',
'Products__height' => 'decimal',
'Products.height' => 'decimal',
'height' => 'decimal',
'Products__volume' => 'string',
'Products.volume' => 'string',
'volume' => 'string',
'Products__active' => 'tinyinteger',
'Products.active' => 'tinyinteger',
'active' => 'tinyinteger',
'Products__custom_product_field_1_value' => 'string',
'Products.custom_product_field_1_value' => 'string',
'custom_product_field_1_value' => 'string',
'Products__custom_product_field_2_value' => 'string',
'Products.custom_product_field_2_value' => 'string',
'custom_product_field_2_value' => 'string',
'Products__custom_product_field_3_value' => 'string',
'Products.custom_product_field_3_value' => 'string',
'custom_product_field_3_value' => 'string',
'Products__custom_product_field_4_value' => 'string',
'Products.custom_product_field_4_value' => 'string',
'custom_product_field_4_value' => 'string',
'Products__custom_product_field_5_value' => 'string',
'Products.custom_product_field_5_value' => 'string',
'custom_product_field_5_value' => 'string',
'Products__district_id' => 'biginteger',
'Products.district_id' => 'biginteger',
'district_id' => 'biginteger',
'Products__city_id' => 'biginteger',
'Products.city_id' => 'biginteger',
'city_id' => 'biginteger',
'Products__shop_owner_commission_percentage' => 'decimal',
'Products.shop_owner_commission_percentage' => 'decimal',
'shop_owner_commission_percentage' => 'decimal',
'Products__website_price' => 'decimal',
'Products.website_price' => 'decimal',
'website_price' => 'decimal',
'Products__currency' => 'string',
'Products.currency' => 'string',
'currency' => 'string',
'Products__private_info' => 'text',
'Products.private_info' => 'text',
'private_info' => 'text',
'Products__attached_file' => 'proffer.file',
'Products.attached_file' => 'proffer.file',
'attached_file' => 'proffer.file',
'Products__attached_file_dir' => 'string',
'Products.attached_file_dir' => 'string',
'attached_file_dir' => 'string',
'Products__attached_file2' => 'proffer.file',
'Products.attached_file2' => 'proffer.file',
'attached_file2' => 'proffer.file',
'Products__attached_file_dir2' => 'string',
'Products.attached_file_dir2' => 'string',
'attached_file_dir2' => 'string',
'Products__size_chart' => 'proffer.file',
'Products.size_chart' => 'proffer.file',
'size_chart' => 'proffer.file',
'Products__size_chart_dir' => 'string',
'Products.size_chart_dir' => 'string',
'size_chart_dir' => 'string',
'Products__seo_url' => 'string',
'Products.seo_url' => 'string',
'seo_url' => 'string',
'Products__contact_name' => 'string',
'Products.contact_name' => 'string',
'contact_name' => 'string',
'Products__contact_mobile' => 'string',
'Products.contact_mobile' => 'string',
'contact_mobile' => 'string',
'Products__contact_whatsapp' => 'string',
'Products.contact_whatsapp' => 'string',
'contact_whatsapp' => 'string',
'Products__view_count' => 'biginteger',
'Products.view_count' => 'biginteger',
'view_count' => 'biginteger',
'ProductCategories__id' => 'biginteger',
'ProductCategories.id' => 'biginteger',
'ProductCategories__name' => 'string',
'ProductCategories.name' => 'string',
'ProductCategories__photo' => 'proffer.file',
'ProductCategories.photo' => 'proffer.file',
'photo' => 'proffer.file',
'ProductCategories__photo_dir' => 'string',
'ProductCategories.photo_dir' => 'string',
'photo_dir' => 'string',
'ProductCategories__large_photo' => 'proffer.file',
'ProductCategories.large_photo' => 'proffer.file',
'large_photo' => 'proffer.file',
'ProductCategories__large_photo_dir' => 'string',
'ProductCategories.large_photo_dir' => 'string',
'large_photo_dir' => 'string',
'ProductCategories__discount_percentage' => 'decimal',
'ProductCategories.discount_percentage' => 'decimal',
'ProductCategories__discount_value' => 'decimal',
'ProductCategories.discount_value' => 'decimal',
'ProductCategories__website_id' => 'biginteger',
'ProductCategories.website_id' => 'biginteger',
'ProductCategories__created' => 'datetime',
'ProductCategories.created' => 'datetime',
'ProductCategories__created_by' => 'biginteger',
'ProductCategories.created_by' => 'biginteger',
'ProductCategories__modified' => 'datetime',
'ProductCategories.modified' => 'datetime',
'ProductCategories__modified_by' => 'biginteger',
'ProductCategories.modified_by' => 'biginteger',
'ProductCategories__sort_order' => 'integer',
'ProductCategories.sort_order' => 'integer',
'ProductCategories__enabled' => 'integer',
'ProductCategories.enabled' => 'integer',
'enabled' => 'integer',
'ProductCategories__show_in_home_page' => 'integer',
'ProductCategories.show_in_home_page' => 'integer',
'show_in_home_page' => 'integer',
'ProductCategories__custom_field_1_label' => 'string',
'ProductCategories.custom_field_1_label' => 'string',
'custom_field_1_label' => 'string',
'ProductCategories__custom_field_2_label' => 'string',
'ProductCategories.custom_field_2_label' => 'string',
'custom_field_2_label' => 'string',
'ProductCategories__custom_field_3_label' => 'string',
'ProductCategories.custom_field_3_label' => 'string',
'custom_field_3_label' => 'string',
'ProductCategories__custom_field_4_label' => 'string',
'ProductCategories.custom_field_4_label' => 'string',
'custom_field_4_label' => 'string',
'ProductCategories__custom_field_5_label' => 'string',
'ProductCategories.custom_field_5_label' => 'string',
'custom_field_5_label' => 'string',
'ProductSubCategories__id' => 'biginteger',
'ProductSubCategories.id' => 'biginteger',
'ProductSubCategories__name' => 'string',
'ProductSubCategories.name' => 'string',
'ProductSubCategories__description' => 'string',
'ProductSubCategories.description' => 'string',
'ProductSubCategories__product_category_id' => 'biginteger',
'ProductSubCategories.product_category_id' => 'biginteger',
'ProductSubCategories__discount_percentage' => 'decimal',
'ProductSubCategories.discount_percentage' => 'decimal',
'ProductSubCategories__discount_value' => 'decimal',
'ProductSubCategories.discount_value' => 'decimal',
'ProductSubCategories__website_id' => 'biginteger',
'ProductSubCategories.website_id' => 'biginteger',
'ProductSubCategories__photo' => 'proffer.file',
'ProductSubCategories.photo' => 'proffer.file',
'ProductSubCategories__photo_dir' => 'string',
'ProductSubCategories.photo_dir' => 'string',
'ProductSubCategories__created' => 'datetime',
'ProductSubCategories.created' => 'datetime',
'ProductSubCategories__created_by' => 'biginteger',
'ProductSubCategories.created_by' => 'biginteger',
'ProductSubCategories__modified' => 'datetime',
'ProductSubCategories.modified' => 'datetime',
'ProductSubCategories__modified_by' => 'biginteger',
'ProductSubCategories.modified_by' => 'biginteger',
'ProductSubCategories__custom_field_1_label' => 'string',
'ProductSubCategories.custom_field_1_label' => 'string',
'ProductSubCategories__custom_field_2_label' => 'string',
'ProductSubCategories.custom_field_2_label' => 'string',
'ProductSubCategories__custom_field_3_label' => 'string',
'ProductSubCategories.custom_field_3_label' => 'string',
'ProductSubCategories__custom_field_4_label' => 'string',
'ProductSubCategories.custom_field_4_label' => 'string',
'ProductSubCategories__custom_field_5_label' => 'string',
'ProductSubCategories.custom_field_5_label' => 'string',
'ProductSuperSubCategories__id' => 'biginteger',
'ProductSuperSubCategories.id' => 'biginteger',
'ProductSuperSubCategories__product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories.product_sub_category_id' => 'biginteger',
'ProductSuperSubCategories__website_id' => 'biginteger',
'ProductSuperSubCategories.website_id' => 'biginteger',
'ProductSuperSubCategories__discount_percentage' => 'decimal',
'ProductSuperSubCategories.discount_percentage' => 'decimal',
'ProductSuperSubCategories__discount_value' => 'decimal',
'ProductSuperSubCategories.discount_value' => 'decimal',
'ProductSuperSubCategories__name' => 'string',
'ProductSuperSubCategories.name' => 'string',
'ProductSuperSubCategories__photo' => 'proffer.file',
'ProductSuperSubCategories.photo' => 'proffer.file',
'ProductSuperSubCategories__photo_dir' => 'string',
'ProductSuperSubCategories.photo_dir' => 'string',
'ProductSuperSubCategories__created' => 'datetime',
'ProductSuperSubCategories.created' => 'datetime',
'ProductSuperSubCategories__created_by' => 'biginteger',
'ProductSuperSubCategories.created_by' => 'biginteger',
'ProductSuperSubCategories__modified' => 'datetime',
'ProductSuperSubCategories.modified' => 'datetime',
'ProductSuperSubCategories__modified_by' => 'biginteger',
'ProductSuperSubCategories.modified_by' => 'biginteger',
'ProductSuperSubCategories__custom_field_1_label' => 'string',
'ProductSuperSubCategories.custom_field_1_label' => 'string',
'ProductSuperSubCategories__custom_field_2_label' => 'string',
'ProductSuperSubCategories.custom_field_2_label' => 'string',
'ProductSuperSubCategories__custom_field_3_label' => 'string',
'ProductSuperSubCategories.custom_field_3_label' => 'string',
'ProductSuperSubCategories__custom_field_4_label' => 'string',
'ProductSuperSubCategories.custom_field_4_label' => 'string',
'ProductSuperSubCategories__custom_field_5_label' => 'string',
'ProductSuperSubCategories.custom_field_5_label' => 'string',
'Brands__id' => 'biginteger',
'Brands.id' => 'biginteger',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__photo' => 'proffer.file',
'Brands.photo' => 'proffer.file',
'Brands__photo_dir' => 'string',
'Brands.photo_dir' => 'string',
'Brands__website_id' => 'biginteger',
'Brands.website_id' => 'biginteger',
'Brands__discount_percentage' => 'decimal',
'Brands.discount_percentage' => 'decimal',
'Brands__discount_value' => 'decimal',
'Brands.discount_value' => 'decimal',
'ProductImages__id' => 'biginteger',
'ProductImages.id' => 'biginteger',
'ProductImages__photo' => 'proffer.file',
'ProductImages.photo' => 'proffer.file',
'ProductImages__photo_dir' => 'string',
'ProductImages.photo_dir' => 'string',
'ProductImages__product_id' => 'biginteger',
'ProductImages.product_id' => 'biginteger',
'product_id' => 'biginteger',
'ProductImages__is_default' => 'tinyinteger',
'ProductImages.is_default' => 'tinyinteger',
'is_default' => 'tinyinteger'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'ProductCategories' => [
[maximum depth reached]
],
'ProductSubCategories' => [
[maximum depth reached]
],
'ProductSuperSubCategories' => [
[maximum depth reached]
],
'Brands' => [
[maximum depth reached]
],
'ProductImages' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$categoriesWithProducts = []
$productCategories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT ProductCategories.id AS `ProductCategories__id`, ProductCategories.name AS `ProductCategories__name`, ProductCategories.photo AS `ProductCategories__photo`, ProductCategories.photo_dir AS `ProductCategories__photo_dir`, ProductCategories.large_photo AS `ProductCategories__large_photo`, ProductCategories.large_photo_dir AS `ProductCategories__large_photo_dir`, ProductCategories.enabled AS `ProductCategories__enabled`, ProductCategories.show_in_home_page AS `ProductCategories__show_in_home_page`, ProductCategories.custom_field_1_label AS `ProductCategories__custom_field_1_label`, ProductCategories.custom_field_2_label AS `ProductCategories__custom_field_2_label`, ProductCategories.custom_field_3_label AS `ProductCategories__custom_field_3_label`, ProductCategories.custom_field_4_label AS `ProductCategories__custom_field_4_label`, ProductCategories.custom_field_5_label AS `ProductCategories__custom_field_5_label` FROM product_categories ProductCategories WHERE (ProductCategories.website_id = :c0 AND ProductCategories.enabled = :c1) ORDER BY ProductCategories.sort_order DESC, ProductCategories.id DESC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'ProductCategories__id' => 'biginteger',
'ProductCategories.id' => 'biginteger',
'id' => 'biginteger',
'ProductCategories__name' => 'string',
'ProductCategories.name' => 'string',
'name' => 'string',
'ProductCategories__photo' => 'proffer.file',
'ProductCategories.photo' => 'proffer.file',
'photo' => 'proffer.file',
'ProductCategories__photo_dir' => 'string',
'ProductCategories.photo_dir' => 'string',
'photo_dir' => 'string',
'ProductCategories__large_photo' => 'proffer.file',
'ProductCategories.large_photo' => 'proffer.file',
'large_photo' => 'proffer.file',
'ProductCategories__large_photo_dir' => 'string',
'ProductCategories.large_photo_dir' => 'string',
'large_photo_dir' => 'string',
'ProductCategories__discount_percentage' => 'decimal',
'ProductCategories.discount_percentage' => 'decimal',
'discount_percentage' => 'decimal',
'ProductCategories__discount_value' => 'decimal',
'ProductCategories.discount_value' => 'decimal',
'discount_value' => 'decimal',
'ProductCategories__website_id' => 'biginteger',
'ProductCategories.website_id' => 'biginteger',
'website_id' => 'biginteger',
'ProductCategories__created' => 'datetime',
'ProductCategories.created' => 'datetime',
'created' => 'datetime',
'ProductCategories__created_by' => 'biginteger',
'ProductCategories.created_by' => 'biginteger',
'created_by' => 'biginteger',
'ProductCategories__modified' => 'datetime',
'ProductCategories.modified' => 'datetime',
'modified' => 'datetime',
'ProductCategories__modified_by' => 'biginteger',
'ProductCategories.modified_by' => 'biginteger',
'modified_by' => 'biginteger',
'ProductCategories__sort_order' => 'integer',
'ProductCategories.sort_order' => 'integer',
'sort_order' => 'integer',
'ProductCategories__enabled' => 'integer',
'ProductCategories.enabled' => 'integer',
'enabled' => 'integer',
'ProductCategories__show_in_home_page' => 'integer',
'ProductCategories.show_in_home_page' => 'integer',
'show_in_home_page' => 'integer',
'ProductCategories__custom_field_1_label' => 'string',
'ProductCategories.custom_field_1_label' => 'string',
'custom_field_1_label' => 'string',
'ProductCategories__custom_field_2_label' => 'string',
'ProductCategories.custom_field_2_label' => 'string',
'custom_field_2_label' => 'string',
'ProductCategories__custom_field_3_label' => 'string',
'ProductCategories.custom_field_3_label' => 'string',
'custom_field_3_label' => 'string',
'ProductCategories__custom_field_4_label' => 'string',
'ProductCategories.custom_field_4_label' => 'string',
'custom_field_4_label' => 'string',
'ProductCategories__custom_field_5_label' => 'string',
'ProductCategories.custom_field_5_label' => 'string',
'custom_field_5_label' => 'string',
'ProductSubCategories__id' => 'biginteger',
'ProductSubCategories.id' => 'biginteger',
'ProductSubCategories__name' => 'string',
'ProductSubCategories.name' => 'string',
'ProductSubCategories__description' => 'string',
'ProductSubCategories.description' => 'string',
'description' => 'string',
'ProductSubCategories__product_category_id' => 'biginteger',
'ProductSubCategories.product_category_id' => 'biginteger',
'product_category_id' => 'biginteger',
'ProductSubCategories__discount_percentage' => 'decimal',
'ProductSubCategories.discount_percentage' => 'decimal',
'ProductSubCategories__discount_value' => 'decimal',
'ProductSubCategories.discount_value' => 'decimal',
'ProductSubCategories__website_id' => 'biginteger',
'ProductSubCategories.website_id' => 'biginteger',
'ProductSubCategories__photo' => 'proffer.file',
'ProductSubCategories.photo' => 'proffer.file',
'ProductSubCategories__photo_dir' => 'string',
'ProductSubCategories.photo_dir' => 'string',
'ProductSubCategories__created' => 'datetime',
'ProductSubCategories.created' => 'datetime',
'ProductSubCategories__created_by' => 'biginteger',
'ProductSubCategories.created_by' => 'biginteger',
'ProductSubCategories__modified' => 'datetime',
'ProductSubCategories.modified' => 'datetime',
'ProductSubCategories__modified_by' => 'biginteger',
'ProductSubCategories.modified_by' => 'biginteger',
'ProductSubCategories__custom_field_1_label' => 'string',
'ProductSubCategories.custom_field_1_label' => 'string',
'ProductSubCategories__custom_field_2_label' => 'string',
'ProductSubCategories.custom_field_2_label' => 'string',
'ProductSubCategories__custom_field_3_label' => 'string',
'ProductSubCategories.custom_field_3_label' => 'string',
'ProductSubCategories__custom_field_4_label' => 'string',
'ProductSubCategories.custom_field_4_label' => 'string',
'ProductSubCategories__custom_field_5_label' => 'string',
'ProductSubCategories.custom_field_5_label' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'ProductSubCategories' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductCategoriesTable) {}
}
$selectedProductCategoryId = null
$selectedProductSubCategoryId = null
$selectedProductSuperSubCategoryId = null
$selectedDistrictId = null
$productCategoryCustomFieldLabels = [
'website_labels' => [
(int) 182 => [
(int) 1 => null,
(int) 2 => null,
(int) 3 => null,
(int) 4 => null,
(int) 5 => null
]
],
'category_labels' => [],
'sub_category_labels' => [],
'super_sub_category_labels' => []
]
$viewElements = [
(int) 1 => 'header_1',
(int) 2 => 'header_2',
(int) 3 => 'slider_1',
(int) 4 => 'slider_2',
(int) 5 => 'header_text_based_custom',
(int) 6 => 'slider_brand_model_year_form',
(int) 7 => 'login_classified'
]
$isEcommerce = false
$countries = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Countries.id AS `Countries__id`, Countries.name AS `Countries__name` FROM countries Countries WHERE Countries.name = :c0',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Countries__id' => 'biginteger',
'Countries.id' => 'biginteger',
'id' => 'biginteger',
'Countries__country_code' => 'string',
'Countries.country_code' => 'string',
'country_code' => 'string',
'Countries__short_code' => 'string',
'Countries.short_code' => 'string',
'short_code' => 'string',
'Countries__name' => 'string',
'Countries.name' => 'string',
'name' => 'string',
'Countries__air_mail_zone' => 'string',
'Countries.air_mail_zone' => 'string',
'air_mail_zone' => 'string',
'Countries__ems_zone' => 'string',
'Countries.ems_zone' => 'string',
'ems_zone' => 'string',
'Countries__ems' => 'string',
'Countries.ems' => 'string',
'ems' => 'string',
'Countries__air_parcel' => 'string',
'Countries.air_parcel' => 'string',
'air_parcel' => 'string',
'Countries__air_mail' => 'string',
'Countries.air_mail' => 'string',
'air_mail' => 'string',
'Countries__supporting' => 'tinyinteger',
'Countries.supporting' => 'tinyinteger',
'supporting' => 'tinyinteger',
'Countries__dhl_zone' => 'tinyinteger',
'Countries.dhl_zone' => 'tinyinteger',
'dhl_zone' => 'tinyinteger',
'Countries__created' => 'datetime',
'Countries.created' => 'datetime',
'created' => 'datetime',
'Countries__created_by' => 'biginteger',
'Countries.created_by' => 'biginteger',
'created_by' => 'biginteger',
'Countries__modified' => 'datetime',
'Countries.modified' => 'datetime',
'modified' => 'datetime',
'Countries__modified_by' => 'biginteger',
'Countries.modified_by' => 'biginteger',
'modified_by' => 'biginteger'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CountriesTable) {}
}
$minContentAction = 'login'
$tabName = null
$deliveryAvailableDistricts = []
$websiteId = (int) 182
$poweredBy = '<span id="powered-by-text"><span style="color:#C5C5C5;">Powered by </span><a href="https://lakshop.lk/" style="color:#fff;" target="_blank" class="powered-by-link">LakSHOP website builder</a></span>'
$websiteSettings = object(App\Model\Entity\WebsiteSetting) {
'id' => (int) 38,
'website_id' => (int) 182,
'user_reg_sms_validation' => (int) 0,
'vendor_reg_method' => 'USERNAME',
'auto_activate_vendors' => (int) 0,
'auto_activate_customers' => (int) 1,
'auto_approve_vendors' => (int) 0,
'auto_approve_vendor_products' => (int) 0,
'pre_approve_vendors' => (int) 0,
'pre_approve_products' => (int) 0,
'vendor_bank_account_required' => (int) 1,
'buyers_can_register' => (int) 1,
'sellers_can_register' => (int) 0,
'courier_can_register' => (int) 0,
'product_based_owner_commission' => (int) 0,
'staff_members' => (int) 0,
'make_model_based_products' => (int) 1,
'show_custom_product_field_1_in_home' => (int) 0,
'show_custom_product_field_2_in_home' => (int) 0,
'show_custom_product_field_3_in_home' => (int) 0,
'single_shipping_location' => (int) 1,
'product_weight_is_important_to_show' => (int) 0,
'location_mark_type' => 'CITY',
'international_shipping' => (int) 0,
'usd_rate' => (float) 230,
'show_product_price_to_public' => (int) 1,
'customer_auto_activate' => (int) 1,
'show_order_id_qr_in_confirmation_email' => (int) 0,
'show_order_user_details_qr_in_confirmation_email' => (int) 0,
'contact_us_popup' => null,
'show_google_translate' => (int) 0,
'text_to_speech_product_desc' => (int) 0,
'show_lakshop_branding' => (int) 1,
'product_img_watermark_opacity' => null,
'subscriptions_enable' => (int) 0,
'append_blog_in_content_min' => (int) 0,
'append_gallery_in_content_min' => (int) 0,
'append_subscription_box_in_content_min' => (int) 0,
'append_featured_products_in_content_min' => (int) 0,
'show_sl_map_in_home' => (int) 0,
'[new]' => false,
'[accessible]' => [
'website_id' => true,
'user_reg_sms_validation' => true,
'website' => true,
'usd_rate' => true,
'contact_us_popup' => true,
'product_img_watermark_opacity' => true,
'subscriptions_enable' => true,
'append_blog_in_content_min' => true,
'append_gallery_in_content_min' => true,
'append_subscription_box_in_content_min' => true,
'append_featured_products_in_content_min' => true,
'show_sl_map_in_home' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'WebsiteSettings'
}
$loggedUserId = null
$loggedUserType = nullinclude - APP/Template/Layout/lakshop_template_layouts/8/wonderland/content.ctp, line 7
include - APP/Template/Layout/lakshop_template_layouts/8/wonderland/layout.ctp, line 137
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1196
Cake\View\View::_render() - CORE/src/View/View.php, line 1157
Cake\View\View::renderLayout() - CORE/src/View/View.php, line 812
Cake\View\View::render() - CORE/src/View/View.php, line 770
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 623
App\Controller\WebsitesController::viewWebsite() - APP/Controller/WebsitesController.php, line 4107
App\Controller\WebsitesController::home() - APP/Controller/WebsitesController.php, line 3874
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 440
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 119
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 108
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 104
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88