@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@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-body">
                    <div class="mb-3">
                        <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-primary ms-2" onclick="saveSellingPrices()">
                                <i class="fas fa-save me-2"></i>Save
                        </button>
                        @if(in_array('supadm', $users_rules))
                        <button onclick="confirmRegenerate()" class="btn btn-info">
                            <i class="fas fa-sync-alt me-2"></i> Generate Ulang
                        </button>
                        @endif
                        <form id="exportExcelForm" method="POST" action="{{ route('rptboq.exportExcel') }}" style="display:inline;">
                                @csrf
                                <input type="hidden" name="project_id" value="{{ $project->id }}">
                                <button type="submit" class="btn btn-success ms-2">
                                    <i class="fas fa-file-excel me-2"></i>Export Excel
                                </button>
                        </form>
                         <form id="exportExcelWithSellingPriceForm" method="POST" action="{{ route('rptboq.exportExcelWithSellingPrice') }}" style="display:inline;">
                                @csrf
                                <input type="hidden" name="project_id" value="{{ $project->id }}">
                                <button type="submit" class="btn btn-secondary ms-2">
                                    <i class="fas fa-file-excel me-2"></i>Export Excel With Selling Price
                                </button>
                        </form>
                        
                    </div>

                    <!-- Header Report -->
                    <div class="text-center mb-4">
                        <h3 class="mb-3"><strong>BILL OF QUANTITY</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>PROJECT NAME</strong></td>
                                    <td style="width: 20px">:</td>
                                    <td>{{ $project->proyek ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>LOCATION</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->lokasi ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>OWNER NAME</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->pemilik ?? '-' }}</td>
                                </tr>
                                <tr>
                                    <td><strong>SALES NAME</strong></td>
                                    <td>:</td>
                                    <td>{{ $project->sales ?? '-' }}</td>
                                </tr>
                                
                            </table>
                        </div>
                        <div class="col-md-6">
                            <table class="table-sm" style="width: 100%">
                               <tr>
                                    <td><strong>PV CAPACITY</strong></td>
                                    <td>:</td>
                                    <td>{{ isset($project->pv_capacity) ? number_format($project->pv_capacity, 0, ',', '.') . ' Wp' : '-' }}</td>
                                </tr>
                                 <tr>
                                    <td><strong>INVERTER CAPACITY</strong></td>
                                    <td>:</td>
                                    <td>{{ isset($project->inverter_capacity) ? number_format($project->inverter_capacity, 0, ',', '.') . ' W' : '-' }}</td>
                                </tr>
                                 <tr>
                                    <td><strong>FOREX</strong></td>
                                    <td>:</td>
                                    <td>{{ isset($project->forex) ? number_format($project->forex, 2, ',', '.') : '-' }} IDR/$</td>
                                </tr>
                            </table>
                        </div>
                    </div>

                    <!-- Tabel BOQ -->
                    <div class="table-responsive mb-4">
                        <h6 class="mb-2"><strong>EPC COST</strong></h6>

                        <table class="table table-bordered table-sm" style="font-size: 12px;">
                            
                            <thead>
                                <tr>
                                    <th class="text-sm text-center">Code</th>
                                    <th class="text-sm text-center">No</th>
                                    <th class="text-sm text-center">Items</th>
                                    <th class="text-sm text-center">Supply By</th>
                                    <th class="text-sm text-center">Brand</th>
                                    <th class="text-sm ext-center">Specification</th>
                                    <th class="text-sm text-center">Qty</th>
                                    <th class="text-sm text-start">Unit</th>
                                    <th class="text-sm text-center">Price/Unit (IDR)</th>
                                    <th class="text-sm text-center">Total (IDR)</th>
                                    <th class="text-sm text-center">Selling Price/Unit</th>
                                    <th class="text-sm text-center">Total Selling Price</th>
                                    <th class="text-sm text-center">Difference</th>
                                    <th class="text-sm text-center">$/Wp</th>
                                    <th class="text-sm text-center">Remarks</th>
                                </tr>
                            </thead>

                            <tbody>

                            @php
                                $totalMaterialSellingPrice = 0;
                                $totalMaterialDifference = 0;
                            @endphp

                            @foreach ($boqItemsGrouped as $kategoriCode => $items)

                                @php
                                $kategoriNo = $loop->iteration;
                                $totalRupiah = $items->sum('amount_rupiah');
                                $usd_per_wp_cat = 0;

                                if($project->pv_capacity && $project->forex){
                                    $usd_per_wp_cat = ($totalRupiah / $project->forex) / $project->pv_capacity;
                                }

                                $totalSellingPrice = $items->sum(function($item) {
                                    $sellingPriceUnit = $item->selling_price_unit ?? 0;
                                    return $sellingPriceUnit * ($item->amount_unit ?? 0);
                                });

                                $totalDifference = $items->sum(function($item) {
                                    $sellingPriceUnit = $item->selling_price_unit ?? 0;
                                    $sellingPriceTotal = $sellingPriceUnit * ($item->amount_unit ?? 0);
                                    return $sellingPriceTotal - ($item->amount_rupiah ?? 0);
                                });

                                $totalMaterialSellingPrice += $totalSellingPrice;
                                $totalMaterialDifference += $totalDifference;
                                @endphp

                                {{-- Header Kategori --}}
                                <tr class="category-header" style="background-color:#fff2cc; font-weight:bold;">
                                    <td>{{ $items->first()->kategori_code }}</td>
                                    <td class="text-end">{{ $kategoriNo }}</td>
                                    <td>{{ $items->first()->kategori }}</td>
                                    <td colspan="6"></td> {{-- Kosong agar Total IDR jatuh di kolom 10 --}}
                                    <td class="text-end">
                                        {{ number_format($totalRupiah, 2, ',', '.') }}
                                    </td>
                                    <td></td> {{-- Selling Price kosong untuk header --}}
                                    <td class="text-end">{{ number_format($totalSellingPrice, 2, ',', '.') }}</td>
                                    <td class="text-end">{{ number_format($totalDifference, 2, ',', '.') }}</td>
                                    <td class="text-end">
                                        {{ number_format($usd_per_wp_cat, 3, ',', '.') }}
                                    </td>
                                    <td></td>
                                </tr>

                                {{-- Detail Item --}}
                                @foreach ($items as $item)
                                @php
                                    $detailNo = $kategoriNo . '.' . $loop->iteration;
                                    $usd_per_wp = 0;

                                    if($project->pv_capacity && $project->forex){
                                        $usd_per_wp = ($item->amount_rupiah / $project->forex) / $project->pv_capacity;
                                    }
                                @endphp
                                <tr>
                                    <td>{{ $item->detail_kategori_code }}</td>
                                    <td class="text-end">{{ $detailNo }}</td>
                                    <td>{{ $item->detail_kategori }}</td>
                                    <td class="{{ $item->supplier_name ? 'text-start' : 'text-center' }}">{{ $item->supplier_name ?? '-' }}</td>
                                    <td class="{{ $item->brand ? 'text-start' : 'text-center' }}">{{ $item->brand ?? '-' }}</td>
                                    <td class="{{ $item->spesifikasi ? 'text-start' : 'text-center' }}">{{ $item->spesifikasi ?? '-' }}</td>
                                    <td class="text-end">{{ number_format($item->amount_unit, 2, ',', '.') }}</td>
                                    <td class="{{ $item->unit ? 'text-start' : 'text-center' }}">{{ $item->unit ?? '-' }}</td>
                                    @php
                                        $sellingPriceUnit = $item->selling_price_unit ?? 0;
                                        $sellingPriceTotal = $sellingPriceUnit * ($item->amount_unit ?? 0);
                                        $difference = $sellingPriceTotal - ($item->amount_rupiah ?? 0);
                                    @endphp
                                    <td class="text-end">{{ number_format($item->amount_rupiah_unit, 2, ',', '.') }}</td>
                                    <td class="text-end">{{ number_format($item->amount_rupiah, 2, ',', '.') }}</td>
                                    <td class="text-end">
                                        <input type="text"
                                            class="form-control form-control-sm text-end selling-price-input"
                                            inputmode="numeric"
                                            autocomplete="off"
                                            value="{{ number_format($item->selling_price_unit ?? 0, 2, ',', '.') }}"
                                            data-amount-unit="{{ $item->amount_unit ?? 0 }}"
                                            data-id="{{ $item->id }}"
                                            style="width: 150px;"
                                        />
                                    </td>
                                    <td class="text-end selling-price-total-cell">{{ number_format($sellingPriceTotal, 2, ',', '.') }}</td>
                                    <td class="text-end selling-price-difference-cell">{{ number_format($difference, 2, ',', '.') }}</td>
                                    <td class="text-end">
                                        {{number_format($usd_per_wp, 3, ',', '.')}}
                                    </td>
                                    <td></td>
                                </tr>
                                @endforeach

                            @endforeach
                            <!-- Baris Total -->
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                <td colspan="9" class="text-start">TOTAL MATERIAL PRICES</td>
                                <td class="text-end">
                                    <span id="total_material_prices">{{ number_format($totals['total_material_rupiah'] ?? 0, 2, ',', '.') }}</span>
                                </td>
                                <td></td>
                                <td class="text-end">
                                    <span id="total_material_selling_price">{{ number_format($totalMaterialSellingPrice, 2, ',', '.') }}</span>
                                </td>
                                <td class="text-end">
                                    <span id="total_material_difference">{{ number_format($totalMaterialDifference, 2, ',', '.') }}</span>
                                </td>
                                <td class="text-end">
                                    <span id="total_material_prices_usd">{{ number_format($totals['total_material_usd_wp'] ?? 0, 3, ',', '.') }}</span>
                                </td>
                                <td></td>
                            </tr>

                            <!-- Baris Total Exclude VAT, VAT Amount, dan Include VAT (commented out) -->
                            <!--
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                <td colspan="9" class="text-start">TOTAL PRICE EXCLUDE VAT</td>
                                <td class="text-end">
                                    <span id="total_exclude_vat">{{ number_format($totals['total_exclude_vat'] ?? 0, 2, ',', '.') }}</span>
                                </td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td class="text-end">
                                    <span id="total_exclude_vat_usd">{{ number_format($totals['total_exclude_vat_usd_wp'] ?? 0, 3, ',', '.') }}</span>
                                </td>
                                <td></td>
                            </tr>
                            -->
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                <td colspan="9" class="text-start">DISCOUNT</td>
                                <td class="text-end">
                                    <input type="text"
                                        id="discount_idr_input"
                                        class="form-control form-control-sm text-end"
            
                                        inputmode="numeric"
                                        autocomplete="off"
                                        value="{{ number_format($totals['discount_idr'] ?? 0, 2, ',', '.') }}"
                                        style="width: 140px; display: inline-block;"
                                    />
                                </td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td class="text-end">
                                    <span id="discount_usd_wp">{{ number_format($totals['discount_usd_wp'] ?? 0, 3, ',', '.') }}</span>
                                </td>
                                <td></td>
                            </tr>
                            {{-- Hidden holder for discount value used by JS --}}
                            <input type="hidden" id="discount_idr" value="{{ $totals['discount_idr'] ?? 0 }}">
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                <td colspan="9" class="text-start">TOTAL PRICE AFTER DISCOUNT</td>
                                <td class="text-end">
                                    <span id="total_price_after_discount">{{ number_format(($totals['total_material_rupiah'] ?? 0) - ($totals['discount_idr'] ?? 0), 2, ',', '.') }}</span>
                                </td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td class="text-end">
                                    <span id="total_price_after_discount_usd">{{ number_format((($totals['total_material_rupiah'] ?? 0) - ($totals['discount_idr'] ?? 0)) / ($project->forex ?? 1) / ($project->pv_capacity ?? 1), 3, ',', '.') }}</span>
                                </td>
                                <td></td>
                            </tr>
                            <!--
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                
                            <td colspan="9" class="text-start">
                                <span id="vat_label">VAT AMOUNT ({{ isset($settings['ppn_id']) && $settings['ppn_id'] ? ($settings['ppn_rate'] ?? 11) . '%' : '11%' }})</span>
                            </td>
                            <td class="text-end">
                                <div class="input-group input-group-sm" style="width: 140px; display: inline-flex;">
                                    <input type="text"
                                        id="ppn_input"
                                        class="form-control form-control-sm text-end"
                                        style="padding-right:3px"
                                        readonly
                                        value="{{ number_format($settings['ppn_amount'] ?? ($totals['vat_amount'] ?? 0), 2, ',', '.') }}"
                                    />
                                    <input type="hidden" id="selected_dpp_id" value="{{ $settings['dpp_id'] ?? '' }}">
                                    <input type="hidden" id="selected_ppn_id" value="{{ $settings['ppn_id'] ?? '' }}">
                                    <span class="input-group-text bg-primary text-light" style="cursor:pointer" onclick="openVatModal()" title="Set DPP & PPN">
                                        <i class="fas fa-search"></i>
                                    </span>
                                </div>
                                <span id="vat_amount" style="display:none;">{{ number_format($totals['vat_amount'] ?? 0, 2, ',', '.') }}</span>
                            </td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td class="text-end">
                                <span id="vat_amount_usd">{{ number_format($totals['vat_amount_usd_wp'] ?? 0, 3, ',', '.') }}</span>
                            </td>
                            <td></td>
                            </tr>
                            <tr style="background-color:#d9d9d9; font-weight:bold;">
                                <td colspan="9" class="text-start">TOTAL PRICE INCLUDE VAT</td>
                                <td class="text-end">
                                    <span id="total_include_vat">{{ number_format($totals['total_include_vat'] ?? 0, 2, ',', '.') }}</span>
                                </td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td class="text-end">
                                    <span id="total_include_vat_usd">{{ number_format($totals['total_include_vat_usd_wp'] ?? 0, 3, ',', '.') }}</span>
                                </td>
                                <td></td>
                            </tr>
                            -->
                            </tbody>
                        </table>

                        <!-- Modal VAT Calculation -->
                        <div class="modal fade" id="vatModal" tabindex="-1" role="dialog" aria-labelledby="vatModalLabel" aria-hidden="true">
                            <div class="modal-dialog modal-md" role="document">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="vatModalLabel">Set DPP & PPN</h5>
                                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                                    </div>
                                    <div class="modal-body">
                                        <div class="row mb-3">
                                            <div class="col-md-6">
                                                <label for="dpp_select" class="form-label">DPP (Dasar Pengenaan Pajak)</label>
                                                <select class="form-select form-select-sm" id="dpp_select">
                                                    <option value="">-- Pilih DPP --</option>
                                                </select>
                                            </div>
                                            <div class="col-md-6">
                                                <label for="ppn_select" class="form-label">PPN (Pajak Pertambahan Nilai)</label>
                                                <select class="form-select form-select-sm" id="ppn_select">
                                                    <option value="">-- Pilih PPN --</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="row mb-3">
                                            <div class="col-md-6">
                                                <label class="form-label">Net (Total - Discount)</label>
                                                <input type="text" class="form-control form-control-sm text-end" id="net_amount" readonly>
                                            </div>
                                            <div class="col-md-6">
                                                <label class="form-label">DPP Amount</label>
                                                <input type="text" class="form-control form-control-sm text-end" id="dpp_amount" readonly>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-6">
                                                <label class="form-label">PPN Rate</label>
                                                <input type="text" class="form-control form-control-sm text-end" id="ppn_rate" readonly>
                                            </div>
                                            <div class="col-md-6">
                                                <label class="form-label">PPN Amount</label>
                                                <input type="text" class="form-control form-control-sm text-end" id="ppn_amount" readonly>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="modal-footer">
                                        <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Batal</button>
                                        <button type="button" class="btn btn-primary btn-sm" onclick="saveVatSettings()">
                                            <i class="fas fa-check me-2"></i>Apply
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="mt-4">
                        <h6 class="mb-2"><strong>TERM OF PAYMENTS</strong></h6>

                        @if(isset($term_of_payments) && $term_of_payments->count() > 0)
                            <ul style="padding-left: 18px; margin-bottom: 0;">
                                @foreach($term_of_payments as $term)
                                    <li>{{ $term->tterm_or_payments }}</li>
                                @endforeach
                            </ul>
                        @else
                            <p class="mb-0">-</p>
                        @endif
                    </div>
                    <!-- Export Pdf/Excel -->
                    <div class="row mt-3">
                        <div class="col-12">
                            <!-- <form id="exportPdfForm" method="POST" action="{{ route('rptboq.export') }}" style="display:inline;" target="_blank">
                                @csrf
                                <input type="hidden" name="project_id" value="{{ $project->id }}">
                                <button type="submit" class="btn btn-success">
                                    <i class="fas fa-file-pdf me-2"></i>Export PDF
                                </button>
                            </form> -->
                            
                        </div>
                            
                    </div>
                    </div>
                                
                    
            </div>
        </div>
    </div>
</div>
@endsection
@push('js')
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
    const baseTotals = @json($totals);
    const baseProject = {
        forex: {{ $project->forex ?? 0 }},
        pv_capacity: {{ $project->pv_capacity ?? 0 }},
        project_id: {{ request('project_id') ?? 0 }},
    };

    function formatIdr(value) {
        const number = Number(value || 0);
        const [integerPart, decimalPart] = number.toFixed(2).split('.');
        const formattedInteger = integerPart.replace(/\B(?=(\d{3})+(?!\d))/g, '.');
        return `${formattedInteger},${decimalPart}`;
    }

    function formatCurrencyInput(value) {
        const text = String(value ?? '').replace(/[^\d,.-]/g, '');
        if (text === '') {
            return '';
        }

        const numericValue = parseNumber(text);
        const [integerPart, decimalPart] = numericValue.toFixed(2).split('.');
        const formattedInteger = integerPart.replace(/\B(?=(\d{3})+(?!\d))/g, '.');
        return `${formattedInteger},${decimalPart}`;
    }

    function applyFormattedValue($input) {
        const formatted = formatCurrencyInput($input.val());
        $input.val(formatted);
        return formatted;
    }

    function formatUsdWp(value) {
        return Number(value || 0).toFixed(3);
    }

    function showSweetAlert(type) {
        if (type === 'discount') {
            const currentIdr = parseFloat(document.getElementById('discount_idr').value) || 0;
            Swal.fire({
                title: 'Discount (IDR)',
                input: 'number',
                inputValue: currentIdr,
                inputAttributes: {
                    min: 0,
                    autocapitalize: 'off',
                    placeholder: 'Discount (IDR)'
                },
                showCancelButton: true,
                confirmButtonText: 'Save',
                cancelButtonText: 'Cancel',
                preConfirm: (value) => {
                    if (value === '' || isNaN(value)) {
                        Swal.showValidationMessage('Please enter a valid number');
                        return false;
                    }
                    return parseFloat(value);
                }
            }).then((result) => {
                if (result.isConfirmed) {
                    document.getElementById('discount_idr').value = result.value;
                    saveSettings().then(() => updateCalculations());
                }
            });
        }
    }

    function saveSettings() {
        const payload = {
            project_id: baseProject.project_id,
            discount_idr: parseFloat(document.getElementById('discount_idr').value) || 0,
            ppn: baseTotals.ppn || 0,
        };

        return $.ajax({
            url: '{{ route('rptboq.settings') }}',
            method: 'POST',
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            },
            data: payload,
        }).done((res) => {
            if (res.success) {
                // keep server totals in sync
                Object.assign(baseTotals, res.totals);
                document.getElementById('discount_amount').textContent = formatIdr(res.totals.discount_idr);
                document.getElementById('discount_usd_wp').textContent = formatUsdWp(res.totals.discount_usd_wp);
                const vatAmountEl2 = document.getElementById('vat_amount');
                if (vatAmountEl2) vatAmountEl2.textContent = formatIdr(res.totals.vat_amount);
                const vatAmountUsdEl2 = document.getElementById('vat_amount_usd');
                if (vatAmountUsdEl2) vatAmountUsdEl2.textContent = formatUsdWp(res.totals.vat_amount_usd_wp);
                const totalIncludeVatEl2 = document.getElementById('total_include_vat');
                if (totalIncludeVatEl2) totalIncludeVatEl2.textContent = formatIdr(res.totals.total_include_vat);
                const totalIncludeVatUsdEl2 = document.getElementById('total_include_vat_usd');
                if (totalIncludeVatUsdEl2) totalIncludeVatUsdEl2.textContent = formatUsdWp(res.totals.total_include_vat_usd_wp);
                // document.getElementById('vat_label').textContent = `VAT AMOUNT (11%)`;
            }
        });
    }

    function updateCalculations() {
        const discountIdr = parseFloat(document.getElementById('discount_idr').value) || 0;

        const totalExcludeVat = baseTotals.total_exclude_vat || 0;
        const vatAmount = baseTotals.vat_amount || 0;

        // Generate discount $/Wp based on current IDR discount + current forex/pv capacity
        const discountUsdWp = (baseProject.forex > 0 && baseProject.pv_capacity > 0)
            ? (discountIdr / baseProject.forex) / baseProject.pv_capacity
            : 0;
        // Discount is only applied once (IDR). USD/Wp is for display only.
        const discountTotalIdr = discountIdr;

        const totalIncludeVat = totalExcludeVat + vatAmount - discountTotalIdr;

        const totalExcludeVatEl = document.getElementById('total_exclude_vat');
        if (totalExcludeVatEl) totalExcludeVatEl.textContent = formatIdr(totalExcludeVat);
        const totalExcludeVatUsdEl = document.getElementById('total_exclude_vat_usd');
        if (totalExcludeVatUsdEl) totalExcludeVatUsdEl.textContent = formatUsdWp(totalExcludeVat / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
        const vatAmountEl = document.getElementById('vat_amount');
        if (vatAmountEl) vatAmountEl.textContent = formatIdr(vatAmount);
        const vatAmountUsdEl = document.getElementById('vat_amount_usd');
        if (vatAmountUsdEl) vatAmountUsdEl.textContent = formatUsdWp(vatAmount / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
        const discountAmount = document.getElementById('discount_amount');

        if (discountAmount) {
            discountAmount.textContent = formatIdr(discountIdr);
        }
        document.getElementById('discount_usd_wp').textContent = formatUsdWp(discountUsdWp);
        const totalIncludeVatEl = document.getElementById('total_include_vat');
        if (totalIncludeVatEl) totalIncludeVatEl.textContent = formatIdr(totalIncludeVat);
        const totalIncludeVatUsdEl = document.getElementById('total_include_vat_usd');
        if (totalIncludeVatUsdEl) totalIncludeVatUsdEl.textContent = formatUsdWp(totalIncludeVat / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
        // document.getElementById('vat_label').textContent = `VAT AMOUNT (11%)`;
        
        // Total Price After Discount = Total Material Prices - Discount
        const totalMaterialRupiah = baseTotals.total_material_rupiah || 0;
        const totalPriceAfterDiscount = totalMaterialRupiah - discountIdr;
        document.getElementById('total_price_after_discount').textContent = formatIdr(totalPriceAfterDiscount);
        document.getElementById('total_price_after_discount_usd').textContent = formatUsdWp(totalPriceAfterDiscount / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
    }

    function parseNumber(value) {
        const text = String(value ?? '').trim();
        if (text === '') {
            return 0;
        }

        const normalized = text.replace(/\s/g, '');
        if (normalized.indexOf('.') > -1 && normalized.indexOf(',') > -1) {
            return parseFloat(normalized.replace(/\./g, '').replace(/,/g, '.')) || 0;
        }

        if (normalized.indexOf(',') > -1) {
            return parseFloat(normalized.replace(/,/g, '.')) || 0;
        }

        if (normalized.indexOf('.') > -1) {
            const parts = normalized.split('.');
            if (parts.length > 2) {
                return parseFloat(parts.join('')) || 0;
            }

            const decimalPart = parts[1] || '';
            if (decimalPart.length === 2) {
                return parseFloat(normalized) || 0;
            }

            if (decimalPart.length === 3) {
                return parseFloat(normalized.replace(/\./g, '')) || 0;
            }
        }

        return parseFloat(normalized) || 0;
    }

    function recalculateMaterialTotals() {
        let totalSellingPrice = 0;
        let totalDifference = 0;

        $('.selling-price-total-cell').each(function () {
            totalSellingPrice += parseNumber($(this).text());
        });

        $('.selling-price-difference-cell').each(function () {
            totalDifference += parseNumber($(this).text());
        });

        $('#total_material_selling_price').text(formatIdr(totalSellingPrice));
        $('#total_material_difference').text(formatIdr(totalDifference));
    }

    function updateSellingPriceRow($input) {

        const sellingPrice = parseNumber($input.val());
        const amountUnit = parseNumber($input.data('amount-unit'));
        const total = sellingPrice * amountUnit;
        const $row = $input.closest('tr');
        const amountRupiah = parseNumber($row.find('td:nth-child(10)').text());

        $row.find('.selling-price-total-cell').text(formatIdr(total));
        $row.find('.selling-price-difference-cell').text(formatIdr(total - amountRupiah));
        recalculateMaterialTotals();
    }

    function saveSellingPrices() {
        const sellingPrices = [];
        $('.selling-price-input').each(function () {
            const $input = $(this);
            const id = $input.data('id');
            const sellingPriceUnit = parseNumber($input.val());

            if (id) {
                sellingPrices.push({
                    id: id,
                    selling_price_unit: sellingPriceUnit
                });
            }
        });

        const discountIdr = parseNumber(document.getElementById('discount_idr_input').value);
        const dppId = $('#selected_dpp_id').val();
        const ppnId = $('#selected_ppn_id').val();
        const ppnAmount = parseNumber($('#ppn_input').val());

        if (sellingPrices.length === 0 && discountIdr <= 0 && !ppnId) {
            Swal.fire('Error', 'Tidak ada perubahan untuk disimpan', 'error');
            return;
        }

        Swal.fire({
            title: 'Simpan perubahan?',
            text: 'Data selling price, discount, dan PPN akan diperbaharui di database',
            icon: 'question',
            showCancelButton: true,
            confirmButtonText: 'Ya, Simpan',
            cancelButtonText: 'Batal'
        }).then((result) => {
            if (result.isConfirmed) {
                $.ajax({
                    url: '{{ route("rptboq.updateSellingPrice") }}',
                    method: 'POST',
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    data: {
                        project_id: {{ $project->id }},
                        selling_prices: sellingPrices,
                        discount_idr: discountIdr,
                        dpp_id: dppId || null,
                        ppn_id: ppnId || null,
                        ppn: ppnAmount,
                    },
                    success: function (response) {
                        if (response.success) {
                            Swal.fire('Success', response.message, 'success').then(() => {
                                location.reload();
                            });
                        } else {
                            Swal.fire('Error', 'Failed to save selling prices', 'error');
                        }
                    },
                    error: function () {
                        Swal.fire('Error', 'An error occurred while saving', 'error');
                    }
                });
            }
        });
    }

    function confirmRegenerate() {
        Swal.fire({
            title: 'Konfirmasi Generate Ulang',
            text: 'Apakah anda yakin akan generate ulang BOQ untuk project "{{ $project->proyek ?? "" }}", setelah generate semua perubahan yang anda lakukan disini akan menghilang dan isi BOQ akan kembali sesuai transaksi terbaru',
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: 'Ya, Generate Ulang',
            cancelButtonText: 'Batal',
            confirmButtonColor: '#028284',
            cancelButtonColor: '#d33'
        }).then((result) => {
            if (result.isConfirmed) {
                var form = $('<form>', {
                    method: 'POST',
                    action: '{{ route("rptboq.regenerate", encrypt($project->id)) }}'
                });
                
                form.append($('<input>', {
                    type: 'hidden',
                    name: '_token',
                    value: '{{ csrf_token() }}'
                }));
                
                $('body').append(form);
                form.submit();
                form.remove();
            }
        });
    }

    function openVatModal() {
        $('#vatModal').modal('show');
        fetchDPPData();
        fetchPPNData();
    }

    let dppDataLoaded = false;
    let ppnDataLoaded = false;
    function triggerCalculateIfReady() {
        if (dppDataLoaded && ppnDataLoaded) {
            calculateNet();
            dppDataLoaded = false;
            ppnDataLoaded = false;
        }
    }

    function fetchDPPData() {
        $.ajax({
            url: '{{ route("trsmts.api.dpp-data") }}',
            method: 'GET',
            success: function(response) {
                if (response.success && response.data) {
                    const $select = $('#dpp_select');
                    const savedDppId = $('#selected_dpp_id').val();
                    const savedPpnId = $('#selected_ppn_id').val();
                    $select.empty();
                    $select.append('<option value="">-- Pilih DPP --</option>');
                    
                    response.data.forEach(function(item) {
                        const selected = savedDppId && String(item.id) === String(savedDppId) ? ' selected' : '';
                        $select.append(`<option value="${item.id}" data-numerator="${item.dpp_numerator}" data-denominator="${item.dpp_denominator}"${selected}>${item.name}</option>`);
                    });
                    
                    dppDataLoaded = true;
                    triggerCalculateIfReady();
                }
            },
            error: function() {
                Swal.fire('Error', 'Gagal memuat data DPP', 'error');
            }
        });
    }

    function fetchPPNData() {
        $.ajax({
            url: '{{ route("trsmts.api.ppn-data") }}',
            method: 'GET',
            success: function(response) {
                if (response.success && response.data) {
                    const $select = $('#ppn_select');
                    const savedPpnId = $('#selected_ppn_id').val();
                    $select.empty();
                    $select.append('<option value="">-- Pilih PPN --</option>');
                    
                    response.data.forEach(function(item) {
                        const selected = savedPpnId && String(item.id) === String(savedPpnId) ? ' selected' : '';
                        $select.append(`<option value="${item.id}" data-rate="${item.rate}"${selected}>${item.name} (${item.rate}%)</option>`);
                    });
                    
                    ppnDataLoaded = true;
                    triggerCalculateIfReady();
                }
            },
            error: function() {
                Swal.fire('Error', 'Gagal memuat data PPN', 'error');
            }
        });
    }

    function calculateNet() {
        const totalExcludeVat = baseTotals.total_exclude_vat || 0;
        const discountIdr = parseFloat(document.getElementById('discount_idr').value) || 0;
        const net = totalExcludeVat - discountIdr;
        
        $('#net_amount').val(formatIdr(net));
        
        // Calculate DPP Amount
        const selectedDpp = $('#dpp_select option:selected');
        if (selectedDpp.length && selectedDpp.val()) {
            const numerator = parseFloat(selectedDpp.data('numerator')) || 0;
            const denominator = parseFloat(selectedDpp.data('denominator')) || 0;
            
            if (denominator > 0) {
                const dppAmount = (net * numerator) / denominator;
                $('#dpp_amount').val(formatIdr(dppAmount));
                
                // Calculate PPN Amount
                const selectedPpn = $('#ppn_select option:selected');
                if (selectedPpn.length && selectedPpn.val()) {
                    const ppnRate = parseFloat(selectedPpn.data('rate')) || 0;
                    $('#ppn_rate').val(ppnRate + '%');
                    
                    const ppnAmount = (dppAmount * ppnRate) / 100;
                    $('#ppn_amount').val(formatIdr(ppnAmount));
                } else {
                    $('#ppn_rate').val('0%');
                    $('#ppn_amount').val(formatIdr(0));
                }
            } else {
                $('#dpp_amount').val(formatIdr(0));
                $('#ppn_amount').val(formatIdr(0));
            }
        } else {
            $('#dpp_amount').val(formatIdr(0));
            $('#ppn_rate').val('0%');
            $('#ppn_amount').val(formatIdr(0));
        }
    }

    function saveVatSettings() {
        const selectedDpp = $('#dpp_select').val();
        const selectedPpn = $('#ppn_select').val();
        
        if (!selectedDpp || !selectedPpn) {
            Swal.fire('Warning', 'Silakan pilih DPP dan PPN terlebih dahulu', 'warning');
            return;
        }
        
        const net = baseTotals.total_exclude_vat - (parseFloat(document.getElementById('discount_idr').value) || 0);
        const selectedDppOption = $('#dpp_select option:selected');
        const numerator = parseFloat(selectedDppOption.data('numerator')) || 0;
        const denominator = parseFloat(selectedDppOption.data('denominator')) || 0;
        const dppAmount = (denominator > 0) ? (net * numerator) / denominator : 0;
        
        const selectedPpnOption = $('#ppn_select option:selected');
        const ppnRate = parseFloat(selectedPpnOption.data('rate')) || 0;
        const ppnAmount = (dppAmount * ppnRate) / 100;
        
        // Update readonly input
        $('#ppn_input').val(formatIdr(ppnAmount));
        
        // Store selected IDs
        $('#selected_dpp_id').val(selectedDpp);
        $('#selected_ppn_id').val(selectedPpn);
        
        // Update calculations
        baseTotals.vat_amount = ppnAmount;
        baseTotals.ppn = ppnAmount;
        baseTotals.dpp_id = selectedDpp;
        baseTotals.ppn_id = selectedPpn;
        
        const totalExcludeVat = baseTotals.total_exclude_vat || 0;
        const discountIdr = parseFloat(document.getElementById('discount_idr').value) || 0;
        const totalIncludeVat = totalExcludeVat + ppnAmount - discountIdr;
        
        const vatAmountEl3 = document.getElementById('vat_amount');
        if (vatAmountEl3) vatAmountEl3.textContent = formatIdr(ppnAmount);
        const vatAmountUsdEl3 = document.getElementById('vat_amount_usd');
        if (vatAmountUsdEl3) vatAmountUsdEl3.textContent = formatUsdWp(ppnAmount / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
        const totalIncludeVatEl3 = document.getElementById('total_include_vat');
        if (totalIncludeVatEl3) totalIncludeVatEl3.textContent = formatIdr(totalIncludeVat);
        const totalIncludeVatUsdEl3 = document.getElementById('total_include_vat_usd');
        if (totalIncludeVatUsdEl3) totalIncludeVatUsdEl3.textContent = formatUsdWp(totalIncludeVat / (baseProject.forex || 1) / (baseProject.pv_capacity || 1));
        const vatLabelEl = document.getElementById('vat_label');
        if (vatLabelEl) vatLabelEl.textContent = `VAT AMOUNT (${ppnRate}%)`;
        
        $('#vatModal').modal('hide');
    }

    // Initialize form state
    document.addEventListener('DOMContentLoaded', () => {
        const discountInput = document.getElementById('discount_idr_input');
        const initialDiscount = formatCurrencyInput(baseTotals.discount_idr || 0);
        document.getElementById('discount_idr').value = baseTotals.discount_idr || 0;
        discountInput.value = initialDiscount;
        
        // Initialize VAT settings if exist
        if (baseTotals.dpp_id) {
            $('#selected_dpp_id').val(baseTotals.dpp_id);
        }
        if (baseTotals.ppn_id) {
            $('#selected_ppn_id').val(baseTotals.ppn_id);
        }
        
        updateCalculations();

        $('.selling-price-input').each(function () {
            updateSellingPriceRow($(this));
        });

        $(document).on('input', '.selling-price-input', function () {
            const $input = $(this);
            updateSellingPriceRow($input);
        });

        $(document).on('blur change', '.selling-price-input', function () {
            const $input = $(this);
            applyFormattedValue($input);
            updateSellingPriceRow($input);
        });

        $(document).on('input', '#discount_idr_input', function () {
            const $input = $(this);
            document.getElementById('discount_idr').value = parseNumber($input.val());
            updateCalculations();
        });

        $(document).on('blur change', '#discount_idr_input', function () {
            const $input = $(this);
            applyFormattedValue($input);
            document.getElementById('discount_idr').value = parseNumber($input.val());
            updateCalculations();
        });

        // Event listeners for VAT modal
        $(document).on('change', '#dpp_select', function() {
            calculateNet();
        });
        
        $(document).on('change', '#ppn_select', function() {
            calculateNet();
        });
    });
</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;
    }

    #vatModal .modal-body {
        padding: 1rem;
    }

    #vatModal .form-label {
        font-size: 11px;
        font-weight: 600;
        margin-bottom: 0.25rem;
        color: #495057;
    }

    #vatModal .form-control[readonly] {
        background-color: #e9ecef;
        opacity: 1;
    }

    @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