}
+ if (isset($q['_who'])) {
+
+ $e = PDO_DataObject::factory('ext_data');
+ $this->joinAdd($e,'LEFT');
+ //$this->autoJoinCorePerson();
+ $this->selectAddWho();
+ }
+
// 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 selectAddWho()
+ {
+ $this->selectAdd("join_person_id_userdata_id.in_firstname, join_person_id_userdata_id.in_middlename, join_person_id_userdata_id.in_lastname");
+
+ //$this->selectAdd("
+ // CASE
+ // WHEN ext_data_id.in_middlename='' THEN
+ // CONCAT_WS(' ', ext_data_id.in_firstname,ext_data_id.in_lastname)
+ // ELSE
+ // CONCAT_WS(' ', ext_data_id.in_firstname,ext_data_id.in_middlename,ext_data_id.in_lastname)
+ // END AS ext_data_full_name
+ //");
+ }
}