Thanks for you answer Lorenzo.
collection($entities)->combine('id', function ($row) { return $row}, 'group'
);
Worked like a charm.
collection($entities)->indexBy('id')->groupBy('group');
Didn't work, inner array isn't indexed by id.
I'm trying something like this:
$this->find()
->where(['section_id IN' => $sections])
->each(function ($entity){
$entity->dateStr = $entity->date->toDateString();
return $entity;
})
//->combine('id', function ($row) { return $row; }, 'dateStr')
->indexBy('id')
->GroupBy('dateStr')
->toArray();
The second way sounds more interesting to me, more easy to remember and use
that declaring a closure. So I really interested in learn how to use it
properly.
Cheers.
El sábado, 9 de mayo de 2015, 15:42:56 (UTC+1), José Lorenzo escribió:
>
> $combined = collection($entities)->combine('id', function ($row) { return
> $row}, 'group');
>
> The function in the second argument will return the same row without
> extracting any property from it. This is also equivalent to doing:
>
> $combined = collection($entities)->indexBy('id')->groupBy('group');
>
> On Saturday, May 9, 2015 at 4:33:54 PM UTC+2, Aday Talavera wrote:
>>
>> 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.
