| # |
Mar 6th 2018, 16:11 |
 neon1024 |
You can do some really clever stuff with them |
| # |
Mar 6th 2018, 16:11 |
neon1024 |
@flavius Yeah, they’re super handy and really powerful |
| # |
Mar 6th 2018, 16:11 |
flavius |
@neon1024 huh, so Today I Learned about mutators -> https://book.cakephp.org/3.0/en/orm/entities.html#Cake\ORM\Entity::get cool :slightly_smiling_face: |
| # |
Mar 6th 2018, 16:10 |
phantomwatson |
TL;DR: The form helper adds IDs to URLs if there isn't a route name, and that seems weird to me. |
| # |
Mar 6th 2018, 16:09 |
slackebot |
`$this->Form->create()`. Yes, I know that specifying the URL is redundant if the form is submitting to its own URL. Using CakePHP 3.5.8, but it appears to also be the case in the latest version too. |
| # |
Mar 6th 2018, 16:09 |
phantomwatson |
`FormHelper::_formUrl()` appears to only return the unmodified value of `$options['url']` if `$options['url']['_name']` is also specified, and it automatically appends the current record's ID to the URL otherwise. Is this intentional? In an application I'm reviewing, this has the effect of the form on `/users/my-account` submitting to `/users/my-account/$userId`, despite explicitly setting the URL _without_ an ID in |
| # |
Mar 6th 2018, 16:09 |
dereuromark |
neon1024 give it a spin, sounds like a legit improvement. Just have to dicuss the pros and cons of the solutions available |
| # |
Mar 6th 2018, 16:09 |
neon1024 |
Oh yeah, good point! |
| # |
Mar 6th 2018, 16:08 |
popperz0r |
using ->having |
| # |
Mar 6th 2018, 16:08 |
popperz0r |
ok i got it |
| # |
Mar 6th 2018, 16:07 |
neon1024 |
I’d like to propose your idea, I think it’s a good one |
| # |
Mar 6th 2018, 16:06 |
neon1024 |
At least an RFC I guess right? |
| # |
Mar 6th 2018, 16:06 |
neon1024 |
@dereuromark Do you think it’s worth a ticket? The issue of entity access in templates? |
| # |
Mar 6th 2018, 16:06 |
neon1024 |
Well, without a syntax error :P |
| # |
Mar 6th 2018, 16:05 |
neon1024 |
For example |
| # |
Mar 6th 2018, 16:05 |
neon1024 |
`$this->set('catalog', $this->Catalogs->find()->first()` |
| # |
Mar 6th 2018, 16:05 |
neon1024 |
It’s an instance of a class which extends `\Cake\ORM\Entity` |
| # |
Mar 6th 2018, 16:04 |
neon1024 |
There are not two types. |
| # |
Mar 6th 2018, 16:04 |
flavius |
but not an ORM entity, so which one? |
| # |
Mar 6th 2018, 16:04 |
neon1024 |
@flavius It’s an entity |
| # |
Mar 6th 2018, 16:03 |
flavius |
@neon1024 what type of object is `$catalog` in your template? |
| # |
Mar 6th 2018, 16:03 |
neon1024 |
Ah! |
| # |
Mar 6th 2018, 16:03 |
popperz0r |
```(CONCAT(User.first_name, :param0, User.last_name)) AS `full_name```` |
| # |
Mar 6th 2018, 16:03 |
neon1024 |
You’d get first and last, and use an entity mutator method instead as detailed in the book |
| # |
Mar 6th 2018, 16:03 |
neon1024 |
It doesn’t exist |
| # |
Mar 6th 2018, 16:03 |
neon1024 |
You can’t use full_name in your query |
| # |
Mar 6th 2018, 16:02 |
popperz0r |
i really gonna make a foreach and filter with php |
| # |
Mar 6th 2018, 16:02 |
neon1024 |
Perhaps I could do all this checking when setting stuff to the template in my controller, and set individual variables |
| # |
Mar 6th 2018, 16:02 |
popperz0r |
still |
| # |
Mar 6th 2018, 16:02 |
slackebot |
(UnqualifiedLead.phone_id) LEFT JOIN email Email ON Email.id = (UnqualifiedLead.email_id) LEFT JOIN city City ON City.id = (UnqualifiedLead.city_id) LEFT JOIN company Company ON Company.id = (UnqualifiedLead.company_id) LEFT JOIN lead_type LeadType ON LeadType.id = (UnqualifiedLead.lead_type_id) WHERE (`full_name` like :c1 AND Email.email like :c2) ORDER BY UnqualifiedLead.id desc``` |
| # |
Mar 6th 2018, 16:02 |
popperz0r |
````UnqualifiedLead__user_id`, User.first_name AS `User__first_name`, User.last_name AS `User__last_name`, LeadType.label AS `LeadType__label`, Email.email AS `Email__email`, Phone.number AS `Phone__number`, City.city_name AS `City__city_name`, (CONCAT(User.first_name, :param0, User.last_name)) AS `full_name` FROM unqualified_lead UnqualifiedLead LEFT JOIN user User ON User.id = (UnqualifiedLead.user_id) LEFT JOIN phone Phone ON Phone.id = |
| # |
Mar 6th 2018, 16:02 |
popperz0r |
```Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'where clause'``` |
| # |
Mar 6th 2018, 16:02 |
popperz0r |
so this is happening |
| # |
Mar 6th 2018, 16:01 |
dereuromark |
well, that is a third issue |
| # |
Mar 6th 2018, 16:01 |
neon1024 |
But sure, `s/get/has` |
| # |
Mar 6th 2018, 16:01 |
neon1024 |
Has doesn’t check emptyness |
| # |
Mar 6th 2018, 16:01 |
neon1024 |
Which if you’re a designer in a template, seems very confusing |
| # |
Mar 6th 2018, 16:01 |
dereuromark |
why not ->has() then?^^ |
| # |
Mar 6th 2018, 16:01 |
neon1024 |
I end up with `if (!empty($catalog->get('content') andand !empty($catalog->get('content')->get('adverts')) { // Output advert };` |
| # |
Mar 6th 2018, 16:00 |
dereuromark |
with nesting it must always use latter one of course! |
| # |
Mar 6th 2018, 16:00 |
dereuromark |
well, there are two use cases: get() and I dont care about existence - and get() but make sure it exists |