@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
@include('layouts.navbars.auth.topnav', ['title' => 'Kartu Proyek'])
<div class="container-fluid py-4">
    <div class="row">
        <div class="col-12">
            <div class="card mb-4">
                <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>No. PO</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->no_po ?? '-' }}</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-bordered table-sm" style="font-size: 12px;">
                            <thead class="bg-light">
                                <tr>
                                    <th class="text-center">TGL</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 $expense)
                                @php
                                $total_amount += $expense->amount;
                                $pph = $expense->pph ?? 0; // Ambil dari database
                                $total_pph += $pph;
                                $paid = $expense->amount - $pph;
                                $total_paid += $paid;

                                // Hitung total per kategori
                                if(isset($category_totals[$expense->kategori_id])) {
                                $category_totals[$expense->kategori_id] += $expense->amount;
                                }
                                @endphp
                                <tr>
                                    <td class="text-center">{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }}
                                    </td>
                                    <td>{{ trim(($expense->kode_mutasi ?? '') . ' ' . ($expense->nomor_bukti ?? '')) ?: '-' }}</td>
                                    <td>{{ $expense->keterangan ?? '-' }}</td>
                                    <td>{{ $expense->kategori_name ?? '-' }}</td>
                                    <td>{{ $expense->detail_kategori_name ?? '-' }}</td>
                                    @foreach($dynamic_categories as $category)
                                    <td class="text-end">
                                        @if($expense->kategori_id == $category->id)
                                        {{ number_format($expense->amount, 0, ',', '.') }}
                                        @else
                                        -
                                        @endif
                                    </td>
                                    @endforeach
                                    <td class="text-end">{{ number_format($expense->amount, 0, ',', '.') }}</td>
                                    <td class="text-end">
                                        <input type="number" 
                                               class="form-control form-control-sm text-end pph-input" 
                                               data-id="{{ $expense->id }}" 
                                               value="{{ $pph }}" 
                                               step="0.01"
                                               style="width: 120px; display: inline-block;">
                                    </td>
                                    <td class="text-end total-dibayar" data-amount="{{ $expense->amount }}">
                                        {{ number_format($paid, 0, ',', '.') }}
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="{{ 8 + count($dynamic_categories) }}" class="text-center">Tidak ada
                                        data biaya</td>
                                </tr>
                                @endforelse

                                @if(count($expenses) > 0)
                                <tr class="bg-light">
                                    <td colspan="5" 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-bordered table-sm" style="font-size: 12px;">
                            <thead class="bg-light">
                                <tr>
                                    <th class="text-center">TGL</th>
                                    <th class="text-center">No. Bukti</th>
                                    <th class="text-center">KETERANGAN</th>
                                    <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;
                                @endphp

                                @forelse($incomes as $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;
                                @endphp
                                <tr>
                                    <td class="text-center">{{ \Carbon\Carbon::parse($income->date)->format('d/m/Y') }}
                                    </td>
                                    <td>{{ trim(($income->kode_mutasi ?? '') . ' ' . ($income->nomor_bukti ?? '')) ?: '-' }}</td>
                                    <td>{{ $income->keterangan ?? '-' }}</td>
                                    <td class="text-end">{{ number_format($income->amount, 0, ',', '.') }}</td>
                                    <td class="text-end">
                                        <input type="number" 
                                               class="form-control form-control-sm text-end pph-input-income" 
                                               data-id="{{ $income->id }}" 
                                               value="{{ $income_pph }}" 
                                               step="0.01"
                                               style="width: 120px; display: inline-block;">
                                    </td>
                                    <td class="text-end total-dibayar-income" data-amount="{{ $income->amount }}">
                                        {{ number_format($income_paid, 0, ',', '.') }}
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="6" class="text-center">Tidak ada data penerimaan</td>
                                </tr>
                                @endforelse

                                @if(count($incomes) > 0)
                                <tr class="bg-light">
                                    <td colspan="3" class="text-end"><strong>TOTAL PEMBAYARAN</strong></td>
                                    <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: 13px;">
                                <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>

                    <!-- Tombol Export -->
                    <div class="row mt-3">
                        <div class="col-12">
                            <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>
                            <button type="button" class="btn btn-primary" onclick="window.close()">
                                <i class="fas fa-times me-2"></i>Tutup
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@push('js')
<script>
$(document).ready(function() {
    // 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 = parseFloat($(this).val()) || 0;
        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();
    });
    
    // 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 = parseFloat($(this).val()) || 0;
        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();
    });
    
    // Fungsi untuk update total PPh dan Total Dibayar
    function updateTotals() {
        // Update total Biaya Proyek
        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 = parseFloat($(this).val()) || 0;
            
            totalPph += pph;
            totalDibayar += (amount - pph);
        });
        
        // Update tampilan total biaya
        $('#totalPph strong').text(totalPph.toLocaleString('id-ID'));
        $('#totalDibayar strong').text(totalDibayar.toLocaleString('id-ID'));
        
        // Update total Penerimaan Pembayaran
        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 = parseFloat($(this).val()) || 0;
            
            totalIncomePph += pph;
            totalIncomeDibayar += (amount - pph);
        });
        
        // Update tampilan total penerimaan
        $('#totalIncomePph strong').text(totalIncomePph.toLocaleString('id-ID'));
        $('#totalIncomeDibayar strong').text(totalIncomeDibayar.toLocaleString('id-ID'));
    }
    
    // Save PPh
    $('#btnSavePph').click(function() {
        var pphData = [];
        var hasChanges = false;
        
        // Collect PPh dari Biaya Proyek
        $('.pph-input').each(function() {
            if ($(this).hasClass('border-warning')) {
                hasChanges = true;
            }
            pphData.push({
                id: $(this).data('id'),
                pph: parseFloat($(this).val()) || 0
            });
        });
        
        // Collect PPh dari Penerimaan Pembayaran
        $('.pph-input-income').each(function() {
            if ($(this).hasClass('border-warning')) {
                hasChanges = true;
            }
            pphData.push({
                id: $(this).data('id'),
                pph: parseFloat($(this).val()) || 0
            });
        });
        
        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
                            });
                            
                            // Remove highlight
                            $('.pph-input').removeClass('border-warning');
                            $('.pph-input-income').removeClass('border-warning');
                            
                            // Reload untuk update total
                            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;
    }
    
    @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