@extends('admin.layout.master')
@section('title', 'PURCHASE ORDER MANAGEMENT')
@section('custom_style')
    @include('inventory.blade_styles.posting_blade_css')
    <style>
        input[type=text],
        input[type=file],
        input[type=number] {
            height: 24px !important;
        }

        .table td {
            padding: 0px 5px;
            color: black;
        }

        .table th {
            background: var(--cl-primary);
            padding: 5px !important;
            color: white !important;
        }

        .select2-container--default {
            width: 100% !important;
        }
    </style>
@endsection
@section('content')
    <div class="card sina-card">
        <div class="card-header card-header-s">
            <h4>{{ __('obs.purchase') }} {{ __('obs.order') }}</h4>
        </div>
        <div class="card-body">
            <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />
            {{-- <div class="row justify-content-end">
                <div class="col-3 pl-0">
                    <label for="quotation_search">{{__('obs.quotation')}} {{__('obs.no')}}</label>
                    <select id="quotation_search" class="form-control" name="quotation_search">
                    </select>
                </div>
                <div class="col-6 pl-0">
                    <label>{{__('obs.date')}}</label>
                    <div class="input-group">
                        <div class="input-group input-group-append">
                            <input type="date" class="form-control bsdatepicker" id="start_date" name="start_date" value="{{Request()->start_date?date('Y-m-d',strtotime(Request()->start_date)):date('Y-m-d')}}">
                            <label class="input-group-text" style="height: 24px; margin-left: -2px; margin-right: -2px">{{__('obs.date_to')}}</label>
                            <input type="date" class="form-control bsdatepicker" id="end_date" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):date('Y-m-d')}}">

                            <button type="button" style="height: 24px; margin-left: -2px"  onclick="getQuotationData()" class="btn btn-sm btn-pill btn-sm btn-hover btn-danger">
                                <i class="fa fa-search"></i>
                            </button>
                        </div>
                    </div>
                </div>
            </div> --}}
            <nav class="mb-3 d-flex justify-content-between">
                <div class="nav nav-tabs" id="nav-tab" role="tablist">
                    <button class="nav-link active" id="nav-home-tab" data-bs-toggle="tab" data-bs-target="#invoice-tab"
                        type="button" role="tab" aria-controls="nav-home" aria-selected="true">
                        {{ __('obs.po') }}
                    </button>
                    <button class="nav-link" id="nav-disabled-tab" data-bs-toggle="tab" data-bs-target="#quotation-tab"
                        type="button" role="tab" aria-controls="nav-disabled" aria-selected="false">
                        {{ __('obs.install_from_quotation') }}
                    </button>
                    <button class="nav-link" id="nav-disabled-tab" data-bs-toggle="tab" data-bs-target="#requisition-tab"
                        type="button" role="tab" aria-controls="nav-disabled" aria-selected="false">
                        {{ __('obs.install_from_requisition') }}
                    </button>
                </div>
            </nav>


            <div class="tab-content">
                <div class="tab-pane fade" id="quotation-tab" role="tabpanel" tabindex="0">
                    <div class="row justify-content-start">
                        <div class="col-3 pl-0">
                            <label for="quotation_search">{{ __('obs.quotation') }} {{ __('obs.no') }}</label>
                            <select id="quotation_search" class="form-control" name="quotation_search">
                            </select>
                        </div>
                        <div class="col-6 pl-0">
                            <label>{{ __('obs.date') }}</label>
                            <div class="input-group">
                                <div class="input-group input-group-append">
                                    <input type="date" class="form-control bsdatepicker" id="start_date"
                                        name="start_date"
                                        value="{{ Request()->start_date ? date('Y-m-d', strtotime(Request()->start_date)) : date('Y-m-d') }}">
                                    <label class="input-group-text"
                                        style="height: 24px; margin-left: -2px; margin-right: -2px">{{ __('obs.date_to') }}</label>
                                    <input type="date" class="form-control bsdatepicker" id="end_date" name="end_date"
                                        value="{{ Request()->end_date ? date('Y-m-d', strtotime(Request()->end_date)) : date('Y-m-d') }}">

                                    <button type="button" style="height: 24px; margin-left: -2px"
                                        onclick="getQuotationData()"
                                        class="btn btn-sm btn-pill btn-sm btn-hover btn-danger">
                                        <i class="fa fa-search"></i>
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="tab-pane fade" id="requisition-tab" role="tabpanel" tabindex="0">
                    <div class="row justify-content-start">
                        <div class="col-4 pl-0">
                            <label for="requisition_search">{{ __('obs.requisition') }} {{ __('obs.no') }}</label>
                            <select id="requisition_search" class="form-control" name="requisition_search">
                            </select>
                        </div>
                        <div class="col-6 pl-0">
                            <label>{{ __('obs.date') }}</label>
                            <div class="input-group">
                                <div class="input-group input-group-append">
                                    <input type="date" class="form-control bsdatepicker" id="start_date"
                                        name="start_date"
                                        value="{{ Request()->start_date ? date('Y-m-d', strtotime(Request()->start_date)) : date('Y-m-d') }}">
                                    <label class="input-group-text"
                                        style="height: 24px; margin-left: -2px; margin-right: -2px">{{ __('obs.date_to') }}</label>
                                    <input type="date" class="form-control bsdatepicker" id="end_date" name="end_date"
                                        value="{{ Request()->end_date ? date('Y-m-d', strtotime(Request()->end_date)) : date('Y-m-d') }}">

                                    <button type="button" style="height: 24px; margin-left: -2px"
                                        onclick="getRequisitionData()"
                                        class="btn btn-sm btn-pill btn-sm btn-hover btn-danger">
                                        <i class="fa fa-search"></i>
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


                <div class="tab-pane fade show active" id="invoice-tab" role="tabpanel" tabindex="0">
                    <form id="form1" method="post" action="{{ route('prepurchase.po_store') }}"
                        enctype="multipart/form-data">
                        @csrf
                        <div>
                            <div class="row mb-1">
                                <input type="hidden" name="quotation_id" id="quotation_id"
                                    value="{{ Request()->quotation_id }}">
                                <input type="hidden" name="requisition_id" id="requisition_id"
                                    value="{{ Request()->requisition_id }}">
                                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">{{ __('obs.vendor') }}</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <select name="vendor_id" id="vendor_id" class="form-control vendor" required
                                            onchange="/*getProducts();*/">
                                            @if ($quotation)
                                                <option value="{{ $quotation->supplier_id }}">
                                                    {{ $quotation->supplier->name_eng }}</option>
                                            @endif
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">{{ __('obs.description') }}</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <input type="text" class="form-control" name="note" id="note">

                                    </div>
                                </div>
                                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-4 px-0">
                                        <label for="reference">{{ __('obs.reference') }} {{ __('obs.no') }}</label>
                                    </div>
                                    <div class="col-8 px-0">
                                        <input type="text" class="form-control" name="reference" id="reference"
                                            value="">

                                    </div>
                                </div>
                                @if ($requisition)
                                    <div class="col-md-2 col-12 d-flex flex-wrap pr-0 mb-3">
                                        <div class="col-10 px-0">
                                            <label for="reference">{{ __('obs.close') }}
                                                {{ __('obs.requisition') }}</label>
                                        </div>
                                        <div class="col-2 px-0">
                                            <input type="checkbox" id="close_requisition" name="close_requisition"
                                                value="1">

                                        </div>
                                    </div>
                                @endif
                            </div>
                            <div class="table-responsive">
                                <table class="table table-bordered table-hover">
                                    <thead>
                                        <tr>
                                            <th width="5%">#</th>
                                            <th width="25%">{{ __('obs.product') }}</th>
                                            <th width="15%">{{ __('obs.note') }}</th>
                                            <th width="10%">{{ __('obs.available') }} {{ __('obs.qty') }}</th>
                                            <th width="10%">{{ __('obs.pre') }} {{ __('obs.purchase') }}
                                                {{ __('obs.date') }}</th>
                                            <th width="10%">{{ __('obs.pre') }} {{ __('obs.purchase') }}
                                                {{ __('obs.rate') }}</th>
                                            <th width="10%">{{ __('obs.quotation') }} {{ __('obs.qty') }}</th>
                                            <th width="10%">{{ __('obs.purchase.') }} {{ __('obs.qty') }}</th>
                                            <th width="10%">{{ __('obs.unit') }} {{ __('obs.price') }}</th>
                                            <th width="10%">{{ __('obs.subtotal') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody id="tbl_body">
                                        @php
                                            $i = 0;
                                            $grandtotal = 0;
                                        @endphp
                                        @if ($quotation)
                                            @forelse ($quotation->details as $p=>$item)
                                                <tr id="tr{{ $i }}">
                                                    <td>{{ $i + 1 }}</td>
                                                    <td>
                                                        <div class="d-flex text-center">
                                                            <span
                                                                onclick="load_po_history('{{ request()->quotation_id }}', '{{ $item->product_id }}',1)">{{ $item->product->name_eng }}</span>
                                                            <input type="hidden" name="product_id[{{ $i }}]"
                                                                value="{{ $item->product_id }}">

                                                        </div>
                                                    </td>
                                                    <td class="">
                                                        <input type="text" name="desc[{{ $i }}]"
                                                            id="desc{{ $i }}" class="form-control">
                                                    </td>
                                                    <td class="text-right">
                                                        {{ $item->product ? $item->product->availQty->avail ?? 0 : 0 }}
                                                    </td>
                                                    <td class="text-right">
                                                        {{-- {{ count($item->product->getPreviousPurchaseHistory) > 0 ? date('d-m-Y', strtotime($item->getPreviousPurchaseHistory[0]->date)) : 'No Purchase Info Found'}} --}}
                                                    </td>
                                                    <td class="text-right">
                                                        {{-- {{ count($item->product->getPreviousPurchaseHistory) > 0 ? $item->getPreviousPurchaseHistory[0]->price : 'No Purchase Info Found'}} --}}
                                                    </td>

                                                    <td class="text-center">
                                                        <input type="number" min="0" step=".01"
                                                            name="req[{{ $i }}]" id="req{{ $i }}"
                                                            class="form-control-sm" value="{{ $item->quantity }}"
                                                            readonly>

                                                    </td>
                                                    <td>
                                                        <input type="number"
                                                            onkeyup="setSubtotal('{{ $i }}')" min="0"
                                                            step=".01" value="{{ $item->quantity }}"
                                                            name="quantity[{{ $i }}]"
                                                            id="quantity{{ $i }}" class="form-control-sm">
                                                    </td>
                                                    <td>
                                                        <input type="number"
                                                            onkeyup="setSubtotal('{{ $i }}')" min="0"
                                                            step=".01" name="rate[{{ $i }}]"
                                                            id="rate{{ $i }}" class="form-control-sm"
                                                            value="{{ $item->rate }}">
                                                        <input type="hidden" name="quotation_rate[{{ $i }}]"
                                                            value="{{ $item->rate }}">
                                                    </td>
                                                    <td class="text-right">
                                                        @php
                                                            $grandtotal += $subTotal = $item->quantity * $item->rate;
                                                        @endphp
                                                        <input type="number" min="0" step=".01"
                                                            name="subtotal[{{ $i }}]"
                                                            id="subtotal{{ $i }}"
                                                            class="form-control-sm subtotal" readonly
                                                            value="{{ $subTotal }}">
                                                    </td>
                                                </tr>
                                                @php
                                                    $i++;
                                                @endphp
                                            @empty
                                            @endforelse
                                        @endif
                                        @if ($requisition)
                                            @forelse ($requisition->details as $p=>$item)
                                                <input type="hidden" name="requisition_detail_id[{{ $i }}]"
                                                    value="{{ $item->id }}">

                                                <tr id="tr{{ $i }}">
                                                    <td>{{ $i + 1 }}</td>
                                                    <td>
                                                        <div class="d-flex text-center">
                                                            <span
                                                                onclick="load_po_history('{{ request()->requisition_id }}', '{{ $item->product_id }}',2)">{{ $item->product->name_eng }}</span>
                                                            <input type="hidden" name="product_id[{{ $i }}]"
                                                                value="{{ $item->product_id }}">
                                                        </div>
                                                    </td>
                                                    <td style="min-width: 100px;">
                                                        <input type="text" name="desc[{{ $i }}]"
                                                            id="desc{{ $i }}" class="form-control">
                                                    </td>
                                                    <td class="text-right">
                                                        <input type="number" min="0" step=".01"
                                                            name="avail_quantity[]"
                                                            id="avail_quantity{{ $i }}" class="form-control"
                                                            value="{{ $item->product->availQty->avail ?? 0 }}" readonly>
                                                    </td>
                                                    <td class="text-right">
                                                        {{ count($item->product->getPreviousPurchaseHistory) > 0 ? date('d-m-Y', strtotime($item->getPreviousPurchaseHistory[0]->date)) : 'No Purchase Info Found' }}
                                                    </td>
                                                    <td class="text-right">
                                                        {{ count($item->product->getPreviousPurchaseHistory) > 0 ? $item->getPreviousPurchaseHistory[0]->price : 'No Purchase Info Found' }}
                                                    </td>


                                                    <td class="text-center">
                                                        <input type="number" min="0" step=".01"
                                                            name="req[{{ $i }}]" id="req{{ $i }}"
                                                            class="form-control-sm" value="{{ $item->quantity }}"
                                                            readonly>

                                                    </td>
                                                    <td>
                                                        <input type="number"
                                                            onkeyup="setSubtotal('{{ $i }}')" min="0"
                                                            step=".01" value="{{ $item->quantity }}"
                                                            name="quantity[{{ $i }}]"
                                                            id="quantity{{ $i }}" class="form-control-sm">
                                                    </td>
                                                    <td>
                                                        <input type="number"
                                                            onkeyup="setSubtotal('{{ $i }}')" min="0"
                                                            step=".01" name="rate[{{ $i }}]"
                                                            id="rate{{ $i }}" class="form-control-sm"
                                                            value="{{ $item->approx_rate }}">
                                                        <input type="hidden" name="quotation_rate[{{ $i }}]"
                                                            value="0">
                                                    </td>
                                                    <td class="text-right">
                                                        @php
                                                            $grandtotal += $subTotal = $item->quantity * $item->rate;
                                                        @endphp
                                                        <input type="number" min="0" step=".01"
                                                            name="subtotal[{{ $i }}]"
                                                            id="subtotal{{ $i }}"
                                                            class="form-control-sm subtotal" readonly
                                                            value="{{ $subTotal }}">
                                                    </td>
                                                </tr>
                                                @php
                                                    $i++;
                                                @endphp
                                            @empty
                                            @endforelse
                                        @endif

                                    </tbody>
                                    <input type="hidden" name="" id="index_num" value="{{ $i }}">
                                    <tfoot>
                                        <tr>
                                            <td colspan="9" class="text-right">{{ __('obs.total') }}</td>
                                            <td class="text-right"> <input type="number" min="0" step=".01"
                                                    name="total_amount" id="total_amount"
                                                    class="form-control-sm total_amount" value="{{ $grandtotal }}"
                                                    readonly></td>
                                        </tr>
                                        <tr>
                                            <td colspan="7" class="text-right">{{ __('obs.discount') }}
                                                {{ __('obs.(%)') }}</td>
                                            <td class="text-right"> <input type="number" max="100" step=".01"
                                                    name="discount" id="discount" class="form-control-sm discount"
                                                    onkeyup="setDiscount()"
                                                    value="{{ $quotation ? $quotation->discount : 0 }}"></td>
                                            <td class="text-right">{{ __('obs.discount') }} ({{ __('obs.amount') }})
                                            </td>
                                            @php
                                                $discountAmount = $quotation
                                                    ? ($quotation->discount / 100) * $grandtotal
                                                    : 0;
                                            @endphp
                                            <td class="text-right"> <input type="number" name="discount_amount"
                                                    id="discount_amount" class="form-control-sm discount_amount" readonly
                                                    value="{{ $discountAmount }}"></td>
                                        </tr>
                                        <tr>
                                            <td colspan="9" class="text-right">{{ __('obs.net') }}
                                                {{ __('obs.amount') }}</td>
                                            <td class="text-right"> <input type="number" name="net_amount"
                                                    id="net_amount" class="form-control-sm net_amount"
                                                    value="{{ $grandtotal - $discountAmount }}" readonly></td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                            <div class="row">
                                <div class="col-12 text-right mt-2 mt-md-0">
                                    <button class="btn btn-sm btn-primary btn-pill btn-sina-submit"
                                        style="position: fixed;bottom:10%;right:0" onclick="addRow()" type="button"
                                        name="add_Row" id="add_Row"><i class="fas fa-plus"></i></button>
                                </div>
                            </div>
                            <div class="row pb-0  modal-footer">
                                <input class="btn-sina-submit" type="submit" id="save" value="save">
                            </div>
                        </div>
                    </form>
                </div>

            </div>

        </div>
    </div>

    @include('inventory.prepurchase.po.install_modal')
    @include('inventory.prepurchase.po.install_requisition_modal')
    @include('inventory.prepurchase.po.install_po_history_modal')
@endsection
@section('script')
    <script>
        const store_setting = @json(store_info());
    </script>
    <script type="text/javascript" src="{{ asset('inventory/blade_js/common.js') }}"></script>
    <script type="text/javascript" src="{{ asset('inventory/blade_js/purchase_order.js') }}"></script>
    <script>

        let requisitionData = [];
        let quotationData = [];
        let rowForCallMethod = [];
        $('#quotation_search').select2({
            minimumInputLength: 3,
            // tags: [],
            ajax: {
                url: "/po/create",
                dataType: 'json',
                type: "GET",
                quietMillis: 0,
                data: function(term) {
                    return {
                        type: 2,
                        name: term
                    };
                },
                processResults: function(data) {
                    return {
                        results: $.map(data, function(item) {
                            return {
                                text: item.quotation_no,
                                id: item.id
                            }
                        })
                    };
                }
            }
        });
        partySearch('vendor', 1);
        // $('#vendor_id').select2({
        //     minimumInputLength: 3,
        //     ajax: {
        //         url: "{{ route('vendor.index') }}",
        //         dataType: 'json',
        //         type: "GET",
        //         quietMillis: 0,
        //         data: function (term) {
        //             return {
        //                 type: 1,
        //                 name: term
        //             };
        //         },
        //         processResults: function (data) {
        //             return {
        //                 results: $.map(data, function (item) {
        //                     return {
        //                         text: item.name_eng,
        //                         id: item.id
        //                     }
        //                 })
        //             };
        //         }
        //     }
        // });

        function getQuotationData() {
            $('#install_model_table').dataTable().fnDestroy();
            $('#install_model_tbody').empty();
            var returnData;
            var start = $('#start_date').val();
            var end = $('#end_date').val();
            $.ajaxSetup({
                headers: {
                    "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
                },
            });
            $.ajax({
                type: "GET",
                url: "/po/create",
                data: {
                    start: start,
                    end: end,
                    type: 3,
                },
                success: function(data) {
                    console.log(data);
                    if (data.length > 0) {
                        for (let index = 0; index < data.length; index++) {
                            quotationData[data[index].id] = data[index];
                            returnData += `<tr onclick="setDataForQuotation(` + data[index].id + `)" role="row" class="odd">
                                            <td class="sorting_1">` + (index + 1) + `</td>
                                            <td class="tr_td_group_code-205">` + data[index].quotation_no + `</td>
                                            <td class="tr_td_title-205"><b>` + getFormatedDate(data[index]
                                .created_at) + `</b></td>
                                        </tr>`;
                        }
                    }

                    $('#install_model_tbody').html(returnData);
                    $("#install_model").modal("show");
                    $('#install_model_table').DataTable({
                        "destroy": true,
                    });
                },
                error: function(response) {
                    // $('#load_tbody_previous_recipe_model').empty();
                },
            });
        }

        function getFormatedDate(dateToBeFormated) {
            var now = new Date(dateToBeFormated);
            var day = ("0" + now.getDate()).slice(-2);
            var month = ("0" + (now.getMonth() + 1)).slice(-2);
            var return_date = now.getFullYear() + "-" + (month) + "-" + (day);
            return return_date;
        }

        function addRow() {
            var index = parseInt($('#index_num').val()) + 1;
            var returnData = '';
            returnData += `<tr id="tr-` + index + `">
                        <td>` + (index) + `</td>
                        <td>
                            <div class="d-flex text-center">
                                <select class="form-control new_product" style="width: 100%" name="product_id[` +
                index + `]"  onchange="getAvailQTY(this.value,` + index + `)">
                                    <option value=" ">-- Select Product --</option>
                                </select>
                            </div>
                        </td>
                        <td>
                            <input type="text" name="desc[` + index + `]" id="desc` + index + `" class="form-control">
                        </td>`;
            returnData += `<td class="text-right">
                            <input type="number" min="0" step=".01" name="avail_quantity[]" id="avail_quantity` +
                index + `" class="form-control" readonly>
                        </td>
                        <td class="text-right">
                            <input type="text" name="" id="pre_purchase_date` + index + `" class="form-control" readonly>
                        </td>
                        <td class="text-right"> <input type="text" name=""
                        id="pre_purchase_rate` + index + `" class="form-control" readonly>
                        </td>`;

            returnData += ` <td class="text-center">
                            <input type="number" min="0"  name="req[` + index + `]" id="req` + index + `" step=".01" class="form-control-sm" value="0" readonly>
                          </td>`;
            returnData += `<td class="text-center">
                            <input type="number" min="0" onkeyup="setSubtotal('` + index + `')"  name="quantity[` +
                index + `]" id="quantity` + index + `" step=".01" class="form-control-sm" value="0">
                        </td>
                        <td>
                            <input type="number" onkeyup="setSubtotal('` + index +
                `')" min="0" step=".01"  name="rate[` + index + `]"
                                id="rate` + index + `" class="form-control-sm" value="0">
                                <input type="hidden" name="quotation_rate[` + index + `]" id="quotation_rate` + index + `" class="form-control" value="0">
                        </td>
                        <td class="text-right">
                            <div class="input-group text-right">
                                <input type="number" min="0" step=".01"  name="subtotal[` + index + `]"
                                    id="subtotal` + index + `" style="width:90%" class="form-control-sm subtotal" readonly value="0">
                                <div class="input-group-append" style="width:10%">
                                    <button type="button" onclick="deleteRow(` + index + `)" class="btn btn-danger btn-sm">
                                        <span class="fa fa-minus"></span><span class="btn_text-` + index + `"></span>
                                    </button>
                                </div>
                            </div>
                        </td>
                        </tr>`;
            $('#index_num').val((index));
            $('#tbl_body').append(returnData);
            initSelect2();
        }

        function setDataForQuotation(i) {
            $('#quotation_id').val(i);
            returnData = '';
            var quotation = quotationData[i];
            $('#vendor_id').html(`<option value="` + quotation.supplier_id + `">` + quotation.supplier.name_eng +
                `</option>`);
            $('#discount').val(quotation.discount);
            data = quotation.details.filter(item => item.status == 2);
            if (data.length > 0) {
                for (let index = 0; index < data.length; index++) {
                    rowForCallMethod[index] = index;
                    returnData += `<tr id="tr-` + index + `">
                                        <td>` + (index + 1) + `</td>
                                        <td>
                                            <div class="d-flex text-center">
                                            <span onclick="load_po_history('` + quotation.id + `', '` + data[index]
                        .product_id + `')"> ` + data[index].product.name_eng + `</span>
                                            <input type="hidden" name="product_id[` + index + `]" id="product_id` +
                        index + `" class="form-control" value="` + data[index].product_id + `">
                                            </div>
                                        </td>
                                        <td>
                                            <input type="text" name="desc[` + index + `]" id="desc` + index + `" class="form-control">
                                        </td>`;
                    // returnData+=` <td>`+data[index].quantity+`</td>`;
                    returnData += `<td class="text-right"> <input type="number" min="0" step=".01" name="avail_quantity[]"
                                                id="avail_quantity` + index + `" class="form-control"  value="` + (
                        data[index].product.availQty ? data[index].product.availQty.avail : 0) + `" readonly>
                                                </td>
                                                <td class="text-right"> <input type="text" name=""
                                                id="pre_purchase_date` + index + `" class="form-control" readonly>
                                                </td>
                                                <td class="text-right"> <input type="text" name=""
                                                id="pre_purchase_rate` + index + `" class="form-control" readonly>
                                                </td>`;

                    returnData += `<td class="text-center">
                                            <input type="number" min="0"  name="req[` + index + `]"
                                            id="req` + index + `" step=".01" class="form-control-sm" value="` + data[
                        index].quantity + `" readonly>
                                        </td>`;

                    returnData += `<td class="text-center">
                                                        <input type="number" min="0" onkeyup="setSubtotal('` + index +
                        `')"  name="quantity[` + index + `]" id="quantity` + index +
                        `" step=".01" class="form-control-sm" value="` + data[index].quantity + `">
                                                        <input type="hidden" name="quotation_rate[` + index +
                        `]" id="quotation_rate` + index + `" class="form-control" value="` + data[index].rate + `">
                                                        </td>
                                                    <td>
                                                        <input type="number" onkeyup="setSubtotal('` + index +
                        `')" min="0" step=".01"  name="rate[` + index + `]"
                                                            id="rate` + index + `" class="form-control-sm" value="` +
                        data[index].rate + `">
                                                    </td>
                                                    <td class="text-right">
                                                        <input type="number" min="0" step=".01"  name="subtotal[` +
                        index + `]"
                                                            id="subtotal` + index + `" class="form-control-sm subtotal" readonly value="0">
                                                    </td>
                                                    </tr>`;
                    $('#index_num').val('');
                    $('#index_num').val(parseInt(index) + 1);
                }

            }
            // returnData+=`<tr>
        //                 <th colspan="6" class="text-right">Total</th><th> <input type="number" min="0" step=".01"  name="total_amount"
        //                                         id="total_amount" class="form-control-sm total_amount" readonly></th></tr>
        //             <tr>
        //                 <th colspan="6" class="text-right">Discount (%)</th><th> <input type="number" max="100" step=".01"  name="discount"
        //                 id="discount" class="form-control-sm discount"></th><th> <input type="number"  name="discount_amount"
        //                 id="discount_amount" class="form-control-sm discount_amount" readonly></th>
        //             </tr>
        //             <tr>
        //                 <th colspan="6" class="text-right">Net Amount</th><th> <input type="number"  name="net_amount"
        //                 id="net_amount" class="form-control-sm net_amount" readonly></th>
        //             </tr>`;
            $('#tbl_body').html(returnData);
            if (rowForCallMethod.length > 0) {
                for (let p = 0; p < rowForCallMethod.length; p++) {
                    setSubtotal(p);
                }
            }
            getSum();
            $("#install_model").modal("hide");
            $("#nav-home-tab").click();
        }

        function getAvailQTY(pro_id, i) {
            var store_table_type = store_setting.store_table_type; //$('#store_table_type').val();
            $(`#quantity${i}`).attr('readonly', false);
            $(`#approx_rate${i}`).attr('readonly', false);
            $.each(liveSearchedDataSet, function(index, pro) {
                if (pro.id == pro_id) {
                    $('#unit_name' + i).text(pro.primary_unit.name);
                }
            });
            $.ajax({
                url: '/purchase/invoice-transaction/avail-qty/' + pro_id + '/' + store_table_type,
                method: "get",
                dataType: 'JSON',
                data: {},
                success: function(data) {
                    console.log(data, 'g');
                    var t = data;
                    var preHistory = t.length > 0 ? (t.get_previous_purchase_history.length > 0 ? t
                        .get_previous_purchase_history[0] : null) : null;
                    $('#avail_quantity' + i).val(t.avail_qty ? t.avail_qty.avail : 0);
                    $('#pre_purchase_date' + i).val((!preHistory ? 'No Purchase Info Found' :
                        getFormatedDateDMY(preHistory.date)));
                    $('#pre_purchase_rate' + i).val((!preHistory ? 'No Purchase Info Found' : preHistory
                    .price));
                    // console.log("indent", data);
                },
                error: function(data) {
                    alert('Something Went Wrong.!');
                    console.log(data);
                }
            });

        }


        function getSum() {
            var sum = 0;
            $('.subtotal').each(function() {
                sum += parseFloat(this.value);
            });
            $('#total_amount').val(sum);
            setDiscount();
        }

        function setSubtotal(i) {
            var subtotal = 0;
            var qty = parseFloat($('#quantity' + i).val());
            var rate = parseFloat($('#rate' + i).val());
            $('#subtotal' + i).val((qty * rate));
            getSum();
            setDiscount();
        }

        function setDiscount() {
            var total = 0;
            var discount_amount = 0;
            var discount_rate = (parseFloat($('#discount').val()) / 100);
            total = $('#total_amount').val();
            discount_amount = (discount_rate * total)
            $('#discount_amount').val(discount_amount);
            $('#net_amount').val(total - discount_amount);
            // getSum();
        }

        function deleteRow(row_id) {
            $('#tr-' + row_id).remove();
            getSum();
        }

        function initSelect2() {
            liveSearch('new_product', '/product-live-search', false, title = 'Select Product');

            // productSearch('new_product');
            // $('.new_product').select2({
            //             minimumInputLength: 3,
            //             // tags: [],
            //             ajax: {
            //                 url: "/product-live-search",
            //                 dataType: 'json',
            //                 type: "POST",
            //                 quietMillis: 50,
            //                 data: function (term) {
            //                     return {
            //                         _token: "{{ csrf_token() }}",
            //                         type: 2,
            //                         p_ids: [],
            //                         name: term
            //                     };
            //                 },
            //                 processResults: function (data) {
            //                     return {
            //                         results: $.map(data, function (item) {
            //                             return {
            //                                 text: item.name_eng + ' -- ' + item.barcode,
            //                                 id: item.id
            //                             }
            //                         })
            //                     };
            //                 }
            //             }
            //         });
        }
    </script>
@stop