@extends('admin.layout.master')
@section('title','BANK STATEMENT')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number],input[type=date] {
    height: 35px !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;
}
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'BANK STATEMENT'])

    {{-- <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="card-title text-center">BANK STATEMENT</h4>
    </div> --}}
                
    <div class="card-body">
        @php
            $types=[0=>'Available',1=>'Registered',2=>'Approved',3=>'Passed',4=>'Bounced',5=>'Cancle',6=>'Return'];
        @endphp
        <form action="{{route('voucher.bank_statement')}}" method="get">
            <div class="card-body"  style="margin-bottom: -14px">
                    <div class="row justify-content-end">
                        {{-- <div class="col-md-2">
                            <div class="form-check">
                                <input class="form-check-input" name="preparation_date" type="checkbox" value="1" id="flexCheckChecked" @if(request()->preparation_date) checked @endif>
                                <label class="form-check-label" for="flexCheckChecked">
                                  Prepared Cheque
                                </label>
                              </div>
                        </div> --}}
                        {{-- <div class="col-md-4">
                            <div class="input-group">
                                <label class="input-group-text" style="height: 35px;">Status</label>
                                <select name="check_status" id="voucher_type">
                                    @forelse ($types as $t=>$type)
                                        <option value="{{$t}}">{{strtoupper(str_replace('_',' ',$type))}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div> --}}
                        <div class="col-md-4">
                            <div class="input-group">
                                <label class="input-group-text" style="height: 35px;">Bank</label>
                                <select name="bank_id" id="bank_id" class="select_2">
                                    @forelse ($cashBanks as $t=>$bank)
                                        <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 class="col-md-4 pl-0">
                            <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: 35px;">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" onclick="install_form()" 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">
                    <input type="date" id="preparation_date">
                    <div class="input-group-append">
                        <button type="button" class="btn btn-sm btn-info" onclick="setPreparationDate()">
                            <span class="fa fa-calendar"></span> Set Date
                        </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"></th>
                            <th class="text-nowrap text-center" style="padding: 0">Date</th>
                            <th class="text-nowrap text-center" style="padding: 0">Bank Name</th>
                            <th class="text-nowrap text-center" style="padding: 0">Pendind</th>
                            <th class="text-nowrap text-center" style="padding: 0">Passed</th>
                            <th class="text-nowrap text-center" style="padding: 0">Total Amount</th>
                            {{-- <th class="text-nowrap text-center" style="padding: 0">Action</th> --}}
                        </tr>
                        </thead>
                        <tbody class="item_tbody">
                        @php
                            $m=1;
                            $pen=0;
                            $pla=0;
                        @endphp
                            @forelse ($vouchers->groupBy('check_date') as $key=>$voucher)
                            <tr>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">
                                    {{$m++}}
                                </td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">{{ date('Y-M-d', strtotime($voucher->first()->check_date))}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-left">{{ $voucher->first()->bank->name_eng }}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{$p=$voucher->where('check_status','<',3)->sum('amount')}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{$n=$voucher->where('check_status',3)->sum('amount')}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{($p+$n)}}</td>
                                {{-- <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-center">
                                    <a target="_blank" href="{{ route('voucher.cheque_voucher_details',['voucher_ids'=>$key]) }}" class="btn btn-sm btn-info">
                                        <span class="fa fa-eye"></span>
                                    </a>
                                    @if($voucher->first()->check_status==1)
                                        <button type="button" class="btn btn-sm btn-danger icon-size" onclick="setApprovedVoucher('{{$key}}')">Approve</button>
                                    @endif
                                    
                                </td> --}}
                            </tr>   
                            @empty
                                
                            @endforelse
                            
                                    
                                    
                        </tbody>
                        <tfoot>
                            <tr>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right" colspan="3">Total Amount</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{$pen=$vouchers->where('check_status','<',3)->sum('amount')}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{$pla=$vouchers->where('check_status',3)->sum('amount')}}</td>
                                <td style="border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;" class="text-right">{{($pen+$pla)}}</td>
                            </tr>
                        </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;
    $('.select_2').select2();
    function setPreparationDate(){
        var preparationDate=getFormatedDate($('#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){
            console.log(voucher_ids);
            $.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;
                },
                error: function (response) {
                //
                },
            });
        }else{
            alert('Please Select Voucher');
        }
        // $('.voucher_to_set_preparation').each(function(){
        //         if($(this).checked){
        //         array_push($(this).value('selected', true);
        //     }
        // });

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

function getAvailaibleChequeNo(row_id){
    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);
            $('#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 showChequeList(btn,voucher){
    vouchers.push(voucher);
    btn.remove();
    console.log(vouchers);
}
function openChequeModel(){
    console.log(vouchers);
    $("#order_details_modal").modal("hide");
    var str ='';
    var total_due=0;
       
    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>
                <td>`+rawData[index].transaction_amount+`</td>`;
                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");
    getSum();
}
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);
}

</script>
@stop