Skip to content

Instantly share code, notes, and snippets.

@artnos
Created August 17, 2015 19:14
Show Gist options
  • Save artnos/d679f0b64e7d821e0fd9 to your computer and use it in GitHub Desktop.
Save artnos/d679f0b64e7d821e0fd9 to your computer and use it in GitHub Desktop.
/src/Controller/DetailsController.php (line 141)
object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Details.id AS `Details__id`, Details.sku AS `Details__sku`, Details.product_id AS `Details__product_id`, Details.size AS `Details__size`, Details.style AS `Details__style`, Details.inventory AS `Details__inventory`, Details.modified AS `Details__modified`, Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.user_id AS `Products__user_id`, Products.brand_id AS `Products__brand_id`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.price AS `Products__price`, Products.msrp AS `Products__msrp`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Products.status AS `Products__status` FROM details Details INNER JOIN products Products ON Products.id = (Details.product_id)',
'params' => [],
'defaultTypes' => [
'Details.id' => 'integer',
'id' => 'integer',
'Details.sku' => 'string',
'sku' => 'string',
'Details.product_id' => 'integer',
'product_id' => 'integer',
'Details.size' => 'string',
'size' => 'string',
'Details.style' => 'string',
'style' => 'string',
'Details.inventory' => 'integer',
'inventory' => 'integer',
'Details.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Products' => []
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\DetailsTable) {
'registryAlias' => 'Details',
'table' => 'details',
'alias' => 'Details',
'entityClass' => 'App\Model\Entity\Detail',
'associations' => [
(int) 0 => 'products'
],
'behaviors' => [
(int) 0 => 'Timestamp'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
}
/src/Controller/DetailsController.php (line 142)
object(Cake\ORM\ResultSet) {
'query' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Details.id AS `Details__id`, Details.sku AS `Details__sku`, Details.product_id AS `Details__product_id`, Details.size AS `Details__size`, Details.style AS `Details__style`, Details.inventory AS `Details__inventory`, Details.modified AS `Details__modified`, Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.user_id AS `Products__user_id`, Products.brand_id AS `Products__brand_id`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.price AS `Products__price`, Products.msrp AS `Products__msrp`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Products.status AS `Products__status` FROM details Details INNER JOIN products Products ON Products.id = (Details.product_id)',
'params' => [],
'defaultTypes' => [
'Details.id' => 'integer',
'id' => 'integer',
'Details.sku' => 'string',
'sku' => 'string',
'Details.product_id' => 'integer',
'product_id' => 'integer',
'Details.size' => 'string',
'size' => 'string',
'Details.style' => 'string',
'style' => 'string',
'Details.inventory' => 'integer',
'inventory' => 'integer',
'Details.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Products' => []
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\DetailsTable) {
'registryAlias' => 'Details',
'table' => 'details',
'alias' => 'Details',
'entityClass' => 'App\Model\Entity\Detail',
'associations' => [
(int) 0 => 'products'
],
'behaviors' => [
(int) 0 => 'Timestamp'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
},
'items' => [
(int) 0 => object(App\Model\Entity\Detail) {
'id' => (int) 1,
'sku' => null,
'product_id' => (int) 1,
'size' => 'M',
'style' => 'red/blue',
'inventory' => (int) 50,
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T12:48:16+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'product' => object(App\Model\Entity\Product) {
'id' => (int) 1,
'sku' => 'N103',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Pink Pants',
'description' => 'hash',
'price' => (float) 19.5,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-10T18:58:38+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-14T18:54:40+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 1 => object(App\Model\Entity\Detail) {
'id' => (int) 2,
'sku' => null,
'product_id' => (int) 1,
'size' => 'XL',
'style' => 'deco',
'inventory' => (int) 20,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 1,
'sku' => 'N103',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Pink Pants',
'description' => 'hash',
'price' => (float) 19.5,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-10T18:58:38+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-14T18:54:40+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 2 => object(App\Model\Entity\Detail) {
'id' => (int) 3,
'sku' => null,
'product_id' => (int) 2,
'size' => 'M',
'style' => 'red/black',
'inventory' => (int) 50,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 2,
'sku' => '100',
'user_id' => (int) 1,
'brand_id' => (int) 2,
'name' => 'Red Jacket',
'description' => 'Jacket',
'price' => (float) 100,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-11T20:43:46+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T12:53:09+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 3 => object(App\Model\Entity\Detail) {
'id' => (int) 4,
'sku' => null,
'product_id' => (int) 1,
'size' => 'M',
'style' => 'Another style',
'inventory' => (int) 210,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 1,
'sku' => 'N103',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Pink Pants',
'description' => 'hash',
'price' => (float) 19.5,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-10T18:58:38+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-14T18:54:40+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 4 => object(App\Model\Entity\Detail) {
'id' => (int) 5,
'sku' => null,
'product_id' => (int) 1,
'size' => 'M',
'style' => 'last style',
'inventory' => (int) 500,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 1,
'sku' => 'N103',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Pink Pants',
'description' => 'hash',
'price' => (float) 19.5,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-10T18:58:38+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-14T18:54:40+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 5 => object(App\Model\Entity\Detail) {
'id' => (int) 6,
'sku' => null,
'product_id' => (int) 2,
'size' => 'm',
'style' => 'another one',
'inventory' => (int) 6,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 2,
'sku' => '100',
'user_id' => (int) 1,
'brand_id' => (int) 2,
'name' => 'Red Jacket',
'description' => 'Jacket',
'price' => (float) 100,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-11T20:43:46+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T12:53:09+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 6 => object(App\Model\Entity\Detail) {
'id' => (int) 7,
'sku' => null,
'product_id' => (int) 2,
'size' => 'XS',
'style' => 'another one',
'inventory' => null,
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T12:53:41+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'product' => object(App\Model\Entity\Product) {
'id' => (int) 2,
'sku' => '100',
'user_id' => (int) 1,
'brand_id' => (int) 2,
'name' => 'Red Jacket',
'description' => 'Jacket',
'price' => (float) 100,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-11T20:43:46+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T12:53:09+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 7 => object(App\Model\Entity\Detail) {
'id' => (int) 8,
'sku' => null,
'product_id' => (int) 1,
'size' => 'S',
'style' => 'red/blue',
'inventory' => (int) 10,
'modified' => null,
'product' => object(App\Model\Entity\Product) {
'id' => (int) 1,
'sku' => 'N103',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Pink Pants',
'description' => 'hash',
'price' => (float) 19.5,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-10T18:58:38+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-14T18:54:40+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 8 => object(App\Model\Entity\Detail) {
'id' => (int) 9,
'sku' => null,
'product_id' => (int) 4,
'size' => 'M',
'style' => 'another one',
'inventory' => (int) 100,
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T13:05:29+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'product' => object(App\Model\Entity\Product) {
'id' => (int) 4,
'sku' => 'N100',
'user_id' => (int) 1,
'brand_id' => (int) 1,
'name' => 'Red Shirt',
'description' => 'red Shirt',
'price' => (float) 19,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-12T13:07:29+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-12T20:13:10+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
},
(int) 9 => object(App\Model\Entity\Detail) {
'id' => (int) 10,
'sku' => null,
'product_id' => (int) 13,
'size' => 'M',
'style' => 'blank',
'inventory' => (int) 11,
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-15T13:10:01+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'product' => object(App\Model\Entity\Product) {
'id' => (int) 13,
'sku' => 'N55cb549ad9476',
'user_id' => (int) 1,
'brand_id' => (int) 2,
'name' => 'Expensive Shirt',
'description' => 'afdsdd',
'price' => (float) 1500.333,
'msrp' => null,
'created' => object(Cake\I18n\Time) {
'time' => '2015-08-12T14:08:53+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'modified' => object(Cake\I18n\Time) {
'time' => '2015-08-12T20:14:22+0000',
'timezone' => 'UTC',
'fixedNowTime' => false
},
'status' => (int) 2,
'[new]' => false,
'[accessible]' => [
'*' => true,
'tag_string' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Products'
},
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[repository]' => 'Details'
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment