Log message #4212901

# At Username Text
# Nov 8th, 17:18 samuel.assuncao Someone got a idea ?
# Nov 8th, 17:18 slackebot1 associations too, I do not see any example on documentation how i can do that with the cake ORM
# Nov 8th, 17:18 slackebot1 'Plants' ]); But Instead of getting the actual saved value from my table Purchase, I need get the data from the tables from a certain date. Sales Purchases to get volume_vendido -> created date and filter it to the $date(which is YYYY-MM-DD already) I also need the same for Purchases_Transfers (which is volume_transferido) and Purchase_Devolutions (which is volume_devolvido) So I need a where condition which will filter the
# Nov 8th, 17:18 samuel.assuncao $purchases = TableRegistry::get('Purchases')->find() ->where([ 'data_compra <=' => $date, 'volume_comprado + volume_transferido - volume_devolvido - volume_vendido > 0' ]) //certo ->matching('Plants') ->orderAsc('Plants.razao_social') ->orderAsc('Purchases.created') ->contain([ 'Distributors',
# Nov 8th, 17:18 samuel.assuncao Hi guys!
# Nov 8th, 12:51 dev.cyrusjayson and more <3
# Nov 8th, 12:50 dev.cyrusjayson more <3 here
# Nov 8th, 12:47 dev.cyrusjayson oh!
# Nov 8th, 12:46 frank @dev.cyrusjayson Yeah, it’s just because it’s looking in the namespace of your controller when you don’t define it at the top
# Nov 8th, 12:43 dev.cyrusjayson that is the response
# Nov 8th, 12:43 frank @dev.cyrusjayson use Cake\ORM\Query; at the top
# Nov 8th, 12:43 dev.cyrusjayson I get this error ``` [TypeError] Argument 1 passed to App\Controller\FruitsController::App\Controller\{closure}() must be an instance of App\Controller\Query, instance of Cake\ORM\Query given, called in ...```
# Nov 8th, 12:40 frank @dev.cyrusjayson This is what I mean, does this give the error also? ``` $fruits = $this->Fruits->find('all') ->contain(['GaveFruits' => function (Query $q) { return $q ->select(['id', 'name']) ->where(['user_id' => 1]); }]); ```
# Nov 8th, 12:37 frank @dev.cyrusjayson Wait, so with the `=>` it gave that as well?
# Nov 8th, 12:35 dev.cyrusjayson ‘Illegal offset type in isset or empty’
# Nov 8th, 12:32 frank @dev.cyrusjayson Okay, yeah that should work. What did the internal server error say, did it provide any context?
# Nov 8th, 12:31 dev.cyrusjayson here
# Nov 8th, 12:30 dev.cyrusjayson gave_fruits, sorry not in the screenshot
# Nov 8th, 12:29 frank @dev.cyrusjayson In which table is the user_id?
# Nov 8th, 12:24 dev.cyrusjayson this is the models
# Nov 8th, 12:22 dev.cyrusjayson following this is not helping https://book.cakephp.org/3/en/orm/retrieving-data-and-resultsets.html#passing-conditions-to-contain
# Nov 8th, 12:20 dev.cyrusjayson An Internal Server Error Occurred
# Nov 8th, 12:19 dev.cyrusjayson @frank I got internal error this is only thing is working but I want to filter the GaveFruits by user_id so I can get specific only ```$fruits = $this->Fruits->find('all') ->contain(['GaveFruits']);```
# Nov 8th, 12:16 frank @dev.cyrusjayson Could you try `'GaveFruits' => function ….` instead of `'GaveFruits', function ….` (arrow vs comma)
# Nov 8th, 12:08 slackebot1 [CORE/src/ORM/EagerLoader.php, line 410]``` but if I remove the ->where([‘user_id’ => 1]) everything is working so I think the problem is in ->where but based on the documentation, I am fopllowing it correctly
# Nov 8th, 12:08 dev.cyrusjayson I have this query ``` $fruits = $this->Fruits->find('all') ->contain(['GaveFruits',function (Query $q){ return $q ->select(['id', 'name']) ->where(['user_id' => 1]); }]); ``` and I get this error ```Warning (2): Illegal offset type in isset or empty
# Nov 8th, 12:01 pieceof whoami
# Nov 8th, 11:01 dev.cyrusjayson @frank noted on that. thanks
# Nov 8th, 10:59 frank @dev.cyrusjayson You can remove the foreignKey from the association definition. As you’re following the conventions Cake will know to use user_id for Users.
# Nov 8th, 10:52 dev.cyrusjayson sorry. it all works. thanks mate. that fucking cache save the day
# Nov 8th, 10:45 graziel what do you mean not working? you get error or something?
# Nov 8th, 10:38 dev.cyrusjayson This works! thank you. ``` $this->paginate = [ 'contain' => ['Customers', 'Statuses', 'Users'] ]; $orders = $this->paginate($this->Orders); $this->set(compact('orders')); ``` but my association not working. see below ``` $this->belongsTo('Users', [ 'foreignKey' => 'user_id' ]); ```
# Nov 8th, 10:34 dereuromark Going to release TinyAuth next generation auth plugin if someone wants to give early feedback before I release the major? Ideally the ones already using it and checking BC etc.
# Nov 8th, 10:31 dev.cyrusjayson ok
# Nov 8th, 10:31 graziel bin/cake orm_cache clear
# Nov 8th, 10:31 dev.cyrusjayson how?
# Nov 8th, 10:31 graziel try clearing orm cache
# Nov 8th, 10:31 dev.cyrusjayson do I need to compile something?
# Nov 8th, 10:30 dev.cyrusjayson what is going on. kinda frustrating
# Nov 8th, 10:30 dev.cyrusjayson even here I can’t see the user_id ``` $this->paginate = [ 'contain' => ['Customers', 'Statuses', 'Users'] ]; $orders = $this->paginate($this->Orders); $this->set(compact('orders')); ```
# Nov 8th, 10:29 dev.cyrusjayson it is not a field. it is association in users model