@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>{!! ucwords(trans('hilbit.report.assets.description')) !!}</h3>
         Date Interval: {!! DisplayHelper::formatDate($report->start_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>
         Asset Type: {{ $report->asset_type }} <br>
         Debtor/Supplier/Associate: {{ $report->providers }}
         @if (!$report->pdf)
            <br><small>Printed at: {!! DisplayHelper::formatDateTime($report->print_time) !!}</small>
         @endif
    </div>
         
    <hr>
         
    <table id="tbl_exporttable_to_xls" class = "table table-bordered">
        <thead>
            <tr>
               <th>Effective Date</th>
               <th>Client Code</th>
               <th>Client Name</th>
               <th>Agreement Code</th>
                  
               @if ($asset_type->vehicle)
                  <th>Make</th>
                  <th>Model</th>
                  <th>Series</th>
                  <th>Register #</th>
                  <th>Year</th>
                  <th>VIN</th>
                  <th>Engine #</th>
                  <th>Reg #</th>
                  <th style="text-align:right">Amount<br>Incl</th>
                     
               @elseif ($asset_type->equipment)
                  <th>Make</th>
                  <th>Model</th>
                  <th>Series</th>
                  <th>Serial #</th>
                  <th>Year</th>
                  <th>Colour</th>
                  <th style="text-align:right">Amount<br>Incl</th>
               
               @elseif ($asset_type->invoice)
                  <th>Invoice #</th>
                  <th>Invoice Date</th>
                  <th>Order #</th>
                  <th>Reference</th>
                  <th>Due Date</th>
                  <th style="text-align:right">Amount<br>Incl</th>
                     
               @elseif ($asset_type->cheque)
                  <th>Cheque #</th>
                  <th>Cheque Date</th>
                  <th>Due Date</th>
                  <th>Bank</th>
                  <th>Account No</th>
                  <th style="text-align:right">Discount<br>Amount Excl</th>
                  <th style="text-align:right">Face Value</th>
                     
               @elseif ($asset_type->right)
                  <th>Right #</th>
                  <th>Right Date</th>
                  <th>Due Date</th>
                  <th>Bank</th>
                  <th>Account No</th>
                  <th style="text-align:right">Discount<br>Amount Excl</th>
                  <th style="text-align:right">Face Value</th>
                     
               @elseif ($asset_type->property)
                  <th>Erf #</th>
                  <th>Suburb</th>
                  <th>Attorney</th>
                  <th>Transfer Due Date</th>
                  <th>Deed #</th>
                  <th style="text-align:right">Discount<br>Amount Excl</th>
                  <th style="text-align:right">Face Value</th>
               @endif

            </tr>
        </thead>
        
        <tbody>
            @foreach ($agreements as $agreement)
               @foreach ($agreement->assets as $asset)
                  <tr> 
                     <td>{!! DateHelper::stringify($agreement->confirm_date) !!}</td>
                     <td>{{ $agreement->client_code }}</td>
                     <td>{{ $agreement->client_name }}</td>
                     <td>{{ $agreement->agreement_code }}</td>
                     
                     @if ($asset_type->vehicle)
                        <td>{{ $asset->make }}</td>
                        <td>{{ $asset->model }}</td>
                        <td>{{ $asset->series }}</td>
                        <td>{{ $asset->register_no }}</td>
                        <td>{{ $asset->year }}</td>
                        <td>{{ $asset->VIN }}</td>
                        <td>{{ $asset->engine_no }}</td>
                        <td>{{ $asset->reqistration_no }}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($asset->amount_inclusive) !!}</td>
                     
                     @elseif ($asset_type->equipment)
                        <td>{{ $asset->make }}</td>
                        <td>{{ $asset->model }}</td>
                        <td>{{ $asset->series }}</td>
                        <td>{{ $asset->serial_no }}</td>
                        <td>{{ $asset->year }}</td>
                        <td>{{ $asset->colour }}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($asset->amount_inclusive) !!}</td>
                  
                     @elseif ($asset_type->invoice)
                        <td>{{ $agreement->assets_header->invoice_no ? $agreement->assets_header->invoice_no : $asset->invoice_no }}</td>
                        <td>{!! $agreement->assets_header->invoice_date ? DateHelper::stringifyWithTime($agreement->assets_header->invoice_date) : DateHelper::stringifyWithTime($asset->invoice_date)!!}</td>
                        <td>{{ $asset->order_no }}</td>
                        <td>{{ $asset->reference }}</td>
                        <td>{!! DateHelper::stringifyWithTime($agreement->assets_header->due_date) !!}</td></td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($asset->amount_inclusive) !!}</td>
                     
                     @elseif ($asset_type->cheque)
                        <td>{{ $asset->cheque_no }}</td>
                        <td>{!! DateHelper::stringifyWithTime($asset->cheque_date) !!}</td>
                        <td>{!! DateHelper::stringify($agreement->discount_due_date) !!}</td>
                        <td>{{ $agreement->bank_account ? $agreement->bank_account->bank_name : ''}}</td>
                        <td>{{ $agreement->bank_account ? $agreement->bank_account->account_no : '' }}</td>   
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->discount_amount - $agreement->vat_amount) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->face_value) !!}</td>
                           
                     @elseif ($asset_type->right)
                        <td>{{ $asset->right_no }}</td>
                        <td>{!! DateHelper::stringify($asset->cheque_date) !!}</td>
                        <td>{!! DateHelper::stringify($agreement->discount_due_date) !!}</td>
                        <td>{{ $agreement->bank_account->bank_name }}</td>
                        <td>{{ $agreement->bank_account->account_no }}</td>   
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->discount_amount - $agreement->vat_amount) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->face_value) !!}</td>
                           
                     @elseif ($asset_type->property)
                        <td>{{ $asset->property_erf_no }}</td>
                        <td>{{ $asset->property_suburb }}</td>
                        <td>{{ $agreement->provider->description }}</td>
                        <td>{!! DateHelper::stringifyWithTime($asset->property_transfer_date) !!}</td>
                        <td>{{ $asset->property_deed_no }}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->discount_amount - $agreement->vat_amount) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatMoney($agreement->face_value) !!}</td>
                     
                    @endif
                  </tr>  
               @endforeach
               
            @endforeach
         </tbody>
            
     </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