From: KH Lau <khlau@roojs.com>
Date: Mon, 30 Oct 2017 05:13:12 +0000 (+0800)
Subject: DataObjects/Events.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=eaf32f9049fe7b599467164157d886b89eb538bb

DataObjects/Events.php
---

diff --git a/DataObjects/Events.php b/DataObjects/Events.php
index c4970ca6..7ab63eea 100644
--- a/DataObjects/Events.php
+++ b/DataObjects/Events.php
@@ -735,4 +735,17 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
                         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 
+       ");
+    }
 }