Log message #4201803

# At Username Text
# Sep 5th 2019, 13:15 david098 I got a querybuilder issue, I have clients who have many to many contracts what have many to many statements. I want to get all Clients with their active contracts (Contracts.published = 1) where there are statements due (Statements.periodend <= 2019-09-30). So if there is not an active contract or if there are no statements due under the contract i don't want to get the client in the resultset. Is this possible in 1 query(builder) or
# Sep 5th 2019, 13:04 leonardo.crecente actually print_r('Index'); exit;
# Sep 5th 2019, 13:03 leonardo.crecente in /httpdocs/blog/index.php I,ve put a print_r(); exit; to see if request gets there...
# Sep 5th 2019, 13:02 alexdd55976 ah.. ok.. its no subfolder shown for the cake
# Sep 5th 2019, 13:02 leonardo.crecente In any case the website url: http://www.savane.com.br and the blog url: http://www.savane.com.br/blog
# Sep 5th 2019, 12:08 spriz or at least play around with some of the existing rectors
# Sep 5th 2019, 12:09 dereuromark Once you are an expert please also contribute this to IdeHelper for better variable collection :)
# Sep 5th 2019, 12:16 ndm @val That can be achieved by setting the corresponding table class' table name so that it includes the database, like `$this->setTable('my_database.users')` instead of the default `$this->setTable('users')`.
# Sep 5th 2019, 13:01 alexdd55976 so it should be yourdomain.ltd/ and yourdomain.ltd/blog
# Sep 5th 2019, 12:59 leonardo.crecente but not success
# Sep 5th 2019, 12:59 leonardo.crecente I followed this stackoverflow post: https://stackoverflow.com/questions/55240956/wordpress-installed-in-cakephp-subfolder-on-iis-window-server
# Sep 5th 2019, 12:58 alexdd55976 should not be a problem
# Sep 5th 2019, 12:58 leonardo.crecente ON /httpdocs/app
# Sep 5th 2019, 12:58 alexdd55976 where is your cake app?
# Sep 5th 2019, 12:57 leonardo.crecente hey guys! I'm working on a cakephp 2.x project hosted on a windows/iis 7.5 server runnig php 7.0. The website is working perfectly but there is a wordpress installation inside /httpdocs/blog folder (I know this is not the right way to do it but unfotunately I can't change it). The question is: Is there a way to make wordpress work inside /blog folder on iis? On apache I know it is possibly.
# Sep 5th 2019, 12:53 val @admad what plugin do you refer to?
# Sep 5th 2019, 12:52 admad *could be
# Sep 5th 2019, 12:52 admad cakephp-utils could also be working just fine. Might just need updating usage of deprecated methods if at all
# Sep 5th 2019, 12:50 admad https://github.com/FriendsOfCake/awesome-cakephp#auditing--logging
# Sep 5th 2019, 12:50 admad widen your gaze instead of fixating on one plugin/repo
# Sep 5th 2019, 12:48 val @admad awesome links to cakephp-utils which seems to be dead
# Sep 5th 2019, 12:46 slackebot !tell bancer about awesome
# Sep 5th 2019, 12:46 slackebot Command sent from Slack by admad:
# Sep 5th 2019, 12:46 val Is there a better place to find WhoDidItBehavior for 3.x?
# Sep 5th 2019, 12:43 val https://github.com/cakemanager/cakephp-utils is that a dead project?
# Sep 5th 2019, 12:08 spriz Yeah, I think it's time to read up on AST properly
# Sep 5th 2019, 11:57 dereuromark Sounds like a custom rector script or in general custom regex Upgrade app command/task or sth :slightly_smiling_face:
# Sep 5th 2019, 12:01 spriz Yeah, my first thought was rector as well
# Sep 5th 2019, 12:07 dereuromark regex i wouldnt use, too many errors possible. Either token (like I use for IdeHelper) or better yet AST (rector, ...).
# Sep 5th 2019, 11:54 spriz eg if you have Spanish strings in code, and have English in a `.po` file and want to swap so you have English strings in code and Spanish in `.po` files?
# Sep 5th 2019, 11:53 spriz Have anyone had luck with rector or some other automated solution to change the language of the source language in eg `__('foo')` to another language from a .po file?
# Sep 5th 2019, 11:53 val Hi, is there an easy way to force associations to use full table name like `LEFT JOIN my_database.users` instead `LEFT JOIN users` in 3.x?
# Sep 5th 2019, 11:51 Nitrogen indeed it does!
# Sep 5th 2019, 11:49 ndm No problem... not returning a response should work too, ie instead of `return $this->response->withDownload()` use `$this->response = $this->response->withDownload()`.
# Sep 5th 2019, 11:48 Nitrogen @ndm, $this->render() helped, thanks a bunch!
# Sep 5th 2019, 11:43 Nitrogen yea, tried it both ways to no avail, obviously. in case example might've been a typo.
# Sep 5th 2019, 11:43 ndm You could also skip the rendering and set the response body directly if your method is supposed to always return JSON
# Sep 5th 2019, 11:41 ndm @Nitrogen You're missing a `$this->render()` call (and the cookbook example too I guess), as returning a response will skip automatic view rendering, also when specifying the view class name as a "short name" string, it should be just `Json` without the `View` suffix.
# Sep 5th 2019, 11:34 admad @neon1024 at least having rains prevents Smith from notching up another century :P The guy is a freak.
# Sep 5th 2019, 11:31 admad for marshaling that is
# Sep 5th 2019, 11:31 admad though that would require having php's locale set to same locale and incoming value