projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
7b6d405
)
DataObjects/Events.php
author
KH Lau
<khlau@roojs.com>
Mon, 30 Oct 2017 05:13:12 +0000
(13:13 +0800)
committer
KH Lau
<khlau@roojs.com>
Mon, 30 Oct 2017 05:13:12 +0000
(13:13 +0800)
DataObjects/Events.php
patch
|
blob
|
history
diff --git
a/DataObjects/Events.php
b/DataObjects/Events.php
index
c4970ca
..
7ab63ee
100644
(file)
--- 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
+ ");
+ }
}