@extends('admin.layout.master')
@section('title','RECEIPT PAYMENT STATEMENT')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number] {
    height: 35px !important;
}
.bold,.border{
    font-weight: bold;
}
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'RECEIPT PAYMENT REPORTS'])
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.receipt_payment_statement')}}" method="get">
           @include('accounts.reports.search_form',['ledger'=>0])
        </form>
    </div>
   
    <div class="card-body" style="padding-top:2px">
        <div class="card-box">
            {{-- <h3 class="card-title text-center">
                {{ (Request()->cost_center_id && Request()->cost_center_id!=0)?$cost_centers->where('id',Request()->cost_center_id)->first()->name : 'All Cost Center' }}</h3>
            <h4 class="card-title text-center">RECEIPT & PAYMENT ACCOUNT</h4>
            <h5 class="card-title text-center">
                {{ 'From '.date('d-M-Y',strtotime(Request()->start_date)).' To '.date('d-M-Y',strtotime(Request()->end_date))}}
            </h5> --}}
            <div class="card-body"  style="border: black solid 1px;" id="divTableDataHolder">

                <div class="col-md-12">
                    <table class="" style="width: 100%">
                        <thead>
                            <tr>
                                <th colspan="3" class="">
                                    @php
                                        $r_type=1;
                                        $printData['start_date']=Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y');
                                        $printData['end_date']=Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y');
                                        // $printData['ledger_name']=count($ledgers->where('id',Request()->ledger_id))>0?$ledgers->where('id',Request()->ledger_id)->first()->name:'ledger not found';
                                        $routeName=Route::currentRouteName();   
                                        $printData=getPrintData($routeName,$printData);
                                    @endphp
                                     <style type="text/css">{!!$printData['style_css']!!}</style>
                                    {!!$printData['head']!!}
                                    {{-- <h3 class="card-title text-center">
                                        {{ (Request()->cost_center_id && Request()->cost_center_id!=0)?$cost_centers->where('id',Request()->cost_center_id)->first()->name : 'All Cost Center' }}</h3>
                                    <h4 class="card-title text-center">RECEIPT & PAYMENT ACCOUNT</h4>
                                    <h5 class="card-title text-center">
                                        {{ 'From '.date('d-M-Y',strtotime(Request()->start_date)).' To '.date('d-M-Y',strtotime(Request()->end_date))}}
                                    </h5> --}}
                                </th>
                            </tr>
                        </thead>
                            <thead>
                                <th></th>
                                <th width="20%" class="bold text-center" colspan="2"> Amount</th>
                            </thead>
                        <tbody>
                            {{-- <tr>
                                <td class="bold"><b><u>RECEIPT</u></b></td>
                                <td></td>
                                <td></td>
                                
                            </tr> --}}
                            <tr>
                                <td class="bold"> OPENING BALANCE:</td>
                                <td></td>
                                <td class="border text-center" style="border:2px solid black !important;"> @ {{Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):''}}</td>
                            </tr>
                            <tr>
                                <td class="bold"> <u>CASH & CASH EQUIVALENTS</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>
                            <tr>
                                <td class="">&nbsp;&nbsp;<u>CASH IN HAND:</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>
                            @forelse ($cashBanks->where('type',1) as $cash)
                            <tr>
                                <td>
                                    &nbsp;&nbsp;{{ $cash->name_eng }}
                                </td>
                                <td></td>
                                <td class="border text-right" style="border-left:2px solid black !important;border-right:2px solid black !important">
                                    @if(array_key_exists($cash->account_id,$ledgerWiseBeginningBalanced))
                                        @if($r_type)
                                            {{($ledgerWiseBeginningBalanced[$cash->account_id]['amount']<0)?number_format(abs($ledgerWiseBeginningBalanced[$cash->account_id]['amount']),2).' (cr)':number_format($ledgerWiseBeginningBalanced[$cash->account_id]['amount'],2)}}
                                        @else
                                            {{($ledgerWiseBeginningBalanced[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseBeginningBalanced[$cash->account_id]['amount']),2).')':number_format($ledgerWiseBeginningBalanced[$cash->account_id]['amount'],2)}}
                                        @endif
                                    @else
                                    {{number_format(0,2)}}
                                    @endif
                                </td>
                            </tr>
                            @empty
                                
                            @endforelse

                            <tr>
                                <td class="">&nbsp;&nbsp;<u>CASH AT BANK:</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>
                            <span class="cash-in-bank">

                                @forelse ($cashBanks->where('type',2) as $cash)
                                <tr>
                                    <td>&nbsp;&nbsp; {{$cash->name_eng}}</td>
                                    <td></td>
                                    <td class="border text-right" style="border-left:2px solid black !important;border-right:2px solid black !important">
                                    
                                    @if(array_key_exists($cash->account_id,$ledgerWiseBeginningBalanced))
                                        @if($r_type)
                                            {{($ledgerWiseBeginningBalanced[$cash->account_id]['amount']<0)?number_format(abs($ledgerWiseBeginningBalanced[$cash->account_id]['amount']),2).' (cr)':number_format($ledgerWiseBeginningBalanced[$cash->account_id]['amount'],2)}}
                                        @else
                                            {{($ledgerWiseBeginningBalanced[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseBeginningBalanced[$cash->account_id]['amount']),2).')':number_format($ledgerWiseBeginningBalanced[$cash->account_id]['amount'],2)}}
                                        @endif
                                        {{-- {{($ledgerWiseBeginningBalanced[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseBeginningBalanced[$cash->account_id]['amount']),2).')':number_format($ledgerWiseBeginningBalanced[$cash->account_id]['amount'],2)}} --}}
                                    @else
                                        {{number_format(0,2)}}
                                    @endif
                                    </td>
                            </tr>

                            @empty
                            @endforelse
                            </span>
                            <tr>
                                {{-- <td class="">&nbsp;&nbsp;&nbsp;<u>Receipts:</u></td> --}}
                                <td class="bold"><b><u>RECEIPT</u></b></td>
                                <td></td>
                                <td style="border-top:2px solid black !important;"></td>
                            </tr>
                            @php
                                $accountsIds=$cashBanks->pluck('account_id')->toArray(); 
                                $total_receipt=0;  
                                $total_payment=0;  
                            @endphp
                            @forelse ($ledgerWiseBalance as $m=>$receipt)
                                @if($receipt['amount']<0)
                                    <tr>
                                        <td>&nbsp; &nbsp;&nbsp;{{count($ledgers->where('id',$m))?$ledgers->where('id',$m)->first()->name:'N/A'}}</td>
                                        <td class="text-right">
                                            {{number_format(abs($receipt['amount']),2)}}
                                        </td>
                                        @php
                                            $total_receipt+=abs($receipt['amount']);    
                                        @endphp
                                    </tr>

                                @endif
                            @empty
                                
                            @endforelse
                            <tr>
                                <td class="bold underline text-right">
                                    <span style="border: black solid 2px">
                                        TOTAL RECEIPTS:

                                    </span>
                                </td>
                                <td style="border-top:2px solid black !important"></td>
                                <td class="text-right border">{{number_format($total_receipt,2)}}</td>
                            </tr>
                            <tr>
                                <td class="bold"><u><b>PAYMENT:</b></u></td>
                                <td></td>
                                <td></td>
                            </tr>

                            @forelse ($ledgerWiseBalance as $m=>$receipt)
                            @if($receipt['amount']>0)
                                <tr>
                                    <td>&nbsp; &nbsp;&nbsp;{{count($ledgers->where('id',$m))?$ledgers->where('id',$m)->first()->name:'N/A'}}</td>
                                    <td class="text-right">
                                        {{number_format($receipt['amount'],2)}}
                                    </td>
                                    <td></td>
                                            @php
                                            $total_payment+=$receipt['amount'];    
                                        @endphp
                                </tr>

                            @endif
                        @empty
                        @endforelse
                        <tr>
                            <td class="bold underline text-right">
                                <span style="border: black solid 2px">
                                    TOTAL PAYMENTS:
                                </span>
                            </td>
                            <td style="border-top:2px solid black !important"></td>
                            <td class="text-right border">( {{number_format($total_payment,2)}} )</td>
                        </tr>
                        </tbody>
                        <tbody>
                            <tr>
                                <td class="bold"> CLOSING BALANCE:</td>
                                <td></td>
                                <td class="border text-center" style="border:2px solid black !important;"> @ {{Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):''}}</td>
                            </tr>

                            <tr>
                                <td class="bold"> <u>CASH & CASH EQUIVALENTS</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>

                            <tr>
                                <td class="">&nbsp;&nbsp;<u>CASH IN HAND:</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>


                            @forelse ($cashBanks->where('type',1) as $cash)
                            <tr>
                                <td>
                                    &nbsp;&nbsp;{{$cash->name_eng}}
                                </td>
                                <td></td>
                                <td class="border text-right" style="border-left:2px solid black !important;border-right:2px solid black !important">
                                        @if(array_key_exists($cash->account_id,$ledgerWiseEndingBalance))
                                            @if($r_type)
                                                {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).' (cr)':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}}
                                            @else
                                                {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).')':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}}
                                            @endif
                                            {{-- {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).')':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}} --}}
                                        @else
                                        {{number_format(0,2)}}
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                
                            @endforelse
                            <tr>
                                <td class="">&nbsp;&nbsp;<u>CASH AT BANK:</u></td>
                                <td></td>
                                <td style="border-left:2px solid black !important;border-right:2px solid black !important"></td>
                            </tr>

                                @forelse ($cashBanks->where('type',2) as $cash)
                                <tr>
                                    <td>
                                        &nbsp;&nbsp;{{$cash->name_eng}}
                                    </td>
                                    <td></td>
                                    <td class="border text-right" style="border-left:2px solid black !important;border-right:2px solid black !important">
                                        @if(array_key_exists($cash->account_id,$ledgerWiseEndingBalance))
                                            
                                            @if($r_type)
                                                {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).' (cr)':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}}
                                            @else
                                                {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).')':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}}
                                            @endif
                                            {{-- {{($ledgerWiseEndingBalance[$cash->account_id]['amount']<0)?'('.number_format(abs($ledgerWiseEndingBalance[$cash->account_id]['amount']),2).')':number_format($ledgerWiseEndingBalance[$cash->account_id]['amount'],2)}} --}}
                                        @else
                                        {{number_format(0,2)}}
                                        @endif
                                        </td>
                                    </tr>
                                    @empty
                                    @endforelse
                                    <tr>
                                        <th></th>
                                        <th></th>
                                        <td style="border-top:2px solid black !important;"></td>
    
                                    </tr>
                        </tbody>
                    </table>
                    {{-- <table class="">
                        <tbody>
                            <thead>
                                <tr>
                                    <th></th>
                                    <th></th>
                                    <td style="border-top:2px solid black !important;"></td>

                                </tr>

                        </thead>
                        
                    </table> --}}

                </div>





                <div class="report-signature"
                    style="margin-top: 35px;padding-bottom: 30px;clear: both;padding: 0 50px 40px">
                    <div class=""
                        style="float:left; padding: 0 45px;display: inline-block;border-top: 1px solid #ddd;">
                        Finance Secretary </div>
                    <div class=""
                        style="float:right; padding: 0 45px;display: inline-block;border-top: 1px solid #ddd;">
                        General Secretary</div>
                </div>
                <div class="report-signature"
                    style="margin-top: 35px;padding-bottom: 30px;clear: both;padding: 0 50px 40px">
                    <div class="" style="float:left; padding: 0 45px;display: inline-block;">Date:</div>
                    <div class="" style="float:right; padding: 0 45px;display: inline-block;">Chartered
                        Accountants</div>
                </div>
            </div>
        </div>
    </div>
</div>
           

@endsection
@section('script')
<script>
    
    $('#cost_center_id').select2();
    $('#ledger_id').select2();
//    function excelPrint(){


// $(".lists").hide();
// $(".tr_class_b_remove").attr("class","border_remove");

//  window.open('data:application/vnd.ms-excel,' + encodeURIComponent(
            
//             $('div[id$=print]').html()
            
//             ));

// setTimeout(function() {
    
//     $(".border_remove").attr("class","tr_class_b_remove");
// $(".lists").show();

// }, 1000);

// }
</script>
@stop