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..
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();
- $this->selectAdd($d->data_select);
-
- $this->_join .= $d->join;
- echo '<PRE>';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->is_active = 1;
+ break;
+ case 'FAILED';
+ $this->is_active = 0;
+ break;
+ case 'PENDING';
+ $this->is_active = 0;
+ break;
+ case 'ALL':
+ default:
+ break;
+ }
}