@php
    $moduleName = 'Expense Reports';
    $arName = 'تقارير المصروفات';
@endphp
<x-app-layout>
    <x-slot name="header">
        <h2 class="font-semibold text-xl text-black leading-tight">
            {{ \App\Helpers\TranslationHelper::transFromDatabase($moduleName, __($arName)) }}
        </h2>
    </x-slot>

    <div class="py-12">
        <div class="max-w-7xl mx-auto sm:px-6 lg:px-8">
            <!-- Filter -->
            <div class="bg-white overflow-hidden shadow-sm sm:rounded-lg mb-6">
                <div class="p-6 text-black">
                    <form action="{{ route('healthcare.reports.expenses') }}" method="GET" class="grid grid-cols-1 md:grid-cols-3 gap-4">
                        <div>
                            <label class="block text-sm font-medium text-black">{{ \App\Helpers\TranslationHelper::transFromDatabase('Start Date', __('تاريخ البداية')) }}</label>
                            <input type="date" name="start_date" value="{{ $startDate }}" class="mt-1 block w-full rounded-md border-gray-300 shadow-sm focus:border-red-300 focus:ring focus:ring-red-200 focus:ring-opacity-50">
                        </div>
                        <div>
                            <label class="block text-sm font-medium text-black">{{ \App\Helpers\TranslationHelper::transFromDatabase('End Date', __('تاريخ النهاية')) }}</label>
                            <input type="date" name="end_date" value="{{ $endDate }}" class="mt-1 block w-full rounded-md border-gray-300 shadow-sm focus:border-red-300 focus:ring focus:ring-red-200 focus:ring-opacity-50">
                        </div>
                        <div class="flex items-end">
                            <button type="submit" class="bg-red-600 text-white px-4 py-2 rounded-md hover:bg-red-700 w-full">
                                {{ \App\Helpers\TranslationHelper::transFromDatabase('Filter', __('تصفية')) }}
                            </button>
                        </div>
                    </form>
                </div>
            </div>

            <!-- Stats -->
            <div class="grid grid-cols-1 md:grid-cols-2 gap-4 mb-6">
                <div class="bg-white p-6 rounded-lg shadow-sm border-r-4 border-red-500">
                    <p class="text-sm text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Total Expenses', __('إجمالي المصروفات')) }}</p>
                    <p class="text-2xl font-bold">{{ number_format($totalExpenses, 2) }}</p>
                </div>
                <div class="bg-white p-6 rounded-lg shadow-sm border-r-4 border-green-500">
                    <p class="text-sm text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Total Paid', __('إجمالي المدفوع')) }}</p>
                    <p class="text-2xl font-bold">{{ number_format($totalPaid, 2) }}</p>
                </div>
            </div>

            <!-- Expenses Table -->
            <div class="bg-white overflow-hidden shadow-sm sm:rounded-lg">
                <div class="p-6 text-black">
                    <h3 class="text-lg font-bold mb-4">{{ \App\Helpers\TranslationHelper::transFromDatabase('Latest Supplier Invoices', __('أحدث فواتير الموردين')) }}</h3>
                    <div class="overflow-x-auto">
                        <table class="min-w-full divide-y divide-gray-200">
                            <thead class="bg-gray-50">
                                <tr>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Invoice No.', __('رقم الفاتورة')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Supplier', __('المورد')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Amount', __('المبلغ')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Date', __('التاريخ')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Status', __('الحالة')) }}</th>
                                </tr>
                            </thead>
                            <tbody class="bg-white divide-y divide-gray-200">
                                @forelse($recentInvoices as $invoice)
                                    <tr>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-medium">{{ $invoice->invoice_number }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm">{{ $invoice->supplier->name ?? '---' }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-bold">{{ number_format($invoice->total_amount, 2) }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm">{{ $invoice->invoice_date->format('Y-m-d') }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap">
                                            @php
                                                $statusClass = 'bg-yellow-100 text-yellow-800';
                                                if ($invoice->payment_status == 'paid') $statusClass = 'bg-green-100 text-green-800';
                                                if ($invoice->payment_status == 'unpaid') $statusClass = 'bg-red-100 text-red-800';
                                            @endphp
                                            <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full {{ $statusClass }}">
                                                {{ ucfirst($invoice->payment_status) }}
                                            </span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="5" class="px-6 py-4 text-center text-black italic">
                                            {{ \App\Helpers\TranslationHelper::transFromDatabase('No expense invoices found', __('لم يتم العثور على فواتير مصروفات')) }}
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</x-app-layout>