@if (!$freightDatas->isEmpty())
<div class="col-sm-12 col-12 mt-3">
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>S.no</th>
                <th>GR No</th>
                <th>Dispatch Date</th>
                <th>Truck No.</th>
                <th>Party Name</th>
                <th>From</th>
                <th>To</th>
                <th>Sub Total</th>
                <th>+ Halting</th>
                <th>+ Extra charge</th>
                <th>Any Deduction</th>
                <th>Net Amount</th>
                <th>
                    <input type="checkbox" value="1" id="checkall">
                    <label for="checkall">&nbsp; Select All</label>
                </th>
            </tr>
        </thead>
        <tbody>
            @php $rowNum = 1; @endphp
            @foreach ($freightDatas as $freight)
            @php
            $items = $freight->items ?? collect();
            $itemCount = $items->count() > 0 ? $items->count() : 1;
            @endphp

            @forelse($items as $itemIndex => $item)
            <tr>
                {{-- Freight Details (Rowspan for all items) --}}
                @if ($itemIndex === 0)
                <td rowspan="{{ $itemCount }}">{{ $rowNum }}</td>
                <td rowspan="{{ $itemCount }}">{{ $freight->lr_no }}</td>
                <td rowspan="{{ $itemCount }}">{{ date('d-M-Y', strtotime($freight->date)) }}</td>
                <td rowspan="{{ $itemCount }}">{{ $freight->vehicle->vehicle_no ?? '' }}</td>
                <td rowspan="{{ $itemCount }}">
                    @php
                    $partyName = \App\Http\Helpers\CommonHelper::getPartyByFreightPaidBy(
                    $freight->id,
                    $freight->paid_by,
                    );
                    @endphp
                    {{ $partyName }}
                </td>
                <td rowspan="{{ $itemCount }}">{{ $freight->from_location }}</td>
                <td rowspan="{{ $itemCount }}">{{ $freight->to_location }}</td>
                <td rowspan="{{ $itemCount }}">
                    <input type="text" class="form-control floatnumber readonly" value="{{ number_format($freight->sub_total, 2) }}" readonly>
                </td>
                @endif

                {{-- Item Details --}}
                {{-- <td>{{ $item->material_name ?? '-' }}</td>
                <td>{{ $item->hsn_code ?? '-' }}</td>
                <td>{{ $item->actual_weight ?? '-' }}</td> --}}
                {{-- <td>
                                <input type="text" name="rate[]" class="form-control floatnumber rate-input"
                                    value="{{ $item->rate ?? 0 }}" data-freight-id="{{ $freight->id }}" readonly>
                </td> --}}
                {{-- @php
                                $totalMaterialAmount = $freight->items->sum('amount');
                            @endphp

                            <td>
                                <input type="text" name="freight_amount[]"
                                    class="form-control floatnumber freight-amount"
                                    value="{{ number_format($totalMaterialAmount > 0 ? $totalMaterialAmount : $freight->net_total, 2) }}"
                readonly>
                </td> --}}

                {{-- Charges (Only on first item row) --}}
                @if ($itemIndex === 0)
                <td rowspan="{{ $itemCount }}">
                    <input type="text" name="halting[]" class="form-control floatnumber halting"
                        value="0" data-freight-id="{{ $freight->id }}">
                </td>
                <td rowspan="{{ $itemCount }}">
                    <input type="text" name="extra_charge[]"
                        class="form-control floatnumber extra_charge" value="0"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td rowspan="{{ $itemCount }}">
                    <input type="text" name="any_deduction[]"
                        class="form-control floatnumber any_deduction" value="0"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td rowspan="{{ $itemCount }}">
                    <input type="text" name="net_amount[]"
                        class="form-control floatnumber readonly net_amount"
                        value="{{ number_format($freight->sub_total, 2) }}" readonly
                        data-freight-id="{{ $freight->id }}">
                    <input type="hidden" name="party_total[]" value="{{ $freight->sub_total }}"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td rowspan="{{ $itemCount }}">
                    <input type="checkbox" class="form-check-input check" name="freight_check[]"
                        value="{{ $freight->id }}" data-freight-id="{{ $freight->id }}">
                </td>
                @endif
            </tr>
            @empty
            {{-- No items, show freight row with minimal data --}}
            <tr>
                <td>{{ $rowNum }}</td>
                <td>{{ $freight->lr_no }}</td>
                <td>{{ date('d-M-Y', strtotime($freight->date)) }}</td>
                <td>{{ $freight->vehicle->vehicle_no ?? '' }}</td>
                <td>
                    @php
                    $partyName = \App\Http\Helpers\CommonHelper::getPartyByFreightPaidBy(
                    $freight->id,
                    $freight->paid_by,
                    );
                    @endphp
                    {{ $partyName }}
                </td>
                <td>{{ $freight->from_location }}</td>
                <td>{{ $freight->to_location }}</td>
                <td>
                    <input type="text" class="form-control floatnumber readonly" value="{{ number_format($freight->sub_total, 2) }}" readonly>
                </td>
                <td>
                    <input type="text" name="halting[]" class="form-control floatnumber halting"
                        value="0" data-freight-id="{{ $freight->id }}">
                </td>
                <td>
                    <input type="text" name="extra_charge[]"
                        class="form-control floatnumber extra_charge" value="0"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td>
                    <input type="text" name="any_deduction[]"
                        class="form-control floatnumber any_deduction" value="0"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td>
                    <input type="text" name="net_amount[]"
                        class="form-control floatnumber readonly net_amount"
                        value="{{ number_format($freight->sub_total, 2) }}" readonly
                        data-freight-id="{{ $freight->id }}">
                    <input type="hidden" name="party_total[]" value="{{ $freight->sub_total }}"
                        data-freight-id="{{ $freight->id }}">
                </td>
                <td>
                    @php
                    $partyId = match ($freight->paid_by) {
                    'Consignor' => $freight->consignor_id,
                    'Consignee' => $freight->consignee_id,
                    'Transporter' => $freight->party_id,
                    };
                    @endphp

                    <input type="checkbox" class="form-check-input check" value="{{ $freight->id }}"
                        data-freight-id="{{ $freight->id }}" data-party-id="{{ $partyId }}">

                </td>
            </tr>
            @endforelse
            @php $rowNum++; @endphp
            @endforeach
        </tbody>
    </table>
</div>

{{-- ================= JS ================= --}}
<script>
    // Allow only numbers
    $('.floatnumber').on('input', function() {
        this.value = this.value.replace(/[^0-9.]/g, '')
            .replace(/(\..*)\./g, '$1');
    });

    // Select all
    $('#checkall').on('change', function() {
        $('.check').prop('checked', this.checked);
    });

    // Recalculate net amount on any change
    function recalculateNetAmount(freightId) {
        const rows = document.querySelectorAll(`input[data-freight-id="${freightId}"]`);
        const row = rows[0].closest('tr');

        // Get base amount
        const baseAmount = parseFloat(
            row.querySelector(`input[name="party_total[]"][data-freight-id="${freightId}"]`).value
        ) || 0;

        // Get all charges for this freight
        const halting = parseFloat(
            row.querySelector(`input[name="halting[]"][data-freight-id="${freightId}"]`).value
        ) || 0;

        const extraCharge = parseFloat(
            row.querySelector(`input[name="extra_charge[]"][data-freight-id="${freightId}"]`).value
        ) || 0;

        const deduction = parseFloat(
            row.querySelector(`input[name="any_deduction[]"][data-freight-id="${freightId}"]`).value
        ) || 0;

        // Calculate final amount
        let finalAmount = baseAmount + halting + extraCharge - deduction;

        row.querySelector(`input[name="net_amount[]"][data-freight-id="${freightId}"]`).value =
            Math.max(0, finalAmount).toFixed(2);
    }

    $(document).on('input', '.halting', function() {
        const freightId = $(this).data('freight-id');
        recalculateNetAmount(freightId);
    });

    $(document).on('input', '.extra_charge', function() {
        const freightId = $(this).data('freight-id');
        recalculateNetAmount(freightId);
    });

    $(document).on('input', '.any_deduction', function() {
        const freightId = $(this).data('freight-id');
        recalculateNetAmount(freightId);
    });


    // $(document).on('input', '.rate-input', function() {
    //     const freightId = $(this).data('freight-id');
    //     const rate = parseFloat($(this).val()) || 0;
    //     const qty = parseFloat($(this).closest('tr').find('td:nth-child(10)').text()) || 0;
    //     const amount = (rate * qty).toFixed(2);

    //     $(this).closest('tr').find('.freight-amount').val(amount);
    // });


    // Proceed to Generate Invoice
    // function proceedToGenerateInvoice() {
    //     const selectedGRs = [];
    //     const party_id = $('#party_id').val();

    //     if (!party_id) {
    //         alert('Please select a party first.');
    //         return;
    //     }

    //     // Collect all checked freight entries
    //     $('.check:checked').each(function() {
    //         const freightId = $(this).data('freight-id');
    //         const row = $(this).closest('tr');

    //         // Get all the values for this freight entry
    //         const halting = parseFloat(row.find(`input[name="halting[]"][data-freight-id="${freightId}"]`)
    //         .val()) || 0;
    //         const extraCharge = parseFloat(row.find(
    //             `input[name="extra_charge[]"][data-freight-id="${freightId}"]`).val()) || 0;
    //         const deduction = parseFloat(row.find(
    //             `input[name="any_deduction[]"][data-freight-id="${freightId}"]`).val()) || 0;
    //         const netAmount = parseFloat(row.find(`input[name="net_amount[]"][data-freight-id="${freightId}"]`)
    //             .val()) || 0;

    //         selectedGRs.push({
    //             freight_id: freightId,
    //             halting: halting,
    //             extra_charge: extraCharge,
    //             any_deduction: deduction,
    //             net_amount: netAmount
    //         });
    //     });

    //     if (selectedGRs.length === 0) {
    //         alert('Please select at least one GR to proceed.');
    //         return;
    //     }

    //     // Create a form and submit
    //     const form = $('<form>', {
    //         method: 'POST',
    //         action: '{{ route('freight-billing.proceedToInvoice') }}'
    //     });

    //     // Add CSRF token
    //     form.append($('<input>', {
    //         type: 'hidden',
    //         name: '_token',
    //         value: '{{ csrf_token() }}'
    //     }));

    //     // Add party_id
    //     form.append($('<input>', {
    //         type: 'hidden',
    //         name: 'party_id',
    //         value: party_id
    //     }));

    //     // Add selected GRs data
    //     form.append($('<input>', {
    //         type: 'hidden',
    //         name: 'selected_grs',
    //         value: JSON.stringify(selectedGRs)
    //     }));

    //     // Append form to body and submit
    //     $('body').append(form);
    //     form.submit();
    // }
    function proceedToGenerateInvoice() {

        const selectedGRs = [];
        let detectedPartyId = null;
        let invalidPartySelection = false;

        $('.check:checked').each(function() {

            const freightId = $(this).data('freight-id');
            const partyId = $(this).data('party-id');

            // Detect first party
            if (!detectedPartyId) {
                detectedPartyId = partyId;
            }

            // If another party found → error
            if (detectedPartyId != partyId) {
                invalidPartySelection = true;
            }

            const row = $(this).closest('tr');

            const halting = parseFloat(row.find(`input[name="halting[]"][data-freight-id="${freightId}"]`)
                .val()) || 0;
            const extraCharge = parseFloat(row.find(
                `input[name="extra_charge[]"][data-freight-id="${freightId}"]`).val()) || 0;
            const deduction = parseFloat(row.find(
                `input[name="any_deduction[]"][data-freight-id="${freightId}"]`).val()) || 0;
            const netAmount = parseFloat(row.find(`input[name="net_amount[]"][data-freight-id="${freightId}"]`)
                .val()) || 0;

            selectedGRs.push({
                freight_id: freightId,
                halting: halting,
                extra_charge: extraCharge,
                any_deduction: deduction,
                net_amount: netAmount
            });
        });

        if (selectedGRs.length === 0) {
            alert('Please select at least one GR to proceed.');
            return;
        }

        if (invalidPartySelection) {
            alert('All selected GR must belong to same party.');
            return;
        }

        // Create form
        const form = $('<form>', {
            method: 'POST',
            action: '{{ route('freight-billing.proceedToInvoice') }}'

        });

        form.append($('<input>', {
            type: 'hidden',
            name: '_token',
            value: '{{ csrf_token() }}'
        }));

        form.append($('<input>', {
            type: 'hidden',
            name: 'party_id',
            value: detectedPartyId
        }));

        form.append($('<input>', {
            type: 'hidden',
            name: 'selected_grs',
            value: JSON.stringify(selectedGRs)
        }));

        $('body').append(form);
        form.submit();
    }

    // Auto-remove 0 or 0.00 on focus for inputs, restore on blur if empty
    $(document).on('focus', 'input[type="number"], input[type="text"]', function() {
        var val = $(this).val();
        if (val === '0' || val === '0.00') {
            $(this).data('zero-val', val);
            $(this).val('');
        } else {
            $(this).data('zero-val', null);
        }
    });
    $(document).on('blur', 'input[type="number"], input[type="text"]', function() {
        if ($(this).val() === '' && $(this).data('zero-val')) {
            $(this).val($(this).data('zero-val'));
            $(this).trigger('input'); // Trigger input so calculations can run
            $(this).trigger('change');
        }
    });
</script>
@else
<p class="text-danger fw-bold">Data Not Found</p>
@endif