@extends('layouts.app')

@section('title', 'التقارير والإحصائيات')
@section('page_title', 'التقارير والإحصائيات')

@section('content')
<div class="row mb-4">
    <div class="col-md-3">
        <div class="card bg-primary text-white">
            <div class="card-body">
                <div class="d-flex justify-content-between">
                    <div>
                        <h4>{{ \App\Models\Appointment::whereDate('appointment_date', today())->count() }}</h4>
                        <p class="mb-0">مواعيد اليوم</p>
                    </div>
                    <div class="align-self-center">
                        <i class="fas fa-calendar-day fa-2x"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card bg-success text-white">
            <div class="card-body">
                <div class="d-flex justify-content-between">
                    <div>
                        <h4>{{ \App\Models\Appointment::where('created_at', '>=', now()->subWeek())->count() }}</h4>
                        <p class="mb-0">مواعيد هذا الأسبوع</p>
                    </div>
                    <div class="align-self-center">
                        <i class="fas fa-calendar-week fa-2x"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card bg-warning text-white">
            <div class="card-body">
                <div class="d-flex justify-content-between">
                    <div>
                        <h4>{{ \App\Models\MedicalRecord::count() }}</h4>
                        <p class="mb-0">السجلات الطبية</p>
                    </div>
                    <div class="align-self-center">
                        <i class="fas fa-file-medical fa-2x"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card bg-info text-white">
            <div class="card-body">
                <div class="d-flex justify-content-between">
                    <div>
                        <h4>{{ \App\Models\Prescription::where('is_active', true)->count() }}</h4>
                        <p class="mb-0">الوصفات النشطة</p>
                    </div>
                    <div class="align-self-center">
                        <i class="fas fa-prescription fa-2x"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-md-8">
        <div class="card">
            <div class="card-header">
                <h5 class="card-title mb-0">إحصائيات المواعيد الشهرية</h5>
            </div>
            <div class="card-body">
                <canvas id="appointmentsChart" height="100"></canvas>
            </div>
        </div>
        
        <div class="card mt-3">
            <div class="card-header">
                <h5 class="card-title mb-0">أكثر الأطباء نشاطاً</h5>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-striped">
                        <thead>
                            <tr>
                                <th>اسم الطبيب</th>
                                <th>عدد المواعيد</th>
                                <th>عدد المرضى</th>
                                <th>السجلات الطبية</th>
                                <th>معدل النشاط</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $doctors = \App\Models\User::where('role', 'doctor')
                                    ->withCount(['doctorAppointments', 'doctorMedicalRecords'])
                                    ->orderBy('doctor_appointments_count', 'desc')
                                    ->get();
                            @endphp
                            @foreach($doctors as $doctor)
                            <tr>
                                <td>د. {{ $doctor->name }}</td>
                                <td>{{ $doctor->doctor_appointments_count }}</td>
                                <td>{{ $doctor->doctorAppointments()->distinct('patient_id')->count() }}</td>
                                <td>{{ $doctor->doctor_medical_records_count }}</td>
                                <td>
                                    @php
                                        $activity = $doctor->doctor_appointments_count > 0 ? 
                                            round(($doctor->doctor_medical_records_count / $doctor->doctor_appointments_count) * 100) : 0;
                                    @endphp
                                    <div class="progress" style="height: 20px;">
                                        <div class="progress-bar" role="progressbar" style="width: {{ $activity }}%">
                                            {{ $activity }}%
                                        </div>
                                    </div>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    
    <div class="col-md-4">
        <div class="card">
            <div class="card-header">
                <h5 class="card-title mb-0">توزيع المستخدمين</h5>
            </div>
            <div class="card-body">
                <canvas id="usersChart"></canvas>
            </div>
        </div>
        
        <div class="card mt-3">
            <div class="card-header">
                <h5 class="card-title mb-0">حالة المواعيد</h5>
            </div>
            <div class="card-body">
                @php
                    $appointmentStatuses = [
                        'مؤكد' => \App\Models\Appointment::where('status', 'مؤكد')->count(),
                        'في الانتظار' => \App\Models\Appointment::where('status', 'في الانتظار')->count(),
                        'مكتمل' => \App\Models\Appointment::where('status', 'مكتمل')->count(),
                        'ملغي' => \App\Models\Appointment::where('status', 'ملغي')->count(),
                        'جديد' => \App\Models\Appointment::where('status', 'جديد')->count(),
                    ];
                @endphp
                @foreach($appointmentStatuses as $status => $count)
                <div class="d-flex justify-content-between align-items-center mb-2">
                    <span>{{ $status }}</span>
                    <span class="badge 
                        @if($status == 'مؤكد') bg-success
                        @elseif($status == 'في الانتظار') bg-warning
                        @elseif($status == 'مكتمل') bg-info
                        @elseif($status == 'ملغي') bg-danger
                        @else bg-secondary
                        @endif
                    ">{{ $count }}</span>
                </div>
                @endforeach
            </div>
        </div>
        
        <div class="card mt-3">
            <div class="card-header">
                <h5 class="card-title mb-0">إحصائيات سريعة</h5>
            </div>
            <div class="card-body">
                <div class="mb-3">
                    <h6>متوسط المواعيد اليومية</h6>
                    <h4 class="text-primary">{{ round(\App\Models\Appointment::count() / max(\App\Models\Appointment::selectRaw('DATEDIFF(MAX(appointment_date), MIN(appointment_date)) + 1 as days')->value('days'), 1)) }}</h4>
                </div>
                <div class="mb-3">
                    <h6>أكثر الأيام نشاطاً</h6>
                    <h4 class="text-success">
                        @php
                            $busiestDay = \App\Models\Appointment::selectRaw('DAYNAME(appointment_date) as day_name, COUNT(*) as count')
                                ->groupBy('day_name')
                                ->orderBy('count', 'desc')
                                ->first();
                        @endphp
                        {{ $busiestDay ? $busiestDay->day_name : 'N/A' }}
                    </h4>
                </div>
                <div class="mb-3">
                    <h6>معدل إكمال المواعيد</h6>
                    @php
                        $totalAppointments = \App\Models\Appointment::count();
                        $completedAppointments = \App\Models\Appointment::where('status', 'مكتمل')->count();
                        $completionRate = $totalAppointments > 0 ? round(($completedAppointments / $totalAppointments) * 100) : 0;
                    @endphp
                    <h4 class="text-info">{{ $completionRate }}%</h4>
                </div>
            </div>
        </div>
    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
// Appointments Chart
const appointmentsCtx = document.getElementById('appointmentsChart').getContext('2d');
new Chart(appointmentsCtx, {
    type: 'line',
    data: {
        labels: ['يناير', 'فبراير', 'مارس', 'أبريل', 'مايو', 'يونيو', 'يوليو', 'أغسطس', 'سبتمبر', 'أكتوبر', 'نوفمبر', 'ديسمبر'],
        datasets: [{
            label: 'المواعيد',
            data: [12, 19, 3, 5, 2, 3, 7, 8, 9, 10, 11, 13],
            borderColor: 'rgb(75, 192, 192)',
            backgroundColor: 'rgba(75, 192, 192, 0.1)',
            tension: 0.1
        }]
    },
    options: {
        responsive: true,
        plugins: {
            legend: {
                display: false
            }
        }
    }
});

// Users Chart
const usersCtx = document.getElementById('usersChart').getContext('2d');
new Chart(usersCtx, {
    type: 'doughnut',
    data: {
        labels: ['مرضى', 'أطباء', 'موظفي استقبال', 'مديرين'],
        datasets: [{
            data: [
                {{ \App\Models\User::where('role', 'patient')->count() }},
                {{ \App\Models\User::where('role', 'doctor')->count() }},
                {{ \App\Models\User::where('role', 'receptionist')->count() }},
                {{ \App\Models\User::where('role', 'admin')->count() }}
            ],
            backgroundColor: [
                '#17a2b8',
                '#28a745', 
                '#ffc107',
                '#dc3545'
            ]
        }]
    },
    options: {
        responsive: true,
        plugins: {
            legend: {
                position: 'bottom'
            }
        }
    }
});
</script>
@endsection