<?php
include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/PipeengagementFactory.php";

class PipeengagementModel extends My_Model
{
    /**
     * @var string
     */
    public $table = 'module_imobles_pipe_engagement';
    public function createPipeengagement($data)
    {
        $crm_goals_category = self::create();
        $crm_goals_category->default=0;
       PipeengagementFactory::create($data, $crm_goals_category,true);
                $crm_goals_category->save();
        return $crm_goals_category;
    }

    public function updatePipeengagement($data, $crm_goals_category)
    {
        ORM::for_table($this->table)->create($crm_goals_category);
       PipeengagementFactory::create($data, $crm_goals_category);
        $crm_goals_category->save();
       return $crm_goals_category;
    }
    
    
    public function deletePipeengagement($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 getAllPipeEngagement(){
        $goalsCategories = ORM::for_table($this->table)
            ->where_null('deleted_at')
            ->order_by_asc('sorder')
            ->find_many();
        return $goalsCategories;
    }
}