@extends('layouts.pdf')

@section('title')
    {{ $extra['module_name']  }}
@endsection
@section('content')

    
<table>
    <tr>
        <th></th>
        <th></th>
        <td style="font-size: 20px!important;text-align: center;"  colspan="12">
            {{ config('settings.company_name')}}
        </td>
    </tr>
    <tr> 
        <th></th>
        <th></th>
        <th></th>

        
        <td style="text-align: center;" colspan="10">
            {{ config('settings.address_1')}}, {{ config('settings.address_2')}}, {{ config('settings.city')}}
            </td>
    </tr>
   
</table>

   <table>

    <tr>
        <th></th>
        <th></th>
        <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>
        <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>

          
       
        @php 
            $total_payable_amount= 0;
            $total_received_amount = 0;
            $total_balance_amount= 0;
        @endphp
        
        @if( !empty($infos) )
            @foreach($infos as $item )
                    @php  
                    $total_payable_amount+=$item->payable_amount;
                    $total_received_amount+=$item->total_received;
                    $total_balance_amount+=$item->balance;
                    $internal+=$item->internal_rebate;
                    $external+=$item->external_rebate;
                    $net_sale_amount = ($total_payable_amount - $total_internal_rebate - $total_external_rebate);
                    @endphp
            @endforeach
        @endif
        <hr>   
            <table>
                <tbody>
                    <tr>
                        <td></td>
                        <td colspan="3">Total Receivable Customer:</td>
                        <td  id='receivable_amount'>{{$transaction->convert_money_format($total_payable_amount)}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td colspan="3">Total Paid Amount: </td>
                        <td id='paid_amount'>{{$transaction->convert_money_format($total_received_amount)}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td colspan="3">Total Receivable:</td>
                        <td id='balance_amount' >{{$transaction->convert_money_format($total_balance_amount)}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td colspan="3">Total Internal Rebate:</td>
                        <td id='internal'>{{$transaction->convert_money_format($internal)}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td colspan="3"> Total External Rebate: </td>
                        <td id='external'>{{$transaction->convert_money_format($external)}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td colspan="3">Net Sale Amount:  </td>
                        <td id='net_sale_amount'>{{$transaction->convert_money_format($net_sale_amount)}}</td>
                    </tr>
                </tbody>
            </table>
            <table>
                <tbody>
                    @if ($params['block'] != '0' )
                        <tr>
                            <td style="width:30%"> <strong>Block</strong> <span class="float-right">: </span> </td>
                            <td>{{ $params['block'] }}</td>
                        </tr>
                    @endif
                    @if ($params['floor_number'] != '0' )
                        <tr>
                            <td style="width:20%"><strong>Floor</strong> <span class="float-right">: </span> </td>
                            <td>{{ $params['floor_number'] }}</td>
                        </tr>
                    @endif
                    @if ($params['product_type'] != '0' )
                        <tr>
                            <td style="width:20%"><strong>{{__('lang.type')}}</strong> <span class="float-right">: </span> </td>
                            <td>{{App\Models\ProductType::find($params['product_type'])->name}}</td>
                        </tr>
                    @endif
                </tbody>
            </table>


        <hr>
      
        <table  style="display: inline-block!important;">
            <thead>
                <tr>
                    <th colspan="12">{{ $search_by['branch'] == 0 ? 'ALL PROJECT' : App\Models\Branch::where('id', $search_by['branch'] )->first()->name }}</th>
                </tr>
                <tr>
                    <th scope="col">S. No.</th>
                    <th></th>
                    <th scope="col">Registration No</th>
                    <th></th>
                    <th scope="col">Unit No</th>
                    <th></th>
                    <th scope="col">Customer</th>
                    <th></th>
                    <th scope="col" >{{__('lang.phone')}}</th>
                    <th></th>
                    <th scope="col">Last Paid Amount {{$transaction->systemSettingCurrency()}}</th>
                    <th></th>
                    <th scope="col">Last Paid Date</th>
                    <th></th>
                    <th scope="col">Total Sell {{$transaction->systemSettingCurrency()}}</th>
                    <th></th>
                    <th scope="col">Total Paid Amount {{$transaction->systemSettingCurrency()}}</th>
                    <th></th>
                    <th scope="col">Total Balance Amount {{$transaction->systemSettingCurrency()}}</th>
                    <th></th>
                    <th scope="col">Upcoming Payment</th>
                    <th></th>
                    <th scope="col">Upcoming Payment Date</th>
                </tr>
            </thead>
            <tbody>
                
                @php 

                   $counter = 1;
                   $total_payable_amount= 0;
                   $total_received_amount = 0;
                   $total_balance_amount= 0;

                
                @endphp
                
                @if( !empty($infos) )
                    @foreach( $infos as $item )
                        @php
                            $query = App\Models\ScheduleReceivable::WHERE('sells_id',$item->sells_id)->where('already_received',true)->orderBy('id', 'asc')->first();
                            
                            $checkActualReceived = App\Models\ActualReceived::where('sells_id',$item->sells_id)->orderBy('created_at', 'desc')->first();
                            if($checkActualReceived)
                            {
                                $upcoming_id = App\Models\ActualReceivedItem::where('sells_id',$item->sells_id)->orderBy('created_at', 'desc')->first()->schedule_receivable_id;
                                $last_payment = $checkActualReceived->actual_amount;
                                $last_payment_date =  $checkActualReceived->date_of_collection;
                                $last_payment_date =  $last_payment_date ? date(Config('settings.date_format'),strtotime(trim(str_replace('/', '-', $last_payment_date)))) : '-';
                            }
                            else
                            {
                                $upcoming_id = $query->id;
                                $last_payment = $query->already_received_amount;
                                $last_payment_date =  $query->already_received_date;                           
                                $last_payment_date =  $last_payment_date ? date(Config('settings.date_format'),strtotime(trim(str_replace('/', '-', $last_payment_date)))) : '-';                      
                            }

                            $upcomingQuery = App\Models\ScheduleReceivable::leftJOIN('actual_received_items as ari','ari.schedule_receivable_id','=','schedule_receivables.id')
                            ->WHERE('schedule_receivables.id',$upcoming_id+7)->first();
                            // if(empty($upcomingQuery))
                            // {
                            //     $upcomingQuery = App\Models\ScheduleReceivable::leftJOIN('actual_received_items as ari','ari.schedule_receivable_id','=','schedule_receivables.id')
                            //     ->WHERE('schedule_receivables.id',$upcoming_id+7)->first();
                            // }
                            
                            $upcoming_payment = $upcomingQuery->payable_amount - ($upcomingQuery->already_received_amount + $upcomingQuery->received_amount);
                            if($upcoming_payment == 0){
                                $upcomingQuery = App\Models\ScheduleReceivable::leftJOIN('actual_received_items as ari','ari.schedule_receivable_id','=','schedule_receivables.id')
                            ->WHERE('schedule_receivables.id',$upcoming_id+2)->first();
                            }
                            if(!$upcomingQuery){
                                $upcomingQuery = App\Models\ScheduleReceivable::WHERE('sells_id',$item->sells_id)->first();                               
                            }
                            $upcoming_payment = $upcomingQuery->payable_amount - ($upcomingQuery->already_received_amount + $upcomingQuery->received_amount);
                            $upcoming_payment_date = date(Config('settings.date_format'),strtotime(trim(str_replace('/', '-', $upcomingQuery->schedule_date))));                          
                        @endphp
                        <tr>
                            <td>{{$loop->iteration}}</td>
                            <td></td>
                            <td>{{$item->registration_no}}</td>
                            <td></td>
                            <td>{{$item->product_id}}</td>
                            <td></td>
                            <td>{{$item->customer_name}}</td>
                            <td></td>
                            <td>{{$item->customer_phone}}</td>
                            <td></td>
                            <td>{{ $transaction->convert_money_format( $last_payment ) }}</td>
                            <td></td>
                            <td>{{ App\Models\Common::checkInvalidDate($last_payment_date) }}</td>
                            <td></td>
                            <td>{{ $transaction->convert_money_format( $item->payable_amount ) }}</td>
                            <td></td>
                            <td>{{$transaction->convert_money_format($item->total_received)}}</td>
                            <td></td>
                            <td>{{$transaction->convert_money_format($item->balance)}}</td>
                            <td></td>
                            <td>{{$item->payable_amount == $item->total_received ? "0.00" : $transaction->convert_money_format($upcoming_payment)}}</td>
                            <td></td>
                            <td>{{ $item->payable_amount == $item->total_received ? "-" : App\Models\Common::checkInvalidDate($upcoming_payment_date)}}</td>
                        </tr>
                          
                         @php  
                         $total_payable_amount+=$item->payable_amount;
                         $total_received_amount+=$item->total_received;
                         $total_balance_amount+=$item->balance;
                         @endphp
                    
                    @endforeach
                @endif

                <tr class="font-w-b">
                    <th class="text-right" colspan="7">Total</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th>{{$transaction->convert_money_format($total_payable_amount)}}</th>
                    <th></th>
                    

                    <th>{{$transaction->convert_money_format($total_received_amount)}}</th>
                    <th></th>
                    <th>{{$transaction->convert_money_format($total_balance_amount)}}</th>
                    <th></th>
                </tr>
            
            </tbody>
        </table>
        <hr>
    
@stop