X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=7bb3b96a757ecd31e8e15e390bd90906cb638b17;hb=bb6b6fc0bcb6f006aecf4311b23f0266e4c44755;hp=0ddfa8bd315d4a46f01a9b48f55d5d9935216372;hpb=64c9440b1c63c76cc91ae53e382537c462ab3365;p=Pman.Core diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 0ddfa8bd..7bb3b96a 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -55,6 +55,22 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject } } + if(!empty($q['_is_in_group'])){ + $this->selectAdd(" + COALESCE(( + SELECT + COUNT(id) + FROM + core_group_member + WHERE + user_id = {$q['_is_in_group']} + AND + group_id = {$this->tableName()}.id + ), 0) AS is_in_group + "); + } + + $cp = DB_DataObject::Factory('core_person')->tableName(); $cgm = DB_DataObject::Factory('core_group_member')->tableName(); @@ -75,11 +91,6 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject "); } - - function postListExtra($q, $roo) - { - print_R($this);exit; - } function toEventString() { return $this->name; @@ -94,7 +105,7 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $roo->jerr("missing group id"); } - foreach(explode(',', $q['user_ids']) as $uid) { + foreach(explode(',', $q['user_ids']) as $uid) { switch($q['_action']) { case 'add': $g->addMember($uid,$roo);