DATA REKAP PAYROLL
Manager Area	: {{ @$rows[0]->lokasi->area->nama }}
Cabang	: {{ @$rows[0]->lokasi->nama }}
Bulan	: {{ request()->tahun.request()->bulan }}

@php $total = 0; $kasbon = 0; $kue = 0; $tabungan = 0; $lain2 = 0; $totalNet = 0; $totalTab = 0; $totalBon = 0; @endphp @foreach($rows as $row) @php if(!$row->payrollRekap){ continue; } $nilaiPerHari = nilaiPerhari($row->gaji); $bruto = $row->payrollRekap->gaji_pokok + $row->payrollRekap->uang_makan + $row->payrollRekap->lembur + $row->payrollRekap->lembur_libur + $row->payrollRekap->bonus + $row->payrollRekap->bonus_plus + $row->payrollRekap->tunjangan_jabatan + $row->payrollRekap->bonus_loyalitas; $bruto += (($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($bruto/50000)) * 50000; $netto = $bruto - ($row->payrollRekap->kasbon_bayar + $row->payrollRekap->tabungan + $row->payrollRekap->kasbon_kue + $row->payrollRekap->tabungan_lain); $saldoTab = (@$row->gaji->saldo_awal_tabungan + @$row->payrollTabBefore->tabungan_bulan_lalu + $row->payrollRekap->tabungan + $row->payrollRekap->tabungan_susulan) - $row->payrollRekap->tabungan_diambil; $sisaBon = (($row->payrollKasbonBefore->kasbon_bulan_lalu ?? 0) + $row->payrollRekap->kasbon ) - $row->payrollRekap->kasbon_bayar; $total += $bruto; $kasbon += $row->payrollRekap->kasbon_bayar; $kue += $row->payrollRekap->kasbon_kue; $tabungan += $row->payrollRekap->tabungan; $lain2 += $row->payrollRekap->tabungan_lain; $totalNet += $netto; $totalTab += $saldoTab; $totalBon += $sisaBon; @endphp @endforeach

#	Nama Karyawan	Jabatan	Divisi	Total gaji Bruto	Potongan Gaji				Total Diterima Netto	Saldo Tabungan	Sisa Pinjaman
					KASBON	BON KUE	NABUNG	LAIN-LAIN
{{ $loop->iteration }}	{{ $row->nama }}	{{ @$row->jabatan->nama }}	{{ @$row->divisi->nama }}	{{ number_format($bruto) }}	{{ number_format($row->payrollRekap->kasbon_bayar) }}	{{ number_format($row->payrollRekap->kasbon_kue) }}	{{ number_format($row->payrollRekap->tabungan) }}	{{ number_format($row->payrollRekap->tabungan_lain) }}	{{ number_format($netto) }}	{{ number_format($saldoTab) }}	{{ number_format($sisaBon) }}
TOTAL				{{ number_format($total) }}	{{ number_format($kasbon) }}	{{ number_format($kue) }}	{{ number_format($tabungan) }}	{{ number_format($lain2) }}	{{ number_format($totalNet) }}	{{ number_format($totalTab) }}	{{ number_format($totalBon) }}

---

Total Gaji		{{ number_format($total) }}
Kasbon	{{ number_format($kasbon) }}
Kasbon	{{ number_format($kue) }}
Tabungan	{{ number_format($tabungan) }}
Lain-lain	{{ number_format($lain2) }}
	Potongan Gaji	{{ number_format(($kasbon + $kue + $tabungan + $lain2)) }}
	Total Diterima	{{ number_format($total - ($kasbon + $kue + $tabungan + $lain2)) }}