X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_notify.php;h=dbf012bb5b2c3aa37b43af22c5e35ffea6d2847f;hp=cfa2a06f1314637cb4c293229d74365abe991421;hb=HEAD;hpb=2bff5281230348363bcdc467492fcb23e2ddffe2

diff --git a/DataObjects/Core_notify.php b/DataObjects/Core_notify.php
index cfa2a06f..2570c860 100644
--- a/DataObjects/Core_notify.php
+++ b/DataObjects/Core_notify.php
@@ -1,7 +1,7 @@
 <?php
 /**
  *
- * Table is designed to be used with a mailer to notify or issue
+ * Table iend designed to be used with a mailer to notify or issue
  * emails (or maybe others later??)
  *
  *
@@ -20,7 +20,7 @@ CREATE TABLE  core_notify  (
 );
 **/
 
-require_once 'DB/DataObject.php';
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
 
 class Pman_Core_DataObjects_Core_notify extends DB_DataObject 
 {
@@ -42,18 +42,36 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
     public $trigger_event_id;              // int(11)  
     public $evtype;                         // event type (or method to call)fall
     public $act_start;
-    
+    public $person_table;
+    public $to_email;
+ 
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
     
     function person($set = false)
     {
+        $def_pt = 'core_person';
+        
         if ($set !== false) {
-            $this->person_id = is_object($set) ? $set->id : $set;
+            $this->person_table = is_object($set) ? $set->tableName() : '';
+            
+            $person_table = empty($this->person_table) ? $def_pt  : strtolower($this->person_table);
+            $col = $person_table  == $def_pt ? 'person_id' : $person_table . '_id';
+            
+            $this->{$col} = is_object($set) ? $set->id : $set;
             return;
         }
-        $c = DB_DataObject::Factory('Person');
-        $c->get($this->person_id);
+        static $cache  =array();
+        $person_table = empty($this->person_table) ? $def_pt  : strtolower($this->person_table);
+        $col = $person_table == $def_pt  ? 'person_id' : $person_table . '_id';
+        
+        if (isset($cache[$person_table .':'. $this->{$col}])) {
+            return $cache[$person_table .':'. $this->{$col}];
+        }
+        
+        $c = DB_DataObject::Factory($person_table == 'person' ? 'core_person' : $person_table);
+        $c->get($this->{$col});
+        $cache[$person_table .':'. $this->{$col}] = $c;
         return $c;
         
     }
@@ -78,6 +96,24 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
         return false;
         
     }
+    
+    function lookup($obj, $person, $evtype='')
+    {
+        $x = DB_DataObject::Factory($this->tableName());
+        $x->object($obj);
+        $x->person($person);
+        if (!empty($evtype)) {
+            $x->evtype = $evtype;
+        }
+        if ($x->count() != 1) {
+            return false;
+        }
+        $x->find(true);
+        return $x;
+        
+    }
+    
+    
     function beforeDelete($dependants_array, $roo) {
         if ($this->delivered()) {
             $roo->jerr("you can not delete a record of a successfull delivery");
@@ -162,10 +198,50 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
                 return  $p. $this->event()->remarks;
         }
         
+    }
+    /**
+     * current state of process
+     *
+     * 0 = pending
+     * 1 = delivered
+     * -1 = failed
+     *
+     *
+     */
+    function state()
+    {
+           
+        if ($this->msgid != '') {
+            return 1;
+        }
+        
+        // msgid is empty now..
+        // if act_when is greater than now, then it's still pending.
+        if (strtotime($this->act_when) > time()) {
+            return 0; 
+        }
+        
+        // event id can be filled in with a failed attempt.
+        
+        if ($this->event_id > 0) {
+            return -1;
+        }
+        
+        // event id is empty, and act_when is in the past... not sent yet..
+        
+        return 0; // pending
+        
+        
     }
     
+    
     function applyFilters($q, $au, $roo)
     {
+        
+        if (!empty($q['search']['contains'])) {
+            $this->whereAdd("join_event_id_id.remarks LIKE '%".$this->escape($q['search']['contains']) ."%'");
+            
+        }
         if (isset($q['ontable']) && !in_array($q['ontable'], array('Person', 'Events',  'core_watch'))) {
             // this will only work on tables not joined to ours.
             
@@ -186,7 +262,7 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
             "; 
             $this->selectAs($d, 'core_notify_%s');
         } 
-        if (isset($q['query']['person_id_name']) ) {
+        if (!empty($q['query']['person_id_name']) ) {
             $this->whereAdd( "join_person_id_id.name LIKE '{$this->escape($q['query']['person_id_name'])}%'");
              
         }
@@ -203,6 +279,7 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
                     break;
                 case 'PENDING';
                     $this->whereAdd('event_id = 0 OR (event_id  > 0 AND act_when > NOW() )');
+                    $this->whereAdd("sent < '2000-01-01'");
                     break;
                 
                 case 'OPENED';
@@ -215,11 +292,77 @@ class Pman_Core_DataObjects_Core_notify extends DB_DataObject
             }
         }
         
+        if(!empty($q['_evtype_align'])){
+            $this->selectAdd("
+                (SELECT
+                        display_name
+                FROM
+                        core_enum
+                WHERE
+                        etype = 'Core.NotifyType'
+                    AND
+                        name = core_notify.evtype
+                    AND
+                        active = 1
+                ) AS evtype_align
+            ");
+        }
         
+        if(!empty($q['from'])){
+            $this->whereAdd("
+                act_when >= '{$q['from']}'
+            ");
+        }
         
+        if(!empty($q['to'])){
+            $this->whereAdd("
+                act_when <= '{$q['to']}'
+            ");
+        }
         
+    }
+    
+    function sendManual($debug=false)
+    {   
+        require_once 'Pman/Core/NotifySend.php';
         
+        $send = new Pman_Core_NotifySend();
+        $send->error_handler = 'exception';
         
+        if ($debug) {
+            $send->get($this->id, array());
+            return true;
+        }
+        
+        try {
+            $send->get($this->id, array('force' => 1));
+        } catch (Exception $e) {
+            ob_end_clean();
+            return $e;
+        }
+        
+        ob_end_clean();
+        
+        return true;
+    }
+    // after called do not rely on content as it includes NOW()
+    function flagDone($event,$msgid)
+    {
+        $ww = clone($this);
+        if(strtotime($this->act_when) > strtotime("NOW")){
+            $this->act_when = $this->sqlValue('NOW()');
+        }
+        $this->sent = empty($this->sent) || strtotime($this->sent) < 1 ? $this->sqlValue('NOW()') :$this->sent; // do not update if sent.....
+        $this->msgid = $msgid;
+        $this->event_id = $event->id;
+        $this->update($ww);
+    }
+    
+    function flagLater($when)
+    {
+        $ww = clone($this);
+        $this->act_when = $when;
+        $this->update($ww);
     }
     
 }