connect_error) die("Database connection failed");
$mysqli->set_charset("utf8mb4");
// 处理表单提交（保存WiFi配置）
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['device_id'])) {
$deviceId = intval($_POST['device_id']);
$wifiName = $_POST['wifi_name'] ?? '';
$wifiPwd = $_POST['wifi_pwd'] ?? '';
$stmt = $mysqli->prepare("
UPDATE device_config
SET wifi_name=?, wifi_pwd=?
WHERE device_id=?
");
$stmt->bind_param("ssi", $wifiName, $wifiPwd, $deviceId);
$stmt->execute();
$stmt->close();
$success = "保存成功！";
}
// 搜索逻辑
$search_imei = $_GET['search_imei'] ?? '';
$show_all = isset($_GET['show_all']) ? true : false;
// 构建SQL
if ($show_all) {
// 总览：显示所有设备
$sql = "
SELECT d.id, d.imei, d.last_seen, d.online,
ds.ssid_name AS device_ssid, ds.wifi_pwd AS device_pwd,
ds.connect_count, ds.current_ip,
dc.wifi_name AS config_ssid, dc.wifi_pwd AS config_pwd,
dc.next_report_time, dc.wifi_usb_switch, dc.is_open_auth, dc.wifi_status AS config_wifi_status
FROM device d
INNER JOIN device_status ds ON d.id = ds.device_id
LEFT JOIN device_config dc ON d.id = dc.device_id
ORDER BY d.last_seen DESC
";
$result = $mysqli->query($sql);
} elseif (!empty($search_imei)) {
// 搜索单个IMEI
$stmt = $mysqli->prepare("
SELECT d.id, d.imei, d.last_seen, d.online,
ds.ssid_name AS device_ssid, ds.wifi_pwd AS device_pwd,
ds.connect_count, ds.current_ip,
dc.wifi_name AS config_ssid, dc.wifi_pwd AS config_pwd,
dc.next_report_time, dc.wifi_usb_switch, dc.is_open_auth, dc.wifi_status AS config_wifi_status
FROM device d
INNER JOIN device_status ds ON d.id = ds.device_id
LEFT JOIN device_config dc ON d.id = dc.device_id
WHERE d.imei = ?
ORDER BY d.last_seen DESC
");
$stmt->bind_param("s", $search_imei);
$stmt->execute();
$result = $stmt->get_result();
}
?>
设备管理
设备WiFi管理
| IMEI |
最后在线 |
状态 |
当前WiFi |
密码 |
连接数 |
IP地址 |
下发WiFi名 |
下发WiFi密码 |
操作 |
num_rows > 0): ?>
fetch_assoc()): ?>
| 暂无设备 |