Log message #4187100

# At Username Text
# May 21st 2019, 16:42 admad @hollistergraham123 `['Inventorys.store_id = Repairs.store_id']`
# May 21st 2019, 16:40 waspinator that makes sense. not sure how to do it though. sorry
# May 21st 2019, 16:36 hollistergraham123 Right now I’m just getting the repair then using it’s store_id in the condition. But it seems like a unnecessary query.
# May 21st 2019, 16:34 hollistergraham123 Yeah, I want to do a where Inventorys.store_id = Repairs.store_id which I can do in sql I just don’t know how to do it in the ORM
# May 21st 2019, 16:33 waspinator oh, you already do that.
# May 21st 2019, 16:32 waspinator contain?
# May 21st 2019, 16:32 waspinator https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#retrieving-associated-data
# May 21st 2019, 16:31 hollistergraham123 I’ve seen matching and used it but I don’t see how to use it when I don’t have a static variable. I.e. I don’t know the store_id. I wanna get a repair and get the inventory record for it’s parts for the store that, that repair belongs to
# May 21st 2019, 16:23 waspinator https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#filtering-by-associated-data-via-matching-and-joins
# May 21st 2019, 16:21 hollistergraham123 How do I query for a parents value i.e. $this->Repairs->find()->contain([‘Parts’ => function (Query $q) { return $q->select($this->Parts)->contain([‘Inventorys’])->select($this->Parts->Inventorys)->where([‘Inventorys.store_id’ => ‘Repairs.store_id’]); }]; in cakephp orm
# May 21st 2019, 16:06 birdy247 I am now trying to solve them logging in the widget which should also set their session in the php app
# May 21st 2019, 16:05 birdy247 @neon1024 good point
# May 21st 2019, 15:30 neon1024 Or at least handle the failure gracefully
# May 21st 2019, 15:30 neon1024 Ensure if they logout in the PHP application, that the widget doesn’t submit data to a session which doesn’t exist :slightly_smiling_face:
# May 21st 2019, 15:17 birdy247 @neon1024 I went with the simple approach of just doing a get request to the server and then it checks the session
# May 21st 2019, 14:50 itmpls 'plugin' => 'Customers', 'controller' => 'Customers', 'action' => 'index' fed to 'url' of Form->create generats just /customers/customeres. Is theereee anyway to make /indeex stick? E keey brokeen, sorry for thee typos lol
# May 21st 2019, 14:43 neon1024 https://github.com/Xety/Cake3-CookieAuth
# May 21st 2019, 14:42 birdy247 you planted the cookie seed
# May 21st 2019, 14:42 birdy247 yes, what I said above
# May 21st 2019, 14:42 birdy247 designing a solution
# May 21st 2019, 14:41 neon1024 Not even like pencil and paper design
# May 21st 2019, 14:41 neon1024 Have you literally tried nothing yet?
# May 21st 2019, 14:41 neon1024 Send the cookie content to the endpoint and do it php
# May 21st 2019, 14:41 neon1024 Don’t do that.
# May 21st 2019, 14:41 neon1024 Are you going to ask how to de-hash in the widget?
# May 21st 2019, 14:40 birdy247 thats fine
# May 21st 2019, 14:40 birdy247 No, I understand how to do it on the server
# May 21st 2019, 14:40 neon1024 Is that a serious question?
# May 21st 2019, 14:40 neon1024 :man-shrugging:
# May 21st 2019, 14:40 neon1024 I mean, like the one in the core
# May 21st 2019, 14:40 neon1024 Using the hash method?
# May 21st 2019, 14:39 birdy247 How would you has the cookie?
# May 21st 2019, 14:37 neon1024 ..but cookies have expiration as well, so that’s up to you
# May 21st 2019, 14:37 neon1024 You can include a datetime in the hash in the cookie too, so you know if it doesn’t match it’s expired
# May 21st 2019, 14:37 neon1024 I tend to use a hash of data which I know, so that I can recreate the hash when I check the cookie
# May 21st 2019, 14:36 neon1024 Just don’t obviously put the users password in the cookie
# May 21st 2019, 14:36 neon1024 I mean, your implementation is your own
# May 21st 2019, 14:36 neon1024 :man-shrugging:
# May 21st 2019, 14:36 neon1024 You could pass the cookie content you’ve written to your server code
# May 21st 2019, 14:34 birdy247 presumably the server could do its thing?
# May 21st 2019, 14:34 birdy247 If we were to literally pass the contents of the cookie to the server