无效的病历ID
';
exit;
}
$sql = "SELECT mr.*, p.name as patient_name, p.gender as patient_gender, p.birth_date, p.phone as patient_phone,
d.name as doctor_name, d.specialty, dept.name as department_name
FROM medical_records mr
JOIN patients p ON mr.patient_id = p.id
JOIN doctors d ON mr.doctor_id = d.id
JOIN departments dept ON mr.department_id = dept.id
WHERE mr.id = $record_id";
$result = mysqli_query($connID, $sql);
if (mysqli_num_rows($result) == 0) {
echo '病历不存在
';
exit;
}
$record = mysqli_fetch_assoc($result);
$status_class = '';
switch($record['status']) {
case '待诊': $status_class = 'status-pending'; break;
case '就诊中': $status_class = 'status-processing'; break;
case '已完成': $status_class = 'status-completed'; break;
}
$age = '';
if($record['birth_date']) {
$today = new DateTime();
$birth = new DateTime($record['birth_date']);
$age = $today->diff($birth)->y . '岁';
}
?>
主诉
未填写'; ?>
现病史
未填写'; ?>
体格检查
未填写'; ?>
诊断
未填写'; ?>
治疗方案
未填写'; ?>
备注
0):
?>
创建时间：