@extends('app')

@section('content')

<center> <button onclick="ExportToExcel('xlsx')" style="border:0px; padding:15px 20px; font-weight:bold; background:#4E2E74; color:#fff;">Download Report</button></center>

<table id="tbl_exporttable_to_xls">
<tr><td>

 
@foreach ($agreements as $agreement)
    <div @unless ($agreement == end($agreements)) class="page-break-after" @endunless>
  
        <hr>
        
        <div style="padding-bottom:10px:">
            @include('reports.company_details')
        </div>
      
        <hr class="dashed-light">
        
        <div style="text-align:center; padding-bottom:10px;">
            <h4>Statement of Account</h4>
            as at {!! $report->as_at_date->format('j F Y') !!} <br>
            Period: {!! DisplayHelper::formatDate($report->start_date) !!} - {!! DisplayHelper::formatDate($report->as_at_date) !!}
        </div>
         
        <hr class="dashed-light">
            
        <div style="padding-bottom:2px;">
          
            <div>
                <h4>{{ $agreement->client_name}} </h4>
                {{ $agreement->post_address1 }} <br>
                {{ $agreement->post_address2 }} <br>
                {{ $agreement->post_address3 }} <br>
                {{ $agreement->post_postalcode }}      
            </div>
        </div>
            
        <hr class="dashed-light">
            
        <div>

            <table style="width:100%">
                <tr>
                    <td style="width:50%">
                        <table>
                            <tr><td>Agreement No : </td><td>{{ $agreement->agreement_code }}</td></tr>
                            <tr><td>Agreement Type : </td><td>{{ $agreement->agreement_type }}</td></tr>
                            <tr><td>Description : </td><td>{{ $agreement->agreement_description }}</td></tr>
                            <tr><td>Agreement Status : </td><td>{{ $agreement->agreement_status }}</td></tr>
                        </table>
                    </td>
                        
                    <td style="width:50%">
                        <table>
                            @if ($agreement->lease)
                                <tr><td>Escalation :</td><td> {{ $agreement->escalation_rate }}%</td></tr>
                            @elseif ($agreement->discount)
                                <tr><td>Discount rate per month :</td><td> {{ $agreement->discount_rate }}%</td></tr>
                            @else
                                <tr><td>Interest rate :</td><td> {{ $agreement->interest_rate }}%</td></tr>
                            @endif
                            <tr><td>Payment due date : </td><td>{{ $agreement->payment_due_day }}</td></tr>
                            <tr><td>Frequency : </td><td>{{ ucfirst($agreement->payment_frequency) }}</td></tr>
                           
                            <tr><td>{{ ucfirst($agreement->payment_description) }} amount : </td><td>{!! DisplayHelper::formatCurrency($agreement->payment_due_amount) !!}</td></tr>
                            <tr><td>{{ ucfirst($agreement->outstanding_description) }} : </td><td>{!! DisplayHelper::formatCurrency($agreement->total_outstanding) !!}</td></tr>
                            
                        </table>
                    </td>
               
                    
                    
            </table>
        </div>
                
        <hr>
                 
        <table class = "table table-bordered">
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Transaction</th>
                    <th>Invoice #</th>
                    <th style="text-align:right">Capital</th>
                    <th style="text-align:right">Interest</th>
                    <th style="text-align:right">Total</th>
                </tr>
            </thead>
            
            <tbody>
    
                <tr>
                    <td>{!! DateHelper::stringifyWithTime($report->start_date)!!}</td>
                    <td>Opening balance</td>
                    <td></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($agreement->settlement_start) !!}</td>
                </tr>
                    
                    
                @if ($agreement->add_initial_value)  
                <tr>
                    <td>{!! DateHelper::stringify($agreement->confirm_date)!!}</td>
                    <td>{{ ucfirst($agreement->initial_value_description) }}</td>
                    <td></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($agreement->initial_value) !!}</td>
                </tr>   
                @endif
                    
                @foreach ($agreement->transactions as $transaction) 
                <tr>
                    <td>{!! DateHelper::stringifyWithTime($transaction->effective_date) !!}</td>
                    <td>{{ ucfirst($transaction->description) }}</td>
                    <td>{{ $transaction->invoice_no }}</td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($transaction->capital) !!}</td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($transaction->interest) !!}</td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($transaction->balance_os) !!}</td>
                </tr>
                @endforeach
            </tbody>
                
            <tfoot>
                <tr>
                    <td>{!! DateHelper::stringifyWithTime($report->as_at_date) !!}</td>
                    <td>Closing balance</td>
                    <td></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right"></td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($agreement->settlement_end) !!}</td>
                </tr>
             </tfoot>
        </table>
                
                
        <div style="padding-top:20px">
            <table class="table">
            
               {{-- @if ($agreement->total_due->amount) --}}
                <tr>
                    <td></td>
                    <td style="text-align:right" class="border-tb-light">Capital</td>
                    <td style="text-align:right" class="border-tb-light">Interest</td>
                    <td style="text-align:right" class="border-tb-light">Total</td>
                </tr>
                {{--@endif --}}
                
               {{-- @if ($agreement->now_due_end->amount > 0)  --}} 
                <tr>
                    <td style="font-weight:bold">Now due</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->now_due_end->capital) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->now_due_end->interest) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->now_due_end->amount) !!}</td>
                </tr>
               {{-- @endif --}}
                
                {{--@if ($agreement->next_payment_due->amount)   --}}
                <tr>
                    <td>Next {{ $agreement->payment_description }} due : {!! App\Helpers\DateHelper::stringifyWithTime($agreement->next_payment_due->payment_date) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->next_payment_due->capital) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->next_payment_due->interest) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->next_payment_due->amount) !!}</td>
                </tr>
                {{--@endif --}}
                
                {{--@if ($agreement->total_due->amount) --}}
                <tr>
                    <td class="border-tb-dashed">{{ $agreement->total_due_description }}</td>
                    <td style="text-align:right" class="border-tb-dashed">{!!DisplayHelper::formatCurrency($agreement->total_due->capital) !!}</td>
                    <td style="text-align:right" class="border-tb-dashed">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->total_due->interest) !!}</td>
                    <td style="text-align:right" class="border-tb-dashed">{!! App\Helpers\DisplayHelper::formatCurrency($agreement->total_due->amount) !!}</td>
                </tr>
                {{-- @endif --}}
            </table>
                
            @foreach($agreement->summary as $summary)
                <div style="page-break-inside:avoid;">
                    @if($summary == reset($agreement->summary))
                        <h4>SUMMARY FOR ACCOUNTING AND TAX PURPOSES</h4>
                    @endif
                    <table class="table">
                        <tr>
                            <td style="font-weight:bold; width:50%" class="border-tb-light">{{ $summary->header }}</td>
                            <td style="text-align:right" class="border-tb-light">Capital</td>
                            <td style="text-align:right" class="border-tb-light">Interest</td>
                            <td style="text-align:right" class="border-tb-light">Total</td>
                        </tr>
                            
                        @foreach ($summary->lines as $line)    
                        <tr>
                            <td>{{ $line->description }}</td>
                            <td style="text-align:right">{!! DisplayHelper::formatCurrency(DisplayHelper::nullToZero($line->capital)) !!}</td>
                            <td style="text-align:right">{!! DisplayHelper::formatCurrency(DisplayHelper::nullToZero($line->interest) )!!}</td>
                            <td style="text-align:right">{!! DisplayHelper::formatCurrency(DisplayHelper::nullToZero($line->amount)) !!}</td>
                        </tr>
                        @endforeach
                    </table>
                </div>
            @endforeach
             
        </div>      
    </div>
@endforeach
@stop

</td></tr></table>


@section('scripts')
    
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
<script>
   
   function ExportToExcel(type, fn, dl) {
            var elt = document.getElementById('tbl_exporttable_to_xls');
            var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1" });

           return dl ?
                XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) :
                XLSX.writeFile(wb, fn || ('{{ $report->description }}.' + (type || 'xlsx')));
        }


</script>
    
@stop