@php
    use App\Models\GajiPokok;
    use App\Models\GajiBulanan;
    use App\Models\GajiBulananDetail;
    use App\Models\TunjanganKaryawan;

    $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('bulan_gajian', 2)
        //->whereIn('users.id_users', [21,20,365,308,309,48,362,307,38,233])
        ->groupBy('users.id_users')
        ->orderBy('nama', 'asc')
        ->orderBy('status_gaji', 'asc')
        ->get();

@endphp

<table width="100%" border="1">
    <thead>
        <tr>
            <th rowspan="2">ID</th>
            <th colspan="2">Karyawan</th>
            <th rowspan="2">Bulan/Tahun</th>
            <th colspan="6">Penerimaan</th>
            <th rowspan="2">Total Penerimaan</th>
            <th colspan="3">Pengurangan</th>
            <th rowspan="2">Gaji Bersih</th>

        </tr>
        <tr>
            <th>Nama</th>
            <th>Status</th>
            <th>GAPOK</th>
            <th>Tunjangan</th>
            <th>Lembur</th>
            <th>Absensi</th>
            <th>Ins. Mar.</th>
            <th>Ins. Tiket</th>
            <th>Pokok</th>
            <th>Kasbon</th>
            <th>Total</th>
        </tr>
    </thead>
    @foreach ($gaji as $row)

        @php
            $pending = 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('bulan_gajian', 2)
                ->whereNull('status_gaji')
                ->where('users.id_users', $row->id_users)
                ->first();
        @endphp


        @if (!empty($pending->nama))
            <tr>
                <td>{{ $pending->id_users }}</td>
                <td>{{ $pending->nama }}</td>
                <td>{{ $pending->nama_jabatan }}</td>
                <td>{{ second_numb($pending->bulan_gajian) }}-{{ $pending->tahun_gajian }}</td>
                <td>{{ number($pending->nominal_gaji_pokok) }}</td>
                <td>{{ number($pending->nominal_tunjangan) }}</td>
                <td>{{ number($pending->nominal_lembur) }}</td>
                <td>{{ number($pending->nominal_bonus_absensi) }}</td>
                <td>{{ number($pending->nominal_komisi_marketing) }}</td>
                <td>{{ number($pending->nominal_komisi_teknisi) }}</td>
                <td>{{ rupiah($total_penerimaan = $pending->nominal_gaji_pokok + $pending->nominal_tunjangan + $pending->nominal_lembur + $pending->nominal_bonus_absensi + $pending->nominal_komisi_marketing + $pending->nominal_komisi_teknisi) }}
                </td>
                <td>{{ number($pending->nominal_potongan_bulanan) }}</td>
                <td>{{ number($pending->nominal_potongan_kasbon) }}</td>
                <td>{{ rupiah($total_potongan = $pending->nominal_potongan_bulanan + $pending->nominal_potongan_kasbon) }}
                </td>
                <td>{{ rupiah($pending->nominal_gaji_bersih) }}</td>
            </tr>
        @endif

        @php
            $transferred = 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('bulan_gajian', 2)
                ->where('status_gaji', 'Transferred')
                ->where('users.id_users', $row->id_users)
                ->first();
        @endphp


        @if (!empty($transferred->nama))
            <tr>
                <td>{{ $transferred->id_users }}</td>
                <td>{{ $transferred->nama }}</td>
                <td>{{ $transferred->nama_jabatan }}</td>
                <td>{{ second_numb($transferred->bulan_gajian) }}-{{ $transferred->tahun_gajian }}</td>
                <td>{{ number($transferred->nominal_gaji_pokok) }}</td>
                <td>{{ number($transferred->nominal_tunjangan) }}</td>
                <td>{{ number($transferred->nominal_lembur) }}</td>
                <td>{{ number($transferred->nominal_bonus_absensi) }}</td>
                <td>{{ number($transferred->nominal_komisi_marketing) }}</td>
                <td>{{ number($transferred->nominal_komisi_teknisi) }}</td>
                <td>{{ rupiah($total_penerimaan = $transferred->nominal_gaji_pokok + $transferred->nominal_tunjangan + $transferred->nominal_lembur + $transferred->nominal_bonus_absensi + $transferred->nominal_komisi_marketing + $transferred->nominal_komisi_teknisi) }}
                </td>
                <td>{{ number($transferred->nominal_potongan_bulanan) }}</td>
                <td>{{ number($transferred->nominal_potongan_kasbon) }}</td>
                <td>{{ rupiah($total_potongan = $transferred->nominal_potongan_bulanan + $transferred->nominal_potongan_kasbon) }}
                </td>
                <td>{{ rupiah($transferred->nominal_gaji_bersih) }}</td>
            </tr>
        @endif


        @php
            $total_transfer = $transferred->nominal_gaji_bersih ?? 0;
            $total_pending = $pending->nominal_gaji_bersih ?? 0;
        @endphp

        <tr>
            <td colspan="14" align="right">
                Selisih
            </td>
            <td>{{ rupiah($selisih = $total_pending - $total_transfer)  }}</td>

        </tr>

        <tr>
            <td colspan="14">
                <hr>
            </td>
        </tr>
    @endforeach
</table>