#!/usr/bin/env python3 """ AeroTrack LAN Sync Server (AeroTrack 局域网多设备同步服务端) - 零第三方依赖,纯 Python 标准库 (Python 3.8+) - 自动管理 SQLite 数据库,具备完整的物理药瓶生命周期 (Bottle Entity) 与事件账本溯源 - 支持高并发多线程与完整 CORS - 一体化托管 Flutter Web 端应用与服务端监控看板 """ import sys import os import json import sqlite3 import datetime from http.server import HTTPServer, SimpleHTTPRequestHandler from socketserver import ThreadingMixIn DB_FILE = os.environ.get( 'AEROTRACK_DB', os.path.join(os.path.dirname(os.path.abspath(__file__)), 'aerotrack.db') ) WEB_DIR = os.environ.get( 'AEROTRACK_WEB_DIR', os.path.join(os.path.dirname(os.path.dirname(os.path.abspath(__file__))), 'build', 'web') ) def get_db(): conn = sqlite3.connect(DB_FILE, check_same_thread=False) conn.row_factory = sqlite3.Row return conn def init_db(): conn = get_db() with conn: # 1. 药品基础方案配置表 conn.execute(''' CREATE TABLE IF NOT EXISTS canisters ( id TEXT PRIMARY KEY, name TEXT NOT NULL, total_doses INTEGER NOT NULL, remaining_doses INTEGER NOT NULL, opened_at TEXT, is_enabled INTEGER DEFAULT 1, puffs_per_session INTEGER DEFAULT 2, inhalation_seconds INTEGER DEFAULT 15, is_steroid INTEGER DEFAULT 1, sort_order INTEGER DEFAULT 1, note TEXT, updated_at TEXT ) ''') # 2. 物理药瓶全生命周期实体表 (支持换新瓶档案、多端独立计数) conn.execute(''' CREATE TABLE IF NOT EXISTS bottles ( id TEXT PRIMARY KEY, canister_id TEXT NOT NULL, name TEXT NOT NULL, sequence_number INTEGER DEFAULT 1, total_doses INTEGER NOT NULL, remaining_doses INTEGER NOT NULL, opened_at TEXT NOT NULL, finished_at TEXT, is_active INTEGER DEFAULT 1, opened_by_device TEXT, updated_at TEXT NOT NULL ) ''') # 3. 吸入流水日志表 (UUID 主键,天然支持并发防重与软删除墓碑) conn.execute(''' CREATE TABLE IF NOT EXISTS dose_records ( id TEXT PRIMARY KEY, start_time TEXT NOT NULL, end_time TEXT NOT NULL, flixotide_puffs INTEGER DEFAULT 0, ventolin_puffs INTEGER DEFAULT 0, flixotide_bottle_id TEXT, ventolin_bottle_id TEXT, rinsed_mouth INTEGER DEFAULT 1, washed_face INTEGER DEFAULT 1, is_prime INTEGER DEFAULT 0, is_deleted INTEGER DEFAULT 0, note TEXT, operator_name TEXT, created_at TEXT NOT NULL, updated_at TEXT ) ''') # 检查并平滑升级 dose_records 缺失的列 cursor = conn.execute("PRAGMA table_info(dose_records)") existing_cols = {row['name'] for row in cursor.fetchall()} if 'flixotide_bottle_id' not in existing_cols: conn.execute('ALTER TABLE dose_records ADD COLUMN flixotide_bottle_id TEXT') if 'ventolin_bottle_id' not in existing_cols: conn.execute('ALTER TABLE dose_records ADD COLUMN ventolin_bottle_id TEXT') if 'is_deleted' not in existing_cols: conn.execute('ALTER TABLE dose_records ADD COLUMN is_deleted INTEGER DEFAULT 0') if 'updated_at' not in existing_cols: conn.execute('ALTER TABLE dose_records ADD COLUMN updated_at TEXT') # 4. 局域网同步设备列表 conn.execute(''' CREATE TABLE IF NOT EXISTS devices ( device_id TEXT PRIMARY KEY, device_name TEXT NOT NULL, last_seen TEXT NOT NULL, ip_address TEXT ) ''') # 5. 若 bottles 为空,初始化默认第 1 瓶并平滑绑定历史流水 bottle_count = conn.execute('SELECT COUNT(*) as c FROM bottles').fetchone()['c'] if bottle_count == 0: now_iso = datetime.datetime.now(datetime.timezone.utc).isoformat() earliest_time = '2020-01-01T00:00:00Z' conn.execute(''' INSERT INTO bottles (id, canister_id, name, sequence_number, total_doses, remaining_doses, opened_at, is_active, opened_by_device, updated_at) VALUES ('flix_b1_initial', 'flixotide_primary', '辅舒酮 (丙酸氟替卡松)', 1, 60, 60, ?, 1, '系统初始化', ?) ''', (earliest_time, now_iso)) conn.execute(''' INSERT INTO bottles (id, canister_id, name, sequence_number, total_doses, remaining_doses, opened_at, is_active, opened_by_device, updated_at) VALUES ('vent_b1_initial', 'ventolin_primary', '万托林 (硫酸沙丁胺醇)', 1, 200, 200, ?, 1, '系统初始化', ?) ''', (earliest_time, now_iso)) conn.execute("UPDATE dose_records SET flixotide_bottle_id = 'flix_b1_initial' WHERE flixotide_puffs > 0 AND flixotide_bottle_id IS NULL") conn.execute("UPDATE dose_records SET ventolin_bottle_id = 'vent_b1_initial' WHERE ventolin_puffs > 0 AND ventolin_bottle_id IS NULL") conn.execute("UPDATE dose_records SET updated_at = ? WHERE updated_at IS NULL", (now_iso,)) # 6. 若 canisters 为空,初始化基础配置 canister_count = conn.execute('SELECT COUNT(*) as c FROM canisters').fetchone()['c'] if canister_count == 0: now_iso = datetime.datetime.now(datetime.timezone.utc).isoformat() conn.execute(''' INSERT INTO canisters (id, name, total_doses, remaining_doses, opened_at, is_enabled, puffs_per_session, inhalation_seconds, is_steroid, sort_order, note, updated_at) VALUES ('ventolin_primary', '万托林 (硫酸沙丁胺醇)', 200, 200, '2020-01-01T00:00:00Z', 1, 2, 15, 0, 1, '支气管舒张剂', ?) ''', (now_iso,)) conn.execute(''' INSERT INTO canisters (id, name, total_doses, remaining_doses, opened_at, is_enabled, puffs_per_session, inhalation_seconds, is_steroid, sort_order, note, updated_at) VALUES ('flixotide_primary', '辅舒酮 (丙酸氟替卡松)', 60, 60, '2020-01-01T00:00:00Z', 1, 2, 15, 1, 2, '糖皮质激素', ?) ''', (now_iso,)) # 7. 家庭智能药箱全量管理表 conn.execute(''' CREATE TABLE IF NOT EXISTS medicines ( id TEXT PRIMARY KEY, name TEXT NOT NULL, category TEXT NOT NULL, spec TEXT, storage_location TEXT, target_user TEXT, barcode TEXT, batch_number TEXT, production_date TEXT, expiry_date TEXT NOT NULL, shelf_life_days_after_opening INTEGER, is_opened INTEGER DEFAULT 0, opened_at TEXT, opened_by_device TEXT, notes TEXT, is_deleted INTEGER DEFAULT 0, updated_at TEXT NOT NULL ) ''') conn.close() class ThreadedHTTPServer(ThreadingMixIn, HTTPServer): daemon_threads = True class SyncHandler(SimpleHTTPRequestHandler): def __init__(self, *args, **kwargs): super().__init__(*args, directory=WEB_DIR if os.path.isdir(WEB_DIR) else None, **kwargs) def log_message(self, format, *args): try: sys.stderr.write("%s - - [%s] %s\n" % (self.address_string(), self.log_date_time_string(), format % args)) sys.stderr.flush() except Exception: pass def _send_cors_headers(self): self.send_header('Access-Control-Allow-Origin', '*') self.send_header('Access-Control-Allow-Methods', 'GET, POST, OPTIONS') self.send_header('Access-Control-Allow-Headers', 'Content-Type, Authorization, X-Requested-With') def end_headers(self): self._send_cors_headers() super().end_headers() def do_OPTIONS(self): self.send_response(200) self.end_headers() def _send_json(self, status_code, data): payload = json.dumps(data, ensure_ascii=False).encode('utf-8') self.send_response(status_code) self.send_header('Content-Type', 'application/json; charset=utf-8') self.send_header('Content-Length', str(len(payload))) self.end_headers() self.wfile.write(payload) def do_GET(self): # 1. Ping / 连通性测试 if self.path == '/api/v1/ping': self._send_json(200, { 'status': 'ok', 'service': 'AeroTrack LAN Sync Server', 'timestamp': datetime.datetime.now(datetime.timezone.utc).isoformat() }) return # 2. 状态查询 if self.path == '/api/v1/sync/status': conn = get_db() total_records = conn.execute('SELECT COUNT(*) as c FROM dose_records WHERE is_deleted = 0').fetchone()['c'] devices = [dict(r) for r in conn.execute('SELECT * FROM devices ORDER BY last_seen DESC').fetchall()] canisters = [dict(r) for r in conn.execute('SELECT * FROM canisters ORDER BY sort_order ASC').fetchall()] bottles = [dict(r) for r in conn.execute('SELECT * FROM bottles ORDER BY sequence_number ASC').fetchall()] conn.close() self._send_json(200, { 'status': 'online', 'total_records': total_records, 'devices': devices, 'canisters': canisters, 'bottles': bottles, 'server_time': datetime.datetime.now(datetime.timezone.utc).isoformat() }) return # 3. 药品条码/追溯码信息查询接口 if self.path.startswith('/api/v1/medicine/lookup'): from urllib.parse import urlparse, parse_qs query = parse_qs(urlparse(self.path).query) code = query.get('code', [''])[0].strip() self._handle_medicine_lookup(code) return # 4. 监控看板 if self.path == '/dashboard' or self.path == '/dashboard/': self._render_dashboard() return # 5. 静态 Web 端(Flutter Web 产物) if os.path.isdir(WEB_DIR): super().do_GET() return # 6. 若未编译 Flutter Web,则默认展示监控面板 if self.path == '/' or self.path == '/index.html': self._render_dashboard() return self.send_error(404, "Not Found") def do_POST(self): if self.path == '/api/v1/sync': content_length = int(self.headers.get('Content-Length', 0)) body = self.rfile.read(content_length) try: payload = json.loads(body.decode('utf-8')) except Exception as e: self._send_json(400, {'error': f'Invalid JSON: {str(e)}'}) return self._handle_sync(payload) return self.send_error(404, "Not Found") def _handle_sync(self, payload): device_name = payload.get('device_name', '未知设备') device_id = payload.get('device_id', 'unknown') client_ip = self.client_address[0] now_str = datetime.datetime.now(datetime.timezone.utc).isoformat() conn = get_db() with conn: # 1. 记录设备心跳 conn.execute(''' INSERT INTO devices (device_id, device_name, last_seen, ip_address) VALUES (?, ?, ?, ?) ON CONFLICT(device_id) DO UPDATE SET device_name = excluded.device_name, last_seen = excluded.last_seen, ip_address = excluded.ip_address ''', (device_id, device_name, now_str, client_ip)) # 2. 接收并合并药瓶实体列表 (Bottles) incoming_bottles = payload.get('bottles', []) for b in incoming_bottles: bid = b.get('id') if not bid: continue cid = b.get('canisterId') or b.get('canister_id', '') bname = b.get('name', '') seq = b.get('sequenceNumber') or b.get('sequence_number', 1) td = b.get('totalDoses') or b.get('total_doses', 60) op_at = b.get('openedAt') or b.get('opened_at', now_str) fin_at = b.get('finishedAt') or b.get('finished_at') is_act = 1 if (b.get('isActive') if b.get('isActive') is not None else b.get('is_active', 1)) else 0 dev = b.get('openedByDevice') or b.get('opened_by_device', device_name) up_at = b.get('updatedAt') or b.get('updated_at', now_str) existing_b = conn.execute('SELECT * FROM bottles WHERE id = ?', (bid,)).fetchone() if not existing_b: conn.execute(''' INSERT INTO bottles (id, canister_id, name, sequence_number, total_doses, remaining_doses, opened_at, finished_at, is_active, opened_by_device, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ''', (bid, cid, bname, seq, td, td, op_at, fin_at, is_act, dev, up_at)) else: if up_at >= (existing_b['updated_at'] or '') or (not is_act and existing_b['is_active']): conn.execute(''' UPDATE bottles SET finished_at = COALESCE(?, finished_at), is_active = ?, updated_at = ? WHERE id = ? ''', (fin_at, is_act, up_at, bid)) # 3. 接收客户端推上来的用药记录 (UUID 幂等入库 + 软删除墓碑同步) incoming_records = payload.get('records', []) for r in incoming_records: rec_id = r.get('id') if not rec_id: continue is_del = 1 if r.get('isDeleted') or r.get('is_deleted') else 0 up_at = r.get('updatedAt') or r.get('updated_at', now_str) fb_id = r.get('flixotideBottleId') or r.get('flixotide_bottle_id') vb_id = r.get('ventolinBottleId') or r.get('ventolin_bottle_id') existing_r = conn.execute('SELECT * FROM dose_records WHERE id = ?', (rec_id,)).fetchone() if not existing_r: conn.execute(''' INSERT INTO dose_records (id, start_time, end_time, flixotide_puffs, ventolin_puffs, flixotide_bottle_id, ventolin_bottle_id, rinsed_mouth, washed_face, is_prime, is_deleted, note, operator_name, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ''', ( rec_id, r.get('startTime', now_str), r.get('endTime', now_str), r.get('flixotidePuffs', 0), r.get('ventolinPuffs', 0), fb_id, vb_id, 1 if r.get('rinsedMouth', True) else 0, 1 if r.get('washedFace', True) else 0, 1 if r.get('isPrime', False) else 0, is_del, r.get('note', ''), device_name, now_str, up_at )) else: if up_at >= (existing_r['updated_at'] or ''): conn.execute(''' UPDATE dose_records SET is_deleted = ?, flixotide_bottle_id = COALESCE(?, flixotide_bottle_id), ventolin_bottle_id = COALESCE(?, ventolin_bottle_id), updated_at = ? WHERE id = ? ''', (is_del, fb_id, vb_id, up_at, rec_id)) # 4. 接收客户端方案配置 (Canisters 元数据) incoming_canisters = payload.get('canisters', []) for c in incoming_canisters: cid = c.get('id') if not cid: continue conn.execute(''' INSERT INTO canisters (id, name, total_doses, remaining_doses, opened_at, is_enabled, puffs_per_session, inhalation_seconds, is_steroid, sort_order, note, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET name = excluded.name, is_enabled = excluded.is_enabled, puffs_per_session = excluded.puffs_per_session, inhalation_seconds = excluded.inhalation_seconds, sort_order = excluded.sort_order, note = excluded.note, updated_at = excluded.updated_at ''', ( cid, c.get('name', ''), c.get('totalDoses', 60), c.get('remainingDoses', 60), c.get('openedAt', now_str), 1 if c.get('isEnabled', True) else 0, c.get('puffsPerSession', 2), c.get('inhalationSeconds', 15), 1 if c.get('isSteroid', True) else 0, c.get('sortOrder', 1), c.get('note', ''), now_str )) # 4.5. 接收客户端家庭药箱数据 (Medicines) incoming_medicines = payload.get('medicines', []) for m in incoming_medicines: mid = m.get('id') if not mid: continue up_at = m.get('updatedAt', now_str) is_del = 1 if m.get('isDeleted', False) else 0 is_open = 1 if m.get('isOpened', False) else 0 existing_m = conn.execute('SELECT * FROM medicines WHERE id = ?', (mid,)).fetchone() if not existing_m: conn.execute(''' INSERT INTO medicines (id, name, category, spec, storage_location, target_user, barcode, batch_number, production_date, expiry_date, shelf_life_days_after_opening, is_opened, opened_at, opened_by_device, notes, is_deleted, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ''', ( mid, m.get('name', '未命名药品'), m.get('category', 'other'), m.get('spec', ''), m.get('storageLocation', '常温药箱'), m.get('targetUser', '全家'), m.get('barcode'), m.get('batchNumber'), m.get('productionDate'), m.get('expiryDate', now_str), m.get('shelfLifeDaysAfterOpening'), is_open, m.get('openedAt'), m.get('openedByDevice'), m.get('notes', ''), is_del, up_at )) else: if up_at >= (existing_m['updated_at'] or ''): conn.execute(''' UPDATE medicines SET name = ?, category = ?, spec = ?, storage_location = ?, target_user = ?, barcode = ?, batch_number = ?, production_date = ?, expiry_date = ?, shelf_life_days_after_opening = ?, is_opened = ?, opened_at = ?, opened_by_device = ?, notes = ?, is_deleted = ?, updated_at = ? WHERE id = ? ''', ( m.get('name', existing_m['name']), m.get('category', existing_m['category']), m.get('spec', existing_m['spec']), m.get('storageLocation', existing_m['storage_location']), m.get('targetUser', existing_m['target_user']), m.get('barcode', existing_m['barcode']), m.get('batchNumber', existing_m['batch_number']), m.get('productionDate', existing_m['production_date']), m.get('expiryDate', existing_m['expiry_date']), m.get('shelfLifeDaysAfterOpening', existing_m['shelf_life_days_after_opening']), is_open, m.get('openedAt', existing_m['opened_at']), m.get('openedByDevice', existing_m['opened_by_device']), m.get('notes', existing_m['notes']), is_del, up_at, mid )) # 5. 依据物理药瓶实体 (Bottle) 与流水绑定关系,严格确定性重新核算余量 for b in conn.execute('SELECT * FROM bottles').fetchall(): bid = b['id'] cid = b['canister_id'] td = b['total_doses'] is_steroid = 1 if 'flix' in cid else 0 if is_steroid: res = conn.execute(''' SELECT SUM(flixotide_puffs) as s FROM dose_records WHERE is_deleted = 0 AND (flixotide_bottle_id = ? OR (flixotide_bottle_id IS NULL AND start_time >= ?)) ''', (bid, b['opened_at'])).fetchone() else: res = conn.execute(''' SELECT SUM(ventolin_puffs) as s FROM dose_records WHERE is_deleted = 0 AND (ventolin_bottle_id = ? OR (ventolin_bottle_id IS NULL AND start_time >= ?)) ''', (bid, b['opened_at'])).fetchone() consumed = (res['s'] or 0) if res else 0 rem = max(0, td - consumed) conn.execute('UPDATE bottles SET remaining_doses = ? WHERE id = ?', (rem, bid)) # 若是当前在用活跃瓶,同步确保并更新 canisters 方案余量 if b['is_active']: conn.execute(''' INSERT INTO canisters (id, name, total_doses, remaining_doses, opened_at, is_enabled, puffs_per_session, inhalation_seconds, is_steroid, sort_order, note, updated_at) VALUES (?, ?, ?, ?, ?, 1, 2, 15, ?, 1, '', ?) ON CONFLICT(id) DO UPDATE SET remaining_doses = excluded.remaining_doses, opened_at = excluded.opened_at ''', (cid, b['name'], td, rem, b['opened_at'], is_steroid, now_str)) # 6. 汇总全量数据响应客户端 all_records = [] for row in conn.execute('SELECT * FROM dose_records ORDER BY start_time DESC LIMIT 300'): all_records.append({ 'id': row['id'], 'startTime': row['start_time'], 'endTime': row['end_time'], 'flixotidePuffs': row['flixotide_puffs'], 'ventolinPuffs': row['ventolin_puffs'], 'flixotideBottleId': row['flixotide_bottle_id'], 'ventolinBottleId': row['ventolin_bottle_id'], 'rinsedMouth': bool(row['rinsed_mouth']), 'washedFace': bool(row['washed_face']), 'isPrime': bool(row['is_prime']), 'isDeleted': bool(row['is_deleted']), 'note': row['note'], 'operatorName': row['operator_name'], 'updatedAt': row['updated_at'] }) all_bottles = [] for row in conn.execute('SELECT * FROM bottles ORDER BY sequence_number ASC'): all_bottles.append({ 'id': row['id'], 'canisterId': row['canister_id'], 'name': row['name'], 'sequenceNumber': row['sequence_number'], 'totalDoses': row['total_doses'], 'remainingDoses': row['remaining_doses'], 'openedAt': row['opened_at'], 'finishedAt': row['finished_at'], 'isActive': bool(row['is_active']), 'openedByDevice': row['opened_by_device'], 'updatedAt': row['updated_at'] }) all_canisters = [] for row in conn.execute('SELECT * FROM canisters ORDER BY sort_order ASC'): all_canisters.append({ 'id': row['id'], 'name': row['name'], 'totalDoses': row['total_doses'], 'remainingDoses': row['remaining_doses'], 'openedAt': row['opened_at'], 'isEnabled': bool(row['is_enabled']), 'puffsPerSession': row['puffs_per_session'], 'inhalationSeconds': row['inhalation_seconds'], 'isSteroid': bool(row['is_steroid']), 'sortOrder': row['sort_order'], 'note': row['note'] }) all_medicines = [] for row in conn.execute('SELECT * FROM medicines ORDER BY expiry_date ASC').fetchall(): all_medicines.append({ 'id': row['id'], 'name': row['name'], 'category': row['category'], 'spec': row['spec'] or '', 'storageLocation': row['storage_location'] or '常温药箱', 'targetUser': row['target_user'] or '全家', 'barcode': row['barcode'], 'batchNumber': row['batch_number'], 'productionDate': row['production_date'], 'expiryDate': row['expiry_date'], 'shelfLifeDaysAfterOpening': row['shelf_life_days_after_opening'], 'isOpened': bool(row['is_opened']), 'openedAt': row['opened_at'], 'openedByDevice': row['opened_by_device'], 'notes': row['notes'] or '', 'isDeleted': bool(row['is_deleted']), 'updatedAt': row['updated_at'] }) conn.close() self._send_json(200, { 'success': True, 'server_time': now_str, 'bottles': all_bottles, 'records': all_records, 'canisters': all_canisters, 'medicines': all_medicines }) def _handle_medicine_lookup(self, code): catalog = { '6921147600010': {'name': '辅舒酮 (丙酸氟替卡松吸入气雾剂)', 'spec': '50μg/喷 × 60喷', 'notes': '吸入用糖皮质激素'}, '6921147600027': {'name': '万托林 (硫酸沙丁胺醇吸入气雾剂)', 'spec': '100μg/喷 × 200喷', 'notes': '支气管舒张剂'}, '6925567800018': {'name': '美林 (布洛芬混悬液)', 'spec': '100ml:2g', 'notes': '退热抗炎镇痛'}, '6925567800025': {'name': '泰诺林 (对乙酰氨基酚混悬滴剂)', 'spec': '15ml:1.5g', 'notes': '儿童退热滴剂'}, '6936577800015': {'name': '托百士 (妥布霉素滴眼液)', 'spec': '5ml:15mg', 'notes': '抗生素眼药水,开封4周内使用'}, '6914567800012': {'name': '可乐必妥 (左氧氟沙星滴眼液)', 'spec': '5ml:24.45mg', 'notes': '抗菌滴眼液'}, '6901234560019': {'name': '百多邦 (莫匹罗星软膏)', 'spec': '5g:0.1g', 'notes': '外用抗菌软膏'}, } if code in catalog: item = catalog[code] self._send_json(200, { 'status': 'ok', 'data': { 'barcode': code, 'name': item['name'], 'spec': item['spec'], 'notes': item['notes'] } }) return if len(code) == 20 and code.isdigit(): self._send_json(200, { 'status': 'ok', 'data': { 'barcode': code, 'name': f'追溯码药品 ({code[:6]}...)', 'notes': '由国家药品电子监管码录入' } }) return self._send_json(200, {'status': 'not_found', 'message': '未在本地知识库匹配到该药品条码'}) def _render_dashboard(self): conn = get_db() records = conn.execute('SELECT * FROM dose_records WHERE is_deleted = 0 ORDER BY start_time DESC LIMIT 20').fetchall() devices = conn.execute('SELECT * FROM devices ORDER BY last_seen DESC').fetchall() canisters = conn.execute('SELECT * FROM canisters ORDER BY sort_order ASC').fetchall() bottles = conn.execute('SELECT * FROM bottles ORDER BY sequence_number DESC').fetchall() medicines = conn.execute('SELECT * FROM medicines WHERE is_deleted = 0 ORDER BY expiry_date ASC').fetchall() total_count = conn.execute('SELECT COUNT(*) as c FROM dose_records WHERE is_deleted = 0').fetchone()['c'] conn.close() med_list = [] now_dt = datetime.datetime.now(datetime.timezone.utc) for m in medicines: exp_str = m['expiry_date'] or '' try: exp_clean = exp_str.replace('Z', '+00:00') exp_dt = datetime.datetime.fromisoformat(exp_clean) days_left = (exp_dt.date() - now_dt.date()).days except Exception: days_left = 999 if days_left < 0: badge = '已过期' elif days_left <= 30: badge = f'临期 ({days_left}天)' elif m['is_opened']: badge = '已开封使用' else: badge = '未开封正常' open_info = f"已开封 ({m['opened_at'][:10]})" if m['is_opened'] and m['opened_at'] else "未开封" loc = m['storage_location'] or '常温药箱' spec = f" ({m['spec']})" if m['spec'] else "" med_list.append( f"" f"{m['name']}{spec}" f"{loc}" f"{exp_str[:10]}" f"{open_info}" f"{badge}" f"" ) med_rows = "".join(med_list) or "暂无家庭药箱数据,可在 App 内扫码或手动添加" canister_list = [] for c in canisters: status_badge = '启用' if c['is_enabled'] else '未启用' canister_list.append( f"" f"{c['name']}" f"{c['remaining_doses']} / {c['total_doses']} 喷" f"{c['puffs_per_session']} 喷" f"{status_badge}" f"" ) canister_rows = "".join(canister_list) or "暂无药瓶方案数据" bottle_list = [] for b in bottles: status_badge = '在用活跃' if b['is_active'] else '已归档' fin_time = b['finished_at'][:16].replace('T', ' ') if b['finished_at'] else '使用中' bottle_list.append( f"" f"第 {b['sequence_number']} 瓶 ({b['name'].split(' ')[0]})" f"{b['remaining_doses']} / {b['total_doses']} 喷" f"{b['opened_at'][:16].replace('T', ' ')}" f"{fin_time}" f"{status_badge}" f"{b['opened_by_device']}" f"" ) bottle_rows = "".join(bottle_list) or "暂无药瓶实体数据" device_list = [] for d in devices: device_list.append( f"" f"📱 {d['device_name']}" f"{d['ip_address']}" f"{d['last_seen'][:19].replace('T', ' ')}" f"" ) device_rows = "".join(device_list) or "暂无在线设备连接" record_list = [] for r in records: detail = '试喷 -1' if r['is_prime'] else f"万{r['ventolin_puffs']}喷 + 辅{r['flixotide_puffs']}喷" clean_status = '已漱口/洗脸' if r['rinsed_mouth'] and r['washed_face'] else '未清洁' op_name = r['operator_name'] or '未知' record_list.append( f"" f"{r['start_time'][:16].replace('T', ' ')}" f"{op_name}" f"{detail}" f"{clean_status}" f"" ) record_rows = "".join(record_list) or "暂无吸入记录" html = f""" AeroTrack 局域网同步服务器

AeroTrack 局域网多设备同步服务器

数据安全保存在局域网私有主机,已记录 {total_count} 条有效雾化流水

📱 打开舒雾记 Web 端
🟢 服务运行中

🏠 家庭智能药箱健康与保质期监控 (全家药品有效期与开封管理)

{med_rows}
药品名称存放位置出厂有效期开封追踪健康状态

当前在用药瓶余量监控 (各设备统一权威真值)

{canister_rows}
药名当前剩余喷数每次用量方案状态

物理药瓶开封与换瓶档案 (Bottle Lifecycle 实体生命周期)

{bottle_rows}
瓶次 / 药品剩余喷数开瓶时间 (UTC)用尽归档状态开瓶设备

已连接局域网设备

{device_rows}
设备名称IP 地址最后同步时间

最近有效雾化时间流水 (前20条)

{record_rows}
时间操作人喷数明细收尾防护
""" encoded = html.encode('utf-8') self.send_response(200) self.send_header('Content-Type', 'text/html; charset=utf-8') self.send_header('Content-Length', str(len(encoded))) self.end_headers() self.wfile.write(encoded) def main(): port = int(os.environ.get('PORT', 8090)) if len(sys.argv) > 1: try: port = int(sys.argv[1]) except ValueError: pass init_db() server_address = ('0.0.0.0', port) httpd = ThreadedHTTPServer(server_address, SyncHandler) print(f"=====================================================") print(f"🚀 AeroTrack 局域网同步服务器已启动!") print(f"📡 监听端口: {port}") print(f"🌐 网页版客户端: http://0.0.0.0:{port}/") print(f"📊 监控看板大屏: http://0.0.0.0:{port}/dashboard") print(f"💾 数据存储路径: {DB_FILE}") print(f"=====================================================") try: httpd.serve_forever() except KeyboardInterrupt: print("\n服务已停止") if __name__ == '__main__': main()