@include('Admin.Includes.header')
@php
    use App\Models\GeneralSettings;
   
    $settings = GeneralSettings::whereIn('option', ['_gst_percentage'])
        ->pluck('value', 'option');
    $gst_percentage = $settings['_gst_percentage'];
@endphp
<div class="container">
    <h2>Update Order #{{ $order->id }}</h2>

    <form action="{{ route('admin.orders.update', $order->id) }}" method="POST">
        @csrf
        <table class="table">
            <thead>
                <tr>
                    <th rowspan="2">Product Name</th>
                    <th colspan="2" class="text-center">Original Values</th>
                    <th colspan="3" class="text-center">Updated Values</th>
                </tr>
                <tr>
                    <th>Weight (kg)</th>
                    <th>Price ($)</th>
                    <th>Weight (kg)</th>
                    <th>Price ($)</th>
                    <th>GST ($)</th>
                </tr>
            </thead>
            <tbody>
                @php 
                    $totalGst = 0;
                    $deliveryCharges = 0;
                @endphp
                @foreach($order->orderMeta as $meta)
                    @php 
                        $totalGst += $meta->totalGst ?? 0;
                        $deliveryCharges += $meta->delivery_charges ?? 0;
                        
                        $gstMeta = $meta->product->productMeta->firstWhere('option', '_gst');
                        $gstValue = $gstMeta ? $gstMeta->value : 0;
                    @endphp
                    <tr data-gst-value="{{ $gstValue }}">
                        <td>{{ $meta->product_title }}</td>
                        <!-- Original Values -->
                        <td>
                            <input type="text" class="form-control original-weight" 
                                value="{{ number_format($meta->quantity, 3, '.', '')}}" 
                                readonly>
                        </td>
                        <td>
                            <input type="text" class="form-control original-price" 
                                value="{{ number_format($meta->qp_subtotal, 2, '.', '') }}" 
                                readonly>
                        </td>
                        <!-- Updated Values -->
                        <td>
                            <input type="number" class="form-control weight-input" 
                                name="weights[{{ $meta->id }}]" 
                                data-total-price="{{ $meta->qp_subtotal }}" 
                                value="{{ number_format($meta->quantity, 3, '.', '')}}" 
                                step="0.001" min="0.001">
                        </td>
                        <td>
                            <input type="text" class="form-control price-input" 
                                name="prices[{{ $meta->id }}]" 
                                value="{{ number_format($meta->qp_subtotal, 2, '.', '') }}" 
                                readonly>
                        </td>
                        <td>
                            <input type="text" class="form-control gst-input" 
                                name="gst[{{ $meta->id }}]" 
                                value="{{ number_format($meta->totalGst, 2, '.', '') }}" 
                                readonly>
                        </td>
                    </tr>
                @endforeach

                <!-- Summary rows -->
                <tr>
                    <td colspan="3"></td>
                    <td colspan="2" class="text-right"><strong>Subtotal:</strong></td>
                    <td>
                        <input type="text" id="subtotal" class="form-control" value="0.00" readonly>
                    </td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td colspan="2" class="text-right"><strong>Total GST ({{ $gst_percentage }}%):</strong></td>
                    <td>
                        <input type="text" id="totalGst" name="total_gst" class="form-control" 
                               value="{{ number_format($order->totalGst, 2, '.', '') }}" readonly>
                    </td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td colspan="2" class="text-right"><strong>Delivery Charges:</strong></td>
                    <td>
                        <input type="text" id="deliveryCharges" class="form-control" 
                               value="{{ number_format($order->delivery_charges, 2, '.', '') }}" readonly>
                    </td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td colspan="2" class="text-right"><strong>Grand Total:</strong></td>
                    <td>
                        <input type="text" name="grand_total" id="grandTotal" class="form-control" value="0.00" readonly>
                    </td>
                </tr>
            </tbody>
        </table>
        <div style="text-align: end;">
            <button type="submit" class="btn btn-primary">Save Order</button>
        </div>
    </form>
</div>

<style>
    .table thead th {
        text-align: center;
        vertical-align: middle;
    }
    .form-control {
        min-width: 100px;
    }
</style>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
    $(document).ready(function() {
        const GST_PERCENTAGE = {{ $gst_percentage }};

        function calculateGst(amount) {
            return (amount * GST_PERCENTAGE) / 100;
        }

        function updateTotals() {
            let subtotal = 0;
            let totalGst = 0;

            $('.price-input').each(function() {
                const price = parseFloat($(this).val()) || 0;
                // Get GST value from the row's data attribute
                const gstValue = parseFloat($(this).closest('tr').data('gst-value')) || 0;
                let gst = 0;
                if (gstValue === 0) {
                    gst = 0;
                } else {
                    gst = calculateGst(price);
                }
                
                // Update GST for this row
                $(this).closest('tr').find('.gst-input').val(gst.toFixed(2));
                
                subtotal += price;
                totalGst += gst;
            });

            let deliveryCharges = parseFloat($('#deliveryCharges').val()) || 0;
            let grandTotal = subtotal + totalGst + deliveryCharges;

            // Update values in input fields
            $('#subtotal').val(subtotal.toFixed(2));
            $('#totalGst').val(totalGst.toFixed(2));
            $('#grandTotal').val(grandTotal.toFixed(2));
        }

        $('.weight-input').on('input', function() {
            // Get the original price and weight
            let newWeight = parseFloat($(this).val()) || 0;
            let originalWeight = parseFloat($(this).closest('tr').find('.original-weight').val()) || 0;
            let originalPrice = parseFloat($(this).closest('tr').find('.original-price').val()) || 0;
            
            // Calculate the new price proportionally
            let newPrice = 0;
            if (originalWeight > 0) {
                newPrice = (newWeight * (originalPrice / originalWeight)).toFixed(2);
            }
            
            // Update the price input
            $(this).closest('tr').find('.price-input').val(newPrice);
            updateTotals();
        });

        // Initialize all totals on page load
        updateTotals();
    });
</script>

@include('Admin.Includes.footer')