From 6b2e1da2fec30e3bec6dbf31a7a1332ca27be69a Mon Sep 17 00:00:00 2001 From: KH Lau Date: Tue, 31 Oct 2017 11:23:25 +0800 Subject: [PATCH] DataObjects/Events.php --- DataObjects/Events.php | 26 +++----------------------- 1 file changed, 3 insertions(+), 23 deletions(-) diff --git a/DataObjects/Events.php b/DataObjects/Events.php index 372533cb..7abc664a 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -256,10 +256,10 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } if (isset($q['_who'])) { - $e = PDO_DataObject::factory('ext_data'); - $this->joinAdd($e,'LEFT'); + //$e = PDO_DataObject::factory('ext_data'); + //$this->joinAdd($e,'LEFT'); //$this->autoJoinCorePerson(); - $this->selectAddWho(); + //$this->selectAddWho(); } // since roo does not support autojoin yet.. @@ -723,25 +723,5 @@ class Pman_Core_DataObjects_Events extends DB_DataObject } - 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 - //"); - } } -- 2.39.2