@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="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
                            @endphp
                            @for ($year = $startYear; $year <= $endYear; $year++)
                                <option value="{{ $year }}"
                                    {{ $year == old('year', $currentYear) ? 'selected' : '' }}>
                                    {{ $year }}
                                </option>
                            @endfor
                        </select>
                    </div>
                    <div class="flex flex-col">
                        <label for="year" class="mb-1 text-sm font-medium text-gray-700">Property:</label>

                        <select name="property_id" id="property"
                            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"
                            required>

                            <option value="">Select Property</option>
                            @foreach ($properties as $property)
                                <option value="{{ $property->id }}"
                                    {{ old('property', request()->input('property_id')) == $property->id ? 'selected' : '' }}>
                                    {{ $property->property_name }}
                                </option>
                            @endforeach
                        </select>
                    </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">
                <!-- Display Selected Filter Criteria -->


                <div class="overflow-x-auto">

                    @if ((request('month') && request('year')) || ($property1 && $property1->property_name != null))
                        <p class="text-sm text-gray-700">Month:
                            {{ \DateTime::createFromFormat('!m', request('month'))->format('F') }}</p>
                        <p class="text-sm text-gray-700">Year: {{ request('year') }}</p>
                        <p class="mb-2 text-xl font-bold text-center text-gray-700">
                            {{ $property1->property_name }}</p>
                    @endif
                    @if (request()->has('month') && request()->has('year') && request()->has('property_id'))
                        <table class="w-full bg-white divide-y divide-gray-200" id="sortable-table">
                            <thead class="text-center bg-orange-600">
                                <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', request()->input('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;

                                                // Calculate total payments with penalty if applicable
                                                $pastPaymentsTotal = \App\Models\Payment::with([
                                                    'lease',
                                                    'electricPayments',
                                                    'waterPayments',
                                                    'newPayments',
                                                ])
                                                    ->where('lease_id', $entry->lease_id)
                                                    ->where('payment_date', '<=', $entry->payment_date)
                                                    ->get()
                                                    ->sum(function ($payment) use ($client) {
                                                        // Ensure the lease and payment are valid
                                                        $totalRent = 0;

                                                        // Check if payment is valid before proceeding
                                                        if ($payment instanceof \App\Models\Payment) {
                                                            // Correctly access the lease associated with this payment
                                                            $rentAmount = $payment->Amount;
                                                            $rentAmount = $payment->lease->getEscalatedRentPenaltyAmountWithPenalty(
                                                                $payment->payment_date,
                                                                $payment->lease->escalation ?? 12,
                                                            );

                                                            $totalRent += $rentAmount;
                                                        }

                                                        return $totalRent;
                                                    });

                                                $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 + $electricBillAmount + $waterBillAmount;
                                                    });

                                                $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
                </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