@extends('docs.master', ['title' => 'Trial Balance'])

@section('content')
<div class="document">
<div class="document-heading">

<div class="row">
<div class="col col-12">
<h2 style="text-align: center">
<span> Receipts & Expenses Report</span><br>
</h2>
<h2 style="text-align: center">
Start Date {{date('d-m-Y',strtotime($model[0]->start_date))}}
</h2>
<h2 style="text-align: center">
    End Date {{date('d-m-Y',strtotime($model[0]->end_date))}}
    </h2>
</div>
</div>
</div>
<div class="document-body">
<table class="document-table">
<thead>
<tr>
<th>#</th>

<th style="text-align: center">Account Code</th>
<th>Account Title</th>
<th style="text-align: center">Account Type</th>
{{-- <th style="text-align: center">Balance B/F</th> --}}

<th style="text-align: center">Recipts</th>
<th style="text-align: center">Payments</th>
{{-- <th style="text-align: center">Balance</th> --}}
</tr>
</thead>
<tbody>
{{$i=1}}
{{--{{var_dump($model[0]->zeroed)}}--}}
{{--{{dd()}}--}}
@foreach($model as $item)

<tr>
<td>{{$i++}}</td>
<td class="width-2"> {{$item->accountcode}}</td>
<td class="width-3"> {{$item->accounttitle}}</td>

<td class="width-2"> {{$item->accounttypename}}</td>

{{-- <td class="width-2 align-right">
    @if ($item->debit_befor - $item->credit_befor >0)
    {{(number_format($item->debit_befor-$item->credit_befor,2))}}&nbsp;Dr
    @else
    {{(number_format($item->credit_befor-$item->debit_befor,2))}}&nbsp;Cr
    @endif 
</td> --}}
<td class="align-right">       
@if ($item->debit >0)
{{(number_format($item->debit,2))}}
@else
<span>-</span>
@endif
</td>
<td class="align-right">
@if ($item->credit >0)
{{(number_format(abs($item->credit),2))}}
@else
<span>-</span>
@endif
</td>
{{-- <td class="width-2 align-right">
    @if ($item->debit_befor - $item->credit_befor + $item->debit -$item->credit >0)
    {{(number_format($item->debit_befor - $item->credit_befor + $item->debit -$item->credit,2))}}&nbsp;Dr
    @else
    {{(number_format(($item->debit_befor - $item->credit_befor + $item->debit -$item->credit)*-1,2))}}&nbsp; Cr
    @endif 
</td> --}}
</tr>

@endforeach
<tr class="item-footer">
<td colspan="4"><strong>Total</strong></td>

<td class="align-right">
<strong>{{number_format($model->sum('debit'),2)}}</strong>
</td>
<td class="align-right">
<strong>{{number_format(abs($model->sum('credit')),2)}}</strong>
</td>
{{-- <td class="align-right">
    &nbsp;
    </td> --}}
</tr>
</tbody>
</table>
</div>

<br /><br /><br />

@if($model->cash_receipts)
<div class="row">
    <h1>Cash Receipts</h1>
</div>   
<div class="document-body" style="font-weight:bold">
    <table class="document-table">
    <thead>
    <tr>
    <th>#</th>
    <th class="align-center">Voucher #</th>
    <th class="align-center">Date</th>
    
    
    <th style="text-align: center">Account Code</th>
    <th>Account Title</th>
    <th style="text-align: center">Narration</th>
    
    
    <th style="text-align: right">Amount</th>
    
    </tr>
    </thead>
    <tbody>
    {{$i=1}}
  
    @foreach($model->cash_receipts as $item)
    
    <tr>
    <td>{{$i++}}</td>
    <td class="width-1 align-center"> {{$item->voucher_number}}</td>
    <td class="width-1 align-center"> {{$item->voucher_date}}</td>
    <td class="width-2 align-center"> {{$item->accountcode}}</td>
    <td class="width-3"> {{$item->accounttitle}}</td>
    <td class="width-4"> {{$item->detail_remarks}}</td>
    
  
    
  
    <td class="width-2 align-right">       
    @if ($item->credit >0)
    {{(number_format($item->credit,2))}}
    @else
    <span>-</span>
    @endif
    </td>
   
 
    </tr>
    
    @endforeach
    <tr class="item-footer">
    <td colspan="6"><strong>Total</strong></td>
    
    <td class=" width-3 align-right">
    <strong>{{number_format($model->cash_receipts->sum('credit'),2)}}</strong>
    </td>
    
   
    </tr>
    </tbody>
    </table>
</div>
@endif
<br /><br /><br />

@if($model->cash_receipts)
<div class="row">
    <h1>Bank Receipts</h1>
</div>   
<div class="document-body">
    <table class="document-table">
    <thead>
    <tr>
    <th>#</th>
    <th class="align-center">Voucher #</th>
    <th class="align-center">Date</th>
    
    <th style="text-align: center">Account Code</th>
    <th>Account Title</th>
    <th style="text-align: center">Narration</th>
    
    
    <th style="text-align: right">Amount</th>
    
    </tr>
    </thead>
    <tbody>
    {{$i=1}}
  
    @foreach($model->bank_receipts as $item)
    
    <tr>
    <td>{{$i++}}</td>
    <td class="width-1 align-center"> {{$item->voucher_number}}</td>
    <td class="width-1 align-center"> {{$item->voucher_date}}</td>
    <td class="width-2 align-center"> {{$item->accountcode}}</td>
    <td class="width-3"> {{$item->accounttitle}}</td>
    <td class="width-4"> {{$item->detail_remarks}}</td>
    
  
    
  
    <td class="width-2 align-right">       
    @if ($item->credit >0)
    {{(number_format($item->credit,2))}}
    @else
    <span>-</span>
    @endif
    </td>
   
 
    </tr>
    
    @endforeach
    <tr class="item-footer">
    <td colspan="6"><strong>Total</strong></td>
    
    <td class=" width-3 align-right">
    <strong>{{number_format($model->bank_receipts->sum('credit'),2)}}</strong>
    </td>
    
   
    </tr>
    </tbody>
    </table>
</div>
@endif
<br /><br /><br />

@if($model->cash_payments)
<div class="row">
    <h1>Cash Payments</h1>
</div>   
<div class="document-body">
    <table class="document-table">
    <thead>
    <tr>
    <th>#</th>
    <th >Voucher #</th>
    <th class="align-center">Date</th>
    <th style="text-align: center">Account Code</th>
    <th >Account Title</th>
    <th style="text-align: center">Narration</th>
    
    
    <th style="text-align: right">Amount</th>
    
    </tr>
    </thead>
    <tbody>
    {{$i=1}}
  
    @foreach($model->cash_payments as $item)
    
    <tr>
    <td>{{$i++}}</td>
    <td class="width-1 align-center"> {{$item->voucher_number}}</td>
    <td class="width-1 align-center"> {{$item->voucher_date}}</td>
    <td class="width-2 align-center"> {{$item->accountcode}}</td>
    <td class="width-3"> {{$item->accounttitle}}</td>
    <td class="width-4"> {{$item->detail_remarks}}</td>
    
  
    
  
    <td class="width-2 align-right">       
    @if ($item->debit >0)
    {{(number_format($item->debit,2))}}
    @else
    <span>-</span>
    @endif
    </td>
   
 
    </tr>
    
    @endforeach
    <tr class="item-footer">
    <td colspan="6"><strong>Total</strong></td>
    
    <td class=" width-3 align-right">
    <strong>{{number_format($model->cash_payments->sum('debit'),2)}}</strong>
    </td>
    
    </tr>
    </tbody>
    </table>
</div>
@endif

<br /><br /><br />

@if($model->bank_payments)
<div class="row">
    <h1>Bank Payments</h1>
</div>   
<div class="document-body">
    <table class="document-table">
    <thead>
    <tr>
    <th>#</th>
    <th >Voucher #</th>
    <th class="align-center">Date</th>
    <th style="text-align: center">Account Code</th>
    <th >Account Title</th>
    <th style="text-align: center">Narration</th>
    
    
    <th style="text-align: right">Amount</th>
    
    </tr>
    </thead>
    <tbody>
    {{$i=1}}
  
    @foreach($model->bank_payments as $item)
    
    <tr>
    <td>{{$i++}}</td>
    <td class="width-1 align-center"> {{$item->voucher_number}}</td>
    <td class="width-1 align-center"> {{$item->voucher_date}}</td>
    <td class="width-2 align-center"> {{$item->accountcode}}</td>
    <td class="width-3"> {{$item->accounttitle}}</td>
    <td class="width-4"> {{$item->detail_remarks}}</td>
    
  
    
  
    <td class="width-2 align-right">       
    @if ($item->debit >0)
    {{(number_format($item->debit,2))}}
    @else
    <span>-</span>
    @endif
    </td>
   
 
    </tr>
    
    @endforeach
    <tr class="item-footer">
    <td colspan="6"><strong>Total</strong></td>
    
    <td class=" width-3 align-right">
    <strong>{{number_format($model->bank_payments->sum('debit'),2)}}</strong>
    </td>
    
    </tr>
    </tbody>
    </table>
</div>
@endif

</div>
@endsection