@extends('admin.layouts.app')
@section('title', 'Add New Sale')
@section('container')
    <!-- Page-Title -->
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <div class="float-end">
                    <a href="{{ route('sale.list') }}" class="btn btn-primary"><i class="ti ti-arrow-back-up me-2"></i>
                        Sale List</a>
                </div>
                <h4 class="page-title">Add New Sale</h4>
            </div>
            <!--end page-title-box-->
        </div>
        <!--end col-->
    </div>
    <!-- end page title end breadcrumb -->

    <div class="row">
        @if (session('success'))
            <div class="alert alert-info">
                <ul>
                    {{ session('success') }}
                </ul>
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger">
                <ul>
                    {{ session('error') }}
                </ul>
            </div>
        @endif
    </div>
    {{-- <div class="row">
        @if ($errors->any())
            <div class="alert alert-danger">
                <ul>
                    @foreach ($errors->all() as $error)
                        <li>{{ $error }}</li>
                    @endforeach
                </ul>
            </div>
        @endif
    </div> --}}

    <div class="row">
        <div class="col-lg-12">
            <form method="POST" action="{{ route('sale.store') }}" class="form" enctype="multipart/form-data">
                @csrf
                <div class="card">

                    <!--end card-header-->
                    <div class="card-body">

                        <div class="row">
                            <div class="col-md-3">
                                <div class="mb-2">
                                    <label for="name" class="mb-2">Client</label>
                                    <select name="client" id="client" class="form-control select2">
                                        <option value="">Select One</option>
                                        @foreach ($clients as $client)
                                            <option data-due="{{ ($client->due) }}" value="{{ $client->id }}"
                                                {{ old('client') == $client->id ? 'selected' : '' }}>
                                                {{ $client->name }}
                                                @if($client->due > 0)
                                                    - Due: {{ number_format($client->due,2) }}
                                                @elseif($client->due < 0)
                                                    - Advance: {{ number_format(abs($client->due),2) }}
                                                @endif

                                            </option>
                                        @endforeach
                                    </select>
                                    <span id="client_due" style="font-size: 16px;"></span>
                                    @error('client')
                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="mb-2">
                                    <button id="add_new_customer_form" class="btn btn-dark" style="margin-top: 28px;"><i class="fas fa-plus"></i></button>
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="mb-2">
                                    <label for="date" class="mb-2">Sale Date</label>
                                    <input type="date" name="date" value="{{ old('date',$lastSaleorder->date ?? date('Y-m-d')) }}" id="date"
                                        class="form-control">
                                    @error('date')
                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                    @enderror
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-2">
                                    <label for="notes" class="mb-2">Notes</label>
                                    <input type="text" placeholder="Enter Notes" name="notes" value="{{ old('notes') }}" id="notes"
                                        class="form-control">
                                    @error('notes')
                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                    @enderror
                                </div>
                            </div>
                        </div>
                    </div>
                    <!--end card-body-->
                    <div class="card-body">

                        <div class="row">
                            <div class="col-md-12">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="white-space: nowrap">Product Name</th>
                                            <th style="white-space: nowrap">Quantity</th>
                                            <th style="white-space: nowrap">Unit Price</th>
                                            <th style="white-space: nowrap">Stock(Pcs)</th>
                                            <th style="white-space: nowrap">Total</th>
                                            <th></th>
                                        </tr>
                                    </thead>
                                    <tbody id="product-container">

                                        @if (old('product') != null && sizeof(old('product')) > 0)
                                            @foreach (old('product') as $key => $item)
                                                <tr class="product-item">
                                                    <td>
                                                        <div class="form-group {{ $errors->has('product.' . $key) ? 'is-invalid' : '' }}"
                                                            style="min-width: 200px;">
                                                            <select class="form-control product default-select"
                                                                style="width: 100%;" id="product" name="product[]"
                                                                required>
                                                                <option value="">Select Product</option>
                                                                @foreach ($products as $product)
                                                                    <option
                                                                        {{ old('product.' . $key) == $product->id ? 'selected' : '' }}
                                                                        value="{{ $product->id }}">
                                                                        {{ $product->productSubCategory->name ?? ''}} - {{ $product->name }}
                                                                    </option>
                                                                @endforeach

                                                            </select>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div
                                                            class="form-group {{ $errors->has('quantity.' . $loop->index) ? 'is-invalid' : '' }}">
                                                            <input type="number" step="any"
                                                                   class="form-control quantity" name="quantity[]"
                                                                   value="{{ old('quantity.' . $loop->index) }}" required>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div
                                                            class="form-group {{ $errors->has('unit_price.' . $loop->index) ? 'is-invalid' : '' }}">
                                                            <input type="number" step="any"
                                                                   class="form-control unit_price" name="unit_price[]"
                                                                   value="{{ old('unit_price.' . $loop->index) }}">
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div class="form-group {{ $errors->has('stock.' . $key) ? 'is-invalid' : '' }}">
                                                            <input type="text" step="any"
                                                                   class="form-control stock is-valid-border"
                                                                   name="stock[]" value="{{ old('stock.' . $loop->index) }}" readonly>
                                                        </div>
                                                    </td>
                                                    <td class="total-cost" style="vertical-align: middle">৳0.00</td>
                                                    <td class="text-center">
                                                        <a role="button" class="btn-sm btn-remove"
                                                            style="cursor: pointer;"><i style="font-size: 20px; color:red;"
                                                                class="feather icon-trash-2"></i></a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @else
                                            <tr class="product-item">
                                                <td>
                                                    <div class="form-group product_area" style="min-width: 200px;">
                                                        <select class="form-select default-select product" id="default"
                                                            required style="width: 100%;" name="product[]">
                                                            <option value="">Select Product</option>
                                                            @foreach ($products as $product)
                                                                <option value="{{ $product->id }}">
                                                                    {{ $product->productSubCategory->name ?? ''}} - {{ $product->name }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                        <input type="hidden" name="product_name[]" class="product_name">
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="form-group">
                                                        <input type="number" step="any"
                                                               class="form-control quantity is-valid-border" required
                                                               name="quantity[]">
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="form-group">
                                                        <input type="text" step="any"
                                                               class="form-control unit_price is-valid-border"
                                                               name="unit_price[]" required>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="form-group">
                                                        <input type="text" step="any"
                                                               class="form-control stock is-valid-border"
                                                               name="stock[]" readonly>
                                                    </div>
                                                </td>
                                                <td class="total-cost" style="vertical-align: middle">৳0.00</td>
                                                <td class="text-center">
                                                    <a role="button" class="btn btn-danger btn-remove btn-close "
                                                        style="cursor: pointer;"><i class="feather icon-trash-2"></i></a>
                                                </td>
                                            </tr>


                                        @endif
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td>
                                                <a role="button" class="btn btn-info btn-sm" id="btn-add-product">Add
                                                    Product</a>
                                            </td>
                                            <th colspan="3" class="text-end">Total Amount</th>

                                            <th id="total_amount">৳0.00</th>
                                            <td></td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>

                        </div>
                        <div class="row">
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-header with-border">
                                        <h3 class="card-title">Payment</h3>
                                    </div>
                                    <div class="card-body">
                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="form-group mb-2">
                                                    <label class="mb-2">Payment Type</label>
                                                    <select class="form-select is-valid-border select2"
                                                        name="payment_type" id="payment_type">
                                                        <option value="">Select Option</option>
                                                        <option value="1"
                                                            {{ old('payment_type',1) == '1' ? 'selected' : '' }}>Cash
                                                        </option>
                                                        <option value="2"
                                                            {{ old('payment_type') == '2' ? 'selected' : '' }}>Bank
                                                        </option>
                                                    </select>
                                                    @error('payment_type')
                                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                                    @enderror
                                                </div>
                                                <div id="isBankNature">
                                                    <div class="form-group mb-2">
                                                        <label class="mb-2">Bank</label>
                                                        <select class="form-control is-valid-border select2"
                                                            name="bank">
                                                            <option value="">Select Bank</option>
                                                            @foreach ($banks as $bank)
                                                                <option
                                                                    value="{{ $bank->id }}"{{ old('bank') == $bank->id ? ' selected' : '' }}>
                                                                    {{ $bank->bank_name }} (Ac : {{ $bank->ac_number }})
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                        @error('bank')
                                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                                        @enderror
                                                    </div>
                                                    <div class="form-group mb-2 ">
                                                        <label>Type</label>
                                                        <select class="form-control select2 modal_bank_type" name="bank_type">
                                                            <option value="1">Bank Transfer</option>
                                                            <option value="2">Cheque</option>
                                                        </select>
                                                        @error('bank_type')
                                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                                        @enderror
                                                    </div>
                                                    <div class="form-group mb-2 bank_check_area">
                                                        <label class="mb-2">Cheque No.</label>
                                                        <input class="form-control is-valid-border" type="text"
                                                            name="cheque_no" placeholder="Enter Cheque No."
                                                            value="{{ old('cheque_no') }}">
                                                        @error('cheque_no')
                                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                                        @enderror
                                                    </div>
                                                    <div class="form-group mb-2 bank_check_area">
                                                        <label>Cheque Date</label>
                                                        <div class="input-group date">
                                                            <div class="input-group-addon">
                                                                <i class="fa fa-calendar"></i>
                                                            </div>
                                                            <input type="date" class="form-control pull-right" id="check_date" name="check_date" value="{{ date('Y-m-d') }}" autocomplete="off">
                                                        </div>
                                                        @error('check_date')
                                                        <p class="mt-1 text-danger">{{ $message }}</p>
                                                        @enderror
                                                    </div>
                                                    {{-- <div class="form-group">
                                                        <label class="mb-2">Cheque Image.</label>
                                                        <input type="file" name="cheque_image"
                                                            class="form-control value="{{ old('cheque_image') }}">
                                                        @error('cheque_image')
                                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                                        @enderror
                                                    </div> --}}
                                                </div>
                                            </div>

                                            <div class="col-md-6">
                                                <table class="table table-bordered">

                                                    <tr>
                                                        <th colspan="4" class="text-right">Sub Total</th>
                                                        <th>
                                                            <input type="number" step="any" id="sub_total" readonly
                                                                class="form-control sub_total is-valid-border"
                                                                value="{{ old('sub_total') }}" name="sub_total">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right"> Discount</th>
                                                        <th>
                                                            <input type="number" step="any" id="discount"
                                                                value="{{ old('discount',0) }}"
                                                                class="form-control discount is-valid-border"
                                                                name="discount">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right"> Transport Cost</th>
                                                        <th>
                                                            <input type="number" step="any" id="transport_cost"
                                                                value="{{ old('transport_cost',0) }}"
                                                                class="form-control transport_cost is-valid-border"
                                                                name="transport_cost">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right">Labour Charge</th>
                                                        <th>
                                                            <input type="number" step="any" id="labour_charge"
                                                                value="{{ old('labour_charge',0) }}"
                                                                class="form-control labour_charge is-valid-border"
                                                                name="labour_charge">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right">Sales Goods Return</th>
                                                        <th>
                                                            <input type="number" step="any" id="sales_goods_return"
                                                                value="{{ old('sales_goods_return',0) }}"
                                                                class="form-control sales_goods_return is-valid-border"
                                                                name="sales_goods_return">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right">Old Battery</th>
                                                        <th>
                                                            <input type="number" step="any" id="old_battery"
                                                                value="{{ old('old_battery',0) }}"
                                                                class="form-control old_battery is-valid-border"
                                                                name="old_battery">
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right">Grand Total</th>
                                                        <th>
                                                            <input type="text" step="any"
                                                                class="form-control grand_total_price is-valid-border"
                                                                name="grand_total_price" readonly>
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right"> Paid *</th>
                                                        <td>
                                                            <div
                                                                class="form-group paid {{ $errors->has('paid') ? 'has-error' : '' }}">
                                                                <input type="text" style="border: 2px solid #2a28a7"
                                                                    class="form-control is-valid-border" name="paid"
                                                                    id="paid" value="{{ old('paid', 0) }}" required>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <th colspan="4" class="text-right">Due</th>
                                                        <th id="due">৳0.00</th>
                                                    </tr>
                                                </table>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!--end card-body-->
                    <div class="card-footer">
                        <div class="text-end">
                            <button class="btn btn-primary" type="submit">Add Sale</button>
                        </div>
                    </div>
                </div>
                <!--end card-->


                <!--end card-->
            </form>
            <!--end form-->
        </div> <!-- end col -->
    </div> <!-- end row -->
    <template id="template-product">
        <tr class="product-item">
            <td>
                <div class="form-group product_area" style="min-width: 200px;">
                    <select class="form-select default-select product" style="width: 100%;" name="product[]" required>
                        <option value="">Select Product</option>
                        @foreach ($products as $product)
                            <option value="{{ $product->id }}">
                                {{ $product->productSubCategory->name ?? ''}} - {{ $product->name }}
                            </option>
                        @endforeach
                    </select>
                    <input type="hidden" name="product_name[]" class="product_name">
                </div>
            </td>
            <td>
                <div class="form-group">
                    <input type="number" step="any" class="form-control quantity is-valid-border" name="quantity[]"
                           required>
                </div>
            </td>
            <td>
                <div class="form-group">
                    <input type="text" step="any" class="form-control unit_price is-valid-border"
                           name="unit_price[]" required>
                </div>
            </td>
            <td>
                <div class="form-group">
                    <input type="text" step="any"
                           class="form-control stock is-valid-border"
                           name="stock[]" readonly>
                </div>
            </td>
            <td class="total-cost" style="vertical-align: middle">৳0.00</td>
            <td class="text-center">

                <a role="button" class="btn btn-danger btn-remove btn-close " style="cursor: pointer;"><i
                        class="feather icon-trash-2"></i></a>
            </td>

        </tr>
    </template>
    <!-- Modal for new Customer-->
    <div class="modal fade" id="newCustomerModal" tabindex="-1" aria-labelledby="newCustomerModalLabel" aria-hidden="true">
        <div class="modal-dialog" style="min-width: 50% !important">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title" style="margin-left: 41% !important" id="newCustomerModalLabel">Customer Info</h4>
                    <button type="button" class="btn btn-dark close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <form style="font-size: 12px;" enctype="multipart/form-data" id="newCustomerForm">
                        <div class="container">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="name">Customer Name</label>
                                        <div class="input-group name">
                                            <input type="text" class="form-control new_customer {{ $errors->has('name') ? 'is-invalid' :'is-valid-border' }}" name="name" value="{{ old('name') }}" placeholder="Name" >
                                        </div>
                                        @error('name')
                                        <span class="invalid-feedback">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="opening_due">Email</label>
                                        <div class="input-group email">
                                            <input type="text" class="form-control {{ $errors->has('email') ? 'is-invalid' :'is-valid-border' }}" name="email" placeholder="Email" >
                                        </div>
                                        @error('email')
                                        <span class="invalid-feedback">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="email">Phone</label>
                                        <div class="input-group phone">
                                            <input type="text" class="form-control {{ $errors->has('phone') ? 'is-invalid' :'is-valid-border' }}" name="phone" value="{{ old('phone') }}" placeholder="Phone" >
                                        </div>
                                        @error('phone')
                                        <span class="invalid-feedback">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="address">Address</label>
                                        <div class="input-group address">
                                            <textarea class="form-control is-valid-border" rows="1" name="address"></textarea>
                                        </div>
                                        @error('address')
                                        <span class="invalid-feedback">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-danger close" data-dismiss="modal">Close</button>
                            <button type="submit" class="btn btn-dark">Save</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('scripts')
    <script>
        $('#client').change(function () {
            var dueAmount = $(this).find(':selected').data('due'); // Get the data-due value
            if (dueAmount > 0) {
                $('#client_due').text('Due: ' + dueAmount).css('color', 'red');
            } else if (dueAmount < 0) {
                $('#client_due').text('Advance: ' + Math.abs(dueAmount)).css('color', 'green');
            } else {
                $('#client_due').text('').css('color', 'black');
            }
        });


        document.querySelectorAll('.default-select').forEach(function(element) {
            new Selectr(element);
        });
        $(function() {
            addProduct__delete();
            calculate();
            $('.select2').select2();
            $('#add_new_customer_form').click(function () {
                $('#newCustomerModal').modal('show');
            });
            $('#newCustomerForm').submit(function (e) {
                e.preventDefault();
                let formData = new FormData($('#newCustomerForm')[0]);

                $.ajax({
                    method: "Post",
                    url: "{{ route('client.add_ajax_customer') }}",
                    data: formData,
                    processData: false,
                    contentType: false,
                }).done(function (response) {
                    if (response.success) {
                        $('#newCustomerModal').modal('hide');
                        $("#client").append('<option value="'+response.customer.id+'" selected>'+response.customer.name+'</option>');
                        //$('.customer').trigger('change');
                    } else {
                        Swal.fire({
                            icon: 'error',
                            title: 'Oops...',
                            text: response.message,
                        });
                    }
                });
            });

            $(document).on('change','.product2',function() {
                var productId = $(this).closest('tr').find('.product').val();

                var type2 = $(this);
                type2.closest('tr').find('.stock').val(' ');
                type2.closest('tr').find('.unit_price').val(' ');
                if (productId != '') {
                    $.ajax({
                        method: "GET",
                        url: "{{ route('get_product_inventory') }}",
                        data: {
                            type: 'Normal_Sale',
                            productId: productId,
                        }
                    }).done(function(response) {
                        console.log(response);
                        type2.closest('tr').find('.stock').val(response.stock);
                        type2.closest('tr').find('.unit_price').val((response.unit_price).toFixed(2));
                    });
                }
            });

            $(document).on('change','.product',function() {
                var productId = $(this).closest('tr').find('.product').val();

                var type2 = $(this);
                type2.closest('tr').find('.stock').val(' ');
                type2.closest('tr').find('.unit_price').val(' ');
                if (productId != '') {
                    $.ajax({
                        method: "GET",
                        url: "{{ route('get_product_inventory') }}",
                        data: {
                            type: 'Normal_Sale',
                            productId: productId,
                        }
                    }).done(function(response) {
                        console.log(response);
                        type2.closest('tr').find('.stock').val(response.stock);
                        type2.closest('tr').find('.unit_price').val((response.unit_price).toFixed(2));
                    });
                }
            });

            $('#payment_type').change(function() {

                if ($(this).val() == '2') {
                    $('#isBankNature').show();
                } else {
                    $('#isBankNature').hide();
                }
            });
            $('.modal_bank_type').change(function () {
                if ($(this).val() == '1') {
                    $('.bank_check_area').hide();
                } else {
                    $('.bank_check_area').show();
                }
            });
            $('.modal_bank_type').trigger('change');

            $('body').on('keyup',
                '.quantity, .unit_price,.discount,.transport_cost,.labour_charge,.sales_goods_return,.old_battery,.selling_price',
                function() {
                    calculate();
                });
            $('body').on('change',
                '.quantity, .unit_price,.discount,.transport_cost,.labour_charge,.sales_goods_return,.old_battery,.selling_price',
                function() {
                    calculate();
                });
            $('body').on('keyup',
                '#paid',
                function() {
                    var paid = $(this).val();
                    var gt = $('.grand_total_price').val();
                    $('#due').html('৳' + (gt - paid).toFixed(2));
                });

            $('#payment_type').trigger('change')
        });

        function addProduct__delete() {
            $('#btn-add-product').click(function() {
                let html = $('#template-product').html();
                let item = $(html);
                $('#product-container').append(item);
                $('.select2').select2();
                let defaultSelect = item.find('.default-select');

                if (defaultSelect.length > 0) {
                    new Selectr(defaultSelect[0]);
                }

                if ($('.product-item').length >= 1) {
                    $('.btn-remove').show();
                }

            });
            $('body').on('click', '.btn-remove', function() {
                $(this).closest('.product-item').remove();
                calculate();
                if ($('.product-item').length <= 1) {
                    $('.btn-remove').hide();
                }
            });
            if ($('.product-item').length <= 1) {
                $('.btn-remove').hide();
            } else {
                $('.btn-remove').show();
            }
        }

        function calculate() {
            let productSubTotal = 0;

            let discount = $('.discount').val();
            if (discount == '' || discount < 0 || !$.isNumeric(discount)) {
                discount = 0;
            }

            let transport_cost = $('.transport_cost').val();
            if (transport_cost == '' || transport_cost < 0 || !$.isNumeric(transport_cost)) {
                transport_cost = 0;
            }
            let labour_charge = $('.labour_charge').val();
            if (labour_charge == '' || labour_charge < 0 || !$.isNumeric(labour_charge)) {
                labour_charge = 0;
            }
            let sales_goods_return = $('.sales_goods_return').val();
            if (sales_goods_return == '' || sales_goods_return < 0 || !$.isNumeric(sales_goods_return)) {
                sales_goods_return = 0;
            }

            let old_battery = $('.old_battery').val();
            if (old_battery == '' || old_battery < 0 || !$.isNumeric(old_battery)) {
                old_battery = 0;
            }




            $('.product-item').each(function(i) {
                let product_rate = $('.unit_price').eq(i).val();
                let quantity = $('.quantity').eq(i).val();

                if (product_rate == '' || product_rate < 0 || !$.isNumeric(product_rate)) {
                    product_rate = 0;
                }
                if (quantity == '' || quantity < 0 || !$.isNumeric(quantity)) {
                    quantity = 0;
                }
                let row_total_cost = quantity * product_rate;

                $('.total-cost').eq(i).html('৳' + (row_total_cost).toFixed(2));
                productSubTotal += row_total_cost;
            });

            $('#total_amount').html('৳' + productSubTotal.toFixed(2));

            $('#sub_total').val(productSubTotal.toFixed(2));
            $('#product_sub_total').html('৳' + productSubTotal.toFixed(2));

            let grandTotal = parseFloat(productSubTotal - discount) + parseFloat(transport_cost) + parseFloat(labour_charge) - parseFloat(sales_goods_return) - parseFloat(old_battery);

            //$('#paid').val(grandTotal.toFixed(2));
            let paid = $('#paid').val() || 0;

            let due = parseFloat(grandTotal) - parseFloat(paid);
            if (due < 0) {
                //confirm('Due amount is not negative');
            }
            $('.grand_total_price').val(grandTotal.toFixed(2));
            $('#due').html('৳' + due.toFixed(2));
        }
    </script>
@endpush