@extends('admin.layout.master')
@section('title','JOURNAL Report')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number] {
    height: 35px !important;
}
.table thead th,.table tbody td {
        border: 1px solid black !important;
        text-align: center;
        vertical-align: middle;
        }
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>' JOURNAL REPORT'])
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.reff_journal_view')}}" method="get">
            @include('accounts.reports.search_form',['ledger'=>0,'is_user'=>1])
        </form>
    </div>
    <div class="card-body" style="padding-top:2px" id="divTableDataHolder">
        <div class="row">
            <div class="col-md-12">          
                
                <div class="card-box">
                  
                     @php
                        $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');
                        $routeName=Route::currentRouteName();   
                        $printData=getPrintData($routeName,[]);
                    @endphp
                    {!!$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">
                                    <table class="table table-bordered">
                                        <thead>
                                          <tr>
                                            <th>Voucher NO</th>
                                            <th>Date</th>
                                            <th width="50%">Account Title</th>
                                            {{-- <th>Description</th> --}}
                                            <th>Debit</th>
                                            <th>Credit</th>
                                          </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $amount=0;    
                                        @endphp
                                        @forelse($vouchers as $voucher)
                                        @php
                                                $k=0;
                                                $rowspan=count($voucher->journals);
                                                $time=strtotime($voucher->date);
                                                $date=date("d-M-Y",$time);
                                                // nnnnnnnnnnnn
                                                $reffVoucher=$voucher->reffChildVoucher;
                                                $reffJournals=$reffVoucher->pluck('journalsGlobal')->flatten(1);
                                                // nnnnnnnnnnnnnnnnn
                                                // dd($reffJournals);
                                                @endphp
                                            @forelse($voucher->journals as $jr)
                                                @php
                                                    $against_id=$jr->oppsiteJr->where('type',$jr->type==0?1:0)->first()->ledger_id;
                                                    //dd($jr->reff_no,$jr->ledger_id,$against_id);
                                                    if($jr->reff_no==$jr->ledger_id){
                                                        $reJrRow=$reffJournals->where('ledger_id',$against_id);
                                                    }else{
                                                        $reJrRow=$reffJournals->where('ledger_id',$jr->reff_no);
                                                    }
                                                    $p=(count($reJrRow)>1)?$reJrRow->where('amount',$jr->amount)->first():$reJrRow->first();
                                                    $reffVoucherId=$p?$p->voucher_id:null;
                                                    $reffed_id=$p?$p->id:null;
                                                    $notProperlyReffered=$reffVoucherId?$reffVoucher->where('id',$reffVoucherId)->first():null;
                                                    $tableColor=0;
                                                    if($jr->refVoucher){
                                                        $tableColor=1;
                                                    }
                                                    $searchrd_voucher=$jr->refVoucher??$notProperlyReffered;//?$jr->refVoucher
                                                    $rrowspan=0;
                                                    if($searchrd_voucher){
                                                        $kf=0;
                                                        $rrowspan=count($searchrd_voucher->journalsGlobal);
                                                        $rtime=strtotime($searchrd_voucher->date);
                                                        $rdate=date("d-M-Y",$rtime);
                                                    }
                                                @endphp
                                                <tr @if($k==0)style="border-top:solid 2px black" @endif>
                                                    @if($k==0)
                                                        <td rowspan="{{$rowspan}}">
                                                            @if(checkAuthPermission('voucher.voucher_edit'))
                                                            <a target="_blank" href="{{ route('voucher.voucher_edit',['voucher_id'=>$voucher->id]) }}" style="padding:0 !important;" class="btn-xs btn-warning hidden_edit_btn">
                                                                <i class="fa fa-wrench"></i>{{$voucher->id}}
                                                            </a>
                                                        @endif
                                                        -{{$voucher->voucher_no}}</td>
                                                        
                                                        <td rowspan="{{$rowspan}}">{{$date}}</td>
                                                    @endif
                                                    <td class="text-left {{$jr->ledger_id==308?'text-danger':''}}">@if($jr->type==1) &nbsp;&nbsp;&nbsp;&nbsp; @endif
                                                        @if($searchrd_voucher)
                                                            <strong>{{$jr->ledger ? $jr->ledger->name:''}}</strong>
                                                            @php
                                                                if($jr->ledger_id==308){
                                                                    updateJournalLedgerAndChildRefference($jr->id,$searchrd_voucher->id,307,1);
                                                                }
                                                                $ccounter=count($searchrd_voucher->journalsGlobal->where('reff_jr_id','!=',null));
                                                                $refcounter=count($searchrd_voucher->journalsGlobal->where('ledger_id','=',$jr->reff_no));
                                                                $reffLedToJrID=count($searchrd_voucher->journalsGlobal->where('ledger_id','=',44))?$searchrd_voucher->journalsGlobal->where('ledger_id','!=',44)->first()->id:null;
                                                               
                                                            @endphp
                                                            @if($searchrd_voucher->transaction_amount!=$jr->amount) 
                                                                <button type="button" id="hide_btn_{{$searchrd_voucher->id}}" class="pull-right btn-danger" onclick="setReffVoucherAmountUpdate({{$searchrd_voucher->id}},{{$jr->amount}},{{$jr->id}},{{$searchrd_voucher->id}})"><i class="fa fa-refresh"></i>Reset</button>
                                                            @endif
                                                           
                                                            <table width="100%" class="bg-{{$searchrd_voucher->transaction_amount==$jr->amount?($tableColor==1?'success':'light'):'warning'}}">
                                                                @forelse($searchrd_voucher->journalsGlobal as $rjr)
                                                                    <tr>
                                                                        @php
                                                                            $upp=0;
                                                                            if($rjr->type==$jr->type){
                                                                                if(Request()->update_reff==1){
                                                                                    updateJournalLedgerAndChildRefference($jr->id,$searchrd_voucher->id,$rjr->id);
                                                                                }
                                                                                $upp=1;
                                                                            }
                                                                        @endphp
                                                                        @if($kf==0)
                                                                        @php
                                                                            $dCheck=(date('dmY',strtotime($searchrd_voucher->date))==date('dmY',strtotime($voucher->date)));
                                                                        @endphp
                                                                            <td rowspan="{{$rrowspan}}">
                                                                                {{$searchrd_voucher->id.'-'.$searchrd_voucher->voucher_no}}
                                                                                @if($tableColor==0)
                                                                                    <button id="hide_btn_{{$searchrd_voucher->id}}" type="button" class="pull-right btn-danger" onclick="setReffVoucherAmountUpdate({{$searchrd_voucher->id}},{{(-1)}},{{$jr->id}},{{$searchrd_voucher->id}},'{{$jr->date}}')"><i class="fa fa-refresh"></i>Reff This</button>
                                                                                @endif
                                                                            </td>
                                                                            <td rowspan="{{$rrowspan}}" class="text-{{$dCheck?'dark':'danger'}}">
                                                                                {{$rdate}}
                                                                                @if(!$dCheck) 
                                                                                    <button id="hide_btn_{{$searchrd_voucher->id}}" type="button" class="pull-right btn-danger" onclick="setReffVoucherAmountUpdate({{$searchrd_voucher->id}},{{(-1)}},{{$jr->id}},{{$searchrd_voucher->id}},'{{$jr->date}}')"><i class="fa fa-refresh"></i>ResetDate</button>
                                                                                @elseif((date('dmYH',strtotime($rjr->created_at))<date('dmYH',strtotime($rjr->updated_at))))
                                                                                    <br><span>{{date('d-M-Y H:i',strtotime($rjr->updated_at))}}</span>
                                                                                @endif
                                                                            </td>
                                                                        @endif
                                                                        <td class="text-left {{$upp==1?'text-warning':'text-dark'}}" title="{{$rjr}}">@if($rjr->type==1) &nbsp;&nbsp;&nbsp;&nbsp; @endif{{$rjr->globalLedger ? $rjr->globalLedger->name:''}}</td>
                                                                        <td class="text-right">{{$rjr->type==0?number_format($rjr->amount,2):'-'}}</td>                       
                                                                        <td class="text-right">{{$rjr->type==1?number_format($rjr->amount,2):'-'}}</td>   
                                                                        @php ++$kf;@endphp
                                                                    </tr>
                                                                @empty
                                                                @endforelse
                                                            </table>
                                                        @else
                                                            {{$jr->ledger ? $jr->ledger->name:''}}
                                                        @endif
                                                    </td>
                                                    {{-- @if($k==0)
                                                        <td class="text-left" rowspan="{{$rowspan}}">{{$voucher->note}}</td>
                                                    @endif --}}
                                                    <td class="text-right">{{$jr->type==0?number_format($jr->amount,2):'-'}}</td>                       
                                                    <td class="text-right">{{$jr->type==1?number_format($jr->amount,2):'-'}}</td>   
                                                </tr>
                                                @php
                                                    ++$k;
                                                @endphp
                                            @empty
                                            @endforelse
                                        @empty
                                            <tr>
                                                <td colspan="8">There is no records available</td>
                                            </tr>
                                        @endforelse
                                        </tbody>
                                        <tfoot>
                                          <th colspan="3" class="text-right">Total Transaction :</th>
                                          <th class="text-right">{{ number_format(0,2) }}</th>
                                          <th class="text-right">{{ number_format(0,2) }}</th>
                                        </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>
                </div>
            {{-- </form> --}}
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script>
    $('#cost_center_id').select2();
    $('#created_by').select2();
    const setReffVoucherAmountUpdate=(id,amount,reff_jr_id,reffed_id,re_date=0)=>{
        let link= "{{route('voucher.sl_wise_store_edit')}}";
        let data_param={
            id:id,
            amount:amount,
            re_date:re_date,
            reff_jr_id:reff_jr_id,
            reffed_id:reffed_id,
            editFromJournal:1
        }
        const setGroupData = data => { 
           if(data==1){
                callSweetAlert('success','<p class="text-info">Update Successfull.!!!</p>','',);
                $('#hide_btn_'+reffed_id).hide();
           }
        }
        ajaxCall(link,'POST',data_param, setGroupData);
    }
    const callSweetAlert = (icon, title, html, confirm=0, callback) => {
    let obj = {
        icon: icon,//'warning',
        title: title,//'<p class="text-danger">Cradit Limit Exceed.!!!</p>',
        html: html,//`<p class="text-warning">Max Limit: <span class="badge badge-danger"> ${party_limit-party_balance} </span></p>`
    };
    if (confirm == 1) {
        obj.showCancelButton = true,
        obj.confirmButtonColor = '#3085d6',
        obj.cancelButtonColor = '#d33',
        obj.confirmButtonText = 'Yes'
    }
    Swal.fire(obj).then(result => {
        if (result.isConfirmed) {
            if (typeof callback != 'undefined')
                callback();
            // Swal.fire(
            //   'Deleted!',
            //   'Your file has been deleted.',
            //   'success'
            // )
        }
    });
}
 
</script>
@stop