Employees_model->set_employee_allowances($user_id); ?>
Employees_model->set_employee_commissions($user_id); ?>
Employees_model->set_employee_deductions($user_id); ?>
Employees_model->set_employee_statutory_deductions($user_id); ?>
Employees_model->set_employee_other_payments($user_id); ?>
Payroll_model->total_leave_day($user_id, $pay_date); ?>
Employees_model->set_employee_overtime($user_id); ?>
Payroll_model->total_late_worked($euser_id, $pay_date);
if ($late_countWorked->num_rows() > 0) {
foreach ($late_countWorked->result() as $result_late) {
$get_day = strtotime($result_late->clock_in);
$day = date('l', $get_day);
// office shift
$office_shift = $this->Timesheet_model->read_office_shift_information($office_shift_id);
$in_time = '00:00:00'; // Default in_time
if (!is_null($office_shift)) {
switch ($day) {
case 'Monday':
$in_time = $office_shift[0]->monday_in_time ?? $in_time;
break;
case 'Tuesday':
$in_time = $office_shift[0]->tuesday_in_time ?? $in_time;
break;
case 'Wednesday':
$in_time = $office_shift[0]->wednesday_in_time ?? $in_time;
break;
case 'Thursday':
$in_time = $office_shift[0]->thursday_in_time ?? $in_time;
break;
case 'Friday':
$in_time = $office_shift[0]->friday_in_time ?? $in_time;
break;
case 'Saturday':
$in_time = $office_shift[0]->saturday_in_time ?? $in_time;
break;
case 'Sunday':
$in_time = $office_shift[0]->sunday_in_time ?? $in_time;
break;
default:
// Handle default case if needed
break;
}
}
// Contoh data Telat
$clock_in_employee = new DateTime($result_late->clock_in); // Waktu masuk employee
$clock_in_real = new DateTime($clock_in_employee->format('Y-m-d') . $in_time); // Waktu masuk real
// Menghitung selisih waktu telat hanya jika $clock_in_employee lebih lambat dari $clock_in_real
if ($clock_in_employee > $clock_in_real) {
$interval_late = $clock_in_employee->diff($clock_in_real);
$hours_r_late = $interval_late->format('%h');
$minutes_r_late = $interval_late->format('%i');
// Mengonversi selisih waktu ke format detik
$total_time_late = $hours_r_late . ":" . $minutes_r_late . ":00";
$str_time_late = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", $total_time_late);
sscanf($str_time_late, "%d:%d:%d", $hours_late, $minutes_late, $seconds_late);
$hrs_old_seconds_late = $hours_late * 3600 + $minutes_late * 60 + $seconds_late;
$hrs_old_int1_late = round($hrs_old_seconds_late / 60); // Perhatikan penggunaan round untuk pembulatan
// Ambil potongan dari database berdasarkan jumlah menit telat
$late_countWork = $this->Payroll_model->total_late_amount($euser_id, $hrs_old_int1_late);
if ($late_countWork) {
$potongan = $late_countWork->late_amount;
} else {
$potongan = 0; // Atur potongan default jika tidak ada data potongan yang cocok
}
// Akumulasikan potongan ke totalpotongan
$totalpotongan += $potongan;
}
}
} else {
$totalpotongan = 0;
}
?>
0) : ?>