Blame view

src/lib/models/eventInfo.php 685 Bytes
ef60cd4d   Administrator   first commit
1
2
3
4
  <?php
  
  class eventInfo extends \Phalcon\Mvc\Model
  {
576e8c45   Administrator   change request to...
5
6
7
8
9
10
      public $customer_id;
      public $event_id;
      public $project_id;
      public $last_delivery;
      public $next_delivery;
      public $event_trigger;
ef60cd4d   Administrator   first commit
11
12
13
14
15
16
  
      public function getSource()
      {
          return "event_info";
      }
  
62ff66e4   Administrator   change request to...
17
18
      static public function getEventsByTrigger($modelsManager, $project_id, $trigger){
          $now = date("Y-m-d H:i:s");
576e8c45   Administrator   change request to...
19
  
62ff66e4   Administrator   change request to...
20
21
22
23
24
25
26
27
28
29
          $phql = "
          SELECT * FROM eventInfo
          WHERE project_id = $project_id
          AND event_trigger='{$trigger}'
          AND next_delivery <= '$now'
          AND last_delivery IS NULL OR last_delivery = ''";
  
          return $modelsManager->executeQuery($phql);
  
      }
ef60cd4d   Administrator   first commit
30
  }