Log message #4170727

# At Username Text
# Oct 8th 2018, 09:41 rudy1976s the column is used to store record parameters and sometimes I need to query against a value contained in that field
# Oct 8th 2018, 09:40 rudy1976s can I use the json fields in the query builder ?
# 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