@extends('layouts.sidebar')

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

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

            .print-content {
                position: absolute;
                left: 0;
                top: 0;
                width: 250mm;
                /* A4 width */
                height: 350mm;
                /* A4 height */

                /* 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="container px-4 py-8 mx-auto ">
        <h1 class="mb-4 text-2xl font-extrabold">Monthly Report</h1>

        <!-- Filter Form -->
        <div class="w-full rounded-lg shadow-sm bg-gray-50 ">
            <form method="GET" action="{{ route('monthlyrevenue') }}" class="mb-6">
                <h2 class="mb-4 text-xl font-semibold">Filter Criteria</h2>
                <div class="grid grid-cols-3 gap-4">

                    <!-- Month Selection -->
                    <div class="flex flex-col">
                        <label for="month" class="mb-1 text-sm font-medium text-gray-700">Month:</label>
                        <select name="month" id="month"
                            class="block w-full px-3 py-2 bg-white border border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm">
                            @foreach (range(1, 12) as $m)
                                <option value="{{ $m }}"
                                    {{ $m == old('month', request('month', date('n'))) ? 'selected' : '' }}>
                                    {{ \DateTime::createFromFormat('!m', $m)->format('F') }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <!-- Year Selection -->
                    <div class="flex flex-col">
                        <label for="year" class="mb-1 text-sm font-medium text-gray-700">Year:</label>
                        <select name="year" id="year"
                            class="block w-full px-3 py-2 bg-white border border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm">
                            @php
                                $currentYear = now()->year;
                                $startYear = $currentYear - 10;
                                $endYear = $currentYear + 10; // Adjust the end year as needed
                                $selectedYear = request('year', $currentYear); // Use the request value, fallback to current year
                            @endphp
                            @for ($year = $startYear; $year <= $endYear; $year++)
                                <option value="{{ $year }}" {{ $year == $selectedYear ? 'selected' : '' }}>
                                    {{ $year }}
                                </option>
                            @endfor
                        </select>
                    </div>

                    <div class="flex flex-col">
                        <label for="property" class="mb-1 text-sm font-medium text-gray-700">Properties:</label>
                        <select name="property_ids[]" id="property" multiple
                            class="block w-full px-3 py-2 bg-white border border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm">
                            @foreach ($properties as $property)
                                <option value="{{ $property->id }}"
                                    {{ in_array($property->id, old('property_ids', request()->input('property_ids', []))) ? 'selected' : '' }}>
                                    {{ $property->property_name }}
                                </option>
                            @endforeach
                        </select>
                        <p class="my-2 text-xs text-gray-500">Hold down the Ctrl (Windows) or Command (Mac) key to select
                            multiple properties.</p>
                    </div>
                    <div class="mt-6 ">
                        <button type="submit"
                            class="px-4 py-2 font-semibold text-white bg-blue-600 rounded-md shadow-sm hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500">
                            Filter
                        </button>
                    </div>
                </div>
            </form>

        </div>

        <div class="print-content">

            <div class="col-span-2 p-4 rounded-lg shadow-sm bg-gray-50">
                @if (request()->has('month') && request()->has('year') && request()->has('property_ids'))
                    @php
                        $month = request('month');
                        $year = request('year');
                    @endphp

                    @foreach ($properties as $property)
                        @if (in_array($property->id, request('property_ids')))
                            <div class="overflow-x-auto">
                                <h2 class="mb-4 text-xl font-bold text-gray-800">{{ $property->property_name }}</h2>
                                <p class="text-sm text-gray-700">Month:
                                    {{ \DateTime::createFromFormat('!m', $month)->format('F') }}</p>
                                <p class="text-sm text-gray-700">Year: {{ $year }}</p>
                                <table class="w-full bg-white divide-y divide-gray-200" id="sortable-table">
                                    <thead class="text-center bg-gray-100">
                                        <tr>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">Unit</th>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">Names</th>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">Due Date</th>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">Rental Rate
                                            </th>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">Outstanding
                                                Deposit
                                            </th>
                                            <th class="px-4 py-2 text-xs font-medium text-gray-600 uppercase">
                                                Balance/Collectibles
                                            </th>
                                        </tr>
                                    </thead>
                                    @php
                                        $totalrate = 0;
                                        $totalAmount1 = 0;
                                    @endphp

                                    <tbody id="sortable" class="text-center bg-white divide-y divide-gray-200">
                                        @php
                                            $deposit = 0;
                                            $noData = true; // Flag to check if there is any data for the filtered month and year
                                            // Get all units for the given property
                                            $units = \App\Models\Lease::with('property', 'client', 'unit')
                                                ->where('property_id', $property->id)
                                                ->whereHas('unit', function ($q) {
                                                    $q->orderByRaw(
                                                        'CAST(SUBSTRING(unit_name, -1) AS UNSIGNED) ASC, unit_name',
                                                    ); // Order by the last number in the unit name
                                                })
                                                ->get();

                                        @endphp

                                        @forelse ($units as $unit)
                                            @php
                                                // Check if there is a new payment for the current unit
                                                $entry = $newPayments->firstWhere('lease.unit_id', $unit->unit_id);
                                                $totalRent = 0;
                                            @endphp

                                            @if ($entry)
                                                @php
                                                    $noData = false;

                                                    // Ensure entry->lease exists before accessing its properties
                                                    if ($entry->lease) {
                                                        $client = \App\Models\Client::find($entry->lease->client_id);
                                                        $deposit +=
                                                            $entry->lease->security_deposit + $entry->lease->utilities;

                                                        $pastPayments = \App\Models\Payment::with([
                                                            'lease',
                                                            'electricPayments',
                                                            'waterPayments',
                                                            'newPayments',
                                                        ])
                                                            ->where('lease_id', $entry->lease_id)
                                                            ->where('payment_date', '<', $entry->payment_date) // Only past
                                                            ->get();

                                                        // Add current entry manually
                                                        $pastPayments->push($entry);

                                                        $pastPaymentsTotal = $pastPayments->sum(
                                                            callback: function ($payment) use ($client) {
                                                                $total = 0;

                                                                if ($payment instanceof \App\Models\Payment) {
                                                                    $rentAmount = $payment->Amount ;

                                                                    $electricAmount = optional(
                                                                        $payment->electricPayments,
                                                                    )->sum('Amount');
                                                                    $waterAmount = optional(
                                                                        $payment->waterPayments,
                                                                    )->sum('Amount');

                                                                    $totalRent = $rentAmount;
                                                                    $totalElectric = $electricAmount;
                                                                    $totalWater = $waterAmount;

                                                                    $paymentDate = Carbon\Carbon::parse(
                                                                        $payment->payment_date,
                                                                    );
                                                                    $penaltyPerMonth = 0.02;

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

                                                                    if ($client->penalty === 'yes') {
                                                                        // Filter newPayments specific to this payment
                                                                        $relatedNewPayments = $payment->newPayments;

                                                                        // Penalty end dates for rent and utilities
                                                                        $penaltyEndDateRaw =
                                                                            $relatedNewPayments->max('check_date') ??
                                                                            $relatedNewPayments->max('date_of_payment');
                                                                        $penaltyEndDate = $penaltyEndDateRaw
                                                                            ? Carbon\Carbon::parse($penaltyEndDateRaw)
                                                                            : Carbon\Carbon::now();

                                                                        $penaltyUtilityEndDateRaw = $relatedNewPayments->max(
                                                                            'date_of_payment',
                                                                        );
                                                                        $penaltyUtilityEndDate = $penaltyUtilityEndDateRaw
                                                                            ? Carbon\Carbon::parse(
                                                                                $penaltyUtilityEndDateRaw,
                                                                            )
                                                                            : Carbon\Carbon::now();

                                                                        // R E N T   P E N A L T Y
                                                                        $dueDate = $paymentDate
                                                                            ->copy()
                                                                            ->addMonthsNoOverflow(1);

                                                                        if (
                                                                            $payment->type == 'electric' ||
                                                                            $payment->type == 'water'
                                                                        ) {
                                                                            if (
                                                                                $penaltyEndDate->greaterThan(
                                                                                    $paymentDate,
                                                                                )
                                                                            ) {
                                                                                $monthsutilityOverdue = 0;

                                                                                $penaltyStart = $paymentDate
                                                                                    ->copy()
                                                                                    ->addMonths(1)
                                                                                    ->day(8);

                                                                                if ($paymentDate->day <= 8) {
                                                                                    $penaltyStart = $paymentDate
                                                                                        ->copy()
                                                                                        ->addMonths(1)
                                                                                        ->day(8);
                                                                                } else {
                                                                                    // If the payment date is after the 8th, we need to wait for the next 8th
                                                                                    $penaltyStart = $paymentDate
                                                                                        ->copy()
                                                                                        ->addMonths(1)
                                                                                        ->day(8);
                                                                                }

                                                                                // Count how many 8th days have passed
                                                                                while (
                                                                                    $penaltyStart->lessThanOrEqualTo(
                                                                                        $penaltyEndDate,
                                                                                    )
                                                                                ) {
                                                                                    $monthsutilityOverdue++;
                                                                                    $penaltyStart->addMonth(); // Move to the next 8th of the month
                                                                                }

                                                                                if (
                                                                                    $monthsutilityOverdue > 0 &&
                                                                                    $totalRent > 0
                                                                                ) {
                                                                                    $penaltyRent =
                                                                                        $totalRent *
                                                                                        $penaltyPerMonth *
                                                                                        $monthsutilityOverdue;
                                                                                }
                                                                            }
                                                                        } else {
                                                                            if (
                                                                                $penaltyEndDate->greaterThan($dueDate)
                                                                            ) {
                                                                                $monthsOverdue = 0;
                                                                                $currentDueDate = $dueDate->copy();

                                                                                while (
                                                                                    $penaltyEndDate->greaterThan(
                                                                                        date: $currentDueDate,
                                                                                    )
                                                                                ) {
                                                                                    $monthsOverdue++;
                                                                                    $currentDueDate->addMonthsNoOverflow(
                                                                                        1,
                                                                                    );
                                                                                }

                                                                                if (
                                                                                    $monthsOverdue > 0 &&
                                                                                    $totalRent > 0
                                                                                ) {
                                                                                    $penaltyRent =
                                                                                        $totalRent *
                                                                                        $penaltyPerMonth *
                                                                                        $monthsOverdue;
                                                                                }
                                                                            }
                                                                        }
                                                                    }

                                                                    $total =
                                                                        $totalRent +
                                                                        $totalElectric +
                                                                        $totalWater +
                                                                        $penaltyRent +
                                                                        $penaltyElectric +
                                                                        $penaltyWater;
                                                                }

                                                                return $total;
                                                            },
                                                        );

                                                        $pastPaidTotal = \App\Models\Payment::with([
                                                            'lease',
                                                            'electricPayments',
                                                            'newPayments',
                                                            'waterPayments',
                                                        ])
                                                            ->where('lease_id', $entry->lease_id)
                                                            ->where('payment_date', '<=', $entry->payment_date)
                                                            ->get()
                                                            ->sum(function ($payment) {
                                                                $rentalAmount = $payment->newPayments->sum(
                                                                    'rental_amount',
                                                                );
                                                                $electricBillAmount = $payment->newPayments->sum(
                                                                    'electricbill_amount',
                                                                );
                                                                $waterBillAmount = $payment->newPayments->sum(
                                                                    'waterbill_amount',
                                                                );
                                                                return $rentalAmount;
                                                            });

                                                        $totalAmount = $pastPaymentsTotal - $pastPaidTotal;
                                                        $totalAmount1 += $totalAmount;
                                                    }
                                                @endphp


                                                <tr class="draggable-row" draggable="true" ondragstart="dragStart(event)"
                                                    ondragover="dragOver(event)" ondrop="drop(event)"
                                                    ondragend="dragEnd(event)">
                                                    <td>{{ $entry->lease->unit->unit_name }}</td>
                                                    <td>{{ $entry->lease->client->owners_name }}</td>
                                                    <td>{{ \Carbon\Carbon::parse($entry->payment_date)->addMonth()->format('d-M-y') }}
                                                    </td>
                                                    <td>{{ number_format($entry->Amount, 2) }}</td>
                                                    <td>{{ number_format($entry->lease->security_deposit + $entry->lease->utilities, 2) }}
                                                    </td>
                                                    <td>{{ $totalAmount >= 0 ? number_format($totalAmount, 2) : '0.00' }}
                                                    </td>
                                                </tr>
                                            @else
                                                <tr class="draggable-row" draggable="true" ondragstart="dragStart(event)"
                                                    ondragover="dragOver(event)" ondrop="drop(event)"
                                                    ondragend="dragEnd(event)">
                                                    <td>{{ $unit->unit->unit_name }}</td>
                                                    <td>{{ $unit->client->owners_name }}</td>
                                                    @php
                                                        $month = request()->input('month');
                                                        $year = request()->input('year');
                                                        $deposit += $unit->security_deposit + $unit->utilities;
                                                    @endphp
                                                    <td>{{ \Carbon\Carbon::create($year, $month, 1)->addMonth()->format('d-M-y') }}
                                                    </td>
                                                    <td>{{ number_format($unit->rent_amount, 2) }}</td>
                                                    <td>{{ number_format($unit->security_deposit + $unit->utilities, 2) }}
                                                    </td>
                                                    <td>0.00</td>
                                                </tr>
                                            @endif
                                        @empty
                                            @if ($noData)
                                                <tr>
                                                    <td colspan="6" class="text-center">No data available for the
                                                        selected
                                                        filters</td>
                                                </tr>
                                            @endif
                                        @endforelse


                                    </tbody>

                                    <tfoot class="text-center bg-gray-100">
                                        <tr>
                                            <td colspan="3" class="font-medium text-right">Total:</td>
                                            <td>

                                            </td>
                                            <td>
                                                {{ number_format($deposit, 2) }}
                                            </td>

                                            <td>
                                                {{ number_format($totalAmount1, 2) }}
                                            </td>

                                        </tr>
                                    </tfoot>


                                </table>
                        @endif
                    @endforeach
                @endif
            </div>
        </div>
        <style>
            /* Highlight the row being dragged */
            .draggable-row:hover {
                background-color: #f0f0f0;
            }

            /* Visual feedback when hovering over a valid row for drop */
            .draggable-row.over {
                background-color: #e6e6e6;
            }

            /* Optional: Add a semi-transparent effect for the dragged row */
            .dragging {
                opacity: 0.5;
            }

            .tr-draggable:hover {
                background-color: #f0f0f0;
                cursor: move;
            }
        </style>
        <script>
            let draggedRow = null;

            function dragStart(event) {
                draggedRow = event.target; // Store the dragged row
                event.dataTransfer.setData("text/html", event.target.outerHTML); // Store the outer HTML of the dragged row
            }

            function dragOver(event) {
                event.preventDefault(); // Allow drop
                let targetRow = event.target.closest('tr');
                if (targetRow && targetRow !== draggedRow) {
                    // Highlight the target row while dragging
                    targetRow.classList.add("bg-gray-200");
                }
            }

            function drop(event) {
                event.preventDefault();
                let targetRow = event.target.closest('tr');
                if (targetRow && targetRow !== draggedRow) {
                    targetRow.classList.remove("bg-gray-200");

                    // Get all the rows in the table
                    let rows = Array.from(document.querySelectorAll('#sortable tr'));

                    // Find the indexes of the dragged row and the target row
                    let draggedRowIndex = rows.indexOf(draggedRow);
                    let targetRowIndex = rows.indexOf(targetRow);

                    // If both rows are valid, proceed with swapping
                    if (draggedRowIndex !== -1 && targetRowIndex !== -1) {
                        // If the dragged row is above the target row, move it before the target
                        if (draggedRowIndex < targetRowIndex) {
                            rows[draggedRowIndex].parentNode.insertBefore(rows[draggedRowIndex], rows[targetRowIndex]
                                .nextSibling);
                        }
                        // If the dragged row is below the target row, move it before the target
                        else {
                            rows[draggedRowIndex].parentNode.insertBefore(rows[draggedRowIndex], rows[targetRowIndex]);
                        }
                    }
                }
            }

            function dragEnd(event) {
                event.target.classList.remove("bg-gray-200");
            }
        </script>


    </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
        </button>
    </div>
@endsection