<?php

class eventInfo extends \Phalcon\Mvc\Model
{
    public $customer_id;
    public $event_id;
    public $project_id;
    public $last_delivery;
    public $next_delivery;
    public $event_trigger;

    public function getSource()
    {
        return "event_info";
    }

    static public function getEventsByTrigger($modelsManager, $project_id, $trigger){
        $now = date("Y-m-d H:i:s");

        $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);

    }
}