From 9c690ed6df46acb23ddcc101c66db892af062c5d Mon Sep 17 00:00:00 2001 From: KH Lau Date: Mon, 23 Oct 2017 15:47:56 +0800 Subject: [PATCH] DataObjects/Events.php --- DataObjects/Events.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/DataObjects/Events.php b/DataObjects/Events.php index a9e36ebd..c28be71c 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -39,18 +39,19 @@ class Pman_Core_DataObjects_Events extends DB_DataObject // if not empty on_table if(!empty($q['person_table'])){ - $jt = DB_DataObject::factory($q['person_table']); $et = DB_DataObject::factory($tn); + $this->selectAdd("(select count(*) from Events where Events.dup_id = evet.id) as cnt "); + $this->selectAs($et,'%s','evet'); if(!array_key_exists("{$jt->tableName()}_id", $this->tableColumns())){ // coz we have triiger on mysql... $keys = $jt->keys(); $this->_join = "LEFT JOIN {$jt->tableName()} AS join_person_id_id ON (join_person_id_id.{$keys[0]}=Events.person_id)"; - $this->selectAdd("(select count(*) from Events where Events.dup_id = evet.id) as cnt "); - $this->selectAs($et,'%s','evet'); + $this->selectAdd(); + $this->selectAs(); $this->selectAs($jt, 'person_id_%s', 'join_person_id_id'); -- 2.39.2