@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;
        }
    </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">
        @include('admin.partials.header', ['extra' => $extra])
        @php
            $total_colspan = 15;
        @endphp
        <table class="table table-bordered table-hover" style=" @if($action == 'Show')   width: 0; white-space: nowrap;@endif">
            <thead>
                <tr>
                    <th colspan="2"></th>
                    <th colspan="6" style="text-align: center">PRODUCT</th>
                    
                    <th colspan="4" style="text-align: center">CUSTOMER</th>
                    <th colspan="100%" style="text-align: center">SALES</th>
                </tr>
                <tr class="fixed_tr">
                    <th>S. No.</th>
                    <th>Registration No</th>
                    <th>Project Name</th>
                    <th>Unit No</th>
                    <th>Block</th>
                    <th>Floor</th>
                    <th>Category</th>
                    <th>Size</th>
                    <th>Customer</th>
                    <th>NIC</th>
                    <th>Address</th>
                    <th>Phone</th>
                    <th>Sale Date</th>
                    <th>Internal Dealer</th>
                    <th>External Dealer</th>
                    <th class="text-right">Property Value</th>
                    <th class="text-right">Additional Charges {{$transaction->systemSettingCurrency()}}</th>
                    <th class="text-right">Sale {{$transaction->systemSettingCurrency()}}</th>
                    <th class="text-right">Discount</th>
                    <th class="text-right">Schedule {{$transaction->systemSettingCurrency()}}</th>
                    <th class="text-right">Total Collection</th>
                    <th class="text-right">Total Due</th>
                    <th class="text-right">Total Due Till Month</th>
                    <th class="text-center">Sale Status</th>
                    <th class="text-center">Down Payment / Booking Money</th>
                    <th class="text-right">Per Month Installment</th>
                    <th class="text-right">Half Yearly Amount</th>
                    <th class="text-right">Quarterly Amount</th>
                    <th class="text-right">Annually Amount</th>
                    <th class="text-right">Possession Amount</th>
                    <th>Due Months</th>
                    <th>No Of Days</th>
                    <th>Last Payment Date</th>
                    <th class="text-right">Last Payment Amount</th>
                    <th>Last Payment Mode</th>
                    <th>Agent Name</th>    
                </tr>
            </thead>
            <tbody>
                @foreach ($sells as $sell)

                    @php 
                        $monthly_installment        = $sell->current_monthly_installment;
                        $half_yearly_installment    = $sell->current_half_yearly_installment;
                        $quarterly_installment      = $sell->current_quarterly_installment;
                        $annually_installment       = $sell->current_annually_installment;
                        $possession_term            = $sell->current_possession_term;
                        $down_payment_term          = $sell->current_down_payment_term;

                        $product_fixed_amount   = $sell->product->fixed_amount;
                        $discount_amount        = $sell->discount_amount;
                        $additional_charges     = $sell->additional_charges;
                        $schedule_amount        = $sell->total_schedule_amount;
                        $collected_amount       = $sell->total_received_amount;
                        $till_month_amount      = $sell->total_till_month_due;
                        $sale_amount            = $schedule_amount + $discount_amount;
                        $due_amount             = $schedule_amount - $collected_amount;
                        $last_payment_date      = $sell->current_month_payment_date;
                        $last_paid_amount       = $sell->current_month_paid_amount;
                        $last_mode_of_payment   = $sell->current_month_payment_mode;

                        $internal_dealer        = $sell->sell_internal_dealer_rebate->implode('DealerName.name' , ',');
                        $external_dealer        = $sell->sell_external_dealer_rebate->implode('DealerName.name' , ',');

                        $no_of_days = 0;
                        if ($sell->due_terms_count == 1) {
                            $no_of_days = "0-30";
                        } elseif ($sell->due_terms_count == 2) {
                            $no_of_days = "30-60";
                        } elseif ($sell->due_terms_count == 3) {
                            $no_of_days = "60-90";
                        } elseif ($sell->due_terms_count >= 4) { 
                            $no_of_days = "90+";
                        }

                        //total amounts
                        $total_product_fixed_amount += $product_fixed_amount ;
                        $total_additional_charges   += $additional_charges ;
                        $total_discount_amount      += $discount_amount;
                        $total_schedule_amount      += $schedule_amount;
                        $total_collected_amount     += $collected_amount;
                        $total_till_month_amount    += $till_month_amount;
                        $total_sale_amount          += $sale_amount;
                        $total_due_amount           += $due_amount;
                        $total_last_paid_amount     += $last_paid_amount;   

                        $badge_class = '';
                        if ($sell->is_transfered) {
                            $badge_class = 'badge-danger';
                        }
                        else{
                            if ($sell->status == 'ACTIVE') {
                                $badge_class = 'badge-success';
                            } elseif ($sell->status == 'CANCELLED') {
                                $badge_class = 'badge-danger';
                            } elseif ($sell->status == 'BUY BACK') {
                                $badge_class = 'badge-info';
                            }elseif ($sell->status == 'FULL PAID') {
                                $badge_class = 'badge-success';
                            } else {
                                $badge_class = 'badge-warning';
                            }
                        }

                    @endphp
                    <tr>
                        <td>{{ $loop->iteration  }}</td>
                        <td>
                            <a href="{{ route('sell.edit', $sell->id) }}" target="_blank">
                                {{ $sell->registration_no }}
                            </a>
                        </td>
                        <td>{{ $sell->branch->name }}</td>
                        <td>{{ $sell->product->product_unique_id }}</td>
                        <td>{{ $sell->product->block->name ?? '-' }}</td>
                        <td>{{ $sell->product->floor->name ?? '-' }}</td>
                        <td>{{ $sell->product->category->name ?? '-' }}</td>
                        <td>{{ $sell->product->flat_size }} {{ $sell->product->size_in }}</td>
                        <td>{{ $sell->customer->name }}</td>
                        <td>{{ $sell->customer->nid }}</td>
                        <td>{{ $sell->customer->mailing_address }}</td>
                        <td>{{ $sell->customer->phone }}</td>
                        <td>{{ $transaction->date_format($sell->sale_date_v2) }}</td>
                        <td>{{ $internal_dealer ?? "-" }}</td>
                        <td>{{ $external_dealer ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($product_fixed_amount) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($additional_charges) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($sale_amount) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($discount_amount) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($schedule_amount) }} </td>
                        <td class="text-right">{{ $transaction->convert_money_format($collected_amount) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($due_amount) }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($till_month_amount) }}</td>
                        <td class="text-center">
                            <span class="badge {{ $badge_class }}">
                                @if ($sell->is_transfered)
                                    TRANSFER
                                @else
                                    {{ $sell->status }}
                                @endif
                            </span>
                        </td>
                        <td class="text-right">{{ $transaction->convert_money_format($down_payment_term) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($monthly_installment) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($half_yearly_installment) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($quarterly_installment) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($annually_installment) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($possession_term) ?? "-" }}</td>
                        <td>{{ $sell->due_terms_count ?? "-" }}</td>
                        <td>{{ $no_of_days ?? "-" }}</td>
                        <td>{{ $transaction->date_format($last_payment_date) ?? "-" }}</td>
                        <td class="text-right">{{ $transaction->convert_money_format($last_paid_amount) ?? "-" }}</td>
                        <td>{{ $last_mode_of_payment ?? "-" }}</td>
                        <td>{{ $sell->SellAssignRecovery->recoveryAgent->name ?? "-" }}</td>
                    </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr style="font-weight: bold">
                    <td colspan="{{$total_colspan}}" class="text-right">TOTAL</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_product_fixed_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_additional_charges ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_sale_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_discount_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_schedule_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_collected_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_due_amount ) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_till_month_amount ) }}</td>
                    <td colspan="10"></td>
                    <td class="text-right">{{ $transaction->convert_money_format($total_last_paid_amount) }}</td>
                    <td colspan="2"></td>
                </tr> 

            </tfoot>
        </table>
</div>

@stop