DataObjects/Events.php
authorAlan Knowles <alan@roojs.com>
Wed, 8 Feb 2012 03:55:01 +0000 (11:55 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 8 Feb 2012 03:55:01 +0000 (11:55 +0800)
DataObjects/Events.php

index c5167af..6e0ad5a 100644 (file)
@@ -73,6 +73,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
             //DB_DataObject::debugLevel(1);
             $this->_extra_cols = array('qty' );
             $this->selectAdd("count($tn.id) as qty");
+            $this->selectAdd("count( distinct $tn.on_id) as uqty");
             $this->whereAdd('LENGTH(join_person_id_id.name) > 0 ');
             $this->groupBy('person_id');
         }
@@ -80,7 +81,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
             //DB_DataObject::debugLevel(1);
             $this->_extra_cols = array('qty' , 'uqty');
             $this->selectAdd("count($tn.id) as qty");
-            $this->selectAdd("count( distinct $tn.on_id) as uqty");
+            $this->selectAdd("count( distinct $tn.on_table, $tn.on_id) as uqty");
             
             $this->groupBy('on_table');
         }