| # |
Apr 20th 2017, 13:31 |
 nk-sonu |
is setForeignKey() and setBindingKey is my friend ? |
| # |
Apr 20th 2017, 13:29 |
spriz |
read through this https://book.cakephp.org/3.0/en/orm/associations.html |
| # |
Apr 20th 2017, 13:28 |
spriz |
I think you can use the conditions of the assoc then |
| # |
Apr 20th 2017, 13:27 |
nk-sonu |
becuase there is common panno in all tables... |
| # |
Apr 20th 2017, 13:27 |
spriz |
how would one know what to join then? |
| # |
Apr 20th 2017, 13:26 |
nk-sonu |
yes.. but there is issue with foreign key .. there is no foreign key like customer_id |
| # |
Apr 20th 2017, 13:25 |
spriz |
and you also have table classes like that for the other tables you want to join? |
| # |
Apr 20th 2017, 13:24 |
nk-sonu |
yes |
| # |
Apr 20th 2017, 13:21 |
spriz |
you have a CustomersTable.php ? |
| # |
Apr 20th 2017, 13:21 |
spriz |
no you don't |
| # |
Apr 20th 2017, 13:19 |
nk-sonu |
i am also a developer who landed with parachute in this module.. thats why i need to work with join |
| # |
Apr 20th 2017, 13:15 |
spriz |
I meant TableClasses rather than database tables |
| # |
Apr 20th 2017, 13:15 |
nk-sonu |
thats why i am doing join |
| # |
Apr 20th 2017, 13:14 |
spriz |
woops :) |
| # |
Apr 20th 2017, 13:14 |
nk-sonu |
the tables are not setup properly and there is nothing with cakephp convention. |
| # |
Apr 20th 2017, 13:14 |
spriz |
->contain(['Fds', 'Ncds', 'Ipos']); |
| # |
Apr 20th 2017, 13:14 |
spriz |
$mf->find() |
| # |
Apr 20th 2017, 13:14 |
spriz |
contain does the join if you setup your tables properly |
| # |
Apr 20th 2017, 13:13 |
spriz |
when using ->contain() then you should not use join yourself |
| # |
Apr 20th 2017, 13:13 |
spriz |
read the link I sent you |
| # |
Apr 20th 2017, 13:13 |
nk-sonu |
@spriz join i a requirement here.. but condition is not coming in sql i checked there.. |
| # |
Apr 20th 2017, 13:11 |
spriz |
and if you use the contain, remove the ->join() |
| # |
Apr 20th 2017, 13:11 |
spriz |
@nk-sonu I said it a few times - just the query doesn't provide enough information to help |
| # |
Apr 20th 2017, 13:08 |
nk-sonu |
but i am not getting data of associated tables |
| # |
Apr 20th 2017, 13:08 |
nk-sonu |
->contain(['Fds', 'Ncds', 'Ipos']) |
| # |
Apr 20th 2017, 13:07 |
inoas |
nk-sonu try what |
| # |
Apr 20th 2017, 13:07 |
nk-sonu |
i again try with contain() but no luck |
| # |
Apr 20th 2017, 13:01 |
admad |
heh |
| # |
Apr 20th 2017, 13:01 |
inoas |
EnableBehavior ;) |
| # |
Apr 20th 2017, 13:01 |
inoas |
AbleBehavior |
| # |
Apr 20th 2017, 13:00 |
admad |
no behavior is gonna get the silly "able" suffix under my watch :slightly_smiling_face: |
| # |
Apr 20th 2017, 12:59 |
inoas |
oh wait... then people delete it after install |
| # |
Apr 20th 2017, 12:59 |
inoas |
better name it TrashableBehavior ;)) |
| # |
Apr 20th 2017, 12:59 |
spriz |
but indeed it does.. :thinking_face: |
| # |
Apr 20th 2017, 12:59 |
inoas |
care to take out the trash :p? |
| # |
Apr 20th 2017, 12:59 |
spriz |
:) Not fun! :) |
| # |
Apr 20th 2017, 12:59 |
inoas |
especially if it trashes your unit tests :p |
| # |
Apr 20th 2017, 12:58 |
inoas |
TrashBehavior has a cool double-meaning |
| # |
Apr 20th 2017, 12:58 |
iqu |
inoas: it has been jquery for me too |
| # |
Apr 20th 2017, 12:58 |
spriz |
Ah, TrashBehavior whacks up my unit test - any tips on how to avoid loading behaviors but still test the behavior of a afterSave function? :thinking_face: |
| # |
Apr 20th 2017, 12:58 |
inoas |
throw it at your frontend, solve all the small things-jquery-style |