@include('layouts.header')
@include('layouts.sidebar')

<div class="page-wrapper">
    <div class="content">
        <!-- Page Header -->
        <div class="page-header">
            <div class="add-item d-flex">
                <div class="page-title">
                    <h4>Purchase Order</h4>
                </div>
            </div>
            <div class="page-btn">
                <a href="{{ route('purchase_orders')}}" class="btn btn-added"><i data-feather="arrow-left" class="me-2"></i>Back To PO</a>
            </div>
        </div>

        <!-- Flash Messages -->
        @if(session()->has('success'))
            <div class="alert alert-success">{{ session()->get('success') }}</div>
        @endif
        @if(session()->has('error'))
            <div class="alert alert-danger">{{ session()->get('error') }}</div>
        @endif

        <!-- Purchase Order Design -->
        <div class="card table-list-card">
            <div class="card-body">
                <!-- Header Section -->
                <header style="border-bottom: 3px solid black; padding: 5px;">
                    <div>
                        <h6 style="font-weight: bold; float:right;">Ph nos: 9665065522 /25 /34</h6>
                    </div>
                    <br><br>
                    <div>
                        <h1 style="font-weight: bold;text-align: center;">{{ $po_details['company_name']}}</h1>
                        <h6 style="text-align: center;">{{ $po_details['company_address'] ?? ''}}</h6>
                    </div>
                    <div>
                        <!--<span style="text-align: center;font-weight: bold;"><a href="">kukreja_interiors@yahoo.com</a></span>
                        <span style="font-weight: bold; float:right;">GSTIN:27AMSPK1108K1ZU</span>-->
                    </div>
                </header>

                <!-- Address Section -->
                <div style="border-bottom: 3px solid black; padding: 5px;">
                    <div>
                        <span>To</span>
                        <span class="float-end" style="margin-right: 5%;">P.O No:{{ $po_details['po_number']}}</span>
                    </div>
                    <input type="hidden" value="{{ $po_details['supplier_id'] }}"  data-top="{{ $po_details['supplier_top'] }}" class="supplier_id">
                    <div>
                        <span>M/S:{{ $po_details['supplier_name'] ?? ''}}</span>
                        <span class="float-end" style="margin-right: 5%;">Date:{{ date('d-m-Y', strtotime($po_details['po_date'])) }}
                        </span>
                    </div>
                    <div>
                        <span>Address:{{ $po_details['supplier_address'] ?? ''}}</span>
                    </div>
                    <br>
                    <div>
                        <!--<span>Kind Attn:</span>
                        <span class="float-end" style="margin-right: 15%;">Ph No.:</span>-->
                    </div>
                </div>

                <!-- Subject Section -->
                <div style="border-bottom: 1px solid black;">
                    <h6 style="padding: 5px;">Subject: We are pleased to place the order for the following material to you.</h6>
                </div>

                <!-- Purchase Items Table -->
                <div>
                    <table class="table table-bordered" id="order-items" style="width:100%; border-collapse: collapse;">
                        <thead>
                            <tr>
                                <th>No</th>
                                <th>Product Name</th>
                                <th>Design/Variant No</th>
                                <th>No Of Rolls</th>
                                <th>Quantity</th>
                                <th>Rate</th>
                                <th>UOM</th>
                                <th>%GST</th>
                                <th>Amount</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            @php $i = 1; @endphp
                            @foreach($po_details['items'] as $item)
                            <tr>
                                <td>{{ $i++ }}</td>
                                <td>{{ $item->product_name }}</td>
                                <td>{{ $item->varient_name }} - {{ $item->varient_code }}</td>
                                <td class="no_of_rolls">{{ $item->no_of_rolls }}</td>
                                <td class="quantity">{{ $item->quantity }}</td>
                                <td class="rate">{{ $item->rate }}</td>
                                <td>{{ $item->uom }}</td>
                                <td class="gst_percent">{{ $item->gst_percent }}%</td>
                                <td class="amount">{{ $item->total }}</td>
                                  <td class="hsn_code d-none">{{ $item->hsn_code ?? 'N/A' }}</td>
                            </tr>
                            @endforeach

                            <!-- Note -->
                            <tr>
                                <td colspan="8" style="font-weight: bold;">Note: {{ $po_details['note'] }}</td>
                            </tr>

                            <!-- Gross Total -->
                            <tr>
                                <td rowspan="6"></td>
                                <td colspan="4" rowspan="2"></td>
                                <td colspan="2">Gross Total</td>
                                <td colspan="2">₹ {{ number_format($po_details['subtotal'], 2) }}</td>
                            </tr>

                            <!-- Forwarding Charges -->
                            @if(!empty($po_details['forwarding']))
                            <tr>
                                <td colspan="2">Forwarding</td>
                                <td colspan="2" class="f_amount text-dark">₹ {{ number_format($po_details['forwarding'], 2) }}</td>
                            </tr>
                            @endif

                            

                            

                            <!-- Message -->
                            <tr>
                                <td colspan="4" rowspan="2">Kindly send the material by above transport in best condition and mail us L.R. details ASAP</td>
                            </tr>

                            
                          

                            <!-- GST -->
                           
                            <tr>
                               
                                <td colspan="2" >GST Amount (Item+Forwarding) </td>
                                <td colspan="2" id="gst_total_input">₹ </td>
                            </tr>
                           

                          

                            <!-- Final Total -->
                            <tr>
                                <td colspan="4"></td>
                                <td style="font-weight: bold;" colspan="2">Final Amount</td>
                                <td class="text-dark" colspan="2">₹ {{ number_format($po_details['grand_total'], 2) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>

                 <div class="mt-4">
                    <h5><strong>GST Summary</strong></h5><br>
                    <table class="table table-bordered" id="gst-summary-table">
                        <thead>
                            <tr>
                              <th>HSN Code</th>
                                <th>GST %</th>
                                <th>CGST %</th>
                                <th>SGST %</th>
                                <th>IGST %</th>
                                <th>Total GST Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                           
                        </tbody>
                    </table>
                </div> <br>


                <!-- Footer Section -->
                <!-- <div>
                    <h6 style="font-weight: bold; float:right; padding: 10px;">For {{$po_details['company_name']}}</h6>
                </div> -->
                <br><br>
                <div>
                    <h6 style="float:right; padding: 10px;"></h6>
                </div>
            </div>
        </div>
    </div>
</div>
 <!--
<div class="text-end" style="position: fixed; bottom: 20px; right: 20px;">
    <a href="{{ url('download-po/'.$po_details['id'] ?? '') }}" class="btn btn-primary">
        <i data-feather="download" class="me-2"></i>Download PDF
    </a>
</div>-->




@include('layouts.footer')
<script>
// function updateGstSummary() {
//     let gstGroups = {};
    
//     // 🔹 Forwarding GST setup
//     const forwardingHSN = "5242";
//     const forwardingGST = 18;

//     // 🔹 Forwarding amount (from DB, static in PO view)
//     let forwardingTotal = parseFloat({{ $po_details['forwarding'] ?? 0 }}) || 0;

//     let totalTaxable = 0;
//     let forwardingGstTotal = 0;

//     // Step 1: Collect all item rows
//     document.querySelectorAll('#order-items tbody tr').forEach(row => {
//         let qty = parseFloat(row.querySelector('.quantity')?.innerText || 0);
//         let rate = parseFloat(row.querySelector('.rate')?.innerText || 0);
//         let no_of_rolls = parseFloat(row.querySelector('.no_of_rolls')?.innerText || 0);
//         let gst = parseFloat((row.querySelector('.gst_percent')?.innerText || "0").replace('%', '')) || 0;
//         let hsncode = row.querySelector('.hsn_code')?.innerText || 'N/A';

//         let amount = no_of_rolls * qty * rate;
//         if (amount === 0) return; // Skip empty rows

//         let itemGstAmount = (amount * gst) / 100;
//         totalTaxable += amount;

//         let key = hsncode + '_' + gst;
//         if (!gstGroups[key]) {
//             gstGroups[key] = {
//                 hsn: hsncode,
//                 gst: gst,
//                 taxable: 0,
//                 cgst: 0,
//                 sgst: 0,
//                 igst: 0,
//                 total: 0
//             };
//         }

//         gstGroups[key].taxable += amount;
//         gstGroups[key].cgst += itemGstAmount / 2;
//         gstGroups[key].sgst += itemGstAmount / 2;
//         gstGroups[key].total += itemGstAmount;
//     });

//     // Step 2: Forwarding GST calculation
//     if (forwardingTotal > 0) {
//         forwardingGstTotal = (forwardingTotal * forwardingGST) / 100;

//         let fwdKey = forwardingHSN + '_' + forwardingGST;
//         if (!gstGroups[fwdKey]) {
//             gstGroups[fwdKey] = {
//                 hsn: forwardingHSN + " (Forwarding)", // 👈 label added
//                 gst: forwardingGST,
//                 taxable: 0,
//                 cgst: 0,
//                 sgst: 0,
//                 igst: 0,
//                 total: 0
//             };
//         }

//         gstGroups[fwdKey].taxable += forwardingTotal;
//         gstGroups[fwdKey].cgst += forwardingGstTotal / 2;
//         gstGroups[fwdKey].sgst += forwardingGstTotal / 2;
//         gstGroups[fwdKey].total += forwardingGstTotal;
//     }

//     // Step 3: Render GST Summary
//     const gstTableBody = document.querySelector('#gst-summary-table tbody');
//     gstTableBody.innerHTML = '';
//     let totalCgst = 0, totalSgst = 0, totalIgst = 0, totalGstSum = 0;

//     for (let key in gstGroups) {
//         let data = gstGroups[key];
//         if (data.total > 0) {
//             totalCgst += data.cgst;
//             totalSgst += data.sgst;
//             totalIgst += data.igst;
//             totalGstSum += data.total;

//             const row = document.createElement('tr');
//             row.innerHTML = `
//                 <td>${data.hsn}</td>
//                 <td>${data.gst}%</td>
//                 <td>₹ ${data.cgst.toFixed(2)}</td>
//                 <td>₹ ${data.sgst.toFixed(2)}</td>
//                 <td>₹ ${data.igst.toFixed(2)}</td>
//                 <td>₹ ${data.total.toFixed(2)}</td>
//             `;
//             gstTableBody.appendChild(row);
//         }
//     }

//     // Step 4: Total Row
//     const totalRow = document.createElement('tr');
//     totalRow.style.fontWeight = "bold";
//     totalRow.innerHTML = `
//         <td>Total</td>
//         <td></td>
//         <td>₹ ${totalCgst.toFixed(2)}</td>
//         <td>₹ ${totalSgst.toFixed(2)}</td>
//         <td>₹ ${totalIgst.toFixed(2)}</td>
//         <td>₹ ${totalGstSum.toFixed(2)}</td>
//     `;
//     gstTableBody.appendChild(totalRow);

//     // Step 5: Update combined GST (items + forwarding) in PO table
//     document.getElementById('gst_total_input').innerText = `₹ ${totalGstSum.toFixed(2)}`;
// }


function updateGstSummary() {
    let gstGroups = {};
    
    // 🔹 Forwarding GST setup
    const forwardingHSN = "5242";
    const forwardingGST = 18;

    // 🔹 Forwarding amount (from DB, static in PO view)
    let forwardingTotal = parseFloat({{ $po_details['forwarding'] ?? 0 }}) || 0;

    let totalTaxable = 0;
    let forwardingGstTotal = 0;

    // ✅ Get supplier state (from hidden input)
    let supplierState = document.querySelector('.supplier_id')?.dataset.top || "OMS"; 
    // Default "OUT" if nothing found

    // Step 1: Collect all item rows
    document.querySelectorAll('#order-items tbody tr').forEach(row => {
        let qty = parseFloat(row.querySelector('.quantity')?.innerText || 0);
        let rate = parseFloat(row.querySelector('.rate')?.innerText || 0);
        let no_of_rolls = parseFloat(row.querySelector('.no_of_rolls')?.innerText || 0);
        let gst = parseFloat((row.querySelector('.gst_percent')?.innerText || "0").replace('%', '')) || 0;
        let hsncode = row.querySelector('.hsn_code')?.innerText || 'N/A';

        let amount = no_of_rolls * qty * rate;
        if (amount === 0) return; // Skip empty rows

        let itemGstAmount = (amount * gst) / 100;
        totalTaxable += amount;

        let key = hsncode + '_' + gst;
        if (!gstGroups[key]) {
            gstGroups[key] = {
                hsn: hsncode,
                gst: gst,
                taxable: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }

        gstGroups[key].taxable += amount;
        

        // ✅ Supplier state condition
        if (supplierState === "MSP") {
            gstGroups[key].cgst += itemGstAmount / 2;
            gstGroups[key].sgst += itemGstAmount / 2;
        } else {
            gstGroups[key].igst += itemGstAmount;
        }

        gstGroups[key].total += itemGstAmount;
    });

    // Step 2: Forwarding GST calculation
    if (forwardingTotal > 0) {
        forwardingGstTotal = (forwardingTotal * forwardingGST) / 100;

        let fwdKey = forwardingHSN + '_' + forwardingGST;
        if (!gstGroups[fwdKey]) {
            gstGroups[fwdKey] = {
                hsn: forwardingHSN + " (Forwarding)",
                gst: forwardingGST,
                taxable: 0,
                cgst: 0,
                sgst: 0,
                igst: 0,
                total: 0
            };
        }

        gstGroups[fwdKey].taxable += forwardingTotal;

        // ✅ Supplier state condition
        if (supplierState === "MH") {
            gstGroups[fwdKey].cgst += forwardingGstTotal / 2;
            gstGroups[fwdKey].sgst += forwardingGstTotal / 2;
        } else {
            gstGroups[fwdKey].igst += forwardingGstTotal;
        }

        gstGroups[fwdKey].total += forwardingGstTotal;
    }

    // Step 3: Render GST Summary
    const gstTableBody = document.querySelector('#gst-summary-table tbody');
    gstTableBody.innerHTML = '';
    let totalCgst = 0, totalSgst = 0, totalIgst = 0, totalGstSum = 0;

    for (let key in gstGroups) {
        let data = gstGroups[key];
        if (data.total > 0) {
            totalCgst += data.cgst;
            totalSgst += data.sgst;
            totalIgst += data.igst;
            totalGstSum += data.total;

            const row = document.createElement('tr');
            row.innerHTML = `
                <td>${data.hsn}</td>
                <td>${data.gst}%</td>
                <td>₹ ${data.cgst.toFixed(2)}</td>
                <td>₹ ${data.sgst.toFixed(2)}</td>
                <td>₹ ${data.igst.toFixed(2)}</td>
                <td>₹ ${data.total.toFixed(2)}</td>
            `;
            gstTableBody.appendChild(row);
        }
    }

    // Step 4: Total Row
    const totalRow = document.createElement('tr');
    totalRow.style.fontWeight = "bold";
    totalRow.innerHTML = `
        <td>Total</td>
        <td></td>
        <td>₹ ${totalCgst.toFixed(2)}</td>
        <td>₹ ${totalSgst.toFixed(2)}</td>
        <td>₹ ${totalIgst.toFixed(2)}</td>
        <td>₹ ${totalGstSum.toFixed(2)}</td>
    `;
    gstTableBody.appendChild(totalRow);

    // Step 5: Update combined GST (items + forwarding) in PO table
    document.getElementById('gst_total_input').innerText = `₹ ${totalGstSum.toFixed(2)}`;
}


// Run once on page load
document.addEventListener('DOMContentLoaded', updateGstSummary);
</script>