0) {
$countSql .= " AND m.message_type = $message_type";
}
if ($is_read >= 0) {
$countSql .= " AND mr.is_read = $is_read";
}
if ($priority >= 0) {
$countSql .= " AND m.priority = $priority";
}
// 添加关键词搜索条件
if (!empty($keyscode)) {
$countSql .= " AND (m.title LIKE '%$keyscode%' OR m.content LIKE '%$keyscode%')";
}
$countResult = mysqli_query($conn, $countSql);
$countRow = mysqli_fetch_assoc($countResult);
$totalRecords = $countRow['total'];
// 计算总页数
$totalPages = ceil($totalRecords / $pageSize);
if ($totalPages < 1) $totalPages = 1;
// 验证当前页码
$page = (int)$page;
if ($page < 1) $page = 1;
if ($page > $totalPages) $page = $totalPages;
// 计算起始记录
$offset = ($page - 1) * $pageSize;
// 添加分页条件
$sql .= " LIMIT $offset, $pageSize";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$tempNum = ($page - 1) * $pageSize;
while ($row = mysqli_fetch_assoc($result)) {
$tempNum++;
// 确定消息状态
$is_read_status = $row['is_read'] ?? 0;
// 确定消息类型
$message_type_text = [
1 => '系统消息',
2 => '客户相关',
3 => '订单相关',
4 => '任务提醒',
5 => '其他'
][$row['message_type']] ?? '未知';
// 确定优先级
$priority_class = [
0 => '',
1 => 'priority-1',
2 => 'priority-2'
][$row['priority']] ?? '';
$priority_text = [
0 => '普通',
1 => '重要',
2 => '紧急'
][$row['priority']] ?? '未知';
// 行样式类，未读消息加粗显示
$row_class = $is_read_status ? '' : 'unread';
?>
当前暂无消息记录
1) {
$pageName = "?$urlStr&";
if ($pageName == "?&") {
$pageName = "?";
}
$pageLen = 3;
if ($page > 1) {
echo "
首页";
echo "
上一页";
}
if ($pageLen * 2 + 1 >= $totalPages) {
$startPage = 1;
$endPage = $totalPages;
} else {
if ($page <= $pageLen + 1) {
$startPage = 1;
$endPage = $pageLen * 2 + 1;
} else {
$startPage = $page - $pageLen;
$endPage = $page + $pageLen;
}
if ($page + $pageLen > $totalPages) {
$startPage = $totalPages - $pageLen * 2;
$endPage = $totalPages;
}
}
for ($i = $startPage; $i <= $endPage; $i++) {
if ($i == $page) {
echo "
$i";
} else {
echo "
$i";
}
}
if ($page < $totalPages) {
if ($totalPages - $page > $pageLen) {
echo "
...$totalPages";
}
echo "
下一页";
echo "
尾页";
}
}
?>