case EnvayaSMS::ACTION_OUTGOING:
$actual_messages = $db->getAll('SELECT id, number "to", message, NOW() now_datetime,
created created_datetime,
( created + INTERVAL send_delay MINUTE ) send_start_datetime,
( created + INTERVAL expiry_delay MINUTE
+ INTERVAL send_delay MINUTE ) send_end_datetime
FROM sms_gate
WHERE NOW() >= ( created + INTERVAL send_delay MINUTE )
AND NOW() <= ( created + INTERVAL expiry_delay MINUTE + INTERVAL send_delay MINUTE )
AND (status = 0 OR status = 2)
AND LENGTH(number) = 11
ORDER BY status ASC, id ASC
LIMIT 1');
$messages = [];
foreach ($actual_messages as $message) {
$sms = new EnvayaSMS_OutgoingMessage();
$sms->id = $message['id'];
$sms->to = $message['to'];
$sms->message = $message['message'];
$sms->priority = NULL;
$sms->type = NULL;
$messages[] = $sms;
}
$events = [];
if ($messages) {
$events[] = new EnvayaSMS_Event_Send($messages);
}
echo $request->render_response($events);
return;