@php use App\Models\GajiPokok; use App\Models\GajiBulanan; use App\Models\GajiBulananDetail; use App\Models\TunjanganKaryawan; $pokok = GajiPokok::orderBy('id_users', 'asc')->get(); @endphp @foreach ($pokok as $var) @php $gaji = GajiBulanan::join('users', 'users.id_users', 'jc_gaji_bulanan.id_users') ->join('jc_jabatan', 'jc_jabatan.id_jc_jabatan', 'users.id_jc_jabatan') ->where('tahun_gajian', 2025) ->where('jc_gaji_bulanan.id_users', $var->id_users) ->get(); @endphp @php $total_gapok = 0; $total_tunjangan = 0; $total_lembur = 0; $total_absensi = 0; $total_ins_mar = 0; $total_ins_tiket = 0; $sub_total_penerimaan = 0; $total_pokok = 0; $total_kasbon = 0; $total_pengurangan = 0; $total_gaji_bersih = 0; @endphp @foreach ($gaji as $row) @php $tunjangan = TunjanganKaryawan::join('jc_jenis_tunjangan','jc_jenis_tunjangan.id_jc_jenis_tunjangan','jc_tunjangan_karyawan.id_jc_jenis_tunjangan')->where('id_users', $row->id_users)->where('jc_tunjangan_karyawan.id_jc_jenis_tunjangan',9)->first(); $get_tunjangan_detail = GajiBulananDetail::where('id_jc_gaji_bulanan', $row->id_jc_gaji_bulanan)->where('kategori_detail_gaji','Tunjangan')->get(); $tunjangan_detail = GajiBulananDetail::where('id_jc_gaji_bulanan', $row->id_jc_gaji_bulanan)->where('kategori_detail_gaji','Tunjangan')->sum('nilai_detail_gaji'); @endphp @php $total_gapok += $row->nominal_gaji_pokok; $total_tunjangan += $row->nominal_tunjangan; $total_lembur += $row->nominal_lembur; $total_absensi += $row->nominal_bonus_absensi; $total_ins_mar += $row->nominal_komisi_marketing; $total_ins_tiket += $row->nominal_komisi_teknisi; $sub_total_penerimaan += $total_penerimaan; $total_pokok += $row->nominal_potongan_bulanan; $total_kasbon += $row->nominal_potongan_kasbon; $total_pengurangan += $total_potongan; $total_gaji_bersih += $row->nominal_gaji_bersih; @endphp @endforeach

Bln/Thn	Karyawan		Penerimaan						Total Penerimaan	Pengurangan		Total Pengurangan	Gaji Bersih
	Nama	Jabatan	GAPOK	Tunjangan	Lembur	Absensi	Ins. Mar.	Ins. Tiket		Pokok	Kasbon
{{ second_numb($row->bulan_gajian) }}-{{ $row->tahun_gajian }}	{{ $row->nama }}	{{ $row->nama_jabatan }}	{{ number($row->nominal_gaji_pokok) }}	@foreach ($get_tunjangan_detail as $gtd) {{ $gtd->keterangan_detail_gaji }} : {{ number($gtd->nilai_detail_gaji) }} @endforeach Total : {{ number($row->nominal_tunjangan) }}	{{ number($row->nominal_lembur) }}	{{ number($row->nominal_bonus_absensi) }}	{{ number($row->nominal_komisi_marketing) }}	{{ number($row->nominal_komisi_teknisi) }}	{{ number($total_penerimaan = $row->nominal_gaji_pokok + $row->nominal_tunjangan + $row->nominal_lembur + $row->nominal_bonus_absensi + $row->nominal_komisi_marketing + $row->nominal_komisi_teknisi) }}	{{ number($row->nominal_potongan_bulanan) }}	{{ number($row->nominal_potongan_kasbon) }}	{{ number($total_potongan = $row->nominal_potongan_bulanan + $row->nominal_potongan_kasbon) }}	{{ number($row->nominal_gaji_bersih) }}
			{{ number($total_gapok) }}	{{ number($total_tunjangan) }}	{{ number($total_lembur) }}	{{ number($total_absensi) }}	{{ number($total_ins_mar) }}	{{ number($total_ins_tiket) }}	{{ number($sub_total_penerimaan) }}	{{ number($total_pokok) }}	{{ number($total_kasbon) }}	{{ number($total_pengurangan) }}	{{ number($total_gaji_bersih) }}

---

@endforeach