| # |
Oct 8th 2018, 21:11 |
 dereuromark |
also, you need to understand the basic ORM concepts. You can do get($id) on the table and then get the entity |
| # |
Oct 8th 2018, 21:11 |
dereuromark |
you got the entity, why do you want it again? |
| # |
Oct 8th 2018, 21:10 |
rightscoreanalysis |
there must be something similar in Cake? |
| # |
Oct 8th 2018, 21:10 |
rightscoreanalysis |
I know that in Magento for example you can get by id on an object |
| # |
Oct 8th 2018, 21:09 |
rightscoreanalysis |
in the above case 103 |
| # |
Oct 8th 2018, 21:09 |
dereuromark |
->id ? |
| # |
Oct 8th 2018, 21:01 |
rightscoreanalysis |
can do do something like $propertyPeriod->getId(103) |
| # |
Oct 8th 2018, 21:00 |
rightscoreanalysis |
[ (int) 0 => object(App\Model\Entity\PropertyPeriod) { 'id' => (int) 103, 'property_id' => (int) 51, 'start_date' => object(Cake\I18n\FrozenTime) { |
| # |
Oct 8th 2018, 21:00 |
rightscoreanalysis |
If i know the 'id' of PropertyPeriod: |
| # |
Oct 8th 2018, 20:14 |
rightscoreanalysis |
brb |
| # |
Oct 8th 2018, 20:13 |
rightscoreanalysis |
what I need is something like: $roomPricesByPeriod = $collection->groupBy('id'. 'start_date', 'end_date'); |
| # |
Oct 8th 2018, 20:12 |
rightscoreanalysis |
$collection = new Collection($propertyTest); $roomPricesByPeriod = $collection->groupBy('id'); |
| # |
Oct 8th 2018, 20:12 |
rightscoreanalysis |
so far I did this to group the ids which is what I need |
| # |
Oct 8th 2018, 20:11 |
rightscoreanalysis |
I just need to extract the start_date and end_date from each index and put it in the top level |
| # |
Oct 8th 2018, 20:11 |
rightscoreanalysis |
https://gist.github.com/spacebiscuit/dabfda259d39fd0cdcfc8032a3f58570 |
| # |
Oct 8th 2018, 20:11 |
rightscoreanalysis |
@ricksaccous see this gist |
| # |
Oct 8th 2018, 20:09 |
rightscoreanalysis |
I tried to read the book... after a while all of the methods look the same and I can't differentiate one form the other |
| # |
Oct 8th 2018, 20:09 |
rightscoreanalysis |
yeah it looks super powerful |
| # |
Oct 8th 2018, 20:09 |
ricksaccous |
it changes your life |
| # |
Oct 8th 2018, 20:09 |
ricksaccous |
whatever you find works, but i'd recommend using collection magic |
| # |
Oct 8th 2018, 20:08 |
rightscoreanalysis |
I might try and just hack it with a foreach |
| # |
Oct 8th 2018, 20:08 |
ricksaccous |
is different than extract() via collection |
| # |
Oct 8th 2018, 20:08 |
ricksaccous |
prob should share exactly what you are trying to extract, it's worth mentioning the extract that EntityInterface implements |
| # |
Oct 8th 2018, 20:07 |
ricksaccous |
@rightscoreanalysis yeah i would think so :slightly_smiling_face: |
| # |
Oct 8th 2018, 20:01 |
rightscoreanalysis |
I am really stuck on something that really doesn't look to be difficult |
| # |
Oct 8th 2018, 20:00 |
rightscoreanalysis |
can i extraxt objects with collections? |
| # |
Oct 8th 2018, 19:24 |
ricksaccous |
oh, neat |
| # |
Oct 8th 2018, 19:14 |
beakman |
@nk-sonu There's also `->sql()`; |
| # |
Oct 8th 2018, 18:57 |
ricksaccous |
https://book.cakephp.org/3.0/en/orm/query-builder.html#selecting-rows-from-a-table |
| # |
Oct 8th 2018, 18:57 |
ricksaccous |
@nk-sonu If you try to call debug() on a Query object, you will see its internal state and the SQL that will be executed in the database: |
| # |
Oct 8th 2018, 18:48 |
nk-sonu |
because i can see its only giving object.. but i need mysql query like this "SELECT * from `seminars` where (DATE(specific_date) IN ('2018-10-24', '2018-10-25', '2018-10-29')) OR week_day IN (1,4,3,6)" |
| # |
Oct 8th 2018, 18:47 |
nk-sonu |
is there any way in cakephp 3 to print raw mysql from cakephp query ? |
| # |
Oct 8th 2018, 18:46 |
rightscoreanalysis |
sure: https://gist.github.com/spacebiscuit/92e6a99cd0cd45174f54b843660e2856 |
| # |
Oct 8th 2018, 18:44 |
yuzl |
use pastebin/gist pls |
| # |
Oct 8th 2018, 18:44 |
rightscoreanalysis |
I want to extraxt the strat_date and and end_date and put them in an index below the top/main |
| # |
Oct 8th 2018, 18:43 |
slackebot |
<rightscoreanalysis> |
| # |
Oct 8th 2018, 18:43 |
rightscoreanalysis |
hi anyone able to help with this: my collection is in this format |
| # |
Oct 8th 2018, 18:39 |
yuzl |
someone here for help? |
| # |
Oct 8th 2018, 18:39 |
yuzl |
hi guys. i'm having some troubles saving associated data |
| # |
Oct 8th 2018, 18:34 |
beakman |
I know, I was building on top of your suggestion of using `IN`. |
| # |
Oct 8th 2018, 18:33 |
edgaras.jan |
you can't ``` 'OR' => [ 'DATE(specific_date)' => '2018-10-24', 'DATE(specific_date)' => '2018-10-24', ] ``` |