# -*- coding: utf-8 -*-
"""校园德育量化登记系统 · 桌面应用（本地运行，数据存飞书多维表格）"""
import json, os, hashlib, time, threading, webbrowser, base64, io
from concurrent.futures import ThreadPoolExecutor
import requests
from flask import Flask, request, jsonify, send_from_directory, Response
from openpyxl import Workbook, load_workbook
from openpyxl.styles import Font as XlFont
from openpyxl.worksheet.datavalidation import DataValidation

BASE = os.path.dirname(os.path.abspath(__file__))
CONFIG_PATH = os.path.join(BASE, 'config.json')
GRADE_ORDER = ['初一', '初二', '初三', '高一', '高二', '高三']

def load_cfg():
    with open(CONFIG_PATH, encoding='utf-8') as f:
        return json.load(f)

def save_cfg(cfg):
    with open(CONFIG_PATH, 'w', encoding='utf-8') as f:
        json.dump(cfg, f, ensure_ascii=False, indent=2)

def sha(s):
    return hashlib.sha256((s or '').encode('utf-8')).hexdigest()

app = Flask(__name__)

# 全局 HTTP 会话：复用 TCP/TLS 连接，避免每次调用飞书都重新握手
HTTP = requests.Session()

@app.after_request
def no_cache_html(resp):
    if resp.mimetype == 'text/html':
        resp.headers['Cache-Control'] = 'no-cache, no-store, must-revalidate'
        resp.headers['Pragma'] = 'no-cache'
    return resp

_token = {'v': None, 'exp': 0}
_tlock = threading.Lock()

def get_token():
    with _tlock:
        cfg = load_cfg()
        if _token['v'] and time.time() < _token['exp'] - 120:
            return _token['v']
        r = HTTP.post('https://open.feishu.cn/open-apis/auth/v3/tenant_access_token/internal',
                          json={'app_id': cfg['app_id'], 'app_secret': cfg['app_secret']}, timeout=15)
        d = r.json()
        if d.get('code') != 0 or not d.get('tenant_access_token'):
            raise RuntimeError('获取飞书令牌失败: ' + json.dumps(d, ensure_ascii=False))
        _token['v'] = d['tenant_access_token']
        _token['exp'] = time.time() + int(d.get('expire', 7200))
        return _token['v']

def bh():
    return {'Authorization': 'Bearer ' + get_token(), 'Content-Type': 'application/json'}

def fe_url(tid, extra=''):
    cfg = load_cfg()
    return f"https://open.feishu.cn/open-apis/bitable/v1/apps/{cfg['app_token']}/tables/{tid}/records" + extra

def list_records_raw(tid):
    out, pt = [], None
    while True:
        extra = '?page_size=500' + (('&page_token=' + pt) if pt else '')
        d = HTTP.get(fe_url(tid, extra), headers=bh(), timeout=25).json()
        if d.get('code') != 0:
            raise RuntimeError('读取记录失败: ' + json.dumps(d, ensure_ascii=False))
        data = d.get('data') or {}
        out += data.get('items') or []
        if data.get('has_more'):
            pt = data.get('page_token')
        else:
            break
    return out

# ---------- 操作日志 ----------
def write_log(action, target='', detail=''):
    """异步写操作日志：立即返回，不阻塞接口响应；detail 可传函数（在后台线程取值）"""
    try:
        cfg = load_cfg()
        tid = cfg.get('tid_logs')
        if not tid:
            return
        if callable(detail):
            try:
                detail = detail()
            except Exception:
                detail = ''
        fields = {
            '时间': int(time.time() * 1000),
            '动作': str(action)[:50],
            '对象': str(target or '')[:200],
            '详情': str(detail or '')[:500],
        }
        def _post():
            try:
                HTTP.post(fe_url(tid), headers=bh(), json={'fields': fields}, timeout=15)
            except Exception:
                pass
        threading.Thread(target=_post, daemon=True).start()
    except Exception:
        pass

def record_brief(rid):
    """读取记录摘要用于日志展示，失败返回 rid"""
    try:
        cfg = load_cfg()
        d = HTTP.get(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(), timeout=15).json()
        f = (d.get('data') or {}).get('record', {}).get('fields') or {}
        return (str(f.get('年级') or '') + str(f.get('班级') or '') + '·' +
                str(f.get('事项细项') or '') + '(' + str(f.get('分值') or '') + '分)')
    except Exception:
        return rid

@app.route('/api/logs')
def get_logs():
    cfg = load_cfg()
    tid = cfg.get('tid_logs')
    out = []
    if tid:
        try:
            for item in list_records_raw(tid):
                f = item.get('fields') or {}
                ts = num(f.get('时间'))
                out.append({
                    'time': time.strftime('%Y-%m-%d %H:%M', time.localtime(ts / 1000)) if ts else '',
                    '_ts': ts,
                    'action': f.get('动作') or '', 'target': f.get('对象') or '',
                    'detail': f.get('详情') or '',
                })
        except Exception:
            pass
    out.sort(key=lambda x: -x['_ts'])
    return jsonify(ok=True, logs=out[:200])

def norm_record(item):
    f = item.get('fields') or {}
    ts = num(f.get('检查时间'))
    tstr = time.strftime('%Y-%m-%d %H:%M', time.localtime(ts / 1000)) if ts else ''
    sc = f.get('分值')
    try:
        sc = float(sc)
    except (TypeError, ValueError):
        sc = 0
    return {
        'rid': item.get('record_id'),
        'time': tstr, '_ts': ts or 0,
        'grade': f.get('年级') or '', 'cls': f.get('班级') or '',
        'dept': f.get('部门') or '', 'item': f.get('事项细项') or '',
        'type': f.get('类型') or '', 'score': int(sc) if sc == int(sc) else sc,
        'desc': f.get('事实描述') or '', 'user': f.get('使用人') or '', 'student': f.get('学生') or '',
        'src': f.get('登记来源') or '',
        'building': rt(f.get('楼栋')) or '', 'room': rt(f.get('房间')) or '', 'bed': rt(f.get('床位')) or '',
        'status': f.get('状态') or '有效', 'cancel_reason': f.get('消分原因') or '',
    }

def norm_user(item):
    f = item.get('fields') or {}
    return {'rid': item.get('record_id'), 'name': f.get('姓名') or '',
            'grade': f.get('年级') or '', 'identity': f.get('身份') or '',
            'dept': rt(f.get('部门')) or '', 'grp': rt(f.get('组别')) or '',
            'cls': rt(f.get('班级')) or ''}

def get_appeals_raw():
    return list_records_raw(load_cfg()['tid_appeals'])

def rt(v):
    """飞书富文本/文本统一取字符串"""
    if isinstance(v, list) and v and isinstance(v[0], dict):
        return ''.join(str(x.get('text') or '') for x in v)
    return v

def num(v, default=0):
    """飞书数字字段可能返回字符串（如 '1789742031998'），统一安全转数值"""
    try:
        return float(v)
    except (TypeError, ValueError):
        return default

def upload_media(filename, data_bytes):
    """上传附件到飞书，返回 file_token（失败返回 None）"""
    try:
        cfg = load_cfg()
        url = 'https://open.feishu.cn/open-apis/drive/v1/medias/upload_all'
        files = {'file': (filename, data_bytes, 'image/jpeg')}
        data = {'file_name': filename, 'parent_type': 'bitable_image', 'size': str(len(data_bytes))}
        d = HTTP.post(url, headers={'Authorization': 'Bearer ' + get_token()}, data=data, files=files, timeout=120).json()
        return (d.get('data') or {}).get('file_token')
    except Exception:
        return None

def norm_appeal(item):
    f = item.get('fields') or {}
    t = num(f.get('提交时间'))
    tstr = time.strftime('%Y-%m-%d %H:%M', time.localtime(t / 1000)) if t else ''
    atts = [{'name': rt(x.get('name')) or '附件', 'url': x.get('url') or ''}
            for x in (f.get('附件') or []) if isinstance(x, dict)]
    return {'arid': item.get('record_id'), 'rid': rt(f.get('关联记录')) or '',
            'appellant': rt(f.get('申诉人')) or '', 'reason': rt(f.get('申诉理由')) or '',
            'time': tstr, 'status': rt(f.get('状态')) or '待处理', 'opinion': rt(f.get('处理意见')) or '',
            'attachments': atts}

_cred_cache = {'v': None, 'exp': 0}
_users_cache = {'v': None, 'exp': 0}

def get_users_cached():
    """用户表缓存 60s：登录查部门/教师名单用"""
    now = time.time()
    if _users_cache['v'] is None or now > _users_cache['exp']:
        try:
            _users_cache['v'] = [norm_user(i) for i in list_records_raw(load_cfg()['tid_users'])]
        except Exception:
            _users_cache['v'] = []
        _users_cache['exp'] = now + 60
    return _users_cache['v']

def get_creds():
    """凭据表缓存 60s：角色 -> 密码哈希"""
    now = time.time()
    if _cred_cache['v'] is None or now > _cred_cache['exp']:
        rows = {}
        try:
            tid = load_cfg().get('tid_creds')
            if tid:
                for it in list_records_raw(tid):
                    f = it.get('fields') or {}
                    rows[rt(f.get('角色')) or ''] = rt(f.get('密码哈希')) or ''
        except Exception:
            rows = {}
        _cred_cache['v'] = rows
        _cred_cache['exp'] = now + 60
    return _cred_cache['v']

ROLE_OF_LEVEL = {'reg': '学生会', 'admin': '管理员', 'bzr': '班主任'}

def check_pw(level, pw):
    role = ROLE_OF_LEVEL.get(level)
    h = get_creds().get(role) if role else None
    if not h:
        cfg = load_cfg()
        key = 'admin_pw_hash' if level == 'admin' else 'reg_pw_hash'
        return sha(pw) == cfg.get(key)
    if sha(pw) == h:
        return True
    # 管理员口令可作为登记级别通行（管理员全功能）
    if level != 'admin':
        ah = get_creds().get('管理员')
        if ah and sha(pw) == ah:
            return True
    return False

def need_auth(level):
    pw = request.headers.get('X-PW')
    if not check_pw(level, pw):
        return jsonify(ok=False, msg='口令验证失败，请重新输入' + level + '口令'), 401

# ---------- 页面 ----------
@app.route('/')
def index():
    return send_from_directory(os.path.join(BASE, 'templates'), 'index.html')

# ---------- 认证 ----------
@app.route('/api/login', methods=['POST'])
def login():
    b = request.get_json(force=True)
    level = b.get('level') or b.get('role'); pw = b.get('password')
    if level not in ('reg', 'admin', 'bzr'):
        write_log('登录失败', '参数错误', 'level=' + repr(level))
        return jsonify(ok=False, msg='参数错误'), 400
    if not check_pw(level, pw):
        return jsonify(ok=False, msg='口令不正确'), 401
    if level == 'reg':
        name = (b.get('name') or '').strip()
        if not name:
            return jsonify(ok=False, msg='请选择登记人'), 400
        dept = ''
        for u in get_users_cached():
            if u['name'] == name:
                dept = u.get('dept') or ''
                break
        return jsonify(ok=True, role='学生会', name=name, dept=dept)
    if level == 'bzr':
        name = (b.get('name') or '').strip()
        if not name:
            return jsonify(ok=False, msg='请选择姓名'), 400
        cls = ''
        found = False
        for u in get_users_cached():
            if u['name'] == name and u['identity'] == '老师':
                cls = u.get('cls') or ''
                found = True
                break
        if not found:
            return jsonify(ok=False, msg='该姓名不在教师名单中'), 401
        if not cls:
            return jsonify(ok=False, msg='该教师未绑定班级，请联系管理员在用户表填写'), 400
        return jsonify(ok=True, role='班主任', name=name, cls=cls)
    return jsonify(ok=True, role='管理员')

@app.route('/api/password', methods=['POST'])
def change_pw():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    level = b.get('level'); new = b.get('new_password')
    if level not in ('reg', 'admin', 'bzr') or not new or len(new) < 4:
        return jsonify(ok=False, msg='新口令至少 4 位'), 400
    cfg = load_cfg()
    role = ROLE_OF_LEVEL[level]
    h = sha(new)
    tid_c = cfg.get('tid_creds')
    target = None
    if tid_c:
        try:
            for it in list_records_raw(tid_c):
                f = it.get('fields') or {}
                if rt(f.get('角色')) == role:
                    target = it.get('record_id'); break
        except Exception:
            pass
    if target:
        d = HTTP.put(fe_url(tid_c) + '/' + target, headers=bh(),
                         json={'fields': {'密码哈希': h, '更新时间': int(time.time() * 1000)}}, timeout=20).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='写入凭据表失败: ' + str(d.get('msg'))), 500
    else:
        cfg['admin_pw_hash' if level == 'admin' else 'reg_pw_hash'] = h
        save_cfg(cfg)
    _cred_cache['v'] = None
    write_log('修改口令', role + ' 口令', '口令已更新')
    return jsonify(ok=True)

# ---------- 用户表 ----------
@app.route('/api/users')
def get_users():
    users = [norm_user(i) for i in list_records_raw(load_cfg()['tid_users'])]
    return jsonify(ok=True, users=users)

@app.route('/api/users', methods=['POST'])
def add_user():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    name = (b.get('name') or '').strip()
    if not name:
        return jsonify(ok=False, msg='姓名必填'), 400
    cfg = load_cfg()
    fields = {'姓名': name, '年级': b.get('grade') or '', '身份': b.get('identity') or '', '部门': b.get('dept') or '', '组别': b.get('grp') or '', '班级': b.get('cls') or ''}
    d = HTTP.post(fe_url(cfg['tid_users']), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg'))), 500
    write_log('新增用户', name, str(b.get('grade') or '') + '·' + str(b.get('identity') or '') + '·' + str(b.get('dept') or ''))
    return jsonify(ok=True, rid=d['data']['record']['record_id'])

@app.route('/api/users/<rid>', methods=['PUT'])
def upd_user(rid):
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    name = (b.get('name') or '').strip()
    if not name:
        return jsonify(ok=False, msg='姓名必填'), 400
    cfg = load_cfg()
    fields = {'姓名': name, '年级': b.get('grade') or '', '身份': b.get('identity') or '',
              '部门': b.get('dept') or '', '组别': b.get('grp') or '', '班级': b.get('cls') or ''}
    d = HTTP.put(fe_url(cfg['tid_users']) + '/' + rid, headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='更新失败: ' + str(d.get('msg'))), 500
    write_log('修改用户', name, str(b.get('grade') or '') + '·' + str(b.get('identity') or '') + '·' + str(b.get('dept') or ''))
    _users_cache['v'] = None
    return jsonify(ok=True)

@app.route('/api/users/<rid>', methods=['DELETE'])
def del_user(rid):
    b = request.get_json(silent=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    d = HTTP.delete(fe_url(cfg['tid_users']) + '/' + rid, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除用户', 'rid=' + rid)
        _users_cache['v'] = None
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

# ---------- 班级字典 ----------
@app.route('/api/classes')
def get_classes():
    cfg = load_cfg()
    tid = cfg.get('tid_classes')
    classes = {}
    if tid:
        try:
            for item in list_records_raw(tid):
                f = item.get('fields') or {}
                grade = f.get('年级'); cls = f.get('班级')
                if grade and cls:
                    classes.setdefault(grade, [])
                    if cls not in classes[grade]:
                        classes[grade].append(cls)
        except Exception:
            pass
    if not classes:
        classes = cfg.get('classes', {})
    for g in GRADE_ORDER:
        classes.setdefault(g, [])
    return jsonify(ok=True, classes=classes, source=('feishu' if classes else 'config'))

# ---------- 检查记录 ----------
@app.route('/api/records')
def get_records():
    items = list_records_raw(load_cfg()['tid_records'])
    recs = [norm_record(i) for i in items]
    recs.sort(key=lambda x: x['_ts'], reverse=True)
    return jsonify(ok=True, records=recs)

@app.route('/api/records', methods=['POST'])
def add_record():
    b = request.get_json(force=True)
    if not check_pw('reg', b.get('reg_password')):
        return jsonify(ok=False, msg='登记口令验证失败'), 401
    labels = {'grade': '年级', 'cls': '班级', 'dept': '登记部门', 'item': '事项细项', 'user': '使用人'}
    missing = [labels[k] for k in ('grade', 'cls', 'dept', 'item', 'user') if not (b.get(k) or '').strip()]
    if missing:
        return jsonify(ok=False, msg='请完整填写：' + '、'.join(missing)), 400
    try:
        score = float(b.get('score'))
    except (TypeError, ValueError):
        return jsonify(ok=False, msg='分值必须是数字'), 400
    cfg = load_cfg()
    if b.get('time_str'):
        tt = time.strptime(b['time_str'], '%Y-%m-%d %H:%M')
        ts = int(time.mktime(tt) * 1000)
    else:
        ts = int(time.time() * 1000)
    fields = {
        '检查时间': ts,
        '年级': b.get('grade'), '班级': (b.get('cls') or '').strip(),
        '部门': b.get('dept'), '事项细项': (b.get('item') or '').strip(),
        '类型': b.get('type') or '扣分', '分值': abs(score) if (b.get('type') != '加分') else abs(score),
        '事实描述': (b.get('desc') or '').strip(), '使用人': (b.get('user') or '').strip(),
        '登记来源': '桌面应用',
    }
    if b.get('type') == '加分':
        fields['分值'] = abs(score)
    else:
        fields['分值'] = -abs(score)
    for k, col in (('building', '楼栋'), ('room', '房间'), ('bed', '床位')):
        v = (b.get(k) or '').strip()
        if v:
            fields[col] = v[:30]
    d = HTTP.post(fe_url(cfg['tid_records']), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg'))), 500
    return jsonify(ok=True, rid=d['data']['record']['record_id'])

@app.route('/api/records/<rid>', methods=['PUT'])
def edit_record(rid):
    b = request.get_json(force=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    fields = {}
    if b.get('score') is not None:
        try:
            v = float(b['score'])
            fields['分值'] = -abs(v) if b.get('type') == '扣分' else abs(v)
        except (TypeError, ValueError):
            return jsonify(ok=False, msg='分值必须是数字'), 400
    if b.get('type'): fields['类型'] = b['type']
    if b.get('desc') is not None: fields['事实描述'] = b['desc']
    if not fields:
        return jsonify(ok=False, msg='没有要修改的内容'), 400
    cfg = load_cfg()
    brief = record_brief(rid)
    d = HTTP.put(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') == 0:
        write_log('改分', brief, ', '.join(k + '=' + str(v) for k, v in fields.items()))
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

@app.route('/api/records/<rid>', methods=['DELETE'])
def del_record(rid):
    if not check_pw('admin', request.headers.get('X-PW')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    brief = record_brief(rid)
    d = HTTP.delete(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除记录', brief)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

# ---------- 细则字典 ----------
@app.route('/api/rules')
def get_rules():
    items = list_records_raw(load_cfg()['tid_rules'])
    rules = []
    for i in items:
        f = i.get('fields') or {}
        try:
            sc = float(f.get('默认分值'))
        except (TypeError, ValueError):
            sc = 0
        rules.append({'rid': i.get('record_id'), 'item': f.get('事项细项') or '',
                      'dept': f.get('归属部门') or '', 'type': f.get('类型') or '',
                      'score': int(sc) if sc == int(sc) else sc})
    rules.sort(key=lambda x: (x['dept'], x['type'], -abs(x['score']) if isinstance(x['score'], (int, float)) else 0))
    return jsonify(ok=True, rules=rules)

@app.route('/api/rules', methods=['POST'])
def add_rule():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    item = (b.get('item') or '').strip()
    if not item or not b.get('dept'):
        return jsonify(ok=False, msg='细项与部门必填'), 400
    cfg = load_cfg()
    fields = {'事项细项': item, '归属部门': b.get('dept'), '类型': b.get('type') or '扣分',
              '默认分值': int(b.get('score') or 1)}
    d = HTTP.post(fe_url(cfg['tid_rules']), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg'))), 500
    write_log('新增细则', str(b.get('dept') or '') + '·' + item, str(b.get('type') or '扣分') + ' ' + str(b.get('score') or 1) + '分')
    return jsonify(ok=True, rid=d['data']['record']['record_id'])

@app.route('/api/rules/<rid>', methods=['PUT'])
def upd_rule(rid):
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    item = (b.get('item') or '').strip()
    if not item or not b.get('dept'):
        return jsonify(ok=False, msg='细项与部门必填'), 400
    cfg = load_cfg()
    fields = {'事项细项': item, '归属部门': b.get('dept'), '类型': b.get('type') or '扣分',
              '默认分值': int(b.get('score') or 1)}
    d = HTTP.put(fe_url(cfg['tid_rules']) + '/' + rid, headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='更新失败: ' + str(d.get('msg'))), 500
    write_log('修改细则', str(b.get('dept') or '') + '·' + item, str(b.get('type') or '扣分') + ' ' + str(b.get('score') or 1) + '分')
    return jsonify(ok=True)

@app.route('/api/rules/<rid>', methods=['DELETE'])
def del_rule(rid):
    if not check_pw('admin', request.headers.get('X-PW')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    d = HTTP.delete(fe_url(cfg['tid_rules']) + '/' + rid, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除细则', 'rid=' + rid)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

# ---------- 申诉与消分 ----------
@app.route('/api/appeals')
def get_appeals():
    recs = {r['rid']: r for r in (norm_record(i) for i in list_records_raw(load_cfg()['tid_records']))}
    appeals = []
    for a in (norm_appeal(i) for i in get_appeals_raw()):
        a['record'] = recs.get(a['rid'])
        appeals.append(a)
    appeals.sort(key=lambda x: x['status'] != '待处理')
    return jsonify(ok=True, appeals=appeals)

@app.route('/api/appeals', methods=['POST'])
def add_appeal():
    b = request.get_json(force=True)
    rid = b.get('rid'); appellant = (b.get('appellant') or '').strip()
    reason = (b.get('reason') or '').strip()
    if not rid or not appellant or not reason:
        return jsonify(ok=False, msg='关联记录、申诉人、申诉理由必填'), 400
    cfg = load_cfg()
    fields = {'关联记录': rid, '申诉人': appellant, '申诉理由': reason,
              '提交时间': int(time.time() * 1000), '状态': '待处理'}
    atts = b.get('attachments') or []
    if isinstance(atts, list) and atts:
        import base64 as _b64
        toks = []
        for i, a in enumerate(atts[:3]):
            try:
                data = _b64.b64decode(a.split(',', 1)[-1])
                tk = upload_media('申诉附件%d.jpg' % (i + 1), data)
                if tk:
                    toks.append({'file_token': tk})
            except Exception:
                pass
        if toks:
            fields['附件'] = toks
    d = HTTP.post(fe_url(cfg['tid_appeals']), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='提交失败: ' + str(d.get('msg'))), 500
    write_log('发起申诉', appellant, '关联 ' + rid[:20] + (' · 附' + str(len(toks)) + '个附件' if toks else ''))
    HTTP.put(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(),
                 json={'fields': {'状态': '申诉中'}}, timeout=20)
    return jsonify(ok=True, arid=d['data']['record']['record_id'])

@app.route('/api/appeals/<arid>', methods=['POST'])
def handle_appeal(arid):
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    result = b.get('result')
    if result not in ('已维持', '已更正', '已消分', '已撤销'):
        return jsonify(ok=False, msg='处理结果参数错误'), 400
    opinion = (b.get('opinion') or '').strip()
    cfg = load_cfg()
    d = HTTP.get(fe_url(cfg['tid_appeals']) + '/' + arid, headers=bh(), timeout=20).json()
    rid = rt((d.get('data') or {}).get('record', {}).get('fields', {}).get('关联记录'))
    if not rid:
        return jsonify(ok=False, msg='申诉记录异常：未找到关联记录'), 500
    upd = {'状态': result, '处理意见': opinion}
    HTTP.put(fe_url(cfg['tid_appeals']) + '/' + arid, headers=bh(), json={'fields': upd}, timeout=20)
    rec_fields = {}
    if result == '已维持':
        rec_fields = {'状态': '有效'}
    elif result == '已更正':
        rec_fields = {'状态': '有效', '处理意见': opinion}
        try:
            ns = float(b.get('new_score'))
            rec_fields['分值'] = -abs(ns) if b.get('rec_type') != '加分' else abs(ns)
        except (TypeError, ValueError):
            pass
    elif result == '已消分':
        rec_fields = {'状态': '已消分', '消分原因': '申诉' + result + '：' + opinion}
    elif result == '已撤销':
        rec_fields = {'状态': '已撤销', '消分原因': '申诉' + result + '：' + opinion}
    HTTP.put(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(), json={'fields': rec_fields}, timeout=20)
    write_log('申诉处理', record_brief(rid), '结果：' + result + (('；' + opinion) if opinion else ''))
    return jsonify(ok=True)

@app.route('/api/records/<rid>/cancel', methods=['POST'])
def cancel_score(rid):
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    reason = (b.get('reason') or '管理员消分').strip()
    cfg = load_cfg()
    brief = record_brief(rid)
    d = HTTP.put(fe_url(cfg['tid_records']) + '/' + rid, headers=bh(),
                     json={'fields': {'状态': '已消分', '消分原因': reason}}, timeout=20).json()
    if d.get('code') == 0:
        write_log('消分', brief, '原因：' + reason)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

# ---------- 批量写入 ----------
@app.route('/api/records/batch', methods=['POST'])
def add_records_batch():
    b = request.get_json(force=True)
    if not check_pw('reg', b.get('reg_password')):
        return jsonify(ok=False, msg='登记口令验证失败'), 401
    recs = b.get('records') or []
    if not recs:
        return jsonify(ok=False, msg='没有可提交的记录'), 400
    cfg = load_cfg()
    fields_list = []
    for r in recs:
        try:
            score = float(r.get('score'))
        except (TypeError, ValueError):
            return jsonify(ok=False, msg='存在非数字分值'), 400
        for k in ('grade', 'cls', 'dept', 'item'):
            if not (r.get(k) or '').strip():
                return jsonify(ok=False, msg='存在未填写完整的行（缺 ' + k + '）'), 400
        v = -abs(score) if r.get('type') != '加分' else abs(score)
        fields_list.append({'fields': {
            '检查时间': int(time.time() * 1000),
            '年级': r['grade'], '班级': r['cls'], '部门': r['dept'],
            '事项细项': r['item'], '类型': r.get('type') or '扣分', '分值': v,
            '事实描述': (r.get('note') or '').strip(), '学生': (r.get('student') or '').strip(), '使用人': (r.get('user') or '').strip(),
            '登记来源': '桌面应用',
        }})
    ok_n = 0
    for i in range(0, len(fields_list), 500):
        chunk = fields_list[i:i + 500]
        d = HTTP.post(fe_url(cfg['tid_records']) + '/batch_create', headers=bh(), json={'records': chunk}, timeout=40).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='批量写入失败: ' + str(d.get('msg')), done=ok_n), 500
        ok_n += len(chunk)
    return jsonify(ok=True, count=ok_n)

# ---------- 检查排班 ----------
DEFAULT_DUTY_RULES = {
    '纪检部': [{'slot':'早读','n':2},{'slot':'午休','n':2},{'slot':'晚自习','n':2}],
    '艺体部': [{'slot':'大课间','n':4},{'slot':'机动','n':1}],
    '宿管部': [{'slot':'早查','n':2},{'slot':'晚查','n':2}],
    '劳动部': [{'slot':'包干区小检','n':3},{'slot':'机动','n':1}],
    '学习部': [{'slot':'早读检查','n':2},{'slot':'作业收交','n':2}],
    '礼仪部': [{'slot':'执勤抽查','n':2},{'slot':'机动','n':2}],
}

@app.route('/api/duty_rules', methods=['GET', 'POST'])
def duty_rules():
    cfg = load_cfg()
    if request.method == 'GET':
        rules = cfg.get('duty_rules')
        if not rules:
            rules = DEFAULT_DUTY_RULES
            cfg['duty_rules'] = rules
            save_cfg(cfg)
        return jsonify(ok=True, rules=rules)
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    rules = b.get('rules')
    if not isinstance(rules, dict) or not rules:
        return jsonify(ok=False, msg='规则格式错误'), 400
    clean = {}
    for dept, slots in rules.items():
        if not isinstance(dept, str) or not dept.strip():
            continue
        clean[dept.strip()] = [{'slot': str(x.get('slot') or '').strip(), 'n': max(1, int(x.get('n') or 1))}
                               for x in (slots or []) if str(x.get('slot') or '').strip()]
    if not clean:
        return jsonify(ok=False, msg='至少保留一个部门的有效规则'), 400
    cfg['duty_rules'] = clean
    save_cfg(cfg)
    write_log('修改值勤规则', '排班配置', json.dumps(clean, ensure_ascii=False)[:400])
    return jsonify(ok=True)

@app.route('/api/duty_ai', methods=['POST'])
def duty_ai():
    """AI 排班：注入值勤规则+可用人员，返回结构化排班（可应用）或文本建议"""
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    llm = cfg.get('llm') or {}
    if not (llm.get('enabled') and llm.get('base_url') and llm.get('api_key') and llm.get('model')):
        return jsonify(ok=False, msg='AI 未接入：请在 config.json 中配置 "llm": {"enabled": true, "base_url": "...", "api_key": "...", "model": "..."} 后重启服务')
    instruction = (b.get('instruction') or '').strip()
    if not instruction:
        return jsonify(ok=False, msg='请输入调整指令'), 400
    import re as _re
    dept = (b.get('dept') or '').strip()
    grade = (b.get('grade') or '').strip()
    rules = cfg.get('duty_rules') or DEFAULT_DUTY_RULES
    pool = [u for u in get_users_cached()
            if (not dept or u.get('dept') == dept) and (not grade or u.get('grade') == grade)]
    if not pool:
        return jsonify(ok=False, msg='可用人员为空：请先在用户表为成员填写部门与组别'), 400
    pool_lines = '\n'.join('- ' + u['name'] + '（' + (u.get('dept') or '') + '/' + (u.get('grade') or '') + '/组' + (u.get('grp') or '?') + '）' for u in pool)
    rules_lines = '\n'.join(dp + '：' + ' + '.join(sl['slot'] + str(sl['n']) + '人' for sl in slots) for dp, slots in rules.items())
    system = (
        '你是学生会检查排班助手。请根据值勤规则、可用人员与用户指令，安排本周检查排班。\n'
        '【值勤规则（部门：每日时段与人数）】\n' + rules_lines +
        '\n【值勤日】A 组值勤周一/三/五，B 组值勤周二/四；高三分会免晚自习时段。\n'
        '【可用人员（姓名（部门/年级/组））】\n' + pool_lines +
        '\n【输出要求】先用一两句话说明安排思路；然后单独一行输出 JSON 数组（不要代码块包裹），'
        '格式：[{"weekday":"周一","slot":"时段名","name":"人员姓名"}]。'
        'weekday 限周一至周五；slot 必须来自该人员所属部门的规则时段；name 必须来自可用人员名单，不得编造。'
    )
    try:
        d = HTTP.post(llm['base_url'].rstrip('/') + '/chat/completions',
                          headers={'Authorization': 'Bearer ' + llm['api_key']},
                          json={'model': llm['model'], 'messages': [
                              {'role': 'system', 'content': system},
                              {'role': 'user', 'content': instruction}]}, timeout=90).json()
        text = ((d.get('choices') or [{}])[0].get('message') or {}).get('content') or ''
    except Exception as e:
        return jsonify(ok=False, msg='AI 调用失败: ' + str(e)[:200]), 500
    schedule = []
    m = _re.search(r'\[[\s\S]*?\]', text)
    if m:
        try:
            arr = json.loads(m.group(0))
            valid_names = {u['name']: u for u in pool}
            valid_slots = set()
            for dp, slots in rules.items():
                if dept and dp != dept:
                    continue
                for sl in slots:
                    valid_slots.add(sl['slot'])
            for x in arr:
                if not isinstance(x, dict):
                    continue
                nm = x.get('name')
                if nm in valid_names and x.get('weekday') in ('周一', '周二', '周三', '周四', '周五') and x.get('slot') in valid_slots:
                    schedule.append({'weekday': x['weekday'], 'slot': x['slot'],
                                     'name': nm, 'grp': valid_names[nm].get('grp') or ''})
        except Exception:
            schedule = []
    write_log('AI排班', llm['model'], instruction[:150] + ' → ' + str(len(schedule)) + ' 条')
    return jsonify(ok=True, reply=text, schedule=schedule)


@app.route('/api/duties')
def get_duties():
    base = request.args.get('date') or time.strftime('%Y-%m-%d')
    try:
        d0 = time.strptime(base, '%Y-%m-%d')
    except ValueError:
        return jsonify(ok=False, msg='日期格式错误'), 400
    import datetime as _dt
    dt = _dt.datetime.strptime(base, '%Y-%m-%d')
    monday = dt - _dt.timedelta(days=dt.weekday())
    start_ms = int(time.mktime(monday.timetuple()) * 1000)
    end_ms = start_ms + 7 * 86400 * 1000
    cfg = load_cfg()
    out = []
    tid = cfg.get('tid_duty')
    if tid:
        for it in list_records_raw(tid):
            f = it.get('fields') or {}
            raw = f.get('日期')
            try:
                ts = float(raw) if raw is not None and str(raw).strip() != '' else 0
            except (TypeError, ValueError):
                ts = 0
            if not (start_ms <= ts < end_ms):
                continue
            dstr = time.strftime('%Y-%m-%d', time.localtime(ts / 1000)) if ts else ''
            out.append({'did': it.get('record_id'), 'date': dstr,
                        'weekday': rt(f.get('星期')) or '', 'slot': rt(f.get('时段')) or '',
                        'name': rt(f.get('检查员')) or '', 'cls': rt(f.get('班级')) or '',
                        'dept': rt(f.get('部门')) or '', 'grp': rt(f.get('组别')) or ''})
    out.sort(key=lambda x: (x['date'], x['slot'], x['name']))
    return jsonify(ok=True, duties=out, monday=monday.strftime('%Y-%m-%d'))

@app.route('/api/duties/batch', methods=['POST'])
def add_duties_batch():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    recs = b.get('records') or []
    if not recs:
        return jsonify(ok=False, msg='没有可写入的安排'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_duty')
    if not tid:
        return jsonify(ok=False, msg='未配置检查安排表'), 500
    fields_list = []
    for r in recs:
        fields_list.append({'fields': {
            '日期': int(r.get('date_ms') or 0), '星期': r.get('weekday') or '',
            '时段': r.get('slot') or '', '检查员': r.get('name') or '',
            '班级': r.get('cls') or '', '部门': r.get('dept') or '', '组别': r.get('grp') or '',
        }})
    # purge: 'week' 清本周全部 / 'week_dept' 清本周该部门 —— 防止重复生成堆积
    purge = b.get('purge')
    if purge in ('week', 'week_dept'):
        import datetime as _dt
        base = b.get('week_start') or time.strftime('%Y-%m-%d')
        dt0 = _dt.datetime.strptime(base, '%Y-%m-%d')
        monday = dt0 - _dt.timedelta(days=dt0.weekday())
        start_ms = int(time.mktime(monday.timetuple()) * 1000)
        end_ms = start_ms + 7 * 86400 * 1000
        stale = []
        for it in list_records_raw(tid):
            f = it.get('fields') or {}
            raw = f.get('日期')
            try:
                ts = float(raw) if raw is not None and str(raw).strip() != '' else 0
            except (TypeError, ValueError):
                ts = 0
            if start_ms <= ts < end_ms:
                if purge == 'week_dept' and rt(f.get('部门')) != (b.get('dept') or ''):
                    continue
                stale.append(it.get('record_id'))
        for i in range(0, len(stale), 500):
            chunk = stale[i:i + 500]
            HTTP.delete(fe_url(tid) + '/batch_delete', headers=bh(), json={'records': chunk}, timeout=40)
        print('purge 清除旧排班:', len(stale))
    ok_n = 0
    for i in range(0, len(fields_list), 500):
        chunk = fields_list[i:i + 500]
        d = HTTP.post(fe_url(tid) + '/batch_create', headers=bh(), json={'records': chunk}, timeout=40).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg')), done=ok_n), 500
        ok_n += len(chunk)
    if recs:
        write_log('生成排班', '全校' if b.get('purge') == 'week' else (recs[0].get('dept') or ''), '共 ' + str(ok_n) + ' 条安排' + ('（清除旧排班 ' + str(len(stale)) + ' 条）' if purge else ''))
    return jsonify(ok=True, count=ok_n)

@app.route('/api/duties/<did>', methods=['DELETE'])
def del_duty(did):
    if not check_pw('admin', request.headers.get('X-PW')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    tid = cfg.get('tid_duty')
    if not tid:
        return jsonify(ok=False, msg='未配置检查安排表'), 500
    d = HTTP.delete(fe_url(tid) + '/' + did, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除排班', 'did=' + did)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

@app.route('/api/users/swap_ab', methods=['POST'])
def swap_ab():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    tid = cfg['tid_users']
    updates = []
    for u in (norm_user(i) for i in list_records_raw(tid)):
        grp = (u.get('grp') or '').strip().upper()
        if grp in ('A', 'B'):
            updates.append({'record_id': u['rid'], 'fields': {'组别': ('B' if grp == 'A' else 'A')}})
    ok_n = 0
    for i in range(0, len(updates), 500):
        chunk = updates[i:i + 500]
        d = HTTP.post(fe_url(tid) + '/batch_update', headers=bh(), json={'records': chunk}, timeout=40).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='互换失败: ' + str(d.get('msg')), done=ok_n), 500
        ok_n += len(chunk)
    write_log('AB组互换', '用户表', '对调 ' + str(ok_n) + ' 人')
    _users_cache['v'] = None
    return jsonify(ok=True, count=ok_n)

# ---------- 公告与留言 ----------
@app.route('/api/notices')
def get_notices():
    cfg = load_cfg()
    out = []
    tid = cfg.get('tid_notices')
    if tid:
        try:
            for it in list_records_raw(tid):
                f = it.get('fields') or {}
                ts = num(f.get('发布时间'))
                pin = f.get('置顶')
                out.append({'nid': it.get('record_id'),
                            'title': rt(f.get('标题')) or '', 'content': rt(f.get('内容')) or '',
                            'by': rt(f.get('发布人')) or '', 'ts': ts,
                            'pin': bool(pin), 'time': time.strftime('%m-%d %H:%M', time.localtime(ts / 1000)) if ts else ''})
        except Exception:
            pass
    out.sort(key=lambda x: (-int(x['pin']), -x['ts']))
    return jsonify(ok=True, notices=out[:50])

@app.route('/api/notices', methods=['POST'])
def add_notice():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    title = (b.get('title') or '').strip()
    content = (b.get('content') or '').strip()
    if not title or not content:
        return jsonify(ok=False, msg='标题与内容必填'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_notices')
    if not tid:
        return jsonify(ok=False, msg='未配置公告表'), 500
    fields = {'标题': title, '内容': content, '发布人': '管理员',
              '发布时间': int(time.time() * 1000)}
    if b.get('pin'):
        fields['置顶'] = ['置顶']  # 公告表「置顶」是多选字段：勾选写选项，不勾选整个字段省略
    d = HTTP.post(fe_url(tid), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='发布失败: ' + str(d.get('msg'))), 500
    write_log('发布公告', title[:30])
    return jsonify(ok=True)

@app.route('/api/notices/<nid>', methods=['DELETE'])
def del_notice(nid):
    if not check_pw('admin', request.headers.get('X-PW')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    tid = cfg.get('tid_notices')
    if not tid:
        return jsonify(ok=False, msg='未配置公告表'), 500
    d = HTTP.delete(fe_url(tid) + '/' + nid, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除公告', 'nid=' + nid)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

@app.route('/api/messages')
def get_messages():
    cfg = load_cfg()
    out = []
    tid = cfg.get('tid_messages')
    if tid:
        try:
            for it in list_records_raw(tid):
                f = it.get('fields') or {}
                ts = num(f.get('时间'))
                out.append({'mid': it.get('record_id'),
                            'time': time.strftime('%m-%d %H:%M', time.localtime(ts / 1000)) if ts else '',
                            '_ts': ts, 'sender': rt(f.get('发送人')) or '', 'identity': rt(f.get('身份')) or '',
                            'content': rt(f.get('内容')) or '', 'reply': rt(f.get('回复')) or ''})
        except Exception:
            pass
    out.sort(key=lambda x: -x['_ts'])
    return jsonify(ok=True, messages=out[:100])

@app.route('/api/messages', methods=['POST'])
def add_message():
    b = request.get_json(force=True)
    sender = (b.get('sender') or '').strip()
    identity = (b.get('identity') or '').strip()
    content = (b.get('content') or '').strip()
    if not sender or not content:
        return jsonify(ok=False, msg='发送人与内容必填'), 400
    if len(content) > 500:
        return jsonify(ok=False, msg='留言最长 500 字'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_messages')
    if not tid:
        return jsonify(ok=False, msg='未配置留言表'), 500
    d = HTTP.post(fe_url(tid), headers=bh(), json={'fields': {
        '时间': int(time.time() * 1000), '发送人': sender, '身份': identity,
        '内容': content}}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='发送失败: ' + str(d.get('msg'))), 500
    write_log('留言', sender, content[:50])
    return jsonify(ok=True)

@app.route('/api/messages/<mid>', methods=['POST'])
def reply_message(mid):
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    reply = (b.get('reply') or '').strip()
    if not reply:
        return jsonify(ok=False, msg='回复内容必填'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_messages')
    if not tid:
        return jsonify(ok=False, msg='未配置留言表'), 500
    d = HTTP.put(fe_url(tid) + '/' + mid, headers=bh(), json={'fields': {'回复': reply}}, timeout=20).json()
    if d.get('code') == 0:
        write_log('回复留言', 'mid=' + mid, reply[:50])
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

@app.route('/api/messages/<mid>', methods=['DELETE'])
def del_message(mid):
    if not check_pw('admin', request.headers.get('X-PW')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    cfg = load_cfg()
    tid = cfg.get('tid_messages')
    if not tid:
        return jsonify(ok=False, msg='未配置留言表'), 500
    d = HTTP.delete(fe_url(tid) + '/' + mid, headers=bh(), timeout=20).json()
    if d.get('code') == 0:
        write_log('删除留言', 'mid=' + mid)
    return jsonify(ok=d.get('code') == 0, msg=d.get('msg'))

# ---------- 启动 ----------
def _warmup():
    """后台预热飞书凭证与常用缓存，避免首次登录慢"""
    def warm():
        try:
            get_token(); get_creds(); get_users_cached()
        except Exception:
            pass
    threading.Timer(1.0, warm).start()

_warmup()

def open_browser():
    time.sleep(1.2)
    webbrowser.open('http://127.0.0.1:8765')

# ---------- 活动名单 ----------
@app.route('/api/activities')
def get_activities():
    cfg = load_cfg()
    tid = cfg.get('tid_activities')
    out = []
    if tid:
        try:
            for it in list_records_raw(tid):
                f = it.get('fields') or {}
                out.append({'aid': it.get('record_id'),
                            'act': rt(f.get('活动名称')) or '', 'date': rt(f.get('日期')) or '',
                            'cls': rt(f.get('班级')) or '', 'member': rt(f.get('姓名')) or '',
                            'dept': rt(f.get('部门')) or '', 'note': rt(f.get('备注')) or '',
                            'creator': rt(f.get('创建人')) or '', 'ts': num(f.get('创建时间'))})
        except Exception:
            pass
    out.sort(key=lambda x: (x['date'], x['act']), reverse=True)
    return jsonify(ok=True, rows=out)

@app.route('/api/activities', methods=['POST'])
def add_activity():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    name = (b.get('name') or '').strip()
    date = (b.get('date') or '').strip()
    members = b.get('members') or []
    if not name or not date or not members:
        return jsonify(ok=False, msg='活动名称、日期与成员必填'), 400
    cfg = load_cfg()
    note = (b.get('note') or '').strip()
    creator = (b.get('creator') or '管理员').strip()
    now = int(time.time() * 1000)
    records = [{'fields': {
        '活动名称': name[:60], '日期': date[:20],
        '班级': str(m.get('cls') or '')[:30], '姓名': str(m.get('name') or '')[:30],
        '部门': str(m.get('dept') or '')[:20], '备注': note[:200],
        '创建人': creator[:30], '创建时间': now}} for m in members]
    ok_n = 0
    for chunk in [records[i:i+400] for i in range(0, len(records), 400)]:
        d = HTTP.post(fe_url(cfg['tid_activities']) + '/batch_create', headers=bh(), json={'records': chunk}, timeout=60).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg'))), 500
        ok_n += len(chunk)
    write_log('活动归档', name + ' ' + date, str(ok_n) + ' 人')
    return jsonify(ok=True, count=ok_n)

@app.route('/api/activities', methods=['DELETE'])
def del_activity():
    b = request.get_json(silent=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    name = (b.get('name') or '').strip()
    date = (b.get('date') or '').strip()
    if not name or not date:
        return jsonify(ok=False, msg='需指定活动名称与日期'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_activities')
    # 飞书"写入后立即删"存在索引延迟（幽灵记录导致 batch 原子失败、逐条删被限流），
    # 因此删除放后台线程慢慢做（batch + 逐条兜底 + 多轮重试），接口立即返回。
    def _bg_del():
        removed = 0
        try:
            for attempt in range(8):
                ids = []
                try:
                    for it in list_records_raw(tid):
                        f = it.get('fields') or {}
                        if rt(f.get('活动名称')) == name and rt(f.get('日期')) == date:
                            ids.append(it.get('record_id'))
                except Exception:
                    pass
                if not ids:
                    break
                # 整批先删（快，通常清掉大部分）
                try:
                    HTTP.delete(fe_url(tid) + '/batch_delete', headers=bh(), json={'records': ids}, timeout=40)
                except Exception:
                    pass
                time.sleep(1.0)
                # 逐条并行清漏网
                try:
                    rest_ids = []
                    for it in list_records_raw(tid):
                        f = it.get('fields') or {}
                        if rt(f.get('活动名称')) == name and rt(f.get('日期')) == date:
                            rest_ids.append(it.get('record_id'))
                    def _one(rid):
                        try:
                            HTTP.delete(fe_url(tid) + '/' + rid, headers=bh(), timeout=20)
                            return 1
                        except Exception:
                            return 0
                    with ThreadPoolExecutor(max_workers=6) as ex:
                        removed += sum(ex.map(_one, rest_ids))
                except Exception:
                    pass
                time.sleep(2.0)
        except Exception:
            pass
    threading.Thread(target=_bg_del, daemon=True).start()
    return jsonify(ok=True, msg='删除任务已开始', count=0)

# ---------- 排班偏好 ----------
@app.route('/api/duty_prefs')
def get_duty_prefs():
    cfg = load_cfg()
    p = cfg.get('duty_prefs') or {}
    return jsonify(ok=True, prefs={'avoid_self': bool(p.get('avoid_self', True)),
                                   'nearby': bool(p.get('nearby', True))})

@app.route('/api/duty_prefs', methods=['POST'])
def set_duty_prefs():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    prefs = {'avoid_self': bool(b.get('avoid_self')), 'nearby': bool(b.get('nearby'))}
    cfg = load_cfg()
    cfg['duty_prefs'] = prefs
    try:
        json.dump(cfg, open(CONFIG_PATH, 'w', encoding='utf-8'), ensure_ascii=False, indent=2)
    except Exception:
        return jsonify(ok=False, msg='保存失败'), 500
    write_log('排班偏好', '回避本班:' + ('开' if prefs['avoid_self'] else '关') + ' · 就近连班:' + ('开' if prefs['nearby'] else '关'))
    return jsonify(ok=True, prefs=prefs)

# ---------- 宿舍床位 ----------
@app.route('/api/dorms')
def get_dorms():
    cfg = load_cfg()
    out = []
    try:
        for it in list_records_raw(cfg.get('tid_dorms')):
            f = it.get('fields') or {}
            out.append({'rid': it.get('record_id'),
                        'building': rt(f.get('楼栋')) or '', 'room': rt(f.get('房间')) or '',
                        'bed': rt(f.get('床位')) or '', 'grade': rt(f.get('年级')) or '',
                        'cls': rt(f.get('班级')) or '', 'name': rt(f.get('姓名')) or ''})
    except Exception:
        pass
    out.sort(key=lambda x: (x['building'], x['room'], len(x['bed']), x['bed']))
    return jsonify(ok=True, rows=out)

@app.route('/api/dorms', methods=['POST'])
def import_dorms():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    rows = b.get('rows') or []
    if not rows:
        return jsonify(ok=False, msg='没有可导入的床位'), 400
    cfg = load_cfg()
    records = [{'fields': {
        '楼栋': str(r.get('building') or '')[:30], '房间': str(r.get('room') or '')[:20],
        '床位': str(r.get('bed') or '')[:10], '年级': str(r.get('grade') or '')[:10],
        '班级': str(r.get('cls') or '')[:30], '姓名': str(r.get('name') or '')[:30]}} for r in rows]
    n = 0
    for chunk in [records[i:i+400] for i in range(0, len(records), 400)]:
        d = HTTP.post(fe_url(cfg['tid_dorms']) + '/batch_create', headers=bh(), json={'records': chunk}, timeout=60).json()
        if d.get('code') != 0:
            return jsonify(ok=False, msg='写入失败: ' + str(d.get('msg'))), 500
        n += len(chunk)
    write_log('床位导入', '共 ' + str(n) + ' 床')
    return jsonify(ok=True, count=n)

@app.route('/api/dorms', methods=['PUT'])
def edit_dorm():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    rid = b.get('rid')
    if not rid:
        return jsonify(ok=False, msg='缺少床位记录ID'), 400
    field_map = {'building': '楼栋', 'room': '房间', 'bed': '床位', 'grade': '年级', 'cls': '班级', 'name': '姓名'}
    fields = {}
    for k, col in field_map.items():
        if k in b:
            fields[col] = str(b.get(k) or '')[:30]
    if not fields:
        return jsonify(ok=False, msg='没有需要更新的字段'), 400
    cfg = load_cfg()
    d = HTTP.put(fe_url(cfg['tid_dorms']) + '/' + rid, headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='更新失败: ' + str(d.get('msg'))), 500
    return jsonify(ok=True)

@app.route('/api/dorms', methods=['DELETE'])
def del_dorms():
    b = request.get_json(silent=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    rids = b.get('rids') or []
    if not rids:
        return jsonify(ok=False, msg='需指定要删除的床位'), 400
    cfg = load_cfg()
    n = 0
    for rid in rids:
        try:
            d = HTTP.delete(fe_url(cfg['tid_dorms']) + '/' + rid, headers=bh(), timeout=20).json()
            if d.get('code') == 0:
                n += 1
        except Exception:
            pass
    write_log('删除床位', 'rid=' + ','.join(rids[:5]) + ('...' if len(rids) > 5 else ''), str(n) + ' 条')
    return jsonify(ok=True, count=n)

# ---------- 德育挂件(PulseDeck 桌面小组件)只读接口 ----------

_widget_cache = {'key': None, 'v': None, 'exp': 0}

@app.after_request
def widget_cors(resp):
    if request.path.startswith('/api/widget/'):
        resp.headers['Access-Control-Allow-Origin'] = '*'
    return resp

def _collect_widget_notices(cls, grade, limit=6):
    """按班级/年级过滤公告;紧急广播单独返回;过期自动剔除"""
    cfg = load_cfg()
    notices, broadcasts = [], []
    tid = cfg.get('tid_notices')
    now_ms = int(time.time() * 1000)

    def match(scopes):
        if not scopes:
            return True
        return ('全校' in scopes) or (grade and grade in scopes) or (cls and cls in scopes)

    if tid:
        try:
            for it in list_records_raw(tid):
                f = it.get('fields') or {}
                ts = num(f.get('发布时间'))
                raw_scope = rt(f.get('范围')) or ''
                if isinstance(raw_scope, list):
                    scopes = [str(x.get('text') if isinstance(x, dict) else x).strip()
                              for x in raw_scope if x]
                else:
                    scopes = [s.strip() for s in str(raw_scope).replace('，', ',').split(',') if s.strip()]
                expire = num(f.get('过期时间'), 0)
                if expire and now_ms > expire:
                    continue
                if not match(scopes):
                    continue
                entry = {'title': rt(f.get('标题')) or '', 'content': rt(f.get('内容')) or '',
                         'pin': bool(f.get('置顶')), 'ts': ts,
                         'time': time.strftime('%m-%d %H:%M', time.localtime(ts / 1000)) if ts else ''}
                if f.get('紧急'):
                    broadcasts.append(entry)
                else:
                    notices.append(entry)
        except Exception:
            pass
    notices.sort(key=lambda x: (-int(x['pin']), -x['ts']))
    broadcasts.sort(key=lambda x: -x['ts'])
    return notices[:limit], broadcasts[:3]

def _collect_widget_duties():
    cfg = load_cfg()
    out = []
    tid = cfg.get('tid_duty')
    if tid:
        try:
            day0 = time.mktime(time.strptime(time.strftime('%Y-%m-%d'), '%Y-%m-%d')) * 1000
            for it in list_records_raw(tid):
                f = it.get('fields') or {}
                ts = num(f.get('日期'))
                if not (day0 <= ts < day0 + 86400000):
                    continue
                out.append({'slot': rt(f.get('时段')) or '', 'name': rt(f.get('检查员')) or '',
                            'dept': rt(f.get('部门')) or '', 'cls': rt(f.get('班级')) or '',
                            'grp': rt(f.get('组别')) or ''})
        except Exception:
            pass
    out.sort(key=lambda x: (x['slot'], x['name']))
    return out

@app.route('/api/widget/board')
def widget_board():
    """桌面挂件聚合只读接口:班级加减分 / 年级排名 / 公告事件 / 好人好事 / 今日执勤"""
    cfg = load_cfg()
    wt = (cfg.get('widget_token') or '').strip()
    if wt and request.args.get('token') != wt:
        return jsonify(ok=False, msg='token 无效'), 401
    cls = (request.args.get('cls') or '').strip()
    now = time.time()
    if _widget_cache['v'] is not None and _widget_cache['key'] == cls and now < _widget_cache['exp']:
        return jsonify(ok=True, **_widget_cache['v'])
    # 班级 → 年级
    classes = {}
    tid = cfg.get('tid_classes')
    if tid:
        try:
            for item in list_records_raw(tid):
                f = item.get('fields') or {}
                g, c = f.get('年级'), f.get('班级')
                if g and c:
                    classes.setdefault(g, [])
                    if c not in classes[g]:
                        classes[g].append(c)
        except Exception:
            pass
    if not classes:
        classes = cfg.get('classes', {})
    if not cls:
        for g in GRADE_ORDER:
            if classes.get(g):
                cls = classes[g][0]
                break
    grade = next((g for g, lst in classes.items() if cls in lst), '')
    # 记录
    recs = []
    try:
        recs = [norm_record(i) for i in list_records_raw(cfg['tid_records'])]
    except Exception:
        recs = []
    valid = [r for r in recs if r.get('status') == '有效']
    mine = [r for r in valid if r.get('cls') == cls]
    mine.sort(key=lambda x: -(x.get('_ts') or 0))
    if not grade and mine:
        grade = mine[0].get('grade') or ''
    day0 = time.mktime(time.strptime(time.strftime('%Y-%m-%d'), '%Y-%m-%d')) * 1000
    import datetime as _dt
    _now = _dt.datetime.now()
    mon0 = time.mktime((_now - _dt.timedelta(days=_now.weekday())).date().timetuple()) * 1000
    # 排名口径:week(默认) / month / total
    rank_mode = cfg.get('widget_rank_mode') or 'week'
    if rank_mode == 'total':
        rank0 = 0
    elif rank_mode == 'month':
        m0 = _now.replace(day=1, hour=0, minute=0, second=0, microsecond=0)
        rank0 = time.mktime(m0.timetuple()) * 1000
    else:
        rank0 = mon0

    # 每日基础分:每班每天 100 分初始分,一直累计。总分 = 基础分累计 + 净分
    BASE_PER_DAY = 100
    week_days = _now.weekday() + 1          # 周一起算
    month_days = _now.day                   # 月初起算
    sem_name = str(cfg.get('semester_name') or '').strip()
    sem_end = ''
    try:
        _ss = time.strptime(str(cfg.get('semester_start') or '2026-09-01'), '%Y-%m-%d')
        _sd = _dt.date(_ss.tm_year, _ss.tm_mon, _ss.tm_mday)
        semester_days = max((_now.date() - _sd).days + 1, 1)
        try:
            _ee = str(cfg.get('semester_end') or '').strip()
            if _ee:
                _et = time.strptime(_ee, '%Y-%m-%d')
                _ed = _dt.date(_et.tm_year, _et.tm_mon, _et.tm_mday)
                if _ed >= _sd:
                    sem_end = _ee
                    semester_days = min(semester_days, (_ed - _sd).days + 1)   # 学期结束后天数封顶
        except Exception:
            pass
    except Exception:
        semester_days = 1
    period_days = {'week': week_days, 'month': month_days, 'total': semester_days}.get(rank_mode, week_days)
    _deeds_days = num(cfg.get('deeds_board_days'), 7)   # 好人好事上榜天数,0=一直展示

    def agg(items):
        add = sum(r.get('score') or 0 for r in items if (r.get('score') or 0) > 0)
        deduct = sum(r.get('score') or 0 for r in items if (r.get('score') or 0) < 0)
        return {'add': add, 'deduct': deduct, 'net': add + deduct}

    # 年级排名(基础分累计+净分;全年级班级都参与,无记录班级净分记 0)
    rank, total_cls, grade_score, board_list = 0, 0, 0, []
    if grade:
        pool = {}
        for r in valid:
            if (r.get('grade') or '') == grade and r.get('cls') and (r.get('_ts') or 0) >= rank0:
                pool[r['cls']] = pool.get(r['cls'], 0) + (r.get('score') or 0)
        if cls and cls not in pool:
            pool[cls] = 0
        for c2 in classes.get(grade, []):
            if c2 not in pool:
                pool[c2] = 0
        base = BASE_PER_DAY * period_days
        ordered = sorted(pool.items(), key=lambda kv: -(kv[1] + base))
        for i, (c2, sc) in enumerate(ordered, 1):
            if c2 == cls:
                rank, grade_score = i, sc + base
        total_cls = len(ordered)
        board_list = [{'cls': c2, 'score': sc + base} for c2, sc in ordered[:10]]
    wn, bc = _collect_widget_notices(cls, grade, 6)
    sem_net = sum(r.get('score') or 0 for r in mine)
    data = {
        'cls': cls, 'grade': grade,
        'today': agg([r for r in mine if (r.get('_ts') or 0) >= day0]),
        'week': agg([r for r in mine if (r.get('_ts') or 0) >= mon0]),
        'total': agg(mine),
        'semester': {'name': sem_name, 'start': str(cfg.get('semester_start') or '2026-09-01'), 'end': sem_end,
                     'days': semester_days, 'base': BASE_PER_DAY * semester_days,
                     'net': sem_net, 'total': BASE_PER_DAY * semester_days + sem_net},
        'rank': {'rank': rank, 'total': total_cls, 'score': grade_score, 'top': board_list,
                 'mode': rank_mode, 'days': period_days, 'base': BASE_PER_DAY},
        'latest': [{'time': r.get('time'), 'item': r.get('item'), 'score': r.get('score'),
                    'type': r.get('type'), 'student': r.get('student')} for r in mine[:8]],
        'deeds': [{'time': r.get('time'), 'item': r.get('item'), 'score': r.get('score'),
                   'student': r.get('student'), 'desc': r.get('desc')}
                  for r in mine if r.get('type') == '加分'
                  and (_deeds_days <= 0 or (r.get('_ts') or 0) >= now - _deeds_days * 86400)][:8],
        'notices': wn,
        'broadcasts': bc,
        'duties': _collect_widget_duties(),
        'ts': int(now * 1000),
    }
    _widget_cache.update({'key': cls, 'v': data, 'exp': now + 20})
    return jsonify(ok=True, **data)

# ---------- 德育电子班牌:广播 / 好人好事审核 / 排名口径 ----------

def fe_base():
    return 'https://open.feishu.cn/open-apis/bitable/v1/apps/' + load_cfg()['app_token']

def fe_field_names(tid):
    cfg = load_cfg()
    d = HTTP.get(fe_base() + '/tables/' + tid + '/fields?page_size=100', headers=bh(), timeout=20).json()
    if d.get('code') != 0:
        return []
    return [f.get('field_name') for f in ((d.get('data') or {}).get('items') or [])]

def fe_create_field(tid, payload):
    d = HTTP.post(fe_base() + '/tables/' + tid + '/fields', headers=bh(), json=payload, timeout=20).json()
    return d.get('code') == 0

_notice_fields_ok = False
def ensure_notice_fields():
    """广播字段:范围(文本,逗号分隔)/紧急(复选框)/过期时间(数字ms),缺失自动创建"""
    global _notice_fields_ok
    if _notice_fields_ok:
        return
    try:
        tid = load_cfg().get('tid_notices')
        if not tid:
            return
        have = set(fe_field_names(tid))
        if '范围' not in have:
            fe_create_field(tid, {'field_name': '范围', 'type': 1})
        if '紧急' not in have:
            fe_create_field(tid, {'field_name': '紧急', 'type': 7})
        if '过期时间' not in have:
            fe_create_field(tid, {'field_name': '过期时间', 'type': 2})
        _notice_fields_ok = True
    except Exception:
        pass

_deeds_tid = ''
def deeds_tid():
    """好人好事表:config 配了就用,没有则自动建表"""
    global _deeds_tid
    if _deeds_tid:
        return _deeds_tid
    cfg = load_cfg()
    tid = cfg.get('tid_deeds')
    if tid:
        _deeds_tid = tid
        return tid
    fields = [
        {'field_name': '提交时间', 'type': 2},
        {'field_name': '发起人', 'type': 1},
        {'field_name': '班级', 'type': 1},
        {'field_name': '学生', 'type': 1},
        {'field_name': '事项', 'type': 1},
        {'field_name': '事实描述', 'type': 1},
        {'field_name': '建议分值', 'type': 2},
        {'field_name': '状态', 'type': 1},
        {'field_name': '处理意见', 'type': 1},
        {'field_name': '审核时间', 'type': 2},
        {'field_name': '关联记录', 'type': 1},
    ]
    d = HTTP.post(fe_base() + '/tables', headers=bh(),
                  json={'table': {'name': '好人好事(班牌)', 'fields': fields}}, timeout=25).json()
    if d.get('code') != 0:
        raise RuntimeError('创建好人好事表失败: ' + str(d.get('msg')))
    tid = (d.get('data') or {}).get('table_id') or ''
    if not tid:
        raise RuntimeError('创建好人好事表失败: 未返回 table_id')
    cfg['tid_deeds'] = tid
    save_cfg(cfg)
    _deeds_tid = tid
    write_log('自动建表', '好人好事(班牌)', 'tid=' + tid)
    return tid

def norm_deed(item):
    f = item.get('fields') or {}
    ts = num(f.get('提交时间'))
    ats = num(f.get('审核时间'))
    return {
        'did': item.get('record_id'),
        'time': time.strftime('%m-%d %H:%M', time.localtime(ts / 1000)) if ts else '',
        '_ts': ts,
        'by': rt(f.get('发起人')) or '', 'cls': rt(f.get('班级')) or '',
        'student': rt(f.get('学生')) or '', 'item': rt(f.get('事项')) or '',
        'desc': rt(f.get('事实描述')) or '', 'score': num(f.get('建议分值'), 1),
        'status': rt(f.get('状态')) or '待审核', 'opinion': rt(f.get('处理意见')) or '',
        'review_time': time.strftime('%m-%d %H:%M', time.localtime(ats / 1000)) if ats else '',
        'rid': rt(f.get('关联记录')) or '',
    }

@app.route('/api/deeds')
def list_deeds():
    if not check_pw('admin', request.headers.get('X-PW') or request.args.get('pw')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    try:
        tid = deeds_tid()
    except Exception as e:
        return jsonify(ok=False, msg=str(e)[:120]), 500
    out = [norm_deed(i) for i in list_records_raw(tid)]
    out.sort(key=lambda x: (x['status'] != '待审核', -x['_ts']))
    return jsonify(ok=True, deeds=out[:100])

@app.route('/api/deeds', methods=['POST'])
def add_deed():
    b = request.get_json(force=True)
    wt = (load_cfg().get('widget_token') or '').strip()
    if not (check_pw('admin', b.get('admin_password') or '') or check_pw('reg', b.get('reg_password') or '')
            or (wt and b.get('token') == wt)):
        return jsonify(ok=False, msg='口令验证失败(需登记口令/管理口令/挂件令牌)'), 401
    for k, lab in (('by', '发起人'), ('student', '学生'), ('item', '事项')):
        if not (b.get(k) or '').strip():
            return jsonify(ok=False, msg='请填写:' + lab), 400
    try:
        tid = deeds_tid()
    except Exception as e:
        return jsonify(ok=False, msg=str(e)[:120]), 500
    fields = {'提交时间': int(time.time() * 1000),
              '发起人': b['by'].strip(), '班级': (b.get('cls') or '').strip(),
              '学生': b['student'].strip(), '事项': b['item'].strip(),
              '事实描述': (b.get('desc') or '').strip(),
              '建议分值': num(b.get('score'), 1), '状态': '待审核'}
    d = HTTP.post(fe_url(tid), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='提交失败: ' + str(d.get('msg'))), 500
    write_log('发起好人好事', b['student'].strip() + '·' + b['item'].strip())
    return jsonify(ok=True)

@app.route('/api/deeds/<did>/approve', methods=['POST'])
def approve_deed(did):
    b = request.get_json(force=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    try:
        score = float(b.get('score'))
    except (TypeError, ValueError):
        return jsonify(ok=False, msg='加分分值必须是数字'), 400
    if score <= 0:
        return jsonify(ok=False, msg='加分分值必须大于 0'), 400
    try:
        tid = deeds_tid()
    except Exception as e:
        return jsonify(ok=False, msg=str(e)[:120]), 500
    d = HTTP.get(fe_url(tid) + '/' + did, headers=bh(), timeout=15).json()
    rec = ((d.get('data') or {}).get('record') or {}).get('fields') or {}
    if rt(rec.get('状态')) not in ('', '待审核'):
        return jsonify(ok=False, msg='该记录已处理过'), 400
    cls = rt(rec.get('班级')) or ''
    grade = ''
    try:
        cfg = load_cfg()
        for item in list_records_raw(cfg.get('tid_classes')):
            f = item.get('fields') or {}
            g, c = f.get('年级'), f.get('班级')
            if g and c:
                if c == cls:
                    grade = g
                    break
    except Exception:
        pass
    rfields = {'检查时间': int(time.time() * 1000), '年级': grade, '班级': cls,
               '部门': '班牌好人好事', '事项细项': rt(rec.get('事项')) or '好人好事',
               '类型': '加分', '分值': abs(score),
               '事实描述': (rt(rec.get('事实描述')) or '')[:200],
               '使用人': rt(rec.get('发起人')) or '班牌',
               '学生': rt(rec.get('学生')) or '', '登记来源': '班牌'}
    rd = HTTP.post(fe_url(load_cfg()['tid_records']), headers=bh(), json={'fields': rfields}, timeout=20).json()
    if rd.get('code') != 0:
        return jsonify(ok=False, msg='写入加分记录失败: ' + str(rd.get('msg'))), 500
    rid = rd['data']['record']['record_id']
    HTTP.put(fe_url(tid) + '/' + did, headers=bh(),
             json={'fields': {'状态': '已通过', '处理意见': (b.get('opinion') or '').strip()[:100],
                              '审核时间': int(time.time() * 1000), '关联记录': rid}}, timeout=20)
    write_log('好人好事通过', (rt(rec.get('学生')) or '') + '+' + str(score), 'rid=' + rid)
    return jsonify(ok=True, rid=rid)

@app.route('/api/deeds/<did>/reject', methods=['POST'])
def reject_deed(did):
    b = request.get_json(force=True) or {}
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    try:
        tid = deeds_tid()
    except Exception as e:
        return jsonify(ok=False, msg=str(e)[:120]), 500
    HTTP.put(fe_url(tid) + '/' + did, headers=bh(),
             json={'fields': {'状态': '已驳回', '处理意见': (b.get('opinion') or '不符合要求').strip()[:100],
                              '审核时间': int(time.time() * 1000)}}, timeout=20)
    write_log('好人好事驳回', 'did=' + did)
    return jsonify(ok=True)

@app.route('/api/board/broadcast', methods=['POST'])
def board_broadcast():
    b = request.get_json(force=True)
    if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    title = (b.get('title') or '').strip()
    content = (b.get('content') or '').strip()
    if not title or not content:
        return jsonify(ok=False, msg='标题与内容必填'), 400
    cfg = load_cfg()
    tid = cfg.get('tid_notices')
    if not tid:
        return jsonify(ok=False, msg='未配置公告表'), 500
    ensure_notice_fields()
    scopes = [str(s).strip() for s in (b.get('scopes') or []) if str(s).strip()]
    fields = {'标题': title, '内容': content,
              '发布人': (b.get('by') or '管理员').strip()[:20],
              '发布时间': int(time.time() * 1000)}
    if scopes:
        fields['范围'] = ','.join(scopes)
    if b.get('urgent'):
        fields['紧急'] = True
    if b.get('pin'):
        fields['置顶'] = ['置顶']
    if b.get('expire_str'):
        try:
            tt = time.strptime(b['expire_str'], '%Y-%m-%d %H:%M')
            fields['过期时间'] = int(time.mktime(tt) * 1000)
        except ValueError:
            return jsonify(ok=False, msg='过期时间格式应为 2026-10-18 18:00'), 400
    d = HTTP.post(fe_url(tid), headers=bh(), json={'fields': fields}, timeout=20).json()
    if d.get('code') != 0:
        return jsonify(ok=False, msg='发布失败: ' + str(d.get('msg'))), 500
    write_log('发布广播', title[:30] + (' [紧急]' if b.get('urgent') else ''), '范围=' + (','.join(scopes) or '全校'))
    return jsonify(ok=True)

@app.route('/api/board/settings', methods=['GET', 'POST'])
def board_settings():
    cfg = load_cfg()
    if request.method == 'POST':
        b = request.get_json(force=True)
        if not check_pw('admin', request.headers.get('X-PW') or b.get('admin_password')):
            return jsonify(ok=False, msg='管理口令验证失败'), 401
        mode = b.get('rank_mode')
        if mode not in ('week', 'month', 'total'):
            return jsonify(ok=False, msg='rank_mode 必须是 week / month / total'), 400
        cfg['widget_rank_mode'] = mode
        sstart = str(b.get('semester_start') or '').strip()
        if sstart:
            try:
                time.strptime(sstart, '%Y-%m-%d')
                cfg['semester_start'] = sstart
            except Exception:
                return jsonify(ok=False, msg='学期起始日需为 YYYY-MM-DD'), 400
        # 学期名称(如:2026年秋季学期)与结束日 —— 全系统统一口径,统计导出共用
        if 'semester_name' in b:
            cfg['semester_name'] = str(b.get('semester_name') or '').strip()[:30]
        if 'semester_end' in b:
            send = str(b.get('semester_end') or '').strip()
            if send:
                try:
                    time.strptime(send, '%Y-%m-%d')
                except Exception:
                    return jsonify(ok=False, msg='学期结束日需为 YYYY-MM-DD'), 400
                if sstart and send < sstart:
                    return jsonify(ok=False, msg='学期结束日不能早于起始日'), 400
                cfg['semester_end'] = send
            else:
                cfg['semester_end'] = ''
        # 好人好事上榜天数(0=一直展示,上限 365)
        if 'deeds_board_days' in b:
            try:
                dd = int(float(b.get('deeds_board_days')))
            except (TypeError, ValueError):
                return jsonify(ok=False, msg='上榜天数需为数字'), 400
            cfg['deeds_board_days'] = max(0, min(dd, 365))
        save_cfg(cfg)
        _widget_cache['exp'] = 0
        write_log('班牌设置', '排名口径=' + mode
                  + ((' 学期=' + str(cfg.get('semester_name'))) if cfg.get('semester_name') else '')
                  + (' 起止=' + str(cfg.get('semester_start')) + '~' + str(cfg.get('semester_end') or '未设') if cfg.get('semester_end') else '')
                  + (' 好人好事上榜=' + str(cfg.get('deeds_board_days')) + '天' if 'deeds_board_days' in b else ''))
        return jsonify(ok=True, rank_mode=mode)
    return jsonify(ok=True, rank_mode=cfg.get('widget_rank_mode') or 'week',
                   semester_name=cfg.get('semester_name') or '',
                   semester_start=cfg.get('semester_start') or '2026-09-01',
                   semester_end=cfg.get('semester_end') or '',
                   deeds_board_days=num(cfg.get('deeds_board_days'), 7))

@app.route('/api/widget/classes')
def widget_classes():
    cfg = load_cfg()
    wt = (cfg.get('widget_token') or '').strip()
    if wt and request.args.get('token') != wt:
        return jsonify(ok=False, msg='token 无效'), 401
    classes = {}
    tid = cfg.get('tid_classes')
    if tid:
        try:
            for item in list_records_raw(tid):
                f = item.get('fields') or {}
                g, c = f.get('年级'), f.get('班级')
                if g and c:
                    classes.setdefault(g, [])
                    if c not in classes[g]:
                        classes[g].append(c)
        except Exception:
            pass
    if not classes:
        classes = cfg.get('classes', {})
    for g in GRADE_ORDER:
        classes.setdefault(g, [])
    return jsonify(ok=True, classes=classes)

# ---------- 班牌挂件自动更新:updates/ 目录放新版安装包 + latest.yml ----------
UPDATES_DIR = os.path.join(BASE, 'updates')
os.makedirs(UPDATES_DIR, exist_ok=True)

@app.route('/updates/<path:fname>')
def widget_updates(fname):
    return send_from_directory(UPDATES_DIR, fname)

@app.route('/api/ping')
def ping():
    """桌面壳端口寻址的身份探测点：确认 127.0.0.1:<port> 上跑的是德育系统而非其他程序"""
    return jsonify(ok=True, app='deyu')

# ---------- 宿舍床位：Excel 模板与导入 ----------
def _cell_str(v):
    """Excel 单元格统一转字符串（数字 302.0 -> '302'）"""
    if v is None:
        return ''
    if isinstance(v, float) and v.is_integer():
        return str(int(v))
    return str(v).strip()

@app.route('/api/dorms/template')
def dorm_template():
    cfg = load_cfg()
    wb = Workbook()
    ws = wb.active
    ws.title = '床位导入'
    ws.append(['楼栋', '房间', '床位', '年级', '班级', '姓名（可空）'])
    ws.append(['男生1栋', '302', '1', '高一', '高一（1）班', '张三'])
    ws.append(['男生1栋', '302', '2', '高一', '高一（5）班', '李四'])
    for col, w in zip('ABCDEF', (14, 10, 10, 10, 16, 14)):
        ws.column_dimensions[col].width = w
    for c in ws[1]:
        c.font = XlFont(bold=True)
    ws2 = wb.create_sheet('选项')
    ws2['A1'] = '年级'
    ws2['B1'] = '班级'
    grades = ['高一', '高二', '高三']
    classes = []
    for g in grades:
        classes += (cfg.get('classes') or {}).get(g) or []
    for i, g in enumerate(grades, start=2):
        ws2.cell(row=i, column=1, value=g)
    for i, cname in enumerate(classes, start=2):
        ws2.cell(row=i, column=2, value=cname)
    ws2.sheet_state = 'hidden'
    if classes:
        dv_g = DataValidation(type='list', formula1='=选项!$A$2:$A$4', allow_blank=True)
        dv_c = DataValidation(type='list', formula1='=选项!$B$2:$B$%d' % (len(classes) + 1), allow_blank=True)
        ws.add_data_validation(dv_g)
        ws.add_data_validation(dv_c)
        dv_g.add('D2:D1000')
        dv_c.add('E2:E1000')
    buf = io.BytesIO()
    wb.save(buf)
    return Response(buf.getvalue(), mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        headers={'Content-Disposition': 'attachment; filename=dorm_template.xlsx'})

@app.route('/api/dorms/parse_excel', methods=['POST'])
def parse_dorm_excel():
    b = request.get_json(force=True)
    if not check_pw('admin', b.get('admin_password')):
        return jsonify(ok=False, msg='管理口令验证失败'), 401
    try:
        raw = base64.b64decode(b.get('data_b64') or '')
        wb = load_workbook(io.BytesIO(raw), read_only=True, data_only=True)
    except Exception:
        return jsonify(ok=False, msg='无法读取该文件，请用 .xlsx 格式（建议先下载模板填写）'), 400
    ws = wb.active
    rows, errors = [], []
    for i, row in enumerate(ws.iter_rows(min_row=2, values_only=True), start=2):
        vals = [_cell_str(v) for v in (list(row) + [None] * 6)[:6]]
        building, room, bed, grade, cls, name = vals
        if not any([building, room, bed, cls, name]):
            continue
        miss = [lbl for lbl, v in (('楼栋', building), ('房间', room), ('床位', bed), ('班级', cls)) if not v]
        if miss:
            errors.append('第 %d 行缺：%s' % (i, '、'.join(miss)))
            continue
        rows.append({'building': building[:30], 'room': room[:20], 'bed': bed[:10],
                     'grade': grade[:10], 'cls': cls[:30], 'name': name[:30]})
    if not rows and not errors:
        return jsonify(ok=False, msg='表格里没有数据行（第 1 行是表头，从第 2 行开始填）'), 400
    return jsonify(ok=True, rows=rows, errors=errors, total=len(rows))

if __name__ == '__main__':
    # DEYU_RELOAD=1 开启热更新:改 app.py / templates 后自动重启进程,无需手动重启服务
    _reload = os.environ.get('DEYU_RELOAD') == '1'
    if not os.environ.get('DEYU_NO_BROWSER') and (not _reload or os.environ.get('WERKZEUG_RUN_MAIN') == 'true'):
        threading.Thread(target=open_browser, daemon=True).start()
    app.run(host=os.environ.get('DEYU_HOST', '127.0.0.1'), port=int(os.environ.get('DEYU_PORT', '8765')), debug=False,
            use_reloader=_reload)
