@extends('admin.layout.master')
@section('title','CHEQUE LIST STATEMENT')
@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;
}
    */
.table th, .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           background: var(--tableHeader);
           padding: 5px !important;
           color: white !important;
        }
.card-body{
    padding:.25rem !important;
}
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>__('cheque').' '.__('statement')])
    {{-- <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="card-title text-center">CHEQUE STATEMENT</h4>
    </div> --}}
                
    <div class="card-body">
        @php
            $types=getChequeType();
            $filter_date_type=['check_date'=>'cheque date','preparation_date'=>'preparation_date'];
            $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'];
        @endphp
        <form action="{{route('voucher.cheque_statement')}}" method="get">
            <div class="card-body"  style="margin-bottom: -14px">
                    <div class="row justify-content-end">
                        <div class="col-md-2 pl-3 pr-0">
                            <label class="" style="min-width: 100%">{{__('obs.date')}} {{__('obs.type')}}</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 pl-1 pr-0">
                            <div class="input-group">
                                <label class="" style="min-width: 100%">{{__('obs.cheque')}} {{__('obs.no')}} :</label>
                                <input type="text" name="check_number" id="check_number" class="form-control-sm" value="{{Request()->check_number}}">
                            </div>
                        </div>
                        <div class="col-md-2 pl-1 pr-0">
                            <div class="input-group">
                            <label class="" style="min-width: 100%">{{__('obs.voucher')}} {{__('obs.no')}} :</label>
                                <input type="text" name="voucher_no" id="voucher_no" class="form-control-sm" value="{{Request()->voucher_no}}">
                            </div>
                        </div>
                        <div class="col-md-2 pl-1 pr-0">
                            <div class="input-group">
                                <label class="" style="min-width: 100%">{{__('obs.party')}} {{__('obs.ledger')}} :</label>
                                <select name="ledger_id" id="ledger_id" class="select_2" style="min-width: 100%">
                                    <option value="">All</option>
                                    @forelse ($ledgerIds as $lid=>$name)
                                        <option value="{{$lid}}" @if(request()->ledger_id==$lid) selected @endif>{{strtoupper($name)}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2 pl-1 pr-0">
                            <div class="input-group">
                                <label class="" style="min-width: 100%">{{__('obs.status')}} :</label>
                                <select name="check_status" id="voucher_type" class="select_2" style="min-width: 100%">
                                    <option value="">All</option>
                                    @forelse ($types as $t=>$type)
                                        <option value="{{$t}}" @if(request()->check_status==$t) selected @endif>{{strtoupper(str_replace('_',' ',$type))}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2 pl-1 pr-3">
                            <div class="input-group">
                                <label class="" style="min-width: 100%">{{__('obs.bank')}} :</label>
                                <select name="bank_id" id="bank_id" class="select_2" style="min-width: 100%">
                                    @forelse ($cashBanks as $t=>$bank)
                                        <option value="0">{{__('obs.all')}} {{__('obs.bank')}}</option>
                                        <option value="{{$bank->id}}" @if(request()->bank_id==$bank->id) selected @endif>{{strtoupper(str_replace('_',' ',$bank->name_eng))}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="row justify-content-end">
                        <div class="col-md-3 pl-0">
                            {{-- <label class="" style="min-width: 100%">Date Range</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 !important;">{{__('obs.date_to')}}</label>
                                    <input type="date" class="form-control bsdatepicker" id="end_date" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):date('Y-m-d')}}"> 
                                </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">
                    <select name="check_status" id="check_status_all" onchange="toggleDateAll()">
                        @forelse ($types as $t=>$type)
                            @if($t>2)
                                <option value="{{$t}}">{{strtoupper(str_replace('_',' ',$type))}}</option>
                            @endif
                        @empty
                            
                        @endforelse
                    </select>
                    <div class="input-group-append">
                        <input type="text" name="check_note_all" id="check_note_all" placeholder="Note">
                        <input type="date" name="bounced_date_all" id="bounced_date_all" style="display: none">
                        <button type="button" class="btn btn-sm btn-info" onclick="setChequeStatus()">
                            <span class="fa fa-calendar"></span> {{__('obs.set')}} {{__('obs.cheque')}} {{__('obs.status')}}
                        </button>
                    </div>
                    {{-- <div class="input-group-append">
                        <button type="button" class="btn btn-sm btn-info" onclick="openChequeModel()">
                            <span class="fa fa-calendar"></span> Bill To Plan
                        </button>
                    </div> --}}

                </div>
                <div class="pro_trans_table" id="divTableDataHolder">
                    <table class="table table-bordered">
                        <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 class="text-nowrap text-center" style="padding: 0">{{__('obs.cheque')}} {{__('obs.date')}}</th>
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.cheque')}} {{__('obs.no')}}</th>
                            @if(Request()->voucher_no)
                                <th class="text-nowrap text-center" style="padding: 0">{{__('obs.voucher')}} {{__('obs.no')}}</th>
                            @endif
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.bank')}} {{__('obs.name')}}</th>
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.party')}}</th>
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.status')}}</th>
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.total')}} {{__('obs.amount')}}</th>
                            <th class="text-nowrap text-center" style="padding: 0">{{__('obs.action')}}</th>
                        </tr>
                        </thead>
                        <tbody class="item_tbody">
                        @php
                            $m=1;
                        @endphp
                            @forelse ($vouchers as $key=>$voucher)
                            <tr>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">
                                    <div class="form-check">
                                        <input class="form-check-input voucher_to_set_preparation" name="voucher_to_set_preparation" @if($voucher->check_status>2) 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 style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">{{ date('Y-M-d', strtotime($voucher->check_date))}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ $voucher->check_number }}</td>
                                @if(Request()->voucher_no)
                                    <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ $voucher->voucher_name }}</td>
                                @endif
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ $voucher->bank->name_eng }}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ $voucher->ledger?$voucher->ledger->name:'' }}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ strtoupper(str_replace('_',' ',$types[$voucher->check_status]))}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{$voucher->amount}}</td>
                                
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">
                                    <a target="_blank" href="{{ route('voucher.cheque_print',['id'=>$voucher->id]) }}" class="btn btn-sm btn-info">
                                        <span class="fa fa-print"></span>
                                    </a>
                                    @if($voucher->check_status>1)
                                        <button type="button" class="btn-dark btn-sm" id="submit_allocation" onclick="openChequeModel({{$voucher}})">{{__('obs.change')}} {{__('obs.status')}}</button>
                                    @endif
                                    @if($voucher->check_status==1)
                                        @if(checkAuthPermission($routes[2]) && checkAuthPermission('voucher.journal_voucher_update'))
                                        <a target="_blank" href="{{ route($routes[2],['voucher_id'=>explode(',',$voucher->voucher_ids)[0]]) }}" class="btn btn-sm btn-info">
                                            <span class="fa fa-wrench"></span>
                                        </a>
                                        @endif
                                        @if(checkAuthPermission('voucher.cheque_allotment_edit'))
                                        <button type="button" class="btn-warning btn-sm" onclick="openChequeEditModel({{$voucher}})"><i class="fa fa-wrench"></i></button>
                                        @endif
                                    @endif
                                    
                                </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_status_modal')
@include('admin.modals.cheque_edit_modal')
@endsection
@section('script')
<script>
var vouchers=[];
var j=100;
$('.select_2').select2();
chechTypes=@json($types);
function setChequeStatus(){
    var status=$('#check_status_all').val();
    
    var voucher_ids = [];
    $.each($("input[name='voucher_to_set_preparation']:checked"), function(){
        voucher_ids.push($(this).val());
    });
    if(voucher_ids.length>0){
        var note=$('#check_note_all').val();
        //alert($('#bounced_date_all').val());
        var bounced_date=($('#bounced_date_all').length && $('#bounced_date_all').val())?getFormatedDate($('#bounced_date_all').val()):null;
        console.log(bounced_date);
        $.ajaxSetup({
            headers: {
                "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
                },
            });
        $.ajax({
            type: "POST",
            url: "{{route('voucher.cheque_status')}}",
            data: {
                voucher_ids:voucher_ids,
                check_status:status,
                note:note,
                check_date:bounced_date,
                type:5
            },
            success: function (data) {
                //voucher_ids=data;
                // location.reload();
            },
            error: function (response) {
            //
            },
        });
    }else{
        alert('Please Select Voucher');
    }
}
function setAllChecked(elementBox){
    $('.voucher_to_set_preparation').not("[disabled]").each(function() {
        this.checked = elementBox.checked;
    });    
}
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');
function getAvailaibleChequeNo(row_id,chkNo=false){
    var bankId= $('#row-'+row_id+' option:selected').attr('data-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
        },
        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);
            if(chkNo){
                chequeOptions+=`<option value="`+chkNo+`" selected>`+chkNo+`</option>`;
            }
            $('#cheque_no-'+row_id).html(chequeOptions);

            chequeNumberHtml=chequeOptions;
        },
        error: function (response) {
        //
        },
    });
}
function setApprovedVoucher(voucher_ids){
    if(confirm('are you sure?')){
        $.ajax({
                type: "GET",
                url: "{{route('voucher.set_preparation_date')}}",
                data: {
                    voucher_ids:voucher_ids,
                    status:2,
                    type:2
                },
                success: function (data) {
                location.reload();
                },
                error: function (response) {
                },
            });
        }
}
function toggleDate(){
    var status=$("#check_status").val();
    if(status==4){
        $("#bounced_date").show();
    }else{
        $("#bounced_date").hide();
    }
    if(status==5){
        $('#check_note').attr('required',true);
    }else{
        $('#check_note').attr('required',false);
    }
}
function toggleDateAll(){
    var status=$("#check_status_all").val();
    if(status==4){
        $("#bounced_date_all").show();
    }else{
        $("#bounced_date_all").hide();
    }
    if(status==5){
        $('#check_note_all').attr('required',true);
    }else{
        $('#check_note_all').attr('required',false);
    }
}
function openChequeModel(voucher){
    console.log(voucher);
    $("#order_details_modal").modal("hide");
    var str ='';
       
    
    rawData=voucher.cheque_details;
    
    if(rawData.length>0){
        for (let index = 0; index < rawData.length; index++) {
            str += `<tr id="tr`+index+`">
            <td>`+(index+1)+`</td>
            <td>`+chechTypes[rawData[index].type]+`</td>
            <td>`+getFormatedDate(rawData[index].cheque_date)+`</td></tr>`;
        }
        str += `<input type="hidden" name="cheque_id" value="`+voucher.id+`"/>`;
    }
    
    $('#tbl_body').html(str);
    $("#order_details_modal").modal("show");
}
function openChequeEditModel(voucher){
    console.log(voucher);
    $("#cheque_edit_modal").modal("hide");
    var str ='';
    var total_due=voucher.amount;
    $('#edit_voucher_id').val(voucher.id);
    $('#amount').val(voucher.amount);
    $('#edit_voucher_no').text(voucher.voucher_no);
    $('#edit_ledger_id').text(voucher.ledger?voucher.ledger.name:'');
    $('#cheque_to').val(voucher.check_to??'');
    $('#check_date').val(getFormatedDate(voucher.check_date));
    $('#row-cb0').val(voucher.bank?voucher.bank.account_id:'');//.trigger('change');
        getAvailaibleChequeNo('cb0',voucher.check_number)
    // $('#cheque_no-cb0').val(voucher.check_number);//.trigger('change');
    // $('#cheque_no-cb0').appendTo(`<option value="`+voucher.check_number+`">`+voucher.check_number+`</option>`);//.trigger('change');
   
    
    // $('#cheque_tbl_body').html(str);
    $("#cheque_edit_modal").modal("show");
    // str += `<tr id="tr`+0+`">
    // <td>`+1+`<input type="hidden" name="voucher_id" value="`+voucher.id+`"></td>
    // <td>`+voucher.voucher_no+`</td>
    // <td>`+(voucher.ledger?voucher.ledger.name:'')+`</td>
    // <td><input type="text" name="cheque_to" class="form-control-sm" value="`+(voucher.check_to??'')+`"></td>
    // <td><input type="date" name="check_date" class="form-control-sm" value="`+(getFormatedDate(voucher.check_date))+`"></td>
    // <td><div class="input-group">
    //         <select required id="row-cb0"  onchange="getAvailaibleChequeNo('cb0')" name="bank_ledger_id" class="form-control item-0 select_2" data-row_id="0" style="width: 90%">
    //             @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
    //         </select>
    //     </div>)+`</td>
    // <td>`+(voucher.check_number)+`</td>
    // <td><input type="number" step=".01" value="`+parseFloat(voucher.amount).toFixed(2)+`" name="amount" onkeyup="getSum()" class="form-control amount"/></td>
    // <td><select class="select_2" name="old_cheque_status"><option value="7">USED</option><option value="0">Available</option></select></td>`;
    // str += `</tr>`;
    // getSum();
    // getCrSum();
    // $('#first_cash_amount').val(total_due);
    // $('#cheque_date-cb'+0).val(getFormatedDate(voucher.check_date));
    // $('.select_2').select2();
}
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-199)+`
                               
                            </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%">
                                        @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
                                    </select>
                                </div>
                            </td>`;
                            returnData+=`<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="date" name="cheque_date[`+j+`]" id="cheque_date-cb`+j+`" required class="form-control cheque_date" style="width: 100%"/>
                                    
                                </div>
                            </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 select_2" style="width: 100%" onchange="setCids()" required> </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-sm 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-sm btn-danger">
                                                    <span class="fa fa-minus"></span><span class="btn_text-cb`+j+`"></span>
                                                </button>
                                            </div>
                                </div>
                            </td>
                        </tr>`;
                        $('#cheque_voucher_cr_body').append(returnData);
                       // search_group_with_code('cb'+j);
                        $('.select_2').select2();
                        //getGroupWiseLedgerInit('cb'+j);
                        setCids();
                        getAvailaibleChequeNo('cb'+j);
                        //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();
}
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);
}

</script>
@stop