@extends('layouts.sidebar')

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

            .print-content,
            .print-content * {
                visibility: visible;
                font-size: 10px;
                /* Maintain small font size */
            }

            .print-content {
                position: absolute;
                left: 0;
                top: 0;
                width: 210mm;
                /* A4 width */
                height: 297mm;
                /* A4 height */
                padding: 10mm;
                /* Reduce padding to create more space */
                box-sizing: border-box;
                margin: 0;
                /* Remove default margin */
            }

            .print-header {
                font-size: 10px;
                /* Smaller font size for header */
                font-weight: bold;
                margin-bottom: 2mm;
                /* Minimal bottom margin for header */
                text-align: center;
            }

            .print-content table {
                width: 100%;
                border-collapse: collapse;
            }

            .print-content table th,
            .print-content table td {
                padding: 2px;
                /* Keep padding compact */
                border: 1px solid black;
                /* Maintain border for clarity */
                text-align: left;
            }

            .print-footer {
                position: fixed;
                bottom: 5mm;
                /* Reduce margin at bottom */
                width: 100%;
                text-align: center;
                font-size: 10px;
                margin-top: 2mm;
                /* Minimize space above the footer */
            }
        }
    </style>

    @php

    @endphp
    <div class="flex justify-center gap-10 mt-4">
        <form method="GET" action="" class="mb-4">
            <div class="flex items-center space-x-4">
                <label for="status" class="block text-sm font-medium text-gray-700">Filter by Status:</label>
                <select name="status" id="status" class="px-3 py-2 border border-gray-300 rounded-md">
                    <option value="">Select Status</option>
                    <option value="Paid" {{ request('status') == 'Paid' ? 'selected' : '' }}>Paid</option>
                    <option value="Unpaid" {{ request('status') == 'Unpaid' ? 'selected' : '' }}>Unpaid</option>
                </select>
                <button type="submit" class="h-10 px-4 font-bold text-white bg-blue-500 rounded hover:bg-blue-700">
                    Filter
                </button>
            </div>
        </form>

        <button onclick="window.print()" class="h-10 px-4 font-bold text-white bg-blue-500 rounded hover:bg-blue-700">
            Print Statement
        </button>
    </div>
    <div class="max-w-4xl p-8 mx-auto mt-8 text-sm text-gray-800 bg-white rounded shadow-lg print-content">
        <!-- Header Section -->
        <div class="mb-8 text-center">
            <h1 class="text-2xl font-bold">RWEB Solutions Corp.</h1>
            <p>Airpro BLDG., Bacaca, Davao City</p>
            <p>Email: <a href="mailto:srhimgr@yahoo.com" class="text-blue-500">srhimgr@yahoo.com</a> | Tel: (082)299-4103 |
                Cell #: 0###-###-#### | TIN: ###-###-###</p>
            <hr class="my-4">
        </div>

        <!-- Recipient Information -->
        <div class="mb-4">
            <p class="font-bold">{{ $data->lease->client->owners_name }}</p>
            <p>Owners Name</p>
            <p>{{ $data->lease->client->business_name }}</p>
            <p>{{ $data->lease->unit->unit_name }} & {{ $data->lease->property->property_name }}</p>
            <p>{{ $data->lease->property->street_address }}, {{ $data->lease->property->city }},
                {{ $data->lease->property->state }}, {{ $data->lease->property->zip }}</p>
        </div>

        @php
            // Use Carbon to handle date comparisons

            // Debugging: Output the payment date and the current date
            // Uncomment the next lines for debugging
            // dd($paymentDate, $currentDate, $diffInMonths, $isUpcoming);

            // Check for any unpaid history in past payments
            $hasUnpaidHistory = false;

            foreach ($data1 as $d2) {
                $paymentDate = \Carbon\Carbon::parse($d2->payment_date);
                $currentDate = \Carbon\Carbon::now();
                $diffInMonths = $currentDate->diffInMonths($paymentDate);
                $isUpcoming = $paymentDate->isFuture(); // Check if payment date is in the future
                // Assuming each $d2 has a 'status' field
                if (strcasecmp($d2->status, 'Unpaid') === 0 && \Carbon\Carbon::parse($d2->payment_date)->isPast()) {
                    $hasUnpaidHistory = true; // Set flag if any unpaid payment is found in the past
                    break; // No need to continue looping if we found at least one unpaid payment
                }
            }
        @endphp

        @if ($diffInMonths >= 2 && $diffInMonths <= 3)
            <h2 class="text-2xl font-semibold">Demand Letter</h2>
        @elseif($diffInMonths < 1 || $isUpcoming)
            <p class="text-xl font-bold">STATEMENT OF ACCOUNT</p>
        @elseif($hasUnpaidHistory)
            <p class="text-xl font-bold">Foreclosure Notice</p>
        @else
            <p class="text-xl font-bold">No action required at this time.</p>
        @endif

        <!-- Statement Date -->
        <div class="mb-4">
            <p class="font-bold"> {{ date('F j, Y', strtotime($data->payment_date)) }}</p>
        </div>

        <!-- Greetings -->
        <div class="mb-8">
            <p>Madam:</p>
            <p>Greetings!</p>
            @if ($diffInMonths >= 2 && $diffInMonths <= 3)
                <p> This is to inform you of your unpaid monthly rentals in the total amount as shown in the computation
                    below:</p>
            @elseif($diffInMonths < 1 || $isUpcoming)
                <p>Please be informed of your monthly rental obligation as shown below:</p>
            @elseif($hasUnpaidHistory)
                <p>This is to inform you of your unpaid monthly rentals and utility bills as detailed below</p>
            @endif
            <table class="w-full mt-10 border border-collapse border-gray-200">
                <thead>
                    <tr class="bg-gray-200">
                        <th class="px-4 py-2 border border-gray-300 text-start">Description</th>
                    </tr>
                </thead>
                <tbody>

                    @php

                        $total1 = 0; // Initialize the total before the loop starts
                    @endphp

                    @foreach ($data1 as $d1)
                        @php
                            $penaltyPerMonth = 0.02;
                            $escalatedRent = $d1->lease->getEscalatedRentAmount($d1->payment_date);
                            $currentDate = \Carbon\Carbon::now();
                            $paymentDate = \Carbon\Carbon::parse($d1->payment_date);
                            $penalty = 0.0;
                            $totalElectric = $d1->electricPayments->sum('amount');
                            $totalWater = $d1->waterPayments->sum('amount');
                            $totalUtility = $totalElectric + $totalWater;

                            $penaltyEndDate = $d1->newPayments
                                ->filter(function ($newPayment) {
                                    // Check if remarks is not null and starts with 'fp rent'
                                    return $newPayment->remarks == null ||
                                        strpos($newPayment->remarks, 'fp rent') === 0;
                                })
                                ->max('date_of_payment');

                            if ($penaltyEndDate && $d1->newPayments->max('status') !== '1' && $d1->status === 'Paid') {
                                $penaltyEndDate = \Carbon\Carbon::parse($penaltyEndDate);
                            } else {
                                $penaltyEndDate = $currentDate;
                            }
                            $penaltyutilityEndDate = $d1->newPayments->max('date_of_utilitypayment');

                            if ($penaltyutilityEndDate && $d1->status === 'Paid') {
                                $penaltyutilityEndDate = \Carbon\Carbon::parse($penaltyutilityEndDate);
                            } else {
                                $penaltyutilityEndDate = $currentDate;
                            }

                            $penaltyElectric = 0;
                            $penaltyWater = 0;
                            $penaltyRent = 0;

                            if ($client->penalty === 'yes') {
                                if ($penaltyEndDate->greaterThan($paymentDate)) {
                                    $monthsOverdue = $paymentDate->diffInMonths($penaltyEndDate);
                                    if ($escalatedRent > 0) {
                                        $penaltyRent = $escalatedRent * $penaltyPerMonth * $monthsOverdue;
                                        $total1 += $penaltyRent;
                                    }
                                }
                                if ($penaltyutilityEndDate->greaterThan($paymentDate)) {
                                    $monthsutilityOverdue = $paymentDate->diffInMonths($penaltyutilityEndDate);
                                    if ($totalElectric > 0) {
                                        $penaltyElectric = $totalElectric * $penaltyPerMonth * $monthsutilityOverdue;
                                        $total1 += $penaltyElectric;
                                    }
                                    if ($totalWater > 0) {
                                        $penaltyWater = $totalWater * $penaltyPerMonth * $monthsutilityOverdue;
                                        $total1 += $penaltyWater;
                                    }
                                }
                            }

                        @endphp
                        <tr>
                            <td class="px-4 py-2 border border-gray-300">

                                Rent due for {{ date('F j, Y', strtotime($d1->payment_date)) }} -
                                {{ date('F j, Y', strtotime($d1->payment_date . ' +1 month')) }}







                                @php

                                    $total1 += $escalatedRent;
                                @endphp
                                ₱{{ number_format($escalatedRent, 2) }}
                            </td>
                        </tr>
                        <tr>
                            <td class="px-4 py-2 border border-gray-300">
                                Penalty:

                                ₱{{ number_format($penaltyRent, 2) }}
                            </td>
                        </tr>

                        <!-- Water Payments -->
                        @forelse ($d1->waterPayments as $waterbill)
                            <tr>
                                <td class="px-4 py-2 border border-gray-300">
                                    Water bill ({{ \Carbon\Carbon::parse($waterbill->start_date)->format('F j, Y') }} to
                                    {{ \Carbon\Carbon::parse($waterbill->end_date)->format('F j, Y') }}):
                                    ₱{{ number_format($waterbill->amount, 2) }}
                                    @php
                                        $total1 += $waterbill->amount; // Add water bill to total
                                    @endphp
                                </td>
                            </tr>
                        @empty
                        @endforelse

                        <!-- Electric Payments -->
                        @forelse ($d1->electricPayments as $electricbill)
                            <tr>
                                <td class="px-4 py-2 border border-gray-300">
                                    Electric bill ({{ \Carbon\Carbon::parse($electricbill->start_date)->format('F j, Y') }}
                                    to
                                    {{ \Carbon\Carbon::parse($electricbill->end_date)->format('F j, Y') }}):
                                    ₱{{ number_format($electricbill->amount, 2) }}
                                    @php
                                        $total1 += $electricbill->amount; // Add electric bill to total
                                    @endphp
                                </td>
                            </tr>
                            <tr>
                                <td class="px-4 py-2 border border-gray-300">
                                    W/E Penalty:

                                    ₱{{ number_format($penaltyElectric + $penaltyWater, 2) }}
                                </td>
                            </tr>
                        @empty
                        @endforelse

                        <!-- Additional Fees -->
                        @forelse ($d1->additionalFees as $fee)
                            <tr>
                                <td class="px-4 py-2 border border-gray-300">
                                    {{ $fee->charge_type }}: ₱{{ number_format($fee->amount, 2) }}
                                    @php
                                        $total1 += $fee->amount; // Add additional fees to total
                                    @endphp
                                </td>
                            </tr>
                        @empty
                        @endforelse
                    @endforeach
                    <tr class="font-bold">
                        <td class="px-4 py-2 border border-gray-300">Grand Total: ₱{{ number_format($total1, 2) }}
                        </td>
                    </tr>
                </tbody>
            </table>

            <!-- Notes -->
            <div class="mt-8 mb-8">
                <p>Note: {{ $data->billing_notes }}</p>
            </div>

            @if ($diffInMonths >= 2 && $diffInMonths <= 3)
                <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>
            @elseif($diffInMonths < 1 || $isUpcoming)
                <div class="mt-8">
                    <p>Thank you for your prompt attention to this matter.</p>
                    <p class="mt-4 font-bold">Very truly yours,</p>
                    <p class="mt-4">San Roque Hermanas Inc.</p>
                </div>
            @elseif($hasUnpaidHistory)
                <p>Kindly settle the payment by the due date to avoid further penalties. For any questions, please contact
                    our office.</p>

                <p>Thank you for your prompt attention to this matter.</p>
            @endif

        </div>
    </div>
@endsection