connect();
// İstatistikleri getir
try {
// Toplam hasta sayısı
$query = "SELECT COUNT(*) as total FROM patients";
$stmt = $db->prepare($query);
$stmt->execute();
$total_patients = $stmt->fetch(PDO::FETCH_ASSOC)['total'];
// Toplam doktor sayısı
$query = "SELECT COUNT(*) as total FROM doctors";
$stmt = $db->prepare($query);
$stmt->execute();
$total_doctors = $stmt->fetch(PDO::FETCH_ASSOC)['total'];
// Günlük randevu sayısı
$today = date('Y-m-d');
$query = "SELECT COUNT(*) as total FROM appointments WHERE appointment_date = :today";
$stmt = $db->prepare($query);
$stmt->bindParam(':today', $today);
$stmt->execute();
$daily_appointments = $stmt->fetch(PDO::FETCH_ASSOC)['total'];
// Günlük tamamlanan muayene sayısı
$query = "SELECT COUNT(*) as total FROM examinations WHERE examination_date = :today";
$stmt = $db->prepare($query);
$stmt->bindParam(':today', $today);
$stmt->execute();
$daily_examinations = $stmt->fetch(PDO::FETCH_ASSOC)['total'];
// Bugünün randevuları
$query = "SELECT a.id, a.appointment_time, a.status,
p.name AS patient_name, p.surname AS patient_surname,
d.name AS doctor_name, d.surname AS doctor_surname, d.specialty
FROM appointments a
JOIN patients p ON a.patient_id = p.id
JOIN doctors d ON a.doctor_id = d.id
WHERE a.appointment_date = :today
ORDER BY a.appointment_time ASC";
$stmt = $db->prepare($query);
$stmt->bindParam(':today', $today);
$stmt->execute();
$today_appointments = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch(PDOException $e) {
echo display_error("Veritabanı hatası: " . $e->getMessage());
}
?>