From fd8bd87607ea4d64f10541318c82a9c57ffd01d3 Mon Sep 17 00:00:00 2001 From: KH Lau Date: Tue, 30 Jan 2018 16:36:17 +0800 Subject: [PATCH] DataObjects/Core_email.php --- DataObjects/Core_email.php | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php index de91473d..8fd76394 100644 --- a/DataObjects/Core_email.php +++ b/DataObjects/Core_email.php @@ -41,6 +41,18 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject $tn.subject LIKE '%{$this->escape($q['search']['nameortitle'])}%' "); } + + $this->selectAdd(" + ( + SELECT + count(user_id) + FROM + core_group_member + WHERE + to_group_id = core_group_member.group_id + ) + AS group_member_count + "); } function beforeDelete($dependants_array, $roo) -- 2.39.2