alert('无效的消息ID'); window.location.href='message_list.php';";
exit;
}
// 查询消息
$sql = "SELECT m.*, mr.is_read, mr.read_time
FROM messages m
LEFT JOIN message_recipients mr ON m.id = mr.message_id AND mr.employee_id = $employee_id
WHERE m.id = $message_id AND (m.target_type = 2 OR mr.employee_id = $employee_id)";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) == 0) {
echo "";
exit;
}
$message = mysqli_fetch_assoc($result);
// 如果消息未读，标记为已读
if (!$message['is_read']) {
$check_sql = "SELECT id FROM message_recipients WHERE message_id = $message_id AND employee_id = $employee_id";
$check_result = mysqli_query($conn, $check_sql);
if (mysqli_num_rows($check_result) > 0) {
// 更新已有记录
$update_sql = "UPDATE message_recipients SET is_read = 1, read_time = NOW() WHERE message_id = $message_id AND employee_id = $employee_id";
mysqli_query($conn, $update_sql);
} else if ($message['target_type'] == 2) {
// 全体公告，创建新的接收记录
$insert_sql = "INSERT INTO message_recipients (message_id, employee_id, is_read, read_time, created_at)
VALUES ($message_id, $employee_id, 1, NOW(), NOW())";
mysqli_query($conn, $insert_sql);
}
}
// 获取关联数据
$related_data = [];
if ($message['related_customer_id']) {
$customer_sql = "SELECT id, cs_company FROM customer WHERE id = " . $message['related_customer_id'];
$customer_result = mysqli_query($conn, $customer_sql);
if ($customer = mysqli_fetch_assoc($customer_result)) {
$related_data['customer'] = $customer;
}
}
if ($message['related_order_id']) {
$order_sql = "SELECT id, order_code FROM orders WHERE id = " . $message['related_order_id'];
$order_result = mysqli_query($conn, $order_sql);
if ($order = mysqli_fetch_assoc($order_result)) {
$related_data['order'] = $order;
}
}
// 消息类型和优先级文本
$message_type_text = [
1 => '系统消息',
2 => '客户相关',
3 => '订单相关',
4 => '任务提醒',
5 => '其他'
][$message['message_type']] ?? '未知';
$target_type_text = [
0 => '个人',
1 => '部分群发',
2 => '全体公告'
][$message['target_type']] ?? '未知';
$priority_text = [
0 => '普通',
1 => '重要',
2 => '紧急'
][$message['priority']] ?? '未知';
// 确定优先级样式
$priority_class = [
0 => '',
1 => 'priority-1',
2 => 'priority-2'
][$message['priority']] ?? '';
?>
消息详情