# |
Nov 14th 2019, 12:50 |
frank |
@rk.thedigifrog What @admad said |
# |
Nov 14th 2019, 12:31 |
pieceof |
id remove parenthesis from where |
# |
Nov 14th 2019, 12:29 |
admad |
you might have whitespace in the saved value |
# |
Nov 14th 2019, 12:28 |
pieceof |
try like ? |
# |
Nov 14th 2019, 12:12 |
rk.thedigifrog |
@frank ^ |
# |
Nov 14th 2019, 12:09 |
rk.thedigifrog |
Not working means query is not working even if I hit same query in MYSQL console |
# |
Nov 14th 2019, 12:08 |
rk.thedigifrog |
Expected result: |
# |
Nov 14th 2019, 12:07 |
frank |
@rk.thedigifrog Not working..? What’s happening and what were you expecting to happen? |
# |
Nov 14th 2019, 12:05 |
javier.villanueva |
thanks @dereuromark |
# |
Nov 14th 2019, 12:02 |
slackebot1 |
`Campaigns__created`, Campaigns.modified AS `Campaigns__modified` FROM messages Messages LEFT JOIN campaigns Campaigns ON Campaigns.id = (Messages.campaign_id) WHERE (Messages.sent_from = '+15104221247' AND Messages.sent_to = '+14242576491') ORDER BY Messages.created DESC LIMIT 1 |
# |
Nov 14th 2019, 12:02 |
slackebot1 |
`Campaigns__start_date`, Campaigns.template AS `Campaigns__template`, Campaigns.company_id AS `Campaigns__company_id`, Campaigns.status AS `Campaigns__status`, Campaigns.message_time AS `Campaigns__message_time`, Campaigns.day_of_week AS `Campaigns__day_of_week`, Campaigns.messages_limit AS `Campaigns__messages_limit`, Campaigns.offer_code AS `Campaigns__offer_code`, Campaigns.is_deleted AS `Campaigns__is_deleted`, Campaigns.created AS |
# |
Nov 14th 2019, 12:02 |
slackebot1 |
`Messages__messageSid`, Messages.message_sent AS `Messages__message_sent`, Messages.sent_from AS `Messages__sent_from`, Messages.sent_to AS `Messages__sent_to`, Messages.delivery_status AS `Messages__delivery_status`, Messages.created AS `Messages__created`, Messages.modified AS `Messages__modified`, Campaigns.id AS `Campaigns__id`, Campaigns.title AS `Campaigns__title`, Campaigns.user_id AS `Campaigns__user_id`, Campaigns.start_date AS |
# |
Nov 14th 2019, 12:02 |
rk.thedigifrog |
Hi Guy's, cakephp query not working: $this->Messages->find()->contain(['Campaigns'=>['campaignResponses']])->where(['Messages.sent_from '=> $get_array['To'], 'Messages.sent_to '=> $get_array['From']])->order(['Messages.created' => 'DESC'])->first(); Raw Query in log: SELECT Messages.id AS `Messages__id`, Messages.campaign_id AS `Messages__campaign_id`, Messages.customer_id AS `Messages__customer_id`, Messages.messageSid AS |
# |
Nov 14th 2019, 11:07 |
dereuromark |
if you modify courses in loop, then student entitiy doesnt know that. that is the case where you have to manually $student->setDirty('courses') then for the ORM to know |
# |
Nov 14th 2019, 10:57 |
javier.villanueva |
problem is that I dont know assign this days_attended. ¿Where I must assign?, in course? in student? in other? |
# |
Nov 14th 2019, 10:56 |
javier.villanueva |
if I do foreach $courses . $course->days_attended. Then I have a dirty field days_attended in dd($student) |
# |
Nov 14th 2019, 10:54 |
dereuromark |
in some cases you need to manually setDirty() those. but shouldnt be the case for direct assignment here |
# |
Nov 14th 2019, 10:54 |
dereuromark |
check why the fields are not dirty after you set them |
# |
Nov 14th 2019, 10:48 |
javier.villanueva |
not really, but I can do it |
# |
Nov 14th 2019, 10:48 |
dereuromark |
no need to validate the info? |
# |
Nov 14th 2019, 10:48 |
dereuromark |
why are you not patching it? |
# |
Nov 14th 2019, 10:47 |
javier.villanueva |
cause I dont see nothing |
# |
Nov 14th 2019, 10:47 |
javier.villanueva |
then I have a mistake lol |
# |
Nov 14th 2019, 10:44 |
javier.villanueva |
yes $student sorry |
# |
Nov 14th 2019, 10:44 |
dereuromark |
dd() the result and you will see |
# |
Nov 14th 2019, 10:43 |
dereuromark |
and yes, you can directly modify fields |
# |
Nov 14th 2019, 10:43 |
dereuromark |
$student (singular) |
# |
Nov 14th 2019, 10:42 |
javier.villanueva |
``` $students = $this->Students->newEntity(); $students->courses = $courses; ¿and days_attended? ``` |
# |
Nov 14th 2019, 10:41 |
javier.villanueva |
if I have a belongsToMany (with through option cause I have metadata in this relation https://book.cakephp.org/3/en/orm/associations.html#using-the-through-option). Could I save this metadata infomation directly when I save one of the models? for instance In the doc example how to save days_attended |
# |
Nov 14th 2019, 10:39 |
javier.villanueva |
morning all |
# |
Nov 14th 2019, 10:34 |
challgren |
Im not sure, I never use deliver I always do ->send() |
# |
Nov 14th 2019, 10:32 |
mehov |
you mean it should use the *default transport*, not the whatever transport defined for the *default profile*, correct? i.e. this is the intended behaviour, and if i want `deliver()` to use my custom transport configuration, i should overwrite the default transport with it, instead of putting it into a separate transport and choosing it for the default profile |
# |
Nov 14th 2019, 10:29 |
challgren |
But it should use the default |
# |
Nov 14th 2019, 10:28 |
challgren |
Source code |
# |
Nov 14th 2019, 10:28 |
challgren |
https://api.cakephp.org/3.4/source-class-Cake.Mailer.Email.html#2092-2130 |
# |
Nov 14th 2019, 10:27 |
mehov |
https://cakesf.slack.com/archives/C053DPNGT/p1573727141287500 > Sounds like deliver specifies you must define the config does it say that in the doc or source code somewhere? |
# |
Nov 14th 2019, 10:26 |
slackebot1 |
breaks the whole point |
# |
Nov 14th 2019, 10:26 |
mehov |
I sat down to read the Email doc page and found it there: https://book.cakephp.org/3/en/core-libraries/email.html#sending-messages-quickly The logic made sense: > Sometimes you need a quick way to fire off an email, and you don’t necessarily want do setup a bunch of configuration ahead of time. Cake\Mailer\Email::deliver() is intended for that purpose It's just having to setup configuration for the method that's supposed to work quickly |
# |
Nov 14th 2019, 10:25 |
challgren |
Sounds like deliver specifies you must define the config |
# |
Nov 14th 2019, 10:24 |
challgren |
@mehov I’ve never seen Email::deliver() used. Most of the time it should be Email->send() |
# |
Nov 14th 2019, 10:23 |
slackebot1 |
time (thinking that's what the config files are for, right?) |