@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-6 mx-auto text-sm bg-white rounded-md shadow-lg print-content">
        <div class="mb-6 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-6">
            <h2 class="text-2xl font-semibold">Demand Letter</h2>
            <p class="mt-2 text-gray-700">{{ now()->format('F d, 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-6">
            <p class="text-gray-700">Sir / Madam:</p>
            <p class="mt-2 text-gray-700">
                This is to inform you of your unpaid monthly rentals in the total amount as shown in the computation below:
            </p>
            <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

                            $escalatedAmount = $lease->getEscalatedRentAmount($payment->payment_date);

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

                            $dueDate1 = $payment->payment_date;

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

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

                            $isPastDue = now()->isAfter($dueDate1);
                            $monthsPastDue = $isPastDue ? now()->diffInMonths($dueDate1) : 0;
                            $penaltyEndDate = $dateOfPayment->isAfter($dueDate1) ? $dateOfPayment : now();
                            $monthsPastDueWithPayment = $penaltyEndDate->diffInMonths($dueDate1);
                            $penalty = $escalatedAmount * 0.02 * $monthsPastDueWithPayment;
                            $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>
                        </tr>
                        @php
                            $totalAmount += $escalatedAmount;
                        @endphp

                        @foreach ($payment->electricPayments as $electricPayment)
                            @php
                                $totalAmount += $electricPayment->amount;
                            @endphp
                            <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)
                            @php
                                $totalAmount += $waterPayment->amount;
                            @endphp
                            <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)
                            @php
                                $totalAmount += $fee->amount;
                            @endphp
                            <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>
                                @php
                                    $totalAmount += $fee->amount;
                                @endphp
                            </tr>
                        @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 {{ $monthsPastDue }} 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($totalAmount, 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">Total Current Payable</td>
                        <td class="px-4 py-2 text-right border border-gray-300">
                            {{ number_format($totaldeductedAmount, 2) }}
                        </td>
                    </tr>



                </tbody>
            </table>
        </div>

        <div class="mb-6">
            <p class="mt-2 text-gray-700">
                It is stipulated in the Contract of Lease that in the event the LESSEE fails to pay two (2) monthly rental
                payments, the LESSOR is hereby authorized, and the LESSEE agrees, to padlock the leased premises without
                incurring any liability, civil or criminal. It must also be stated here that your security deposit with Us
                cannot be applied to or answer for any unpaid monthly rentals, electricity or water bills at this time.
            </p>
            <p class="mt-2 text-gray-700">
                Accordingly, We demand that you pay in cash or issue checks in the total amount as shown above on or
                before _________________ from receipt of this notice. Otherwise, much to our regret, We will be constrained
                to take appropriate action against you, which includes the possible padlocking of your premises and/or
                cutting off your water or electricity connection with Us, without prejudice to other further actions as may
                be allowed by law.
            </p>
        </div>

        <div class="mt-8">
            <div class="flex justify-between mb-4">
                <div>
                    <p class="font-bold">Prepared by:</p>
                    <p class="mt-2">Theresa G. Sabate</p>
                    <p>Admin Staff</p>
                </div>
                <div>
                    <p class="font-bold">Noted by:</p>
                    <p class="mt-2">Heracleo S. Roque</p>
                    <p>Lessor</p>
                </div>
            </div>

            <div class="mt-4">
                <p class="font-bold">Received By:</p>
                <p class="mt-2">________________________</p>
                <p class="text-gray-700">Signature over Printed Name</p>
            </div>
        </div>
    </div>
    <div class="mt-4 text-center">
        <button onclick="window.print()" class="px-4 py-2 font-bold text-white bg-blue-500 rounded hover:bg-blue-700">
            Print Statement
        </button>
    </div>
@endsection