@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.journal_view')}}" method="get">
            @include('accounts.reports.search_form',['ledger'=>0,'is_user'=>1])
            {{-- <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 class="col-5 px-0">
                        <label for="pay_type">C CENTER</label>
                    </div>
                    <div class="col-7 px-0">
                        <select name="cost_center_id" id="cost_center_id">
                            <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-4 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 class="col-5 px-0">
                        <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')}}">
                    </div>
                    <div class="col-2 px-0 text-center">
                        <label for="cost_id">TO</label>
                    </div>
                    <div class="col-5 px-0">
                        <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>
                </div>
                <div class="col-md-2 col-12 d-flex flex-wrap pr-0 mb-1">
                    <div class="col-12 px-0">
                        <div class="input-group">
                            <span class="input-group-text">Search</span>
                            <div class="input-group-append">
                                <button type="submit" class="btn btn-danger">
                                <span class="fa fa-search"></span>
                                </button>
                            </div>

                        </div>
                    </div>
                </div>
                
            </div> --}}
        </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)
                                          <tr>
                                              <td>{{$voucher->voucher_no}}</td>
                                             @php 
                                                $time=strtotime($voucher->date);
                                                $date=date("d-M-Y",$time);
                                                $ledger_name='';
                                                $damountHtml='';
                                                $amountHtml='';
                                                $title='';
                                                foreach($voucher->journals->sortBy('group_type')->groupBy('group_type') as $journalsEntryGroup){
                                                    foreach($journalsEntryGroup as $jr){
                                                        //dd($jr);
                                                        if($jr->type==0){
                                                            if($jr->refTransaction && $jr->voucher->reff_transaction_id){
                                                                $ledger_name.='<span title="'.($jr->ledger ? $jr->ledger->name:'').'">'.getNameLedgerName($jr->refTransaction,$jr->type).'</span><br>';
                                                            }else{
                                                                $ledger_name.=($jr->ledger ? $jr->ledger->name.(($jr->voucher->reff_transaction_id==null) && $jr->refLedger && ($jr->ledger_id!=$jr->reff_no))? ' <strong>[ '.$jr->refLedger->name.' ]</strong>':'') : '').'<br>';
                                                            }
                                                            // $ledger_name.=getNameLedgerName($voucher->reffVoucher,$jr).'<br>';
                                                            //$ledger_name.=($jr->ledger ? $jr->ledger->name.(($jr->refLedger && ($jr->ledger_id!=$jr->reff_no))? ' <strong>[ '.$jr->refLedger->name.' ]</strong>':'') : '').'<br>';
                                                            $damountHtml.=number_format($jr->amount,2).'<br>';
                                                            $amountHtml.='<br>';
                                                        }else{
                                                            if($jr->refTransaction){
                                                                $ledger_name.='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.'<span title="'.($jr->ledger ? $jr->ledger->name:'').'">'.getNameLedgerName($jr->refTransaction,$jr->type).'</span><br>';
                                                            }else{
                                                                $ledger_name.='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.($jr->ledger ? $jr->ledger->name.(($jr->refLedger && ($jr->ledger_id!=$jr->reff_no))? ' <strong>[ '.$jr->refLedger->name.' ]</strong>':'') : '').'<br>';
                                                            }
                                                            //$ledger_name.=($jr->ledger ? $jr->ledger->name.(($jr->refLedger && ($jr->ledger_id!=$jr->reff_no))? ' <strong>[ '.$jr->refLedger->name.' ]</strong>':'') : '').'<br>';
                                                            // $ledger_name.='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.getNameLedgerName($voucher->reffVoucher,$jr).'<br>';
                                                            $amountHtml.=number_format($jr->amount,2).'<br>';
                                                            $damountHtml.='<br>';
                                                            $amount=$amount+$jr->amount;
                                                        }
                                                    }
                                                }
                                              @endphp
                                              <td>{{$date}}</td>
                                              <td class="text-left" title="{{$title}}">{!!$ledger_name!!}</td>
                                              <td class="text-left">{{$voucher->note}}</td>
                                              <td class="text-right">{!!$damountHtml!!}</td>                       
                                              <td class="text-right">{!!$amountHtml!!}</td>                       
                                          </tr>
                                        @empty
                                            <tr>
                                                <td colspan="8">There is no records available</td>
                                            </tr>
                                        @endforelse
                                        </tbody>
                                        <tfoot>
                                          <th colspan="4" class="text-right">Total Transaction :</th>
                                          <th class="text-right">{{ number_format($amount,2) }}</th>
                                          <th class="text-right">{{ number_format($amount,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();
 
</script>
@stop