| # |
Jun 28th 2021, 20:56 |
slackebot |
'%'.$search.'%']] ]) ->contain(['Addresses']) ->select(['id', 'first_name','last_name']);``` |
| # |
Jun 28th 2021, 20:56 |
 japerlman |
Is there a way to have a query do an OR across a relation? I want to have one search box that searches first_name, last_name, and address and when I try to include address I get SQL errors I'm not sure how to include ro OR on the contain I can't find an example of an OR on a contain ``` $query = $this->People->find(); $query ->where([ 'OR' => [['first_name ILIKE' => '%'.$search.'%'], ['last_name ILIKE' => |
| # |
Jun 28th 2021, 17:29 |
admad |
Ping to discord |
| # |
Jun 28th 2021, 15:35 |
umer936 |
Sweet. I'll let y'all know what I end up going with |
| # |
Jun 28th 2021, 15:35 |
umer936 |
@info315 oh I'll check that out too |
| # |
Jun 28th 2021, 15:35 |
kevin.pfeifer |
then I would guess the asset-mix plugin is what you need because (as far as I know) the laravel-mix plugin is the easiest way to get started with webpack and therefore have features like tree shaking |
| # |
Jun 28th 2021, 15:34 |
umer936 |
Hmm. AssetMix might be a little what I'm looking for... Haha all this Js dependancy stuff got so complicated so fast ,:). But one of the things I would like to use is Tree Shaking so the way I was doing wasn't enough |
| # |
Jun 28th 2021, 15:33 |
slackebot |
<https://github.com/it-novum/openITCOCKPIT/blob/5955b1152f1eec021f7e72298e9a9a86692752e0/src/Command/CompressCommand.php#L200%7Ccake shell which copy only the required files>. Still a hack but works not to bad. |
| # |
Jun 28th 2021, 15:33 |
info315 |
@umer936 I had a similar issue and had to build something for on my own. I had to move the node_modules folder out of the webroot because it is full of bash scripts and example files. I added a <https://github.com/it-novum/openITCOCKPIT/blob/development/src/itnovum/openITCOCKPIT/Core/AngularJS/AngularAssets.php#L36%7Clist> of all loaded npm files to my code and created a |
| # |
Jun 28th 2021, 15:28 |
kevin.pfeifer |
or you use the asset-mix plugin https://github.com/ishanvyas22/asset-mix which is based on laravel-mix |
| # |
Jun 28th 2021, 15:26 |
kevin.pfeifer |
well you can still use npm normally like in any other project I still love gulp and use it to generate CSS and JS from my source files and downloaded modules but as far as I know there is no out of the box npm/JS bundler in cakephp present. Maybe you can find a plugin Maybe you can copy some things from this vuejs single page application template https://github.com/ishanvyas22/cakephpvue-spa |
| # |
Jun 28th 2021, 15:23 |
umer936 |
Hi, what's the way to have npm (or yarn) as a package manager for front-end stuff (JS)? Laravel has mix-ins to handle this. After trying quite a few things, I've come to using the "foxy" composer plugin (to allow composer to run npm commands) and putting my node_modules folder in /webroot/js so I can access them in my templates. This still feels a little like a hack. |
| # |
Jun 28th 2021, 15:20 |
info315 |
Oh i see you are still using freenode - the Freenode stuff delete my user account and hijack our community channel (together with more than 700 other channels) |
| # |
Jun 28th 2021, 15:18 |
dereuromark |
@info315 https://api.slack.com/reference/surfaces/formatting#linking-urls |
| # |
Jun 28th 2021, 15:18 |
admad |
But the bridge seems down :( |
| # |
Jun 28th 2021, 15:17 |
kevin.pfeifer |
https://discord.gg/k4trEMPebj |
| # |
Jun 28th 2021, 15:16 |
info315 |
@admad Really? Can you send me an invite link please? @dereuromark Good to know |
| # |
Jun 28th 2021, 15:14 |
admad |
We are on Discord too :) |
| # |
Jun 28th 2021, 15:14 |
dereuromark |
@info315 Slack uses a different markup ;) <link|url> etc |
| # |
Jun 28th 2021, 15:13 |
info315 |
Fun fact, Slack isn't as Markdown friendly as I expected^^ |
| # |
Jun 28th 2021, 15:13 |
ankitgsolanki |
@admad Ok |
| # |
Jun 28th 2021, 15:12 |
admad |
@ankitgsolanki ignore my comments about scopes :) |
| # |
Jun 28th 2021, 15:11 |
admad |
Sorry I had a dumb moment, it's a config for logger not cache. |
| # |
Jun 28th 2021, 14:54 |
info315 |
@admad What is the `scopes` option? Its unknown to the [docs](https://book.cakephp.org/4/en/core-libraries/caching.html) and the [code](https://github.com/cakephp/cakephp/blob/master/src/Cache/Engine/RedisEngine.php) |
| # |
Jun 28th 2021, 14:51 |
ankitgsolanki |
@admad Ok |
| # |
Jun 28th 2021, 14:50 |
admad |
@ankitgsolanki err... needs to be `false` not `null` |
| # |
Jun 28th 2021, 14:49 |
ankitgsolanki |
@admad No. Let me try with add this config |
| # |
Jun 28th 2021, 14:48 |
admad |
@ankitgsolanki Have you set `'scopes' => null` for the redis config? |
| # |
Jun 28th 2021, 14:44 |
info315 |
Me too. Check the Redis Metrics and your Code - something is firing hundreds of requests or stores large files to redis i guess |
| # |
Jun 28th 2021, 14:40 |
admad |
If it's not the default cache and it's not used for the current request then Cake wouldn't even connect to it, so don't see how it could cause any slowdown. |
| # |
Jun 28th 2021, 14:38 |
ankitgsolanki |
I have defined new cache for redis server in app.php and default cache is file cache |
| # |
Jun 28th 2021, 14:36 |
info315 |
Have you set your default cache to redis? Or did you defined a new cache in app.php just for the particular data that has to be stored to redis? |
| # |
Jun 28th 2021, 14:32 |
ankitgsolanki |
@info315 At this post request I am not sending any request to Redis server. |
| # |
Jun 28th 2021, 14:31 |
info315 |
@ankitgsolanki How many requests do you send to the redis server per POST request? |
| # |
Jun 28th 2021, 14:30 |
tomrwaller |
Thanks again @ndm - your tip pointed me in the right direction and I ended up looking at the BootstrapUI plugin by FriendsOfCake which has shown me how to avoid using dumb templates! |
| # |
Jun 28th 2021, 14:27 |
ankitgsolanki |
Also try with another redis remote server from https://app.redislabs.com/ but same issue facing this remote server as well |
| # |
Jun 28th 2021, 14:26 |
ankitgsolanki |
In a local redis server it takes 10 seconds |
| # |
Jun 28th 2021, 14:24 |
info315 |
try with an local redis server running on 127.0.0.1 to test if it's an Redis or an AWS issue |
| # |
Jun 28th 2021, 14:23 |
info315 |
Than you are facing most likely a network latency issue |
| # |
Jun 28th 2021, 14:22 |
ankitgsolanki |
@info315 Yes. It is in AWS Elastic Cache |
| # |
Jun 28th 2021, 14:21 |
info315 |
@ankitgsolanki Is your Redis server running on a remote host? |