| # |
Jul 10th 2019, 12:36 |
 admad |
and our batting after the 3 top is equally shitty |
| # |
Jul 10th 2019, 12:34 |
admad |
@neon1024 your shitty weather screwed us over :P |
| # |
Jul 10th 2019, 12:28 |
lorenzo |
sad that the pipe operator never got a voting |
| # |
Jul 10th 2019, 12:27 |
lorenzo |
no, you need to filter then out with distinct or group by |
| # |
Jul 10th 2019, 12:21 |
inoas |
thanks for pointing the way without difficult exists/union things |
| # |
Jul 10th 2019, 12:19 |
inoas |
so I get some true duplicates that I can remove with distinct - there is nothing I can do abou,r ight? |
| # |
Jul 10th 2019, 12:18 |
inoas |
ok will do the same - a pipe operator would be nice https://wiki.php.net/rfc/pipe-operator |
| # |
Jul 10th 2019, 12:13 |
lorenzo |
I prefer assigning the variable again |
| # |
Jul 10th 2019, 12:12 |
inoas |
btw is it good style to write $query = $query->mutatingBuilderMethod() or just $query->mutatingBuilderMethod? |
| # |
Jul 10th 2019, 12:10 |
lorenzo |
no, the the where() clause needs to be in the parent query |
| # |
Jul 10th 2019, 12:10 |
inoas |
so not within the closure |
| # |
Jul 10th 2019, 12:10 |
lorenzo |
`leftJoinWith('TariffsManufacturers.Manufacturers')->where(['OR' => ['Manufacturers.id IS' =>null, $conditions])` |
| # |
Jul 10th 2019, 12:10 |
inoas |
working on that now - thanks |
| # |
Jul 10th 2019, 12:09 |
lorenzo |
ionas I think I just wrote the exact code 2 messages ago :slightly_smiling_face: |
| # |
Jul 10th 2019, 12:05 |
inoas |
lorenzo I got a working reduced case in raw SQL now: https://gist.github.com/inoas/18618c0ad24ec11d27867dd923322a6c - but I am not sure how to best translate that to the orm |
| # |
Jul 10th 2019, 11:46 |
inoas |
let me try |
| # |
Jul 10th 2019, 11:46 |
inoas |
now that sounds like I can udnerstand it at least |
| # |
Jul 10th 2019, 11:46 |
lorenzo |
that is similar to the approach of `notMatching` but you have a bit more control |
| # |
Jul 10th 2019, 11:45 |
lorenzo |
`leftJoinWith($stuff)->where(['OR' => ['Manufacturers.id IS' =>null, $conditions])` |
| # |
Jul 10th 2019, 11:44 |
lorenzo |
ionas you can do it with a leftJoinWith |
| # |
Jul 10th 2019, 11:38 |
inoas |
is there a more transparent way to do it, this seems like venn-diagram double negation by my gut, I am still trying to wrap my head around it |
| # |
Jul 10th 2019, 11:36 |
inoas |
can I do notInnerJoinWith ;)? |
| # |
Jul 10th 2019, 11:36 |
inoas |
AND (Manufacturers.id) IS NULL) that seems to be injected |
| # |
Jul 10th 2019, 11:35 |
inoas |
but I don't understand it entirely |
| # |
Jul 10th 2019, 11:33 |
inoas |
the test data wasn't good |
| # |
Jul 10th 2019, 11:33 |
inoas |
lorenzo I think your notMatching works after all |
| # |
Jul 10th 2019, 11:29 |
dereuromark |
the callback could also need some example and use cases shown. |
| # |
Jul 10th 2019, 11:23 |
inoas |
lorenzo I am back |
| # |
Jul 10th 2019, 11:11 |
neon1024 |
Although as that’s wrapped by `get()` perhaps not as pertinent |
| # |
Jul 10th 2019, 11:11 |
neon1024 |
I can’t see `firstOrFail` either |
| # |
Jul 10th 2019, 11:11 |
ricksaccous |
for the longest time i didn't know findOrCreate had a callback, lol |
| # |
Jul 10th 2019, 11:09 |
dereuromark |
Why is findOrCreate not sth found on the book/docs? thats kinda weird, also not on https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html itself |
| # |
Jul 10th 2019, 10:28 |
neon1024 |
What’s happening @admad :cricket_bat_and_ball: :,) |
| # |
Jul 10th 2019, 10:19 |
np |
Hello https://stackoverflow.com/questions/56967784/cakephp-3-how-to-do-document-useimmutable-method-in-bootstrap-php |
| # |
Jul 10th 2019, 09:32 |
felix.robaglia |
correct way is $this->Flash->success(__('id {0} has been disabled', $user->id)); |
| # |
Jul 10th 2019, 09:32 |
felix.robaglia |
I found out why it wasn't working, I writed the $user->id outside of the parenthesis. |
| # |
Jul 10th 2019, 09:32 |
slackebot |
some answers - Zend, Symfony and Code Igniter were basically the only opponents, and they had a lot of their own architecture and/or usage/mvc problems. Also, php4/php5 compatibility for a long, long time. And development cycle, and the ownership of project transferred to non-profit corp, there are many reasons why is this project still alive (and more than just alive). |
| # |
Jul 10th 2019, 09:32 |
storkovo |
@mfauzan828 I think of Japan as of country with strong feelings for traditions, conventions... CakePHP had clear conventions since day one, core team and community defended them even against lead developer, and after all these years it is ok to say that CakePHP has some traditions... ;-) Just kidding, Japan part of cake community was always strong. I would suggest to compare “state of art” of PHP MVC frameworks back in spring 2005, there |
| # |
Jul 10th 2019, 09:31 |
dereuromark |
$postedTitle etc |
| # |
Jul 10th 2019, 09:31 |
dereuromark |
usually it also auto-escapes for security reasons. just check this when using more custom input here. |
| # |
Jul 10th 2019, 09:30 |
dereuromark |
of course |