<?php
include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/CrmgoalsFactory.php";
include_once __DIR__ . "/../models/CrmgoalscategoryModel.php";
class CrmgoalsModel extends My_Model
{
    /**
     * @var string
     */
    public $table = 'module_imobles_crm_goals';
    public function createCrmgoals($data)
    {
        $crm_goals_category = self::create();
       CrmgoalsFactory::create($data, $crm_goals_category,true);
                $crm_goals_category->save();
        return $crm_goals_category;
    }

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

    public function getClientGoalsByCategory($clientID){

        $crmGoalsCategoryModel = new CrmgoalscategoryModel();

        $goalsCategories = $crmGoalsCategoryModel->getAllGoalsCategories();
        $deal = ORM::for_table('module_imobles_deals')
            ->where('crm_account_id', $clientID)
            ->where_null('deleted_at')
            ->order_by_desc('id')
            ->find_one();
        
        foreach($goalsCategories as $gc){
            if(isset($deal->id)){
                $goals = ORM::for_table($this->table)
                    ->where('crm_accounts_id', $clientID)
                    ->where('deal_id', $deal->id)
                    ->where('module_imobles_crm_goals_category_id', $gc->id)
                    ->where_null('deleted_at')
                    ->order_by_asc('id')
                    ->find_many();
                if($goals){
                    $gc->goals = $goals;
                } else {
                    $gc->goals = [];
                }
            } else {
                $gc->goals = [];
            }
        }

        return $goalsCategories;
    }

}