function perform($params)
{
$sql = <<<EOT
SELECT e.event_type,e.event_time,e.context_json,j.ref,j.prettyname,j.oneliner
FROM event_log e INNER join journo j on j.id=e.journo_id
WHERE e.event_time >= date ? AND e.event_time < (date ? + interval '24 hours')
ORDER BY e.event_time DESC
EOT;
$rows = db_getAll($sql, $params['from_date']->format('Y-m-d'), $params['to_date']->format('Y-m-d'));
foreach ($rows as &$r) {
$r['description'] = $r['event_type'] . ' ("' . eventlog_Describe($r) . '")';
unset($r['event_type']);
unset($r['context']);
unset($r['context_json']);
$r['event_time'] = date_create($r['event_time'])->format('Y-m-d h:i:s');
}
collectColumns($rows);
return $rows;
}
function journo_fetchRecentEvents($journo_id)
{
$sql = <<<EOT
SELECT event_time, event_type, context_json FROM event_log
WHERE journo_id=? AND event_time>NOW()-interval '12 hours'
ORDER BY event_time DESC;
EOT;
$events = db_getAll($sql, $journo_id);
foreach ($events as &$ev) {
$ev['context'] = json_decode($ev['context_json'], TRUE);
$ev['description'] = eventlog_Describe($ev);
}
return $events;
}
