@extends('admin.layout.master')
@section('title','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.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">
                    <label for="pay_type">C CENTER</label>
                    {{-- <div class="col-5 px-0">
                    </div>
                    <div class="col-7 px-0"> --}}
                        <select name="cost_center_id" id="cost_center_id" style="min-width: 100%;">
                            <option value="0">{{ 'ALL' }}</option>
                            @forelse ($cost_centers as $cost_center)   
                            <option value="{{$cost_center->id}}">{{ $cost_center->name }}</option>
                            @empty
                            @endforelse
                        </select>
                    {{-- </div> --}}
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id">LEDGER</label>
                        <select name="ledger_id" style="width:100%" id="ledger_id" required>

                            @if(Request()->ledger_id)
                                <option value="{{Request()->ledger_id}}">{{ $ledger->name.' - '.$ledger->auto_code}}</option>
                            @endif
                            
                        </select>
                    </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;background-color: aliceblue" id="divTableDataHolder">
        <input type="hidden" id="marketing_admin" value="{{marketing_customer()?1:0}}">
        @if(Request()->ledger_id)
        <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']=$ledger?$ledger->name:'';
                        $routeName=Route::currentRouteName();   
                        $printData=getPrintData($routeName,$printData);
                        function ledgerReffName($jrV){
                            $str='';
                            if($jrV->voucher->reffParentVoucher){
                                $str.=' <strong>{ '.getNameLedgerName($jrV->voucher->reffParentVoucher,$jrV->type,$jrV->reff_jr_id).'}</strong>';
                            }else{
                                $str.=((($jrV->refLedger && ($jrV->ledger_id!=$jrV->reff_no))? ' <strong>[ '.$jrV->refLedger->name.' ]</strong>':''));
                            }
                            return $str;
                        }
                    @endphp
                     <style type="text/css">{!!$printData['style_css']!!}</style>
                        {!!$printData['head']!!}
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-12 table-responsive-sm" style="padding-bottom: 15px;">
                                <div class="pro_trans_table">
                                    <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>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th class="text-nowrap text-center" style="width: 10%;padding: 0">DATE</th>
                                                <th class="text-nowrap text-center" style="width: 10%;padding: 0">VOUCHER NO</th>
                                                <th class="text-nowrap text-center" style="width: 25%;padding: 0">PARTICULERS</th>
                                                <th class="text-nowrap text-center" style="width: 10%;padding: 0">Reff</th>
                                                <th class="text-nowrap text-center" style="width: 10%;padding: 0">NOTE</th>
                                                <th class="text-nowrap text-center" style="width: 15%;padding: 0">DR</th>
                                                <th class="text-nowrap text-center" style="width: 15%;padding: 0">CR</th>
                                                <th class="text-nowrap text-center" style="width: 15%;padding: 0">BALANCE</th>
                                            </tr>
                                        </thead>
                                                @php
                                                    $c_amount=0;
                                                    $d_amount=0;
                                                    $amount=0;
                                                    $show_multiple=0;
                                                    $placed_id=[];
                                                    $code=$ledger?$ledger->auto_code:null;
                                                @endphp
                                        <tbody class="item_tbody">
                                            @if($code==null || $code[0]<3)
                                                <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-left" style="padding: 0 2px;">{{'--'}}</td>
                                                    <td class="text-left" style="padding: 0 2px;">
                                                        {{'Beginning Balance'}}
                                                    </td>
                                                    <td class="text-nowrap text-left" style="padding: 0 2px;"></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
                                                        @endif
                                                    </td>
                                                    <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                        @if($b_balance<0)
                                                        @php
                                                            $minusTrimedBalance=abs($b_balance);
                                                            //$c_amount+=$minusTrimedBalance;
                                                            $amount-=$minusTrimedBalance;
                                                            @endphp
                                                        {{-- {{ abs($b_balance) }} --}}
                                                        {{number_format($minusTrimedBalance,2)}}
                                                        @endif
                                                    </td>
                                                    @if($r_type==1)
                                                        <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2).'(dr)':(number_format(abs($amount),2)).' (cr)'}}</td>
                                                    @else
                                                        <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</td>
                                                    @endif
                                                </tr>
                                            @endif
                                            @forelse ($vouchers as $jr)
                                            @if($jr->amount>0)
                                            <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')||checkAuthPermission('voucher.journal_vouchers'))
                                                        @if($jr->voucher->reff_transaction_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-dark hidden_edit_btn">
                                                                <i class="fa fa-wrench"></i>
                                                            </a>
                                                        {{-- @elseif(($jr->voucher->reffParentVoucher==null))
                                                            <a target="_blank" href="{{ route('voucher.journal_vouchers',['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
                                                    @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;">
                                                    {{-- @if($jr->type==0) --}}
                                                    @php
                                                        $creditLedger=$jr->opposite_posting->where('type',$jr->type==0?1:0);//->where('id','>',$jr->id);
                                                        $drCounter=count($jr->opposite_posting->where('type',$jr->type));
                                                        $groupType=$creditLedger->where('group_type',$jr->group_type)->whereNotIn('id',$placed_id);
                                                        $str='';
                                                        $noteStr='';
                                                        if(count($groupType)>0){
                                                            if($show_multiple || $drCounter==1){
                                                                foreach($groupType as $opp){
                                                                    //$str.=$opp->ledger?$opp->ledger->name:'Ledger Missing';

                                                                    $jrV=$opp;
                                                                    $str.=$jrV->globalLedger?$jrV->globalLedger->name:'Ledger Missing';
                                                                    $str.=ledgerReffName($jrV);
                                                                   
                                                                    if(count($groupType)>1){
                                                                        $str.=' - '.(number_format($opp->amount,2)).'<br>';
                                                                        $noteStr.=$opp->note.'<br>';
                                                                    }
                                                                }
                                                            }else{
                                                                $jrV=$groupType->first();
                                                                $str.=$jrV->globalLedger?$jrV->globalLedger->name:'Ledger Missing';
                                                                $str.=ledgerReffName($jrV);
                                                               
                                                                array_push($placed_id,$jrV->id);
                                                                $noteStr.=$jrV->note;
                                                            }
                                                        }elseif(count($creditLedger)>0){
                                                            if($show_multiple || $drCounter==1){
                                                                foreach($creditLedger as $ocl){
                                                                    //$str.=$ocl->ledger?$ocl->ledger->name:'Ledger Missing';

                                                                    $jrV=$ocl;
                                                                    $str.=$jrV->globalLedger?$jrV->globalLedger->name:'Ledger Missing';
                                                                    $str.=ledgerReffName($jrV);
                                                                   
                                                                    
                                                                    if(count($creditLedger)>1){
                                                                        $str.=' - '.(number_format($ocl->amount,2)).'<br>';
                                                                        $noteStr.=$ocl->note.'<br>';
                                                                    }
                                                                }
                                                            }else{
                                                               
                                                                $jrV=$creditLedger->first();
                                                                $str.=$jrV->globalLedger?$jrV->globalLedger->name:'Ledger Missing';
                                                                $str.=ledgerReffName($jrV);
                                                               
                                                                array_push($placed_id,$jrV->id);
                                                                $noteStr.=$jrV->note;
                                                            }
                                                        }
                                                            
                                                    @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)->whereNotIn('id',$placed_id);
                                                        $str='';
                                                        $noteStr='';
                                                        if(count($drGroupType)>0){
                                                            if($show_multiple || $crCounter==1){
                                                                foreach($drGroupType as $opp){
                                                                    $str.=$opp->ledger?$opp->ledger->name:'Ledger Missing';
                                                                    if(count($drGroupType)>1){
                                                                        $str.=' - '.(number_format($opp->amount,2)).'<br>';
                                                                        $noteStr.=$opp->note.'<br>';
                                                                    }
                                                                }
                                                            }else{
                                                                    // $str.=$drGroupType->first()->ledger?$drGroupType->first()->ledger->name:'Ledger Missing';
                                                                    // array_push($placed_id,$drGroupType->first()->id);
                                                                    // $noteStr.=$drGroupType->first()->note;

                                                                    $jrV=$drGroupType->first();
                                                                    $str.=$jrV->ledger?$jrV->ledger->name:'Ledger Missing';
                                                                    if($jrV->voucher->reffParentVoucher){
                                                                        $str.=' <strong>[ '.getNameLedgerName($jrV->voucher->reffParentVoucher,$jrV->type,$jrV->reff_jr_id).']</strong>';
                                                                    }else{
                                                                        $str.=((($jrV->refLedger && ($jrV->ledger_id!=$jrV->reff_no))? ' <strong>[ '.$jrV->refLedger->name.' ]</strong>':''));
                                                                    }
                                                                    array_push($placed_id,$jrV->id);
                                                                    $noteStr.=$jrV->note;
                                                                }
                                                        }elseif(count($debitLedger)>0){
                                                            if($show_multiple || $crCounter==1){
                                                                foreach($debitLedger as $ocl){
                                                                    $str.=$ocl->ledger?$ocl->ledger->name:'Ledger Missing';
                                                                    if(count($debitLedger)>1){
                                                                        $str.=' - '.$ocl->amount.'<br>';
                                                                        $noteStr.=$ocl->note.'<br>';
                                                                    }
                                                                }
                                                            }else{
                                                                // $str.=$debitLedger->first()->ledger?$debitLedger->first()->ledger->name:'Ledger Missing';
                                                                // array_push($placed_id,$debitLedger->first()->id);
                                                                // $noteStr.=$debitLedger->first()->note;
                                                                
                                                                $jrV=$debitLedger->first();
                                                                $str.=$jrV->ledger?$jrV->ledger->name:'Ledger Missing';
                                                                if($jrV->voucher->reffParentVoucher){
                                                                    $str.=' <strong>[ '.getNameLedgerName($jrV->voucher->reffParentVoucher,$jrV->type,$jrV->reff_jr_id).']</strong>';
                                                                }else{
                                                                    $str.=((($jrV->refLedger && ($jrV->ledger_id!=$jrV->reff_no))? ' <strong>[ '.$jrV->refLedger->name.' ]</strong>':''));
                                                                }
                                                                array_push($placed_id,$jrV->id);
                                                                $noteStr.=$jrV->note;
                                                            }
                                                            
                                                        }
                                                    @endphp --}}
                                                    {{-- @endif --}}
                                                    {!!$str!!}
                                                </td>
                                                @php
                                                    $reff=$jr->voucher->reffInvoice??$jr->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
                                                <td class="text-nowrap text-left" style="padding: 0 2px;">
                                                    @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="text-left" style="padding: 0 2px;">@if($jr->voucher->bill_date){{$jr->voucher->bill_date?'Bill Date : '.date('d-m-Y',strtotime($jr->voucher->bill_date)).'Bill No : '.$jr->voucher->bill_no:''}}<br>@endif @if($noteStr) {!!$noteStr!!} @else {{$jr->note??$jr->voucher->note}} @endif</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
                                                    @endif
                                                </td>
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                    @if($jr->type==1)
                                                        {{number_format($jr->amount,2)}}
                                                        @php
                                                            $c_amount+=$jr->amount;
                                                            $amount-=$jr->amount;
                                                        @endphp
                                                    @endif
                                                </td>
                                                    @if($r_type==1)
                                                        <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2).'(dr)':(number_format(abs($amount),2)).' (cr)'}}</td>
                                                    @else
                                                        <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</td>
                                                    @endif
                                            </tr>
                                            @endif
                                            @empty
                                                
                                            @endforelse
                                        </tbody>
                                        <tfoot>
                                            <tr>    
                                                <th class="text-nowrap text-right" style="width: 10%;padding: 0 2px;" colspan="2">
                                                    {{'TOTAL'}}
                                                </th>
                                                <th class="text-nowrap text-right" style="width: 10%;padding: 0 2px;" colspan="2">
                                                    {{'OPENING'}}
                                                </th>
                                                @if($r_type==1)
                                                    <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $b_balance==0 ? '': ($b_balance > 0?number_format($b_balance,2).'(dr)':(number_format(abs($b_balance),2)).' (cr)')}}</th>
                                                @else
                                                    <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $b_balance>=0?number_format($b_balance,2):'('.(number_format(abs($b_balance),2)).')'}}</th>
                                                @endif
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">
                                                        {{number_format($d_amount,2)}}
                                                </th>
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">
                                                    {{number_format($c_amount,2)}}
                                                </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
                                                {{-- <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</th> --}}
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>

                            </div>
                            
                        </div>
                    </form>
                    {{-- <button type="button"  class="btn btn-primary btn-sm" onclick="hideBox()">
                        <span class="fa fa-refresh"></span>
                    </button> --}}
                    </div>
                    {!!$printData['foot']!!}
                </div>
            {{-- </form> --}}
            </div>
        </div>
        @endif
    </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