From cbb26873e88a7a13e868448c1cc578ce70b8c6ae Mon Sep 17 00:00:00 2001
From: 905086 <k2049@qq.com>
Date: Mon, 09 Nov 2026 10:54:51 +0800
Subject: [PATCH] feat: 新增客户端版本管理与下载页,重构配置加载方式

---
 server/admin/index.html |  197 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 191 insertions(+), 6 deletions(-)

diff --git a/server/admin/index.html b/server/admin/index.html
index 3777f69..4666ac4 100644
--- a/server/admin/index.html
+++ b/server/admin/index.html
@@ -99,6 +99,8 @@
       <button data-tab="tools" onclick="switchTab('tools')">工具管理</button>
       <button data-tab="cats" onclick="switchTab('cats')">类别管理</button>
       <button data-tab="ann" onclick="switchTab('ann')">公告设置</button>
+      <button data-tab="reset" onclick="switchTab('reset')">密码重置</button>
+      <button data-tab="versions" onclick="switchTab('versions')">版本管理</button>
     </div>
     <button id="logoutBtn" onclick="logout()">退出登录</button>
   </div>
@@ -175,6 +177,29 @@
         <tbody id="toolTable"></tbody>
       </table>
     </div>
+
+    <!-- 密码重置申请 -->
+    <div id="tab-reset" class="panel hidden">
+      <h2>找回密码申请</h2>
+      <p style="color:#888;font-size:12px;margin-bottom:14px">用户在客户端"找回密码"中提交的申请。点击"同意并重置"为该用户设置新密码(可自定义,至少6位),重置后请将新密码告知用户。</p>
+      <table>
+        <thead><tr><th>ID</th><th>手机号</th><th>期望新密码</th><th>申请时间</th><th>状态</th><th>新密码</th><th>处理时间</th><th>操作</th></tr></thead>
+        <tbody id="resetTable"></tbody>
+      </table>
+    </div>
+
+    <!-- 客户端版本管理 -->
+    <div id="tab-versions" class="panel hidden">
+      <h2>客户端版本管理</h2>
+      <p style="color:#888;font-size:12px;margin-bottom:14px">上传客户端安装包(整个 Release 目录打成的 zip)。最新一条记录会展示在公开下载页 <a href="/download" target="_blank" style="color:#4a92ff">/download</a>,用户无需登录即可下载。</p>
+      <div class="toolbar">
+        <button class="btn" onclick="showVersionModal()">+ 上传新版本</button>
+      </div>
+      <table>
+        <thead><tr><th>ID</th><th>版本号</th><th>文件大小</th><th>更新说明</th><th>下载次数</th><th>发布时间</th><th>操作</th></tr></thead>
+        <tbody id="versionTable"></tbody>
+      </table>
+    </div>
   </div>
 </div>
 
@@ -188,8 +213,8 @@
       <div class="form-row"><label>类别</label><select id="g_category"></select></div>
       <div class="form-row"><label>平台</label><select id="g_platform"><option value="pc">PC资源(单机)</option><option value="switch">Switch资源</option></select></div>
       <div class="form-row"><label>标签(逗号分隔,如: 即时战略,经典怀旧)</label><input id="g_tags"></div>
-      <div class="form-row"><label>游戏大小(如 232.6 GB)</label><input id="g_size"></div>
-      <div class="form-row"><label>安装磁盘占用(如 411.6 GB)</label><input id="g_install_size"></div>
+      <div class="form-row"><label>游戏大小(GB,纯数字,如 232.6)*</label><input id="g_size" type="number" step="any" min="0" placeholder="232.6"></div>
+      <div class="form-row"><label>磁盘占用(GB,纯数字,如 411.6)*</label><input id="g_install_size" type="number" step="any" min="0" placeholder="411.6"></div>
       <div class="form-row"><label>系统要求</label><input id="g_os" placeholder="Windows 10 64bit"></div>
       <div class="form-row"><label>CPU要求</label><input id="g_cpu" placeholder="Intel i5-4460"></div>
       <div class="form-row"><label>显卡要求</label><input id="g_gpu" placeholder="GTX 1060 6GB"></div>
@@ -230,6 +255,27 @@
 
 <div id="toast" class="toast"></div>
 
+<!-- 版本编辑弹窗 -->
+<div id="versionModal" class="modal-mask hidden">
+  <div class="modal">
+    <h3 id="versionModalTitle">上传新版本</h3>
+    <input type="hidden" id="v_id">
+    <div class="form-row"><label>版本号 *(如 1.0.0)</label><input id="v_version" placeholder="1.0.0"></div>
+    <div class="form-row"><label>更新说明(换行分隔,展示在下载页)</label><textarea id="v_notes" placeholder="新增xxx功能&#10;修复xxx问题"></textarea></div>
+    <div class="upload-box">
+      <div class="hint">客户端安装包(整个 Release 目录打成的 zip)</div>
+      <input type="file" accept=".zip" onchange="uploadVersionFile(this)">
+      <div id="v_file_list"></div>
+      <input type="hidden" id="v_file_url">
+      <input type="hidden" id="v_file_size">
+    </div>
+    <div style="display:flex;gap:10px;justify-content:flex-end;margin-top:16px">
+      <button class="btn btn-gray" onclick="hideVersionModal()">取消</button>
+      <button class="btn" id="saveVersionBtn" onclick="saveVersion()">保存</button>
+    </div>
+  </div>
+</div>
+
 <!-- 工具编辑弹窗 -->
 <div id="toolModal" class="modal-mask hidden">
   <div class="modal">
@@ -298,11 +344,11 @@
 function enterPanel() {
   document.getElementById('loginPage').style.display = 'none';
   document.getElementById('mainPage').style.display = 'flex';
-  loadStats(); loadKeys(1); loadGames(); loadCategories(); loadAnnouncement(); loadTools();
+  loadStats(); loadKeys(1); loadGames(); loadCategories(); loadAnnouncement(); loadTools(); loadResetRequests(); loadVersions();
 }
 function switchTab(tab) {
   document.querySelectorAll('.nav-tabs button').forEach(b => b.classList.toggle('active', b.dataset.tab === tab));
-  ['keys','games','cats','ann','tools'].forEach(t => document.getElementById('tab-' + t).classList.toggle('hidden', t !== tab));
+  ['keys','games','cats','ann','tools','reset','versions'].forEach(t => document.getElementById('tab-' + t).classList.toggle('hidden', t !== tab));
 }
 
 async function loadStats() {
@@ -394,7 +440,7 @@
     <td>${g.title}</td>
     <td>${g.category_name || '-'}</td>
     <td><span class="tag ${g.platform==='pc'?'tag-blue':'tag-green'}">${g.platform==='pc'?'PC':'Switch'}</span></td>
-    <td>${g.size}</td>
+    <td>${/^[0-9.]+$/.test(g.size) ? g.size + ' GB' : (g.size || '-')}</td>
     <td>${g.download_count}</td>
     <td>
       <button class="btn btn-sm" onclick='showGameModal(${JSON.stringify(g).replace(/'/g,"&#39;")})'>修改</button>
@@ -407,7 +453,9 @@
   if (g) {
     document.getElementById('gameModalTitle').innerText = '修改游戏';
     g_id.value = g.id; g_title.value = g.title; g_tags.value = g.tags || '';
-    g_size.value = g.size || ''; g_install_size.value = g.install_size || '';
+    // 大小统一为 GB 纯数字,历史数据如 "232.6 GB" 去掉单位后填入
+    g_size.value = (g.size || '').replace(/\s*GB$/i, '').trim();
+    g_install_size.value = (g.install_size || '').replace(/\s*GB$/i, '').trim();
     g_os.value = g.os_req || ''; g_cpu.value = g.cpu_req || ''; g_gpu.value = g.gpu_req || ''; g_ram.value = g.ram_req || '';
     g_version_note.value = g.version_note || ''; g_description.value = g.description || '';
     g_launch_exe.value = g.launch_exe || '';
@@ -502,6 +550,11 @@
     `<div class="file-item"><span>${f.name}(${f.size})</span><button class="btn btn-sm btn-danger" onclick="editingFiles.splice(${i},1);renderFiles()">移除</button></div>`).join('');
 }
 async function saveGame() {
+  // 大小/磁盘占用统一为 GB 纯数字,必须校验
+  const sizeVal = g_size.value.trim();
+  const installVal = g_install_size.value.trim();
+  if (!/^\d+(\.\d+)?$/.test(sizeVal)) return toast('游戏大小请填写纯数字(单位GB),如 232.6', true);
+  if (!/^\d+(\.\d+)?$/.test(installVal)) return toast('磁盘占用请填写纯数字(单位GB),如 411.6', true);
   const body = {
     id: parseInt(g_id.value) || 0,
     title: g_title.value.trim(), category_id: parseInt(g_category.value) || 0,
@@ -626,6 +679,138 @@
   loadTools();
 }
 
+/* ---------- 客户端版本管理 ---------- */
+async function loadVersions() {
+  const res = await api('/admin/api/versions');
+  if (res.code !== 0) return;
+  const rows = res.data.map((v, i) => `<tr>
+    <td>${v.id}</td>
+    <td><span class="tag ${i===0?'tag-green':'tag-gray'}">${v.version}${i===0?' · 最新':''}</span></td>
+    <td>${v.file_size || '-'}</td>
+    <td style="max-width:260px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" title="${(v.notes||'').replace(/"/g,'&quot;')}">${(v.notes||'-').replace(/\n/g,';')}</td>
+    <td>${v.download_count}</td>
+    <td>${(v.created_at || '').replace('T', ' ').slice(0, 19)}</td>
+    <td>
+      <button class="btn btn-sm" onclick='showVersionModal(${JSON.stringify(v).replace(/'/g,"&#39;")})'>修改</button>
+      <button class="btn btn-sm btn-danger" onclick="deleteVersion(${v.id})">删除</button>
+    </td></tr>`).join('');
+  document.getElementById('versionTable').innerHTML = rows || '<tr><td colspan="7" style="text-align:center;color:#666">暂无版本,请上传第一个客户端版本</td></tr>';
+}
+function showVersionModal(v) {
+  document.getElementById('versionModalTitle').innerText = v ? '修改版本' : '上传新版本';
+  document.getElementById('v_id').value = v ? v.id : '';
+  document.getElementById('v_version').value = v ? v.version : '';
+  document.getElementById('v_notes').value = v ? (v.notes || '') : '';
+  document.getElementById('v_file_url').value = v ? (v.file_url || '') : '';
+  document.getElementById('v_file_size').value = v ? (v.file_size || '') : '';
+  renderVersionFile();
+  document.getElementById('versionModal').classList.remove('hidden');
+}
+function hideVersionModal() { document.getElementById('versionModal').classList.add('hidden'); }
+function renderVersionFile(name, pct) {
+  const url = document.getElementById('v_file_url').value;
+  const size = document.getElementById('v_file_size').value;
+  if (pct !== undefined) {
+    document.getElementById('v_file_list').innerHTML = `<div class="file-item"><span>${name} 上传中 ${pct}%</span></div>`;
+  } else {
+    document.getElementById('v_file_list').innerHTML = url ? `<div class="file-item"><span>${url}${size ? '(' + size + ')' : ''}</span></div>` : '';
+  }
+}
+async function uploadVersionFile(input) {
+  if (!input.files.length) return;
+  const f = input.files[0];
+  const fd = new FormData();
+  fd.append('file', f); fd.append('type', 'file');
+  const btn = document.getElementById('saveVersionBtn');
+  btn.disabled = true; btn.style.opacity = '0.5';
+  try {
+    const res = await new Promise((resolve, reject) => {
+      const xhr = new XMLHttpRequest();
+      xhr.open('POST', '/admin/api/upload');
+      if (token) xhr.setRequestHeader('Authorization', 'Bearer ' + token);
+      xhr.upload.onprogress = e => { if (e.lengthComputable) renderVersionFile(f.name, Math.floor(e.loaded / e.total * 100)); };
+      xhr.onload = () => { try { resolve(JSON.parse(xhr.responseText)); } catch (err) { reject(err); } };
+      xhr.onerror = () => reject(new Error('网络错误'));
+      xhr.send(fd);
+    });
+    if (res.code !== 0) return toast(res.msg || '上传失败', true);
+    document.getElementById('v_file_url').value = res.data.url;
+    document.getElementById('v_file_size').value = res.data.size;
+    // 未填版本号时用文件名里的版本号(如 gamebox-1.0.0.zip)
+    if (!document.getElementById('v_version').value.trim()) {
+      const m = f.name.match(/(\d+\.\d+(\.\d+)?)/);
+      if (m) document.getElementById('v_version').value = m[1];
+    }
+    toast('上传成功');
+  } catch (e) {
+    toast('上传失败(' + e.message + ')', true);
+  } finally {
+    btn.disabled = false; btn.style.opacity = '';
+    renderVersionFile();
+  }
+}
+async function saveVersion() {
+  const body = {
+    id: parseInt(document.getElementById('v_id').value) || 0,
+    version: document.getElementById('v_version').value.trim(),
+    notes: document.getElementById('v_notes').value,
+    file_url: document.getElementById('v_file_url').value.trim(),
+    file_size: document.getElementById('v_file_size').value.trim(),
+  };
+  if (!body.version) return toast('请填写版本号', true);
+  if (!body.file_url) return toast('请上传客户端安装包', true);
+  const res = await api('/admin/api/versions', {method: 'POST', body});
+  toast(res.msg, res.code !== 0);
+  if (res.code === 0) { hideVersionModal(); loadVersions(); }
+}
+async function deleteVersion(id) {
+  if (!confirm('确定删除该版本?')) return;
+  const res = await api(`/admin/api/versions/${id}`, {method: 'DELETE'});
+  toast(res.msg, res.code !== 0);
+  loadVersions();
+}
+
+/* ---------- 密码重置申请 ---------- */
+async function loadResetRequests() {
+  const res = await api('/admin/api/reset_requests');
+  if (res.code !== 0) return;
+  const rows = res.data.map(r => `<tr>
+    <td>${r.id}</td>
+    <td>${r.phone}</td>
+    <td>${r.proposed_password ? `<code style="color:#4a92ff">${r.proposed_password}</code>` : '-'}</td>
+    <td>${(r.created_at || '').replace('T', ' ').slice(0, 19)}</td>
+    <td>${r.status === 1 ? '<span class="tag tag-green">已同意</span>' : '<span class="tag" style="background:#8a6d1a;color:#ffd700">待处理</span>'}</td>
+    <td>${r.status === 1 ? `<code style="color:#ffd700">${r.new_password || '-'}</code>` : '-'}</td>
+    <td>${r.handled_at ? (r.handled_at + '').replace('T', ' ').slice(0, 19) : '-'}</td>
+    <td>
+      ${r.status === 0 ? `<button class="btn btn-sm" onclick="approveReset(${r.id}, '${r.phone}', '${r.proposed_password || ''}')">同意并重置</button>` : ''}
+      <button class="btn btn-sm btn-danger" onclick="deleteReset(${r.id})">删除</button>
+    </td></tr>`).join('');
+  document.getElementById('resetTable').innerHTML = rows || '<tr><td colspan="8" style="text-align:center;color:#666">暂无申请</td></tr>';
+}
+async function approveReset(id, phone, proposed) {
+  const input = prompt(`同意 ${phone} 的找回密码申请。\n请输入要设置的新密码(至少6位,留空则使用用户填写的密码):`, proposed || '');
+  if (input === null) return; // 取消
+  const body = input.trim() ? {new_password: input.trim()} : {};
+  const res = await api(`/admin/api/reset_requests/${id}/approve`, {method: 'POST', body});
+  if (res.code !== 0) return toast(res.msg, true);
+  const newPwd = res.data.new_password;
+  const w = document.createElement('div');
+  w.className = 'modal-mask';
+  w.innerHTML = `<div class="modal" style="width:420px"><h3>重置成功</h3>
+    <p style="margin:10px 0">手机号 <b style="color:#4a92ff">${phone}</b> 的密码已重置为:</p>
+    <p style="font-size:20px;color:#ffd700;text-align:center;margin:14px 0">${newPwd}</p>
+    <p style="color:#888;font-size:12px">请将新密码告知该用户。</p>
+    <div style="text-align:right;margin-top:14px"><button class="btn" onclick="copyText('${newPwd}');this.closest('.modal-mask').remove();loadResetRequests()">复制并关闭</button></div></div>`;
+  document.body.appendChild(w);
+}
+async function deleteReset(id) {
+  if (!confirm('确定删除该申请?')) return;
+  const res = await api(`/admin/api/reset_requests/${id}`, {method: 'DELETE'});
+  toast(res.msg, res.code !== 0);
+  loadResetRequests();
+}
+
 document.getElementById('adminPwd').addEventListener('keydown', e => { if (e.key === 'Enter') adminLogin(); });
 if (token) enterPanel();
 </script>

--
Gitblit v1.10.0