@php $total = 0; $brutoTotal = 0; @endphp @foreach($rows as $row) @php $nilaiPerHari = nilaiPerhari($row->gaji); $totalGaji = ($row->payrollRekap->gaji_pokok ?? 0) + ($row->payrollRekap->uang_makan ?? 0) + ($row->payrollRekap->lembur ?? 0) + ($row->payrollRekap->lembur_libur ?? 0); $totalGaji += ($row->payrollRekap->tunjangan_jabatan ?? 0) + ($row->payrollRekap->bonus ?? 0) + ($row->payrollRekap->bonus_plus ?? 0) + ($row->payrollRekap->bonus_loyalitas ?? 0); $totalGaji += (($row->payrollRekap->tabungan_libur ?? 0) * $nilaiPerHari['gaji_pokok']) + (($row->payrollRekap->tabungan_libur ?? 0) * $nilaiPerHari['uang_makan']) + + (($row->payrollRekap->tabungan_libur ?? 0) * $nilaiPerHari['bonus']); $bruto = (ceil($totalGaji/50000)) * 50000; $brutoTotal += $bruto; $totalGaji = $totalGaji - (($row->payrollRekap->tabungan ?? 0) + ($row->payrollRekap->tabungan_lain ?? 0) + ($row->payrollRekap->kasbon_kue ?? 0) + ($row->payrollRekap->kasbon_bayar ?? 0) ); $totalGaji = (ceil($totalGaji/50000)) * 50000; $total += $totalGaji; @endphp @endforeach

#	NIK	NAMA	JABATAN	DIVISI	CABANG	JUMLAH HARI	GAJI POKOK	UANG MAKAN	LEMBUR	LEMBUR LIBUR	TUNJANGAN JABATAN	BONUS	BONUS PLUS	BONUS LOYALITAS	TABUNGAN LIBUR	TABUNGAN BULAN LALU	TABUNGAN	TABUNGAN LAIN	TABUNGAN DIAMBIL	KASBON BULAN LALU	KASBON BULAN INI	KASBON KUE	ANGSURAN	GAJI BRUTO	TOTAL GAJI
{{ $loop->iteration }}	{{ $row->nik }}	{{ $row->nama }}	{{ @$row->jabatan->nama }}	{{ @$row->divisi->nama }}	{{ @$row->lokasi->nama }}	{{ $row->payrollRekap->jumlah_hari ?? 0 }}	{{ $row->payrollRekap->gaji_pokok ?? 0 }}	{{ $row->payrollRekap->uang_makan ?? 0 }}	{{ $row->payrollRekap->lembur ?? 0 }}	{{ $row->payrollRekap->lembur_libur ?? 0 }}	{{ $row->payrollRekap->tunjangan_jabatan ?? 0 }}	{{ $row->payrollRekap->bonus ?? 0 }}	{{ $row->payrollRekap->bonus_plus ?? 0 }}	{{ $row->payrollRekap->bonus_loyalitas ?? 0 }}	{{ $row->payrollRekap->tabungan_libur ?? 0 }}	{{ ($row->gaji->saldo_awal_tabungan ?? 0 ) + ($row->payrollTabBefore->tabungan_bulan_lalu ?? 0) }}	{{ $row->payrollRekap->tabungan ?? 0 }}	{{ $row->payrollRekap->tabungan_lain ?? 0 }}	{{ $row->payrollRekap->tabungan_ambil ?? 0 }}	{{ $row->payrollKasbonBefore->kasbon_bulan_lalu ?? 0 }}	{{ $row->payrollRekap->kasbon_bulan_ini ?? 0 }}	{{ $row->payrollRekap->kasbon_kue ?? 0 }}	{{ $row->payrollRekap->kasbon_bayar ?? 0 }}	{{ $bruto ?? 0 }}	{{ $totalGaji }}
TOTAL																							{{ $brutoTotal }}	{{ $total }}