<?php
use Phalcon\Mvc\Model;

class SpyEvent extends \Phalcon\Mvc\Model
{
    public function getSource()
    {
        return "spy_event";
    }


    public function spyTimeAfter($project,$customer_id){
        return  self::query()
            ->columns(['customer_id', 'st.id, st.item_id', 'st.item_name', 'st.item_image', 'st.quantity', 'st.price', 'st.item_url', 'st.item_image'])
            ->rightJoin('spyStore', 'st.spy_event_id = SpyEvent.id', 'st')
            ->where("project_id = :project_id:")
            ->andWhere("action ='order_add'")
            ->andWhere("customer_id =$customer_id")
            ->bind(array("project_id" => $project->id))
            ->execute();

    }

    public function getSpyUsers($modelsManager, $project)
    {

        $now = date("Y-m-d H:i:s");

        $date1 = new DateTime($now);
        $date1->modify('-3 hours');
        $date1 = $date1->format('Y-m-d H:i:s');

        $date2 = new DateTime($now);
        $date2->modify('-11 hours');
        $date2 = $date2->format('Y-m-d H:i:s');

        $phql = "SELECT DISTINCT (customer_id) as id FROM SpyEvent WHERE project_id = {$project->id} AND action = 'order_add' AND date <=  '{$date1}' OR date <=  '{$date2}'";
        //äîáàâèòü êîä íèæå äëÿ ïðîâåðêè âðåìåíè
        // AND action = 'order_add' AND date <=  '{$date}'

        return $modelsManager->executeQuery($phql)->toArray();

    }
}