| # |
Jun 9th 2021, 21:26 |
 kevin.pfeifer |
Is it possible to “globally overwrite” all recipients of mails sent via a Mailer? I would like to add a config for a sort of “Email debug mode” where all mails are being sent to a defined mail. Or do I have to add that logic to all my “reusable mailer functions”? |
| # |
Jun 9th 2021, 13:56 |
paolo.bragagni |
found sorry |
| # |
Jun 9th 2021, 13:50 |
paolo.bragagni |
I get '*Cannot convert value of type `string` to integer'* |
| # |
Jun 9th 2021, 13:49 |
paolo.bragagni |
cake4/libri/?lingua_id=2 |
| # |
Jun 9th 2021, 13:49 |
paolo.bragagni |
in fiendofsearch plugin I got an error searching in related |
| # |
Jun 9th 2021, 11:04 |
y.teruyacookie |
Thank you very much!! I have solved this problem! |
| # |
Jun 9th 2021, 10:56 |
ndm |
`['column_name' => "''"]` |
| # |
Jun 9th 2021, 10:49 |
y.teruyacookie |
Thanks, but I don't get the passed code. The followings are an error log. ```Hogemodel.'' as column_name AS `Hogemodels__'' as column_name` FROM higemodels Hogemodels``` |
| # |
Jun 9th 2021, 10:32 |
steinkel |
try `->select(["'' as column_name"])` |
| # |
Jun 9th 2021, 10:23 |
slackebot |
->find('FinderMethod') ->select([. 'column_name' => '', ]);``` Is there any way to output a blank column? |
| # |
Jun 9th 2021, 10:23 |
y.teruyacookie |
Hi, I would like to ask my question. I would like to intentionally output blank columns in the CakePHP3 query builder. In the case of MySQL, you can write the following ```SELECT '' AS 'column_name' FROM hogeModel;``` It will return a column with column_name and a blank value. I would like to do the same thing with CakePHP3's query builder. If I write the following, I get a DataBase error. ```return $query |
| # |
Jun 9th 2021, 10:01 |
ndm |
https://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/ |
| # |
Jun 9th 2021, 09:57 |
eax |
Oh thanks @ndm I’ll look into that! :relaxed: |
| # |
Jun 9th 2021, 09:56 |
ndm |
If you just have an adjacency list with `parent_id`, then you'd need something recursive, which could for example be achieved using common table expressions. |
| # |
Jun 9th 2021, 09:50 |
eax |
@ndm: Ok, then I don’t think it’s an option here, but thanks :$ |
| # |
Jun 9th 2021, 09:48 |
ndm |
Yes, that's the fields for a nested set. |
| # |
Jun 9th 2021, 09:48 |
eax |
Thanks @ndm! But doesn’t that require me to have the lft and rght fields in my table? |
| # |
Jun 9th 2021, 09:46 |
ndm |
@eax If you have a nested set, then you can use the `path` finder: `find('path', ['for' => $childId])` https://book.cakephp.org/3/en/orm/behaviors/tree.html |
| # |
Jun 9th 2021, 09:30 |
eax |
Hey folks! Cake3 question: Is it possible to do a “reverse” threaded find? I have the “bottom” child, and would like to get the parents all the way “up” in the same Query :$ |
| # |
Jun 9th 2021, 07:46 |
philo.hamel |
that's what we use to continue to use the property access |
| # |
Jun 9th 2021, 07:45 |
dereuromark |
Saves also inline type annotations |
| # |
Jun 9th 2021, 07:45 |
birdy247 |
So maybe we do that ->property for any code that has got defined properties |
| # |
Jun 9th 2021, 07:44 |
dereuromark |
If u know the fields exist, use prop access imo. |
| # |
Jun 9th 2021, 07:44 |
birdy247 |
Yes, good point |
| # |
Jun 9th 2021, 07:43 |
dereuromark |
Get method is better for generic Code, like behaviors often. Phpstan likes it more then |
| # |
Jun 9th 2021, 07:43 |
birdy247 |
I prefer the look of ->property in the code |
| # |
Jun 9th 2021, 07:30 |
philo.hamel |
this, and I also use `$entity->property` because it's less error prone and easier with refactoring, but it's an interesting question so I'm also interested to hear from `$entity->get('property')` users |
| # |
Jun 9th 2021, 07:27 |
jpramirez |
If you define the properties' types in the entity's annotations, your IDE and static analyzers will prefer `$entity->property`. |
| # |
Jun 9th 2021, 07:16 |
birdy247 |
Do people recmoned direct access $entity->property or $entity->get('property') |
| # |
Jun 9th 2021, 07:15 |
birdy247 |
When accessing a property in cake 3 |
| # |
Jun 8th 2021, 15:08 |
neon1024 |
Ah, simple `applyOptions` |
| # |
Jun 8th 2021, 15:07 |
neon1024 |
So now I wonder how to pass `beforeFind` options to contained associations |
| # |
Jun 8th 2021, 15:06 |
neon1024 |
Found my issue, it was a beforeFilter in a table class that I am containing! |
| # |
Jun 8th 2021, 14:36 |
neon1024 |
I loop the data, so I’ve been filthy and solved it in the php :grimacing: |
| # |
Jun 8th 2021, 14:36 |
neon1024 |
Hah, fair enough |
| # |
Jun 8th 2021, 14:35 |
ndm |
@neon1024 That reads as if every sentence is missing like 4 or 5 words :P But it kinda sounds like you want to use `leftJoinWith()`, as `matching()` uses an `INNER` join, so you cannot use it for optional filtering. |
| # |
Jun 8th 2021, 13:39 |
paolo.bragagni |
,:) |
| # |
Jun 8th 2021, 13:39 |
paolo.bragagni |
till now I port (to 4) csv :P |
| # |
Jun 8th 2021, 13:38 |
paolo.bragagni |
and use tinybutstrong to build their own odt template |
| # |
Jun 8th 2021, 13:37 |
paolo.bragagni |
me too. cls - xlsx - and pdf |
| # |
Jun 8th 2021, 13:37 |
kevin.pfeifer |
I let users download a XLSX |