@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 class="strong">
    <div>
        <h4>{{ $report->company_name }}</h4>
        <h3>{{ $report->description }}</h3>
        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 }} 
        @if (!$report->pdf)
            <br><small>Printed at: {!! App\Helpers\DisplayHelper::formatDateTime($report->print_time) !!}</small>
        @endif
    </div>
    <hr class="strong">

    <table  id="tbl_exporttable_to_xls">
    <tr><td>
    
    @foreach ($agreements as $agreement)
        <hr class="dashed">
        
        <table class="table" style="page-break-inside:avoid;">
            <tr>
                <td>Client: {{ $agreement->client_name }}</td>
                <td>Client Status: {{ $agreement->client_status }}</td>
            </tr>
            <tr>
                <td>Agreement: {{ $agreement->agreement_code }} - {{ $agreement->agreement_description }}</td>
                <td>Agreement Status: {!! $agreement->confirmed ? 'Confirmed' : 'Not confirmed' !!} {{ $agreement->agreement_status }}</td>
            </tr>
                
            @if (!$agreement->discount)
                <tr>
                    <td>{{ ucfirst($agreement->payment_description) }}: {!! App\Helpers\DisplayHelper::formatMoney($agreement->instalment + $agreement->instalment_vat) !!}</td>
                    <td>{{ucfirst($agreement->payment_description) }} Billed: {{ $agreement->last_billed_instalment }}</td>
                </tr>
            @endif
            
            <tr>
                <td>
                    @if ($agreement->lease)
                        Contract Amount:
                    @elseif ($agreement->discount)
                        Face value:
                    @else
                        Total payable:
                    @endif
                    {!! App\Helpers\DisplayHelper::formatMoney($agreement->total_payable) !!}
                </td>
                <td>Movements: {!! App\Helpers\DisplayHelper::formatMoney($agreement->movement) !!}</td>
            </tr>
            <tr>
                <td>
                    @if ($agreement->lease)
                        Contract Amount o/s:
                    @else
                        Balance o/s:
                    @endif
                    {!! App\Helpers\DisplayHelper::formatMoney($agreement->balance_os) !!}
                </td>
                <td>Now Due: {!! App\Helpers\DisplayHelper::formatMoney($agreement->now_due) !!}</td>
            </tr>
            <tr>
                <td>
                    @if ($agreement->discount)
                        Total advanced: {!! App\Helpers\DisplayHelper::formatMoney($agreement->total_advanced) !!}
                    @else
                        Principal: {!! App\Helpers\DisplayHelper::formatMoney($agreement->principal) !!}
                    @endif
                </td>
                <td>Settlement: {!! App\Helpers\DisplayHelper::formatMoney($agreement->settlement) !!}</td>
            </tr> 
        </table>

        <hr class="dashed">
         
        <table class = "table table-bordered">
            <thead>
                <tr>
                    <th>Ref No</th>
                    @if (!$agreement->transactions_by_date)
                        <th>Pmt No</th>
                    @endif
                    <th>Effective Date</th>
                    <th>Type</th>
                    <th>Comment</th>
                    @if ($agreement->capital_interest_split)
                        <th style="text-align:right">Interest</th>
                        <th style="text-align:right">Capital</th>
                    @endif
                    <th style="text-align:right">Amount</th>
                    <th style="text-align:right">Balance</th>
                </tr>
            </thead>
        
            <tbody>
                @foreach ($agreement->transactions as $transaction) 
                <tr>
                    <td>{{ $transaction->reference }}</td>
                    @if (!$agreement->transactions_by_date)
                        <td>{{ $transaction->payment_no }}</td>
                    @endif
                    <td>{!! App\Helpers\DateHelper::stringifyWithTime($transaction->effective_date) !!}</td>
                    <td>{{ $transaction->type->description }}</td>
                    <td>{{ $transaction->comment }}</td>
                    @if ($agreement->capital_interest_split)
                        <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->interest) !!}</td>
                        <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->capital) !!}</td>
                    @endif
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->amount) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($transaction->balance) !!}</td>
                </tr>
                @endforeach
             </tbody> 
        </table>

        </tr></td>
        </table>
        
    @endforeach 


@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