| # |
Feb 20th 2020, 21:35 |
 jan-willem |
But will look to it. thnx |
| # |
Feb 20th 2020, 21:35 |
jan-willem |
I suppose this one was for me? :P I'm already on CakePHP 4 |
| # |
Feb 20th 2020, 21:28 |
wizardfix |
Reading now @challgren thanks :) |
| # |
Feb 20th 2020, 21:27 |
challgren |
@wizardfix see https://www.dereuromark.de/2020/02/06/virtual-query-fields-in-cakephp/ |
| # |
Feb 20th 2020, 21:27 |
dereuromark |
@hawk dot syntax is not supported by has afaik. I use here normally https://github.com/dereuromark/cakephp-shim/blob/master/src/Model/Entity/ReadTrait.php - which then supports paths. |
| # |
Feb 20th 2020, 21:26 |
wizardfix |
From the book (3.8): > Control which Fields Used for Ordering¶ > By default sorting can be done on any non-virtual column a table has. Does this mean the Paginator can no way sort on virtual fields? :thinking_face: |
| # |
Feb 20th 2020, 21:18 |
jan-willem |
can I use the has() function as well for nested associations? I know I can use it to check if `games->events` exists. But can I use it as well to check if `games->events->competitions` exists? |
| # |
Feb 20th 2020, 18:37 |
phantomwatson |
Ha! Yeah, that's my experience too. Sometimes just by analyzing your problem enough to write a well-formed question or bug report, the cause reveals itself. |
| # |
Feb 20th 2020, 18:34 |
jh |
the next attempt works |
| # |
Feb 20th 2020, 18:34 |
jh |
always when u ask after tinkering for a few hours |
| # |
Feb 20th 2020, 18:34 |
jh |
i just tinkered around it it works |
| # |
Feb 20th 2020, 18:22 |
phantomwatson |
I'd like to help, but I'm having a hard time understanding your question. |
| # |
Feb 20th 2020, 18:11 |
jh |
damn i hate this guessing/magic :E |
| # |
Feb 20th 2020, 18:02 |
jh |
in patchEntity i use 'TariffsDocuments' => ['onlyIds' => true], |
| # |
Feb 20th 2020, 18:01 |
jh |
tariffs_documents._ids.0 tariffs_documents._ids.1 etc contents each is just the foreign key to the tariff document |
| # |
Feb 20th 2020, 18:01 |
jh |
What could probably stop _ids BTM to save the association? |
| # |
Feb 20th 2020, 17:57 |
kaliel |
:) |
| # |
Feb 20th 2020, 17:57 |
wizardfix |
@kaliel yes what was I thinking! Of course I have this data from the request! Just had a blind spot lol! It all works now! :) |
| # |
Feb 20th 2020, 17:45 |
slackebot |
https://github.com/cakephp/cakephp/commit/0cf9921798d823fa87b61bb93f908c57a132a53f#diff-525e59c1441ed03389d3cf0ac1198130R186 |
| # |
Feb 20th 2020, 17:45 |
phantomwatson |
The core uses a colon, the letter C, and a number for placeholders. The colon, I assume is so it's easier to parse the SQL and find those placeholders. The numbers are to differentiate each placeholders from the others. But I don't know why the letter C is used. The commit history for the relevant code suggests that it might be short for "comparison". |
| # |
Feb 20th 2020, 17:35 |
wizardfix |
@phantomwatson ok, great, `$query->getValueBinder()->bindings()[':c1']['value']` gets me the value in a `debug()` call so now I'll try getting it in the form. But I wonder where this `':c1'` property comes from... :thinking_face: |
| # |
Feb 20th 2020, 17:32 |
kaliel |
Don't you get these values in requested data ? |
| # |
Feb 20th 2020, 17:29 |
wizardfix |
Calling `toArray()` just gives me the users without the params. The situation is: 1. User selects "Inactive", "Active" or "All". These map to values 0, 1, 2 respectively. So this value is in the query object and I want to use it to prepopulate the HTML select element in the form when I return the response. ` |
| # |
Feb 20th 2020, 17:27 |
phantomwatson |
It looks like all of those methods are public, so it should work. |
| # |
Feb 20th 2020, 17:26 |
phantomwatson |
So I'd try `$query->getValueBinder()->bindings()` and see if that works. |
| # |
Feb 20th 2020, 17:26 |
phantomwatson |
It looks like `$params` isn't part of the query object per se, but generated by its `__debugInfo()` method. That method uses `$this->getValueBinder()->bindings()` to populate `'params'`. |
| # |
Feb 20th 2020, 17:25 |
phantomwatson |
Is there any way to sidestep the problem by just capturing that data at the point that the query object is being built? |
| # |
Feb 20th 2020, 17:24 |
phantomwatson |
I think that John's asking about getting the parameters that were passed into the query object via the `->where()` method, not getting data from the database. |
| # |
Feb 20th 2020, 17:22 |
kaliel |
`$query->toArray()` |
| # |
Feb 20th 2020, 17:20 |
slackebot |
variety of ways and am not finding any good examples of getting data from a query object. I need to access this value to prepopulate a form selector. :thinking_face: |
| # |
Feb 20th 2020, 17:20 |
slackebot |
'params' => [ ':c0' => [ 'value' => (int) 2, 'type' => 'tinyinteger', 'placeholder' => 'c0' ], ':c1' => [ 'value' => (int) 1, 'type' => 'tinyinteger', 'placeholder' => 'c1' ] ], 'defaultTypes' => [ 'Users__id' => 'integer', 'Users.id' => 'integer', 'id' => 'integer', 'Users__name' => 'string', 'Users.name' => 'string',``` How to I get the `'value' => (int) 1` from the `':c1'` element of `params`? I've tried a |
| # |
Feb 20th 2020, 17:20 |
slackebot |
`Creators__id`, Creators.name AS `Creators__name`, Creators.email AS `Creators__email`, Creators.admin AS `Creators__admin`, Creators.password AS `Creators__password`, Creators.status AS `Creators__status`, Creators.created_by AS `Creators__created_by`, Creators.created_on AS `Creators__created_on` FROM users Users LEFT JOIN users Creators ON Creators.id = (Users.created_by) WHERE (Users.status < :c0 AND Users.status = :c1) LIMIT 30 OFFSET 0', |
| # |
Feb 20th 2020, 17:20 |
wizardfix |
I have a `Query` object that starts like this: ```'(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Users.id AS `Users__id`, Users.name AS `Users__name`, Users.email AS `Users__email`, Users.admin AS `Users__admin`, Users.password AS `Users__password`, Users.status AS `Users__status`, Users.created_by AS `Users__created_by`, Users.created_on AS `Users__created_on`, Creators.id AS |
| # |
Feb 20th 2020, 17:10 |
dereuromark |
afaik they still dont use any static analyzer, e.g. phpstan, as such the functional part is also quite bad. |
| # |
Feb 20th 2020, 17:10 |
dereuromark |
I know^^ worst code in general |
| # |
Feb 20th 2020, 17:09 |
kaliel |
you wan to see a real mess in doc ? try symfony and its annotations :) |
| # |
Feb 20th 2020, 17:08 |
dereuromark |
doc vs functional part |
| # |
Feb 20th 2020, 17:07 |
dereuromark |
no, it makes them independant from the source code (and included use). |
| # |
Feb 20th 2020, 17:06 |
phantomwatson |
It looks like this was added last November to the CakePHP codesniffer ruleset, and I'm _just_ now pulling those changes for some projects and noticing failing tests. Is the rationale that it makes doc comments more human-readable? |
| # |
Feb 20th 2020, 16:56 |
phantomwatson |
This convention is new to me. I've always seen recommendations to put the fully-qualified names in `use` statements at the top to simplify the rest of your code. PhpStorm kind of nags me with notifications to do that, too. Is there some pitfall to that approach that I've been overlooking? |
| # |
Feb 20th 2020, 16:53 |
dereuromark |
sure, always use fqcn here |