@extends('reports.report', ['report' => $report])
@section('content')
 
@foreach ($client_debtors as $client_debtor)
    <style>
        #pageCounter {
            counter-reset: pageTotal;
        }
    </style>
    <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>{{ $report->title }}</h4>
            as at {!! $report->as_at_date->format('j F Y') !!} <br>
        </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>

        @if(count($client_debtor->agreements) > 0)

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

        @php
            $totalCount = 0 ;
            $openning_balance = 0.0 ;
            $cumulative_balance = 0.0;
        @endphp
        
        @foreach ($client_debtor->agreements as $key => $agreement)

                @if ($totalCount) 
                    <tr>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                    </tr>
                    
                @endif 

                    <tr>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td>{{ $client_debtor->debtor_name }}</td>
                        <td>Opening Balance</td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td style="text-align:right">{!! DisplayHelper::formatCurrency($openning_balance) !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatCurrency($cumulative_balance) !!}</td>
                    </tr>      
   
                @foreach ($agreement['line_items'] as $line_item) 
                    <tr>
                        <td>{{ $line_item['agreement_code'] }}</td>
                        <td>{!! DateHelper::stringifyWithTime($line_item['effective_date']) !!}</td>
                        <td>{{ $line_item['supplier'] }}</td>
                        <td>{{ $client_debtor->debtor_name }}</td>
                        <td>{{ $line_item['description'] }}</td>
                        <td>{!! DateHelper::stringifyWithTime($line_item['due_date']) !!}</td>
                        <td>{{ $line_item['invoice_no'] }}</td>
                        <td>{{ $line_item['reference'] }}</td>
                        <td>{{ $line_item['comment'] }}</td>
                        <td style="text-align:right">{!! $line_item['amount'] >= 0 ?  DisplayHelper::formatCurrency($line_item['amount']) : "" !!}</td>
                        <td style="text-align:right">{!! $line_item['amount'] < 0 ?  DisplayHelper::formatCurrency($line_item['amount']) : "" !!}</td>
                        <td style="text-align:right">{!! DisplayHelper::formatCurrency($line_item['balance_os']) !!}</td>
                        <td></td>
                    </tr>

                    @php
                        $closingBalance = $line_item['balance_os'];
                    @endphp

                @endforeach

                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td>{{ $client_debtor->debtor_name }}</td>
                    <td>Closing Balance</td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($closingBalance) !!}</td>
                    <td style="text-align:right">{!! DisplayHelper::formatCurrency($closingBalance + $cumulative_balance) !!}</td>
                </tr> 

                @php
                    $totalCount++;
                    $openning_balance = $closingBalance;
                    $cumulative_balance += $openning_balance;
                @endphp
        @endforeach 

        @if(count($client_debtor->periods) > 0)

            </tbody>
            </table>
        @endif       
                
        <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)

                    @php
                        $enddiffdate = DateHelper::stringifyWithTime($period['end_date']);
                        $explodediffdate = explode('/', $enddiffdate);
                        $startdate = explode('-', $report->as_at_date->format('Y-m-d'));
                        $month = $startdate[1] - $explodediffdate[1];
                    @endphp

                    <tr>
                        <td>{{$period['summary_description']}} : {!! DateHelper::stringifyWithTime($period['end_date']) !!} {{ $month ? ' ( >' . $month * 30 . ' days )' : '' }}</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>
    <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>
@endforeach
@stop