}
- if (!isset($q['_who'])) {
- $this->autoJoinExtData();
- $this->autoJoinCorePerson();
+ if (isset($q['_who'])) {
+ $this->autoJoin();
+ //$e = PDO_DataObject::factory('ext_data');
+ //$this->joinAdd($e,'LEFT');
+ //$this->autoJoinCorePerson();
$this->selectAddWho();
}
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";
- }
-
function selectAddWho()
{
- $this->selectAdd("
- core_person_id.name AS person_name,
- 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
- ");
+ $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
+ //");
}
}