X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=c9f12bc1f4e92c96abca0b57e0ce77b21219c066;hb=7e47084723e8e83d89498da0e605d325e5add1a4;hp=b0e01ecaca0eb7a20034397519156ce695330fed;hpb=1fa914c0f1e1aca36dd32c1aae34597f9ee37bf7;p=Pman.Core diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index b0e01eca..c9f12bc1 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -50,10 +50,32 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $core_group = DB_DataObject::factory('core_group'); if($core_group->get('name', $q['_count_member_by_name'])){ - $roo->jdata($core_group->memberCount()); + $roo->jok($core_group->memberCount()); } } + + + $cp = DB_DataObject::Factory('core_person')->tableName(); + $cgm = DB_DataObject::Factory('core_group_member')->tableName(); + + $this->selectAdd(" + ( + SELECT + count(user_id) + FROM + core_group_member + + ) + AS group_member_count + "); + + + + + /*$cgmDBObj->joinAdd($cpObj); + $this->joinAdd($cgmDBObj); + DB_DataObject::debugLevel();*/ } function toEventString() { @@ -139,6 +161,9 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject { $gm = DB_Dataobject::factory('core_group_member'); $gm->group_id = $this->id; + $gm->autoJoin(); + $gm->whereAdd('join_user_id_id.active = 1'); + //PDO_DAtaObject::DebugLevel(1); return $gm->count(); } @@ -146,6 +171,8 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject { $gm = DB_Dataobject::factory('core_group_member'); $gm->group_id = $this->id; + $gm->autoJoin(); + $gm->whereAdd('join_user_id_id.active = 1'); return $gm->fetchAll('user_id'); } @@ -157,10 +184,10 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject return $gm->count(); } - function addMember($person,$roo) + function addMember($person,$roo = false) { - if ($this->name != "Empty Group") { - //$this->jerr('Cannot the person into the empty group'); + if ($this->name == "Empty Group") { + $roo->jerr('Cannot add the person into Empty Group'); } $gm = DB_Dataobject::factory('core_group_member'); $gm->group_id = $this->id; @@ -199,8 +226,6 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject // groups databse is hard coded to person.. so this should not be used for other tables.???? $p = DB_Dataobject::factory( 'core_person' ); - - $p->whereAdd('id IN ('. implode(',', $ids) .')'); $p->active = 1; @@ -253,7 +278,7 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject function initGroups() { - + $g = DB_DataObject::factory($this->tableName()); $g->type = 0; $g->name = 'Administrators';