Log message #4263778

# At Username Text
# May 21st 2021, 09:47 ndm There probably is no overly straightforward way, as it applies for all queries of table, and joins and formatters for translations are being added in the `Model.beforeFind` event.
# May 21st 2021, 09:44 thomas465 oh, neat, what about a clean way of disabling translations where they are not needed ?
# May 21st 2021, 09:43 ndm @thomas465 You can use the query builder's `counter()` method to define a custom count query. https://book.cakephp.org/4/en/orm/query-builder.html#returning-the-total-count-of-records
# May 21st 2021, 09:40 paolo.bragagni it works!! great!
# May 21st 2021, 09:40 ndm I don't think so, IIRC that's only required on application level.
# May 21st 2021, 09:38 paolo.bragagni no 'authorization' path somewhere in my plugin template?
# May 21st 2021, 09:38 thomas465 sorry, fails with ` Syntax error or access violation: 1234 Incorrect usage/placement of ‘SQL_NO_CACHE’`
# May 21st 2021, 09:38 slackebot (SELECT sql_no_cache `Products`.`id` AS `Produ```
# May 21st 2021, 09:38 thomas465 Regarding pagination, i have a rather large query that i need paginated, the problem is that the count method in the Paginator uses the complete query, including translation tables. It always fails when giving the query a modifier like ```$query = $query->where(['Products.is_active' => true])->select([ 'id', 'name', 'children_count'], false)->modifier('sql_no_cache');``` fails with ```SELECT (COUNT(*)) AS `count` FROM
# May 21st 2021, 09:34 ndm See also https://book.cakephp.org/bake/2/en/development.html#creating-a-bake-theme
# May 21st 2021, 09:33 ndm Given the paths in the authorization plugin, the path inside your theme plugin should be `templates/bake/policy.twig` and `templates/bake/element/entity_methods.twig`.
# May 21st 2021, 09:31 paolo.bragagni (and I'd like to insert the modified twig policy template in a plugin)
# May 21st 2021, 09:30 paolo.bragagni I'd like to insert something in before method and add all my standard actions
# May 21st 2021, 09:29 paolo.bragagni I have to modify the template
# May 21st 2021, 09:21 ndm @paolo.bragagni Do you plan to modify the templates? If not, then you don't need to touch them.
# May 21st 2021, 08:43 paolo.bragagni and I'd like to put the policy.twig and entity_methods.twig inside a plugin
# May 21st 2021, 08:43 paolo.bragagni found this https://github.com/cakephp/authorization/issues/138 but doesnt work in cakephp 4
# May 21st 2021, 07:14 paolo.bragagni Hi there is a way to bake a authorization policy taking the template from a plugin?
# May 20th 2021, 23:56 khalil And I can't find one that works with 4.2
# May 20th 2021, 23:55 khalil There are a couple that work with 3.x
# May 20th 2021, 23:55 khalil Guys is there any datatables plugin that works with cake 4.2 ?
# May 20th 2021, 23:10 ndm no problem
# May 20th 2021, 23:02 khalil Sorry for wasting your time!
# May 20th 2021, 23:02 khalil Naming convention of has and belongs to many always confuses me with which should plural and which not
# May 20th 2021, 23:01 khalil And I was working on the wrong file
# May 20th 2021, 23:01 khalil I guess one was auto generated
# May 20th 2021, 23:01 khalil for some reason, I have ProductSize and ProductsSize Entities
# May 20th 2021, 23:01 khalil '_joinData' => object(App\Model\Entity\ProductsSize)
# May 20th 2021, 23:00 khalil Here's what was wrong
# May 20th 2021, 23:00 khalil Ok it worked now
# May 20th 2021, 22:59 khalil Let me try this
# May 20th 2021, 22:59 khalil One sec guys, I noticed something
# May 20th 2021, 22:59 khalil No I'm saying that because `protected _virtual => [ ]`
# May 20th 2021, 22:58 greg138 Because there's a *lot* of those, and not all should be empty...
# May 20th 2021, 22:58 greg138 Is it really an empty array, or just saying that because it says `'[virtual]' => [ ]`?
# May 20th 2021, 22:56 khalil protected _virtual is an empty array
# May 20th 2021, 22:55 slackebot ]` `protected _registryAlias => 'ProductsSizes'` `}`
# May 20th 2021, 22:55 slackebot => [ ]` `'[hasErrors]' => *false*` `'[errors]' => [ ]` `'[invalid]' => [ ]` `'[repository]' => 'ProductsSizes'` `protected _accessible => [ ]` `protected _fields => [ ]` `protected _original => [ ]` `protected _hidden => [ ]` `protected _virtual => [ ]` `protected _dirty => [ ]` `protected _accessors => [ ]` `protected _new => *false*` `protected _errors => [ ]` `protected _invalid => [
# May 20th 2021, 22:55 khalil `'_joinData' => object(App\Model\Entity\ProductsSize) id:*1* {'id' => (int) *23*` `'size_id' => '10'` `'product_id' => (int) *53*` `'width' => '10.000'` `'height' => '20.000'` `'length' => '30.000'` `'weight' => '40.000'` `'price' => '50.00'` `'stock' => (int) *12*` `'is_default' => *false*` `'[new]' => *false*` `'[accessible]' => [ ]` `'[dirty]' => [ ]` `'[original]' => [ ]` `'[virtual]'
# May 20th 2021, 22:53 khalil Wait i'll show you the results of that
# May 20th 2021, 22:53 ndm I mean inside of the `_getLocalPrice` method