Notice (8): Undefined index: HTTP_ACCEPT_LANGUAGE [APP/Controller/AppController.php, line 283]Code Context $selectedLang = $this->session->read('language');
$acceptLang = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);
$selectedLang = 'fr'
App\Controller\AppController::setLanguage() - APP/Controller/AppController.php, line 283
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 189
App\Controller\ProductsController::beforeFilter() - APP/Controller/ProductsController.php, line 38
Cake\Event\EventManager::_callListener() - CORE/src/Event/EventManager.php, line 351
Cake\Event\EventManager::dispatch() - CORE/src/Event/EventManager.php, line 328
Cake\Controller\Controller::dispatchEvent() - CORE/src/Event/EventDispatcherTrait.php, line 112
Cake\Controller\Controller::startupProcess() - CORE/src/Controller/Controller.php, line 673
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 115
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 66
[main] - ROOT/webroot/index.php, line 165
Notice (8): Undefined offset: 0 [APP/Controller/ProductsController.php, line 867]Code Context if (empty($options['brand'])) {
$printerBrandSearch = ['label LIKE ' => "%" . $brandArr[0] . "%"];
}
$keyword = null
$key = 'misc'
$options = [
'condition' => null,
'brand' => null,
'printer' => null,
'color' => null,
'sort' => null
]
$filterIsApplied = false
$value = 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.3to6 AS `products__3to6`, products.qty AS `products__qty`, products.title AS `products__title`, products.model_part AS `products__model_part`, products.part_number AS `products__part_number`, products.model AS `products__model`, products.cond AS `products__cond`, products.color AS `products__color`, products.qty_jo AS `products__qty_jo`, pricelist.special AS `pricelist__special`, pricelist.specialprice AS `pricelist__specialprice`, pricelist.price AS `pricelist__price`, pricelist.special_start AS `pricelist__special_start`, pricelist.special_end AS `pricelist__special_end`, rv2.label AS `rv2__label`, rv.label AS `rv__label`, products_categories.category_id AS `products_categories__category_id` FROM products Products LEFT JOIN products_categories ON Products.id = products_categories.product_id LEFT JOIN ref_values rv ON (products_categories.category_id = rv.value_id AND rv.kind = "category" AND rv.language = "en" AND rv.label = :c0) LEFT JOIN pricelist ON Products.id = pricelist.product_id LEFT JOIN ref_values rv2 ON (products.manufacturer_id = rv2.value_id AND rv2.kind = 'category' AND rv2.parent = 0 AND rv2.language = 'en') WHERE (pricelist.site_id = :c1 AND Products.active = :c2 AND (Products.description LIKE '%misc%' OR printer_models LIKE '%misc%' OR secret LIKE '%misc%') AND products.cond != 2) GROUP BY Products.id ORDER BY Products.cond ASC, pricelist.price ASC, Products.title ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__title' => 'string',
'Products.title' => 'string',
'title' => 'string',
'Products__model_part' => 'string',
'Products.model_part' => 'string',
'model_part' => 'string',
'Products__model_display' => 'string',
'Products.model_display' => 'string',
'model_display' => 'string',
'Products__description' => 'text',
'Products.description' => 'text',
'description' => 'text',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__show_description' => 'boolean',
'Products.show_description' => 'boolean',
'show_description' => 'boolean',
'Products__show_related' => 'boolean',
'Products.show_related' => 'boolean',
'show_related' => 'boolean',
'Products__secret' => 'text',
'Products.secret' => 'text',
'secret' => 'text',
'Products__photo' => 'string',
'Products.photo' => 'string',
'photo' => 'string',
'Products__photo1' => 'string',
'Products.photo1' => 'string',
'photo1' => 'string',
'Products__photo2' => 'string',
'Products.photo2' => 'string',
'photo2' => 'string',
'Products__photo3' => 'string',
'Products.photo3' => 'string',
'photo3' => 'string',
'Products__photo4' => 'string',
'Products.photo4' => 'string',
'photo4' => 'string',
'Products__photo_dir' => 'string',
'Products.photo_dir' => 'string',
'photo_dir' => 'string',
'Products__photo_url' => 'string',
'Products.photo_url' => 'string',
'photo_url' => 'string',
'Products__photo_size' => 'integer',
'Products.photo_size' => 'integer',
'photo_size' => 'integer',
'Products__photo_type' => 'string',
'Products.photo_type' => 'string',
'photo_type' => 'string',
'Products__color' => 'integer',
'Products.color' => 'integer',
'color' => 'integer',
'Products__nickname' => 'string',
'Products.nickname' => 'string',
'nickname' => 'string',
'Products__model' => 'text',
'Products.model' => 'text',
'model' => 'text',
'Products__product_type' => 'integer',
'Products.product_type' => 'integer',
'product_type' => 'integer',
'Products__part_number' => 'string',
'Products.part_number' => 'string',
'part_number' => 'string',
'Products__part_number2' => 'string',
'Products.part_number2' => 'string',
'part_number2' => 'string',
'Products__cond' => 'integer',
'Products.cond' => 'integer',
'cond' => 'integer',
'Products__pages' => 'string',
'Products.pages' => 'string',
'pages' => 'string',
'Products__qty' => 'integer',
'Products.qty' => 'integer',
'qty' => 'integer',
'Products__instock' => 'boolean',
'Products.instock' => 'boolean',
'instock' => 'boolean',
'Products__qty_jo' => 'integer',
'Products.qty_jo' => 'integer',
'qty_jo' => 'integer',
'Products__instock_usa' => 'tinyinteger',
'Products.instock_usa' => 'tinyinteger',
'instock_usa' => 'tinyinteger',
'Products__qty_check' => 'tinyinteger',
'Products.qty_check' => 'tinyinteger',
'qty_check' => 'tinyinteger',
'Products__qty_min' => 'integer',
'Products.qty_min' => 'integer',
'qty_min' => 'integer',
'Products__3to6' => 'boolean',
'Products.3to6' => 'boolean',
'3to6' => 'boolean',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__needempty' => 'boolean',
'Products.needempty' => 'boolean',
'needempty' => 'boolean',
'Products__freegift' => 'boolean',
'Products.freegift' => 'boolean',
'freegift' => 'boolean',
'Products__crazypromo' => 'boolean',
'Products.crazypromo' => 'boolean',
'crazypromo' => 'boolean',
'Products__wholisted' => 'string',
'Products.wholisted' => 'string',
'wholisted' => 'string',
'Products__active' => 'boolean',
'Products.active' => 'boolean',
'active' => 'boolean',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__qb_id' => 'integer',
'Products.qb_id' => 'integer',
'qb_id' => 'integer',
'Products__views' => 'integer',
'Products.views' => 'integer',
'views' => 'integer',
'Products__sold' => 'integer',
'Products.sold' => 'integer',
'sold' => 'integer',
'Products__gtin' => 'string',
'Products.gtin' => 'string',
'gtin' => 'string',
'Products__barcode' => 'string',
'Products.barcode' => 'string',
'barcode' => 'string',
'Products__textArea1' => 'string',
'Products.textArea1' => 'string',
'textArea1' => 'string',
'Products__textArea2' => 'string',
'Products.textArea2' => 'string',
'textArea2' => 'string',
'Products__link2Prod' => 'string',
'Products.link2Prod' => 'string',
'link2Prod' => 'string',
'Products__id2Prod' => 'integer',
'Products.id2Prod' => 'integer',
'id2Prod' => 'integer',
'Products__link2Prod2' => 'string',
'Products.link2Prod2' => 'string',
'link2Prod2' => 'string',
'Products__id2Prod2' => 'integer',
'Products.id2Prod2' => 'integer',
'id2Prod2' => 'integer',
'Products__printer_models' => 'text',
'Products.printer_models' => 'text',
'printer_models' => 'text',
'Products__product_quantity' => 'integer',
'Products.product_quantity' => 'integer',
'product_quantity' => 'integer',
'Products__product_capacity' => 'integer',
'Products.product_capacity' => 'integer',
'product_capacity' => 'integer',
'Products__shelf_life' => 'integer',
'Products.shelf_life' => 'integer',
'shelf_life' => 'integer',
'Products__details' => 'string',
'Products.details' => 'string',
'details' => 'string',
'Products__weight' => 'string',
'Products.weight' => 'string',
'weight' => 'string',
'Products__google_merchant' => 'boolean',
'Products.google_merchant' => 'boolean',
'google_merchant' => 'boolean',
'Products__walmart_marketplace' => 'boolean',
'Products.walmart_marketplace' => 'boolean',
'walmart_marketplace' => 'boolean',
'Products__sitemap' => 'boolean',
'Products.sitemap' => 'boolean',
'sitemap' => 'boolean',
'Products__length' => 'string',
'Products.length' => 'string',
'length' => 'string',
'Products__width' => 'string',
'Products.width' => 'string',
'width' => 'string',
'Products__height' => 'string',
'Products.height' => 'string',
'height' => 'string',
'Products__bestbuy_marketplace' => 'integer',
'Products.bestbuy_marketplace' => 'integer',
'bestbuy_marketplace' => 'integer'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$optionsBrands = ''
$conditions = [
'oem' => (int) 0,
'compatible' => (int) 2,
'madein' => (int) 0,
'count' => (int) 1,
'selected' => false
]
$p = object(App\Model\Entity\Product) {
'products' => [
'id' => '17124',
'3to6' => '0',
'qty' => '0',
'title' => 'Misc see notes ',
'model_part' => 'Misc see notes',
'part_number' => 'Misc see notes',
'model' => null,
'cond' => '0',
'color' => null,
'qty_jo' => '0'
],
'pricelist' => [
'special' => '0',
'specialprice' => '0.00',
'price' => '347.69',
'special_start' => null,
'special_end' => null
],
'rv2' => [
'label' => 'Zebra'
],
'rv' => [
'label' => null
],
'products_categories' => [
'category_id' => null
],
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[hasErrors]' => false,
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Products'
}
$c = (int) 0
$k = 'count'
$brandArr = [
(int) 1 => 'Zebra'
]
$brand = object(App\Model\Entity\Product) {
'products' => [
'id' => '17124',
'3to6' => '0',
'qty' => '0',
'title' => 'Misc see notes ',
'model_part' => 'Misc see notes',
'part_number' => 'Misc see notes',
'model' => null,
'cond' => '0',
'color' => null,
'qty_jo' => '0'
],
'pricelist' => [
'special' => '0',
'specialprice' => '0.00',
'price' => '347.69',
'special_start' => null,
'special_end' => null
],
'rv2' => [
'label' => 'Zebra'
],
'rv' => [
'label' => null
],
'products_categories' => [
'category_id' => null
],
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[hasErrors]' => false,
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Products'
}
$printerKeySearch = [
'label LIKE ' => '%misc%'
]
$printerPrinterSearch = []
$printerBrandSearch = [
'label LIKE ' => '%%'
]
App\Controller\ProductsController::search() - APP/Controller/ProductsController.php, line 867
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 606
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 120
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 66
[main] - ROOT/webroot/index.php, line 165