<?php

include_once __DIR__ . "/../../../autoload/My_Model.php";
include_once __DIR__ . "/../factories/RegisterFactory.php";

class RegisterModel extends My_Model
{
    /**
     * @var string
     */
    public $table = 'module_teammanagement_register';
    public function createRegister($data)
    {
        $category = self::create();
        RegisterFactory::create($data, $category,true);
                $category->save();
        return $category;
    }

    public function updateRegister($data, $category)
    {
        ORM::for_table($this->table)->create($category);
        RegisterFactory::create($data, $category);
        $category->save();
        return $category;
    }
    
    
    public function deleteRegister($category)
    {
        ORM::for_table($this->table)->create($category);
        $category->delete();
        return $category;
    }
     
  
    public function getRegisterForDataUser($id_user,$date)
      {
        $registers= ORM::for_table($this->table)
              ->where("id_user",$id_user)
              ->where("date", $date)->find_many();
        return $registers;
      
      }
    public function getOneWithNames($id)
      {
        $registers= ORM::for_table($this->table)
              ->raw_query(" SELECT m.*,s.account,s2.account as account_branch FROM module_teammanagement_register m "
                      . "JOIN crm_accounts s ON(s.id=m.id_user) "//pega o nome do funcionário
                      . "LEFT JOIN crm_accounts s2 ON(s2.id=m.crm_accounts_id) " //pega o nome da filial
                      . "WHERE m.id=".$id)
        ->find_many();
        return count($registers)>0?$registers[0]:false;
      
      }
    public function getOneByDateParameter($id_user,$date,$parameter)
    {
        $registers= ORM::for_table($this->table)
              ->where("id_user",$id_user)
              ->where("date", $date)
               ->where("parameter",$parameter) 
                ->find_many();
        return count($registers)>0?$registers[0]:false;
    }  
      
}