| # |
Jan 9th 2020, 15:59 |
 ricksaccous |
IT'S ALIVE |
| # |
Jan 9th 2020, 15:59 |
ricksaccous |
YES |
| # |
Jan 9th 2020, 15:54 |
neothermic |
yes! |
| # |
Jan 9th 2020, 15:50 |
neothermic |
hmm! *tries* |
| # |
Jan 9th 2020, 15:50 |
neothermic |
ah, I see an example! |
| # |
Jan 9th 2020, 15:49 |
neothermic |
eg: |
| # |
Jan 9th 2020, 15:49 |
neothermic |
that lets me insert arbitry items? |
| # |
Jan 9th 2020, 15:48 |
admad |
Yes, override th string templates |
| # |
Jan 9th 2020, 15:47 |
neothermic |
in cake2's form helper, you had the before/between/after for throwing stuff inbetween generated labels and inputs. Cake3 doesn't seem to have these anymore, is there a way to still do this? |
| # |
Jan 9th 2020, 15:27 |
admad |
@val test cases are the best examples |
| # |
Jan 9th 2020, 15:15 |
ricksaccous |
i dunno then, oh wells |
| # |
Jan 9th 2020, 15:15 |
ricksaccous |
that didn't work |
| # |
Jan 9th 2020, 15:15 |
ricksaccous |
welp |
| # |
Jan 9th 2020, 15:14 |
ricksaccous |
echo $this->Form->create(['well' => 'okay']); echo $this->Form->control('well'); echo $this->Form->end(); |
| # |
Jan 9th 2020, 15:13 |
ricksaccous |
it would most likely match array key to array value |
| # |
Jan 9th 2020, 15:13 |
val |
to try what? `$this->Form->create([]);` ? |
| # |
Jan 9th 2020, 15:13 |
ricksaccous |
just try it, lell |
| # |
Jan 9th 2020, 15:13 |
val |
an example would be helpful |
| # |
Jan 9th 2020, 15:12 |
ricksaccous |
@val you could prob just set an array to the view if you want and use that |
| # |
Jan 9th 2020, 15:12 |
ricksaccous |
have you tried something and it failed? |
| # |
Jan 9th 2020, 15:06 |
val |
https://api.cakephp.org/3.8/class-Cake.View.Helper.FormHelper.html#_create ```The context for which the form is being defined. Can be a ContextInterface instance, ORM entity, ORM resultset, or an array of meta data.``` Is there an example when `$context` is an array of meta data? I cannot find it in the cookbook - https://book.cakephp.org/3/en/views/helpers/form.html#Cake\View\Helper\FormHelper::create |
| # |
Jan 9th 2020, 14:58 |
sdevore |
https://book.cakephp.org/3/en/orm/query-builder.html#sql-injection-prevention |
| # |
Jan 9th 2020, 14:47 |
ricksaccous |
you gotta bind those params |
| # |
Jan 9th 2020, 14:09 |
ndm |
Well, let's call it "(user) data", given that I don't know where `$id` comes from, but even if it's not user data currently (ie data sent by the user(agent) to your application), you never know when someone might make a change for the source of `$id`, so don't even start with inserting (user) data into queries directly. |
| # |
Jan 9th 2020, 14:06 |
alexdd55976 |
@ndm not sure what you mean with user data? |
| # |
Jan 9th 2020, 14:04 |
ndm |
@alexdd55976 It's still really bad form, never insert user data into queries if you can avoid it, always use bindings when possible, don't let stuff like that slip |
| # |
Jan 9th 2020, 14:03 |
alexdd55976 |
@sdevore thanks :) |
| # |
Jan 9th 2020, 14:02 |
sdevore |
Also https://book.cakephp.org/3/en/orm/query-builder.html#advanced-conditions there is a bit on notIn I have to run a kid to school but will be back in about an hour if you are still stuck ;) But I have faith that in my absence insight will be self discovered ;) |
| # |
Jan 9th 2020, 14:02 |
alexdd55976 |
@dereuromark good point thanks. i will forward him the message.. i am not in the office |
| # |
Jan 9th 2020, 14:01 |
dereuromark |
The $id is better (int) casted, otherwise you might open yourself to sql injections^^ |
| # |
Jan 9th 2020, 14:01 |
sdevore |
check out https://book.cakephp.org/3/en/orm/query-builder.html#subqueries |
| # |
Jan 9th 2020, 14:00 |
alexdd55976 |
the subselect is the big issue |
| # |
Jan 9th 2020, 13:59 |
alexdd55976 |
bu i am sure there is a more cakey way to do that |
| # |
Jan 9th 2020, 13:59 |
ndm |
ouch |
| # |
Jan 9th 2020, 13:59 |
alexdd55976 |
a colleague did that ```$this->Departments->find() ->where([ 'departments.active' => 1, 'departments.id NOT IN (SELECT DISTINCT department_id FROM users_departments where user_id <> ' . $id . ' )', ]);``` |
| # |
Jan 9th 2020, 13:58 |
slackebot |
`Departments__modified` FROM departments Departments WHERE ( departments.active = '1' AND departments.id NOT IN ( SELECT DISTINCT department_id FROM users_departments where user_id <> 1 ) )``` |
| # |
Jan 9th 2020, 13:58 |
alexdd55976 |
can somebody help me bringing the following statement to orm query? ```SELECT Departments.id AS `Departments__id`, Departments.name AS `Departments__name`, Departments.user_id AS `Departments__user_id`, Departments.is_root AS `Departments__is_root`, Departments.parent_id AS `Departments__parent_id`, Departments.active AS `Departments__active`, Departments.created AS `Departments__created`, Departments.modified AS |
| # |
Jan 9th 2020, 13:58 |
ndm |
I heard everybody loves Upwork ;) |
| # |
Jan 9th 2020, 13:49 |
spriz |
Do you guys know anywhere awesome to post a Cake job? :) |
| # |
Jan 9th 2020, 12:03 |
tibor.hajos |
Great, thank you. I'll see how long it takes for me to get stuck :P |
| # |
Jan 9th 2020, 12:01 |
dereuromark |
Jep, and you can use cake4 branch of sandbox to real life test it. Helped me a lot. |