レンタル中
Notice (8): Undefined offset: 0 [APP/Template/Products/categoryproducts.ctp, line 31]Code Context <?php echo $this->element('productstatus', ['sku' => $sku ]); ?>
<?= $this->Html->image($sku->image_constitutions[0]->image->image_url,[
'url' => ['controller' => 'Products', 'action' => 'productdetail', $sku->product->product_id],
$viewFile = '/var/www/shareris/sharecloapp/src/Template/Products/categoryproducts.ctp'
$dataForView = [
'category_name' => 'トップス',
'skus' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\SkusTable) {}
},
'monthly_rental_period' => '30',
'shortest_dress_rental_period' => '4',
'rental_period' => '3',
'categorys_ll' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'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\CategorysTable) {}
},
'brands_ll' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'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\BrandsTable) {}
},
'scenes' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\ScenesTable) {}
},
'categorys' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\CategorysTable) {}
},
'brands' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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) {}
}
]
$category_name = 'トップス'
$skus = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Skus__id' => 'integer',
'Skus.id' => 'integer',
'id' => 'integer',
'Skus__sku_id' => 'string',
'Skus.sku_id' => 'string',
'sku_id' => 'string',
'Skus__product_id' => 'string',
'Skus.product_id' => 'string',
'product_id' => 'string',
'Skus__size_id' => 'integer',
'Skus.size_id' => 'integer',
'size_id' => 'integer',
'Skus__color_id' => 'integer',
'Skus.color_id' => 'integer',
'color_id' => 'integer',
'Skus__rental_price' => 'integer',
'Skus.rental_price' => 'integer',
'rental_price' => 'integer',
'Skus__base_price' => 'integer',
'Skus.base_price' => 'integer',
'base_price' => 'integer',
'Skus__monthly_price' => 'integer',
'Skus.monthly_price' => 'integer',
'monthly_price' => 'integer',
'Skus__rental_startdate' => 'date',
'Skus.rental_startdate' => 'date',
'rental_startdate' => 'date',
'Skus__rental_enddate' => 'date',
'Skus.rental_enddate' => 'date',
'rental_enddate' => 'date',
'Skus__product_status' => 'string',
'Skus.product_status' => 'string',
'product_status' => 'string',
'Skus__rental_status' => 'string',
'Skus.rental_status' => 'string',
'rental_status' => 'string',
'Skus__two_dress_flag' => 'tinyinteger',
'Skus.two_dress_flag' => 'tinyinteger',
'two_dress_flag' => 'tinyinteger',
'Skus__delete_flag' => 'boolean',
'Skus.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Skus__created' => 'datetime',
'Skus.created' => 'datetime',
'created' => 'datetime',
'Skus__modified' => 'datetime',
'Skus.modified' => 'datetime',
'modified' => 'datetime',
'Products__id' => 'integer',
'Products.id' => 'integer',
'Products__product_id' => 'string',
'Products.product_id' => 'string',
'Products__product_name' => 'string',
'Products.product_name' => 'string',
'product_name' => 'string',
'Products__product_description' => 'text',
'Products.product_description' => 'text',
'product_description' => 'text',
'Products__category_id' => 'string',
'Products.category_id' => 'string',
'category_id' => 'string',
'Products__brand_id' => 'string',
'Products.brand_id' => 'string',
'brand_id' => 'string',
'Products__scene_id' => 'string',
'Products.scene_id' => 'string',
'scene_id' => 'string',
'Products__shop_id' => 'integer',
'Products.shop_id' => 'integer',
'shop_id' => 'integer',
'Products__retail_price' => 'integer',
'Products.retail_price' => 'integer',
'retail_price' => 'integer',
'Products__delete_flag' => 'boolean',
'Products.delete_flag' => 'boolean',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'Image_constitutions__id' => 'integer',
'Image_constitutions.id' => 'integer',
'Image_constitutions__kind' => 'string',
'Image_constitutions.kind' => 'string',
'kind' => 'string',
'Image_constitutions__sku_id' => 'string',
'Image_constitutions.sku_id' => 'string',
'Image_constitutions__coordinate_id' => 'string',
'Image_constitutions.coordinate_id' => 'string',
'coordinate_id' => 'string',
'Image_constitutions__image_id' => 'string',
'Image_constitutions.image_id' => 'string',
'image_id' => 'string',
'Image_constitutions__created' => 'datetime',
'Image_constitutions.created' => 'datetime',
'Image_constitutions__modified' => 'datetime',
'Image_constitutions.modified' => 'datetime',
'Images__id' => 'integer',
'Images.id' => 'integer',
'Images__image_id' => 'string',
'Images.image_id' => 'string',
'Images__image_url' => 'string',
'Images.image_url' => 'string',
'image_url' => 'string',
'Images__created' => 'datetime',
'Images.created' => 'datetime',
'Images__modified' => 'datetime',
'Images.modified' => 'datetime',
'Colors__id' => 'integer',
'Colors.id' => 'integer',
'Colors__color_id' => 'integer',
'Colors.color_id' => 'integer',
'Colors__color_name' => 'string',
'Colors.color_name' => 'string',
'color_name' => 'string',
'Colors__created' => 'datetime',
'Colors.created' => 'datetime',
'Colors__modified' => 'datetime',
'Colors.modified' => 'datetime',
'Sizes__id' => 'integer',
'Sizes.id' => 'integer',
'Sizes__size_id' => 'integer',
'Sizes.size_id' => 'integer',
'Sizes__size_name' => 'string',
'Sizes.size_name' => 'string',
'size_name' => 'string',
'Sizes__created' => 'datetime',
'Sizes.created' => 'datetime',
'Sizes__modified' => 'datetime',
'Sizes.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Products' => [
[maximum depth reached]
],
'Image_constitutions' => [
[maximum depth reached]
],
'Colors' => [[maximum depth reached]],
'Sizes' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\SkusTable) {}
}
$monthly_rental_period = '30'
$shortest_dress_rental_period = '4'
$rental_period = '3'
$categorys_ll = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands_ll = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$scenes = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [],
'defaultTypes' => [
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ScenesTable) {}
}
$categorys = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$bufferLevel = (int) 1
$sku = object(App\Model\Entity\Skus) {
'id' => (int) 1699,
'sku_id' => 'ProductTest2_001_001',
'product_id' => 'ProductTest2',
'size_id' => (int) 1,
'color_id' => (int) 1,
'rental_price' => (int) 3000,
'base_price' => (int) 10000,
'monthly_price' => (int) 20000,
'rental_startdate' => null,
'rental_enddate' => null,
'product_status' => 'ランク5(新品)',
'rental_status' => 'ダミー',
'two_dress_flag' => null,
'delete_flag' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'modified' => object(Cake\I18n\FrozenTime) {},
'size' => object(App\Model\Entity\Size) {},
'color' => object(App\Model\Entity\Color) {},
'image_constitutions' => [],
'product' => object(App\Model\Entity\Product) {},
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[hasErrors]' => false,
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Skus'
}
include - APP/Template/Products/categoryproducts.ctp, line 31
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1435
Cake\View\View::_render() - CORE/src/View/View.php, line 1393
Cake\View\View::render() - CORE/src/View/View.php, line 892
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 791
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 256
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 100
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Maintenance\Middleware\MaintenanceMiddleware::__invoke() - ROOT/vendor/fusic/maintenance/src/Middleware/MaintenanceMiddleware.php, line 46
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 164
Notice (8): Trying to get property of non-object [APP/Template/Products/categoryproducts.ctp, line 31]Code Context <?php echo $this->element('productstatus', ['sku' => $sku ]); ?>
<?= $this->Html->image($sku->image_constitutions[0]->image->image_url,[
'url' => ['controller' => 'Products', 'action' => 'productdetail', $sku->product->product_id],
$viewFile = '/var/www/shareris/sharecloapp/src/Template/Products/categoryproducts.ctp'
$dataForView = [
'category_name' => 'トップス',
'skus' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\SkusTable) {}
},
'monthly_rental_period' => '30',
'shortest_dress_rental_period' => '4',
'rental_period' => '3',
'categorys_ll' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL)',
'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\CategorysTable) {}
},
'brands_ll' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL)',
'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\BrandsTable) {}
},
'scenes' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\ScenesTable) {}
},
'categorys' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\CategorysTable) {}
},
'brands' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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) {}
}
]
$category_name = 'トップス'
$skus = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Skus__id' => 'integer',
'Skus.id' => 'integer',
'id' => 'integer',
'Skus__sku_id' => 'string',
'Skus.sku_id' => 'string',
'sku_id' => 'string',
'Skus__product_id' => 'string',
'Skus.product_id' => 'string',
'product_id' => 'string',
'Skus__size_id' => 'integer',
'Skus.size_id' => 'integer',
'size_id' => 'integer',
'Skus__color_id' => 'integer',
'Skus.color_id' => 'integer',
'color_id' => 'integer',
'Skus__rental_price' => 'integer',
'Skus.rental_price' => 'integer',
'rental_price' => 'integer',
'Skus__base_price' => 'integer',
'Skus.base_price' => 'integer',
'base_price' => 'integer',
'Skus__monthly_price' => 'integer',
'Skus.monthly_price' => 'integer',
'monthly_price' => 'integer',
'Skus__rental_startdate' => 'date',
'Skus.rental_startdate' => 'date',
'rental_startdate' => 'date',
'Skus__rental_enddate' => 'date',
'Skus.rental_enddate' => 'date',
'rental_enddate' => 'date',
'Skus__product_status' => 'string',
'Skus.product_status' => 'string',
'product_status' => 'string',
'Skus__rental_status' => 'string',
'Skus.rental_status' => 'string',
'rental_status' => 'string',
'Skus__two_dress_flag' => 'tinyinteger',
'Skus.two_dress_flag' => 'tinyinteger',
'two_dress_flag' => 'tinyinteger',
'Skus__delete_flag' => 'boolean',
'Skus.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Skus__created' => 'datetime',
'Skus.created' => 'datetime',
'created' => 'datetime',
'Skus__modified' => 'datetime',
'Skus.modified' => 'datetime',
'modified' => 'datetime',
'Products__id' => 'integer',
'Products.id' => 'integer',
'Products__product_id' => 'string',
'Products.product_id' => 'string',
'Products__product_name' => 'string',
'Products.product_name' => 'string',
'product_name' => 'string',
'Products__product_description' => 'text',
'Products.product_description' => 'text',
'product_description' => 'text',
'Products__category_id' => 'string',
'Products.category_id' => 'string',
'category_id' => 'string',
'Products__brand_id' => 'string',
'Products.brand_id' => 'string',
'brand_id' => 'string',
'Products__scene_id' => 'string',
'Products.scene_id' => 'string',
'scene_id' => 'string',
'Products__shop_id' => 'integer',
'Products.shop_id' => 'integer',
'shop_id' => 'integer',
'Products__retail_price' => 'integer',
'Products.retail_price' => 'integer',
'retail_price' => 'integer',
'Products__delete_flag' => 'boolean',
'Products.delete_flag' => 'boolean',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'Image_constitutions__id' => 'integer',
'Image_constitutions.id' => 'integer',
'Image_constitutions__kind' => 'string',
'Image_constitutions.kind' => 'string',
'kind' => 'string',
'Image_constitutions__sku_id' => 'string',
'Image_constitutions.sku_id' => 'string',
'Image_constitutions__coordinate_id' => 'string',
'Image_constitutions.coordinate_id' => 'string',
'coordinate_id' => 'string',
'Image_constitutions__image_id' => 'string',
'Image_constitutions.image_id' => 'string',
'image_id' => 'string',
'Image_constitutions__created' => 'datetime',
'Image_constitutions.created' => 'datetime',
'Image_constitutions__modified' => 'datetime',
'Image_constitutions.modified' => 'datetime',
'Images__id' => 'integer',
'Images.id' => 'integer',
'Images__image_id' => 'string',
'Images.image_id' => 'string',
'Images__image_url' => 'string',
'Images.image_url' => 'string',
'image_url' => 'string',
'Images__created' => 'datetime',
'Images.created' => 'datetime',
'Images__modified' => 'datetime',
'Images.modified' => 'datetime',
'Colors__id' => 'integer',
'Colors.id' => 'integer',
'Colors__color_id' => 'integer',
'Colors.color_id' => 'integer',
'Colors__color_name' => 'string',
'Colors.color_name' => 'string',
'color_name' => 'string',
'Colors__created' => 'datetime',
'Colors.created' => 'datetime',
'Colors__modified' => 'datetime',
'Colors.modified' => 'datetime',
'Sizes__id' => 'integer',
'Sizes.id' => 'integer',
'Sizes__size_id' => 'integer',
'Sizes.size_id' => 'integer',
'Sizes__size_name' => 'string',
'Sizes.size_name' => 'string',
'size_name' => 'string',
'Sizes__created' => 'datetime',
'Sizes.created' => 'datetime',
'Sizes__modified' => 'datetime',
'Sizes.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Products' => [
[maximum depth reached]
],
'Image_constitutions' => [
[maximum depth reached]
],
'Colors' => [[maximum depth reached]],
'Sizes' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\SkusTable) {}
}
$monthly_rental_period = '30'
$shortest_dress_rental_period = '4'
$rental_period = '3'
$categorys_ll = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands_ll = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$scenes = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [],
'defaultTypes' => [
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ScenesTable) {}
}
$categorys = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$bufferLevel = (int) 1
$sku = object(App\Model\Entity\Skus) {
'id' => (int) 1699,
'sku_id' => 'ProductTest2_001_001',
'product_id' => 'ProductTest2',
'size_id' => (int) 1,
'color_id' => (int) 1,
'rental_price' => (int) 3000,
'base_price' => (int) 10000,
'monthly_price' => (int) 20000,
'rental_startdate' => null,
'rental_enddate' => null,
'product_status' => 'ランク5(新品)',
'rental_status' => 'ダミー',
'two_dress_flag' => null,
'delete_flag' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'modified' => object(Cake\I18n\FrozenTime) {},
'size' => object(App\Model\Entity\Size) {},
'color' => object(App\Model\Entity\Color) {},
'image_constitutions' => [],
'product' => object(App\Model\Entity\Product) {},
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[hasErrors]' => false,
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Skus'
}
include - APP/Template/Products/categoryproducts.ctp, line 31
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1435
Cake\View\View::_render() - CORE/src/View/View.php, line 1393
Cake\View\View::render() - CORE/src/View/View.php, line 892
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 791
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 256
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 100
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Maintenance\Middleware\MaintenanceMiddleware::__invoke() - ROOT/vendor/fusic/maintenance/src/Middleware/MaintenanceMiddleware.php, line 46
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 164
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Notice (8): Trying to get property of non-object [APP/Template/Products/categoryproducts.ctp, line 31]Code Context <?php echo $this->element('productstatus', ['sku' => $sku ]); ?>
<?= $this->Html->image($sku->image_constitutions[0]->image->image_url,[
'url' => ['controller' => 'Products', 'action' => 'productdetail', $sku->product->product_id],
$viewFile = '/var/www/shareris/sharecloapp/src/Template/Products/categoryproducts.ctp'
$dataForView = [
'category_name' => 'トップス',
'skus' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\SkusTable) {}
},
'monthly_rental_period' => '30',
'shortest_dress_rental_period' => '4',
'rental_period' => '3',
'categorys_ll' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL)',
'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\CategorysTable) {}
},
'brands_ll' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL)',
'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\BrandsTable) {}
},
'scenes' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\ScenesTable) {}
},
'categorys' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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\CategorysTable) {}
},
'brands' => 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'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) {}
}
]
$category_name = 'トップス'
$skus = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Skus.id AS `Skus__id`, Skus.sku_id AS `Skus__sku_id`, Skus.product_id AS `Skus__product_id`, Skus.size_id AS `Skus__size_id`, Skus.color_id AS `Skus__color_id`, Skus.rental_price AS `Skus__rental_price`, Skus.base_price AS `Skus__base_price`, Skus.monthly_price AS `Skus__monthly_price`, Skus.rental_startdate AS `Skus__rental_startdate`, Skus.rental_enddate AS `Skus__rental_enddate`, Skus.product_status AS `Skus__product_status`, Skus.rental_status AS `Skus__rental_status`, Skus.two_dress_flag AS `Skus__two_dress_flag`, Skus.delete_flag AS `Skus__delete_flag`, Skus.created AS `Skus__created`, Skus.modified AS `Skus__modified`, Products.id AS `Products__id`, Products.product_id AS `Products__product_id`, Products.product_name AS `Products__product_name`, Products.product_description AS `Products__product_description`, Products.category_id AS `Products__category_id`, Products.brand_id AS `Products__brand_id`, Products.scene_id AS `Products__scene_id`, Products.shop_id AS `Products__shop_id`, Products.retail_price AS `Products__retail_price`, Products.delete_flag AS `Products__delete_flag`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified`, Brands.id AS `Brands__id`, Brands.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified`, Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified`, Colors.id AS `Colors__id`, Colors.color_id AS `Colors__color_id`, Colors.color_name AS `Colors__color_name`, Colors.created AS `Colors__created`, Colors.modified AS `Colors__modified`, Sizes.id AS `Sizes__id`, Sizes.size_id AS `Sizes__size_id`, Sizes.size_name AS `Sizes__size_name`, Sizes.created AS `Sizes__created`, Sizes.modified AS `Sizes__modified` FROM skus Skus LEFT JOIN products Products ON Products.product_id = (Skus.product_id) LEFT JOIN categorys Categorys ON Categorys.category_id = (Products.category_id) LEFT JOIN brands Brands ON Brands.brand_id = (Products.brand_id) LEFT JOIN scenes Scenes ON Scenes.scene_id = (Products.scene_id) LEFT JOIN colors Colors ON Colors.color_id = (Skus.color_id) LEFT JOIN sizes Sizes ON Sizes.id = (Skus.size_id) WHERE (Products.category_id = :c0 AND Skus.delete_flag IS NULL AND Products.delete_flag IS NULL) ORDER BY field(Skus.rental_status, 10, "注文完了", 25, 30), Skus.id DESC',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Skus__id' => 'integer',
'Skus.id' => 'integer',
'id' => 'integer',
'Skus__sku_id' => 'string',
'Skus.sku_id' => 'string',
'sku_id' => 'string',
'Skus__product_id' => 'string',
'Skus.product_id' => 'string',
'product_id' => 'string',
'Skus__size_id' => 'integer',
'Skus.size_id' => 'integer',
'size_id' => 'integer',
'Skus__color_id' => 'integer',
'Skus.color_id' => 'integer',
'color_id' => 'integer',
'Skus__rental_price' => 'integer',
'Skus.rental_price' => 'integer',
'rental_price' => 'integer',
'Skus__base_price' => 'integer',
'Skus.base_price' => 'integer',
'base_price' => 'integer',
'Skus__monthly_price' => 'integer',
'Skus.monthly_price' => 'integer',
'monthly_price' => 'integer',
'Skus__rental_startdate' => 'date',
'Skus.rental_startdate' => 'date',
'rental_startdate' => 'date',
'Skus__rental_enddate' => 'date',
'Skus.rental_enddate' => 'date',
'rental_enddate' => 'date',
'Skus__product_status' => 'string',
'Skus.product_status' => 'string',
'product_status' => 'string',
'Skus__rental_status' => 'string',
'Skus.rental_status' => 'string',
'rental_status' => 'string',
'Skus__two_dress_flag' => 'tinyinteger',
'Skus.two_dress_flag' => 'tinyinteger',
'two_dress_flag' => 'tinyinteger',
'Skus__delete_flag' => 'boolean',
'Skus.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Skus__created' => 'datetime',
'Skus.created' => 'datetime',
'created' => 'datetime',
'Skus__modified' => 'datetime',
'Skus.modified' => 'datetime',
'modified' => 'datetime',
'Products__id' => 'integer',
'Products.id' => 'integer',
'Products__product_id' => 'string',
'Products.product_id' => 'string',
'Products__product_name' => 'string',
'Products.product_name' => 'string',
'product_name' => 'string',
'Products__product_description' => 'text',
'Products.product_description' => 'text',
'product_description' => 'text',
'Products__category_id' => 'string',
'Products.category_id' => 'string',
'category_id' => 'string',
'Products__brand_id' => 'string',
'Products.brand_id' => 'string',
'brand_id' => 'string',
'Products__scene_id' => 'string',
'Products.scene_id' => 'string',
'scene_id' => 'string',
'Products__shop_id' => 'integer',
'Products.shop_id' => 'integer',
'shop_id' => 'integer',
'Products__retail_price' => 'integer',
'Products.retail_price' => 'integer',
'retail_price' => 'integer',
'Products__delete_flag' => 'boolean',
'Products.delete_flag' => 'boolean',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'Image_constitutions__id' => 'integer',
'Image_constitutions.id' => 'integer',
'Image_constitutions__kind' => 'string',
'Image_constitutions.kind' => 'string',
'kind' => 'string',
'Image_constitutions__sku_id' => 'string',
'Image_constitutions.sku_id' => 'string',
'Image_constitutions__coordinate_id' => 'string',
'Image_constitutions.coordinate_id' => 'string',
'coordinate_id' => 'string',
'Image_constitutions__image_id' => 'string',
'Image_constitutions.image_id' => 'string',
'image_id' => 'string',
'Image_constitutions__created' => 'datetime',
'Image_constitutions.created' => 'datetime',
'Image_constitutions__modified' => 'datetime',
'Image_constitutions.modified' => 'datetime',
'Images__id' => 'integer',
'Images.id' => 'integer',
'Images__image_id' => 'string',
'Images.image_id' => 'string',
'Images__image_url' => 'string',
'Images.image_url' => 'string',
'image_url' => 'string',
'Images__created' => 'datetime',
'Images.created' => 'datetime',
'Images__modified' => 'datetime',
'Images.modified' => 'datetime',
'Colors__id' => 'integer',
'Colors.id' => 'integer',
'Colors__color_id' => 'integer',
'Colors.color_id' => 'integer',
'Colors__color_name' => 'string',
'Colors.color_name' => 'string',
'color_name' => 'string',
'Colors__created' => 'datetime',
'Colors.created' => 'datetime',
'Colors__modified' => 'datetime',
'Colors.modified' => 'datetime',
'Sizes__id' => 'integer',
'Sizes.id' => 'integer',
'Sizes__size_id' => 'integer',
'Sizes.size_id' => 'integer',
'Sizes__size_name' => 'string',
'Sizes.size_name' => 'string',
'size_name' => 'string',
'Sizes__created' => 'datetime',
'Sizes.created' => 'datetime',
'Sizes__modified' => 'datetime',
'Sizes.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Products' => [
[maximum depth reached]
],
'Image_constitutions' => [
[maximum depth reached]
],
'Colors' => [[maximum depth reached]],
'Sizes' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\SkusTable) {}
}
$monthly_rental_period = '30'
$shortest_dress_rental_period = '4'
$rental_period = '3'
$categorys_ll = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands_ll = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$scenes = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Scenes.id AS `Scenes__id`, Scenes.scene_id AS `Scenes__scene_id`, Scenes.scene_name AS `Scenes__scene_name`, Scenes.delete_flag AS `Scenes__delete_flag`, Scenes.created AS `Scenes__created`, Scenes.modified AS `Scenes__modified` FROM scenes Scenes WHERE delete_flag IS NULL',
'params' => [],
'defaultTypes' => [
'Scenes__id' => 'integer',
'Scenes.id' => 'integer',
'id' => 'integer',
'Scenes__scene_id' => 'string',
'Scenes.scene_id' => 'string',
'scene_id' => 'string',
'Scenes__scene_name' => 'string',
'Scenes.scene_name' => 'string',
'scene_name' => 'string',
'Scenes__delete_flag' => 'boolean',
'Scenes.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Scenes__created' => 'datetime',
'Scenes.created' => 'datetime',
'created' => 'datetime',
'Scenes__modified' => 'datetime',
'Scenes.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ScenesTable) {}
}
$categorys = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categorys.id AS `Categorys__id`, Categorys.category_id AS `Categorys__category_id`, Categorys.category_name AS `Categorys__category_name`, Categorys.delete_flag AS `Categorys__delete_flag`, Categorys.created AS `Categorys__created`, Categorys.modified AS `Categorys__modified` FROM categorys Categorys LEFT JOIN category_selects CategorySelects ON Categorys.category_id = (CategorySelects.category_id) WHERE (Categorys.category_id not like :c0 AND delete_flag IS NULL AND (CategorySelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categorys__id' => 'integer',
'Categorys.id' => 'integer',
'id' => 'integer',
'Categorys__category_id' => 'string',
'Categorys.category_id' => 'string',
'category_id' => 'string',
'Categorys__category_name' => 'string',
'Categorys.category_name' => 'string',
'category_name' => 'string',
'Categorys__delete_flag' => 'boolean',
'Categorys.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Categorys__created' => 'datetime',
'Categorys.created' => 'datetime',
'created' => 'datetime',
'Categorys__modified' => 'datetime',
'Categorys.modified' => 'datetime',
'modified' => 'datetime',
'CategorySelects__id' => 'integer',
'CategorySelects.id' => 'integer',
'CategorySelects__category_id' => 'string',
'CategorySelects.category_id' => 'string',
'CategorySelects__shop_id' => 'integer',
'CategorySelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'matching' => [
'CategorySelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategorysTable) {}
}
$brands = 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.brand_id AS `Brands__brand_id`, Brands.brand_name AS `Brands__brand_name`, Brands.delete_flag AS `Brands__delete_flag`, Brands.created AS `Brands__created`, Brands.modified AS `Brands__modified` FROM brands Brands LEFT JOIN brand_selects BrandSelects ON Brands.brand_id = (BrandSelects.brand_id) WHERE (Brands.brand_id not like :c0 AND delete_flag IS NULL AND (BrandSelects.id) IS NULL)',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'id' => 'integer',
'Brands__brand_id' => 'string',
'Brands.brand_id' => 'string',
'brand_id' => 'string',
'Brands__brand_name' => 'string',
'Brands.brand_name' => 'string',
'brand_name' => 'string',
'Brands__delete_flag' => 'boolean',
'Brands.delete_flag' => 'boolean',
'delete_flag' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'modified' => 'datetime',
'BrandSelects__id' => 'integer',
'BrandSelects.id' => 'integer',
'BrandSelects__brand_id' => 'string',
'BrandSelects.brand_id' => 'string',
'BrandSelects__shop_id' => 'integer',
'BrandSelects.shop_id' => 'integer',
'shop_id' => 'integer',
'Shops__id' => 'integer',
'Shops.id' => 'integer',
'Shops__shopname' => 'string',
'Shops.shopname' => 'string',
'shopname' => 'string',
'Shops__shop_info' => 'text',
'Shops.shop_info' => 'text',
'shop_info' => 'text',
'Shops__shop_status' => 'integer',
'Shops.shop_status' => 'integer',
'shop_status' => 'integer',
'Shops__type' => 'integer',
'Shops.type' => 'integer',
'type' => 'integer',
'Shops__shop_shipping' => 'integer',
'Shops.shop_shipping' => 'integer',
'shop_shipping' => 'integer',
'Shops__tax_rate' => 'float',
'Shops.tax_rate' => 'float',
'tax_rate' => 'float',
'Shops__revenue_rate' => 'float',
'Shops.revenue_rate' => 'float',
'revenue_rate' => 'float',
'Shops__corporate_name' => 'string',
'Shops.corporate_name' => 'string',
'corporate_name' => 'string',
'Shops__corporate_name_kana' => 'string',
'Shops.corporate_name_kana' => 'string',
'corporate_name_kana' => 'string',
'Shops__lastname' => 'string',
'Shops.lastname' => 'string',
'lastname' => 'string',
'Shops__firstname' => 'string',
'Shops.firstname' => 'string',
'firstname' => 'string',
'Shops__postal_code' => 'string',
'Shops.postal_code' => 'string',
'postal_code' => 'string',
'Shops__state' => 'string',
'Shops.state' => 'string',
'state' => 'string',
'Shops__city' => 'string',
'Shops.city' => 'string',
'city' => 'string',
'Shops__address' => 'string',
'Shops.address' => 'string',
'address' => 'string',
'Shops__phone_number' => 'string',
'Shops.phone_number' => 'string',
'phone_number' => 'string',
'Shops__bussiness_hours' => 'text',
'Shops.bussiness_hours' => 'text',
'bussiness_hours' => 'text',
'Shops__selling_price' => 'text',
'Shops.selling_price' => 'text',
'selling_price' => 'text',
'Shops__payment_method' => 'text',
'Shops.payment_method' => 'text',
'payment_method' => 'text',
'Shops__product_delivery_time' => 'text',
'Shops.product_delivery_time' => 'text',
'product_delivery_time' => 'text',
'Shops__about_returns' => 'text',
'Shops.about_returns' => 'text',
'about_returns' => 'text',
'Shops__minimum_rental_period' => 'tinyinteger',
'Shops.minimum_rental_period' => 'tinyinteger',
'minimum_rental_period' => 'tinyinteger',
'Shops__delete_flag' => 'integer',
'Shops.delete_flag' => 'integer',
'Shops__created' => 'datetime',
'Shops.created' => 'datetime',
'Shops__modified' => 'datetime',
'Shops.modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'matching' => [
'BrandSelects' => [
[maximum depth reached]
]
],
'extraOptions' => [],
'repository' => object(App\Model\Table\BrandsTable) {}
}
$bufferLevel = (int) 1
$sku = object(App\Model\Entity\Skus) {
'id' => (int) 1699,
'sku_id' => 'ProductTest2_001_001',
'product_id' => 'ProductTest2',
'size_id' => (int) 1,
'color_id' => (int) 1,
'rental_price' => (int) 3000,
'base_price' => (int) 10000,
'monthly_price' => (int) 20000,
'rental_startdate' => null,
'rental_enddate' => null,
'product_status' => 'ランク5(新品)',
'rental_status' => 'ダミー',
'two_dress_flag' => null,
'delete_flag' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'modified' => object(Cake\I18n\FrozenTime) {},
'size' => object(App\Model\Entity\Size) {},
'color' => object(App\Model\Entity\Color) {},
'image_constitutions' => [],
'product' => object(App\Model\Entity\Product) {},
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[hasErrors]' => false,
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Skus'
}
include - APP/Template/Products/categoryproducts.ctp, line 31
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1435
Cake\View\View::_render() - CORE/src/View/View.php, line 1393
Cake\View\View::render() - CORE/src/View/View.php, line 892
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 791
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 256
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 100
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Maintenance\Middleware\MaintenanceMiddleware::__invoke() - ROOT/vendor/fusic/maintenance/src/Middleware/MaintenanceMiddleware.php, line 46
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 164
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65