'min' => 1,
'max' => 1,
),
+ 'exclude' => array(
+ 'desc' => 'list of actions to exclude from report',
+ 'short' => 'e',
+ 'default' => '',
+ 'min' => 1,
+ 'max' => 1,
+ ),
+ 'subject' => array(
+ 'desc' => 'email subject',
+ 'short' => 's',
+ 'default' => '',
+ 'min' => 1,
+ 'max' => 1,
+ ),
+ 'helo' => array(
+ 'desc' => 'mail helo to use',
+ 'short' => 'l',
+ 'default' => '',
+ 'min' => 1,
+ 'max' => 1,
+ ),
+ 'host' => array(
+ 'desc' => 'mail host to use',
+ 'short' => 'h',
+ 'default' => '',
+ 'min' => 1,
+ 'max' => 1,
+ )
);
function getAuth()
function get($args, $opts)
{
$this->opts = $opts;
-
- $this->transObj = DB_DataObject::Factory('core_enum');
-
- $this->transObj->query('BEGIN');
-
- PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
-
+ print_R($this->opts);exit;
if(empty($this->opts['group'])){
$this->jerr('Missing group - try add [-t {group name}]');
}
$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');
- print_r($events->fetchAll('action', 'total'));exit;
+ $summary = $events->fetchAll('action', 'total');
+
+ if(empty($summary)){
+ $this->jerr('Nothing to be sent');
+ }
+
+ $subject = array();
+
+ foreach ($summary as $k => $v){
+ $subject[] = "{$v} {$k}";
+ }
+
+ $subject = implode(', ', $subject);
+
+ if(!empty($this->opts['subject'])){
+ $subject = "{$this->opts['subject']} $subject";
+ }
+
+ $events = DB_DataObject::factory('Events');
+ $events->autoJoin();
+
+ $events->selectAdd();
+ $events->selectAdd("
+ 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->whereAdd("Events.event_when > NOW() - INTERVAL 1 DAY");
+
+ $exclude = array_unique(array_filter(array_map('trim', explode(',', $this->opts['exclude']))));
+
+ if(!empty($exclude)){
+ $events->whereAddIn('!Events.action', $exclude, 'string');
+ }
+
+ if(!$events->count()){
+ $this->jerr('Nothing to be sent');
+ }
+
+ $errors = $events->fetchAll();
+
+ if(!empty($this->opts['helo'])){
+ HTML_FlexyFramework::get()->Mail['helo'] = $this->opts['helo'];
+ }
+
+ if(!empty($this->opts['host'])){
+ HTML_FlexyFramework::get()->Mail['host'] = $this->opts['host'];
+ }
+
+ $content = array(
+ 'template' => 'EVENT_ERRORS_REPORT',
+ 'rcpts' => $rcpts,
+ 'errors' => $errors,
+ 'subject' => $subject
+ );
+
+ $sent = DB_DataObject::factory('core_email')->send($content);
+
+ if(!is_object($sent)){
+ $this->jok("Done");
+ }
- $this->jok("Done");
+ $this->jerr($sent);
}