From f45c69799150790ccc029dce02969850d5d49b90 Mon Sep 17 00:00:00 2001 From: edward Date: Fri, 5 Feb 2016 12:21:22 +0800 Subject: [PATCH] Report/SendEventErrors.php --- Report/SendEventErrors.php | 23 ++++++++++++++++++++++- 1 file changed, 22 insertions(+), 1 deletion(-) diff --git a/Report/SendEventErrors.php b/Report/SendEventErrors.php index 52e9cfb..895a12c 100644 --- a/Report/SendEventErrors.php +++ b/Report/SendEventErrors.php @@ -99,7 +99,28 @@ class Pman_Admin_Report_SendEventErrors extends Pman_Roo $subject = "{$this->opts['subject']} $subject"; } - print_r($subject);exit; + $events = DB_DataObject::factory('Events'); + $events->autoJoin(); + $events->selectAdd(); + $events->selectAdd(" + Events.event_when AS event_when, + Events.action AS action, + Events. + "); + + $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY"); + + if(!empty($this->opts['exclude'])){ + $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude'])))); + + if(!empty($exclude)){ + $events->whereAddIn('!Events.action', $exclude, 'string'); + } + } + + $events->groupBy('Events.action'); + $events->orderBy('Events.action ASC'); + $this->jok("Done"); -- 2.39.2