@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])
        </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>Reff 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($journals->groupBy('voucher_id') as $journalsEntry)
                                          <tr>
                                              <td>{{$journalsEntry->first()->voucher->voucher_no}}</td>
                                                @php
                                                    $reff=$journalsEntry->first()->voucher->reffInvoice??$journalsEntry->first()->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-center" style="padding: 0 2px;">
                                                    @if($reff)
                                                        <a target="_blank" href="{{ '/'.$printUrlArray[$reff->transaction_type].$reff->id }}" class="text-dark">{{$reff->invoice_no}}</a>
                                                    @endif
                                                </td> 
                                             @php 
                                                $time=strtotime($journalsEntry->first()->voucher->date);
                                                $date=date("d-M-Y",$time);
                                                $ledger_name='';
                                                $damountHtml='';
                                                $amountHtml='';
                                                $title='';
                                                foreach($journalsEntry->sortBy('group_type')->groupBy('group_type') as $journalsEntryGroup){
                                                    foreach($journalsEntryGroup as $jr){
                                                        if($jr->type==0){
                                                            $title.=''; //$jr->refTransaction;
                                                            if($jr->refTransaction){
                                                                $ledger_name.='<span title="'.($jr->globalLedger ? $jr->globalLedger->name:'').'">'.getNameLedgerName($jr->refTransaction,$jr->type).'</span><br>';
                                                            }else{
                                                                $ledger_name.=($jr->globalLedger ? $jr->globalLedger->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>';
                                                            $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->globalLedger ? $jr->globalLedger->name:'').'">'.getNameLedgerName($jr->refTransaction,$jr->type).'</span><br>';
                                                            }else{
                                                                $ledger_name.='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.($jr->globalLedger ? $jr->globalLedger->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;'.($jr->ledger ? $jr->ledger->name.(($jr->refLedger && ($jr->ledger_id!=$jr->reff_no))? ' <strong>[ '.$jr->refLedger->name.' ]</strong>':'') : '').'<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">{{$journalsEntry->first()->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="5" 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