From: Alan Knowles <alan@roojs.com>
Date: Wed, 9 Mar 2016 08:11:36 +0000 (+0800)
Subject: Report/SendEventErrors.php
X-Git-Url: http://git.roojs.org/?p=Pman.Admin;a=commitdiff_plain;h=c65865727cf5e5672829aac9cb01b25ca983151d

Report/SendEventErrors.php
---

diff --git a/Report/SendEventErrors.php b/Report/SendEventErrors.php
index e8a5db1..70c29c7 100644
--- a/Report/SendEventErrors.php
+++ b/Report/SendEventErrors.php
@@ -128,15 +128,10 @@ class Pman_Admin_Report_SendEventErrors extends Pman_Roo
             Events.id AS id,
             Events.event_when AS event_when,
             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.remarks AS remarks
+            
         ");
+        $events->selectAddPersonEmail();
         
         $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");