# 删除旧
文件
rm /www/wwwroot/szrengjing.com/admin/credit_log.
php
# 创建新
文件
cat > /www/wwwroot/szrengjing.com/admin/credit_log.
php << 'EOF'
<?
php
define('IN_ECS', true);
require_once('../includes/init.
php');
admin_priv('users_manage');
// 获取参数
$user_id
= !empty($_GET['user_id']) ? intval($_GET['user_id'])
: 0;
$start_date
= !empty($_GET['start_date']) ? $_GET['start_date']
: date('Y
-m
-01');
$end_date
= !empty($_GET['end_date']) ? $_GET['end_date']
: date('Y
-m
-d');
// 查询日志
$sql
= "SELECT l.*, u.user_name AS username
FROM ecs_user_credit_log l
LEFT JOIN ecs_users u ON l.user_id
= u.user_id
WHERE 1
=1";
if ($user_id) {
$sql .
= " AND l.user_id
= '$user_id'";
}
if ($start_date) {
$sql .
= " AND l.created_at >
= '" . $start_date . " 00
:00
:00'";
}
if ($end_date) {
$sql .
= " AND l.created_at <
= '" . $end_date . " 23
:59
:59'";
}
$sql .
= " ORDER BY l.created_at DESC LIMIT 100";
$res
= $db
->query($sql);
$logs
= array();
while ($row
= $db
->fetchRow($res)) {
$logs[]
= $row;
}
?>
<!DOC
TYPE html>
<
html lang
="zh
-CN">
<head>
<meta
charset="
UTF-8" />
<title>📊 用户信用变更日志</title>
<link href
="https
://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel
="stylesheet" />
</head>
<body class
="p
-4">
<h2 class
="mb
-4">🔐 用户信用变更日志</h2>
<!
-- 搜索表单
-->
<form method
="get" class
="mb
-4 bg
-light p
-3 rounded">
<div class
="row g
-3">
<div class
="col
-md
-3">
<label><strong>用户ID：</strong></label>
<input
type="number" name
="user_id" class
="form
-control" value
="<?
= htmlspecialchars($user_id) ?>" placeholder
="请输入用户ID" />
</div>
<div class
="col
-md
-3">
<label><strong>起始日期：</strong></label>
<input
type="date" name
="start_date" class
="form
-control" value
="<?
= $start_date ?>" />
</div>
<div class
="col
-md
-3">
<label><strong>结束日期：</strong></label>
<input
type="date" name
="end_date" class
="form
-control" value
="<?
= $end_date ?>" />
</div>
<div class
="col
-md
-3 d
-flex align
-items
-end">
<button
type="submit" class
="btn btn
-primary w
-100">🔍 查询</button>
</div>
</div>
</form>
<!
-- 数据表格
-->
<table class
="table table
-striped table
-hover">
<thead class
="table
-light">
<tr>
<th>ID</th>
<th>用户ID</th>
<th>用户名</th>
<th>旧分值</th>
<th>新分值</th>
<th>变化值</th>
<th>原因</th>
<th>操作时间</th>
</tr>
</thead>
<tbody>
<?
php if (empty($logs))
: ?>
<tr>
<td colspan
="
8" class
="
text-muted
text-center">🔍 没有找到符合条件的记录。</td>
</tr>
<?
php else
: ?>
<?
php foreach ($logs as $log)
: ?>
<tr>
<td><?
= $log['id'] ?></td>
<td><?
= $log['user_id'] ?></td>
<td><?
= htmlspecialchars($log['username'] ?? '未知') ?></td>
<td><?
= $log['old_score'] ?></td>
<td><?
= $log['new_score'] ?></td>
<td class
="<?
= $log['change_value'] > 0 ? '
text-success'
: ($log['change_value'] < 0 ? '
text-danger'
: '') ?>">
<?
= $log['change_value'] ?>
</td>
<td title
="<?
= htmlspecialchars($log['reason']) ?>">
<?
= strlen($log['reason']) > 50 ? substr(
htmlspecialchars($log['reason']), 0, 50).'...'
: htmlspecialchars($log['reason']) ?>
</td>
<td><?
= $log['created_at'] ?></td>
</tr>
<?
php endforeach; ?>
<?
php endif; ?>
</tbody>
</table>
</body>
</
html>
EOF
打不开
博客内容概述
本文介绍了一个关于信息技术领域的具体案例，并详细探讨了相关的技术细节。
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
