prepare(
"SELECT
pv.id as visit_id,
pv.status,
pv.notes,
p.id as patient_id,
p.patient_id as patient_system_id,
p.patient_name
FROM patient_visits pv
JOIN patients p ON pv.patient_id = p.id
WHERE pv.doctor_id = ? AND DATE(pv.visit_time) = CURDATE()
ORDER BY pv.visit_time DESC"
);
$stmt->execute([$doctor_id]);
$visits = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$visits = [];
// In a real app, you'd want to log this error
}
// Fetch doctor's details from users table
try {
$pdo = db();
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$doctor_id]);
$doctor = $stmt->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$doctor = null;
}
?>
Doctor's Dashboard
Doctor's Dashboard
Welcome, Dr. !
Today's Appointments
Patient ID
Name
Status
Action
No patients assigned for today.
Add Prescription
Order Tests
Start Consultation';
break;
case 'In Progress':
// The form is shown, but we can add a prescribe button here too
$buttons .= '';
$buttons .= ' ';
break;
case 'Completed':
$buttons .= 'Completed';
$buttons .= ' ';
$buttons .= ' ';
break;
default:
break;
}
return $buttons;
}
?>