}
$jt = DB_DataObject::factory($person);
- $this->whereAdd("
- person_table = *
- ");
+ //$this->whereAdd("
// person_table = '{$jt->tableName()}'
// OR
// person_table = ''
}
+ if (!isset($q['_who'])) {
+ $this->autoJoinExtData();
+ $this->autoJoinCorePerson();
+ }
+
// since roo does not support autojoin yet..
if (!isset($q['_distinct'])) {
//$this->autoJoinExtra();
$this->selectAdd('join_person_id_id.email as email');
}
+
+ function autoJoinExtData()
+ {
+ $this->_join .= "LEFT JOIN
+ ext_data AS ext_data_id
+ ON
+ Events.modx_users_id = ext_data_id.userdata_id";
+ }
+
+ function autoJoinCorePerson()
+ {
+ $this->_join .= "LEFT JOIN
+ core_person AS core_person_id
+ ON
+ Events.person_id = core_person_id.id";
+ }
}