From 2696d29cb79b292a73babf994a8da2a685ba928d Mon Sep 17 00:00:00 2001 From: Edward Date: Tue, 18 Sep 2018 14:02:46 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 19 ++++++++++++++----- 1 file changed, 14 insertions(+), 5 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 48285a27..9932a4fa 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -55,6 +55,20 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject } } + if(!empty($q['_is_in_group'])){ + $this->selectAdd(" + COALESCE( + (SELECT id from core_group_member + WHERE + user_id = {$q['_is_in_group']} + AND + group_id = {$this->tableName()}.id + LIMIT 1 + ),0) as group_membership_user_id + "); + } + + $cp = DB_DataObject::Factory('core_person')->tableName(); $cgm = DB_DataObject::Factory('core_group_member')->tableName(); @@ -75,11 +89,6 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject "); } - - function toRooArray($q) - { - print_R($this);exit; - } function toEventString() { return $this->name; -- 2.39.2