| # |
Oct 8th 2018, 09:39 |
 rudy1976s |
I using a table with a columns used as json type |
| # |
Oct 8th 2018, 09:39 |
rudy1976s |
good morning |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I’m not convinced there are any, but need to test anyway |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I need to test my application for injections |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
`->where(['example' => $escaped]);` |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
Just to sanity check, the values in a condition array are already escaped right? |
| # |
Oct 8th 2018, 08:00 |
turkles |
gooday |
| # |
Oct 8th 2018, 07:56 |
josbeir |
goood morning cakephphphhhhh |
| # |
Oct 8th 2018, 07:54 |
neon1024 |
Morning all |
| # |
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 |