@extends('admin.layout.master')
@section('title',__('accounts.voucher_management'))
@section('custom_style')
<style>
   
    .card-body{
        padding:.25rem !important;
    }
  

    .table tbody th, .table tbody td {
        padding: 0.15rem 0.35rem !important;
        vertical-align: top !important;
    }  
    .row_secondary th,td{
        padding: 0 !important;
    }
</style>

<style>
    
    /*============================================
                AUTOCOMPLETE
    ===================================== */
    .cl-autocomplete {
        position: relative;
        display: block;
    }

    .cl-autocomplete-container {
        position: absolute;
        border: 1px solid var(--cl-gray-100);
        border-radius: 0.5rem;
        border-bottom: none;
        border-top: none;
        top: 60%;
        left: 0;
        right: 0;
        max-height: 12rem;
        overflow-x: hidden;
        overflow-y: scroll;
        z-index: 60;
    }

    .cl-autocomplete-container div {
        padding: 0.12rem 0.4rem;
        height: 1.75rem;
        cursor: pointer;
        background-color: var(--cl-white);
        border-bottom: 1px solid var(--cl-gray-100);
    }

    .cl-autocomplete-container div:hover {
        background-color: var(--cl-gray-200);
    }

    .cl-autocomplete-active {
        background-color: var(--cl-primary) !important;
        color: var(--cl-white);
    }
    .voucher_title{
        border: 2px black solid;
        padding: 4px;
        margin: 0 0 2px 0;
        border-radius: .35rem;
    }
    .fa {
        font-size:0.70rem !important;
    }

    .add_ledger_model_btn {
        /* display:none !important; */
    }
    .vcl-voucher-input {
        border: 1px solid #ced4da;
        box-shadow: none;
        outline: none;
        background-color: #fff;
    }
    .cl-voucher-input:focus,.vcl-voucher-input {
        border: 1px solid #ced4da;
        box-shadow: none;
        outline: none;
        background-color: #fff;
    }
    .cl-table th:first-child, .cl-table td:first-child {
        background-color: var(--cl-primary);
    }
</style>

<style>
            
        /*============================================
                cursor Auto Complete
        ===================================== */
        .cursor-autocomplete-container {
            position: absolute;
            border: 1px solid var(--cl-gray-100);
            border-radius: 0.5rem;
            border-bottom: none;
            border-top: none;
            top: 100%;
            left: 0;
            right: 0;
            max-height: 10rem;
            overflow: hidden auto;
            z-index: 60;
        }

        .cursor-autocomplete-container div {
            padding: 0.12rem 0.4rem;
            height: 1.75rem;
            cursor: pointer;
            background-color: var(--cl-white);
            border-bottom: 1px solid var(--cl-gray-100);
            white-space: nowrap;
        }

        .cursor-autocomplete-container div:hover {
            background-color: var(--cl-primary);
            /* background-color: var(--cl-gray-200); */
        }
        .cursor-autocomplete-active {
            background-color: var(--cl-primary) !important;
            color: var(--cl-white);
        }
        .cl-voucher-input {
            height: 1.75rem;
        }
        .form-control {
            margin-bottom: 0.25rem;
        }
        .select2-container {
            flex: 1;
        }
        .form-label {
            display: inline-flex;
            margin-bottom: 0;
            width: 11rem;
        }
        .form-label::after {
            content: ':' !important,
            
        }
        .cl-btn {
            height: 1.75rem;
        }
        @media (min-width: 992px) {
            #roeLabel {
                width: 2.5rem
            }
        }
</style>
@endsection
@section ('content')
@php
    $cashSl=1000;
    $discountSl=2000;
    $isBankOrCash=in_array($voucher_type['type'],[2,4])?1:0;        
    $isPaymentOrReceipt=in_array($voucher_type['type'],[3,4])?1:0; //check receipt
    $parentId=intval($isBankOrCash?getInitDataWithKeyWord('bank')->group_id:getInitDataWithKeyWord('cash')->group_id);
   
@endphp   
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>__('accounts.'.$voucher_type['name']).($voucher_type['is_request']?(' ('.__('obs.request').')'):'')])
<div class="wrapper m-3 mt-0">
    <nav class="my-1">
        @include('v2.accounts.voucher.install_ledger_by_group_form',['button_type'=>'button'])
    </nav>
    <div class="tab-content" id="nav-tabContent">
        <div class="tab-pane fade show active" id="voucher" role="tabpanel" tabindex="0">
            <div class="row d-flex justify-content-start">
                <div class="col-lg-3 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.branch')}} :</strong>
                        @include('admin.inputs.warehouse_select')
                    </div>
                </div>

                <div class="col-lg-5 col-md-6">
                    <div class="d-flex"></div>  
                </div>

                <div class="col-lg-4 col-md-6">
                    <div class="d-flex">
                        <strong class="d-flex me-2 text-left form-label" >{{__('obs.voucher_no')}}</strong>
                        <input type="text" name="voucher_no" style="flex: 1;" id="voucher_no" class="form-control voucher_no" value="{{isset($transactions)?$transactions->voucher_no:1}}"/>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6">
                    <div class="d-flex">
                        <strong class="d-flex me-2 text-left form-label">{{__('obs.voucher_date')}} : </strong>
                        <input type="hidden" id="voucher_type" value="{{$voucher_type['type']}}">
                        <input type="hidden" id="modified_voucher_type" value="{{$voucher_type['type']}}">
                        <input type="hidden" id="voucher_id" value="{{isset($transactions)?$transactions->id:''}}">
                        @if(isset($transactions))
                            <input type="date" name="date" id="voucher_date" style="flex: 1;" class="form-control" min="{{getAllowedPostDate()}}" max="{{getAllowedPostDate(1)}}" value="{{$transactions->date?date('Y-m-d',strtotime($transactions->date)):date('Y-m-d')}}" />
                        @else
                            <input type="date" name="date" id="voucher_date" style="flex: 1;" class="form-control" min="{{getAllowedPostDate()}}" max="{{getAllowedPostDate(1)}}" value="{{session('voucher_date')?date('Y-m-d',strtotime(session('voucher_date'))):date('Y-m-d')}}" />
                        @endif    
                    </div>
                </div>

                <div class="col-lg-5 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.cost_center')}}</strong>
                        <select name="cost_center_id" style="flex: 1;" id="cost_center_id" onchange="setCostCenterForAll(this.value)" class="select_2 form-control">
                            <option value="0">{{'ALL'}}</option>
                            @forelse ($cost_centers as $cost_center)
                                <option @if(isset($transactions) && $transactions->cost_center_id==$cost_center->id) selected @endif value="{{$cost_center->id}}">
                                    {{$cost_center->name}}
                                </option>
                                @empty
                            @endforelse
                        </select>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.currency')}}</strong>
                        <select name="currency" style="flex: 1;" onchange="currencyChange(-1)" id="currency" class="select_2 form-control">
                            @forelse ($currency as $item)
                                <option value="{{$item->id}}" {{$item->is_primary == 1 ? 'selected' : ''}} roe="{{$item->roe}}">{{$item->name}}</option>
                                @empty
                            @endforelse
                        </select>
                    </div>
                </div>

                <div class="col-lg-1 col-md-6 ps-lg-1">
                    <div class="d-flex">
                        <strong id="roeLabel" class="me-2 text-right form-label" title="RateOfExchange">{{__('obs.rate_of_exchange')}} : </strong>
                        <input step=".000000000000000001" style="flex: 1;" onchange="currencyChange(this.value)" type="text" name="roe" id="roe" class="form-control roe" value="{{isset($transactions)?$transactions->roe:1}}"/>
                        <input class="form-control" style="flex: 1;" step=".000000000000000001" type="hidden" id="currency_id" name="currency_id" value="{{$currency->where('is_primary',1)->first() ? $currency->where('is_primary',1)->first()->id : 1}}" required>
                    </div>
                </div>
            </div>
            <div class="row d-flex justify-content-start">
                <div class="col-lg-3 col-md-6"></div> 

                <div class="col-lg-5 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.voucher_group')}}</strong>
                        <select name="voucher_group" width="100%" id="voucher_group" style="flex: 1;" class="voucher_group cost_center_journal form-control">
                            @forelse (getVoucherGroups($voucher_type['type']) as $k=>$vg)
                                <option value="{{$k}}">{{$vg}}</option>
                            @empty
                                
                            @endforelse
                        </select>
                    </div>
                </div>

                <div class="col-lg-4 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.reference')}}</strong>
                        <input list="reff_no" type="text" name="reff" id="reff" style="flex: 1;"
                            class="form-control reff" value="{{isset($transactions)?$transactions->reff_no:''}}"/>
                        <datalist id="reff_no">
                            @forelse (getVoucherGroups($voucher_type['type'],'reff_no') as $reff_no)
                                <option value="{{$reff_no}}">
                            @empty
                            @endforelse
                        </datalist>
                    </div>
                </div>
            </div>
            <div class="row d-flex justify-content-start">
                <div class="col-lg-3 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.doc_type')}} : </strong>
                        <input type="text" name="doc_type" style="flex: 1;" id="doc_type" class="form-control doc_type" value="{{isset($transactions)?$transactions->doc_type:''}}"/>
                    </div>
                </div>

                <div class="col-lg-5 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.doc_no')}} : </strong>
                        <input type="text" name="doc_no" style="flex: 1;" id="doc_no" class="form-control doc_no" value="{{isset($transactions)?$transactions->doc_no:''}}"/>
                    </div>
                </div>

                <div class="col-lg-4 col-md-6">
                    <div class="d-flex">
                        <strong class="me-2 text-left form-label">{{__('obs.attachment_number')}} : </strong>
                        <input type="text" name="number_of_attachment" style="flex: 1;" id="number_of_attachment" class="form-control number_of_attachment" value="{{isset($transactions)?$transactions->number_of_attachment:''}}"/>
                    </div>
                </div>
            </div>
            <div class="cl-table-container rounded-2" style="height: 50vh">
                <table class="table mb-0 rounded-2 cl-bg-transparent cl-table cl-voucher-table table-borderless"
                    style="min-width: 992px">
                    <thead>
                        <tr>
                            <th class="" scope="col" style="width: 40px">#</th>
                            <th scope="col" class="text-center group_column" style="width: 15%">{{__('obs.group')}}</th>
                            <th scope="col">{{__('obs.particulars')}}</th>
                            <th class="text-end align-middle" scope="col" style="width: 100px">{{__('obs.cost_center')}}</th>
                            <th class="text-end align-middle" scope="col" style="width: 120px">{{__('obs.debit')}}</th>
                            <th class="text-end align-middle" scope="col" style="width: 120px">{{__('obs.credit')}}</th>
                            <th class="text-end align-middle" scope="col" style="width: 10px">
                                <button type="button" class="add_ledger_model_btn btn cl-btn btn-warning" onclick="getNewRow()"><i class="fa fa-plus"></i></button>
                            </th>
                        </tr>
                        <tr></tr>
                    </thead>
                    <tbody>
                        <tr style="height: 0.5rem"></tr>
                        @for ($i =1 ; $i <2; $i++)
                            <tr id="row_id-{{$i}}" data-row_id="{{$i}}" class="cl-voucher-row row-{{$i}}">
                                <th scope="row" class="cl-fixed-cell voucher-sl">{{$i}}</th>
                                <td>
                                    <div class="position-relative d-flex">
                                        <input id="group_row-{{$i}}" type="text" class="form-control cursor-autocomplete">
                                        <button type="button" class="search_group_by_modal btn cl-btn cl-btn-primary ms-1" onclick="openAccountsGroupDetailsModal({{$i}})"><i class="fa fa-download"></i></button>
                                    </div>
                                </td>
                                <td>
                                    <div class="position-relative">
                                        <div id="parent-{{$i}}" class="d-flex">
                                            <input type="text" onkeydown="selectionOnkeyMovement(event)" id="ledger_id-{{$i}}" data-id="{{$i}}" data-ledger_id="" data-balance_limit="" data-reference_type="" data-balance_setting="" class="form-control vcl-voucher-input cl-voucher-input cl-autocomplete cl-autocomplete-{{$i}}">
                                            <button type="button" class="search_ledger_by_modal btn cl-btn cl-btn-primary ms-1" onclick="openAccountsLedgerDetailsModal({{$i}})"><i class="fa fa-download"></i></button>
                                            <button type="button" class="add_ledger_model_btn btn cl-btn ms-1" onclick="openSlideModal({{$i}})"><i class="fa fa-plus"></i></button>
                                        </div>
                                        <div class="position-relative d-flex align-items-center">
                                            <div class="col flex-grow-0">
                                                <span id="msg-{{$i}}" class="nowrap"></span><span id="show_bal-{{$i}}"></span>
                                            </div>
                                            <div class="col flex-grow-1">
                                                <input type="text" id="note-{{$i}}" class="form-control cl-voucher-input row_secondary">
                                            </div>
                                        </div>
                                    </div>
                                </td>
                                
                                <td>
                                    <select name="cost_center_journal" width="100%" id="cost_center_journal-{{$i}}" class="select_2 cost_center_journal form-control">
                                        <option value="0">{{'ALL'}}</option>
                                        @forelse ($cost_centers as $cost_center)
                                            <option value="{{$cost_center->id}}">
                                                {{$cost_center->name}}
                                            </option>
                                        @empty
                                        @endforelse
                                    </select>
                                </td>
                                <td class="text-end">
                                    <input step="0.00001" type="number" class="currency_conversion dr_amount form-control cl-form-control cl-voucher-input text-end" id="dr_amount-{{$i}}" onkeyup="updateObjectForSubmit({{$i}},0,this)">
                                    <br>
                                    <span id="dr_amount_msg-{{$i}}"></span>
                                </td>
                                    <td class="text-end">
                                        <input step="0.00001" type="number" class="currency_conversion cr_amount form-control cl-form-control cl-voucher-input text-end" id="cr_amount-{{$i}}" onkeyup="updateObjectForSubmit({{$i}},1,this)">
                                        <br>
                                        <span id="cr_amount_msg-{{$i}}"></span>
                                    </td>
                                <td></td>
                            </tr>
                        @endfor
                    </tbody>
                </table>
            </div>

            <div class="d-flex justify-content-between mt-3">
                <div class="me-3">
                    <div>
                        <strong>{{__('obs.narration')}} <span class="text-danger">[Ctrl+Space]<span></strong>
                    </div>

                    <div>
                        <textarea list="note_list" name="" id="voucher_notes" class="form-control cl-form-control vcl-voucher-input voucher-narration" cols="50">{{isset($transactions)?$transactions->note:''}}</textarea>
                    </div>
                </div>
                @if($voucher_type['type']<5)
                <div class="text-center" id="voucher_error">
                </div>
                @endif
                <div class="d-flex align-items-start justify-content-end">
                    <div style="width: 120px" class="text-end border-top border-bottom border-dark">
                        <input type="number" class="form-control cl-form-control vcl-voucher-input text-end"
                        id="dr_total_amount" readonly>
                    </div>
                    <div style="width: 130px" class="text-end border-top border-bottom border-dark">
                        <input type="number" class="form-control cl-form-control vcl-voucher-input text-end"
                        id="cr_total_amount" readonly>
                    </div>
                    <br>
                </div>
            </div>
            <div class="d-flex align-items-start justify-content-end">
                <div class="input-group-append">
                    <div class="hidden_content hidden_input">
                        <button class="btn-sina-title-add hidden_content hidden_input btn cl-btn" style="min-width: 50px;" id="submit_buttom" onclick="setSubmitableData()"><i class="fa fa-save"></i> {{__('obs.save')}}</button>
                    </div>
                </div>
            </div>
    </div>

    <div class="tab-pane fade" id="invoice" role="tabpanel" tabindex="0"> 
    </div>
</div>
</div>
@include('admin.global.loader')
@include('admin.slider.global_slider')
@include('accounts.voucher.modal_accounts_ledger')
@include('accounts.voucher.modal_head_accounts_code')
@include('accounts.voucher.modal_previous_voucher')
@endsection
@section('script')
<!-- page script -->
<script type="text/javascript">
$('.select_2').select2();   
$('#voucher_group').select2({
    tags: true
});   
let rawData=[];
let preSearch='';
let preItems=[];
let cost_centers=@json($cost_centers);
let voucher_type=@json($voucher_type['type']);
let isPaymentOrReceipt=[3,4].includes(voucher_type)?1:0;
// let initSl=(voucher_type==5)?1:1000;
let sl = @json($i>2?($i):1);//($voucher_type['type']==5?1:1)
let cashSl=1000;
let discountSl=2000;
</script>
@include('admin.utilities.cursor_autocomplete')
<script>
    let voucherTransactions=@json(isset($transactions)?$transactions->journals:[]);
    let voucher=@json(isset($transactions)?$transactions:[]);
    let voucher_edit_id=@json(Request()->voucher_id??0);
    let is_request_voucher=@json($voucher_type['is_request']);
    const resetForm=(inSl)=>{
        $('#group_row-'+inSl).val('');
        $('#ledger_id-'+inSl).val('');
        $('#msg-'+inSl).val('');
        $('#note-'+inSl).val('');
        $('#cr_amount-'+inSl).val('');
        $('#dr_amount-'+inSl).val('');
    }
    $(document).ready(function(){
       resetForm(1);
       if(voucher_type<5){
           resetForm(cashSl);
           resetForm(discountSl);
       }
       
        if(voucher_edit_id){
            setDataToPreviousVoucher(0,voucher.id,voucher.voucher_no,voucher_edit_id);
        }
    });
    // AUTOCOMPLETE INPUT
    const closeAllLists = () => {
        const allOption = document.querySelector('.cl-autocomplete-container');

        if (allOption)
            allOption.remove()
    }

    const filterOption = (inputField, dataArray) => {
        const inputValue = inputField.value;
        return dataArray.filter((el) => (el.auto_code+'--'+el.name).toLowerCase().includes(inputValue.toLowerCase()))
        // return dataArray.filter(data => data.name.toLowerCase().indexOf(inputValue.toLowerCase()) !== -1)
    }

    const getJournalVoucherData = (id,inputField) => {
        let selectData = [];
        let inVal={};
        inVal.term=inputField.value;
        let link="{{route('accounts_settings.ledger_search')}}";
        let data_param={
            search_type:(id==1000)?5:2,
            group_code:(id==1000)?([1,3].includes(voucher_type)?1:2):null,
            name: inVal
        }
        const setBalance = response => {
            selectData = response;
            preItems=selectData;
            selectData =  filterOption(inputField, selectData);
            closeAllLists()
            currentFocus = -1;
            $(setOption(inputField, selectData)).appendTo('#parent-'+id);
            $('#loader').hide();
        }
        ajaxCall(link,'GET',data_param, setBalance);
    }
    const removeActive = (options) => {
        for (const item of options) {
            item.classList.remove("cl-autocomplete-active")
        }
        setDataForSubmit();
    }

    const addActive = (options,c) => {
        if (!options) return false;
        removeActive(options);
        if (currentFocus >= options.length) currentFocus = 0;
        if (currentFocus < 0) currentFocus = (options.length - 1);
        console.log(currentFocus,c);
        options[currentFocus].classList.add("cl-autocomplete-active");
    }
    const boldString=(str, substr)=> {
        var strRegExp = new RegExp(substr, 'gi');
        return str.replace(strRegExp, '<strong>'+substr+'</strong>');
    }
    const setOption=(inputField,dataArray)=>{
        let inputValue = inputField.value;
        let html=`<div class="cl-autocomplete-container">`;
            dataArray.map(item => {
                let textel=boldString(item.auto_code+'--'+item.name,inputValue);
                html+=`<div class='' onclick="showCurrentBalance(${inputField.dataset.id},${item.id},${item.balance_setting},'${item.reference_type}',${item.balance_limit},${item.auto_code},'${item.name.replace(/'/g, '&lsquo;')}')">${textel}</div>`;
                // html+=`<div class='' onclick="showCurrentBalance(${inputField.dataset.id},${item.id},${item.balance_setting},'${item.reference_type}',${item.balance_limit},'${item.name.replace(/'/g, '&lsquo;')}')">${textel}</div>`;
            });
            
            html+=`</div>`;
            return html;
    }
    let currentFocus=0;
    const selectionOnkeyMovement = (e) => {
        // console.log('e:',e);
        let options = document.querySelector('.cl-autocomplete-container');
        if (options) options = options.getElementsByTagName("div");
        if (e.keyCode == 40) {
            currentFocus++;
            addActive(options,currentFocus);
        } else if (e.keyCode == 38) {
            currentFocus--;
            addActive(options,currentFocus);
        } else if (e.keyCode == 13) {
            e.preventDefault();
            if (currentFocus > -1) {
                // console.log('selected',currentFocus);
                if (options){
                    options[currentFocus].click();
                } 
            }
        }
    }
    const initiatAutoComplete=(id,cls)=>{
        var cl_autocom = document.getElementsByClassName(cls);
        Array.from(cl_autocom).forEach(function(el) {
          el.addEventListener("input", function (e) {
              const target = e.target;
              const isAutocompleteInput = target.classList.contains(cls);
              const inputLength = target.value.length;
              const inputV = target.value;
              
              if (isAutocompleteInput && inputLength > 2) {
                  const regexp = new RegExp('^'+preSearch, 'i');
                  if(preSearch && regexp.test(inputV)){
                    selectData =  filterOption(target, preItems);
                    closeAllLists();
                    currentFocus = -1;
                    $(setOption(target, selectData)).appendTo('#parent-'+id);
                }else{
                    getJournalVoucherData(id,target)
                }
                preSearch=inputV;
                //   closeAllLists();
              } else {
                closeAllLists();
              }
          })
        });
    }


    // ADD/REMOVE CLASS ON INPUT FOCUS
    const cl_inputs = '.cl-voucher-input';

    $(document).on('focus', cl_inputs, function () {
        $(this).parents('tr').addClass('cl-bg-primary-transparent');
        // autocomplete(document.querySelectorAll(".cl-autocomplete"), selectData);
    })

    $(document).on('blur', cl_inputs, function () {
        $(this).parents('tr').removeClass('cl-bg-primary-transparent');
        if ($(this).parent().find('.popup-msg')) {
            $(this).parent().find('.popup-msg').remove();
        }
    });

    
    const initialRow =(i,cls='new-cl-voucher-input')=>{ //t=1 for dr t=2 for cr
        let returnStr=`<tr id="row_id-${i}" data-row_id="${i}" class="cl-voucher-row row-${i}">
                            <th scope="row" class="cl-fixed-cell voucher-sl">${(i==0?(sl):i)}</th>
                            <td>
                                <div class="position-relative d-flex">
                                    <input id="group_row-${i}" type="text" class="form-control cursor-autocomplete">
                                    <button type="button" class="search_group_by_modal btn cl-btn cl-btn-primary ms-1" onclick="openAccountsGroupDetailsModal(${i})"><i class="fa fa-download"></i></button>
                                </div>
                            </td>
                            <td>
                                <div class="position-relative">
                                    <div id="parent-${i}" class="d-flex">
                                        <input type="text" onkeydown="selectionOnkeyMovement(event)" id="ledger_id-${i}" data-id="${i}" data-ledger_id="" data-reference_type="" data-balance_setting="" class="form-control ${cls} cl-autocomplete cl-autocomplete-${i}">
                                        <button type="button" class="search_ledger_by_modal btn cl-btn cl-btn-primary ms-1" onclick="openAccountsLedgerDetailsModal(${i})"><i class="fa fa-download"></i></button>
                                        <button type="button" class="add_ledger_model_btn btn cl-btn ms-1" onclick="openSlideModal(${i})"><i class="fa fa-plus"></i></button>
                                    </div>
                                    <div class="position-relative d-flex align-items-center">
                                        <div class=" flex-grow-0">
                                            <span class="nowrap" id="msg-${i}"></span><span id="show_bal-${i}"></span>
                                        </div>
                                        <div class="col flex-grow-1">
                                            <input type="text" id="note-${i}" class="form-control ${cls} row_secondary">
                                        </div>`;
                                    returnStr+=`</div>
                                </div>
                            </td>
                            <td>
                                <select name="cost_center_journal" width="100%" id="cost_center_journal-${i}" class="jr_select_2 cost_center_journal form-control">
                                    <option value="0">{{'ALL'}}</option>
                                    @forelse ($cost_centers as $cost_center)
                                        <option value="{{$cost_center->id}}">
                                            {{$cost_center->name}}
                                        </option>
                                    @empty
                                    @endforelse
                                </select>
                            </td>
                            <td class="text-end">
                                <input step="0.00001" type="number" class="currency_conversion dr_amount form-control cl-form-control cl-voucher-input text-end" id="dr_amount-${i}" onkeyup="updateObjectForSubmit(${i},0,this)" value="0">
                                <br>
                                <span id="dr_amount_msg-${i}"></span>

                            </td>`;
                            returnStr+=`<td class="text-end">
                                <input step="0.00001" type="number" class="currency_conversion cr_amount form-control cl-form-control cl-voucher-input text-end" id="cr_amount-${i}" onkeyup="updateObjectForSubmit(${i},1,this)" value="0">
                                <br>
                                <span id="cr_amount_msg-${i}"></span>
                            </td>`;
                            returnStr+=`<td><button class="btn cl-btn btn-danger" onclick="removeRow(${i})"> <u>X</u> </button></td>
                        </tr>`;
            return returnStr;
    }
    const removeRow=(id)=>{
        $('#row_id-'+id).remove();
        if(id>0){
            rawData=rawData.filter( t  => t.id != id);
            $('#ledger_id-'+(id-1)).focus();
        }else{
            $('#ledger_id-1').focus();
        }
        setSumForTransactionTotal();
    } 
    //$('.cl-voucher-row');

    $(document).on('keydown', cl_inputs, function (e) {
        const This = $(this);
        if (This.is(":focus") && e.which === 13) {
            const target = $(".cl-voucher-input").eq($(".cl-voucher-input").index($(This))+1);
            if (target.length === 0) {
                let csl=$(this).attr('id').match(/\d+/)[0];
                console.log('enter csl',csl,);
                let ledger_id=$('#ledger_id-'+csl).attr('data-ledger_id');
                if(ledger_id){
                    getNewRow(This);
                }else{
                    $('#msg-'+csl).html('<b class="text-danger">*Required*</b>');
                }
            } else {
                target.focus();
            }
        }
    })
    const getNewRow=(This=0)=>{
        sl++;
        let newRow = initialRow(sl,'cl-voucher-input');
        $(newRow).appendTo('.cl-voucher-table tbody');
        initiatAutoComplete(sl,'cl-autocomplete-'+sl);
        cursorAutoComplete('cursor-autocomplete');
        $('.jr_select_2').select2();
        if(This){
            This.parents('tr').next().find('.cl-voucher-input').first().focus();
        }
        setDataForSubmit();
    }
    const setNewRowWithoutCalculation=()=>{
        sl++;
        let newRow = initialRow(sl);
        $(newRow).appendTo('.cl-voucher-table tbody');
        initiatAutoComplete(sl,'cl-autocomplete-'+sl);
    }

    //  KEYBOARD SHORTCUTS 
    $(window).on('keydown', function (e) {
        if (e.ctrlKey && e.which === 32) {//ctrl+Space
            const target = $('.voucher-narration');
            if (target.length > 0) {
                target.focus();
            }
        }
        if(e.ctrlKey && e.which === 83) {//ctrl+S
            e.preventDefault();
            $('#submit_buttom').trigger('click');
        }
        if(e.ctrlKey && e.which === 88) {//ctrl+X
            e.preventDefault();
            var row_id = e.target.closest('tr').dataset.row_id;
            if(row_id>1){
                Swal.fire({
                    icon: 'warning',
                    title: 'DELETE ROW',
                    html: 'Are You Sure?',
                    showConfirmButton: true,
                    showDenyButton: true,
                    position: 'center',
                    timer: null,
                }).then((res) => {
                    console.log(res);
                    if(res.isConfirmed){
                        removeRow(row_id);
                    }
                });
            }
            console.log(row_id);
            // $('#submit_buttom').trigger('click');
        }
    })
    for (let index = 1; index <= (sl+1); index++) {
        initiatAutoComplete(index,'cl-autocomplete-'+index);
        console.log(index);
    }
    
    cursorAutoComplete('cursor-autocomplete');
    cursorAutoComplete('voucher_cost_center',['name','name'],cost_centers);
    const updateObjectForSubmit=(id,type,This=null)=>{
        let amount=Number($((type?'#cr_amount-':'#dr_amount-')+id).val()??0);
        let ledger_id=$('#ledger_id-'+id).attr('data-ledger_id');
        let cost_center_journal=$(id==1000?'#cost_center_id':('#cost_center_journal-'+id)).val();
        let reference_type=Number($('#ledger_id-'+id).attr('data-reference_type'));
        let against_amt=Number($((type?'#dr_amount-':'#cr_amount-')+id).val()??0);
        let availableRowsCheck=0;
        if(This){
            let cls=(type?'.cr_amount':'.dr_amount');
            console.log('this call',cls);
            availableRowsCheck=$(cls).eq( $(cls).index($(This) ) + 1).length;
        }
        // if(amount>0 || id>0){
        if(amount>0 && id>0){
            $((type?'#dr_amount-':'#cr_amount-')+id).val('');
            let data_pass={'id':id,'ledger_id':ledger_id,'amount':amount,'cost_center_id':cost_center_journal,'note':'','cheque_number':'','cheque_date':'','type':type,'reference_type':reference_type}
            let item = rawData.find( t  => t.id == id);
            if(item){
                item.ledger_id=ledger_id;
                item.reference_type=reference_type;
                item.amount=amount;
                item.type=type;
                item.cost_center_id=cost_center_journal;
            }else{
                rawData.push(data_pass);
            }            
        }else{
            if(!(against_amt>0)){
                rawData=rawData.filter( t  => t.id != id);
            }
        }
        if(availableRowsCheck){
            setDataForSubmit();
        }
        console.log(rawData);
        setSumForTransactionTotal();
    }
    const setSumForTransactionTotal=()=>{
        $('#submit_buttom').hide();
        var dsum=0;
        var csum=0;
        $('.dr_amount').each(function(){
            dsum += Number(this.value);//==''?0:this.value);
        });
        $('.cr_amount').each(function(){
            csum += Number(this.value);//==''?0:this.value);
        });
        let tDrSum=parseFloat(dsum).toFixed(2);
        let tCrSum=parseFloat(csum).toFixed(2);
        $('#dr_total_amount').val(tDrSum);
        $('#cr_total_amount').val(tCrSum);
        if(tCrSum==tDrSum){
            $('#submit_buttom').show();
        }else{
            console.log(dsum,csum,'amount_mismatch');
        }
    }
    const setDataForSubmit=()=>{
        let dTotal=0;
        let cTotal=0;
        let total_sl=sl;
        $('.dr_amount').each(function(){
            if(!((this.id).replace(/[^0-9]/g,'')==total_sl)){
                dTotal+=Number(this.value);
            }
        });
        $('.cr_amount').each(function(){
            if(!((this.id).replace(/[^0-9]/g,'')==total_sl)){
                cTotal+=Number(this.value);
            }
        });
        
        if(dTotal>cTotal){
            $('#cr_amount-'+total_sl).val(parseFloat(dTotal-cTotal).toFixed(2));
            updateObjectForSubmit(sl,1);
        }else if(dTotal<cTotal){
            $('#dr_amount-'+total_sl).val(parseFloat(cTotal-dTotal).toFixed(2));
            updateObjectForSubmit(sl,0);
        }else if(rawData.length && (dTotal==cTotal)){
            $('#submit_buttom').show();
        }
        checkVoucherTypeValidation();
    }
    // const XsetDataForSubmit=(v=0)=>{
    //     let voucherType=Number($('#voucher_type').val());
    //     let isVoucherErrorFree=0;
    //     let checkType=voucherType<3?1:0;
    //     let checkReff=[1,3].includes(voucherType)?1:2;
    //     if(rawData.length){
    //         let dTotal=0;
    //         let cTotal=0;
    //         for (let index = 0; index < rawData.length; index++) {
    //             // if(v==0 && rawData[index]<sl){
    //                 let reffT=Number(rawData[index].reference_type);
    //                 if(rawData[index].type==0){
    //                     dTotal+=Number(rawData[index].amount);
    //                 }else{
    //                     cTotal+=Number(rawData[index].amount);
    //                 }
    //             // }
               
    //             if(voucherType<5){
    //                 console.log(rawData[index],'-',voucherType,checkType,checkReff);
    //                 if(reffT && (reffT==checkReff) && (rawData[index].type==checkType)){
    //                     isVoucherErrorFree=1;
    //                 }
    //             }else{
    //                 isVoucherErrorFree=1;
    //             }
    //         }
    //         if(dTotal>cTotal){
    //             $('#cr_amount-'+sl).val(parseFloat(dTotal-cTotal).toFixed(2));
    //             updateObjectForSubmit(sl,1);
    //         }else if(dTotal<cTotal){
    //             $('#dr_amount-'+sl).val(parseFloat(cTotal-dTotal).toFixed(2));
    //             updateObjectForSubmit(sl,0);
    //         }else if(rawData.length && (dTotal==cTotal)){
    //             $('#submit_buttom').show();
    //         }
    //         if(isVoucherErrorFree==1){
    //             $('#voucher_error').hide();
    //         }else{
    //             $('#voucher_error').show();
    //         }
    //     }else{
    //         // $('#submit_buttom').hide();
    //     }
    // }
    const checkVoucherTypeValidation=()=>{
        let voucherType=Number($('#voucher_type').val());
        let isVoucherErrorFree=0;
        let checkType=voucherType<3?1:0;
        let checkReff=[1,3].includes(voucherType)?1:2;
        for (let index = 0; index < rawData.length; index++) {
            if(voucherType<5){
                let reffT=Number(rawData[index].reference_type);
                console.log(rawData[index],'-',voucherType,checkType,checkReff);
                if(reffT && (reffT==checkReff) && (rawData[index].type==checkType)){
                    isVoucherErrorFree=1;
                }
            }else{
                isVoucherErrorFree=1;
            }
        }
        if(isVoucherErrorFree==1){
            $('#voucher_error').hide();
        }else{
            $('#voucher_error').show();
        }
    }
    
    const showCurrentBalance=(id,ledger_id,balance_setting,reference_type,balance_limit,auto_code,name,shouldNotUpdate=1)=>{
        inputField=document.getElementById('ledger_id-'+id);
        inputField.value = name+' -- '+auto_code;
        inputField.dataset.ledger_id = ledger_id;
        inputField.dataset.balance_setting = balance_setting;
        inputField.dataset.reference_type = reference_type;
        inputField.dataset.balance_limit = balance_limit;
        
        $('#msg-'+id).html('');
        let link="{{route('api.get_ledger_balance')}}";
        if(id==1000){
            $('#group_row-'+id).val(auto_code).attr('data-auto_code',auto_code)
        }
        if(balance_setting!=2){
            let data_param={
                end_date:$('#voucher_date').val(),
                cost_center_id:$('#cost_center_id').val(),
                ledger_id:ledger_id
            }
            const setBalance = html => {
                let balance=parseFloat(html.closing?html.closing:0).toFixed(2);
                if(balance_setting!=4){
                    $('#show_bal-'+id).html("balance:<b>**"+(balance<0?((-1)*balance)+'**(CR)':balance+'**(DR)')+"</b>");
                }
                if(balance_setting>2){
                    let restrict_balance=(balance-parseFloat(balance_limit));
                    if(restrict_balance>0){
                        $('#cr_amount-'+id).attr('max',restrict_balance);
                    }else{
                        $('#dr_amount-'+id).attr('max',restrict_balance*(-1));
                    }
                }
                $('#loader').hide();
            }
            ajaxCall(link,'GET',data_param, setBalance);
        }
        if(!(reference_type=='null') && reference_type==2){
            getAvailaibleChequeNo(id,ledger_id);
            $('#cheque_no-'+id).show('slow').addClass('cl-voucher-input');
            $('#cheque_date-'+id).show('slow').addClass('cl-voucher-input');
            // $('.third-col, .fourth-col').removeClass('d-none');
            initDatePicker();
        }else{
            $('#cheque_no-'+id).hide('slow').removeClass('cl-voucher-input');
            $('#cheque_date-'+id).hide('slow').removeClass('cl-voucher-input');
        }
        //close all dropdown options click event
        closeAllLists();
        let drAmt=Number($('#dr_amount-'+id).val()??0);
        let crAmt=Number($('#cr_amount-'+id).val()??0);
        console.log(drAmt,crAmt,'k');
        if(shouldNotUpdate){
            //Initial ledger update on object RawData
            updateObjectForSubmit(id,drAmt>crAmt?0:1);
        }else if(drAmt>0||crAmt>0){
            updateObjectForSubmit(id,drAmt>crAmt?0:1);
        }
        //focus next input on dropdown option click event
        const targetedInputField = $(".cl-voucher-input").eq($(".cl-voucher-input").index($(inputField))+1);
        targetedInputField.focus();
    }
    const getAvailaibleChequeNo=(row_id,ledger_id,cn=null)=>{
        var chequeOptions='';
        let link="{{route('cheque.search')}}";
        let data_param={
            ledger_id:ledger_id,
        }
        const setBalance = data => {
            if(data.length>0){
                for (let index = 0; index < data.length; index++) {
                    chequeOptions+=`<option value="`+data[index].check_number+`">`;
                }
            }
            if(cn){
                chequeOptions+=`<option value="`+cn+`" selected>`;
            }
            $('#cheque_list-'+row_id).html(chequeOptions);
            $('#loader').hide();
        }
        ajaxCall(link,'GET',data_param, setBalance);
    }
    const validationChecked=()=>{
        let error=0;

        if(Number($('#dr_total_amount').val())==Number($('#cr_total_amount').val())){
            if(rawData.length){
                let typeError=1;
                for (let index = 0; index < rawData.length; index++) {
                    let dataUpdate=rawData[index];
                    if(!dataUpdate.ledger_id){
                        $('#msg-'+dataUpdate.id).html('<b class="text-danger">Please Select Ledger!</b>');
                        error=1;
                    }else{
                        if(dataUpdate.amount<1){
                            $('#'+(dataUpdate.type==0?'d':'c')+'r_amount_msg-'+dataUpdate.id).html('<b class="text-danger">Amt Pls!</b>');
                            console.log('Amt'+dataUpdate.id);
                            error=1;
                        }else{
                            let bs= Number($('#ledger_id-'+dataUpdate.id).attr('data-balance_setting'));
                            let rt= Number($('#ledger_id-'+dataUpdate.id).attr('data-reference_type'));
                            rawData[index].note=$('#note-'+dataUpdate.id).val();
                            if(rt==2){//here we should check cheque number and date
                                let cheque_no=$('#cheque_no-'+dataUpdate.id).val();
                                let cheque_date=$('#cheque_date-'+dataUpdate.id).val();
                                if((cheque_no && cheque_date)){
                                    rawData[index].cheque_number=cheque_no
                                    rawData[index].cheque_date=cheque_date
                                }else{
                                    $('#msg-'+dataUpdate.id).html('<b class="text-danger nowrap">Please Set Cheque!</b>');
                                    error=1;
                                }
                            }
                            if(bs>2){
                                let maxBal=Number($('#'+(dataUpdate.type==0?'d':'c')+'r_amount').attr('max'));
                                console.log('max',maxBal);
                                if(dataUpdate.amount>maxBal){
                                    $('#'+(dataUpdate.type==0?'d':'c')+'r_amount_msg-'+dataUpdate.id).html('<b class="text-danger">Limit Exceeded!</b>');
                                    error=1;
                                }
                            }
                        }
                    }
                }
                
            }else{
                error='Please Add Some Data';
            }
        }else{
            error='Debit and Credit Amount Should be Equal';
        }
        return error;
    }
    const setSubmitableData=()=>{
        setDataForSubmit();
        let errorMsg=validationChecked();
        if(!errorMsg){
            Swal.fire({
                icon: 'success',
                title: 'Confirmation',
                html: 'Are You Sure?',
                showConfirmButton: true,
                showDenyButton: true,
                position: 'center',
                timer: null,
            }).then((res) => {
                // Swal.fire('Saved but Check!', '', 'warning');
                if(res.isConfirmed){
                    saveVoucher();
                }
            });
        }else{
            console.log(errorMsg,'errorMsg');
            Swal.fire(errorMsg, '', 'warning');
            return;
        }
    }
    const saveVoucher=()=>{
        let link="{{route('voucher.voucher_posting_store')}}";
        let c=null;
        let int_data_param={
            date:$('#voucher_date').val(),
            type:$('#voucher_type').val(),
            transaction_type:'',//$('#voucher_type').val(),//for opening
            voucher_id:$('#voucher_id').val(),
            cost_center_id:$('#cost_center_id').val(),
            reff:$('#reff').val(),
            voucher_group:$('#voucher_group').val(),
            voucher_notes:$('#voucher_notes').val(),
            is_request_voucher:is_request_voucher,
            transaction_amount:$('#dr_total_amount').val(),
            currency:$('#currency').val(),
            roe:$('#roe').val(),
            journals:rawData
        }
        if(voucher_type<5){
            int_data_param.reff_ledger_id=$('#ledger_id-1000').attr('data-ledger_id');
        }
        if(voucher_type==5){
            int_data_param.doc_type=$('#doc_type').val();
            int_data_param.doc_no=$('#doc_no').val();
            int_data_param.number_of_attachment=$('#number_of_attachment').val();
        }
        const setReloadtHtml = data => {
            // if(data.id==0){
            //     console.log(data);
            //     $('#loader').hide();
            //     return;
            // }else{
                // if(data.id){ 
                    Swal.fire('Successfull Action', '', 'success');
                    location.href=data.url;
                // }
            // }
        }
        console.log('Save Data',int_data_param);
        ajaxCallV2(link,'POST',int_data_param, setReloadtHtml);
    }
    var prev_curr_val = 1;
    var price=[];
    const currencyChange=(current_roe)=> { 
        if (current_roe == -1) {
            current_roe = $('#currency option:selected').attr('roe');
            currency_id = $('#currency').val();
            $('#currency_id').val(parseFloat(currency_id));
        }
        $('#roe').val(parseFloat(current_roe));
        $('.currency_conversion').each(function(i) {
            if(this.value>0){
                let id=(this.id).replace(/[^0-9]/g,'');
                let t=(this.id).charAt(0)=='d'?0:1;
                let item = rawData.find( t  => t.id == id);
                if(item.type==t){
                    price[i] = parseFloat((item.amount*prev_curr_val)/current_roe);
                    item.amount=price[i];
                    this.value=(item.amount).toFixed(2);
                }
            }
        });
        prev_curr_val = current_roe; 
        setSumForTransactionTotal(); 
    }
    let groupData=[];
    $(document).ready(function() {
        let int_data_param={
            search_type:1
        }
        const setGroupData=(data)=>{
            groupData=data
            let options=``;
            for (let index = 0; index < groupData.length; index++) {
                const group_row = groupData[index];
                options+=`<option value="${group_row.auto_code}">${group_row.auto_code+' -- '+group_row.name}</option>`
            }
            $('#accounts_group').html(options);
            $('#accounts_group').select2();
            
            $('#loader').hide();
        }
        ajaxCall("{{route('accounts_settings.ledger_search')}}",'GET',int_data_param, setGroupData);
    });
    const openAccountsGroupDetailsModal=(row_id)=>{
        //$("#voucher_model_edit_call").modal("hide");
        var returnData=``;
        $('#load_table_modal_accounts_head').dataTable().fnDestroy();
        if(groupData.length>0){
            for (let index = 0; index < groupData.length; index++) {
                returnData+=`<tr onclick="setGroupDataToSelector('`+row_id+`',`+groupData[index].id+`,`+groupData[index].auto_code+`,'`+groupData[index].name+`')" role="row" class="odd">
                            <td>`+(index+1)+`</td>
                            <td>`+groupData[index].auto_code+`</td>
                            <td>`+groupData[index].name+`</td>
                        </tr>`;
            }
        }
        $('#load_tbody_modal_accounts_head').html(returnData);
        $("#accounts_group_model").modal("show");

        $('#load_table_modal_accounts_head').DataTable({
            "destroy": true,
        });
    }
    const setGroupDataToSelector=(row_id,id,auto_code,name)=>{
        // $('#group_row-'+row_id).val(auto_code);
        $('#group_row-'+row_id).val(row_id==1000?auto_code:name);
        $('#group_row-'+row_id).attr('data-auto_code',auto_code);
        $("#accounts_group_model").modal("hide");
        openAccountsLedgerDetailsModal(row_id);
    }
    const openAccountsLedgerDetailsModal=(id)=>{
        $('#load_table_modal_accounts_ledger').dataTable().fnDestroy();
        // var group_code=$('#group_row-'+id).val();
        var group_code=$('#group_row-'+id).attr('data-auto_code');
        var returnData=``;
        let int_data_param={};
        if(id==1000){
            let inVal={};
            inVal.term='';
            int_data_param.search_type=5;
            int_data_param.group_code=[1,3].includes(voucher_type)?1:2;
            int_data_param.name= inVal;
        }else{
            int_data_param.group_code=group_code;
        }
        const setLedgerData=(data)=>{
            if(data.length>0){
                for (let index = 0; index < data.length; index++) {
                    returnData+='<tr onclick="setDataToSelector(`'+id+'`,`'+data[index].id+'`,`'+data[index].balance_setting+'`,`'+data[index].reference_type+'`,`'+data[index].balance_limit+'`,`'+data[index].auto_code+'`,`'+data[index].name+'`)" role="row" class="odd">';
                    returnData+='<td class="sorting_1">'+(index+1)+'</td>';
                    returnData+='<td>'+(data[index].parent?data[index].parent.auto_code:'')+'</td>';
                    returnData+='<td>'+(data[index].parent?data[index].parent.name:'')+'</td>';
                    returnData+='<td><b>'+data[index].auto_code+'</b></td>';
                    returnData+='<td><b>'+data[index].name+'</b></td></tr>';
                }
            }
            $('#load_tbody_modal_accounts_ledger').html(returnData);
            $("#accounts_ledger_model").modal("show");
            $('#load_table_modal_accounts_ledger').DataTable({
                "destroy": true,
            });
            $('#loader').hide();
        }
        ajaxCall("{{route('accounts_settings.ledger_search')}}",'GET',int_data_param, setLedgerData);
    }
    const setDataToSelector=(row_id,id,balance_setting,reference_type,balance_limit,auto_code,name)=>{
        showCurrentBalance(row_id,id,balance_setting,reference_type,balance_limit,auto_code,name);
        $("#accounts_ledger_model").modal("hide");
    }
    const setCostCenterForAll=(cost_id)=>{
        $('.cost_center_journal').each(function(){
            $(this).val(cost_id).trigger('change');
        });
    }
// install from ............
    function install_form(){
        // install_type 0=>voucher 1=>sales invoice 3=>purchase invoice 4=>lab
        var payment_voucher_no=$('#payment_voucher_no').val();
        var install_type=$('#install_type').val();
        var start=$('#start_date').val();
        var end=$('#end_date').val();
        var returnData=``;
        console.log('install_type',install_type);
        if(install_type==0){
            clearFormAndObject();
        }
        if(payment_voucher_no){
            setDataToPreviousVoucher(install_type,0,payment_voucher_no);
        }else{
            $('#previous_voucher_model_table').dataTable().fnDestroy();
            let int_data_param={
                start:start,
                end:end,
                type:voucher_type,
                install_type:install_type,
            }
            const setGroupData=(data)=>{
                if(data.length>0){
                    let html=``;
                    if(install_type>0){
                        html+=`<th>SL</th><th>Date</th><th>Voucher No</th><th>Reff No</th><th>Due</th><th>Amount</th>`;
                    }else{
                        html+=`<th>SL</th><th>Date</th><th>Voucher No</th><th>Amount</th>`;
                    }
                    $('#install_table_header').html(html);
                    for (let index = 0; index < data.length; index++) {
                        returnData+=`<tr onclick="setDataToPreviousVoucher(${install_type},${data[index].id},'${install_type>0?data[index].reff_no:data[index].voucher_no}')" role="row" class="odd">
                                        <td>${(index+1)}</td>
                                        <td>${data[index].date}</td>
                                        <td><b>${data[index].voucher_no}</b></td>`;
                                if(install_type>0){
                                    returnData+=`<td><b>${data[index].reff_no}</b></td>
                                                <td><b>${data[index].due}</b></td>`;
                                }
                                returnData+=`<td><b>${data[index].transaction_amount}</b></td></tr>`;
                    }
                }
                $('#load_tbody_previous_voucher_model').html(returnData);
                $("#previous_voucher_model").modal("show");
                $('#previous_voucher_model_table').DataTable({
                    "destroy": true,
                });
            }
            $('#loader').hide();
            ajaxCall("{{route('voucher.voucher_search')}}",'GET',int_data_param, setGroupData);
        }
    }
    function setDataToPreviousVoucher(install_type,voucher_id,voucher_no,edit_id=0) {
        var returnData='';
        var cb_returnData='';
        let int_data_param={
            voucher_no:voucher_no,
            install_type:install_type
        }
        if(edit_id){
            int_data_param.voucher_id=edit_id;
        }
        const setGroupData=(data)=>{
            var costCenter=[];
            let main_ledger=data.reff_ledger;
            if(install_type>0){
                if(![1000,2000,1].includes(sl)){
                    getNewRow();    
                }
                showCurrentBalance(sl,main_ledger.id,main_ledger.balance_setting,main_ledger.reference_type,main_ledger.balance_limit,main_ledger.auto_code,main_ledger.name);
                $(`#${isPaymentOrReceipt?'cr':'dr'}_amount-${sl}`).val(data.due);
                $(`#note-${sl}`).val(data.note);
                // $(`#cost_center_journal-${sl}`).val(cost_center_id).trigger('change');
            }else{
                let journals=data.journals;
                if(edit_id){
                    $('#voucher_date').val(getFormatedDateCustom(data.date));
                    $('#voucher_type').val(data.type);
                    $('#voucher_id').val(data.id);
                    $('#cost_center_id').val(data.cost_center_id).trigger('change');
                    $('#reff').val(data.reff_no);
                    $('#voucher_group').val(data.voucher_group);
                    $('#voucher_notes').val(data.voucher_notes);
                }
                if(journals.length>0){
                    let nsl=0;
                    for (let m = 0; m < journals.length; m++) {
                        let jrLedger=journals[m].global_ledger;
                        let jrType=journals[m].type;
                        let jrLedger_id=journals[m].ledger_id;
                        let jrCost_center_id=journals[m].cost_center_id;
                        let jrCheck_number=journals[m].cheque_info?journals[m].cheque_info.check_number:'';
                        let jrCheck_date=journals[m].cheque_info?journals[m].cheque_info.initial_cheque_details[0].cheque_date:'';
                        let jrAmount=journals[m].amount;
                        let jrNote=journals[m].note;
                        let mslp=0;
                        
                        if(voucher_type<5){
                            if (jrLedger_id==main_ledger.id){
                                mslp=1000;
                            }else if((isPaymentOrReceipt==1 && jrType==0)||(isPaymentOrReceipt==0 && jrType==1)){
                                mslp=2000;
                            }else{
                                nsl++;
                            }
                        }else{
                            nsl++;
                        }

                        console.log('nsl',nsl,isPaymentOrReceipt,jrType,sl,voucher_type);
                        if(![1000,2000,1].includes(mslp>0?mslp:nsl)){
                            console.log('getNewRow',nsl);
                            setNewRowWithoutCalculation();    
                        }
                        let msl=mslp>0?mslp:nsl;
                        $(`#${jrType==1?'cr':'dr'}_amount-${msl}`).val(jrAmount);
                        // $(`#ledger_id-${msl}`).val(jrLedger.id);
                        $(`#note-${msl}`).val(jrNote);
                        $(`#cost_center_journal-${msl}`).val(jrCost_center_id).trigger('change');
                        setLedgerInRow(msl,jrLedger.id,jrLedger.balance_setting,jrLedger.reference_type,jrLedger.balance_limit,jrLedger.auto_code,jrLedger.name,0);
                        // showCurrentBalance(msl,jrLedger.id,jrLedger.balance_setting,jrLedger.reference_type,jrLedger.balance_limit,jrLedger.auto_code,jrLedger.name,0);
                        let data_pass={'id':msl,'ledger_id':jrLedger.id,'amount':jrAmount,'cost_center_id':jrCost_center_id,'note':jrNote,'cheque_number':'','cheque_date':'','type':jrType,'reference_type':jrLedger.reference_type}
                        let item = rawData.find( t  => t.id == msl);
                        if(item){
                            item.ledger_id=jrLedger.id;
                            item.reference_type=jrLedger.reference_type;
                            item.amount=jrAmount;
                            item.type=jrType;
                            item.cost_center_id=jrCost_center_id;
                        }else{
                            rawData.push(data_pass);
                        }
                        setSumForTransactionTotal();  
                        // updateObjectForSubmit(msl,jrType);
                    }
                    //ForsetNewRowWithoutCalculation
                    cursorAutoComplete('cursor-autocomplete');
                    $('.jr_select_2').select2();
                }
            }
            $('#loader').hide();
        }
        ajaxCall("{{route('voucher.voucher_search')}}",'GET',int_data_param, setGroupData);
        $("#previous_voucher_model").modal("hide");   
    }
    function loadLedger(type=0) {
        let accounts_group=$('#accounts_group').val();
        let int_data_param={
            group_code:accounts_group
        }
        const setGroupData=(data)=>{
            // if(type==0){
            //     clearAllRowFromDom();
            // }
            console.log(data,'datalll');
            $('#loader').hide();
            // let i=1;
            for (let index = 0; index < data.length; index++) {
                let main_ledger = data[index];
                
                if(index>0){
                    setNewRowWithoutCalculation();    
                }
                setLedgerInRow(sl,main_ledger.id,main_ledger.balance_setting,main_ledger.reference_type,main_ledger.balance_limit,main_ledger.auto_code,main_ledger.name);
                // i++;
            }
            // ForsetNewRowWithoutCalculation
            cursorAutoComplete('cursor-autocomplete');
            $('.jr_select_2').select2();
        }
        ajaxCall("{{route('accounts_settings.ledger_search_by_group_code')}}",'GET',int_data_param, setGroupData);
        // $("#previous_voucher_model").modal("hide");   
    }
    const clearFormAndObject=()=>{
        for (let index = 0; index < rawData.length; index++) {
            $(`#ledger_id-${rawData[index].id}`).val('')
            .attr('data-ledger_id','')
            .attr('data-balance_limit','')
            .attr('data-reference_type','')
            .attr('data-balance_setting','');
            $(`#show_bal-${rawData[index].id}`).val('');
            $(`#note-${rawData[index].id}`).val('');
            $(`#${rawData[index].type?'cr':'dr'}_amount-${rawData[index].id}`).val('');
            if([1000,2000,1].includes(rawData[index].id)){
                $('#row_id-'+index).remove();
            }
            rawData=rawData.filter( t  => t.id != rawData[index].id);
        }
        sl=1;
    }
    const clearAllRowFromDom=()=>{
        for (let index = 2; index <= sl; index++) {
            $('#row_id-'+index).remove();
            rawData=rawData.filter( t  => t.id != index);
        }
        sl=1;
    }
</script>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
<script>
// const install_excel_to_form=()=>{
    const excel_file = document.getElementById('excel_file');
    excel_file.addEventListener('change', (event) => {
        // if(!['application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/vnd.ms-excel'].includes(event.target.files[0].type)){
        //     document.getElementById('excel_data').innerHTML = '<div class="alert alert-danger">Only .xlsx or .xls file format are allowed</div>';
        //     excel_file.value = '';
        //     return false;
        // }
        var reader = new FileReader();
        reader.readAsArrayBuffer(event.target.files[0]);
        reader.onload = function(event){
            var data = new Uint8Array(reader.result);
            var work_book = XLSX.read(data, {type:'array'});
            var sheet_name = work_book.SheetNames;
            var sheet_data = XLSX.utils.sheet_to_json(work_book.Sheets[sheet_name[0]], {header:1});
            if(sheet_data.length > 0){
                console.log(sheet_data,'sheet_data');
                $('#loader').hide();
                let int_data_param={
                    sheet_data:sheet_data,
                    install_type:100,
                }
                const setRowData=(data)=>{
                    let nsl=0;
                    $('#loader').hide();
                    for (let i = 0; i < data.length; i++) {
                        let singleRow =data[i]
                        nsl++;
                        console.log((singleRow),'g')
                        
                        if(![1000,2000,1].includes(nsl)){
                            console.log('getNewRow',nsl);
                            setNewRowWithoutCalculation();    
                        }
                        if(singleRow.type){
                            $(`#cr_amount-${nsl}`).val(singleRow.amount);
                        }else{
                            $(`#dr_amount-${nsl}`).val(singleRow.amount);
                        }
                        $(`#${singleRow.type==1?'cr':'dr'}_amount-${nsl}`).val(singleRow.amount);
                        $(`#note-${nsl}`).val(singleRow.note);
                        // $(`#cost_center_journal-${sl}`).val(singleRow.cost_center_id).trigger('change');
                        setLedgerInRow(nsl,singleRow.id,singleRow.balance_setting,singleRow.reference_type,singleRow.balance_limit,singleRow.auto_code,singleRow.name,0);
                        let data_pass={'id':nsl,'ledger_id':singleRow.id,'amount':singleRow.amount,'cost_center_id':'','note':singleRow.note,'cheque_number':'','cheque_date':'','type':singleRow.type,'reference_type':singleRow.amount.reference_type}
                        let item = rawData.find( t  => t.id == nsl);
                        if(item){
                            item.ledger_id=singleRow.id;
                            item.reference_type=singleRow.reference_type;
                            item.amount=singleRow.amount;
                            item.type=singleRow.type;
                            // item.cost_center_id=jrCost_center_id;
                        }else{
                            rawData.push(data_pass);
                        } 
                        setSumForTransactionTotal();
                    }
                    // For-setNewRowWithoutCalculationY
                    cursorAutoComplete('cursor-autocomplete');
                    $('.jr_select_2').select2();
                }
                // ajaxCall("{{route('voucher.voucher_search')}}",'GET',int_data_param, setRowData);
                ajaxCall("{{route('voucher.voucher_search_excel')}}",'POST',int_data_param, setRowData);
                // var ledgerWiseIdsAndAmount =[];
                // for(var row = 0; row < sheet_data.length; row++){
                //     if(row>0){
                //         let singleRow={};
                //         for(var cell = 0; cell < sheet_data[row].length; cell++){
                //             if(cell==1){
                //                 singleRow['ledger_code']= sheet_data[row][cell];
                //             }
                //             if(cell==2){
                //                 singleRow['note']= sheet_data[row][cell];
                //             }
                //             if(cell==5){
                //                 singleRow['amount']= sheet_data[row][cell];
                //             }
                //             if((sheet_data[row].length+1)==cell){
                //                 ledgerWiseIdsAndAmount.push(singleRow);
                //             }
                //         }
                //     }
                // }
            }
            excel_file.value = '';
        }
    });
    const setLedgerInRow=(id,ledger_id,balance_setting,reference_type,balance_limit,auto_code,name,shouldNotUpdate=1)=>{
        inputField=document.getElementById('ledger_id-'+id);
        inputField.value = name+'--'+auto_code;
        inputField.dataset.ledger_id = ledger_id;
        inputField.dataset.balance_setting = balance_setting;
        inputField.dataset.reference_type = reference_type;
        inputField.dataset.balance_limit = balance_limit;
    }
</script>
@stop