@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>

        Start Date: {!! DisplayHelper::formatDate($report->start_date) !!}<br>
        End Date: {!! DisplayHelper::formatDate($report->end_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>
        Agreement Charge: {{ $report->agreement_charge }} <br>
        @if (!$report->pdf)
            <br><small>Printed at: {!! DisplayHelper::formatDateTime($report->print_time) !!}</small>
        @endif
    </div>

    <hr>

    </div>
    <table id="tbl_exporttable_to_xls" class = "table table-bordered">
            <thead>
                <tr>
                    <th>Agreement No</th>
                    <th>Client Name</th>
                    <th>Agreement Type</th>
                    <th>Income Type</th>
                    <th style="text-align:right">Amount(Ex. VAT)</th>
                    <th style="text-align:right">VAT</th>
                    <th style="text-align:right">Amount(Incl. VAT)</th>
                </tr>
            </thead>

            <tbody>
            @php
                $total = 0.0;
                $total_vat = 0.0;
            @endphp
            @foreach ($data as $agreement)
                @if (count($agreement['incomes']))
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
               </tr>
                @php
                    $a_total = 0.0;
                    $v_total = 0.0;
                @endphp
                @foreach ($agreement['incomes'] as $key => $income)
                    <tr>
                        <td>{{ $agreement['agreement_code'] }}</td>
                        <td>{{ $agreement['client'] }}</td>
                        <td>{{ $agreement['agreement_type'] }}</td>
                        <td>{{ $key }}</td>
                        <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($income['amount']) !!}</td>
                        <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($income['vat']) !!}</td>
                        <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($income['amount'] + $income['vat']) !!}</td>
                    </tr>
                    @php
                        $a_total += $income['amount'];
                        $v_total += $income['vat'];
                    @endphp
                @endforeach
                
                @php
                    $total += $a_total;
                    $total_vat += $v_total;
                @endphp
                @endif
            @endforeach
        </tbody>

        <tfoot>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td>TOTALS</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total_vat) !!}</td>
                <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatMoney($total + $total_vat) !!}</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