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

    $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', 7)
        ->orderBy('nama', 'asc')
        ->orderBy('status_gaji', 'asc')
        ->get();

@endphp
<table width="100%" border="1">
    <thead>
        <tr>
            <th rowspan="2">No</th>
            <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>Jabatan</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>
    <tbody>
        @php
            $grand_total_penerimaan = 0;
            $x = 1;
        @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)
                    ->get();

                $tunjangan_detail = GajiBulananDetail::where('id_jc_gaji_bulanan', $row->id_jc_gaji_bulanan)
                    ->where('kategori_detail_gaji', 'Tunjangan')
                    ->sum('nilai_detail_gaji');

                $get_tunjangan_detail = GajiBulananDetail::where('id_jc_gaji_bulanan', $row->id_jc_gaji_bulanan)
                    ->where('kategori_detail_gaji', 'Tunjangan')
                    ->get();
            @endphp

            <tr>
                <td>{{ $x++ }}</td>
                <td align="center">{{ $row->id_jc_gaji_bulanan }}</td>
                <td>{{ $row->nama }}</td>
                <td>{{ $row->nama_jabatan }}</td>
                <td>{{ second_numb($row->bulan_gajian) }}-{{ $row->tahun_gajian }}</td>
                <td>{{ number($row->nominal_gaji_pokok) }}</td>
                <td>

                    @php
                        $total_tunjangan = 0;
                    @endphp
                    @foreach ($tunjangan as $tjn)
                        {{ $tjn->nama_tunjangan }} : {{ number($tjn->nilai_tunjangan_karyawan) }}<br>

                        @php
                            $cek_gaji_bulanan_detail_tunjangan = GajiBulananDetail::where(
                                'id_jc_gaji_bulanan',
                                $row->id_jc_gaji_bulanan,
                            )
                                ->where('kategori_detail_gaji', 'Tunjangan')
                                ->where('keterangan_detail_gaji', $tjn->nama_tunjangan)
                                ->first();

                            if (empty($cek_gaji_bulanan_detail_tunjangan)) {
                                $store = GajiBulananDetail::create([
                                    'id_jc_gaji_bulanan' => $row->id_jc_gaji_bulanan,
                                    'kategori_detail_gaji' => 'Tunjangan',
                                    'keterangan_detail_gaji' => $tjn->nama_tunjangan,
                                    'nilai_detail_gaji' => $tjn->nilai_tunjangan_karyawan,
                                ]);
                            } else {
                                $cek_gaji_bulanan_detail_tunjangan->update([
                                    'id_jc_gaji_bulanan' => $row->id_jc_gaji_bulanan,
                                    'kategori_detail_gaji' => 'Tunjangan',
                                    'keterangan_detail_gaji' => $tjn->nama_tunjangan,
                                    'nilai_detail_gaji' => $tjn->nilai_tunjangan_karyawan,
                                ]);
                            }
                        @endphp


                        @php
                            $total_tunjangan += $tjn->nilai_tunjangan_karyawan;
                        @endphp
                    @endforeach

                    Total : {{ number($total_tunjangan) }}
                    <br>

                    <!--
                    <span style="color:red;">{{ number($row->nominal_tunjangan) }}</span>

                    <br> {{ number($tunjangan_detail) }}




                    <hr>

                    @foreach ($get_tunjangan_detail as $gtd)
{{ $gtd->id_jc_gaji_bulanan_detail . ' ' . $gtd->keterangan_detail_gaji }} : {{ number($gtd->nilai_detail_gaji) }}<br>
@endforeach
                    -->

                </td>
                <td>
                    @php
                        $bulan_sebelumnya = $row->bulan_gajian - 1;
                        $tgl_mulai_gajian = $row->tahun_gajian . '-' . $bulan_sebelumnya . '-26';
                        $tgl_akhir_gajian = $row->tahun_gajian . '-' . $row->bulan_gajian . '-26';

                        $get_lembur_detail = LemburDetail::where('id_users', $row->id_users)
                            ->whereBetween('jam_mulai_lembur', [$tgl_mulai_gajian, $tgl_akhir_gajian])
                            ->get();
                    @endphp
                    @php
                        $total_lembur = 0;
                    @endphp
                    @foreach ($get_lembur_detail as $gld)
                        {{ tgl_indo($gld->jam_mulai_lembur) . ' ' . $gld->waktu_lembur }} :
                        {{ number($gld->upah_lembur) }}<br>

                        @php
                            $total_lembur += $gld->upah_lembur;
                        @endphp
                    @endforeach
                    Total : {{ number($total_lembur) }} / {{ number($row->nominal_lembur) }} <br>
                    Selisih : {{ number($row->nominal_lembur - $total_lembur) }}
                </td>
                <td>{{ number($row->nominal_bonus_absensi) }}</td>
                <td>{{ number($row->nominal_komisi_marketing) }}</td>
                <td>{{ number($row->nominal_komisi_teknisi) }}</td>
                <td>{{ rupiah($total_penerimaan = $row->nominal_gaji_pokok + $row->nominal_tunjangan + $row->nominal_lembur + $row->nominal_bonus_absensi + $row->nominal_komisi_marketing + $row->nominal_komisi_teknisi) }}
                </td>
                <td>{{ number($row->nominal_potongan_bulanan) }}</td>
                <td>{{ number($row->nominal_potongan_kasbon) }}</td>
                <td>{{ rupiah($total_potongan = $row->nominal_potongan_bulanan + $row->nominal_potongan_kasbon) }}</td>
                <td>{{ rupiah($row->nominal_gaji_bersih) }}</td>

            </tr>
            @php
                $grand_total_penerimaan += $total_penerimaan;
            @endphp
        @endforeach
        <tr>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td><b>{{ number($grand_total_penerimaan) }}</b></td>
        </tr>
    </tbody>
</table>
<hr>