@extends('reports.report', ['report' => $report])

@section('content')

@if (!(isset($export) && $export))
<style type="text/css" media="all">
    #pageCounter {
        counter-reset: pageTotal;
    }
    .width-100 {
        width: 100%;
    }  

    .width-50 {
        width: 50%;
    }

    .text-center {
        text-align: center
    }
    .text-right {
        text-align: right
    }
    .summary-debtor {
        padding-top:10px; 
        page-break-inside:avoid;
    }
</style>
@endif

@foreach ($statements as $statement)
    
    <div @unless ($statement == end($statements)) class="page-break-after" @endunless>
  
        <hr>
        
        <div>
            @include('reports.company_details')
        </div>
      
        <hr class="dashed-light">

        <div>
            <div>
                <h4>To: {{ $statement['provider_name'] }}</h4>

                @if ($statement['debtor']['registrationID'])
                    Reg No: {{ $statement['debtor']['registrationID'] }} <br>
                @endif

                @if ($statement['debtor']['vat_registration'])
                    Vat Reg No: {{ $statement['debtor']['vat_registration'] }} <br>
                @endif

                @if ($statement['debtor']['post_address1'])
                    Postal Address: {{ $statement['debtor']['post_address1'] }} 
                    {{ $statement['debtor']['post_address2'] ? ', ' . $statement['debtor']['post_address2'] : '' }}
                    {{ $statement['debtor']['post_address3'] ? ', ' . $statement['debtor']['post_address3'] : '' }}
                    {{ $statement['debtor']['post_postalcode'] ? ' - ' . $statement['debtor']['post_postalcode'] : '' }}<br>
                @endif

                @if ($statement['debtor']['address1'])
                    Address: {{ $statement['debtor']['address1'] }} 
                    {{ $statement['debtor']['address2'] ? ', ' . $statement['debtor']['address2'] : '' }}
                    {{ $statement['debtor']['address3'] ? ', ' . $statement['debtor']['address3'] : '' }}
                    {{ $statement['debtor']['postalcode'] ? ' - ' . $statement['debtor']['postalcode'] : '' }}<br>
                @endif
                
                @if ($statement['debtor']['work_phone'])
                    Tel: {{ $statement['debtor']['work_phone'] }} <br>
                @endif     

                @if ($statement['debtor']['fax'])
                    Fax: {{ $statement['debtor']['fax'] }} <br>
                @endif

                @if ($statement['debtor']['email'])
                    Email: {{ $statement['debtor']['email'] }} <br>
                @endif

                @if ($statement['debtor']['url'])
                    Web: {{ $statement['debtor']['url'] }} <br>
                @endif 
            </div>
        </div>
        
        <hr class="dashed-light">
            
        <div class="text-center">
            <h4>{{ $statement['provider_name'] . ' Debtor Statement of Account' }}</h4>
            <h4>{{ 'For Supplier: ' . $statement['client_name'] }}</h4>
            <br />
            Statement range: {!! date('j F Y', strtotime($report->start_date)) !!} - {!! date('j F Y', strtotime($report->end_date)) !!}
            <br />
            Statement as at date: {!! date('j F Y', strtotime($report->as_at_date)) !!}
            <br />
        </div>
            
        <hr class="dashed-light">
            
        <div>

            <table class="width-100">
                <tr>
                    <td class="width-50">
                        <table>
                            <tr><td>Debtor Code : </td><td>{{ $statement['provider_code'] }}</td></tr>
                            <tr><td>Agreement Type : </td><td>{{ $statement['agreement_type'] }}</td></tr>
                            <tr><td>Cut off date : </td><td>{{ $statement['cut_off_day'] }}</td></tr>    
                        </table>
                    </td>
                        
                    <td class="width-50">
                        <table>
                            <tr><td>Terms : </td><td>{{ ucfirst($statement['ptm_description']) }}</td></tr>
                            <tr><td>Invoice bought : </td><td class="text-right">{!! DisplayHelper::formatCurrency($statement['invoice_bought']) !!}</td></tr>
                            <tr><td>Balance o/s : </td><td class="text-right">{!! DisplayHelper::formatCurrency($statement['balance_os']) !!}</td></tr>   
                        </table>
                    </td>
       
            </table>
        </div>
                
        <hr>

        <table class = "table table-bordered">
        <thead>
            <tr>
                <th>Agreement #</th>
                <th>Invoice Date</th>
                <th>Description</th>
                <th>Due on</th>
                <th>Inv #</th>
                <th>Ref #</th>
                <th>Comment</th>
                <th class="text-right">Inv Amount VAT incl (DR)</th>
                <th class="text-right">CR</th>
                <th class="text-right">Balance</th>
                <th class="text-right">Total Due</th>
            </tr>
        </thead>
        <tbody>

        @php
            $openning_balance = $statement['opening_balance'] ;
        @endphp

        <tr>
            <td></td>
            <td></td>
            <td>Opening Balance</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
            <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
        </tr>

        @foreach ($statement['agreements'] as $agreement)
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right"></td>
                <td class="text-right"></td>
            </tr>
            <tr>
                <td></td>
                <td></td>
                <td>Opening Balance</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right">{!! DisplayHelper::formatCurrency(0.00) !!}</td>
                <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
            </tr>

            @php
                $balance = 0.00;
            @endphp

            @foreach ($agreement as $trans)

                @php
                    $balance += $trans['amount'];
                @endphp

                <tr>
                    <td>{{ $trans['code'] }}</td>
                    <td>{!! date('d/m/Y', strtotime($trans['invoice_date'])) !!}</td>
                    <td>{{ $trans['description'] }}</td>
                    <td>{!! $trans['due_on'] ? date('d/m/Y', strtotime($trans['due_on'])) : '' !!}</td>
                    <td>{{ $trans['invoice_no'] }}</td>
                    <td>{{ $trans['reference_no'] }}</td>
                    <td>{{ $trans['comment'] }}</td>
                    <td>{!! $trans['amount'] >= 0 ?  DisplayHelper::formatCurrency($trans['amount']) : "" !!}</td>
                    <td>{!! $trans['amount'] < 0 ?  DisplayHelper::formatCurrency($trans['amount']) : "" !!}</td>
                    <td class="text-right">{!! DisplayHelper::formatCurrency($balance) !!}</td>
                    <td></td>
                </tr>
            @endforeach
            @php
                $openning_balance += $balance;
            @endphp

            <tr>
                <td></td>
                <td></td>
                <td>Closing Balance</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right">{!! DisplayHelper::formatCurrency($balance) !!}</td>
                <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
            </tr>
        
        @endforeach
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right"></td>
                <td class="text-right"></td>
            </tr>
            <tr>
                <td></td>
                <td></td>
                <td>Closing Balance</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
                <td class="text-right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
            </tr>
        </tbody>
        </table>
        <table>
            <tr>
                <td>Future dated invoices bought</td>
                <td> : </td>
                <td>{!! App\Helpers\DisplayHelper::formatCurrency($statement['future_invoice']) !!}</td>
            </tr>
            <tr>
                <td>Total exposure for debtor for the supplier</td>
                <td> : </td>
                <td>{!! App\Helpers\DisplayHelper::formatCurrency($statement['future_invoice'] + $openning_balance) !!}</td>
            </tr>
        </table>
    </div>

    <div class="summary-debtor">
            <table class="table">
                <tr>
                    <td></td>
                    <td class="text-right" class="border-tb-light">Total</td>
                </tr>
                
                @foreach ($statement['final_periods'] as $period)

                    <tr>
                        <td>{{ $period['desc'] }}</td>
                        <td class="text-right">{!! App\Helpers\DisplayHelper::formatCurrency($period['amount']) !!}</td>
                    </tr>
                @endforeach
                
                <tr>
                    <td class="border-tb-light">TOTAL DUE IMMEDIATELY</td>
                    <td class="text-right border-tb-light">{!! App\Helpers\DisplayHelper::formatCurrency($statement['total_due']) !!}</td>
                </tr>
            </table>     
        </div>      
    </div>
@endforeach

<script type="text/php">

    if ( isset($pdf) ) {
        $x = 72;
        $y = 18;
        $text = "{PAGE_NUM} of {PAGE_COUNT}";
        $font = $fontMetrics->get_font("Arial", "bold");
        $size = 6;
        $color = array(0,0,0);
        $word_space = 0.0;  //  default
        $char_space = 0.0;  //  default
        $angle = 0.0;   //  default
        $pdf->page_text($x, $y, $text, $font, $size, $color, $word_space, $char_space, $angle);
    }

</script>
@stop