Report/SendEventErrors.php

diff --git a/Report/SendEventErrors.php b/Report/SendEventErrors.php
index bc45b8a..3a2fc76 100644 (file)
--- 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");