public $person_id; // int(11)
public $remarks; // blob(65535) blob
public $person_table; // string(64)
public $person_id; // int(11)
public $remarks; // blob(65535) blob
public $person_table; // string(64)
- $this->whereAdd("
- person_table = '{$jt->tableName()}'
- OR
- person_table = ''
- OR person_table IS NULL"
- ); // default to our standard.. - unless otherwise requested..
+ //$this->whereAdd("
+ // person_table = '{$jt->tableName()}'
+ // OR
+ // person_table = ''
+ // OR person_table IS NULL"
+ //); // default to our standard.. - unless otherwise requested..
- if(!empty($q['dup_check'])){
- $et = DB_DataObject::factory($tn);
- $this->_join = "LEFT JOIN {$et->tableName()} AS evet ON (evet.id=Events.id)";
- $this->selectAdd("(select count(*) from Events where Events.dup_id = evet.id) as cnt ");
- $this->selectAs($et,'evet_%s','evet');
-
-
-
+ if(!empty($q['_with_dupe_count'])){
+ $this->dupe_id = 0;
+ $this->selectAdd("(select count(*)+1 from Events ev_cnt where ev_cnt.dupe_id = {$tn}.id) as dupe_count");
if (!method_exists($obj,'relatedWhere')) {
$roo->jerr( $q['_related_on_table'] . " Does not have method relatedWhere :" .
implode(',', get_class_methods($obj)));
}
if ($obj && method_exists($obj,'relatedWhere')) {
$ar = $obj->relatedWhere();
if (!method_exists($obj,'relatedWhere')) {
$roo->jerr( $q['_related_on_table'] . " Does not have method relatedWhere :" .
implode(',', get_class_methods($obj)));
}
if ($obj && method_exists($obj,'relatedWhere')) {
$ar = $obj->relatedWhere();
if (empty($au) || (isset($au->id) && empty($au->id))) {
// not authenticated - and a standard id based object
$this->person_id = 0;
if (empty($au) || (isset($au->id) && empty($au->id))) {
// not authenticated - and a standard id based object
$this->person_id = 0;
$cols = $this->tableColumns();
$col = isset($cols[$col]) ? $col : 'person_id'; // for BC.... - revert to using person_id
$this->{$col} = $au->pid();
$cols = $this->tableColumns();
$col = isset($cols[$col]) ? $col : 'person_id'; // for BC.... - revert to using person_id
$this->{$col} = $au->pid();
}
$this->person_table = $au ? $au->tableName() : '';
$this->ipaddr = isset($_SERVER["REMOTE_ADDR"]) ? $_SERVER["REMOTE_ADDR"] : 'cli';
}
$this->person_table = $au ? $au->tableName() : '';
$this->ipaddr = isset($_SERVER["REMOTE_ADDR"]) ? $_SERVER["REMOTE_ADDR"] : 'cli';