In CakePHP 2 I usually used Hash::combine to provide me some useful
grouping of the DB data.
Let me show you an example:
Original array:
<?php $data_rows = $this->find('all', $query); ?>
// Output
array(
(int) 0 => array(
'DataRow' => array(
'id' => '70',
'section_id' => '2',
'group' => 'extrahotelero',
'date' => '2014-01-01',
'value' => '93150'
)
),
(int) 1 => array(
'DataRow' => array(
'id' => '202',
'section_id' => '5',
'group' => 'hotelero',
'date' => '2014-01-01',
'value' => '91.83'
)
),
### more results ###
)
Use combine to group results in a fancy way:
<?php $data_rows = Hash::combine($data_rows, '{n}.DataRow.id', '{n}.DataRow'
, '{n}.DataRow.group'); ?>
//Output
array(
'extrahotelero' => array(
(int) 70 => array(
'id' => '70',
'section_id' => '2',
'group' => 'extrahotelero',
'date' => '2014-01-01',
'value' => '93150'
),
(int) 97 => array(
'id' => '97',
'section_id' => '5',
'group' => 'extrahotelero',
'date' => '2014-01-01',
'value' => '48.91'
),
### more results ###
),
'hotelero' => array(
(int) 202 => array(
'id' => '202',
'section_id' => '5',
'group' => 'hotelero',
'date' => '2014-01-01',
'value' => '91.83'
),
(int) 193 => array(
'id' => '193',
'section_id' => '4',
'group' => 'hotelero',
'date' => '2014-01-01',
'value' => '7'
),
### more results ###
)
I tried the same with CakePHP3 without success using Collection:combine (as
part of transformation after a query) and even tried mapReduce() (the
result was near the expected, but I don't know how to get second level
array keys.
Collection:indexBy() and Collection:groupBy() helped.
Maybe the problem is a limitation of the dot notation?
Collection:combine('id', '{n}', 'group') didn't work.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
