index.php
6.79 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
<?php
require_once __DIR__ . '/../vendor/autoload.php';
// 加载配置 (.env 手动加载逻辑同 start.php)
if (file_exists(__DIR__ . '/../.env')) {
$lines = file(__DIR__ . '/../.env', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
foreach ($lines as $line) {
if (strpos(trim($line), '#') === 0)
continue;
list($name, $value) = explode('=', $line, 2);
$_ENV[trim($name)] = trim($value);
}
}
// 简单的一致性检查 (实际生产环境应加上 Session 登录验证)
// 这里假设通过 Basic Auth 或内网访问
// 连接数据库
try {
$dsn = "mysql:host={$_ENV['DB_HOST']};dbname={$_ENV['DB_NAME']};charset=utf8mb4";
$pdo = new PDO($dsn, $_ENV['DB_USER'], $_ENV['DB_PASS']);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
// 处理绑定表单提交
$message = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'bind') {
$deviceId = trim($_POST['device_id']);
$phone = trim($_POST['phone']);
$isPrimary = isset($_POST['is_primary']) ? 1 : 0;
if ($deviceId && $phone) {
// 1. 查找用户
$stmt = $pdo->prepare("SELECT id, nickname FROM users WHERE phone = ?");
$stmt->execute([$phone]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user) {
// 2. 插入/更新绑定
// 先检查是否已存在
$check = $pdo->prepare("SELECT id FROM user_device_bindings WHERE user_id = ? AND device_id = ?");
$check->execute([$user['id'], $deviceId]);
if (!$check->fetch()) {
$bind = $pdo->prepare("INSERT INTO user_device_bindings (user_id, device_id, is_primary, created_at) VALUES (?, ?, ?, NOW())");
$bind->execute([$user['id'], $deviceId, $isPrimary]);
$message = "<div style='color: green; margin-bottom: 20px;'>✅ 成功将设备 <b>$deviceId</b> 绑定给用户 <b>{$user['nickname']}</b></div>";
} else {
$message = "<div style='color: orange; margin-bottom: 20px;'>⚠️ 该用户已经绑定过此设备，无需重复操作。</div>";
}
} else {
$message = "<div style='color: red; margin-bottom: 20px;'>❌ 手机号 <b>$phone</b> 未找到。请确保用户已在小程序登录过。</div>";
}
}
}
// 获取设备列表 (Mock Data + Binding Count)
// 实际项目应从 Redis 或 devices 表获取在线状态，这里先从 bindings 表反查活跃情况
// 为了简化，我们列出 distinct device_id from bindings，或者列出 bindings
$bindings = $pdo->query("
SELECT b.id, u.nickname, u.phone, b.device_id, b.is_primary, b.created_at
FROM user_device_bindings b
JOIN users u ON b.user_id = u.id
ORDER BY b.created_at DESC
")->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Moltbot 管理后台</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="header">
<div class="brand">Moltbot Admin</div>
<div>
<?php echo date('Y-m-d H:i'); ?>
</div>
</div>
<div class="container">
<?php echo $message; ?>
<!-- 新增绑定卡片 -->
<div class="card">
<div class="title">新增绑定</div>
<form method="POST" action="">
<input type="hidden" name="action" value="bind">
<div style="display: flex; gap: 20px;">
<div class="form-group" style="flex: 1;">
<label class="form-label">设备 ID</label>
<input type="text" name="device_id" class="form-control" placeholder="例如: dev_test_001"
required>
</div>
<div class="form-group" style="flex: 1;">
<label class="form-label">用户手机号</label>
<input type="text" name="phone" class="form-control" placeholder="输入用户注册手机号" required>
</div>
</div>
<div class="form-group">
<label>
<input type="checkbox" name="is_primary" value="1" checked> 设为主设备 (默认)
</label>
</div>
<button type="submit" class="btn btn-primary">立即绑定</button>
</form>
</div>
<!-- 绑定列表卡片 -->
<div class="card">
<div class="title">绑定记录 (
<?php echo count($bindings); ?>)
</div>
<table>
<thead>
<tr>
<th>用户</th>
<th>手机号</th>
<th>设备 ID</th>
<th>主设备</th>
<th>绑定时间</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<?php foreach ($bindings as $row): ?>
<tr>
<td>
<?php echo htmlspecialchars($row['nickname']); ?>
</td>
<td>
<?php echo htmlspecialchars($row['phone']); ?>
</td>
<td>
<?php echo htmlspecialchars($row['device_id']); ?>
</td>
<td>
<?php if ($row['is_primary']): ?>
<span style="color: var(--primary-color);">✔</span>
<?php endif; ?>
</td>
<td>
<?php echo $row['created_at']; ?>
</td>
<td>
<a href="#" style="color: red; font-size: 12px; text-decoration: none;">解绑</a>
</td>
</tr>
<?php endforeach; ?>
<?php if (empty($bindings)): ?>
<tr>
<td colspan="6" style="text-align: center; color: #999;">暂无数据</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</body>
</html>