X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=d34ac9b0a026246959978588bf90effb04b4e701;hb=9d267840ff7efc96b0022d443c137643e9fd792e;hp=9f6e8a03dc070abe2b1a6b873f75c549800bc06c;hpb=d2eaa30ca3dd5d1284dc0563ad239db543bee0d5;p=Pman.Core diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 9f6e8a03..d34ac9b0 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -50,12 +50,12 @@ 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()); } } $cgm = DB_DataObject::Factory('core_group_member')->tableName();; - $this->selectAdd(" + $this->selectAdd(" ( SELECT count(user_id) @@ -66,6 +66,19 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject ) AS group_member_count "); + + $this->_join .= " + LEFT JOIN + core_group_member + ON + core_group.id = core_group_member.group_id + Left JOIN + core_person + ON + core_user_id = core_person.id + "; + + } function toEventString() {