@extends('layouts.sidebar')

@section('content')
    <style>
        @media print {
            body * {
                visibility: hidden;
            }

            .print-content,
            .print-content * {
                visibility: visible;
                font-size: 10px;
                /* Adjust the font size as needed */
            }

            .print-content {
                position: absolute;
                left: 0;
                top: 0;
                width: 210mm;
                /* A4 width */
                height: 350mm;
                /* A4 height */
                padding: 10mm;
                /* Add padding to simulate margin */
                box-sizing: border-box;
            }

            .print-content table td,
            .print-content table th {
                padding: 2px;
                /* Adjust the padding as needed */
            }
        }
    </style>
    <div class="max-w-4xl p-8 mx-auto text-sm bg-white border border-gray-200 shadow-lg print-content">
        <div class="mb-8 text-center">
            <h1 class="text-xl font-bold">San Roque Hermanas Inc.</h1>
            <p class="text-gray-700">MGR BLDG. II, Matina Crossing, Davao City</p>
            <p class="text-gray-700">Tel: (082)299-4103</p>
            <p class="text-gray-700">Cell # 0910-651-1604</p>
        </div>

        <div class="mb-8">
            <h2 class="pb-2 mb-4 text-lg font-semibold border-b">Foreclosure Notice</h2>
            <p class="mb-4 text-gray-700">Date: {{ now()->format('F j, Y') }}</p>
        </div>

        <div class="mb-8">
            <p class="font-semibold">To:</p>
            <p class="text-gray-700">{{ $lease->client->business_name }}</p>
            <p class="text-gray-700">{{ $lease->unit->unit_name }}</p>
            <p class="text-gray-700">{{ $lease->property->street_address }}, {{ $lease->property->city }},
                {{ $lease->property->state }}, {{ $lease->property->zip }}</p>
        </div>

        <div class="mb-8">
            <p class="text-gray-700">Sir / Madam:</p>
            <p class="mt-4 text-gray-700">This is to inform you of your unpaid monthly rentals and utility bills as detailed
                below:</p>
        </div>

        <table class="w-full mt-4 border border-collapse border-gray-300">
            <thead>
                <tr class="bg-gray-200">
                    <th class="px-4 py-2 text-left border border-gray-300">Billing No.</th>
                    <th class="px-4 py-2 text-left border border-gray-300">Description</th>
                    <th class="px-4 py-2 text-right border border-gray-300">Amount</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $totalAmount = 0;
                    $totalEscalatedAmount = 0;
                    use Carbon\Carbon;
                @endphp

                @foreach ($lease->payments as $payment)
                    @php

                        // Get escalated amount based on payment date
                        $escalatedAmount = $lease->getEscalatedRentAmount($payment->payment_date);

                        // Define the due date based on lease terms
                        $dueDate = $payment->payment_date->copy()->addDays($payment->lease->terms);

                        $dateOfPayment = $payment->newPayments->max('date_of_payment');

                        if ($dateOfPayment) {
                            $dateOfPayment = Carbon::parse($dateOfPayment);
                        } else {
                            $dateOfPayment = now();
                        }

                        // Check if the payment date is past due date
                        $isPastDue = $dateOfPayment->isAfter($dueDate);

                        // Calculate penalty only if payment is past due
                        if ($isPastDue) {
                            $monthsPastDueWithPayment = $dateOfPayment->diffInMonths($dueDate);
                            $penalty = $escalatedAmount * 0.02 * $monthsPastDueWithPayment;
                        } else {
                            $penalty = 0;
                        }

                        $totalEscalatedAmount += $escalatedAmount + $penalty;
                    @endphp


                    <tr>
                        <td class="px-4 py-2 border border-gray-300">
                            Billing No. {{ $payment->payment_id }}
                        </td>
                        <td class="px-4 py-2 border border-gray-300">
                            Rent Due for
                            ({{ $payment->payment_date->format('M d, Y') }} -
                            {{ $dueDate->format('M d, Y') }})
                        </td>
                        <td class="px-4 py-2 text-right border border-gray-300">
                            {{ number_format($escalatedAmount, 2) }}
                        </td>
                        @php
                            $totalAmount += $escalatedAmount;
                        @endphp
                    </tr>

                    @foreach ($payment->electricPayments as $electricPayment)
                        <tr>
                            <td class="px-4 py-2 border border-gray-300"></td>
                            <td class="px-4 py-2 border border-gray-300">Electric Bill
                                ({{ $electricPayment->start_date->format('M d, Y') }} -
                                {{ $electricPayment->end_date->format('M d, Y') }})
                            </td>
                            <td class="px-4 py-2 text-right border border-gray-300">
                                {{ number_format($electricPayment->amount, 2) }}
                            </td>
                        </tr>
                        @php
                            $totalAmount += $electricPayment->amount;
                        @endphp
                    @endforeach

                    @foreach ($payment->waterPayments as $waterPayment)
                        <tr>
                            <td class="px-4 py-2 border border-gray-300"></td>
                            <td class="px-4 py-2 border border-gray-300">Water Bill
                                ({{ $waterPayment->start_date->format('M d, Y') }} -
                                {{ $waterPayment->end_date->format('M d, Y') }})
                            </td>
                            <td class="px-4 py-2 text-right border border-gray-300">
                                {{ number_format($waterPayment->amount, 2) }}
                            </td>
                        </tr>
                        @php
                            $totalAmount += $waterPayment->amount;
                        @endphp
                    @endforeach

                    @foreach ($payment->additionalFees as $fee)
                        <tr>
                            <td class="px-4 py-2 border border-gray-300"></td>
                            <td class="px-4 py-2 border border-gray-300">Additional Fee: {{ $fee->notes }}</td>
                            <td class="px-4 py-2 text-right border border-gray-300">
                                {{ number_format($fee->amount, 2) }}
                            </td>
                        </tr>
                        @php
                            $totalAmount += $fee->amount;
                        @endphp
                    @endforeach

                    @if ($isPastDue)
                        <tr>
                            <td class="px-4 py-2 border border-gray-300"></td>
                            <td class="px-4 py-2 border border-gray-300">Penalty for {{ $monthsPastDueWithPayment }}
                                month(s) past due
                            </td>
                            <td class="px-4 py-2 text-right border border-gray-300">
                                {{ number_format($penalty, 2) }}
                            </td>
                        </tr>
                        @php
                            $totalAmount += $penalty;
                        @endphp
                    @endif
                @endforeach

                @php
                    $totalpayable = $totalAmount;
                    $totaldeductedAmount = $totalpayable - $totalPaymentsMade;
                @endphp
                <tr class="font-bold">
                    <td class="px-4 py-2 border border-gray-300"></td>
                    <td class="px-4 py-2 border border-gray-300">Total Payables</td>
                    <td class="px-4 py-2 text-right border border-gray-300">
                        {{ number_format($totalpayable, 2) }}
                    </td>
                </tr>
                <tr class="font-bold">
                    <td class="px-4 py-2 border border-gray-300"></td>
                    <td class="px-4 py-2 border border-gray-300">Total Advanced Payment</td>
                    <td class="px-4 py-2 text-right border border-gray-300">
                        {{ number_format($totalPaymentsMade, 2) }}
                    </td>
                </tr>
                <tr class="font-bold">
                    <td class="px-4 py-2 border border-gray-300"></td>
                    <td class="px-4 py-2 border border-gray-300">Current Payables</td>
                    <td class="px-4 py-2 text-right border border-gray-300">
                        {{ number_format($totaldeductedAmount, 2) }}
                    </td>
                </tr>
            </tbody>
        </table>

        <div class="mt-8">
            <p class="text-gray-700">Kindly settle the payment by the due date to avoid further penalties. For any
                questions,
                please contact our office.</p>
        </div>

        <div class="mt-8">
            <p class="text-gray-700">Thank you for your prompt attention to this matter.</p>
        </div>
    </div>
@endsection