From a67cf0bd4e6769fb1da9f117cd5c95e6bd4ceae5 Mon Sep 17 00:00:00 2001
From: KH Lau <khlau@roojs.com>
Date: Mon, 30 Oct 2017 13:19:41 +0800
Subject: [PATCH] DataObjects/Events.php

---
 DataObjects/Events.php | 17 ++++-------------
 1 file changed, 4 insertions(+), 13 deletions(-)

diff --git a/DataObjects/Events.php b/DataObjects/Events.php
index da1e9242..3614b0fd 100644
--- a/DataObjects/Events.php
+++ b/DataObjects/Events.php
@@ -254,10 +254,10 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
             
             
         }
-        if (isset($q['_who'])) {
+        if (!isset($q['_who'])) {
         	   $this->autoJoinExtData();
-            $this->autoJoinCorePerson();
-            //$this->selectAddWho(); 
+            //$this->autoJoinCorePerson();
+            $this->selectAddWho(); 
         }
         
         // since roo does not support autojoin yet..
@@ -729,18 +729,9 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
                             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, 
+       $this->selectAdd("             
             CASE
                 WHEN ext_data_id.in_middlename='' THEN
                     CONCAT_WS(' ', ext_data_id.in_firstname,ext_data_id.in_lastname)
-- 
2.39.2