@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: {!! DisplayHelper::formatDate($report->as_at_date) !!}<br>
        Report Level: {{ $report->level }}<br>
        {{ $report->level }} Range: {{ $report->start_code }} - {{ $report->end_code }}<br>
        Agreement Type: {{ $report->agreement_type }} <br>
        Transaction Type: {{ $report->payment_type }} <br>
        @if (!$report->pdf)
            <br><small>Printed at: {!! DisplayHelper::formatDateTime($report->print_time) !!}</small>
        @endif
    </div>

    <hr>

    </div>

    @foreach($agreement_types as $agreement_type)

        <div style="page-break-inside:avoid;">
        <h3>{{ $agreement_type->description}} </h3>
        <table id="tbl_exporttable_to_xls" class = "table table-bordered">
            <thead>
                <tr>
                    <th>Transaction Date</th>
                    <th>Agreement No</th>
                    <th>Client Name</th>
                    <th>Agreement Type</th>
                    <th>Transaction Type</th>
                    <th>Comment</th>
                    <th>Ref</th>
                    <th style="text-align:right">Amount</th>
                </tr>
            </thead>

            <tbody>

            @foreach ($agreement_type->agreements as $agreement)
                @foreach ($agreement->payments as $payment)
                    <tr>
                        <td>{!! DateHelper::stringify($payment->effective_date) !!}</td>
                        <td>{{ $agreement->agreement_code }}</td>
                        <td>{{ $agreement->client_name }}</td>
                        <td>{{ ucfirst($agreement_type->description) }}</td>
                        <td>{{ ucfirst($payment->payment_type) }}</td>
                        <td>{{ $payment->comment }}</td>
                        <td>{{ $payment->reference }}</td>
                        @if ($payment == end($agreement->payments))
                            <td style="text-align:right; border-bottom:1px solid black;">
                        @else
                            <td style="text-align:right;">
                        @endif
                        {!! DisplayHelper::formatCurrency($payment->amount) !!}</td>
                   </tr>
               @endforeach {{-- payments --}}
               <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td style="text-align:right; border-bottom: 1px solid black;">
                        <strong>{!! DisplayHelper::formatCurrency($agreement->payment_sum) !!}</strong></td>
               </tr>

               <tr>
                    <td><br></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    @if ($agreement == end($agreement_type->agreements))
                        <td style="border-bottom:1px solid black;">
                    @else
                        <td>
                    @endif
                    </td>
               </tr>

            @endforeach {{-- agreement --}}
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td style="text-align:right; border-bottom:1px solid black;">
                    <strong>{!! DisplayHelper::formatCurrency($agreement_type->payment_sum) !!}</strong></td>
            </tr>

            @if ($agreement_type == end($agreement_types))
            <tr>
                <td colspan=7><br></td>
                <td style="border-bottom:1px solid black;"></td>
            </tr>

            <tr>
                <td colspan=7 style="text-align:right;"><strong>TOTAL : </strong></td>
                <td style="text-align:right; border-bottom:1px solid black;">
                    <strong>{!! DisplayHelper::formatCurrency($total_payment_sum) !!}</strong></td>
            </tr>
            @endif


        </tbody>
    </table>
    </div>
    @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