0) {
$check_cfg = $pdo->prepare("SELECT COUNT(*) FROM system_config WHERE agent_id = ?");
$check_cfg->execute([$my_agent_id]);
if ($check_cfg->fetchColumn() == 0) {
// 全新分站初次访问，全自动开辟配置底座并设初值为 1
$init_cfg = $pdo->prepare("INSERT INTO system_config (agent_id, title, notice, total_views) VALUES (?, '全新独立学院楼群中心', '欢迎新同学，请长按下方群码加入官方组织！', 1)");
$init_cfg->execute([$my_agent_id]);
} else {
// 存在历史记录，total_views 物理自增 +1
$update_pv = $pdo->prepare("UPDATE system_config SET total_views = total_views + 1 WHERE agent_id = ?");
$update_pv->execute([$my_agent_id]);
}
}
// ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
// 🏢 楼栋独立点击流水采集接口：承接前端 1.5 秒倒计时期间发来的计数请求
// ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
if (isset($_GET['action']) && $_GET['action'] == 'click_building') {
$b_id = isset($_GET['b_id']) ? intval($_GET['b_id']) : 0;
if ($b_id > 0) {
// 死锁当前选定的楼号，让它的被点击次数 click_views 实时自增 +1
$update_click = $pdo->prepare("UPDATE dorm_building SET click_views = click_views + 1 WHERE id = ?");
$update_click->execute([$b_id]);
echo json_encode(['status' => 'success']);
}
exit; // 采集流结束，切断后续 HTML 渲染输出
}
// 2. 严格按当前的学校 ID 拉取对应的全局配置、轮播图和大版块
$config = $pdo->prepare("SELECT * FROM system_config WHERE agent_id = ? LIMIT 1");
$config->execute([$my_agent_id]);
$config = $config->fetch() ?: ['title'=>'新一代楼群导航中心', 'notice'=>'', 'total_views' => 0];
$zones = $pdo->prepare("SELECT * FROM dorm_zone WHERE agent_id = ? ORDER BY sort_order ASC");
$zones->execute([$my_agent_id]);
$zones = $zones->fetchAll();
$banners = $pdo->prepare("SELECT * FROM system_banners WHERE agent_id = ? ORDER BY sort_order ASC, id DESC");
$banners->execute([$my_agent_id]);
$banners = $banners->fetchAll();
// 3. 隔离拉取楼宇群码
$buildings = $pdo->prepare("SELECT * FROM dorm_building WHERE agent_id = ? ORDER BY sort_order ASC");
$buildings->execute([$my_agent_id]);
$buildings = $buildings->fetchAll();
$zone_buildings = [];
foreach ($buildings as $b) {
$z_key = trim((string)$b['zone_id']);
$zone_buildings[$z_key][] = $b;
}
$cache_buster = time();
?>
<?php echo htmlspecialchars($config['title']); ?>
![]()
💡 长按图片 识别二维码进群