/*=======================API HUMAN RESOURCE=================================*/
    public function select_timekeeping_of_day($branchid, $day, $monthid, $userid)
    {
        $query = "SELECT ca.number_hours, user.name, ca.number_day,ca.description,	
				(SELECT v.number_hours
				FROM ca V where ca.ca_rel_id = v.id ) as 'number_hours_ca'
				,
				(SELECT 
					IF(c.branchid!=0,
						(SELECT CONCAT(C.symbol,'.',m.branch_id)
						FROM branch m
						WHERE m.id =c.branchid),
						c.symbol						
					)
					FROM ca c where ca.ca_rel_id = c.id ) as 'symbol'
			FROM `ca` 
			INNER JOIN user on user.id = ca.userid
			INNER JOIN branch_user_rel on user.id = branch_user_rel.userid
			WHERE ca.ca_type='timekeeping' and ca.monthid = $monthid and ca.userid= $userid  and ca.number_day = $day";
        if ($branchid != 0)
        {
            $query = $query . " and branch_user_rel.branchid=$branchid";
        }
        $result = $this->db->query($query)->result_array();
        return $result;
    }

    public function select_timekeeping_of_week($branchid, $start_date, $end_date, $monthid, $userid)
    {
        $query = "SELECT ca.number_hours, user.name, ca.number_day,ca.description,	
				(SELECT v.number_hours
				FROM ca V where ca.ca_rel_id = v.id ) as 'number_hours_ca'
				,
				(SELECT 
					IF(c.branchid!=0,
						(SELECT CONCAT(C.symbol,'.',m.branch_id)
						FROM branch m
						WHERE m.id =c.branchid),
						c.symbol						
					)
					FROM ca c where ca.ca_rel_id = c.id ) as 'symbol'
			FROM `ca` 
			INNER JOIN user on user.id = ca.userid
			INNER JOIN branch_user_rel on user.id = branch_user_rel.userid
			WHERE ca.ca_type='timekeeping' and ca.monthid = $monthid and ca.userid= $userid  and ca.number_day >= $start_date and ca.number_day <= $end_date";
        if ($branchid != 0)
        {
            $query = $query . " and branch_user_rel.branchid=$branchid";
        }
        $result = $this->db->query($query)->result_array();
        return $result;
    }
    
    public function select_timekeeping_of_month($branchid, $monthid, $userid)
    {
        $query = "SELECT ca.number_hours, user.name, ca.number_day,ca.description,	
				(SELECT v.number_hours
				FROM ca V where ca.ca_rel_id = v.id ) as 'number_hours_ca'
				,
				(SELECT 
					IF(c.branchid!=0,
						(SELECT CONCAT(C.symbol,'.',m.branch_id)
						FROM branch m
						WHERE m.id =c.branchid),
						c.symbol						
					)
					FROM ca c where ca.ca_rel_id = c.id ) as 'symbol'
			FROM `ca` 
			INNER JOIN user on user.id = ca.userid
			INNER JOIN branch_user_rel on user.id = branch_user_rel.userid
			WHERE ca.ca_type='timekeeping' and ca.monthid = $monthid and ca.userid= $userid";
        if ($branchid != 0)
        {
            $query = $query . " and branch_user_rel.branchid=$branchid";
        }
        $result = $this->db->query($query)->result_array();
        return $result;
    }