From 99e16861cc0c51cc8de55431480fd48fe92a315a Mon Sep 17 00:00:00 2001 From: benny Date: Fri, 27 Jul 2018 10:38:09 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 643a6687..b890b7d6 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -56,8 +56,8 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject -// $cp = DB_DataObject::Factory('core_person')->tableName(); -// $cgm = DB_DataObject::Factory('core_group_member')->tableName(); + $cp = DB_DataObject::Factory('core_person')->tableName(); + $cgm = DB_DataObject::Factory('core_group_member')->tableName(); $this->selectAdd(" ( @@ -68,11 +68,11 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject LEFT JOIN core_person ON - core_person.id = core_group_member.user_id + ${cp}.id = {$cgm}.user_id WHERE - core_group_member.group_id = core_group.id - AND - core_person.active = 1 + ${cgm}.group_id = {$this->tableName()}.id + AND + ${cp}.active = 1 ) AS group_member_count "); -- 2.39.2