public function calculate_quota($user_id, $leave_type_id)
{
$sql = "" . "SELECT SUM(LTDHOUR) AS hour " . "FROM( " . "SELECT LID " . "FROM " . $this->table_leave . " " . "WHERE 1 " . "AND L_UserID = " . $this->db->escape($user_id) . " " . "AND L_LTID = " . $this->db->escape($leave_type_id) . " " . "AND L_StatusID <> '-999' " . ")AS A " . "LEFT JOIN " . $this->table_leavetimedetail . " AS B ON B.LTD_LID = A.LID " . "";
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
$query = $query->row_array();
$all_hour = $query["hour"];
$work_hour = get_work_hour();
$used_day = floor($all_hour / $work_hour);
//หารออกมาแบบไม่เอาเศษ
$used_hour = $all_hour % $work_hour;
//mod
$where = array();
$where["LQ_UserID"] = $user_id;
$where["LQ_LTID"] = $leave_type_id;
$data = array();
$data["LQUsedDay"] = $used_day;
$data["LQUsedHour"] = $used_hour;
$this->db->where($where);
$this->db->update($this->table, $data);
}
}
private function sum_show_leave_time($row_time = array())
{
$returner = '';
$counter = count($row_time);
if ($counter > 0) {
$counter = 0;
foreach ($row_time as $row) {
$counter = (int) $counter + (int) $row['LTDHour'];
}
$work_hour = get_work_hour();
$day = floor($counter / $work_hour);
$hour = $counter % $work_hour;
$returner = $day . ' วัน ' . $hour . ' ชั่วโมง';
}
return $returner;
}
function sum_show_leave_time($row_time = array(), $only_day = FALSE)
{
$returner = '';
$counter = count($row_time);
if ($counter > 0) {
$counter = 0;
foreach ($row_time as $row) {
$counter = (int) $counter + (int) $row['LTDHour'];
}
$work_hour = get_work_hour();
$day = floor($counter / $work_hour);
$hour = $counter % $work_hour;
if ($only_day === TRUE) {
$returner = $day;
} else {
if ($hour > 0) {
$returner = $day . ' วัน ' . $hour . ' ชั่วโมง';
} else {
$returner = $day . ' วัน';
}
}
}
return $returner;
}
