| # |
Feb 3rd 2018, 21:30 |
 davinci |
and no, not right then. They're added from beforeFinds from behaviors, plugins...etc. So it's not as simple as just looking at the single query code row |
| # |
Feb 3rd 2018, 21:29 |
davinci |
Right. They should be. But they don't seem to be, and I have no way to debug what it's actually using as that param value |
| # |
Feb 3rd 2018, 21:28 |
ahmed_bodi |
those would be whatever your providing right e.g. $table->find()->where(['user_id' => $user_id])->all(); otherwise they would just be an aliased name for each column in the table |
| # |
Feb 3rd 2018, 21:27 |
davinci |
when I debug the object, it shows params => [ :c1, :c2 ..etc, but I want to see what values those `:c1`, `:c2` are |
| # |
Feb 3rd 2018, 21:27 |
ahmed_bodi |
@davinci which params? |
| # |
Feb 3rd 2018, 21:27 |
davinci |
How can I get the 'params' from a query object? |
| # |
Feb 3rd 2018, 21:24 |
ahmed_bodi |
@hmic quick query is there any way to use the tree queries with contain to get the link back to the users model? |
| # |
Feb 3rd 2018, 21:06 |
hmic |
thats *the* solution to store tree like data in a flat table, scientifically proven design ;-) |
| # |
Feb 3rd 2018, 21:05 |
ahmed_bodi |
i'll try then and pop back with my results |
| # |
Feb 3rd 2018, 21:05 |
hmic |
welcome! |
| # |
Feb 3rd 2018, 21:05 |
ahmed_bodi |
thanks @hmic |
| # |
Feb 3rd 2018, 21:05 |
ahmed_bodi |
i spent hours reading all of github and i thought most of the docs |
| # |
Feb 3rd 2018, 21:05 |
ahmed_bodi |
oh wow, i cant believe i missed that |
| # |
Feb 3rd 2018, 21:04 |
davinci |
https://stackoverflow.com/questions/48602025/how-to-get-params-from-query-object-in-cakephp-3 |
| # |
Feb 3rd 2018, 21:04 |
hmic |
https://book.cakephp.org/3.0/en/orm/behaviors/tree.html |
| # |
Feb 3rd 2018, 21:04 |
hmic |
well, change the one you've got accordinly |
| # |
Feb 3rd 2018, 21:04 |
hmic |
you first create a table that holds that tree structure |
| # |
Feb 3rd 2018, 21:03 |
ahmed_bodi |
how would i do that with my queries? |
| # |
Feb 3rd 2018, 21:03 |
hmic |
use a tree structure? |
| # |
Feb 3rd 2018, 21:03 |
ahmed_bodi |
anyone know of any solutions? |
| # |
Feb 3rd 2018, 21:03 |
ahmed_bodi |
now any more than one and i get a null object, i believe reading from github its due to the same alias for each field |
| # |
Feb 3rd 2018, 21:02 |
ahmed_bodi |
Basically get the next 3 nested referrers |
| # |
Feb 3rd 2018, 21:02 |
ahmed_bodi |
So im trying to run a query like this $this->Users->get($id, ['contain' => ['Referrer', 'Referrer.Referrer', 'Referrer.Referrer']]); |
| # |
Feb 3rd 2018, 21:02 |
ahmed_bodi |
I've got users object with a relationship to itself on a different field |
| # |
Feb 3rd 2018, 21:01 |
ahmed_bodi |
HI guys, im wondering if anyones got any experience with anything like this |
| # |
Feb 3rd 2018, 20:23 |
greenjam94 |
Ok, I'll look into it |
| # |
Feb 3rd 2018, 20:19 |
hmic |
greenjam94: use friendsofcake/bootstrap-ui plugin if you want to use bootstrap |
| # |
Feb 3rd 2018, 20:16 |
greenjam94 |
Hi, does anyone have experience with making forms look good? I am not using cake default css, but bootstrap 3.3.7 |
| # |
Feb 3rd 2018, 18:36 |
hmic |
sayed: thanks. good you found it! |
| # |
Feb 3rd 2018, 18:25 |
sayed |
It was because that row was soft deleted …. |
| # |
Feb 3rd 2018, 18:25 |
sayed |
By the way, the issue i was having earlier, i found the real reason of the error, to whom it may concern. |
| # |
Feb 3rd 2018, 18:06 |
kailas |
https://gist.github.com/kailasnarendran/87b59208b2305fd549b47afa80f8c31a This has working and non-working code |
| # |
Feb 3rd 2018, 18:04 |
kailas |
why doesn’t the associated term make the associated join table save? |
| # |
Feb 3rd 2018, 18:03 |
kailas |
geeez,rather than saving the TaxItem with [‘associated’=>[‘TaxItemX3Invoice’], I tried saving the _joinData specifically $TaxItemsX3Invoices->save($ti->_joinData) and it works |
| # |
Feb 3rd 2018, 18:01 |
sayed |
Thanks anyways !! |
| # |
Feb 3rd 2018, 18:00 |
sayed |
no idea why it was dying/passing on the initial one |
| # |
Feb 3rd 2018, 18:00 |
slackebot |
see that hte joinData is being set to the right value, and the save doesn’t generate any errors. however, the value saved to my table is 0 (rather than the 23.25 calculated). i’m guessing i’m just not doing the right save? any thoughts? |
| # |
Feb 3rd 2018, 18:00 |
kailas |
I’ve always been a bit challenged when it comes to saving data to a join table. I’ve got a pretty simple sample now that is not working as I would expect. see https://gist.github.com/anonymous/08e620154ea7bd30fe59291179b80eab X3Invoices->belongToMany(‘TaxItems’). In my X3Invoice entity, i have a method to recalculate taxes. I’m looping through tax items, and calculating the tax (_joinData->amount) for each. in my debug sta |
| # |
Feb 3rd 2018, 18:00 |
sayed |
…. |
| # |
Feb 3rd 2018, 18:00 |
sayed |
it did validate on the next attempt of inserting data |
| # |
Feb 3rd 2018, 18:00 |
sayed |
but by inserting a new row of data |