return $set;
}
$c = DB_DataObject::factory($this->ontable);
+
if ($this->onid == 0) {
return $c; // empty dataobject.
}
$c->autoJoin();
+
if ($c->get($this->onid)) {
return $c;
}
}
function delivered()
{
- return !empty($msgid);
+ return !empty($this->msgid);
}
function status() // used by commandline reporting at present..
function applyFilters($q, $au, $roo)
{
- if (isset($q['ontable'])) {
+ if (isset($q['ontable']) && !in_array($q['ontable'], array('Person', 'Events' . 'core_watch'))) {
+ // this will only work on tables not joined to ours.
+
+ //DB_DAtaObject::DebugLevel(1);
// then we can build a join..
$d = DB_DataObject::Factory($q['ontable']);
$d->autoJoin();
- print_R($d);
- exit;
-
-
-
-
-
-
+ //$this->selectAdd($d->_query['data_select']); -- this will cause the same dataIndex...
+ $this->_join .= "
+ LEFT JOIN {$d->tableName()} ON {$this->tableName()}.onid = {$d->tableName()}.id
+ {$d->_join}
+ ";
+ $this->selectAs($d, 'core_notify_%s');
+ }
+ if (isset($q['query']['person_id_name']) ) {
+ $this->whereAdd( "join_person_id_id.name LIKE '{$this->escape($q['query']['person_id_name'])}%'");
+
+ }
+ if (!empty($q['query']['status'])) {
+ switch ($q['query']['status']) {
+
+ case 'SUCCESS';
+ $this->whereAdd("msgid != ''");
+ break;
+ case 'FAILED';
+ $this->whereAdd('event_id > 0 AND act_when <= NOW() ');
+ $this->is_active = 0;
+ break;
+ case 'PENDING';
+
+ $this->is_active = 0;
+ break;
+ case 'ALL':
+ default:
+ break;
+ }
}