<?php
include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/CrmjourneytasksFactory.php";
include_once __DIR__ . "/../models/CrmjourneystageModel.php";

class CrmjourneytasksModel extends My_Model
{
    /**
     * @var string
     */
    public $table = 'module_imobles_crm_journey_tasks';
    public function createCrmjourneytasks($data)
    {
        $crm_journey_tasks = self::create();
       CrmjourneytasksFactory::create($data, $crm_journey_tasks,true);
                $crm_journey_tasks->save();
        return $crm_journey_tasks;
    }

    public function updateCrmjourneytasks($data, $crm_journey_tasks)
    {
        ORM::for_table($this->table)->create($crm_journey_tasks);
       CrmjourneytasksFactory::create($data, $crm_journey_tasks);
        $crm_journey_tasks->save();
       return $crm_journey_tasks;
    }
    
    public function deleteCrmjourneytasks($crm_journey_tasks)
    {
        ORM::for_table($this->table)->create($crm_journey_tasks);
        $now = new DateTime('now', new DateTimeZone('America/Sao_Paulo'));
        $user = User::_info();
        $crm_journey_tasks->deleted_at = $now->format('Y-m-d H:i:s');
        $crm_journey_tasks->deleted_by = $user->id;
        $crm_journey_tasks->save();
        return $crm_journey_tasks;
    }

    public function getClientJourneyTaskByStage($clientID){

        $crmJourneyStageModel = new CrmjourneystageModel();
        $journeyStages = $crmJourneyStageModel->getAllJourneyStages();

        $deal = ORM::for_table('module_imobles_deals')
            ->where('crm_account_id', $clientID)
            ->where_null('deleted_at')
            ->order_by_desc('id')
            ->find_one();
        if(isset($deal->id)){
            foreach($journeyStages as $js){
                $tasks = ORM::for_table($this->table)
                    ->where('crm_accounts_id', $clientID)
                    ->where('journey_stage_id', $js->id)
                    ->where_null('deleted_at')
                    ->where('deal_id', $deal->id)
                    ->order_by_asc('id')
                    ->find_many();
                    
                if($tasks){
                    $js->tasks = $tasks;
                } else {
                    $js->tasks = [];
                }

                if($js->id == $deal->journey_stage_id){
                    $js->current_stage = true;
                } else {
                    $js->current_stage = false;
                }
            }
        }
        return $journeyStages;
    }
}