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

<table id="tbl_exporttable_to_xls">
    <tr><td>
    @if (!$report->pdf)
    <table>
        <tr><td colspan="13"><h3>{{ $report->company_name }}</h3></td></tr>
        <tr><td colspan="13"><h3>{{ $report->description }}</h3></td></tr>
        <tr><td colspan="13">Agreement Range: {{ $report->start_agreement_code }} - {{ $report->end_agreement_code }}<br><br></td></tr>
        <tr><td colspan="13">Client Type: {{ $report->client_type }}</td></tr>
        <tr><td colspan="13">Clients: {{ $report->clients }}</td></tr>
        <tr><td colspan="13">Agreement Type: {{ $report->agreement_type }}</td></tr>
        <tr><td colspan="13">Agreement Status: {{ $report->agreement_status }}</td></tr>
        <tr><td colspan="13">Include History: {{ $report->include_history }}</td></tr>
        <tr><td colspan="13"><small>Printed at: {!! App\Helpers\DisplayHelper::formatDateTime($report->print_time) !!}</small></td></tr>
    </table>    
    @endif
    
    
    @foreach ($agreements as $agreement)
    <div @unless ($agreement == end($agreements)) class="page-break-after" @endunless>
        
        @if ($report->pdf)
        <hr>
        <h6 style="text-align:center;">{{ $report->company_name }}</h6>
        <h6 style="text-align:center;">{{ $report->description }}</h6>
        <hr>
        @endif

        @if ($report->pdf)
        <table class="table table-small-bottom-margin" style="font-size:10px;">
            <thead>
                <tr>
                    <th style="font-size:10px;">Client</th>
                    <th style="font-size:10px;">Debtor</th>
                </tr>
            </thead>
            
            <tbody>
                <tr>
                    <td width="50%">
                        <table class="table table-bordered table-small-bottom-margin">
                            <tr>
                                <td>Name:</td>
                                <td>{{ $agreement->client_name }}</td>
                            </tr>
                            <tr>
                                <td>Address:</td>
                                <td>{{ $agreement->client_address }}</td>
                            </tr>
                            <tr>
                                <td>Tel:</td>
                                <td>{{ $agreement->client_phone }}</td>
                            </tr>
                            <tr>
                                <td>Email:</td>
                                <td>{{ $agreement->client_email }}</td>
                            </tr>
                            <tr>
                                <td>Contact:</td>
                                <td>{{ $agreement->client_contact }}</td>
                            </tr>
                        </table>
                    </td>
                    <td>
                        <table class="table table-bordered table-small-bottom-margin">
                            <tr>
                                <td>Name:</td>
                                <td>{{ $agreement->provider_name }}</td>
                            </tr>
                            <tr>
                                <td>Address:</td>
                                <td>{{ $agreement->provider_address }}</td>
                            </tr>
                            <tr>
                                <td>Tel:</td>
                                <td>{{ $agreement->provider_phone }}</td>
                            </tr>
                            <tr>
                                <td>Email:</td>
                                <td>{{ $agreement->provider_email }}</td>
                            </tr>
                            <tr>
                                <td>Contact:</td>
                                <td>{{ $agreement->provider_contact }}</td>
                            </tr>
                        </table>
                    </td>
                </tr>
            </tbody>    
        </table>
            
        @else
        <table>
            <tr>
                <td colspan="6" class="strong">Client</td>
                <td colspan="7" class="strong">Debtor</td>
            </tr>
            <tr>
                <td colspan="6">Name: {{ $agreement->client_name }}</td>
                <td colspan="7">Name: {{ $agreement->provider_name }}</td>
            </tr>
            <tr>
                <td colspan="6">Address: {{ $agreement->client_address }}</td>
                <td colspan="7">Address: {{ $agreement->provider_address }}</td>        
            </tr>
            <tr>
                <td colspan="6">Tel: {{ $agreement->client_phone }}</td>
                <td colspan="7">Tel: {{ $agreement->provider_phone }}</td>        
            </tr>
            <tr>
                <td colspan="6">Email: {{ $agreement->client_email }}</td>
                <td colspan="7">Email: {{ $agreement->provider_email }}</td>        
            </tr>
            <tr>
                <td colspan="6">Contact:{{ $agreement->client_contact }}</td>
                <td colspan="7">Contact: {{ $agreement->provider_contact }}</td>        
            </tr>
        </table>
        @endif
        
    
        <table class="table table-bordered table-small-bottom-margin" style="font-size:10px;">
   
            <thead>
                <tr>
                    <th style="text-align:center; font-size:10px;">Inv #/Trip sheet</th>
                    <th style="text-align:center; font-size:10px;">Inv Date</th>
                    <th style="text-align:center; font-size:10px;">Qty</th>
                    <th style="text-align:center; font-size:10px;">Descrip</th>
                    <th style="text-align:center; font-size:10px;">Ref</th>
                    <th style="text-align:center; font-size:10px;">From</th>
                    <th style="text-align:center; font-size:10px;">To</th>
                    <th style="text-align:center; font-size:10px;">Unit price</th>
                    <th style="text-align:center; font-size:10px;">Amount (excl)</th>
                    <th style="text-align:center; font-size:10px;">Vat</th>
                    <th style="text-align:center; font-size:10px;">Amount (incl)</th>
                    <th style="font-size:10px;">Terms</th>
                    <th style="font-size:10px;">Settlement Due Date</th>
                </tr>
            </thead>

            <tbody>
                @foreach ($agreement->invoices as $invoice)
                    <tr>
                        <td>{{ $invoice->invoice_no }}</td>
                        <td>{!! DateHelper::stringifyWithTime($invoice->invoice_date) !!}</td>
                        <td style="text-align:right; font-size:10px;">{{ $invoice->quantity }}</td>
                        <td>{{ $invoice->description }}</td>
                        <td>{{ $invoice->reference }}</td>
                        <td>{{ $invoice->load_from }}</td>
                        <td>{{ $invoice->load_to }}</td>
                        <td style="text-align:right;">{!! DisplayHelper::formatCurrency($invoice->unit_price) !!}</td>
                        <td style="text-align:right;">{!! DisplayHelper::formatCurrency($invoice->amount_exclusive) !!}</td>
                        <td style="text-align:right;">{!! ($agreement->client_vat_registered + 0) ? DisplayHelper::formatCurrency($invoice->vat) : DisplayHelper::formatCurrency(0) !!}</td>
                        <td style="text-align:right;">{!! ($agreement->client_vat_registered + 0) ? DisplayHelper::formatCurrency($invoice->amount_inclusive) : DisplayHelper::formatCurrency($invoice->amount_exclusive) !!}</td>
                        <td>{{ $agreement->payment_term }}</td>
                        <td>{!! DateHelper::stringifyWithTime($agreement->due_date) !!}</td>
                    </tr>
                @endforeach
            </tbody>
                
            <tfoot>
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td style="text-align:right; font-size:10px;">{!! DisplayHelper::formatCurrency($agreement->sum_amount_exclusive) !!}</td>
                    <td style="text-align:right; font-size:10px;">{!! DisplayHelper::formatCurrency($agreement->sum_vat) !!}</td>
                    <td style="text-align:right; font-size:10px;">{!! DisplayHelper::formatCurrency($agreement->sum_amount_inclusive) !!}</td>
                    <td></td>
                    <td></td>
                </tr>   
            </tfoot>
        </table>
        
        @if (!$report->pdf)
        <table><tr><td colspan="13">
        @endif

        @if ($report->pdf)
        <hr class="no-space">
        <h6>CONDITIONS:</h6>
        @else
        <h4>CONDITIONS:</h4>
        @endif
        
        <span style="font-size:10px;">
            We have been advised by the above stated client that the following DELIVERIES and or SERVICES have been made/ rendered to you. These invoices have been factored by us and are due to be paid by you as per the settlement due date reflected above. In accordance with the factoring facility letter which has been signed by you, payment of these invoices to any other party will not be considered discharging of your debt. Payment is to be made to: <br><br>
        

            {{ $report->company_name }}<br>
            {{ $report->bank_name }}<br>
            {{ $report->bank_branch_name }}<br>
            {{ $report->bank_branch_code }}<br>
            {{ $report->bank_account_no }}

        </span>
       
        @if ($report->pdf)
            <hr>
            <h6>ACCEPTANCE CONFIRMATION AND PAYMENT UNDERTAKING:</h6>
        @else
            <h4>ACCEPTANCE CONFIRMATION AND PAYMENT UNDERTAKING:</h4>
        @endif
        
        <span style="font-size:10px;">We hereby confirm the client as detailed above has delivered the goods and or services per the invoices as detailed in this schedule. The above stated invoices together with all delivery notes and POD's have been received by us and are correct and in accordance with our order.  We further confirm that the we have received these goods/ services in good order and that they are not subject to any set off or credit notes.<br><br>
        
        We hereby undertake to pay the settlement amount on the due date detailed in this schedule.</span><br><br>
        
        @if (!$report->pdf)
            </td></tr>
        @endif
        
        @if ($report->pdf)
            <table class="table-60 table-small-bottom-margin" style="font-size:10px;">
        @endif
        
            <tr>
                <td colspan="6">Signed at:<br><br></td>
                <td colspan="7">-------------------------------------------------------------------------<br><br></td>
            </tr>
            <tr>
                <td colspan="6">On:<br><br></td>
                <td colspan="7">-------------------------------------------------------------------------<br><br></td>
            </tr>
            <tr>
                <td colspan="6">By:<br><br></td>
                <td colspan="7">-------------------------------------------------------------------------<br><br></td>
            </tr>
                
            <tr>
                <td colspan="6">Position:<br><br></td>
                <td colspan="7">-------------------------------------------------------------------------<br><br></td>
            </tr> 
            <tr>
                <td colspan="6">Signature:</td>
                <td colspan="7" style="border:1px solid;"><br><br><br><br></td>
            </tr>
            <tr>
                <td colspan="6"><br></td>
                <td colspan="7"><br></td>
            </tr>
            <tr>
                <td colspan="6">Company Stamp:</td>
                <td colspan="7" style="border:1px solid;"><br><br><br><br></td>
            </tr>
        
        @if($report->pdf)    
            </table>
        @endif
       
        
        @if (!$report->pdf)
        <tr><td colspan="13">
        @endif
    
        <span style="font-size:10px;">By signing hereto, the signatory warrants their authority to bind the company hereto.</span>
            
        @if (!$report->pdf)
        </td></tr></table>
        @endif
      
    </div>
    @endforeach    

@stop

</td></tr>
</table>

@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