# |
Oct 8th 2018, 07:15 |
turkles |
I don't see why you would want to lose all that lovely functionality by doing that |
# |
Oct 8th 2018, 07:15 |
turkles |
start_date is an object, so is at that level |
# |
Oct 7th 2018, 22:59 |
rightscoreanalysis |
[0] => [id => 103, start_date => 'xxxx', 'end_date' => 'xxxx', 'object' => [.........] ] |
# |
Oct 7th 2018, 22:58 |
rightscoreanalysis |
it could even be of the format: |
# |
Oct 7th 2018, 22:57 |
rightscoreanalysis |
but I would like start_and end_date extracted into the top level index |
# |
Oct 7th 2018, 22:57 |
slackebot |
<rightscoreanalysis> |
# |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
for example this is my collection after groupby id |
# |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
@admad do you know if I can add other fields to the index I have grouped by |
# |
Oct 7th 2018, 20:43 |
rightscoreanalysis |
perfect it works just as I need thank you |
# |
Oct 7th 2018, 20:41 |
admad |
`debug($roomPricesByPeriod->toArray());` |
# |
Oct 7th 2018, 20:36 |
rightscoreanalysis |
I'm not sure why |
# |
Oct 7th 2018, 20:36 |
rightscoreanalysis |
which outputs: 'count' => (int) 6 |
# |
Oct 7th 2018, 20:35 |
rightscoreanalysis |
$collection = new Collection($propertyTest->toArray()); $roomPricesByPeriod = $propertyTest->groupBy('id'); debug($roomPricesByPeriod); |
# |
Oct 7th 2018, 20:35 |
rightscoreanalysis |
thanks @admad I tried this: |
# |
Oct 7th 2018, 19:52 |
admad |
@rightscoreanalysis check out Collection::groupBy() |
# |
Oct 7th 2018, 19:45 |
rightscoreanalysis |
slept on it and this morning wrote the raw sql to fully understand my needs, which made writing the query in cake much easier |
# |
Oct 7th 2018, 19:44 |
rightscoreanalysis |
i was burning the midnight oil trying to nail it last night |
# |
Oct 7th 2018, 19:44 |
rightscoreanalysis |
btw I nailed that join eventually |
# |
Oct 7th 2018, 19:44 |
rightscoreanalysis |
that was an option but I thought I should try the cake way, but I'm happy enough to do my own processing |
# |
Oct 7th 2018, 19:43 |
dereuromark |
you dont. i think simple foreach loops are easier |
# |
Oct 7th 2018, 19:37 |
rightscoreanalysis |
I want to group the 30 items into 6 indexes |
# |
Oct 7th 2018, 19:36 |
rightscoreanalysis |
each of the 30 index items has one of six possible ids |
# |
Oct 7th 2018, 19:35 |
rightscoreanalysis |
I have an array of 30 items |
# |
Oct 7th 2018, 19:35 |
rightscoreanalysis |
I think I need the Hash class for what I want to do |
# |
Oct 7th 2018, 15:00 |
adithya |
@admad Thank you :slightly_smiling_face: |
# |
Oct 7th 2018, 14:44 |
slackebot |
~tell adithya about awesome |
# |
Oct 7th 2018, 14:44 |
slackebot |
Command sent from Slack by admad: |
# |
Oct 7th 2018, 14:24 |
adithya |
Hey guys, i'm looking for a plugin which will let me generate a PDF, i'm looking for an easy to use plugin, any leads? |
# |
Oct 7th 2018, 12:00 |
ssalvatori |
6.12 |
# |
Oct 7th 2018, 12:00 |
ssalvatori |
3.6.x |
# |
Oct 7th 2018, 11:59 |
isvyas |
Which CakePHP version are you using? |
# |
Oct 7th 2018, 11:17 |
ssalvatori |
and the login/logout works ok |
# |
Oct 7th 2018, 11:17 |
ssalvatori |
but if a check any other controller (without admin prefix everything is ok) |
# |
Oct 7th 2018, 11:15 |
ssalvatori |
I'm checking the includes and I can´t see the Model under app |
# |
Oct 7th 2018, 11:11 |
ssalvatori |
because everything works ok with bin/cake server |
# |
Oct 7th 2018, 11:10 |
ssalvatori |
i think its more apache conf issue |
# |
Oct 7th 2018, 11:06 |
ssalvatori |
public function initialize() { parent::initialize(); // TODO: Change the autogenerated stub $this->Users = TableRegistry::getTableLocator()->get('DcUsers'); } |
# |
Oct 7th 2018, 11:06 |
ssalvatori |
for that controller |
# |
Oct 7th 2018, 11:05 |
ssalvatori |
and in the line 54 $users = $this->paginate($this->Users); |
# |
Oct 7th 2018, 11:05 |
ssalvatori |
⟩ Cake\Controller\Controller->paginate APP/Controller/Admin/UsersController.php, line 54 |
# |
Oct 7th 2018, 11:05 |
ssalvatori |
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.dc_users' doesn't exist |