| {{ $loop->iteration }} |
'{{ $d['nik'] }} |
{{ $d['nama_karyawan'] }} |
{{ $d['nama_jabatan'] }} |
{{ $d['kode_dept'] }} |
{{ $d['kode_cabang'] }} |
{{ formatAngka($d['gaji_pokok']) }} |
@php
$total_tunjangan = 0;
@endphp
@foreach ($jenis_tunjangan as $j)
@php
$total_tunjangan += $d[$j->kode_jenis_tunjangan];
${'total_tunjangan_' . $j->kode_jenis_tunjangan} += $d[$j->kode_jenis_tunjangan];
@endphp
{{ formatAngka($d[$j->kode_jenis_tunjangan]) }} |
@endforeach
@php
$bruto = $d['gaji_pokok'] + $total_tunjangan;
@endphp
{{ formatAngka($bruto) }}
|
{{ $generalsetting->total_jam_bulan }} |
@php
$upah_perjam = $d['gaji_pokok'] / $generalsetting->total_jam_bulan;
@endphp
{{ formatAngka($upah_perjam) }}
|
@php
$total_denda = 0;
$total_potongan_jam = 0;
$total_jam_lembur = 0;
@endphp
@while (strtotime($tanggal_presensi) <= strtotime($periode_sampai))
@php
$denda = 0;
$potongan_jam = 0;
$search = [
'nik' => $d['nik'],
'tanggal' => $tanggal_presensi,
];
$ceklibur = ceklibur($datalibur, $search);
$ceklembur = ceklembur($datalembur, $search);
$lembur = hitungLembur($ceklembur);
if (!empty($ceklembur)) {
$jml_jam_lembur = $lembur;
} else {
$jml_jam_lembur = 0;
}
@endphp
@if (isset($d[$tanggal_presensi]))
@if ($d[$tanggal_presensi]['status'] == 'h')
@php
$bgcolor = '';
$textcolor = '';
$jam_masuk = $tanggal_presensi . ' ' . $d[$tanggal_presensi]['jam_masuk'];
$jam_in = !empty($d[$tanggal_presensi]['jam_in'])
? date('H:i', strtotime($d[$tanggal_presensi]['jam_in']))
: '✘';
$jam_out = !empty($d[$tanggal_presensi]['jam_out'])
? date('H:i', strtotime($d[$tanggal_presensi]['jam_out']))
: '✘';
$color_jam_in = !empty($d[$tanggal_presensi]['jam_in']) ? 'green' : 'red';
$color_jam_out = !empty($d[$tanggal_presensi]['jam_out']) ? 'green' : 'red';
$terlambat = hitungjamterlambat($d[$tanggal_presensi]['jam_in'], $jam_masuk);
$color_terlambat = $terlambat != null ? $terlambat['color'] : '';
if ($terlambat != null) {
if ($terlambat['desimal_terlambat'] < 1) {
$potongan_jam_terlambat = 0;
$denda = hitungdenda($denda_list, $terlambat['menitterlambat']);
} else {
$potongan_jam_terlambat = $terlambat['desimal_terlambat'];
$denda = 0;
}
} else {
$potongan_jam_terlambat = 0;
$denda = 0;
}
$pulangcepat = hitungpulangcepat(
$tanggal_presensi,
$d[$tanggal_presensi]['jam_out'],
$d[$tanggal_presensi]['jam_pulang'],
$d[$tanggal_presensi]['istirahat'],
$d[$tanggal_presensi]['jam_awal_istirahat'],
$d[$tanggal_presensi]['jam_akhir_istirahat'],
$d[$tanggal_presensi]['lintashari'],
);
$color_pulang_cepat = $pulangcepat != null ? 'red' : '';
$potongan_jam = $pulangcepat + $potongan_jam_terlambat;
// $ket =
// $ket_nama_jam_kerja .
// $ket_jadwal_kerja .
// $ket_presensi .
// $ket_terlambat .
// $ket_denda .
// $ket_pulang_cepat .
// $ket_potongan_jam;
@endphp
@elseif($d[$tanggal_presensi]['status'] == 'i')
@php
$bgcolor = '#dea51f';
$textcolor = 'white';
$potongan_jam = $d[$tanggal_presensi]['total_jam'];
@endphp
@elseif($d[$tanggal_presensi]['status'] == 's')
@php
$bgcolor = '#c8075b';
$textcolor = 'white';
@endphp
@elseif($d[$tanggal_presensi]['status'] == 'c')
@php
$bgcolor = '#0164b5';
$textcolor = 'white';
@endphp
@elseif($d[$tanggal_presensi]['status'] == 'a')
@php
$bgcolor = 'red';
$textcolor = 'white';
$potongan_jam = $d[$tanggal_presensi]['total_jam'];
@endphp
@endif
@else
@php
$bgcolor = 'red';
$textcolor = 'white';
$ket = '';
//var_dump($ceklibur);
if (!empty($ceklibur)) {
$bgcolor = 'green';
$textcolor = 'white';
$ket = $ceklibur[0]['keterangan'];
}
@endphp
@endif
@php
$total_denda += $denda;
$total_potongan_jam += $potongan_jam;
$total_jam_lembur += $jml_jam_lembur;
@endphp
{{--
{!! $ket !!}
| --}}
@php
$tanggal_presensi = date('Y-m-d', strtotime('+1 day', strtotime($tanggal_presensi)));
@endphp
@endwhile
@php
$jumlah_potongan_jam = ROUND($upah_perjam) * $total_potongan_jam;
$total_potongan =
ROUND($jumlah_potongan_jam) +
$total_denda +
$d['bpjs_kesehatan'] +
$d['bpjs_tenagakerja'];
$total_all_potongan += $total_potongan;
$upah_lembur = ROUND($upah_perjam) * ROUND($total_jam_lembur, 2);
$total_upah_lembur += $upah_lembur;
$total_gaji_pokok += $d['gaji_pokok'];
$total_bpjs_kesehatan += $d['bpjs_kesehatan'];
$total_bpjs_tenagakerja += $d['bpjs_tenagakerja'];
$total_penambah += $d['penambah'];
$total_pengurang += $d['pengurang'];
$total_bruto += $bruto;
$total_all_denda += $total_denda;
$total_jumlah_potongan_jam += $jumlah_potongan_jam;
$gaji_bersih =
$d['gaji_pokok'] +
$total_tunjangan -
$total_potongan +
$d['penambah'] -
$d['pengurang'] +
$upah_lembur;
$total_gaji_bersih += $gaji_bersih;
@endphp
{{ formatAngka($total_denda) }} |
{{ formatAngkaDesimal($total_potongan_jam) }} |
{{ formatAngka($jumlah_potongan_jam) }}
|
{{ formatAngka($d['bpjs_kesehatan']) }} |
{{ formatAngka($d['bpjs_tenagakerja']) }} |
{{ formatAngka($total_potongan) }} |
{{ formatAngkaDesimal($total_jam_lembur) }} |
{{ formatAngka($upah_lembur) }} |
{{ formatAngka($d['penambah']) }} |
{{ formatAngka($d['pengurang']) }} |
{{ formatAngka($gaji_bersih) }} |
@endforeach