From 2256fe811941e640ec9e637f3a701b1d189d444e Mon Sep 17 00:00:00 2001 From: KH Lau Date: Wed, 31 Jan 2018 15:48:56 +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