@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;
            position: relative !important;
        }

        .table th {
            background: #000 !important;
            vertical-align: middle !important;
        }

        .table th {
            position: sticky !important z-index: 1 !important;
        }

        .g-total {
            font-size: 12px !important;
        }

        .gray {
            background: rgb(207, 204, 204) !important;
        }

        .font-bold {
            font-weight: bold;
        }

        .text-center {
            text-align: center;
        }

        .width-85{
            width: 85px;
        }
        .width-90{
            width: 90px;
        }
    </style>

    {{-- <p>Printing Date & Time: {{ $extra['current_date_time']  }}</p> --}}
    <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])
        @php
            
        @endphp
         @if ($type > 0)
            @foreach ($type as $key => $item)
                @php
                    $balance = $total_received_per = $total_dues_per = $total_balance_per = $dues_total= $total_cost = $total_received_off = $total_received_un = $total_balance = $total_dues_bf_this = $total_dues_till_month = $total_dues = $total_advance = $total_received_per_all = $total_dues_per_all = $total_balance_per_all = $last_paid= 0;
                @endphp

                @if(count($sells[$item->id]) > 0)
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th scope="col" colspan="100٪" class="text-left">{{__('lang.type')}} : {{ $item->name }}</th>
                            </tr>
                            <tr>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.serial_no')}}</th>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.unit')}} #</th>
                                <th scope="col" class="text-center" style="width: 150px;">{{__('lang.customer')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.contact')}} #</th>
                                <th scope="col" class="text-center width-90">{{__('lang.booking_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.advance_receiving')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}} {{__('lang.sale')}}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th scope="col" class="text-center" colspan="2" style="width: 120px;">{{__('lang.receiving')}}</th>
                                @endif

                                <th scope="col" class="text-center width-85">{{__('lang.total_received')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance')}}</th>
                                
                                <th scope="col" class="text-center" colspan="3" style="width: 200px">{{__('lang.dues')}}</th>

                                <th scope="col" class="text-center" colspan="3" style="width: 200px">% {{__('lang.of')}}</th>
                                
                                <th scope="col" class="text-center width-90">{{__('lang.last_pay_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.last_pay')}} {{$transaction->systemSettingCurrency()}}</th>

                            </tr>
                            <tr>
                                @if(userAllowedUnofficial() == 1)
                                    <th colspan="7"></th>
                                    <th scope="col" class="text-center width-85">{{__('lang.off')}}</th>
                                    <th scope="col" class="text-center width-85">{{__('lang.un')}}</th>
                                @else
                                    <th colspan="9"></th>
                                @endif
                                <th scope="col" class="text-center width-85">{{__('lang.bf_this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}}</th>
                            
                                <th scope="col" class="text-center width-85">{{__('lang.recvd')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.dues_upper')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance_upper')}} %</th>
                                <th colspan="2"></th>
                            </tr>
                        </thead>
                        <tbody>
                            
                            
                            @foreach ($sells[$item->id] as $key => $sell)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td><a style="color: black" href="{{url('/product/edit/'. $sell['product']['id'])}}" target="_blank">{{ $sell['product']['product_unique_id'] }}</a></td>
                                    <td>{{ $sell['customer']['name'] }}</td>
                                    <td>{{ $sell['customer']['phone'] }}<br>{{ $sell['customer']['residential_phone'] }}</td>
                                    <td>{{ $transaction->date_format($sell['sale_date_v2']) }}</td>
                                    <td>{{ number_format($sell['total_advance_amount'],2) }}</td>
                                    <td>{{ number_format($sell['total_schedule_amount'],2) }}</td>


                                    @if(userAllowedUnofficial() == 1)
                                        <td>{{ number_format($sell['total_paid_off'],2) }}</td>
                                        <td>{{ number_format($sell['total_paid_un'],2) }}</td>
                                    @endif

                                    <td>{{ number_format($sell['total_paid_off'] + $sell['total_paid_un'],2) }} </td>

                                    @php
                                        $balance = $sell['total_schedule_amount'] - ($sell['total_paid_off']+$sell['total_paid_un']);

                                        $total_cost += $sell['total_schedule_amount'];

                                        $total_received_off += $sell['total_paid_off'];
                                        $total_received_un += $sell['total_paid_un'];

                                        $total_balance += $balance;


                                    @endphp

                                    <td>{{ number_format($balance,2) }}</td>
                                    <td>{{ isset($sell['total_till_month_due_before_this_period']) ? number_format($sell['total_till_month_due_before_this_period'],2) : 0 }}</td>
                                    <td>{{ number_format($sell['total_till_month_due'],2) }}</td>
                                    @php

                                        $dues_total = $sell['total_till_month_due'] + $sell['total_till_month_due_before_this_period'] ?? 0;


                                        $total_dues_bf_this += $sell['total_till_month_due_before_this_period'] ?? 0;

                                        $total_dues_till_month += $sell['total_till_month_due'];

                                        $total_dues += $dues_total;



                                    @endphp
                                    <td>{{ number_format($dues_total, 2) }}</td>

                                    


                                    @php

                                        $total_received_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($sell['total_paid_off']+$sell['total_paid_un'])/$sell['total_schedule_amount'])*100);

                                        $total_dues_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($dues_total)/$sell['total_schedule_amount'])*100);
                                        $total_balance_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($balance)/$sell['total_schedule_amount'])*100);



                                        $total_advance += $sell['total_advance_amount'];

                                    @endphp
                                    <td>{{ number_format($total_received_per,2) }}%</td>
                                    <td>{{ number_format($total_dues_per,2) }}%</td>
                                    <td>{{ number_format($total_balance_per,2) }}%</td>

                                    
                                    

                                    @php
                                        if(count($sell['actual_received']) > 0){
                                            end($sell['actual_received']);
                                            $last_index = key($sell['actual_received']);
                                        }
                                        if(count($sell['actual_received_item']) > 0){
                                            end($sell['actual_received_item']);
                                            $last_index_items = key($sell['actual_received_item']);
                                        }


                                        $last_pay_amount = end($sell['actual_received'])['actual_amount'] ?? 0;

                                        

                                    @endphp
                                    <td>{{ (count($sell['actual_received']) > 0) ? $transaction->date_format($sell['actual_received'][$last_index]['date_of_collection_new']) : "-" }}</td>
                                    <td>{{  number_format($last_pay_amount,2)  }}</td>

                                    @php
                                        $last_paid += $last_pay_amount;
                                    @endphp
                                    
                                </tr>
                            @endforeach
                            
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan ="5" class="text-right">{{__('lang.total')}} </th>
                                
                                <th>{{ number_format($total_advance,2) }}</th>
                                <th>{{ number_format($total_cost,2) }}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th>{{ number_format($total_received_off,2) }}</th>
                                    <th>{{ number_format($total_received_un,2) }}</th>
                                @endif
                                <th>{{ number_format(($total_received_off+$total_received_un),2) }}</th>
                                <th>{{ number_format($total_balance,2) }}</th>

                                <th>{{ number_format($total_dues_bf_this, 2) }}</th>
                                <th>{{ number_format($total_dues_till_month, 2) }}</th>
                                <th>{{ number_format($total_dues,2) }}</th>

                                @php

                                    $total_received_per_all = ($total_cost == 0) ? 0 : ((($total_received_off+$total_received_un)/$total_cost)*100);
                                    $total_dues_per_all = ($total_cost == 0) ? 0 : (($total_dues/$total_cost)*100);
                                    $total_balance_per_all = ($total_cost == 0) ? 0 : (($total_balance/$total_cost)*100);
                                @endphp
                                <th>{{ number_format($total_received_per_all,2) }}%</th>
                                <th>{{ number_format($total_dues_per_all,2) }}%</th>
                                <th>{{ number_format($total_balance_per_all,2) }}%</th>
                                <th colspan="1"></th>
                                <th>{{ number_format($last_paid,2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                    <br>

                    @php
                        $total_cost_grand += $total_cost;
                        $total_received_off_grand += $total_received_off;
                        $total_received_un_grand += $total_received_un;
                        $total_received_grand += $total_received_off+$total_received_un;
                        $total_balance_grand += $total_balance;
                        $total_dues_bf_this_grand += $total_dues_bf_this;
                        $total_dues_till_month_grand += $total_dues_till_month;
                        $total_dues_grand += $total_dues;
                        $total_advance_grand += $total_advance;
                        $total_dues_grand += $total_dues;

                    @endphp
                @endif

            @endforeach
        @elseif ($block > 0)
            @foreach ($block as $key => $item)
                @php
                    $balance = $total_received_per = $total_dues_per = $total_balance_per = $dues_total= $total_cost = $total_received_off = $total_received_un = $total_balance = $total_dues_bf_this = $total_dues_till_month = $total_dues = $total_advance = $total_received_per_all = $total_dues_per_all = $total_balance_per_all = $last_paid = 0;
                @endphp

                @if(count($sells[$item->id]) > 0)
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th scope="col" colspan="100٪" class="text-left">{{__('lang.block')}}: {{ $item->name }}</th>
                            </tr>
                            <tr>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.serial_no')}}</th>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.unit')}} #</th>
                                <th scope="col" class="text-center" style="width: 150px;">{{__('lang.customer')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.contact')}} #</th>
                                <th scope="col" class="text-center width-90">{{__('lang.booking_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.advance_receiving')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}} {{__('lang.sale')}}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th scope="col" class="text-center" colspan="2" style="width: 120px;">{{__('lang.receiving')}}</th>
                                @endif

                                <th scope="col" class="text-center width-85">{{__('lang.total_received')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance')}}</th>
                                
                                <th scope="col" class="text-center" colspan="3" style="width: 200px">{{__('lang.dues')}}</th>

                                <th scope="col" class="text-center" colspan="3" style="width: 200px">% {{__('lang.of')}}</th>
                                
                                <th scope="col" class="text-center width-90">{{__('lang.last_pay_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.last_pay')}} {{$transaction->systemSettingCurrency()}}</th>

                            </tr>
                            <tr>
                                @if(userAllowedUnofficial() == 1)
                                    <th colspan="7"></th>
                                    <th scope="col" class="text-center width-85">{{__('lang.off')}}</th>
                                    <th scope="col" class="text-center width-85">{{__('lang.un')}}</th>
                                @else
                                    <th colspan="9"></th>
                                @endif
                                <th scope="col" class="text-center width-85">{{__('lang.bf_this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}}</th>
                            
                                <th scope="col" class="text-center width-85">{{__('lang.recvd')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.dues_upper')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance_upper')}} %</th>
                                <th colspan="2"></th>
                            </tr>
                        </thead>
                        <tbody>
                            
                            
                            @foreach ($sells[$item->id] as $key => $sell)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $sell['product']['product_unique_id'] }}</td>
                                    <td>{{ $sell['customer']['name'] }}</td>
                                    <td>{{ $sell['customer']['phone'] }}<br>{{ $sell['customer']['residential_phone'] }}</td>
                                    <td>{{ $transaction->date_format($sell['sale_date_v2']) }}</td>
                                    <td>{{ number_format($sell['total_advance_amount'],2) }}</td>
                                    <td>{{ number_format($sell['total_schedule_amount'],2) }}</td>


                                    @if(userAllowedUnofficial() == 1)
                                        <td>{{ number_format($sell['total_paid_off'],2) }}</td>
                                        <td>{{ number_format($sell['total_paid_un'],2) }}</td>
                                    @endif

                                    <td>{{ number_format($sell['total_paid_off'] + $sell['total_paid_un'],2) }} </td>

                                    @php
                                        $balance = $sell['total_schedule_amount'] - ($sell['total_paid_off']+$sell['total_paid_un']);

                                        $total_cost += $sell['total_schedule_amount'];

                                        $total_received_off += $sell['total_paid_off'];
                                        $total_received_un += $sell['total_paid_un'];

                                        $total_balance += $balance;


                                    @endphp

                                    <td>{{ number_format($balance,2) }}</td>
                                    <td>{{ isset($sell['total_till_month_due_before_this_period']) ? number_format($sell['total_till_month_due_before_this_period'],2) : 0 }}</td>
                                    <td>{{ number_format($sell['total_till_month_due'],2) }}</td>
                                    @php

                                        $dues_total = $sell['total_till_month_due'] + $sell['total_till_month_due_before_this_period'] ?? 0;


                                        $total_dues_bf_this += $sell['total_till_month_due_before_this_period'] ?? 0;

                                        $total_dues_till_month += $sell['total_till_month_due'];

                                        $total_dues += $dues_total;



                                    @endphp
                                    <td>{{ number_format($dues_total, 2) }}</td>

                                    


                                    @php

                                        $total_received_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($sell['total_paid_off']+$sell['total_paid_un'])/$sell['total_schedule_amount'])*100);

                                        $total_dues_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($dues_total)/$sell['total_schedule_amount'])*100);
                                        $total_balance_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($balance)/$sell['total_schedule_amount'])*100);



                                        $total_advance += $sell['total_advance_amount'];

                                    @endphp
                                    <td>{{ number_format($total_received_per,2) }}%</td>
                                    <td>{{ number_format($total_dues_per,2) }}%</td>
                                    <td>{{ number_format($total_balance_per,2) }}%</td>

                                    
                                    

                                    @php
                                        if(count($sell['actual_received']) > 0){
                                            end($sell['actual_received']);
                                            $last_index = key($sell['actual_received']);
                                        }
                                        if(count($sell['actual_received_item']) > 0){
                                            end($sell['actual_received_item']);
                                            $last_index_items = key($sell['actual_received_item']);
                                        }

                                        $last_pay_amount = end($sell['actual_received'])['actual_amount'] ?? 0;

                                    @endphp
                                    <td>{{ (count($sell['actual_received']) > 0) ? $transaction->date_format($sell['actual_received'][$last_index]['date_of_collection_new']) : "-" }}</td>
                                    <td>{{ number_format($last_pay_amount,2)}}</td>

                                    @php
                                        $last_paid += $last_pay_amount;
                                    @endphp
                                    
                                </tr>
                            @endforeach
                            
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan ="5" class="text-right">{{__('lang.total')}} </th>
                                
                                <th>{{ number_format($total_advance,2) }}</th>
                                <th>{{ number_format($total_cost,2) }}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th>{{ number_format($total_received_off,2) }}</th>
                                    <th>{{ number_format($total_received_un,2) }}</th>
                                @endif
                                <th>{{ number_format(($total_received_off+$total_received_un),2) }}</th>
                                <th>{{ number_format($total_balance,2) }}</th>

                                <th>{{ number_format($total_dues_bf_this, 2) }}</th>
                                <th>{{ number_format($total_dues_till_month, 2) }}</th>
                                <th>{{ number_format($total_dues,2) }}</th>

                                @php

                                    $total_received_per_all = ($total_cost == 0) ? 0 : ((($total_received_off+$total_received_un)/$total_cost)*100);
                                    $total_dues_per_all = ($total_cost == 0) ? 0 : (($total_dues/$total_cost)*100);
                                    $total_balance_per_all = ($total_cost == 0) ? 0 : (($total_balance/$total_cost)*100);
                                @endphp
                                <th>{{ number_format($total_received_per_all,2) }}%</th>
                                <th>{{ number_format($total_dues_per_all,2) }}%</th>
                                <th>{{ number_format($total_balance_per_all,2) }}%</th>
                                <th colspan="1"></th>
                                <th>{{ number_format($last_paid,2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                    <br>

                    @php
                        $total_cost_grand += $total_cost;
                        $total_received_off_grand += $total_received_off;
                        $total_received_un_grand += $total_received_un;
                        $total_received_grand += $total_received_off+$total_received_un;
                        $total_balance_grand += $total_balance;
                        $total_dues_bf_this_grand += $total_dues_bf_this;
                        $total_dues_till_month_grand += $total_dues_till_month;
                        $total_dues_grand += $total_dues;
                        $total_advance_grand += $total_advance;
                        $total_dues_grand += $total_dues;

                    @endphp
                @endif

            @endforeach
      
       
        @else
            @foreach ($category as $key => $item)

                @php
                    $balance = $total_received_per = $total_dues_per = $total_balance_per = $dues_total= $total_cost = $total_received_off = $total_received_un = $total_balance = $total_dues_bf_this = $total_dues_till_month = $total_dues = $total_advance = $total_received_per_all = $total_dues_per_all = $total_balance_per_all = $last_paid= 0;
                @endphp

                @if(count($sells[$item->id]) > 0)
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th scope="col" colspan="100٪" class="text-left">{{__('lang.category')}} : {{ $item->name }}</th>
                            </tr>
                            <tr>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.serial_no')}}</th>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.unit')}} #</th>
                                <th scope="col" class="text-center width-90">{{__('lang.booking_date')}}</th>
                                <th scope="col" class="text-center" style="width: 150px;">{{__('lang.customer')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}} {{__('lang.sale')}}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th scope="col" class="text-center" colspan="2" style="width: 120px;">{{__('lang.receiving')}}</th>
                                @endif

                                <th scope="col" class="text-center width-85">{{__('lang.total_received')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance')}}</th>
                                
                                <th scope="col" class="text-center" colspan="3" style="width: 200px">{{__('lang.dues')}}</th>

                                <th scope="col" class="text-center width-85">{{__('lang.advance_receiving')}}</th>
                                <th scope="col" class="text-center" colspan="3" style="width: 200px">% {{__('lang.of')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.contact')}} #</th>
                                <th scope="col" class="text-center width-90">{{__('lang.last_pay_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.remarks')}}</th>

                            </tr>
                            <tr>
                                @if(userAllowedUnofficial() == 1)
                                    <th colspan="5"></th>
                                    <th scope="col" class="text-center width-85">{{__('lang.off')}}</th>
                                    <th scope="col" class="text-center width-85">{{__('lang.un')}}</th>
                                @else
                                    <th colspan="7"></th>
                                @endif
                                <th scope="col" class="text-center width-85">{{__('lang.bf_this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}}</th>
                                <th colspan="1"></th>
                                <th scope="col" class="text-center width-85">{{__('lang.recvd')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.dues_upper')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance_upper')}} %</th>
<tr>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.serial_no')}}</th>
                                <th scope="col" class="text-center" style="width: 60px;">{{__('lang.unit')}} #</th>
                                <th scope="col" class="text-center" style="width: 150px;">{{__('lang.customer')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.contact')}} #</th>
                                <th scope="col" class="text-center width-90">{{__('lang.booking_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.advance_receiving')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}} {{__('lang.sale')}}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th scope="col" class="text-center" colspan="2" style="width: 120px;">{{__('lang.receiving')}}</th>
                                @endif

                                <th scope="col" class="text-center width-85">{{__('lang.total_received')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance')}}</th>
                                
                                <th scope="col" class="text-center" colspan="3" style="width: 200px">{{__('lang.dues')}}</th>

                                <th scope="col" class="text-center" colspan="3" style="width: 200px">% {{__('lang.of')}}</th>
                                
                                <th scope="col" class="text-center width-90">{{__('lang.last_pay_date')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.last_pay')}} {{$transaction->systemSettingCurrency()}}</th>

                            </tr>
                            <tr>
                                @if(userAllowedUnofficial() == 1)
                                    <th colspan="7"></th>
                                    <th scope="col" class="text-center width-85">{{__('lang.off')}}</th>
                                    <th scope="col" class="text-center width-85">{{__('lang.un')}}</th>
                                @else
                                    <th colspan="9"></th>
                                @endif
                                <th scope="col" class="text-center width-85">{{__('lang.bf_this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.this_period')}}</th>
                                <th scope="col" class="text-center width-85">{{__('lang.total')}}</th>
                            
                                <th scope="col" class="text-center width-85">{{__('lang.recvd')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.dues_upper')}} %</th>
                                <th scope="col" class="text-center width-85">{{__('lang.balance_upper')}} %</th>
                                <th colspan="2"></th>
                            </tr>
                        </thead>
                        <tbody>
                            
                            
                            @foreach ($sells[$item->id] as $key => $sell)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $sell['product']['product_unique_id'] }}</td>
                                    <td>{{ $sell['customer']['name'] }}</td>
                                    <td>{{ $sell['customer']['phone'] }}<br>{{ $sell['customer']['residential_phone'] }}</td>
                                    <td>{{ $transaction->date_format($sell['sale_date_v2']) }}</td>
                                    <td>{{ number_format($sell['total_advance_amount'],2) }}</td>
                                    <td>{{ number_format($sell['total_schedule_amount'],2) }}</td>


                                    @if(userAllowedUnofficial() == 1)
                                        <td>{{ number_format($sell['total_paid_off'],2) }}</td>
                                        <td>{{ number_format($sell['total_paid_un'],2) }}</td>
                                    @endif

                                    <td>{{ number_format($sell['total_paid_off'] + $sell['total_paid_un'],2) }} </td>

                                    @php
                                        $balance = $sell['total_schedule_amount'] - ($sell['total_paid_off']+$sell['total_paid_un']);

                                        $total_cost += $sell['total_schedule_amount'];

                                        $total_received_off += $sell['total_paid_off'];
                                        $total_received_un += $sell['total_paid_un'];

                                        $total_balance += $balance;


                                    @endphp

                                    <td>{{ number_format($balance,2) }}</td>
                                    <td>{{ isset($sell['total_till_month_due_before_this_period']) ? number_format($sell['total_till_month_due_before_this_period'],2) : 0 }}</td>
                                    <td>{{ number_format($sell['total_till_month_due'],2) }}</td>
                                    @php

                                        $dues_total = $sell['total_till_month_due'] + $sell['total_till_month_due_before_this_period'] ?? 0;


                                        $total_dues_bf_this += $sell['total_till_month_due_before_this_period'] ?? 0;

                                        $total_dues_till_month += $sell['total_till_month_due'];

                                        $total_dues += $dues_total;



                                    @endphp
                                    <td>{{ number_format($dues_total, 2) }}</td>

                                    


                                    @php

                                        $total_received_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($sell['total_paid_off']+$sell['total_paid_un'])/$sell['total_schedule_amount'])*100);

                                        $total_dues_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($dues_total)/$sell['total_schedule_amount'])*100);
                                        $total_balance_per = ($sell['total_schedule_amount'] == 0) ? 0 : ((($balance)/$sell['total_schedule_amount'])*100);



                                        $total_advance += $sell['total_advance_amount'];

                                    @endphp
                                    <td>{{ number_format($total_received_per,2) }}%</td>
                                    <td>{{ number_format($total_dues_per,2) }}%</td>
                                    <td>{{ number_format($total_balance_per,2) }}%</td>

                                    
                                    

                                    @php
                                        if(count($sell['actual_received']) > 0){
                                            end($sell['actual_received']);
                                            $last_index = key($sell['actual_received']);
                                        }
                                        if(count($sell['actual_received_item']) > 0){
                                            end($sell['actual_received_item']);
                                            $last_index_items = key($sell['actual_received_item']);
                                        }

                                        $last_pay_amount = end($sell['actual_received'])['actual_amount'] ?? 0;


                                    @endphp
                                    <td>{{ (count($sell['actual_received']) > 0) ? $transaction->date_format($sell['actual_received'][$last_index]['date_of_collection_new']) : "-" }}</td>
                                    <td>{{ number_format($last_pay_amount,2) }}</td>

                                    @php
                                        $last_paid += $last_pay_amount;
                                    @endphp
                                    
                                </tr>
                            @endforeach
                            
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan ="5" class="text-right">{{__('lang.total')}} </th>
                                
                                <th>{{ number_format($total_advance,2) }}</th>
                                <th>{{ number_format($total_cost,2) }}</th>

                                @if(userAllowedUnofficial() == 1)
                                    <th>{{ number_format($total_received_off,2) }}</th>
                                    <th>{{ number_format($total_received_un,2) }}</th>
                                @endif
                                <th>{{ number_format(($total_received_off+$total_received_un),2) }}</th>
                                <th>{{ number_format($total_balance,2) }}</th>

                                <th>{{ number_format($total_dues_bf_this, 2) }}</th>
                                <th>{{ number_format($total_dues_till_month, 2) }}</th>
                                <th>{{ number_format($total_dues,2) }}</th>

                                @php

                                    $total_received_per_all = ($total_cost == 0) ? 0 : ((($total_received_off+$total_received_un)/$total_cost)*100);
                                    $total_dues_per_all = ($total_cost == 0) ? 0 : (($total_dues/$total_cost)*100);
                                    $total_balance_per_all = ($total_cost == 0) ? 0 : (($total_balance/$total_cost)*100);
                                @endphp
                                <th>{{ number_format($total_received_per_all,2) }}%</th>
                                <th>{{ number_format($total_dues_per_all,2) }}%</th>
                                <th>{{ number_format($total_balance_per_all,2) }}%</th>
                                <th colspan="1"></th>
                                <th>{{ number_format($last_paid,2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                    <br>

                    @php
                        $total_cost_grand += $total_cost;
                        $total_received_off_grand += $total_received_off;
                        $total_received_un_grand += $total_received_un;
                        $total_received_grand += $total_received_off+$total_received_un;
                        $total_balance_grand += $total_balance;
                        $total_dues_bf_this_grand += $total_dues_bf_this;
                        $total_dues_till_month_grand += $total_dues_till_month;
                        $total_dues_grand += $total_dues;
                        $total_advance_grand += $total_advance;
                        $total_dues_grand += $total_dues;

                    @endphp
                @endif
            @endforeach
        @endif

        <table class="table table-bordered table-hover" style="width: 30%; float: right;">
            <thead>
                <tr>
                    <td colspan="2" style="font-weight: bold; text-align: center;">{{__('lang.grand_total')}}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_sale')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_cost_grand,2) }}</td>
                </tr>
                @if(userAllowedUnofficial() == 1)
                    <tr>
                        <th class="gray font-bold">{{__('lang.received_off')}}</th>
                        <td class="text-right font-bold">{{ number_format($total_received_off_grand,2) }}</td>
                    </tr>
                    <tr>
                        <th class="gray font-bold">{{__('lang.received_un')}}</th>
                        <td class="text-right font-bold">{{ number_format($total_received_un_grand,2) }}</td>
                    </tr>
                @endif
                <tr>
                    <th class="gray font-bold">{{__('lang.total_received')}} @if(userAllowedUnofficial() == 1) OFF/UN @endif</th>
                    <td class="text-right font-bold">{{ number_format($total_received_grand,2) }}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.balance')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_balance_grand,2) }}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_bf_this_period')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_dues_bf_this_grand,2) }}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_this_period')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_dues_till_month_grand,2) }}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_dues')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_dues_grand,2) }}</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_advance_receiving')}}</th>
                    <td class="text-right font-bold">{{ number_format($total_advance_grand,2) }}</td>
                </tr>
                @php

                    $total_received_per_grand = ($total_cost_grand == 0) ? 0 : ((($total_received_grand)/$total_cost_grand)*100);
                    $total_dues_per_grand = ($total_cost_grand == 0) ? 0 : (($total_dues_grand/$total_cost_grand)*100);
                    $total_balance_per_grand = ($total_cost_grand == 0) ? 0 : (($total_balance_grand/$total_cost_grand)*100);
                @endphp
                <tr>
                    <th class="gray font-bold">{{__('lang.total_received')}} %</th>
                    <td class="text-right font-bold">{{ number_format($total_received_per_grand,2) }}%</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_dues')}} %</th>
                    <td class="text-right font-bold">{{ number_format($total_dues_per_grand,2) }}%</td>
                </tr>
                <tr>
                    <th class="gray font-bold">{{__('lang.total_balance_lowercase')}} %</th>
                    <td class="text-right font-bold">{{ number_format($total_balance_per_grand,2) }}%</td>
                </tr>

            </thead>
        </table>
        
    </div>

@stop