X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=d34ac9b0a026246959978588bf90effb04b4e701;hb=9d267840ff7efc96b0022d443c137643e9fd792e;hp=595d44eb2488e09941c0936fd9c84b3b5db7b1a7;hpb=e4a7289d341ef33d59287472cd55e17c2e42e608;p=Pman.Core diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 595d44eb..d34ac9b0 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -55,7 +55,7 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject } $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() {