@extends('layouts.app')

@section('page-title', 'Total Rent')

@section('content')
<div class="row">
    <div class="col-xl-12">
        <div class="card">
            <div class="card-header border-0 pb-0">
                <div class="d-flex align-items-center justify-content-between">
                    <h4 class="card-title mb-0">Total Rent: Rs {{ number_format($totalRent, 2) }}</h4>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="display table table-borderless table-lg" id="rentGymsTable">
                        <thead>
                            <tr>
                                <th>Gym Name</th>
                                <th>City</th>
                                <th>Monthly Rent</th>
                                <th>Last Payment</th>
                                <th>Next Payment Due</th>
                                <th>Total Paid</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($rentGyms as $gym)
                            <tr>
                                <td>{{ $gym->name }}</td>
                                <td>{{ $gym->city ?? 'N/A' }}</td>
                                <td>Rs {{ number_format($gym->rent_amount, 2) }}</td>
                                <td>
                                    @if($gym->rentPayments->where('status', 'paid')->count() > 0)
                                        {{ $gym->rentPayments->where('status', 'paid')->sortByDesc('payment_date')->first()->payment_date->format('M d, Y') }}
                                    @else
                                        <span class="text-muted">No payment yet</span>
                                    @endif
                                </td>
                                <td>
                                    @if($gym->rentPayments->where('status', 'paid')->count() > 0)
                                        {{ $gym->rentPayments->where('status', 'paid')->sortByDesc('payment_date')->first()->next_payment_due_date?->format('M d, Y') ?? 'N/A' }}
                                    @else
                                        <span class="text-danger">Due Now</span>
                                    @endif
                                </td>
                                <td>Rs {{ number_format($gym->rentPayments->where('status', 'paid')->sum('amount'), 2) }}</td>
                                <td>
                                    <a href="{{ route('rent-payments.create-for-gym', $gym->id) }}" class="btn btn-primary btn-sm">
                                        <i class="fas fa-money-bill"></i> Mark Paid
                                    </a>
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="7" class="text-center">No rent gyms found.</td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script src="{{ asset('assets/vendor/datatables/js/jquery.dataTables.bundle.min.js') }}"></script>
<script>
    $(document).ready(function() {
        $('#rentGymsTable').DataTable({
            responsive: true,
            order: [[0, 'asc']],
            pageLength: 25,
            searching: true,
            search: {
                caseInsensitive: true,
                smart: true
            },
            language: {
                search: "Search:",
                searchPlaceholder: "Search gyms..."
            },
            dom: '<"row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>rt<"row"<"col-sm-12 col-md-5"i><"col-sm-12 col-md-7"p>>'
        });
    });
</script>
@endpush