@extends('admin.layout.master')
@section('title','Cash Ledger Report')
@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: #ab3535;
           padding: 5px !important;
           color: white !important;
        }
.card-body{
    padding:.25rem !important;
}
</style> 
@endsection
@section ('content')
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'LEDGER REPORT'])
    
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.cash_ledger_view')}}" method="get">
        {{-- <form action="{{route(Request::route()->getName())}}" method="get"> --}}
            <div class="row mb-0 mt-0 pt-2"  style="border:dashed 1px green">
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    
                    </div>
                    <div class="col-md-6 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id">Date Range</label>
                        <div class="input-group">
                            <input type="date" class="form-control" name="start_date" value="{{Request()->start_date?date('Y-m-d',strtotime(Request()->start_date)):date('Y-m-d')}}">
                            <span class="input-group-text" style="max-height: 30px;">TO</span>
                            <input type="date" class="form-control" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):date('Y-m-d')}}">
                            <div class="input-group-append">
                                <button type="submit" style="max-height: 30px;" class="btn btn-sm btn-danger">
                                <span class="fa fa-search"></span>
                                </button>
                            </div>
                        </div>
                </div>
                
            </div>
        </form>
    </div>
    <div class="card-body"  style="padding-top:2px" id="divTableDataHolder">
        <input type="hidden" id="marketing_admin" value="{{marketing_customer()?1:0}}">
        <div class="row">
            <div class="col-md-12">          
                
                <div class="card-box">
                    @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">
                        
                        @if(count($ledgers->where('id',Request()->ledger_id))>0)
                            {{$ledgers->where('id',Request()->ledger_id)->first()->name}}
                        @else
                            {{'ledger not found'}}
                        @endif
                    </h3>
                    <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">
                        <div class="input-group row justify-content-start" style="position: sticky; top: 80px;z-index:25000">
                            <div class="input-group-append" 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>
                        <div class="row">
                            @php
                                $amount=0;
                                $recieveVoucher=$vouchers->where('type',0);
                                $pmtVoucher=$vouchers->where('type',1);
                                $types=[0,1];
                            @endphp
                            @forelse ($types as $type)
                            <div class="col-md-6 table-responsive-sm" style="padding-bottom: 15px;">
                                <div class="pro_trans_table">
                                    <table class="table table-bordered">
                                        <thead>
                                        <tr>
                                            <th class="text-nowrap text-center" colspan="5" style="background-color: #002952">{{$type==0?'Receive':'Payment'}}</th>
                                        </tr>
                                        <tr>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">DATE</th>
                                            <th class="text-nowrap text-center" style="width: 3%;padding: 0">VCR NO</th>
                                            <th class="text-nowrap text-center" style="width: 50%;padding: 0">PARTICULERS</th>
                                            <th class="text-nowrap text-center" style="width: 25%;padding: 0">NOTE</th>
                                            <th class="text-nowrap text-center" style="padding: 0">Amount</th>
                                        </tr>
                                        </thead>
                                                @php
                                                    $c_amount=0;
                                                    $d_amount=0;
                                                    $show_multiple=0;
                                                    //$code=$ledgers->where('id',Request()->ledger_id)->first()->auto_code;
                                                @endphp
                                        <tbody class="item_tbody">
                                            @if($b_balance>=0 && $type==0)
                                                <tr>    
                                                    <td class="text-nowrap text-center" style="width: 10%;padding: 0 2px;">{{ date('d-m-Y',strtotime(Request()->start_date)) }}</td>
                                                    <td class="text-nowrap text-center" style="padding: 0 2px;">-</td>
                                                    <td class="text-nowrap text-left" style="padding: 0 2px;"><strong>{{'Opening Balance'}}</strong></td>
                                                    <td class="text-nowrap text-left" style="padding: 0 2px;"></td>
                                                    <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                        @if($b_balance>=0)
                                                        {{number_format($b_balance,2)}}
                                                            @php
                                                                $d_amount+=$b_balance;
                                                                $amount+=$b_balance;
                                                            @endphp
                                                        @else
                                                            @php
                                                                $minusTrimedBalance=abs($b_balance);
                                                                $c_amount+=$minusTrimedBalance;
                                                                $amount-=$minusTrimedBalance;
                                                            @endphp
                                                        {{number_format($minusTrimedBalance,2)}}
                                                        @endif
                                                    </td>
                                                    
                                                </tr>
                                            @endif
                                            @forelse ($type==0?$recieveVoucher:$pmtVoucher as $jr)
                                                <tr>    
                                                    <td class="text-nowrap text-center" style="width: 10%;padding: 0 2px;">{{date('d-m-Y',strtotime($jr->date))}}</td>
                                                    <td class="text-nowrap text-left" style="padding: 0 2px;">
                                                        @if(checkAuthPermission('voucher.voucher_edit') && $jr->voucher->reff_voucher_id==null)
                                                            <a target="_blank" href="{{ route('voucher.voucher_edit',['voucher_id'=>$jr->voucher->id]) }}" 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="{{ route('voucher.voucher_details',['voucher_id'=>$jr->voucher_id]) }}" class="text-dark">
                                                            {{$jr->voucher->voucher_no}}
                                                        </a>
                                                    </td>
                                                    <td class="text-left" style="padding: 0 2px; border-bottom:1px solid black;">
                                                        @if($jr->type==0)
                                                            @php
                                                                $creditLedger=$jr->opposite_posting->where('type',1);
                                                                $drCounter=count($jr->opposite_posting->where('type',0));
                                                                $groupType=$creditLedger->where('group_type',$jr->group_type);
                                                                $str='';
                                                                if(count($groupType)>0){
                                                                    // if($show_multiple==1){
                                                                    if($show_multiple && $drCounter==1){
                                                                        foreach($groupType as $opp){
                                                                            $str.=$opp->globalLedger?$opp->globalLedger->name:'Ledger Missing';
                                                                            if(count($groupType)>1){
                                                                                $str.=' - '.$opp->amount.'<br>';
                                                                            }
                                                                        }
                                                                    }else{
                                                                        $str.=$groupType->first()->globalLedger?$groupType->first()->globalLedger->name:'Ledger Missing';
                                                                    }
                                                                }elseif(count($creditLedger)>0){
                                                                    // if($show_multiple==1){
                                                                    if($show_multiple && $drCounter==1){
                                                                        foreach($creditLedger as $ocl){
                                                                            $str.=$ocl->globalLedger?$ocl->globalLedger->name:'Ledger Missing';
                                                                            if(count($creditLedger)>1){
                                                                                $str.=' - '.(number_format($ocl->amount,2)).'<br>';
                                                                            }
                                                                        }
                                                                    }else{
                                                                        $str.=$creditLedger->first()->globalLedger?$creditLedger->first()->globalLedger->name:'Ledger Missing';
                                                                    }
                                                                }
                                                                    
                                                            @endphp
                                                        @else
                                                            @php
                                                                $debitLedger=$jr->opposite_posting->where('type',0);
                                                                $crCounter=count($jr->opposite_posting->where('type',1));
                                                                $drGroupType=$debitLedger->where('group_type',$jr->group_type);
                                                                $str='';
                                                                if(count($drGroupType)>0){
                                                                    // if($show_multiple==1){
                                                                    if($show_multiple && $crCounter==1){
                                                                        foreach($drGroupType as $opp){
                                                                            $str.=$opp->globalLedger?$opp->globalLedger->name:'Ledger Missing';
                                                                            if(count($drGroupType)>1){
                                                                                $str.=' - '.(number_format($opp->amount,2)).'<br>';
                                                                            }
                                                                        }
                                                                    }else{
                                                                        $str.=$drGroupType->first()->globalLedger?$drGroupType->first()->globalLedger->name:'Ledger Missing';
                                                                        }
                                                                }elseif(count($debitLedger)>0){
                                                                    // if($show_multiple==1){
                                                                    if($show_multiple && $crCounter==1){
                                                                        foreach($debitLedger as $ocl){
                                                                            $str.=$ocl->globalLedger?$ocl->globalLedger->name:'Ledger Missing';
                                                                            if(count($debitLedger)>1){
                                                                                $str.=' - '.$ocl->amount.'<br>';
                                                                            }
                                                                        }
                                                                    }else{
                                                                        $str.=$debitLedger->first()->globalLedger?$debitLedger->first()->globalLedger->name:'Ledger Missing';
                                                                        }
                                                                    
                                                                }
                                                            @endphp
                                                        @endif
                                                        {!!$str!!}
                                                    </td>
                                                   
                                                    <td class="text-left" style="padding: 0 2px;">{{$jr->note??$jr->voucher->note}}</td>
                                                    <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                        @if($jr->type==0)
                                                        {{number_format($jr->amount,2)}}
                                                            @php
                                                                $d_amount+=$jr->amount;
                                                                $amount+=$jr->amount;
                                                            @endphp
                                                        @elseif($jr->type==1)
                                                        {{number_format($jr->amount,2)}}
                                                        @php
                                                            $c_amount+=$jr->amount;
                                                            $amount-=$jr->amount;
                                                            @endphp
                                                        @endif
                                                    </td>
                                                       
                                                </tr>
                                            @empty
                                                
                                            @endforelse
                                        </tbody>
                                        <tfoot>
                                            <tr>    
                                                <th class="text-nowrap text-right" style="width: 10%;padding: 0 2px;" colspan="4">{{'TOTAL '}}</th>
                                                {{-- <th class="text-nowrap text-left" style="padding: 0 2px;"></th> --}}
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">
                                                    
                                                    {{number_format(($type==0?$d_amount:$c_amount),2)}}
                                                </th>
                                             </tr>
                                            @if($type==1)
                                                <tr>    
                                                    <th class="text-nowrap text-right" style="width: 10%;padding: 0 2px;" colspan="4">{{'Closing Balance'}}</th>
                                                    {{-- <th class="text-nowrap text-left" style="padding: 0 2px;"></th> --}}
                                                    @if($r_type==1)
                                                        <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount=0 ? '': ($amount > 0?number_format($amount,2).' (dr)':(number_format(abs($amount),2)).' (cr)')}}</th>
                                                    @else
                                                        <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</th>
                                                    @endif
                                                </tr>
                                            @endif
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                            @empty
                            @endforelse
                        </div>
                    </form>
                    {{-- <button type="button"  class="btn btn-primary btn-sm" onclick="hideBox()">
                        <span class="fa fa-refresh"></span>
                    </button> --}}
                    </div>
                    {!!$printData['foot']!!}
                </div>
           
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script>
    $('#ledger_id').select2({ 
                    minimumInputLength: 3,
                    // tags: [],
                    ajax: {
                        url: "{{route('accounts_settings.ledger_search')}}",
                        dataType: 'json',
                        type: "GET",
                        quietMillis: 50,
                        data: function (term) {
                            // row_id= $(term.element).attr('data-row_id');
                            // var group_code=$('#group_row-'+100).val();
                            return {
                                _token: $("input[name='_token']").val(),
                                marketing_admin: $("#marketing_admin").val(),
                                search_type: 2,
                                group_code:null,
                                name: term
                            };
                        },
                        processResults: function (data) {
                            return {
                                results: $.map(data, function (item) {
                                    return {
                                        text: item.auto_code + ' -- ' + item.name,
                                        id: item.id
                                    }
                                })
                            };
                        }
                    }                                                   
                });
    $('#cost_center_id').select2();
    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();
        }
    }
</script>
@stop