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' => 'email subject',
35 $ff = HTML_FlexyFramework::get();
44 function get($args, $opts)
48 $this->transObj = DB_DataObject::Factory('core_enum');
50 $this->transObj->query('BEGIN');
52 PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
54 if(empty($this->opts['group'])){
55 $this->jerr('Missing group - try add [-t {group name}]');
58 $rcpts = DB_DataObject::factory('groups')->lookupMembers("{$this->opts['group']}",'email');
61 $this->jerr("{$this->opts['group']} does not has any memeber");
64 // $events = DB_DataObject::factory('Events');
65 // $events->selectAdd();
66 // $events->selectAdd("
67 // DISTINCT(Events.action) AS action,
68 // COUNT(Events.id) AS total
71 // $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");
73 // if(!empty($this->opts['exclude'])){
74 // $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude']))));
76 // if(!empty($exclude)){
77 // $events->whereAddIn('!Events.action', $exclude, 'string');
81 // $events->groupBy('Events.action');
82 // $events->orderBy('Events.action ASC');
84 // $totals = $events->fetchAll('action', 'total');
86 // if(empty($totals)){
87 // $this->jerr('Nothing to be sent');
90 // $subject = array();
92 // foreach ($totals as $k => $v){
93 // $subject[] = "{$v} {$k}";
96 // $subject = implode(', ', $subject);
98 // if(!empty($this->opts['subject'])){
99 // $subject = "{$this->opts['subject']} $subject";
102 $events = DB_DataObject::factory('Events');
105 $events->selectAdd();
108 Events.event_when AS event_when,
109 Events.action AS action,
110 Events.remarks AS remarks,
111 CASE WHEN Events.person_id != 0 THEN
112 join_person_id_id.email
113 WHEN Events.hydra_person_id != 0 THEN
114 join_hydra_person_id_id.email
120 $events->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");
122 $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude']))));
124 if(!empty($exclude)){
125 $events->whereAddIn('!Events.action', $exclude, 'string');
128 if(!$events->count()){
129 $this->jerr('Nothing to be sent');
132 print_R($events->fetchAll());exit;