From d226552a7f0b58de81105c9bb82304ddc8445ca1 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 31 Jul 2018 15:13:23 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index a18c3da9..5c0618f5 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -54,7 +54,17 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject } } - + if(!empty($q['_with_member_id'])){ + $this->selectAdd(" + COALESE( + (SELECT id from core_group_member + WHERE ... + + LIMIT 1 + ),0) as .... + "); + } + $cp = DB_DataObject::Factory('core_person')->tableName(); $cgm = DB_DataObject::Factory('core_group_member')->tableName(); -- 2.39.2