@extends('layouts.pdf')
@section('title')
    {{ $extra['module_name']  }}
@endsection
@section('content')
    
     <table>
            <tr>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <td style="font-size: 20px!important;text-align: center;">
                    {{ config('settings.company_name')}}
                </td>
            </tr>
            <tr> 
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <td style="text-align: center;" colspan="3">
                    {{ config('settings.address_1')}}, {{ config('settings.address_2')}}, {{ config('settings.city')}}
                </td>
            </tr>
           
        </table>

           <table>

            <tr>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <td colspan="3" style="font-size: 20px!important;text-align: center;">
                    {{$heading}}
                </td>
            </tr>
            <tr> 
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <td style="text-align: center;" colspan="3">
                   
                @if($search_by['from'] && $search_by['to'])

                        <b>From:</b> {{ $transaction->date_format($search_by['from']) }} 
                        <b>To:</b> {{ $transaction->date_format($search_by['to']) }}
                @else
  
                     <b>{{ 'Upto ' .$transaction->date_format(now()) }} </b>
                
                @endif
                    
                </td>
            </tr>
           
        </table>
   
        
        <table class="table  table-bordered table-hover"  style="font-size: 12px;">
            <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="15" >Installment Due Report</th>
            </tr>
            <tr>
                <th scope="col" >S. NO.</th>
                <th scope="col" >PROJECT</th>
                <th scope="col" >JAN</th>
                <th scope="col" >FEB</th>
                <th scope="col" >MAR</th>
                <th scope="col" >APR</th>
                <th scope="col" >MAY</th>
                <th scope="col" >JUN</th>
                <th scope="col" >JUL</th>
                <th scope="col" >AUG</th>
                <th scope="col" >SEP</th>
                <th scope="col" >OCT</th>
                <th scope="col" >NOV</th>
                <th scope="col" >DEC</th>
                <th scope="col" >TOTAL </th>
            </tr>
            </thead>
            <tbody>
                <tr>
                    @php
                        
                        $old_project='';
                        $total_count = 0;
                        $total_amount = 0;
                    @endphp

               @for ($i=1; $i <= 13 ; $i++)
                    @if ($i ==1)
                        <td> {{ $i }}</td>
                    @endif
                    @foreach ($installments as $key => $value)

                        @if ($old_project== NULL)
                            @php
                                $old_project = $key;
                            @endphp
                            <td>{{ $old_project }}</td>

                        @elseif($old_project != $key)
                            @php
                                $old_project = $key;
                            @endphp
                            <td>{{ $old_project }}</td>
                        @endif
                        @if (isset($value[$i]))
                            @php
                                $total_count  += $value[$i]['month'];
                                $total_amount += $value[$i]['total_amount'];
                            @endphp

                            <td>{{ $value[$i]['month'] }} / {{$value[$i]['total_amount']}}</td>
                        @elseif($i==13)
                            <td>{{ $total_count }} / {{ $total_amount }}</td>

                        @else
                            <td>0 / 0</td>
                        @endif

                        @php
                            $old_project = $key;
                        @endphp
                    @endforeach
               @endfor
            </tr>
            </tbody>
        </table>
       
@stop