From 86952307d54cce7c5936f672c16c71208fa9d6a1 Mon Sep 17 00:00:00 2001 From: edward Date: Fri, 5 Feb 2016 12:23:55 +0800 Subject: [PATCH] Report/SendEventErrors.php --- Report/SendEventErrors.php | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) diff --git a/Report/SendEventErrors.php b/Report/SendEventErrors.php index bc45b8a..3a2fc76 100644 --- a/Report/SendEventErrors.php +++ b/Report/SendEventErrors.php @@ -101,11 +101,19 @@ class Pman_Admin_Report_SendEventErrors extends Pman_Roo $events = DB_DataObject::factory('Events'); $events->autoJoin(); - print_R($events);exit; + $events->selectAdd(); $events->selectAdd(" Events.event_when AS event_when, - Events.action AS action + Events.action AS action, + Events.remarks AS remarks + CASE WHEN Events.person_id != 0 THEN + join_person_id_id.email + WHEN Events.hydra_person_id != 0 THEN + join_hydra_person_id_id.email + ELSE + '' + END AS email "); $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY"); -- 2.39.2