X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=613a77d07a69dedf225aab179d9e214e172ade47;hp=0ddfa8bd315d4a46f01a9b48f55d5d9935216372;hb=303dc6b95a0eb88eb025d0e8c23d1d631555425e;hpb=64c9440b1c63c76cc91ae53e382537c462ab3365 diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 0ddfa8bd..613a77d0 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,11 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $roo->jerr("missing group id"); } - foreach(explode(',', $q['user_ids']) as $uid) { + + $user_ids = explode(',', $q['user_ids']); + + foreach($user_ids as $uid) { + switch($q['_action']) { case 'add': $g->addMember($uid,$roo); @@ -195,6 +210,7 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $gm = DB_Dataobject::factory('core_group_member'); $gm->group_id = $this->id; $gm->user_id = is_object($person) ? $person->id : $person; + if (!$gm->count()) { $gm->insert(); }