@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>Amount</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>
            @foreach($freightDatas as $i => $row1)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $row1->lr_no }}</td>
                    <td>{{ date('d-M-Y', strtotime($row1->date)) }}</td>
                    <td>{{ $row1->vehicle->vehicle_no ?? '' }}</td>
                    <td>
                        @php
                            $partyName = \App\Http\Helpers\CommonHelper::getPartyByFreightPaidBy(
                                $row1->id,
                                $row1->paid_by
                            );
                        @endphp
                        {{ $partyName }}
                    </td>
                    <td>{{ $row1->from_location }}</td>
                    <td>{{ $row1->to_location }}</td>

                    {{-- ✅ BASE AMOUNT (NET TOTAL FROM FREIGHT ENTRY) --}}
                    <td>
                        {{ number_format($row1->net_total, 2) }}
                        <input type="hidden"
                               name="party_total[]"
                               value="{{ $row1->net_total }}">
                    </td>

                    {{-- Any Deduction --}}
                    <td>
                        <input type="text"
                               name="any_deduction[]"
                               class="form-control floatnumber any_deduction"
                               value="0">
                    </td>

                    {{-- Final Net Amount --}}
                    <td>
                        <input type="text"
                               name="net_amount[]"
                               class="form-control floatnumber readonly net_amount"
                               value="{{ number_format($row1->net_total, 2) }}"
                               readonly>
                    </td>

                    {{-- Select --}}
                    <td>
                        <input type="checkbox"
                               class="form-check-input check"
                               name="freight_check[]"
                               value="{{ $row1->id }}">
                    </td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </div>

    {{-- Invoice Date --}}
    <div class="col-md-3 col-12">
        <label class="form-label">Invoice Date <span class="text-danger">*</span></label>
        <input type="date"
               class="form-control"
               name="invoice_date"
               value="{{ date('Y-m-d') }}"
               min="{{ date('Y-m-d', strtotime($company_details['company']->year_from ?? date('Y-m-d'))) }}"
               required>
    </div>

    {{-- Invoice No --}}
    <div class="col-md-3 col-12">
        <label class="form-label">Invoice No <span class="text-danger">*</span></label>
        <input type="text"
               class="form-control"
               name="invoice_no"
               readonly
               value="{{ 'FB/' . date('Y') . '/' . str_pad($freightBillCount + 1, 3, '0', STR_PAD_LEFT) }}">
    </div>

    {{-- Bank --}}
    <div class="col-md-3 col-12">
        <label class="form-label">
            Select Bank
            <button type="button"
                    class="btn btn-sm btn-primary"
                    data-bs-toggle="modal"
                    data-bs-target="#BankModel"
                    style="border-radius:15px;height:20px;width:20px;">
                <i class="ri-add-line ri-sm"></i>
            </button>
        </label>
        {!! Form::select(
            'client_bank_id',
            [''=>'--Select--'] + $bank,
            old('client_bank_id'),
            ['class'=>'form-control select2']
        ) !!}
    </div>

    {{-- Submit --}}
    <div class="col-sm-12 col-12 mt-3">
        <button type="submit" class="btn btn-success">
            Submit
        </button>
    </div>

    @include('common.modal.bank')

    {{-- ================= 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);
        });

        // deduction calculation
        $(document).on('input', '.any_deduction', function () {
            let row = $(this).closest('tr');

            let baseAmount = parseFloat(
                row.find('input[name="party_total[]"]').val()
            ) || 0;

            let deduction = parseFloat($(this).val()) || 0;

            let finalAmount = baseAmount - deduction;

            row.find('.net_amount')
               .val(finalAmount.toFixed(2));
        });
    </script>
@else
    <p class="text-danger fw-bold">Data Not Found</p>
@endif