@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>
 
@foreach ($client_debtors as $client_debtor)
    <div @unless ($client_debtor == end($client_debtors)) class="page-break-after" @endunless>
  
        <hr>
        
        <div style="padding-bottom:10px:">
            @include('reports.company_details')
        </div>
      
        <hr class="dashed-light">
        
        <div style="text-align:center; padding-bottom:10px;">
            <h4>Debtor Statement of Account</h4>
            as at {!! $report->as_at_date->format('j F Y') !!} <br>
            Period: {!! DisplayHelper::formatDate($report->start_date) !!} - {!! DisplayHelper::formatDate($report->as_at_date) !!}
        </div>
         
        <hr class="dashed-light">
            
        <div style="padding-bottom:2px;">
          
            <div>
                <h4>{{ $client_debtor->debtor_name}} </h4>
                {{ $client_debtor->post_address1 }} <br>
                {{ $client_debtor->post_address2 }} <br>
                {{ $client_debtor->post_address3 }} <br>
                {{ $client_debtor->post_postalcode }}      
            </div>
        </div>
            
        <hr class="dashed-light">
            
        <div>

            <table style="width:100%">
                <tr>
                    <td style="width:50%">
                        <table>
                            <tr><td>Debtor Code : </td><td>{{ $client_debtor->debtor_code }}</td></tr>
                            <tr><td>Agreement Type : </td><td>{{ $client_debtor->agreement_type }}</td></tr>
                            <tr><td>Cut off date : </td><td>{{ $client_debtor->cut_off_day }}</td></tr>    
                        </table>
                    </td>
                        
                    <td style="width:50%">
                        <table>
                            <tr><td>Terms : </td><td>{{ ucfirst($client_debtor->payment_terms) }}</td></tr>
                            <tr><td>Invoice bought : </td><td style="text-align:right">{!! DisplayHelper::formatCurrency($client_debtor->invoice_bought_amount) !!}</td></tr>
                            <tr><td>Balance o/s : </td><td style="text-align:right">{!! DisplayHelper::formatCurrency($client_debtor->balance_outstanding) !!}</td></tr>   
                        </table>
                    </td>
       
            </table>
        </div>
                
        <hr>
        
        @foreach ($client_debtor->periods as $period)
        {{ $period['description'] }} : {!! DateHelper::stringifyWithTime($period['end_date']) !!}
        
        <table class = "table table-bordered">
            <thead>
                <tr>
                    <th>Inv/trans date</th>
                    <th>Confirm date</th>
                    <th>Supplier</th>
                    <th>Inv #</th>
                    <th>Transaction</th>
                    <th>Due date</th>
                    <th style="text-align:right">Inv/trans amount</th>
                    <th style="text-align:right">Total</th>
                </tr>
            </thead>
            
            <tbody>
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td>Opening balance</td>
                    <td></td>
                    <td></td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($period['open_balance']) !!}</td>
                </tr>
            
                
                @foreach ($period['line_items'] as $line_item) 
                    <tr>
                        <td>{!! DateHelper::stringifyWithTime($line_item['effective_date']) !!}</td>
                        <td>{!! DateHelper::stringifyWithTime($line_item['confirm_date']) !!}</td>
                        <td>{{ $line_item['supplier'] }}</td>
                        <td>{{ $line_item['invoice_no'] }}</td>
                        <td>{{ $line_item['description'] }}</td>
                        <td>{!! DateHelper::stringifyWithTime($line_item['due_date']) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatCurrency($line_item['amount']) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatCurrency($line_item['balance_os']) !!}</td>
                    </tr>
                @endforeach
 
            </tbody
        </table>
        @endforeach        
                
        <div style="padding-top:10px; page-break-inside:avoid;">
            <table class="table">
                <tr>
                    <td></td>
                    <td style="text-align:right" class="border-tb-light">Total</td>
                </tr>
                
                @foreach ($client_debtor->periods as $period)
                <tr>
                    <td>{{$period['summary_description']}} : {!! DateHelper::stringifyWithTime($period['end_date']) !!}</td>
                    <td style="text-align:right">{!! App\Helpers\DisplayHelper::formatCurrency($period['due']) !!}</td>
                </tr>
                @endforeach
                
                <tr>
                    <td class="border-tb-light">TOTAL DUE IMMEDIATELY</td>
                    <td style="text-align:right" class="border-tb-light">{!! App\Helpers\DisplayHelper::formatCurrency($client_debtor->now_due) !!}</td>
                </tr>
            </table>     
        </div>      
    </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