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

</table>

<table>

    <tr>
        
        <th>{{ $extra['branch'] ? $extra['branch']->name : 'All Projects' }}</th>
        <td colspan="1" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
        <td>
            @if ($search_by['from'] && $search_by['to'])
                <b>{{__('lang.from')}}:</b> {{ $transaction->date_format($search_by['from']) }}
                <b>{{__('lang.to')}}:</b> {{ $transaction->date_format($search_by['to']) }}
            @else
                <b>{{ 'Upto ' . $transaction->date_format(now()) }} </b>
            @endif
        </td>
    </tr>
</table>
{{-- Excel title format end --}}
@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>