DataObjects/Events.php
authorEdward <edward@roojs.com>
Thu, 18 Dec 2014 03:04:42 +0000 (11:04 +0800)
committerEdward <edward@roojs.com>
Thu, 18 Dec 2014 03:04:42 +0000 (11:04 +0800)
DataObjects/Events.php

index edc5daa..19050cf 100644 (file)
@@ -37,11 +37,10 @@ class Pman_Core_DataObjects_Events extends DB_DataObject
     {
         $tn = $this->tableName();
         // if not empty on_table
-        $q['person_table'] = 'cntct';
         if(!empty($q['person_table'])){
             $jt = DB_DataObject::factory($q['person_table']);
         
-            $this->_join = "LEFT JOIN {$jt->tableName()} AS join_person_id_id ON (join_person_id_id.cntct_id=Events.person_id)";
+            $this->_join = "LEFT JOIN {$jt->tableName()} AS join_person_id_id ON (join_person_id_id.id=Events.person_id)";
             $this->selectAdd();
             $this->selectAs();