@extends('layouts.pdf')

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

    <style type="text/css" media="all">
        div[size="A4"]{
            font-family: Verdana,Geneva,sans-serif !important;
            line-height:18px
        }
        h5,h6,p{
            font-family: Verdana,Geneva,sans-serif;
        }
        table td, table th,h6,p{
            font-size: 11px !important;
        }
        h5{
            font-size:12px !important;
            font-weight: 600;
        }
        .table td{
            border-top:0px;
        }
        table th,table td{
            padding:5px !important;
        }

        .table-sm  td{
            padding:0px !important;
        }
        body {
            font-size: 1rem;
        }
        table{
            font-size: 1rem;
        }
        .table th
        {
            background: #000 !important;
        }
    </style>

    <script type="text/php">
        if (isset($pdf)) {
            $x = 400;
            $y = 10;
            $text = "Page {PAGE_NUM} of {PAGE_COUNT}";
            $font = null;
            $size = 8;
            $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>

    <div size="A4" @if($action=='Show') style="margin: 30px 50px auto;" @endif >
        @include('admin.partials.header', ['extra' => $extra])

        <table class="table table-bordered">
            <thead>                    
                <tr class="fixed_tr">
                    <th>{{__('lang.sno')}}</th>
                    <th>{{__('lang.registration_no')}}</th>
                    <th>{{__('lang.unit_no')}}</th>
                    <th>{{__('lang.dealer')}}</th>
                    <th width="14%">{{__('lang.customer')}}</th>
                    <th>{{__('lang.status')}}</th>
                    <th width="10%">{{__('lang.sale_date')}}</th>
                    <th class="text-right">{{__('lang.sale_amount')}}</th>
                    <th class="text-right">{{__('lang.received')}}</th>
                    <th class="text-right">{{__('lang.balance')}}</th>
                    <th >{{__('lang.received_percentage')}}</th>
                    <th class="text-right">{{__('lang.last_payment_date')}}</th>
                    <th class="text-right">{{__('lang.last_paid_amount')}}</th>
                    @foreach ($months as $month)
                        <th class="text-right">{{ date('M-Y', strtotime($month)) }}</th>
                    @endforeach
                    <th class="text-right">{{__('lang.till_month_due')}}</th>
                </tr>
            </thead>
            <tbody>


                @php
                    $total_sale_amount      = 0; 
                    $total_balance_amount   = 0;
                    $total_received_amount  = 0;
                    $total_due_amount       = 0;
                    $total_last_paid_amount  = 0;

                    $total_month_amount = [];
                @endphp

                @foreach ($sells as $sell )
                <tr>
                    @php
                        $schedules              = $sell->ScheduleReceivableWithoutDiscount;
                        $till_month_schedules   = $sell->all_till_month_due;

                        $last_receipt           = $sell->lastActualReceivedByDate();
                        $last_payment_amount    = $last_receipt ? $last_receipt->actualReceivedItem->sum('received_amount') : 0;
                        $last_payment_date      = $last_receipt->date_of_collection_new;

                        $sale_amount            = $schedules->sum('payable_amount') + $schedules->sum('unofficial_payable_amount'); 
                        $received_amount        = $schedules->sum('payment_received_amount') + $schedules->sum('unofficial_payment_received_amount');
                        $balance_amount         = $sale_amount - $received_amount;
                        $received_amt_per       = $sale_amount ? ($received_amount * 100) / $sale_amount : 0;

                        $till_month_received_amount = $till_month_schedules->sum('payment_received_amount') + $till_month_schedules->sum('unofficial_payment_received_amount');
                        $till_month_due_amount      = $till_month_schedules->sum('payable_amount') - $till_month_received_amount;


                        $total_sale_amount      += $sale_amount; 
                        $total_balance_amount   += $balance_amount;
                        $total_received_amount  += $received_amount;
                        $total_due_amount       += $till_month_due_amount;
                        $total_last_paid_amount += $last_payment_amount;

                    @endphp

                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $sell->registration_no }}</td>
                    <td>{{ $sell->product->product_unique_id }}</td>
                    <td>{!! $sell->dealers->implode('DealerName.name', ',<br>') !!}</td>
                    <td>{{ $sell->customer->name }}</td>
                    <td>{{ $sell->status }}</td>
                    <td>{{ $transaction->date_format($sell->sale_date_v2) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sale_amount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($received_amount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($balance_amount) }}</td>
                    <td>{{ round( $received_amt_per, 2 ) }}</td>
                    <td>{{ $transaction->date_format($last_payment_date) ?? '-' }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($last_payment_amount) }}</td>
                    
                    
                    @foreach ($months as $month)
                    
                        @php
                            $schedule_receivable_month = $sell->getScheduleReceivableByMonth($month);

                            $month_payable      = $schedule_receivable_month->sum('payable_amount') + $schedule_receivable_month->sum('unofficial_payable_amount');
                            $total_month_amount[$loop->iteration] += $month_payable; 

                        @endphp
                        
                        <td class="text-right">{{ $transaction->convert_money_format($month_payable) }}</td>
                    
                    @endforeach
                    
                    
                    <td class="text-right">{{ $transaction->convert_money_format($till_month_due_amount) }}</td>
                </tr>
                @endforeach


                <tr>
                    <th colspan="7" class="text-right">{{__('lang.total')}}</th>
                    <th class="text-right">{{ $transaction->convert_money_format($total_sale_amount) }}</th>
                    <th class="text-right">{{ $transaction->convert_money_format($total_balance_amount) }}</th>
                    <th class="text-right">{{ $transaction->convert_money_format($total_received_amount) }}</th>
                    <th></th>
                    <th></th>
                    <th class="text-right">{{ $transaction->convert_money_format($total_last_paid_amount) }}</th>

                    @foreach ($total_month_amount as $amount)
                        <th class="text-right">{{ $transaction->convert_money_format($amount) }}</th>
                    @endforeach

                    <th class="text-right">{{ $transaction->convert_money_format($total_due_amount) }}</th>
                </tr>

            </tbody>
        </table>
    </div>

@stop