DataObjects/Core_person.php

diff --git a/DataObjects/Core_person.php b/DataObjects/Core_person.php
index 108e569..3a00068 100644 (file)
--- a/DataObjects/Core_person.php
+++ b/DataObjects/Core_person.php
@@ -51,6 +51,29 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
     
+    function applyFilters($q, $au, $roo)
+    {
+        $cg = DB_DataObject::Factory('core_group')->tableName();
+        $cgm = DB_DataObject::Factory('core_group_member')->tableName();
+        
+        $this->selectAdd("
+           (
+            SELECT GROUP_CONCAT(CONCAT_WS('\"', ${cgm}.group_id, '\"')) 
+                FROM 
+                    {$cgm}
+                LEFT JOIN
+                    {$this}
+                ON
+                    {$this->tableName()}.id = {$cgm}.user_id
+                AND
+                    ${cp}.active = 1
+                ) AS group_membership_list            
+        ");    
+        
+    }
+    
+    
+    
     function owner()
     {
         $p = DB_DataObject::Factory($this->tableName());