X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FEvents.php;h=d573e4ed35eca445a5274e08bbbd8792557c464d;hb=9e9ddc4a06d04c6ef7b387f316c6bf0ac0c002d2;hp=fa86a9c836cc670f58db284b17532a44900134fa;hpb=eda0a2661e3eb9f3df726e37ea3f5d9209adac99;p=Pman.Core

diff --git a/DataObjects/Events.php b/DataObjects/Events.php
index fa86a9c8..d573e4ed 100644
--- a/DataObjects/Events.php
+++ b/DataObjects/Events.php
@@ -25,7 +25,6 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
     public $person_id;                       // int(11)  
     public $remarks;                         // blob(65535)  blob
     public $person_table;                    // string(64)
-    public $investor_id;                           // int(11)  
 
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
@@ -38,16 +37,19 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
     {
         $tn = $this->tableName();
         // if not empty on_table
+        echo $this->tableName();
         if(!empty($q['person_table'])){
             $jt = DB_DataObject::factory($q['person_table']);
+
+            $et = DB_DataObject::factory($tn);
             
             if(!array_key_exists("{$jt->tableName()}_id", $this->tableColumns())){ // coz we have triiger on mysql...
                 
                 $keys = $jt->keys();
             
                 $this->_join = "LEFT JOIN {$jt->tableName()} AS join_person_id_id ON (join_person_id_id.{$keys[0]}=Events.person_id)";
-                $this->selectAdd();
-                $this->selectAs();
+                $this->selectAdd("(select count(*) from Events where Events.dup_id = evet.id) as cnt ");
+                $this->selectAs($et,'%s','evet');
 
                 $this->selectAs($jt, 'person_id_%s', 'join_person_id_id');
 
@@ -101,7 +103,8 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
         if (!$au->hasPerm("Admin.Admin_Tab", 'S')) {
             //DB_DataObject::DebugLevel(1);
             // they can only view their changes..
-            $this->person_id = $au->id;
+            $this->whereAdd("($tn.person_id = {$au->id} OR $tn.person_id = 0)");
+//            $this->person_id = $au->id;
             
         }
         // _join = tablename,tablename...
@@ -116,9 +119,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
             // empty ontable queries.. these are valid..
             $this->whereAdd("$tn.on_table = ''");
         }
-        
-        
-        
+      
         if (isset($q['query']['person_sum'])) {
             //DB_DataObject::debugLevel(1);
             $this->_extra_cols = array('qty' );