From ec4b802f97803be5ca5bc487dfae484d33af2d15 Mon Sep 17 00:00:00 2001 From: leon Date: Thu, 17 Mar 2022 12:57:47 +0800 Subject: [PATCH] DataObjects/Core_email.php --- DataObjects/Core_email.php | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php index c0d3721b..0447e14a 100644 --- a/DataObjects/Core_email.php +++ b/DataObjects/Core_email.php @@ -40,7 +40,25 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject } $cgm = DB_DataObject::Factory('core_group_member')->tableName();; - + $this->selectAdd(" + ( + SELECT + count(id) + FROM + {$cgm} + WHERE + to_group_id = {$cgm}.group_id + ) AS group_member_count, + + ( + SELECT + count(id) + FROM + {$cgm} + WHERE + bcc_group_id = {$cgm}.group_id + ) AS bcc_group_member_count + "); if (!empty($_REQUEST['_hide_system_emails'])) { $this->whereAddIn("!{$this->tableName()}.name", array('EVENT_ERRORS_REPORT'), 'string'); -- 2.39.2