3 require_once 'Pman/Roo.php';
5 class Pman_Admin_Report_SendEventErrors extends Pman_Roo
7 static $cli_desc = "Send event errors occured in the last 24 hours";
9 static $cli_opts = array(
11 'desc' => 'group to send to',
18 'desc' => 'list of actions to exclude from report',
25 'desc' => 'list of actions only to report',
32 'desc' => 'email subject',
39 'desc' => 'mail helo to use',
46 'desc' => 'mail host to use',
54 'desc' => 'list the current actions in the database',
64 $ff = HTML_FlexyFramework::get();
73 function get($args, $opts)
78 if(!empty($this->opts['list'])){
82 if(empty($this->opts['group'])){
83 $this->jerr('Missing group - try add [-t {group name}]');
86 $rcpts = DB_DataObject::factory('groups')->lookupMembers("{$this->opts['group']}",'email');
89 $this->jerr("{$this->opts['group']} does not has any memeber");
92 $events = DB_DataObject::factory('Events');
95 DISTINCT(Events.action) AS action,
96 COUNT(Events.id) AS total
99 $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");
101 if(!empty($this->opts['exclude'])){
102 $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude']))));
104 if(!empty($exclude)){
105 $events->whereAddIn('!Events.action', $exclude, 'string');
109 $events->groupBy('Events.action');
110 $events->orderBy('Events.action ASC');
112 $summary = $events->fetchAll('action', 'total');
115 $this->jerr('Nothing to be sent');
120 foreach ($summary as $k => $v){
121 $subject[] = "{$v} {$k}";
124 $subject = implode(', ', $subject);
126 if(!empty($this->opts['subject'])){
127 $subject = "{$this->opts['subject']} $subject";
130 $events = DB_DataObject::factory('Events');
133 $events->selectAdd();
136 Events.event_when AS event_when,
137 Events.action AS action,
138 Events.remarks AS remarks
141 $events->selectAddPersonEmail();
143 $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");
145 $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude']))));
147 if(!empty($exclude)){
148 $events->whereAddIn('!Events.action', $exclude, 'string');
151 if(!$events->count()){
152 $this->jerr('Nothing to be sent');
155 $errors = $events->fetchAll();
157 if(!empty($this->opts['host'])){
158 // reset the mail settings..
159 HTML_FlexyFramework::get()->Mail = array(
160 'host' => $this->opts['host']
164 if(!empty($this->opts['helo'])){
165 HTML_FlexyFramework::get()->Mail['helo'] = $this->opts['helo'];
171 'template' => 'EVENT_ERRORS_REPORT',
174 'subject' => $subject
177 $sent = DB_DataObject::factory('core_email')->send($content);
179 if(!is_object($sent)){
189 $events = DB_DataObject::factory('Events');
190 $events->selectAdd();
192 DISTINCT(Events.action) AS action
194 $events->whereAdd("action != ''");
195 $ar = $events->fetchAll('action');
196 echo implode(",", $ar);