@php
    $moduleName = 'Pharmacy 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.pharmacy') }}" 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 lg:grid-cols-4 gap-4 mb-6">
                <div class="bg-white p-6 rounded-lg shadow-sm border-r-4 border-blue-500">
                    <p class="text-sm text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Total Prescriptions', __('إجمالي الوصفات')) }}</p>
                    <p class="text-2xl font-bold">{{ $totalPrescriptions }}</p>
                </div>
                @foreach($statusBreakdown as $status)
                    @php
                        $borderColor = 'border-yellow-500';
                        if ($status->status == 'dispensed') $borderColor = 'border-green-500';
                        if ($status->status == 'cancelled') $borderColor = 'border-red-500';
                        if ($status->status == 'pending') $borderColor = 'border-blue-500';
                        if ($status->status == 'partially_dispensed') $borderColor = 'border-orange-500';
                    @endphp
                    <div class="bg-white p-6 rounded-lg shadow-sm border-r-4 {{ $borderColor }}">
                        <p class="text-sm text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase(ucfirst($status->status), __(ucfirst($status->status))) }}</p>
                        <p class="text-2xl font-bold">{{ $status->total }}</p>
                    </div>
                @endforeach
            </div>

            <!-- Recent Prescriptions -->
            <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('Recent Prescriptions', __('أحدث الوصفات الطبية')) }}</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('Prescription No.', __('رقم الوصفة')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Patient', __('المريض')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Doctor', __('الطبيب')) }}</th>
                                    <th class="px-6 py-3 text-right text-xs font-medium text-black uppercase">{{ \App\Helpers\TranslationHelper::transFromDatabase('Medications', __('الأدوية')) }}</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($recentPrescriptions as $prescription)
                                    <tr>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm font-medium">{{ $prescription->prescription_number }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm">{{ $prescription->patient->name ?? '---' }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm">{{ $prescription->visit->doctor->name ?? '---' }}</td>
                                        <td class="px-6 py-4 text-sm">
                                            @foreach($prescription->items as $item)
                                                <span class="inline-block bg-gray-100 rounded px-2 py-1 text-xs mb-1">{{ $item->medicine->name ?? 'N/A' }} ({{ $item->quantity }})</span>
                                            @endforeach
                                        </td>
                                        <td class="px-6 py-4 whitespace-nowrap text-sm">{{ $prescription->created_at->format('Y-m-d H:i') }}</td>
                                        <td class="px-6 py-4 whitespace-nowrap">
                                            @php
                                                $statusClass = 'bg-yellow-100 text-yellow-800';
                                                if ($prescription->status == 'dispensed') $statusClass = 'bg-green-100 text-green-800';
                                                if ($prescription->status == 'cancelled') $statusClass = 'bg-red-100 text-red-800';
                                                if ($prescription->status == 'pending') $statusClass = 'bg-blue-100 text-blue-800';
                                                if ($prescription->status == 'partially_dispensed') $statusClass = 'bg-orange-100 text-orange-800';
                                            @endphp
                                            <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full {{ $statusClass }}">
                                                {{ \App\Helpers\TranslationHelper::transFromDatabase(ucfirst($prescription->status), __(ucfirst($prescription->status))) }}
                                            </span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="6" class="px-6 py-4 text-center text-black italic">
                                            {{ \App\Helpers\TranslationHelper::transFromDatabase('No prescriptions found', __('لم يتم العثور على وصفات طبية')) }}
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</x-app-layout>