应急演练系统 - 数据存储与认证方案

┌─────────────┐
│  手机端H5   │ ──扫码登录──> ┌──────────────┐
│  (前端)     │               │  后端API服务  │
└─────────────┘               │  (Node.js/   │
                              │   Python)    │
       │                      └──────────────┘
       │                             │
       │ HTTPS请求                   │
       │                             │
       ▼                             ▼
┌─────────────┐              ┌──────────────┐
│  云存储OSS  │              │  云数据库     │
│  (图片/音频) │              │  (MySQL/     │
└─────────────┘              │   MongoDB)   │
                             └──────────────┘
                

-- 演练基本信息表 CREATE TABLE drills ( id INT PRIMARY KEY AUTO_INCREMENT, drill_name VARCHAR(200), drill_type VARCHAR(50), location VARCHAR(200), gps_lat DECIMAL(10,6), gps_lng DECIMAL(10,6), start_time DATETIME, end_time DATETIME, status VARCHAR(20), created_by INT, created_at TIMESTAMP ); -- 参演队伍表 CREATE TABLE teams ( id INT PRIMARY KEY AUTO_INCREMENT, drill_id INT, team_name VARCHAR(100), team_type VARCHAR(50), team_size INT, equipment TEXT, arrival_time DATETIME, FOREIGN KEY (drill_id) REFERENCES drills(id) ); -- 现场采集记录表 CREATE TABLE field_records ( id INT PRIMARY KEY AUTO_INCREMENT, drill_id INT, record_type VARCHAR(50), content TEXT, voice_url VARCHAR(500), photos JSON, recorder_id INT, record_time DATETIME, FOREIGN KEY (drill_id) REFERENCES drills(id) ); -- 专家点评表 CREATE TABLE expert_reviews ( id INT PRIMARY KEY AUTO_INCREMENT, drill_id INT, expert_id INT, rating VARCHAR(20), comments TEXT, suggestions TEXT, review_time DATETIME, FOREIGN KEY (drill_id) REFERENCES drills(id) ); -- 用户表 CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50), phone VARCHAR(20), role VARCHAR(20), unit VARCHAR(100), created_at TIMESTAMP );

// 混合存储示例代码 class DataSync { async saveRecord(data) { // 先保存到本地 this.saveToLocal(data); // 尝试上传到云端 if (navigator.onLine) { try { await this.uploadToCloud(data); this.markAsSynced(data.id); } catch (error) { console.log('离线模式，稍后同步'); } } } async syncPendingData() { const pending = this.getUnsyncedData(); for (let data of pending) { await this.uploadToCloud(data); this.markAsSynced(data.id); } } } // 监听网络状态 window.addEventListener('online', () => { dataSync.syncPendingData(); });

// 腾讯云开发示例 const db = wx.cloud.database(); // 保存采集记录 async function saveRecord(data) { return await db.collection('drill_records').add({ data: { ...data, createTime: new Date() } }); } // 查询记录 async function getRecords(drillId) { return await db.collection('drill_records') .where({ drillId }) .orderBy('createTime', 'desc') .get(); }

// 登录流程示例 // 1. 发送验证码 POST /api/auth/send-code { "phone": "13800138000" } // 2. 验证登录 POST /api/auth/login { "phone": "13800138000", "code": "123456" } // 返回 { "token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...", "user": { "id": 1, "phone": "13800138000", "role": "collector", "name": "张三" } } // 3. 后续请求携带 Token GET /api/drills/123 Headers: { "Authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..." }

// 二维码内容示例 https://drill.example.com/join? drillId=12345& token=abc123def456& role=collector& expires=1737590400 // 扫码后自动登录 GET /api/auth/qrcode-login?token=abc123def456 // 返回用户信息 { "drillId": 12345, "role": "collector", "permissions": ["record", "photo", "voice"] }

// 微信授权登录 wx.login({ success: (res) => { // 发送 code 到后端 fetch('/api/auth/wechat-login', { method: 'POST', body: JSON.stringify({ code: res.code }) }); } }); // 后端换取 openid const result = await axios.get( `https://api.weixin.qq.com/sns/jscode2session? appid=${appId}& secret=${appSecret}& js_code=${code}& grant_type=authorization_code` ); // 返回 openid，作为用户唯一标识