| # |
Jun 11th 2018, 11:36 |
joopm |
but can not see anything according too autotables |
| # |
Jun 11th 2018, 11:34 |
joopm |
Cake\ORM\Association->attachTo(Object(Cake\ORM\Query), Array) |
| # |
Jun 11th 2018, 11:34 |
joopm |
Cake\ORM\Association->find('External', Array) |
| # |
Jun 11th 2018, 11:33 |
joopm |
ican see like this :Cake\ORM\Table->find('External', Array) |
| # |
Jun 11th 2018, 11:33 |
joopm |
well on the error.log : |
| # |
Jun 11th 2018, 11:33 |
joopm |
:lorenzo thank you that you still not gave up |
| # |
Jun 11th 2018, 11:31 |
 lorenzo |
joopm did you figure out if debukit is giving you a warning about auto tables? |
| # |
Jun 11th 2018, 11:23 |
edoreld |
thanks |
| # |
Jun 11th 2018, 11:22 |
josbeir |
debug($entity->errors()); |
| # |
Jun 11th 2018, 11:19 |
edoreld |
How can I debug a failing form? |
| # |
Jun 11th 2018, 11:11 |
edgaras.jan |
sorry i was wrong i used findExternal(as you described) but still error |
| # |
Jun 11th 2018, 11:10 |
slackebot |
inputfield is an email and send the correct key/values from client, but I'm curious if there is a way to implement it in the API |
| # |
Jun 11th 2018, 11:10 |
ksc |
Hi there, Has anyone an example how to allow login with email or username in the same requestfield? (API context, i don't use the cake views) e.g.: "login": "username" OR "email", "password":"******" It works with "email" and "username" in extra inputfields, but i try to allow both from one inputfield. The Auth component restricts that because it uses directly the requestData which is protected. I could check clientside if the |
| # |
Jun 11th 2018, 11:09 |
edgaras.jan |
findExternal, not finderExternal |
| # |
Jun 11th 2018, 11:08 |
joopm |
i use public function finderExternal(..){...} |
| # |
Jun 11th 2018, 11:08 |
edgaras.jan |
i did exactly as you described but i still get the same error Unknown finder method "External" |
| # |
Jun 11th 2018, 11:04 |
edgaras.jan |
> when i tried to use this in the model association 'finder'=>'findExternalCheck' > gives me error Unknown finder method however the function is placed in the ModelTable you need remove 'find' prefix |
| # |
Jun 11th 2018, 11:01 |
edgaras.jan |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#custom-finder-methods |
| # |
Jun 11th 2018, 11:01 |
edgaras.jan |
you need add custom finders in Table class, ex `function findMyFinder()`, then use `->find('myFinder')` or 'finder' => 'myFinder' (no 'find' prefix) |
| # |
Jun 11th 2018, 10:55 |
joopm |
where should i exactly define the custome find method |
| # |
Jun 11th 2018, 10:54 |
joopm |
maybe i am doing wrong the conditional model association |
| # |
Jun 11th 2018, 10:53 |
loginews |
alright. I will go and try all this and get back here if i am stuck. |
| # |
Jun 11th 2018, 10:52 |
edgaras.jan |
you can also `$this->Rep01->find()->innerJoinWith(...)`, but you would need define JOIN statement everytime. Now you define relation once in Table, and then use relation name in `contain()` |
| # |
Jun 11th 2018, 10:49 |
loginews |
@edgaras.jan You see, for someone like me who has written thousands of lines of php and mysql, I am a bit surprised that it is so complex to just extract a few columns from 2 inner joined tables. |
| # |
Jun 11th 2018, 10:48 |
edgaras.jan |
you need both |
| # |
Jun 11th 2018, 10:48 |
loginews |
ok so I need both. |
| # |
Jun 11th 2018, 10:48 |
edgaras.jan |
`contain will join another table depending on how you have configured relation using `belongsTo` |
| # |
Jun 11th 2018, 10:46 |
loginews |
so I don't need belongsTo in my table model ? |
| # |
Jun 11th 2018, 10:46 |
edgaras.jan |
`$query = $this->Rep01->find()->contain('saleitem');` |
| # |
Jun 11th 2018, 10:45 |
edgaras.jan |
`contain()` will add JOIN |
| # |
Jun 11th 2018, 10:45 |
loginews |
@edgaras.jan. I want to display some columns in cakephp via index.ctp |
| # |
Jun 11th 2018, 10:44 |
loginews |
@edgaras.jan My aim is very simple. I have to SELECT * FROM psales INNER JOIN saleitem ON psales.VOUNO=saleitem.INVREF. |
| # |
Jun 11th 2018, 10:44 |
edgaras.jan |
or 'saleitem', because your current code doesn't use cake convensions, so I don't know well |
| # |
Jun 11th 2018, 10:43 |
edoreld |
File uploaded https://cakesf.slack.com/files/UB4FMM7H6/FB686M9AT/-.php / https://slack-files.com/T053DPNCM-FB686M9AT-ddaf04f351 |
| # |
Jun 11th 2018, 10:43 |
edgaras.jan |
you need `->contain('saleitems')` in controller |
| # |
Jun 11th 2018, 10:42 |
edoreld |
I created the entity in my controller but it still says 'undefined variable' :S |
| # |
Jun 11th 2018, 10:42 |
loginews |
@edgaras.jan I get this: Notice (8): Trying to get property of non-object [APP/Template\Rep01\index.ctp, line 32] when I put $psale->VOUNO->ITEMNUM |
| # |
Jun 11th 2018, 10:39 |
loginews |
let me try... |
| # |
Jun 11th 2018, 10:39 |
edgaras.jan |
`$psale->VOUNO` is entity Saleitem, use `$psale->VOUNO->ITEMNUM` |
| # |
Jun 11th 2018, 10:37 |
loginews |
File uploaded https://cakesf.slack.com/files/U435V89H8/FB4L1UJ57/learning_association.txt / https://slack-files.com/T053DPNCM-FB4L1UJ57-6c98b46968 - But the second column (i.e. ITEMNUM) does not work. |
| # |
Jun 11th 2018, 10:31 |
edgaras.jan |
You can use `$category->posts`, and if you have baked entity correctly, you IDE will know it is `Post[]` and will help autocomplete rest of code |