@extends('admin.layout.master')
@section('title','VOUCHER MANAGEMENT')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number],input[type=date] {
    height: 30px !important;
}
.padding_apply{
    padding-left: 1px;
}
.table thead th {
    border: 1px solid black !important;
    text-align: center;
    vertical-align: middle;
    }
/* .table tbody td {
    border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;
    } */
.card-body{
    padding:.25rem !important;
}
/* #edit_card_box {      
 display : none; !important;      
 width :100%;      
 height : 100%;      
 background : rgba(50,50,50,0.5);      
 position : fixed;      
 top : 0;       
 z-index : 500;      
}
#popup{      
 background : white;      
 width : 400px;      
 height : 300px;      
 margin : 150px auto;      
}    */
.table th, .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           background: #ab3535;
           padding: 5px !important;
           color: white !important;
        }
.card-body{
    padding:.25rem !important;
}
.dataTables_filter {
    display: none;
}
.table_cell{
    border: 1px solid black !important;
    vertical-align: middle;
    padding: 2px 5px;
}
.hide_content{
    display:none;
} 
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'PAYABLE BILLS'])
    
                
    <div class="card-body">
        {{-- @forelse ($cashBanks as $cashBank)
                <option value="{{$cashBank->account_id}}" data-id="{{$cashBank->id}}" data-type="{{$cashBank->type}}" class="cash-bank-option-{{$cashBank->type}}">
                    {{ $cashBank->name_eng }}
                </option>
            @empty
            @endforelse
        --}}
        @php
            $types=[2=>'bank_payment',1=>'cash_payment',3=>'cash_receive',4=>'bank_receive',5=>'journal'];
            $routes=[2=>'voucher.bank_payment_vouchers',1=>'voucher.cash_payment_vouchers',3=>'voucher.cash_receive_vouchers',4=>'voucher.bank_receive_vouchers',5=>'voucher.journal_vouchers'];
            $filter_date_type=['date'=>'voucher date','preparation_date'=>'preparation_date','bill_date'=>'bill_date','created_at'=>'posting_date','approval_date'=>'approval_date'];
            $cashBankHtml='';
            foreach ($cashBanks as $cashBank){
                $selected='';
                if($cashBank->id==getDefaultCashBankId()){
                    $selected='selected="true"';
                }
                $cashBankHtml.='<option '.$selected.' value="'.$cashBank->account_id.'" data-id="'.$cashBank->id.'" data-type="'.$cashBank->type.'" class="cash-bank-option-'.$cashBank->type.'">'.$cashBank->name_eng .'</option>';
            }
        @endphp
        <form action="{{route('voucher.bill')}}" method="get">
            <div class="card-body"  style="margin-bottom: -14px">
                <div class="row justify-content-end">
                    <div class="col-md-2">
                        <label class="">DateType</label>
                        <div class="input-group">
                            <select name="filter_date" id="filter_date" class="select_2" style="min-width: 100%">
                                @forelse ($filter_date_type as $t=>$typ)
                                    <option value="{{$t}}" @if(request()->filter_date==$t) selected @endif>{{strtoupper(str_replace('_',' ',$typ))}}</option>
                                @empty   
                                @endforelse
                            </select>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <label class="">VoucherType</label>
                        <div class="input-group">
                            <select name="voucher_type" id="voucher_type" class="select_2" style="min-width: 100%">
                                <option value="">All</option>
                                @forelse ($types as $t=>$type)
                                    <option value="{{$t}}" @if(request()->voucher_type==$t) selected @endif>{{strtoupper(str_replace('_',' ',$type))}}</option>
                                @empty   
                                @endforelse
                            </select>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <label class="">Party</label>
                        <div class="input-group">
                            <select name="party" id="party" class="select_2" style="min-width: 100%">
                                <option value="0">Select Party</option>
                                @forelse ($party->groupBy('ledger_id') as $t=>$p)
                                    <option value="{{$t}}" @if(request()->party==$t) selected @endif>{{strtoupper(str_replace('_',' ',$p->first()->ledger->name))}}</option>
                                @empty   
                                @endforelse
                            </select>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <label class="approved_status">Status</label>
                        <div class="input-group">
                            <select name="approved_status" id="approved_status" class="select_2" style="min-width: 100%">
                                <option @if(request()->approved_status==200) selected @endif value="200">All</option>
                                <option @if(request()->approved_status==100) selected @endif value="100">Pending</option>
                                <option @if(request()->approved_status==1) selected @endif value="1">Approved</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-4 pl-0">
                        <label class="">Date</label>
                        <div class="d-flex flex-wrap">
                            <div class="col-md-10 input-group p-0">
                                <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: 30px;">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')}}"> 
                            </div>
                            <div class="col-md-2 p-0">
                                <button type="submit" class="btn btn-pill btn-sm btn-hover btn-danger">
                                    <i class="fa fa-search"></i>
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>
    </div>
    <hr>          
    
    <div class="card-body">
        <div class="row">
            <div class="col-md-12 table-responsive-sm" style="padding-bottom: 0;">
                <div class="input-group row justify-content-end">
                    
                </div>
                <div class="pro_trans_table" id="divTableDataHolder">
                    <div class="input-group row justify-content-between" style="background-color:rgba(27, 26, 77, 0.8);position: sticky; top: 80px;z-index:900;padding:5px 0;margin:auto">
                        <div class="input-group-append col" style="margin-left:15px;">
                            <button type="button" class="btn-xs btn-warning hidden_content" onclick="showButton(2)"><i class="fa fa-wrench"></i></button>
                            <button type="button" class="btn-xs btn-danger hidden_content" onclick="showButton(3)"><i class="fa fa-eraser"></i></button>
                        </div>
                        <div class="input-group col justify-content-end" style="margin-left:15px;">
                            <input type="date" id="preparation_date" class="">
                            <div class="input-group-append">
                                @if(checkAuthPermission('voucher.set_preparation_date'))
                                    <button type="button" class="btn btn-sm btn-info" onclick="setPreparationDate()">
                                        <span class="fa fa-calendar"></span> Set Date
                                    </button>
                                @endif
                            </div>
                            <div class="input-group-append">
                                @if(checkAuthPermission('voucher.cheque_allotment'))
                                    <button type="button" class="btn btn-sm btn-warning" onclick="openChequeModel()">
                                        <span class="fa fa-calendar"></span> Bill To Plan
                                    </button>
                                @endif
                            </div>
                        </div>
                    </div>
                    <table class="table table-bordered" id="data_table_apply">
                        <thead>
                            <tr>
                                <th class="text-nowrap text-center" style="width: 3%;padding: 0">
                                    <div class="form-check">
                                        <input class="form-check-input voucher_id_all" onclick="setAllChecked(this)" type="checkbox" value="1" id="voucher_id_all">
                                        <label class="form-check-label" for="voucher_id_all">
                                        </label>
                                    </div>
                                </th>
                                <th style="padding: 0;width:2%">#</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:5%">Vchr No</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:5%">Inv No</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:7%">Date</th>
                                {{-- @if((Request()->filter_date && (Request()->filter_date=='approval_date'))) --}}
                                    <th class="text-nowrap text-center hide_content1" style="padding: 0;width:2%">Apv.SL</th>
                                    {{-- <th class="text-nowrap text-center hide_content" style="padding: 0;width:7%">Apv.Date</th> --}}
                                {{-- @else
                                    <th class="text-nowrap text-center hide_content1" style="padding: 0;width:2%">Voucher Id</th>
                                    @endif --}}
                                <th class="text-nowrap text-center hide_content" style="padding: 0;width:2%">StoreID</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:10%">Store</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:5%">Bill No</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:7%">Bill Date</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:5%">Chln No</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:7%">Prep Date</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:18%">Party</th>
                                {{-- <th class="text-nowrap text-center" style="padding: 0;width:10%">Type</th> --}}
                                {{-- <th class="text-nowrap text-center" style="padding: 0;width:10%">Notes</th> --}}
                                <th class="text-nowrap text-center" style="padding: 0;width:10%">Amount</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:10%">Dues</th>
                                <th class="text-nowrap text-center" style="padding: 0;width:20%">Action</th>
                            </tr>
                        </thead>
                        <tbody class="item_tbody">
                                @php
                                    $searchedByGroup=(Request()->filter_date && (Request()->filter_date=='approval_date'))?$vouchers->sortBy('approvals.created_at'):$vouchers; 
                                @endphp
                                @forelse ($searchedByGroup as $key=>$voucher)
                                <tr>
                                    <td class="table_cell text-center">
                                        <div class="form-check">
                                            <input class="form-check-input voucher_to_set_preparation" name="voucher_to_set_preparation" @if($voucher->approved_status>0) disabled @endif type="checkbox" value="{{$voucher->id}}" id="voucher_id_{{$voucher->id}}">
                                            <label class="form-check-label" for="voucher_id_{{$voucher->id}}">
                                            </label>
                                        </div>
                                    </td>
                                    
                                    <td class="table_cell text-center">{{ $key+1}}</td>
                                    <td class="table_cell text-left">
                                        <a target="_blank" href="{{ route('voucher.voucher_details',['voucher_id'=>$voucher->id]) }}" class="text-dark">
                                            {{ $voucher->voucher_no }}
                                        </a>
                                    </td> 
                                    <td class="table_cell text-left">
                                        @php
                                            $reff=$voucher->reffInvoice??$voucher->reffFgInvoice;
                                            $printUrlArray=['','purchase-print?id=','purchase-print?id=','sell-print?id=','sell-print?id=','adjustment-print?id=','adjustment-print?id=','adjustment-print?id=','issue-print?id=','issue-print?id=','store_transfer-print?model=0&store_invoice_id=', 'store_transfer-print?model=1&store_invoice_id=', 'production-print?id=', 'opening-print?id=','','','adjustment-print?id=', 'purchase-contract-print?id=', 'sales-contract-print?id='];
                                        @endphp
                                        @if($reff)
                                            @if(!$reff->ref_type)
                                                <a target="_blank" href="{{ editInvoiceLink($reff->id,$reff->transaction_type) }}" style="display:none;padding:0 !important;" class="btn-xs btn-warning hidden_edit_btn"><i class="fa fa-wrench"></i></a>
                                            @endif
                                            <a target="_blank" href="{{ '/'.$printUrlArray[$reff->transaction_type].$reff->id }}" class="text-dark">{{$reff->invoice_no}}</a>
                                        @endif
                                    </td>
                                    <td class="table_cell text-center">
                                        {{ date('d-M-Y', strtotime($voucher->date))}}
                                    </td>
                                    {{-- @if((Request()->filter_date && (Request()->filter_date=='approval_date'))) --}}
                                        @php
                                            if($voucher->approvals && count($voucher->approvals)){
                                                $app_id=$voucher->approvals->first()->id;
                                                $app_date=$voucher->approvals->first()->created_at;
                                            }else{
                                                $app_id=8888888899;
                                            }//endif
                                            
                                        @endphp
                                        <td class="hide_content1 table_cell text-center" data-order="{{$app_id}}">{{$app_id}}</td>
                                        {{-- <td class="hide_content table_cell text-center">{{date('d-M-Y', strtotime($app_date))}}</td> --}}
                                    {{-- @else --}}
                                        {{-- <td class="hide_content1 table_cell text-center" data-order="{{$voucher->id}}">{{$voucher->id}}</td> --}}
                                    {{-- @endif --}}
                                        @php
                                        $journals=$voucher->journals->where('type',1);
                                        @endphp
                                    <td class="hide_content table_cell text-center" data-order="{{$voucher->warehouse_id}}">{{$voucher->warehouse_id}}</td>
                                    <td class="table_cell text-left">{{ $voucher->warehouse? $voucher->warehouse->name_eng:'' }}</td>
                                    <td class="table_cell text-left">{{ $voucher->bill_no }}</td>
                                    <td class="table_cell text-center">{{ $voucher->bill_date?date('d-M-Y', strtotime($voucher->bill_date)):''}}</td>
                                    <td class="table_cell text-left">{{ $voucher->reff_no }}</td>
                                    <td class="table_cell text-center">{{ $voucher->preparation_date?date('d-M-Y', strtotime($voucher->preparation_date)):''}}</td>
                                    <td class="table_cell text-left">{{ count($journals)? ($journals->first()->ledger->name):'' }}</td>
                                    {{-- <td class="table_cell text-left">{{ strtoupper(str_replace('_',' ',$types[$voucher->type]))}}</td> --}}
                                    {{-- <td class="table_cell text-left">{{ $voucher->note}}</td> --}}
                                    <td class="table_cell text-right">{{ $voucher->transaction_amount}}</td>
                                    <td class="table_cell text-right" id="due_{{$voucher->id}}">{{ number_format($voucher->due,2)}}</td>
                                    <td class="table_cell text-left">
                                        @if(checkAuthPermission('voucher.voucher_details'))
                                            <a target="_blank" href="{{ route('voucher.voucher_details',['voucher_id'=>$voucher->id]) }}" class="btn btn-sm btn-info">
                                                <span class="fa fa-eye"></span>
                                            </a>
                                        @endif
                                        @if(checkAuthPermission($routes[$voucher->type]) && checkAuthPermission('voucher.journal_voucher_update'))
                                            <a target="_blank" href="{{ route($routes[$voucher->type],['voucher_id'=>$voucher->id]) }}" class="btn btn-sm btn-info">
                                                <span class="fa fa-wrench"></span>
                                            </a>
                                        @endif
                                        @if($voucher->approved_status==0 && $voucher->preparation_date)
                                            @if(checkAuthPermission('voucher.set_approval_of_bill'))
                                                <button type="button" class="btn btn-sm btn-danger icon-size" onclick="setApprovedVoucher({{$voucher->id}})">Approve</button>
                                            @endif
                                        @endif
                                        @if($voucher->approved_status==1 && $voucher->preparation_date)
                                            <button type="button" class="btn-info" id="submit_allocation" onclick="showChequeList(this,{{$voucher}})">Add to Checque</button>
                                        @endif
                                        {{-- <button type="button" class="btn btn-sm btn-info" onclick="loadEditForm(`{{$voucher}}`)">
                                            <span class="fa fa-wrench"></span>
                                        </button> --}}
                                    </td>
                                </tr>   
                                @empty
                                @endforelse
                           
                        </tbody>
                        <tfoot>
                        </tfoot>
                    </table>
                </div>
            </div>
            <div class="col-md-12 text-center">
            </div>
        </div>
    </div>
    {{-- </fieldset> --}}
</div>
            
@include('admin.modals.cheque_detail_modal')
@endsection
@section('script')
<script>
    var vouchers=[];
    var j=100;
    var c_ids=[];
    // var bankId=null;
    $( document ).ready(function() {
        $('#data_table_apply').dataTable({
            "paging": false,
            "order": [[6, 'asc'], [5, 'asc']],
        });
    });
    $('.select_2').select2();
    initFlatpicker('cheque_date',"{{date('Y-m-d')}}");
    /////////
    let errorAry=[];
    const formSubmitCheck=()=>{
        var nonempty=$('.cheque_date').filter(function() {
            let reff=$(this).attr('data-row_id');
                if(this.value==''){
                    errorAry.push(reff);
                    $('#cheque_date_error'+reff).html("Please ! Select Cheque Date!!!!! ");
                }else{
                    $('#cheque_date_error'+reff).html("");
                }
                return this.value == ''
            });
        if (nonempty.length > 0) {
            for (let i = 0; i < errorAry.length; i++) {
                console.log(errorAry[i]);
                // $('#cheque_date_error'+errorAry[i]).html("Please ! Select Cheque Date!!!!! ");  
                $('#cheque_date_error'+errorAry[i]).show();  
            }
            return false;
        }else{
            $('#form').submit();
        }
    };
    ////////////
function setPreparationDate(){
    var preparationDate=$('#preparation_date').val();
    //console.log($('#preparation_date').val());
    if(preparationDate=='NaN-aN-aN'){
        alert('Please Set Preparation date');
        return 1;
    }
    var voucher_ids = [];
    $.each($("input[name='voucher_to_set_preparation']:checked"), function(){
        voucher_ids.push($(this).val());
    });
    if(voucher_ids.length>0){
        $.ajaxSetup({
            headers: {
                "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
                },
            });
        $.ajax({
            type: "GET",
            url: "{{route('voucher.set_preparation_date')}}",
            data: {
                voucher_ids:voucher_ids,
                p_date:preparationDate
            },
            success: function (data) {
                voucher_ids=data;
                location.reload();
            },
            error: function (response) {
            //
            },
        });
    }else{
        alert('Please Select Voucher');
    }
}

const showButton=(type)=>{
    if(type==3){
        $('.hidden_create_btn').hide();
        $('.hidden_edit_btn').hide();
    }else if(type==1){
        $('.hidden_create_btn').show();
        $('.hidden_edit_btn').hide();
    }else{
        $('.hidden_edit_btn').show();
        $('.hidden_create_btn').hide();
    }
}
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;
}

getAvailaibleChequeNo('cb0',1);
function getAvailaibleChequeNo(row_id){
    let bankId= $('#row-'+row_id+' option:selected').attr('data-id');
    let bankAcId= $('#row-'+row_id).val();
    sessionStorage.setItem("bankDefaultId", bankAcId);
    //initCheque(row_id);

    var chequeOptions='';
    $.ajaxSetup({
        headers: {"X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),},
    });
    $.ajax({
        type: "GET",
        url: "{{route('cheque.search')}}",
        data: {
            bank_id:bankId,
            c_ids: (c_ids.length == 0 ? [] : c_ids),
        },
        success: function (data) {
            if(data.length>0){
                console.log(data);
                for (let index = 0; index < data.length; index++) {
                    chequeOptions+=`<option value="`+data[index].check_number+`">`+data[index].check_number+`</option>`;
                }
            }
            console.log(chequeOptions);
            $('#cheque_no-'+row_id).html(chequeOptions);
            $('#cheque_no-'+row_id).select2();
            chequeNumberHtml=chequeOptions;
        },
        error: function (response) {
                //
        },
    });
}
setCids();
function setCids() {
    c_ids = [];
    $('.cheque_no').each(function(i) {
        if(this.value > 0)
            c_ids[i] = this.value;
        else
            c_ids[i] = 0;
    });
    console.log(c_ids);
}
// initCheque(0);
// function initCheque(row_id){
//     $('#cheque_no-cb'+row_id).select2({
//         minimumInputLength: 3,
//         // tags: [],
//         ajax: {
//             url: "{{route('cheque.search')}}",
//             dataType: 'json',
//             type: "GET",
//             quietMillis: 0,
//             data: function (term) {
//                 var bank_id=$('#row-cb'+row_id+' option:selected').attr('data-id');;
//                 return {
//                     bank_id:bank_id,
//                     c_ids: (c_ids.length == 0 ? [0] : c_ids),
//                     name: term
//                 };
//             },
//             processResults: function (data) {
//                 return {
//                     results: $.map(data, function (item) {
//                         return {
//                             text: item.check_number,
//                             // text: item.name_eng + ' -- ' + item.barcode,
//                             id: item.check_number
//                         }
//                     })
//                 };
//             }
//         }
//     });
// }
function setApprovedVoucher(voucher_id){
    if(confirm('are you sure?')){
        var voucher_ids = [];
        $.each($("input[name='voucher_to_set_preparation']:checked"), function(){
            voucher_ids.push($(this).val());
        });
        if(voucher_ids.length==0){
            voucher_ids.push(voucher_id);
        }
        $.ajax({
                type: "GET",
                url: "{{route('voucher.set_approval_of_bill')}}",
                data: {
                    voucher_id:voucher_ids,
                    status:2
                },
                success: function (data) {
                location.reload();
                },
                error: function (response) {
                },
            });
    }
}
function setAllChecked(elementBox){
    if(elementBox.checked) {
        $('.voucher_to_set_preparation').prop("checked", true);
    }else{
        $('.voucher_to_set_preparation').prop("checked", false);
    }
}
function showChequeList(btn,voucher){
    var ledger_id='';
    $.each(voucher.journals, function(index, item) {
        if(item.type==1){
            ledger_id=item.ledger_id;
        }
    });
    var ledgerid=filterLedgerVoucher(ledger_id);
    // alert(ledger_id);
    if(ledgerid){
        vouchers.push(voucher);
        btn.remove();
    }else{
        alert('Voucher Party Not Same !!!')
    }
    console.log(vouchers);
}
function filterLedgerVoucher(ledger_id){
    rawData=vouchers;
    var returnData=0;
    if(vouchers.length>0){
        for (let index = 0; index < rawData.length; index++) {
            $.each(rawData[index].journals, function(index, item) {
                if(item.type==1 && ledger_id==item.ledger_id){
                    returnData=ledger_id;
                }
            });
        }
    }else{
        returnData=ledger_id;
    }
    return returnData;
} 
function openChequeModel(){
    console.log(vouchers);
    $("#order_details_modal").modal("hide");
    var str ='';
    var total_due=0;
    rawData=[];
    if(vouchers.length>0){
        rawData=vouchers;
    }
    if(rawData.length>0){
        for (let index = 0; index < rawData.length; index++) {
                str += `<tr id="tr`+index+`">
                <td>`+(index+1)+`<input type="hidden" name="voucher_id[]" value="`+rawData[index].id+`"></td>
                <td>`+rawData[index].voucher_no+`</td>`;
                var cr_l=null;
                var ledger_id;
                $.each(rawData[index].journals, function(index, item) {
                    console.log(item);
                    if(item.type==1){
                        ledger_id=item.ledger_id;
                        cr_l=`<td>`+item.ledger.name+`</td>`;
                    }
                });
                str +=cr_l+`<input type="hidden" name="ledger_id" value="`+ledger_id+`"><input type="hidden" name="preparation_date" value="`+rawData[index].preparation_date+`">`;
                total_due=(total_due+parseFloat(rawData[index].due));
                str += `<td><input type="number" step=".01" value="`+parseFloat(rawData[index].due).toFixed(2)+`" name="amount[`+index+`]"
                        onkeyup="getSum()" class="form-control amount"/></td>`;
                str += `</tr>`;
        }
        // str += `<tr><td colspan="3" class="text-right">Total Bill</td>`;
        //         str += `<td>`+parseFloat(total_due).toFixed(2)+`</td>`;
        //         str += `</tr>`;

    }
    
    $('#tbl_body').html(str);
    $("#order_details_modal").modal("show");
    $('#first_cash_amount').val(total_due);
    getSum();
    getCrSum();
    if(vouchers.length>1){
        $('#add_btn').attr('disabled',true);
    }
}
function getSum(){
    var sum=0;
    $('.amount').each(function(){
        sum += parseFloat(this.value);
    });
    $('#total_amount').val(sum);
    setBalance();
}
function getCrSum(){
    var sum=0;
    setBalance();
    $('.c_amount').each(function(){
        sum += parseFloat(this.value);
    });
    $('#total_cr_amount').val(sum);
}
function setBalance(){
    var sum=0;
    var allCr=$('.c_amount');
    drSum=$('#total_amount').val();
    $('.c_amount').each(function(e){
        if(allCr.length>1 && (e==(allCr.length-1))){
            this.value=(drSum-sum);
        }else if(allCr.length==1){
            this.value=(drSum);
        }
        sum += parseFloat(this.value);
    });
    $('#total_cr_amount').val(sum);
}
function addCashBankRow(){
    j++;
    var returnData=`<tr data-id="cb`+j+`" id="entire_row-cb`+j+`" class="entire_row-cb`+j+`">
                    <td style="width: 3%;padding: 0" class="text-center">`+(j-99)+`
                        
                    </td>
                    <td class="padding_apply">
                        <div class="input-group">`;
                            
                            returnData+=`<select required id="row-cb`+j+`" onchange="getAvailaibleChequeNo('cb`+j+`')" name="cr_ledger_id[`+j+`]"" class="form-control item-cb`+j+` select_2" data-row_id="cb`+j+`" style="width: 90%">
                                {!!$cashBankHtml!!}
                            </select>
                        </div>
                    </td>`;
        returnData+=`<td class="padding_apply">
                        <div class="input-group"><input type="text" value="" id="name-cb`+j+`" name="cb_name[`+j+`]" class="form-control name"/></div>
                    </td>
                    <td class="padding_apply">
                        <div class="input-group">
                            <input type="text"
                                    value=""
                                    id="des-cb`+j+`"
                                    name="cb_des[`+j+`]""
                                    class="form-control des"/>
                        </div>
                    </td>
                    <td>
                        <div class="input-group" id="cheque_date_field-cb`+j+`" style="width:100%">
                            <input type="text" name="cheque_date[`+j+`]" id="cheque_date-cb`+j+`" data-row_id="`+j+`" class="form-control cheque_date" style="width: 70%" required/>
                        </div>
                        <span style="display:none" id="cheque_date_error`+j+`" class="text-danger"></span>
                    </td>
                    
                    <td>
                        <div class="input-group" id="cheque_no_field-cb`+j+`" style="width:100%">
                            
                            <select name="cheque_no[`+j+`]" id="cheque_no-cb`+j+`"
                                                                class="form-control cheque_no" style="width: 70%" onchange="setCids()">
                                                            </select>
                        </div>
                    </td>`;
        returnData+=`<td class="padding_apply">
                            <div class="input-group">
                            <input type="number" step=".01" onkeyup="getCrSum()" name="cr_amount[`+j+`]"" class="form-control c_amount" value="0.00"/>`;
        
            returnData+=`   <div class="input-group-append">
                                <button type="button" onclick="addCashBankRow()" class="btn btn-info">
                                    <span class="fa fa-plus"></span><span class="btn_text-cb`+j+`"></span>
                                </button>
                                <button type="button" onclick="deleteRow('cb`+j+`')" class="btn btn-danger">
                                    <span class="fa fa-minus"></span><span class="btn_text-cb`+j+`"></span>
                                </button>
                            </div>
                        </div>
                    </td>
                </tr>`;
                $('#voucher_cr_body').append(returnData);
                // search_group_with_code('cb'+j);
                $('.select_2').select2();
                //getGroupWiseLedgerInit('cb'+j);
                setCids();
                getAvailaibleChequeNo('cb'+j);
                initFlatpicker('cheque_date',"{{date('Y-m-d')}}");
                //initCheque(j);
    }
function deleteRow(row_id){
    var res = row_id.substring(0, 2);
    if(res=='cb'){
        $('.entire_row-'+row_id).remove();
        j--;
    }else{
        $('#entire_row-'+row_id).remove();
        j--;
    }
        getSum();
}
</script>
@stop