# |
Oct 3rd 2016, 08:11 |
Neon1024 |
Morning all |
# |
Oct 3rd 2016, 07:28 |
keith |
morning |
# |
Oct 3rd 2016, 07:27 |
birdy247 |
Morning all |
# |
Oct 3rd 2016, 04:51 |
cpierce |
back to the view |
# |
Oct 3rd 2016, 04:51 |
cpierce |
how do you set data back into an AppForm inside `execute` |
# |
Oct 3rd 2016, 01:03 |
aro |
hey - is there a way to validate that at least one of three fields is 'checked'? |
# |
Oct 3rd 2016, 00:51 |
ra7bi |
``` LEFT JOIN `events` `Events` ON `Events`.`id` = (`Participants`.`event_id`) WHERE ( `Events`.`start_date` > 'Ù£â?/Ù¡Ù â?/٢٠١٦ ١٢:٤٤ ص' AND `Participants`.`id` = 1 ) ٫٫٫ Look at the Date and Time , it's in Arabic |
# |
Oct 3rd 2016, 00:50 |
ra7bi |
how i can get it in English |
# |
Oct 3rd 2016, 00:49 |
ra7bi |
The output of Time::now(), is written in ARABIC |
# |
Oct 3rd 2016, 00:49 |
ra7bi |
i have a problem with DateTime |
# |
Oct 3rd 2016, 00:49 |
ra7bi |
hi |
# |
Oct 2nd 2016, 23:11 |
moose517 |
yer darn straight :P |
# |
Oct 2nd 2016, 22:45 |
shealyw2 |
lazy |
# |
Oct 2nd 2016, 21:24 |
moose517 |
the only thing i've done today is hang some VFR flight maps up on my wall as decoration, and drink beer |
# |
Oct 2nd 2016, 21:24 |
moose517 |
LMAO |
# |
Oct 2nd 2016, 21:23 |
moose517 |
my goodness i'm sooo bored. but nothing at all sounds entertaining at all XD |
# |
Oct 2nd 2016, 20:13 |
moose517 |
*brrrrup* |
# |
Oct 2nd 2016, 17:32 |
hmic |
welcome! |
# |
Oct 2nd 2016, 17:07 |
michaelze |
hmic: Seems to work pretty well! Thanks again for the hint! |
# |
Oct 2nd 2016, 16:55 |
michaelze |
hmic: I'll give it a shot, thank you very much :) |
# |
Oct 2nd 2016, 16:55 |
hmic |
hope it helps. |
# |
Oct 2nd 2016, 16:54 |
hmic |
it's *meant* for things like that ;-) |
# |
Oct 2nd 2016, 16:54 |
hmic |
so your beforeFind event can easily decide on which query to do what |
# |
Oct 2nd 2016, 16:54 |
michaelze |
hmic: That's actually a very good idea... didn't think about using the $options array for that purpose... |
# |
Oct 2nd 2016, 16:53 |
hmic |
you can access this $options array from the query all the time... |
# |
Oct 2nd 2016, 16:53 |
hmic |
just do: $this->Table->find('all', ['optOut' => true]); |
# |
Oct 2nd 2016, 16:52 |
hmic |
*and* the information is kept with the query it belongs to all the time, so nothing can go wrong |
# |
Oct 2nd 2016, 16:52 |
hmic |
you dont need to function in the behavior to trigger an opt out in this case |
# |
Oct 2nd 2016, 16:51 |
hmic |
so why dont you add the information to opt out to the query itself? |
# |
Oct 2nd 2016, 16:51 |
michaelze |
hmic: Apparently there are no events fired when a query is created... I already checked that ;) |
# |
Oct 2nd 2016, 16:50 |
michaelze |
hmic: sorry for the long text, I hope I made my point clear ;) |
# |
Oct 2nd 2016, 16:50 |
michaelze |
...sure that that is the query I want to modify... |
# |
Oct 2nd 2016, 16:50 |
michaelze |
...I'm logged in as the superadmin or something). When I call the opt out method I store a boolean value in my behavior that gets queried in the beforeFind() method. The problem is, that the "next" beforeFind() call may not be the call that corresponds to the query I want the opt out to happen... So I was wondering whether it is possible to hook into the query creation because there I can be... |
# |
Oct 2nd 2016, 16:50 |
michaelze |
hmic: My use case is as follows: I have a special column in some of my tables that make a record belong to a certain tenant within my application (tenant_id). I created a behavior that, when attached, automatically adds the required filter to any query. I added another method to the behavior that allows me to opt out of this behavior in case I want to also get records for other tenants (e.g.... |
# |
Oct 2nd 2016, 16:47 |
hmic |
still, whats the usecase? |
# |
Oct 2nd 2016, 16:47 |
hmic |
so i'd inspect that code to see if events are fired, which would give you the opportunity to intervene quite easily |
# |
Oct 2nd 2016, 16:46 |
michaelze |
hmic: The query is created in the Table::query() method. Is that what you asked? |
# |
Oct 2nd 2016, 16:45 |
hmic |
and whats the usecase also? |
# |
Oct 2nd 2016, 16:45 |
hmic |
michaelze, do you know how and when a query is created? |
# |
Oct 2nd 2016, 16:45 |
michaelze |
Hi everyone! Is there a way to modify a query by a behavior the moment it is created instead of the moment that it is executed (beforeFind())? |
# |
Oct 2nd 2016, 16:34 |
michaelze |
lorb: one problem could be that your app is crashing so you won't be able to dump the result... But you could try with as much rows before it is failing. That should give you a pretty good sight into what's happending |