@extends('admin.layout.app')
@section('title','Edit Sales Invoice')
@push('headerscript')
    <link href="{{asset('theme/plugins/bootstrap-sweetalert/sweet-alert.css')}}" rel="stylesheet" type="text/css">
    <link href="{{asset('theme/plugins/select2/css/select2.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}" rel="stylesheet">
    <style>
        #bank_detail {
            display: none;
        }
    </style>
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="row">
                        <div class="page-title-box">
                            <h4 class="page-title">Edit Sales Invoice</h4>
                            <div class="pull-right">
                                <a href="{{route('sales-invoice.index')}}"
                                   class="btn btn-info btn-rounded waves-effect waves-light m-b-2"><i
                                        class=" mdi mdi-keyboard-backspace"></i> Back</a>
                            </div>
                            <div class="clearfix"></div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card-box">
                                <div class="row">
                                    <div class="col-sm-12 col-12">
                                        {!! Form::open(['route'=>array('sales-invoice.update', $sales_invoice->id), 'onsubmit'=>'BtnSubmit.disabled = true', 'method' => 'put']) !!}
                                        <div class="form-row">
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="bill_no">Bill No.<span class="text-danger">*</span></label>
                                                <input id="bill_no" type="text" class="form-control" name="bill_no"
                                                       value="{{$sales_invoice->bill_no}}" required readonly>
                                                <div class="text-danger">{{$errors->first('bill_no')}}</div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="bill_date">Date<span class="text-danger">*</span></label>
                                                <input type="text" name="bill_date" id="bill_date"
                                                       value="{{old('bill_date',date('d-m-Y', strtotime($sales_invoice->bill_date)))}}"
                                                       class="form-control datepicker" autocomplete="off">
                                                <div class="text-danger">{{$errors->first('bill_date')}}</div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="customer_id">Customer Name<span class="text-danger">*</span></label>
                                                {!! Form::select("customer_id", [''=>'Select ']+$customers, old("customer_id", $sales_invoice->customer_id), ['class'=>'form-control', 'required', 'id'=>'customer_id'] ) !!}
                                                <div class="text-danger">{{$errors->first('customer_id')}}</div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="payment_type">Payment Type<span class="text-danger">*</span></label>
                                                {!! Form::select("payment_type", [''=>'Select ', 'credit'=>'Credit','cash'=>'Cash','card'=>'Card'], old("payment_type", $sales_invoice->payment_type), ['class'=>'form-control', 'required', 'id'=>'payment_type'] ) !!}
                                                <div class="text-danger">{{$errors->first('payment_type')}}</div>
                                            </div>
                                            <div class=" " id="bank_detail">
                                                <div class="form-group col-sm-6 col-12">
                                                    <label for="bank_name">Bank Name</label>
                                                    <input id="bank_name" type="text" class="form-control"
                                                           name="bank_name"
                                                           value="{{old('bank_name', $sales_invoice->bank_name)}}">
                                                    <div class="text-danger">{{$errors->first('bank_name')}}</div>
                                                </div>
                                                <div class="form-group col-sm-6 col-12">
                                                    <label for="card_no">Card No.</label>
                                                    <input id="card_no" type="text" class="form-control number"
                                                           name="card_no"
                                                           value="{{old('card_no', $sales_invoice->card_no)}}">
                                                    <div class="text-danger">{{$errors->first('card_no')}}</div>
                                                </div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="due_date">Due Date</label>
                                                <input type="text" name="due_date" id="due_date"
                                                       value="{{old('due_date', $sales_invoice->due_date ? date('d-m-Y', strtotime($sales_invoice->due_date)):'')}}"
                                                       class="form-control datepicker" autocomplete="off">
                                                <div class="text-danger">{{$errors->first('due_date')}}</div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="credit_days">Credit Days</label>
                                                <input type="text" name="credit_days" id="credit_days"
                                                       value="{{old('credit_days', $sales_invoice->credit_days)}}"
                                                       class="form-control number" readonly>
                                                <div class="text-danger">{{$errors->first('credit_days')}}</div>
                                            </div>

                                            <div class="form-group col-sm-6 col-12">
                                                <label for="delivery_date">Delivery Date</label>
                                                <input type="text" name="delivery_date"
                                                       value="{{old('delivery_date', $sales_invoice->delivery_date ? date('d-m-Y', strtotime($sales_invoice->delivery_date)):'')}}"
                                                       class="form-control datepicker" autocomplete="off">
                                                <div class="text-danger">{{$errors->first('delivery_date')}}</div>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="branch_id">Branch<span class="text-danger">*</span></label>
                                                <input type="hidden" name="branch_id"
                                                       value="{{$sales_invoice->branch_id}}">
                                                {!! Form::select("branch_ids", \App\Http\Helpers\Helper::getBranchData(), old("branch_ids",$sales_invoice->branch_id), ['class'=>'form-control' ,'id' => 'branch_ids','disabled']  ) !!}
                                            </div>
                                        </div>
                                        <div class="form-group col-sm-12 col-12">
                                            <label for="billing_address">Billing Address</label>
                                            <textarea class="form-control"
                                                      name="billing_address">{{old('billing_address', $sales_invoice->billing_address)}}</textarea>
                                            <div class="text-danger">{{$errors->first('billing_address')}}</div>
                                        </div>
                                        <div class="form-row">
                                            <div class="col-sm-12 col-12 table-responsive">
                                                <table class="table table-striped dataTable" id="datatable">
                                                    <thead>
                                                    <tr class="text-center">
                                                        <th style="width: 20%">Part No. & Desc.<span
                                                                class="text-danger">*</span>
                                                            <button type="button"
                                                                    class="btn btn-info btn-rounded btn-xs pull-right"
                                                                    data-toggle="modal" data-target="#spare-part-modal">
                                                                <i class="fa fa-plus"></i>
                                                            </button>
                                                        </th>
                                                        <th style="width: 15%">Transaction Type<span
                                                                class="text-danger">*</span></th>
                                                        <th style="width: 15%">Qty.<span class="text-danger">*</span>
                                                        </th>
                                                        <th style="width: 10%">Selling Price<span
                                                                class="text-danger">*</span></th>
                                                        <th style="width: 10%">Discount</th>
                                                        <th style="width: 10%">Amount</th>
                                                        <th style="width: 10%">VAT</th>
                                                        <th style="width: 10%">Final Amount</th>
                                                        <th style="width: 5%">
                                                            <button type="button"
                                                                    class="btn btn-info btn-sm m-l-10"
                                                                    id="addrow">
                                                                <i class="fa fa-plus"></i>
                                                            </button>
                                                        </th>
                                                    </tr>
                                                    </thead>
                                                    <tbody>
                                                    @php
                                                        $sp_cont=10;
                                                    @endphp

                                                    @foreach($sales_invoice->salesInvoiceDetails as $sales_invoice_detail)
                                                        <tr>
                                                            <td>
                                                                <input type="hidden" name="check_val[]"
                                                                       value="{{$sales_invoice_detail->id}}">
                                                                <input type="hidden"
                                                                       name="cr_journal_voucher_detail_id[]"
                                                                       value="{{$sales_invoice_detail->cr_journal_voucher_detail_id}}">
                                                                <input type="hidden"
                                                                       name="dr_journal_voucher_detail_id[]"
                                                                       value="{{$sales_invoice_detail->dr_journal_voucher_detail_id}}">
                                                                <input type="hidden" id="spare_part_prev{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->spare_part_id}}">
                                                                <select name="spare_part_id[]"
                                                                        id="spare_part_id{{$sp_cont}}"
                                                                        class="form-control select2" required="">
                                                                    <option value="">Select Part</option>
                                                                    @foreach($spare_parts as $raw)
                                                                        <option
                                                                            value="{{$raw->id}}" {{$sales_invoice_detail->spare_part_id == $raw->id ? 'selected' :''}} >{{$raw->part_number .' - '. $raw->part_description}}</option>
                                                                    @endforeach
                                                                </select>
                                                            </td>
                                                            <td>
                                                                <select name="applicable[]" id="applicable{{$sp_cont}}"
                                                                        class="form-control applicable_inventory"
                                                                        readonly="">
                                                                    <option
                                                                        value="inventory" {{$sales_invoice_detail->applicable == 'inventory' ? 'selected': 'no'}}>
                                                                        Inventory
                                                                    </option>
                                                                    <option
                                                                        value="no" {{$sales_invoice_detail->applicable == 'no' ? 'selected': 'no'}}>
                                                                        N/A
                                                                    </option>
                                                                </select>
                                                            </td>
                                                            <td>
                                                                <input type="number" name="quantity[]"
                                                                       id="quantity{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->quantity}}"
                                                                       required class="form-control number" min="1">
                                                            </td>
                                                            <td>
                                                                <input type="text" name="selling_price[]"
                                                                       id="selling_price{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->selling_price}}"
                                                                       required class="form-control floatnumber">
                                                            </td>
                                                            <td>
                                                                <input type="text" name="discount[]"
                                                                       id="discount{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->part_discount ? $sales_invoice_detail->part_discount : 0}}"
                                                                       required class="form-control floatnumber">
                                                            </td>
                                                            <td>
                                                                <input type="text" name="amount[]"
                                                                       id="amount{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->amount}}"
                                                                       class="form-control floatnumber" readonly>
                                                            </td>
                                                            <td>
                                                                <input type="text" name="vat[]" id="vat{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->vat ? $sales_invoice_detail->vat : 0}}"
                                                                       required class="form-control floatnumber"
                                                                       readonly>
                                                            </td>
                                                            <td>
                                                                <input type="text" name="final_amount[]"
                                                                       id="final_amount{{$sp_cont}}"
                                                                       value="{{$sales_invoice_detail->final_amount}}"
                                                                       class="form-control floatnumber" readonly>
                                                            </td>
                                                            <td>
                                                                <button id="service{{$sales_invoice_detail->id}}"
                                                                        type="button"
                                                                        onclick="deleteSalesInvoiceDetail({{$sales_invoice_detail->id}})"
                                                                        class="btn btn-danger btn-sm" title="Delete"><i
                                                                        class="ti ti-trash icon-sm"></i></button>
                                                            </td>
                                                        </tr>
                                                        @php
                                                            $sp_cont++;
                                                        @endphp
                                                    @endforeach
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                        <div class="form-row">
                                            <div class="form-group col-sm-12 col-12">
                                                <label for="in_word">In Words</label>
                                                <input id="in_word" type="text" class="form-control"
                                                       name="in_word"
                                                       value="Zero"
                                                       readonly>
                                            </div>
                                        </div>
                                        <div class="form-row">
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="total_selling_price">Total Selling Price<span
                                                        class="text-danger">*</span></label>
                                                <input id="total_selling_price" type="text" class="form-control"
                                                       name="total_selling_price"
                                                       value="{{$sales_invoice->total_selling_price}}" readonly>
                                            </div>

                                            <div class="form-group col-sm-6 col-12">
                                                <label for="total_discount">Total Discount<span
                                                        class="text-danger">*</span></label>
                                                <input id="total_discount" type="text" class="form-control"
                                                       name="total_discount" value="{{$sales_invoice->total_discount}}"
                                                       readonly>
                                                <div class="text-danger">{{$errors->first('total_discount')}}</div>
                                            </div>

                                            <div class="form-group col-sm-6 col-12">
                                                <label for="gross_amount">Gross Amount<span class="text-danger">*</span></label>
                                                <input id="gross_amount" type="text" class="form-control"
                                                       name="gross_amount" value="{{$sales_invoice->gross_amount}}"
                                                       readonly>
                                                <div class="text-danger">{{$errors->first('gross_amount')}}</div>
                                            </div>

                                            <div class="form-group col-sm-6 col-12">
                                                <label for="total_vat">Total Vat<span
                                                        class="text-danger">*</span></label>
                                                <input id="total_vat" type="text" class="form-control" name="total_vat"
                                                       value="{{$sales_invoice->total_vat}}" readonly>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="net_amount">Net Amount ( Include VAT )<span
                                                        class="text-danger">*</span></label>
                                                <input id="net_amount" type="text" class="form-control"
                                                       name="net_amount"
                                                       value="{{$sales_invoice->net_amount}}"
                                                       readonly>
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="paid_amount">Paid Amount</label>
                                                <input id="paid_amount" type="text" class="form-control"
                                                       name="paid_amount" readonly
                                                       value="{{$sales_invoice->paid_amount}}">
                                            </div>
                                            <div class="form-group col-sm-6 col-12">
                                                <label for="balance_amount">Balance Amount<span
                                                        class="text-danger">*</span></label>
                                                <input id="balance_amount" type="text" class="form-control"
                                                       name="balance_amount"
                                                       value="{{$sales_invoice->balance_amount}}"
                                                       readonly>
                                            </div>
                                        </div>
                                        <div class="form-row">
                                            <div class="form-group col-sm-12 text-center">
                                                <button type="submit" name="action_create" value="save"
                                                        class="btn btn-success">
                                                    Update
                                                </button>
                                                <button type="submit" name="action_create" value="receipt_voucher"
                                                        class="btn btn-info m-l-10">
                                                    Receipt Voucher
                                                </button>
                                                <button type="submit" name="action_create" value="sales_return"
                                                        class="btn btn-primary m-l-10">
                                                    Sales Return
                                                </button>
                                                <button type="submit" name="action_create" value="cancel_invoice"
                                                        class="btn btn-danger m-l-10">
                                                    Cancel
                                                </button>
                                                <button type="button"
                                                        onclick="sendEmail({{$sales_invoice->id}}, 'sales-invoice','{{ $sales_invoice->customer ? $sales_invoice->customer->email : '' }}'
                                                            )" title="send email"
                                                        class="btn btn-danger waves-effect waves-light m-l-10"><i class="fa fa-envelope"></i>
                                                </button>
                                                <button type="button"
                                                        onclick="whatsapp('{{ $sales_invoice->customer ? $sales_invoice->customer->contact_number : '' }}')"
                                                        title="whatsapp"
                                                        class="btn btn-success waves-effect waves-light">
                                                    <i class="fa fa-whatsapp"></i>
                                                </button>
                                            </div>
                                        </div>
                                        {!! Form::close() !!}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    @include('admin.sales.models.sparePart')
    @include('admin.advisor.models.sendMail')
    @include('admin.advisor.models.whatsapp')
@endsection
@push('footerscript')
    <script src="{{asset('theme/plugins/bootstrap-sweetalert/sweet-alert.min.js')}}"></script>
    <script src="{{asset('theme/plugins/select2/js/select2.full.js')}}"></script>
    <script src="{{asset('theme/plugins/moment/moment.js')}}"></script>
    <script src="{{asset('theme/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
    <script src="{{asset('theme/default/assets/pages/jquery.form-pickers.init.js')}}"></script>
    <script>
        function sendEmail(id, inspection, email) {
            $('#uid').val(id);
            $('#type').val(inspection);
            $('.email_id').val(email);
            $('#email-pdf-modal').modal('show');
        }

        $('.number').keyup(function (e) {
            if (/\D/g.test(this.value)) {
                this.value = this.value.replace(/\D/g, '');
            }
        });

        function whatsapp(mobile) {
            $('#whatsapp_no').val(mobile);
            $('#whatsapp-pdf-modal').modal('show');
        }

        var vat_checked = '';
        $('.select2').select2();
        var spare_part_ids = [];
        $('#spare-part-modal').modal({
            backdrop: 'static',
            keyboard: false,
            show: false
        });
        $('#spare-part-modal').on('shown.bs.modal', function () {
            $('.new-select2').select2({
                dropdownParent: $('#spare-part-modal')
            });
        });
        $(".datepicker").datepicker({
            format: 'dd-mm-yyyy',
            autoclose: true
        });
        $('#due_date').on('change', function () {
            var due_date = moment($(this).val(), "DD-MM-YYYY");
            var bill_date = moment($('#bill_date').val(), "DD-MM-YYYY");
            $('#credit_days').val(due_date.diff(bill_date, 'days'));
        });
        $('.number').keyup(function (e) {
            if (/\D/g.test(this.value)) {
                this.value = this.value.replace(/\D/g, '');
            }
        });
        $('.applicable_inventory').on('mousedown', function (event) {
            event.preventDefault();
            this.blur();
            window.focus();
        });
        $('.floatnumber').on('input', function () {
            this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');
        });

        function numberToWords(number) {
            var digit = ['zero', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine'];
            var elevenSeries = ['ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen'];
            var countingByTens = ['twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety'];
            var shortScale = ['', 'thousand', 'million', 'billion', 'trillion'];
            number = number.toString();
            number = number.replace(/[\, ]/g, '');
            if (number != parseFloat(number)) return 'not a number';
            var x = number.indexOf('.');
            if (x == -1) x = number.length;
            if (x > 15) return 'too big';
            var n = number.split('');
            var str = '';
            var sk = 0;
            for (var i = 0; i < x; i++) {
                if ((x - i) % 3 == 2) {
                    if (n[i] == '1') {
                        str += elevenSeries[Number(n[i + 1])] + ' ';
                        i++;
                        sk = 1;
                    } else if (n[i] != 0) {
                        str += countingByTens[n[i] - 2] + ' ';
                        sk = 1;
                    }
                } else if (n[i] != 0) {
                    str += digit[n[i]] + ' ';
                    if ((x - i) % 3 == 0) str += 'hundred ';
                    sk = 1;
                }
                if ((x - i) % 3 == 1) {
                    if (sk) str += shortScale[(x - i - 1) / 3] + ' ';
                    sk = 0;
                }
            }
            if (x != number.length) {
                var y = number.length;
                str += 'point ';
                for (var i = x + 1; i < y; i++) str += digit[n[i]] + ' ';
            }
            str = str.replace(/\number+/g, ' ');
            return str.trim();
        }

        $('#customer_id, #branch_id').on('change', function () {
            var customer_id = $('#customer_id').val();
            var branch_id = $('#branch_id').val();
            $.ajax({
                url: "{{route('checkVatForBranchCustomer')}}",
                type: 'GET',
                data: {
                    'customer_id': customer_id,
                    'branch_id': branch_id,
                },
                success: function (response) {
                    vat_checked = response.vat_check;
                    if (vat_checked == 'no') {
                        $('input[id^=vat]').each(function (index) {
                            var lastnum = $(this).attr('id').slice(3);
                            $(this).val(0);
                            $('#final_amount' + lastnum).val($('#amount' + lastnum).val())
                        });
                    } else {
                        $('input[id^=vat]').each(function (index) {
                            var lastnum = $(this).attr('id').slice(3);
                            var amount = $('#amount' + lastnum).val();
                            $('#vat' + lastnum).val((amount * 0.05).toFixed(2));
                            var vat = $('#vat' + lastnum).val()
                            var finalAmount = parseFloat(amount) + parseFloat(vat);
                            $('#final_amount' + lastnum).val(finalAmount.toFixed(2));
                        });
                    }
                    totalCalculation();
                },
            });
        });

        $(window).on('load', function () {
            var net_amount = {{$sales_invoice->net_amount}};
            var number_word = (net_amount).toFixed(2);
            var new_number_w = number_word.split('.');
            if (Number(new_number_w[1]) > 0) {
                $('#in_word').val(numberToWords(new_number_w[0]) + ' Dirhams ' + numberToWords(new_number_w[1]) + ' fils Only.');
            } else {
                $('#in_word').val(numberToWords(new_number_w[0]) + ' Dirhams Only. ');
            }

            $('#customer_id').trigger('change');
            for (var a = 1; a < {{$sp_cont}}; a++) {
                spare_part_ids.push(parseInt($('#spare_part_id' + a).val()));
            }
            selectOptions();
        })


        $('#payment_type').on('change', function () {
            if ($(this).val() == 'card') {
                $('#bank_detail').show();
            } else {
                $('#bank_detail').hide();
            }
        });

        $('select[id^=spare_part_id]').on('change', function () {
            var lastnum = $(this).attr('id').slice(13);
            var id = $('#spare_part_id' + lastnum).val();
            if ($('#spare_part_prev' + lastnum).val()) {
                spare_part_ids.splice($.inArray($('#spare_part_prev' + lastnum).val(), spare_part_ids), 1);
                spare_part_ids.push(parseInt(id));
                selectOptions();
                $('#spare_part_prev' + lastnum).val(id);
            } else {
                spare_part_ids.push(parseInt(id));
                selectOptions();
                $('#spare_part_prev' + lastnum).val(id);
            }
            $.ajax({
                url: '{{route('getSparePartById')}}',
                type: 'GET',
                data: {
                    id: id
                },
                success: function (response) {
                    if (response.keep_stock == "yes") {
                        $('#applicable' + lastnum).val("inventory");
                    } else {
                        $('#applicable' + lastnum).val("no");
                        $('#quantity' + lastnum).attr({"max": 100});
                    }
                    $('#selling_price' + lastnum).val(response.selling_price);
                    $('#quantity' + lastnum).val(1);
                    if (response.stock && response.keep_stock == "yes") {
                        $('#quantity' + lastnum).attr({"max": response.stock});
                        alert('Stock Available is: ' + response.stock);
                    } else if (response.keep_stock == "yes") {
                        $('#quantity' + lastnum).attr({"max": 0, "min": 0});
                        alert('Stock Available is: 0');
                    }
                    $('#discount' + lastnum).val(0);
                    var discount = $('#discount' + lastnum).val();

                    $('#amount' + lastnum).val((response.selling_price - discount).toFixed(2));
                    var amount = $('#amount' + lastnum).val();

                    $('#vat' + lastnum).val((vat_checked == 'yes' ? amount * 0.05 : 0).toFixed(2));

                    var vat = $('#vat' + lastnum).val()

                    var finalAmount = parseFloat(amount) + parseFloat(vat);

                    $('#final_amount' + lastnum).val(finalAmount.toFixed(2));

                    totalCalculation();
                }
            });
        });

        $('input[id^=quantity]').keyup(function (e) {
            var lastnum = $(this).attr('id').slice(8);
            calculation(lastnum);
        });

        $('input[id^=selling_price]').keyup(function (e) {
            var lastnum = $(this).attr('id').slice(13);
            calculation(lastnum);
        });

        $('input[id^=discount]').keyup(function (e) {
            var lastnum = $(this).attr('id').slice(8);
            calculation(lastnum);
        });

        $('#paid_amount').on('change', function () {
            totalCalculation();
        });

        function calculation(lastnum) {
            var qty = $('#quantity' + lastnum).val();
            var cost = $('#selling_price' + lastnum).val();
            var discount = $('#discount' + lastnum).val();
            $('#amount' + lastnum).val((qty * cost) - discount);

            var amount = $('#amount' + lastnum).val();

            if (vat_checked == 'yes') {
                $('#vat' + lastnum).val((amount * 0.05).toFixed(2));
            } else {
                $('#vat' + lastnum).val(0);
            }

            var vatAmount = $('#vat' + lastnum).val();

            var finalAmount = parseFloat(amount) + parseFloat(vatAmount);
            $('#final_amount' + lastnum).val(finalAmount);

            totalCalculation();

        }

        function totalCalculation() {

            var vat = 0, amount = 0, dis = 0, sellingPrice = 0, final_amount = 0;
            $('input[id^=selling_price]').each(function (index) {
                sellingPrice += Number($(this).val());
            });
            $('input[id^=discount]').each(function (index) {
                dis += Number($(this).val());
            });
            $('input[id^=amount]').each(function (index) {
                amount += Number($(this).val());
            });
            $('input[id^=vat]').each(function (index) {
                vat += Number($(this).val());
            });
            $('input[id^=final_amount]').each(function (index) {
                final_amount += Number($(this).val());
            });

            $('#total_selling_price').val(sellingPrice.toFixed(2));
            $('#total_discount').val(dis.toFixed(2));
            $('#gross_amount').val(amount.toFixed(2));
            $('#total_vat').val(vat.toFixed(2));

            $('#net_amount').val((final_amount).toFixed(2));

            var net_amount = Number($('#net_amount').val());
            var paidAmount = $('#paid_amount').val();

            var balanceAmount = parseFloat(net_amount) - parseFloat(paidAmount);
            $('#balance_amount').val(balanceAmount.toFixed(2));

            var number_word = (net_amount).toFixed(2);
            var new_number_w = number_word.split('.');
            if (Number(new_number_w[1]) > 0) {
                $('#in_word').val(numberToWords(new_number_w[0]) + ' Dirhams ' + numberToWords(new_number_w[1]) + ' fils Only.');
            } else {
                $('#in_word').val(numberToWords(new_number_w[0]) + ' Dirhams Only. ');
            }
        }

        $('#paid_amount').keyup(function () {
            var netAmount = $('#net_amount').val();
            var paid_amount = $('#paid_amount').val();
            if (paid_amount == '' || paid_amount == null) {
                var paidAmount = 0;
            } else {
                var paidAmount = paid_amount;
            }

            var balance = parseFloat(netAmount) - parseFloat((paidAmount));
            $('#balance_amount').val(balance.toFixed(2));
        })

        function selectOptions() {
            if (j != 1) {
                for (var a = 1; a < (j + 1); a++) {
                    $('#spare_part_id' + a).find("option").each(function () {
                        if ($('#spare_part_id' + a).val() != $(this).val() && $.inArray(parseInt($(this).val()), spare_part_ids) != -1) {
                            $(this).prop("disabled", true);
                        } else {
                            $(this).prop("disabled", false);
                        }
                    });
                    $('#spare_part_id' + a).trigger("change.select2");
                }
            }
        }

        let j = "{{$sp_cont}}";
        $("#addrow").on('click', function () {
            var col = "<tr>";
            col += ' <input type="hidden" name="check_val[]" value="new">';
            col += ' <input type="hidden" name="cr_journal_voucher_detail_id[]" value="new">';
            col += ' <input type="hidden" name="dr_journal_voucher_detail_id[]" value="new">';
            col += '<td><input type="hidden" id="spare_part_prev' + j + '" value=""> <select name="spare_part_id[]"  id="spare_part_id' + j + '" class="form-control select2" required="">' +
                '<option value="">Select Part</option>@foreach($spare_parts as $raw)<option value="{{$raw->id}}">{{$raw->part_description .' - '. $raw->part_number}}</option>@endforeach
                    </select></td>';
            col += '<td><select name="applicable[]"  id="applicable' + j + '" class="form-control applicable_inventory" readonly="">' +
                '<option value="inventory">Inventory</option><option value="no">N/A</option></select></td>';
            col += '<td><input type="number" name="quantity[]" id="quantity' + j + '" class="form-control number" min="1" required></td>';

            col += '<td><input type="text" name="selling_price[]" id="selling_price' + j + '" class="form-control floatnumber" required></td>';
            col += '<td><input type="text" name="discount[]" id="discount' + j + '" class="form-control floatnumber"></td>';
            col += '<td><input type="text" name="amount[]" id="amount' + j + '" class="form-control" readonly></td>';
            col += '<td><input type="text" name="vat[]" id="vat' + j + '" class="form-control floatnumber" readonly></td>';
            col += '<td><input type="text" name="final_amount[]" id="final_amount' + j + '" class="form-control" readonly></td>';
            col += '<td><button class="btn btn-danger btn-sm" id="deleteRow" type="button"><i class="fa fa-trash"></i></button></td>';
            $("table#datatable").append(col);
            j++;
            $('.select2').select2();
            selectOptions();
            $('.number').keyup(function (e) {
                if (/\D/g.test(this.value)) {
                    this.value = this.value.replace(/\D/g, '');
                }
            });
            $('.floatnumber').on('input', function () {
                this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');
            });
            $('.applicable_inventory').on('mousedown', function (event) {
                event.preventDefault();
                this.blur();
                window.focus();
            });

            $('select[id^=spare_part_id]').on('change', function () {
                var lastnum = $(this).attr('id').slice(13);
                var id = $('#spare_part_id' + lastnum).val();
                if ($('#spare_part_prev' + lastnum).val()) {
                    spare_part_ids.splice($.inArray($('#spare_part_prev' + lastnum).val(), spare_part_ids), 1);
                    spare_part_ids.push(parseInt(id));
                    selectOptions();
                    $('#spare_part_prev' + lastnum).val(id);
                } else {
                    spare_part_ids.push(parseInt(id));
                    selectOptions();
                    $('#spare_part_prev' + lastnum).val(id);
                }
                $.ajax({
                    url: '{{route('getSparePartById')}}',
                    type: 'GET',
                    data: {
                        id: id
                    },
                    success: function (response) {
                        if (response.keep_stock == "yes") {
                            $('#applicable' + lastnum).val("inventory");
                        } else {
                            $('#applicable' + lastnum).val("no");
                            $('#quantity' + lastnum).attr({"max": 100});
                        }
                        $('#selling_price' + lastnum).val(response.selling_price);
                        $('#quantity' + lastnum).val(1);
                        if (response.stock && response.keep_stock == "yes") {
                            $('#quantity' + lastnum).attr({"max": response.stock});
                            alert('Stock Available is: ' + response.stock);
                        } else if (response.keep_stock == "yes") {
                            $('#quantity' + lastnum).attr({"max": 0, "min": 0});
                            alert('Stock Available is: 0');
                        }
                        $('#discount' + lastnum).val(0);
                        var discount = $('#discount' + lastnum).val();

                        $('#amount' + lastnum).val((response.selling_price - discount).toFixed(2));
                        var amount = $('#amount' + lastnum).val();

                        $('#vat' + lastnum).val((vat_checked == 'yes' ? amount * 0.05 : 0).toFixed(2));

                        var vat = $('#vat' + lastnum).val()

                        var finalAmount = parseFloat(amount) + parseFloat(vat);

                        $('#final_amount' + lastnum).val(finalAmount.toFixed(2));
                        totalCalculation()

                    }
                });
            });

            $('input[id^=quantity]').keyup(function (e) {
                var lastnum = $(this).attr('id').slice(8);
                calculation(lastnum);
            });

            $('input[id^=selling_price]').keyup(function (e) {
                var lastnum = $(this).attr('id').slice(13);
                calculation(lastnum);
            });

            $('input[id^=discount]').keyup(function (e) {
                var lastnum = $(this).attr('id').slice(8);
                calculation(lastnum);
            });
        });
        $("table#datatable").on("click", "#deleteRow", function (event) {
            $(this).closest("tr").remove();
        });

        function deleteSalesInvoiceDetail(id) {
            swal({
                    title: "Are you sure?",
                    text: "You will not be able to recover this data!",
                    type: "warning",
                    showCancelButton: true,
                    confirmButtonColor: '#DD6B55',
                    confirmButtonText: 'Yes    ',
                    cancelButtonText: "No    ",
                    closeOnConfirm: false,
                    closeOnCancel: false,
                    cancelButtonClass: 'btn-default btn-md waves-effect',
                    confirmButtonClass: 'btn-danger btn-md waves-effect waves-light',
                },
                function (isConfirm) {
                    if (isConfirm) {
                        $.ajax({
                            url: '{{ url('sales-invoice/delete-sales-detail') }}/' + id,
                            type: 'delete',
                            dataType: "JSON",
                            data: {
                                "_token": "{{ csrf_token() }}"
                            },
                            success: function () {
                                $("#service" + id).closest("tr").remove();
                            }
                        });
                        swal("Deleted!", "Data has been deleted!", "success");
                    } else {
                        swal("Cancelled", "Data is safe :)", "error");
                    }
                });
        }
    </script>
@endpush