@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>
    <hr>
     <div>
        <h4>{{ $report->company_name }}</h4>
        <h3>{{ $report->description }}</h3>
        
        As at Date: {!! App\Helpers\DisplayHelper::formatDate($report->as_at_date) !!}<br>
        Agreement Range: {{ $report->start_agreement_code }} - {{ $report->end_agreement_code }}<br>
        Client Type: {{ $report->client_type }} <br>
        Clients: {{ $report->clients }} <br>
        Agreement Type: {{ $report->agreement_type }} <br>
        Agreement Status: {{ $report->agreement_status }} <br>
        Include History: {{ $report->include_history }}
        @if (!$report->pdf)
            <br><small>Printed at: {!! App\Helpers\DisplayHelper::formatDateTime($report->print_time) !!}</small>
        @endif
    </div>
         
    <hr>
         
    <table id="tbl_exporttable_to_xls" class = "table table-bordered">
        <thead>
            <tr>
                <th>Agreement</th>
                <th>Client</th>
                <th>@if ($report->lease)
                        Contract o/s   
                    @else
                        Balance o/s    
                    @endif
                </th>
                <th>Settlement</th>
                <th style="text-align:right;">Payments<br>Remaining</th>
                @if ($report->capital_interest_split)
                    <th style="text-align:right;">Interest Due</th>
                    <th style="text-align:right;">Capital Due</th>
                @endif
                
                @if ($report->discount)
                    <th style="text-align:right;">Face Value</th>
                    <th style="text-align:right;">Receipts</th>
                @endif
                
                <th style="text-align:right;">Total Due</th>
                <th style="text-align:right;">{{ $report->month4 }}</th>
                <th style="text-align:right;">{{ $report->month3 }}</th>
                <th style="text-align:right;">{{ $report->month2 }}</th>
                <th style="text-align:right;">{{ $report->month1 }}</th>
                <th>Last Payment Date</th>
            </tr>
        </thead>
        
        <tbody>

            @foreach ($agreements as $agreement) 
            <tr>
                <td>{{ $agreement->agreement_code }}</td>
                <td>{{ $agreement->client_name }}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->balance_os) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->settlement) !!}</td>
                <td style="text-align:right">{{ $agreement->payments_left }}</td>
                    
                @if ($report->capital_interest_split)    
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_interest) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_capital) !!}</td>
                @endif
                
                @if ($report->discount)    
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->face_value) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->payments_total) !!}</td>
                @endif
                
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_amount) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_month_4) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_month_3) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_month_2) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due_month_1) !!}</td>
                <td>{!! App\Helpers\DateHelper::stringifyWithTime($agreement->last_payment_date) !!}</td>
            </tr>
            @endforeach
        </tbody>
            
        <tfoot>
            <tr>
                <td>TOTALS</td>
                <td></td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->balance_os) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->settlement) !!}</td>
                <td></td>
                @if ($report->capital_interest_split)
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_interest) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_capital) !!}</td>
                @endif
                
                @if ($report->discount)
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->face_value) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->payments_total) !!}</td>
                @endif
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_amount) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_month_4) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_month_3) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_month_2) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($summary->now_due_month_1) !!}</td>
                <td></td>
            </tr>
         </tfoot>
      </table>   
@stop


@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