@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;
            margin: 30px 50px auto;
            width: fit-content;
        }

        h5,
        h6,
        p {
            font-family: Verdana, Geneva, sans-serif;
        }

        body,
        table {
            font-size: 1rem;
        }

        table td,
        table th,
        h6,
        p {
            font-size: 10px !important;
        }

        table td {
            border-top: 0px;
        }

        table th,
        table td {
            padding: 5px !important;
        }

        .table-sm td {
            padding: 0px !important;
        }

        table th {
            background: #000 !important;
        }

        h5 {
            font-size: 12px !important;
            font-weight: 600;
        }

        .g-total {
            font-size: 12px !important;
        }
        .gray{
            background: rgb(207, 204, 204) !important;
        }
        .font-bold{
            font-weight: bold;
        }
        .font-12{
            font-size: 12px !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 @if($action == 'Show') size="A4" @endif>
        <div @if($action == 'Show') class="container-fluid" @endif>

            @include('admin.partials.header', ['extra' => $extra])

            @php 
                $total_sell_amount                  = 0;
                $total_till_month_payable_amount    = 0;
                $total_till_month_balance_amount    = 0;
                $total_collection_official          = 0;
                $total_collection_unofficial        = 0;
                $total_collection                   = 0;
                $total_balance                      = 0;
            @endphp 

            <table class="table  table-bordered" style="border-top: 0px !important">
                <thead>
                    <tr class= "fixed_tr">
                        <th class = "text-center">{{__('lang.sno')}}</th>
                        <th>{{__('lang.project')}}</th>
                        <th>{{__('lang.registration_no')}}</th>
                        <th >{{__('lang.sale_date')}}</th>
                        <th>{{__('lang.customer_name')}}</th>
                        <th>{{__('lang.customer_contact')}}</th>
                        <th>{{__('lang.dealer_name')}}</th>
                        <th>{{__('lang.area')}}</th>
                        <th class = "text-right">{{__('lang.rate')}}</th>
                        <th class = "text-right">{{__('lang.sale_amount')}}</th>
                        <th class = "text-right">{{__('lang.last_received_date')}}</th>
                        <th class = "text-right">{{__('lang.last_received_amount')}}</th>
                        <th class = "text-right">{{__('lang.demand')}}</th>
                        <th class = "text-right">{{__('lang.received_amount_official')}}</th>
                        <th class = "text-right">{{__('lang.received_amount_unofficial')}}</th>
                        <th class = "text-right">{{__('lang.total_collection')}}</th>
                        <th class = "text-right">{{__('lang.total_collection_percentage')}}</th>
                        <th class = "text-right">{{__('lang.demand_balance')}}</th>
                        <th class = "text-right">{{__('lang.total_balance_lowercase')}}</th>
                        <th class = "text-right">{{__('lang.due_terms')}}</th>
                        <th class = "text-center">{{__('lang.status')}}</th>
                    </tr>
                </thead>
                <tbody>

                    @foreach ($sells as $sell )
                        @php

                            $customer                       = $sell->customer;
                            $product                        = $sell->product;
                            $rate                           = $product->rate_per_size + $product->rate_per_size_unofficial;

                            $sell_schedules                 = $sell->ScheduleReceivableWithoutDiscount;

                            $till_month_due_schedules       = $sell->all_till_month_due;
                            $till_month_payable_amount      = $till_month_due_schedules->sum('payable_amount') + $till_month_due_schedules->sum('unofficial_payable_amount') ;
                            $till_month_received_amount     = $till_month_due_schedules->sum('payment_received_amount') + $till_month_due_schedules->sum('unofficial_payment_received_amount') ;
                            $till_month_balance_amount      = $till_month_payable_amount - $till_month_received_amount;
                            $due_terms_count                = $sell->till_month_due->count();


                            $dealer_name                    = $sell->dealers->implode('DealerName.name', ' , ') ?? '-';
                            $sell_amount                    = $sell_schedules->sum('payable_amount');
                            $collection_amount_official     = $received_amounts[$sell->id]['official'] ?? 0;
                            $collection_amount_unofficial   = $received_amounts[$sell->id]['unofficial'] ?? 0;
                            $collection_amount              = $collection_amount_official + $collection_amount_unofficial;
                            $balance_amount                 = $sell_amount - $collection_amount;
                            $status                         = $sell->status;
                            $defaulter_status               = '';
                            $last_payment_data              = $sell->all_last_payment_data;
                            $last_received_amount           = $last_payment_data->last_received_amount ?? 0;
                            $last_received_date             = $last_payment_data->last_date_of_collection ?? null;
                            $collection_percent             = 0;

                            if($sell_amount){
                                $collection_percent         = $transaction->convert_money_format(($collection_amount/$sell_amount) * 100);
                            }

                            if($due_terms_count >= 3){
                                $defaulter_status = __('lang.defaulter_caps');
                            }
                            
                            $total_sell_amount                  += $sell_amount;
                            $total_till_month_payable_amount    += $till_month_payable_amount;
                            $total_till_month_balance_amount    += $till_month_balance_amount;
                            $total_collection_official          += $collection_amount_official;
                            $total_collection_unofficial        += $collection_amount_unofficial;
                            $total_collection_amount            += $collection_amount;
                            $total_balance_amount               += $balance_amount;


                            // Badges_start
                            $badge = 'badge badge-success';
                            
                            if ($sell->is_transfered || $status == 'BLOCKED') {
                                $badge = 'badge badge-danger';
                            } elseif ($status == 'REACTIVATE'|| $status == 'CANCELLATION' || $status == 'CANCELLED') {
                                $badge = 'badge badge-warning';
                            } elseif ($status == 'BUY BACK') {
                                $badge = 'badge badge-primary';
                            } elseif ($status == 'REFUNDED') {
                                $badge = 'badge badge-secondary';
                            }
                            // Badges_end

                        @endphp
                        <tr>
                            <td class = "text-center"> {{$loop->iteration}} </td>
                            <td> {{$sell->branch->name}} </td>
                            <td> 
                                <a href="{{ route('sell.edit', ['id' => $sell->id]) }}" target="_blank" >
                                    {{ $sell->registration_no }} 
                                </a>
                            </td>
                            <td> {{ $transaction->date_format($sell->sale_date_v2) ?? '-'}} </td>
                            <td> {{ $customer->name}} </td>
                            <td> {{ $customer->phone ?? '-'}} </td>
                            <td> {{ $dealer_name }} </td>
                            <td> {{ $product->flat_size }} {{$product->size_in}} </td>
                            <td class = "text-right"> {{ $rate }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($sell_amount) }} </td>
                            <td class = "text-right"> {{ $transaction->date_format($last_received_date) ?? '-' }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($last_received_amount) }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($till_month_payable_amount ) }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($collection_amount_official) }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($collection_amount_unofficial) }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($collection_amount) }} </td>
                            <td class = "text-right"> {{ $collection_percent }} %</td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($till_month_balance_amount) }} </td>
                            <td class = "text-right"> {{ $transaction->convert_money_format($balance_amount) }} </td>
                            <td class = "text-right"> {{ $due_terms_count }} </td>
                            <td class = "text-center"> 
                                <span class="{{$badge}} font-12" >
                                    {{$status}}
                                </span>

                                @if($defaulter_status == 'DEFAULTER')
                                    <br> <br>
                                    <span class ='badge badge-danger font-12'>{{ $defaulter_status }}</span>
                                @endif
                            </td>
                        </tr>
                    @endforeach

                    <tr>
                        <th colspan="9" class = "text-right">{{__('lang.total')}}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_sell_amount) }}</th>
                        <th></th>
                        <th></th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_till_month_payable_amount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_collection_official) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_collection_unofficial) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_collection) }}</th>
                        <th></th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_till_month_balance_amount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($total_balance) }}</th>
                        <th></th>
                        <th></th>
                        
                    </tr>
                </tbody>
            </table>    
        </div>
    </div>
@stop