@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@push('css')
    <style>
        .detail-table th,
        .detail-table td {
            padding-left: 16px !important;
            vertical-align: middle;
            font-size: 0.8rem;
        }
    </style>
@endpush
@section('content')
@include('layouts.navbars.auth.topnav', ['title' => ''])
<div class="container-fluid py-4">
    <div class="row">
        <div class="col-12">
            <div class="card mb-4">
                <div class="card-header pb-0 d-flex justify-content-between align-items-center">
                    <div>
                        <button type="button" class="btn btn-danger" onclick="window.close()">
                                <i class="fas fa-times me-2"></i>Tutup
                        </button>
                        <button type="button" class="btn btn-info" id="btnSavePph">
                                <i class="fas fa-save me-2"></i>Save PPh
                        </button>
                        <form id="exportExcelForm" method="POST" action="{{ route('rptkpj.export') }}"
                                style="display:inline;">
                                @csrf
                                <input type="hidden" name="project_id" value="{{ $project->id }}">
                                <input type="hidden" name="start_date" value="{{ request('start_date') }}">
                                <input type="hidden" name="end_date" value="{{ request('end_date') }}">
                                <button type="submit" class="btn btn-success">
                                    <i class="fas fa-file-excel me-2"></i>Export Excel
                                </button>
                        </form>
                        

                    </div>
                </div>
                <div class="card-body">
                    <!-- Header Report -->
                    <div class="text-center mb-4">
                        <h3 class="mb-3"><strong>KARTU PROYEK</strong></h3>
                    </div>

                    <!-- Identitas Proyek -->
                    <div class="row mb-4">
                        <div class="col-md-6">
                            <table class="table-sm" style="width: 100%">
                                <tr>
                                    <td style="width: 150px"><strong>NAMA PROYEK</strong></td>
                                    <td style="width: 20px">:</td>
                                    <td>{{ $project->proyek ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>LOKASI</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->lokasi ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>PEKERJAAN</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->pekerjaan ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>PEMILIK</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->pemilik ?? '-' }}</td>
                                </tr>
                            </table>
                        </div>
                        <div class="col-md-6">
                            <table class="table-sm" style="width: 100%">
                                <tr>
                                    <td style="width: 150px"><strong>No. SPK</strong></td>
                                    <td style="width: 20px">:</td>
                                    <td>{{ $project->no_spk ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>Sales</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->sales ?? '-' }}</td>
                                </tr>
                            </table>
                        </div>
                    </div>

                    <!-- Tabel Biaya Proyek -->
                    <div class="table-responsive mb-4">
                        <h6 class="mb-2"><strong>BIAYA PROYEK</strong></h6>
                        <table class="table table-hover align-items-center mb-0">
                            <thead class="thead-light">
                                <tr>
                                    <th class="text-center" style="width: 40px;">#</th>
                                    <th class="text-center">Tanggal</th>
                                    <th class="text-center">No. Bukti</th>
                                    <th class="text-center">Uraian</th>
                                    <th class="text-center">Kategori</th>
                                    <th class="text-center">Detail Kategori</th>
                                    @foreach($dynamic_categories as $category)
                                    <th class="text-center">{{ strtoupper($category->kategori) }} (Rp)</th>
                                    @endforeach
                                    <th class="text-center">Jumlah (Rp)</th>
                                    <th class="text-center">Potongan PPh</th>
                                    <th class="text-center">Total Dibayar</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                $total_amount = 0;
                                $total_pph = 0;
                                $total_paid = 0;
                                $category_totals = [];
                                foreach($dynamic_categories as $cat) {
                                $category_totals[$cat->id] = 0;
                                }
                                @endphp

                                @forelse($expenses as $idx => $expense)
                                @php
                                $total_amount += $expense->amount;
                                $pph = $expense->pph ?? 0;
                                $total_pph += $pph;
                                $paid = $expense->amount - $pph;
                                $total_paid += $paid;

                                // Hitung total per kategori dari map
                                $exp_cat_row = $expense_category_amounts[$expense->id] ?? [];
                                foreach($exp_cat_row as $catId => $catAmt) {
                                if(isset($category_totals[$catId])) {
                                $category_totals[$catId] += $catAmt;
                                }
                                }
                                @endphp
                                <tr class="main-row" style="cursor: pointer;" data-expand-id="exp-{{ $expense->id }}">
                                    <td class="text-sm font-weight-normal text-center">
                                        <i class="fas fa-chevron-right expand-icon" style="transition: transform 0.2s;"></i>
                                    </td>
                                    <td class="text-sm font-weight-normal text-center">{{ \Carbon\Carbon::parse($expense->date)->format('j-M-Y h:i A')}}</td >
                                    <td class="text-sm font-weight-normal {{ trim(($expense->kode_mutasi ?? '') . ' ' . ($expense->nomor_bukti ?? '')) ? 'text-start' : 'text-center' }}">{{ trim(($expense->kode_mutasi ?? '') . ' ' . ($expense->nomor_bukti ?? '')) ?: '-' }}</td>
                                    <td class="text-sm font-weight-normal {{ !empty($expense->keterangan) ? 'text-start' : 'text-center' }}">{{ !empty($expense->keterangan) ? $expense->keterangan : '-' }}</td>
                                    @php
                                        $grouped = [];

                                        foreach ($expense_breakdown[$expense->id] ?? [] as $item) {
                                            $grouped[$item->kategori][] = $item->detail_kategori;
                                        }
                                    @endphp
                                    <td class="text-sm font-weight-normal">
                                        @foreach($grouped as $kategori => $details)
                                            {{ $kategori }}@unless($loop->last)<br>@endunless
                                        @endforeach
                                    <td class="text-sm font-weight-normal">
                                        @foreach($grouped as $kategori => $details)
                                            {{ implode(', ', $details) }}@unless($loop->last)<br>@endunless
                                        @endforeach
                                    </td>
                                    @foreach($dynamic_categories as $category)
                                    @php $cat_amt = $expense_category_amounts[$expense->id][$category->id] ?? null;
                                    @endphp
                                    <td class="text-sm font-weight-normal {{ $cat_amt !== null  ? 'text-end' : 'text-center' }}">
                                        @if($cat_amt !== null)
                                        {{ number_format($cat_amt, 0, ',', '.') }}
                                        @else
                                        -
                                        @endif
                                    </td>
                                    @endforeach
                                    <td class="text-sm font-weight-normal text-end">{{ number_format($expense->amount, 0, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">
                                        <input type="text"
                                            class="form-control form-control-sm text-end pph-input"
                                            data-id="{{ $expense->id }}"
                                            value="{{ number_format($pph, 2, ',', '.') }}"
                                            style="width:120px;display:inline-block;">
                                    </td>
                                    <td class="text-xs font-weight-normal text-end total-dibayar" data-amount="{{ $expense->amount }}">
                                        {{ number_format($paid, 0, ',', '.') }}
                                    </td>
                                </tr>
                                <tr class="detail-row" id="detail-exp-{{ $expense->id }}" style="display: none;">
                                    <td colspan="{{ 11 + count($dynamic_categories) }}">
                                        <div class="p-3 border-top">
                                            <h6 class="mb-3" style="font-size: 0.8rem !important;">
                                                <i class="fas fa-list-ul me-2"></i>
                                                Detail Transaksi per Detail Kategori
                                            </h6>
                                            <table class="table table-sm table-bordered mb-0 detail-table">
                                                <thead class="thead-light" style="font-size: 0.8rem;">
                                                    <tr>
                                                        <th class="text-center" style="width: 50px;">No</th>
                                                        <th class="text-center">Kategori</th>
                                                        <th class="text-center">Detail Kategori</th>
                                                        <th class="text-center">Jenis</th>
                                                        <th class="text-center">Tipe</th>
                                                        <th class="text-center">Gross Amount</th>
                                                        <th class="text-center">Diskon</th>
                                                        <th class="text-center">Pot. Bon</th>
                                                        <th class="text-center">Net Amount</th>
                                                        <th class="text-center">PPN</th>
                                                        <th class="text-center">Jumlah (Net Amount + PPN)</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                        $bk = $expense_breakdown[$expense->id] ?? [];
                                                    @endphp
                                                    @forelse($bk as $b)
                                                    <tr style="font-size: 0.8rem;">
                                                        <td class="text-center">{{ $loop->iteration }}</td>
                                                        <td class="{{ $b->kategori ? 'text-start' : 'text-center' }}">{{ $b->kategori ?? '-' }}</td>
                                                        <td class="{{ $b->detail_kategori ? 'text-start' : 'text-center' }}">{{ $b->detail_kategori ?? '-' }}</td>
                                                        <td class="text-center">
                                                            <span class="badge {{ $b->jenis == 'PO' ? 'bg-primary' : 'bg-secondary' }}">
                                                                {{ $b->jenis }}
                                                            </span>
                                                        </td>
                                                        <td class="{{ $b->tipe ? 'text-start' : 'text-center' }}">
                                                            {{
                                                                [
                                                                    'lain-lain' => 'Lain-Lain',
                                                                    'material' => 'Material',
                                                                    'akomodasi' => 'Akomodasi',
                                                                    'upah' => 'Upah',
                                                                 ][$b->tipe] ?? '-'
                                                            }}
                                                        </td>
                                                        <td class="text-end">{{ number_format($b->gross_amount_rupiah ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->diskon ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->potongan_bon ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->amount ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->ppn ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format(($b->amount ?? 0) + ($b->ppn ?? 0), 0, ',', '.') }}</td>
                                                    </tr>
                                                    @empty
                                                    <tr>
                                                        <td colspan="11" class="text-center text-muted">Tidak ada detail</td>
                                                    </tr>
                                                    @endforelse
                                                </tbody>
                                                <tfoot>
                                                    @if(!empty($expense_breakdown_totals[$expense->id]))
                                                        @foreach($expense_breakdown_totals[$expense->id] as $tipe => $total)
                                                        <tr class="bg-light" style="font-size: 0.8rem;">
                                                            <td colspan="10" class="text-end"><strong>
                                                                Total {{
                                                                    [
                                                                        'lain-lain' => 'Lain-Lain',
                                                                        'material' => 'Material',
                                                                        'akomodasi' => 'Akomodasi',
                                                                        'upah' => 'Upah',
                                                                    ][$tipe] ?? ucfirst($tipe)
                                                                }}
                                                            </strong></td>
                                                            <td class="text-end"><strong>{{ number_format($total['jumlah'], 0, ',', '.') }}</strong></td>
                                                        </tr>
                                                        @endforeach
                                                    @endif
                                                </tfoot>
                                            </table>
                                        </div>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="{{ 7 + count($dynamic_categories) }}" class="text-center">Tidak ada data biaya</td>
                                </tr>
                                @endforelse

                                @if(count($expenses) > 0)
                                <tr class="bg-light" style="font-size: 0.9rem;">
                                    <td colspan="6" class="text-end"><strong>TOTAL BIAYA</strong></td>
                                    @foreach($dynamic_categories as $category)
                                    <td class="text-end"><strong>{{ number_format($category_totals[$category->id] ?? 0,
                                            0, ',', '.') }}</strong></td>
                                    @endforeach
                                    <td class="text-end"><strong>{{ number_format($total_amount, 0, ',', '.')
                                            }}</strong></td>
                                    <td class="text-end" id="totalPph"><strong>{{ number_format($total_pph, 0, ',', '.')
                                            }}</strong></td>
                                    <td class="text-end" id="totalDibayar"><strong>{{ number_format($total_paid, 0, ',',
                                            '.') }}</strong>
                                    </td>
                                </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>

                    <!-- Tabel Penerimaan Pembayaran -->
                    <div class="table-responsive mb-4">
                        <h6 class="mb-2"><strong>PENERIMAAN PEMBAYARAN</strong></h6>
                        <table class="table table-hover align-items-center mb-0">
                            <thead class="thead-light">
                                <tr>
                                    <th class="text-center" style="width: 40px;">#</th>
                                    <th class="text-center">Tanggal</th>
                                    <th class="text-center">No. Bukti</th>
                                    <th class="text-center">Uraian</th>
                                    <th class="text-center">Kategori</th>
                                    <th class="text-center">Detail Kategori</th>
                                    @foreach($dynamic_categories as $category)
                                    <th class="text-center">{{ strtoupper($category->kategori) }} (Rp)</th>
                                    @endforeach
                                    <th class="text-center">Jumlah (Rp)</th>
                                    <th class="text-center">Potongan PPh</th>
                                    <th class="text-center">Total Dibayar</th>
                                </tr>
                            </thead>
                            <tbody >
                                @php
                                $total_income = 0;
                                $total_income_pph = 0;
                                $total_income_paid = 0;
                                $income_category_totals = [];
                                foreach($dynamic_categories as $cat) {
                                $income_category_totals[$cat->id] = 0;
                                }
                                @endphp

                                @forelse($incomes as $idx => $income)
                                @php
                                $total_income += $income->amount;
                                $income_pph = $income->pph ?? 0;
                                $total_income_pph += $income_pph;
                                $income_paid = $income->amount - $income_pph;
                                $total_income_paid += $income_paid;

                                // Hitung total per kategori dari map
                                $inc_cat_row = $income_category_amounts[$income->id] ?? [];
                                foreach($inc_cat_row as $catId => $catAmt) {
                                if(isset($income_category_totals[$catId])) {
                                $income_category_totals[$catId] += $catAmt;
                                }
                                }
                                @endphp
                                <tr class="main-row" style="cursor: pointer;" data-expand-id="inc-{{ $income->id }}">
                                    <td class="text-sm font-weight-normal text-center">
                                        <i class="fas fa-chevron-right expand-icon" style="transition: transform 0.2s;"></i>
                                    </td>
                                    <td class="text-sm font-weight-normal text-center">{{ \Carbon\Carbon::parse($income->date)->format('j-M-Y h:i A') }}
                                    </td>
                                    <td class="text-sm font-weight-normal {{ trim(($income->kode_mutasi ?? '') . ' ' . ($income->nomor_bukti ?? '')) ? 'text-start' : 'text-center' }}">{{ trim(($income->kode_mutasi ?? '') . ' ' . ($income->nomor_bukti ?? '')) ?: '-' }}</td>
                                    <td class="text-sm font-weight-normal {{ !empty($income->keterangan) ? 'text-start' : 'text-center' }}">{{ !empty($income->keterangan) ? $income->keterangan : '-' }}</td>
                                    @php
                                        $grouped = [];

                                        foreach ($income_breakdown[$income->id] ?? [] as $item) {
                                            $grouped[$item->kategori][] = $item->detail_kategori;
                                        }
                                    @endphp
                                    <td class="text-sm font-weight-normal">
                                        @foreach($grouped as $kategori => $details)
                                            {{ $kategori }}@unless($loop->last)<br>@endunless
                                        @endforeach
                                    </td>
                                    <td class="text-sm font-weight-normal">
                                        @foreach($grouped as $kategori => $details)
                                            {{ implode(', ', $details) }}@unless($loop->last)<br>@endunless
                                        @endforeach
                                    </td>

                                    @foreach($dynamic_categories as $category)
                                    @php $inc_cat_amt = $income_category_amounts[$income->id][$category->id] ?? null;
                                    @endphp
                                    <td class="text-sm font-weight-normal {{ $inc_cat_amt !== null  ? 'text-end' : 'text-center' }}">
                                        @if($inc_cat_amt !== null)
                                        {{ number_format($inc_cat_amt, 0, ',', '.') }}
                                        @else
                                        -
                                        @endif
                                    </td>
                                    @endforeach
                                    <td class="text-sm font-weight-normal text-end">{{ number_format($income->amount, 0, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">
                                        <input type="text"
                                        class="form-control form-control-sm text-end pph-input-income"
                                        data-id="{{ $income->id }}"
                                        value="{{ number_format($income_pph, 2, ',', '.') }}"
                                        style="width:120px;display:inline-block;">
                                    </td>
                                    <td class="text-sm  font-weight-normal text-end total-dibayar-income" data-amount="{{ $income->amount }}">
                                        {{ number_format($income_paid, 0, ',', '.') }}
                                    </td>
                                </tr>
                                <tr class="detail-row" id="detail-inc-{{ $income->id }}" style="display: none;">
                                    <td colspan="{{ 11 + count($dynamic_categories) }}">
                                        <div class="p-3 border-top">
                                            <h6 class="mb-3" style="font-size:0.8rem !important;">
                                                <i class="fas fa-list-ul me-2"></i>
                                                Detail Transaksi per Detail Kategori
                                            </h6>
                                            <table class="table table-sm table-bordered mb-0">
                                                <thead class="thead-light" style="font-size: 0.8rem;">
                                                    <tr >
                                                        <th class="text-center" style="width: 50px;">No</th>
                                                        <th class="text-center">Kategori</th>
                                                        <th class="text-center">Detail Kategori</th>
                                                        <th class="text-center">Jenis</th>
                                                        <th class="text-center">Tipe</th>
                                                        <th class="text-center">Gross Amount</th>
                                                        <th class="text-center">Diskon</th>
                                                        <th class="text-center">Pot. Bon</th>
                                                        <th class="text-center">Net Amount</th>
                                                        <th class="text-center">PPN</th>
                                                        <th class="text-center">Jumlah (Net Amount + PPN)</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                        $bk = $income_breakdown[$income->id] ?? [];
                                                    @endphp
                                                    @forelse($bk as $b)
                                                    <tr style="font-size: 0.8rem;">
                                                        <td class="text-center">{{ $loop->iteration }}</td>
                                                        <td class="{{ $b->kategori ? 'text-start' : 'text-center' }}">{{ $b->kategori ?? '-' }}</td>
                                                        <td class="{{ $b->detail_kategori ? 'text-start' : 'text-center' }}">{{ $b->detail_kategori ?? '-' }}</td>
                                                        <td class="text-center">
                                                            <span class="badge {{ $b->jenis == 'PO' ? 'bg-primary' : 'bg-secondary' }}">
                                                                {{ $b->jenis }}
                                                            </span>
                                                        </td>
                                                        <td class="{{ $b->tipe ? 'text-start' : 'text-center' }}">
                                                            {{
                                                                [
                                                                    'lain-lain' => 'Lain-Lain',
                                                                    'material' => 'Material',
                                                                    'akomodasi' => 'Akomodasi',
                                                                    'upah' => 'Upah',
                                                                ][$b->tipe] ?? '-'
                                                            }}
                                                        </td>
                                                        <td class="text-end">{{ number_format($b->gross_amount_rupiah ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->diskon ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->potongan_bon ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->amount ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format($b->ppn ?? 0, 0, ',', '.') }}</td>
                                                        <td class="text-end">{{ number_format(($b->amount ?? 0) + ($b->ppn ?? 0), 0, ',', '.') }}</td>
                                                    </tr>
                                                    @empty
                                                    <tr>
                                                        <td colspan="11" class="text-center text-muted">Tidak ada detail</td>
                                                    </tr>
                                                    @endforelse
                                                </tbody>
                                                <tfoot>
                                                    @if(!empty($income_breakdown_totals[$income->id]))
                                                        @foreach($income_breakdown_totals[$income->id] as $tipe => $total)
                                                        <tr class="bg-light" style="font-size: 0.8rem;">
                                                            <td colspan="10" class="text-end"><strong>
                                                                Total {{
                                                                    [
                                                                        'lain-lain' => 'Lain-Lain',
                                                                        'material' => 'Material',
                                                                        'akomodasi' => 'Akomodasi',
                                                                        'upah' => 'Upah',
                                                                    ][$tipe] ?? ucfirst($tipe)
                                                                }}
                                                            </strong></td>
                                                            <td class="text-end"><strong>{{ number_format($total['jumlah'], 0, ',', '.') }}</strong></td>
                                                        </tr>
                                                        @endforeach
                                                    @endif
                                                </tfoot>
                                            </table>
                                        </div>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="{{ 7 + count($dynamic_categories) }}" class="text-center">Tidak ada
                                        data penerimaan</td>
                                </tr>
                                @endforelse

                                @if(count($incomes) > 0)
                                <tr class="bg-light" style="font-size: 0.9rem;">
                                    <td colspan="6" class="text-end"><strong>TOTAL PEMBAYARAN</strong></td>
                                    @foreach($dynamic_categories as $category)
                                    <td class="text-end"><strong>{{ number_format($income_category_totals[$category->id]
                                            ?? 0, 0, ',', '.') }}</strong></td>
                                    @endforeach
                                    <td class="text-end"><strong>{{ number_format($total_income, 0, ',', '.')
                                            }}</strong></td>
                                    <td class="text-end" id="totalIncomePph"><strong>{{ number_format($total_income_pph,
                                            0, ',', '.') }}</strong></td>
                                    <td class="text-end" id="totalIncomeDibayar"><strong>{{
                                            number_format($total_income_paid, 0, ',', '.') }}</strong></td>
                                </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>

                    <!-- Rekap Final -->
                    <div class="row">
                        <div class="col-md-6 offset-md-6">
                            <table class="table table-sm table-bordered" style="font-size: 16px;">
                                <tr>
                                    <td><strong>JUMLAH BIAYA PROYEK</strong></td>
                                    <td class="text-end">{{ number_format($total_paid, 0, ',', '.') }}</td>
                                </tr>
                                <tr>
                                    <td><strong>TOTAL PEMBAYARAN</strong></td>
                                    <td class="text-end">{{ number_format($total_income_paid, 0, ',', '.') }}</td>
                                </tr>
                                <tr class="bg-light">
                                    <td><strong>KURANG / LEBIH BAYAR</strong></td>
                                    <td class="text-end">
                                        <strong>{{ number_format($total_income_paid - $total_paid, 0, ',', '.')
                                            }}</strong>
                                    </td>
                                </tr>
                            </table>
                        </div>
                    </div>

                    
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@push('js')
<script>
$(document).ready(function() {
    // Accordion: close all other details when opening one
    $('.main-row').click(function(e) {
        // Don't toggle if clicking on PPh input
        if ($(e.target).hasClass('pph-input') || $(e.target).hasClass('pph-input-income')) {
            return;
        }
        const expandId = $(this).data('expand-id');
        const detailRow = $('#detail-' + expandId);
        const icon = $(this).find('.expand-icon');
        
        // Close all other detail rows
        $('.detail-row').each(function() {
            if (this.id !== 'detail-' + expandId) {
                $(this).hide();
                $(this).prev('.main-row').find('.expand-icon')
                    .removeClass('fa-chevron-down').addClass('fa-chevron-right');
            }
        });
        
        // Toggle current
        if (detailRow.is(':visible')) {
            detailRow.hide();
            icon.removeClass('fa-chevron-down').addClass('fa-chevron-right');
        } else {
            detailRow.show();
            icon.removeClass('fa-chevron-right').addClass('fa-chevron-down');
        }
    });

    // Update total dibayar saat PPh diubah (Biaya Proyek)
    $('.pph-input').on('input', function() {
        var row = $(this).closest('tr');
        var amount = parseFloat(row.find('.total-dibayar').data('amount'));
        var pph = rupiahToNumber($(this).val());
        var totalDibayar = amount - pph;
        
        // Update tampilan baris
        row.find('.total-dibayar').text(totalDibayar.toLocaleString('id-ID'));
        
        // Highlight input yang diubah
        $(this).addClass('border-warning');
        
        // Update total keseluruhan
        updateTotals();
    });

    $(document).on('input', '.pph-input, .pph-input-income', function(){
        this.value = formatRupiah(this.value);
    });
    
    // Update total dibayar saat PPh diubah (Penerimaan Pembayaran)
    $('.pph-input-income').on('input', function() {
        var row = $(this).closest('tr');
        var amount = parseFloat(row.find('.total-dibayar-income').data('amount'));
        var pph = rupiahToNumber($(this).val());
        var totalDibayar = amount - pph;
        
        // Update tampilan baris
        row.find('.total-dibayar-income').text(totalDibayar.toLocaleString('id-ID'));
        
        // Highlight input yang diubah
        $(this).addClass('border-warning');
        
        // Update total keseluruhan
        updateTotals();
    });

    function formatRupiah(value) {
        value = value.replace(/[^\d,]/g, '');
        let split = value.split(',');
        let angka = split[0];
        let sisa = angka.length % 3;
        let rupiah = angka.substr(0, sisa);
        let ribuan = angka.substr(sisa).match(/\d{3}/g);
        if (ribuan) {
            let separator = sisa ? '.' : '';
            rupiah += separator + ribuan.join('.');
        }
        if (split.length > 1) {
            rupiah += ',' + split[1].substring(0,2);
        }
        return rupiah;
    }

    function rupiahToNumber(value) {
        if (!value) return 0;
        return Number(value.replace(/\./g, '').replace(',', '.')) || 0;
    }

    function updateTotals() {
        var totalPph = 0;
        var totalDibayar = 0;
        
        $('.pph-input').each(function() {
            var row = $(this).closest('tr');
            var amount = parseFloat(row.find('.total-dibayar').data('amount'));
            var pph = rupiahToNumber($(this).val());
            totalPph += pph;
            totalDibayar += (amount - pph);
        });
        
        $('#totalPph strong').text(totalPph.toLocaleString('id-ID'));
        $('#totalDibayar strong').text(totalDibayar.toLocaleString('id-ID'));
        
        var totalIncomePph = 0;
        var totalIncomeDibayar = 0;
        
        $('.pph-input-income').each(function() {
            var row = $(this).closest('tr');
            var amount = parseFloat(row.find('.total-dibayar-income').data('amount'));
            var pph = rupiahToNumber($(this).val());
            totalIncomePph += pph;
            totalIncomeDibayar += (amount - pph);
        });
        
        $('#totalIncomePph strong').text(totalIncomePph.toLocaleString('id-ID'));
        $('#totalIncomeDibayar strong').text(totalIncomeDibayar.toLocaleString('id-ID'));
    }

    // Save PPh
    $('#btnSavePph').click(function() {
        var pphData = [];
        var hasChanges = false;
        
        $('.pph-input').each(function() {
            if ($(this).hasClass('border-warning')) {
                hasChanges = true;
            }
            pphData.push({
                id: $(this).data('id'),
                pph: rupiahToNumber($(this).val())
            });
        });
        
        $('.pph-input-income').each(function() {
            if ($(this).hasClass('border-warning')) {
                hasChanges = true;
            }
            pphData.push({
                id: $(this).data('id'),
                pph: rupiahToNumber($(this).val())
            });
        });
        
        if (!hasChanges) {
            Swal.fire({
                icon: 'info',
                title: 'Informasi',
                text: 'Tidak ada perubahan PPh yang perlu disimpan.'
            });
            return;
        }
        
        Swal.fire({
            title: 'Simpan Perubahan PPh?',
            text: 'Data PPh akan diupdate ke database',
            icon: 'question',
            showCancelButton: true,
            confirmButtonText: 'Ya, Simpan',
            cancelButtonText: 'Batal'
        }).then((result) => {
            if (result.isConfirmed) {
                $.ajax({
                    url: '{{ route("rptkpj.updatePph") }}',
                    type: 'POST',
                    data: {
                        _token: '{{ csrf_token() }}',
                        pph_data: pphData
                    },
                    success: function(response) {
                        if (response.success) {
                            Swal.fire({
                                icon: 'success',
                                title: 'Berhasil',
                                text: 'Data PPh berhasil disimpan!',
                                timer: 1500
                            });
                            
                            $('.pph-input').removeClass('border-warning');
                            $('.pph-input-income').removeClass('border-warning');
                            
                            setTimeout(function() {
                                location.reload();
                            }, 1500);
                        }
                    },
                    error: function(xhr) {
                        Swal.fire({
                            icon: 'error',
                            title: 'Gagal',
                            text: 'Terjadi kesalahan saat menyimpan data PPh'
                        });
                    }
                });
            }
        });
    });
});
</script>
<style>
    .pph-input,
    .pph-input-income {
        min-width: 100px !important;
        padding: 0.25rem 0.5rem !important;
        font-size: 12px !important;
    }

    .border-warning {
        border: 2px solid #ffc107 !important;
        background-color: #fff3cd !important;
    }

    .main-row:hover {
        background-color: #f8f9fa;
    }

    .detail-row td {
        padding: 0 !important;
    }

    .detail-table td:not(:first-child) {
        padding-left: 16px !important;
    }

    .detail-row .table {
        margin-bottom: 0;
    }

    .detail-row {
        background-color: #f5f5f5;
    }

    

    @media print {
        .navbar,
        .btn,
        .sidenav {
            display: none !important;
        }
        .card {
            box-shadow: none !important;
            border: none !important;
        }
        table {
            page-break-inside: auto;
        }
        tr {
            page-break-inside: avoid;
            page-break-after: auto;
        }
        thead {
            display: table-header-group;
        }
    }
</style>
@endpush