From 550dee7e7ed121105c990fc13e5ac90de0ccae69 Mon Sep 17 00:00:00 2001 From: benny Date: Thu, 26 Jul 2018 16:24:40 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 16 +++++++++------- 1 file changed, 9 insertions(+), 7 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 7b2ccbeb..84119d97 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -56,21 +56,23 @@ 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(" ( SELECT - COUNT(core_group_member.user_id) + COUNT(core_group_member.user_id) FROM - core_group_member + core_group_member LEFT JOIN - core_person + core_person ON - core_person.id = core_group_member.user_id + core_person.id = core_group_member.user_id WHERE - core_person.active = 1 + core_group_member.group_id = core_group.id + AND + core_person.active = 1 ) AS group_member_count "); /*WHERE -- 2.39.2