"""AI 整理与 Excel 导出的接口测试。 AI 一律走本地规则解析(conftest 把 AI_API_KEY 置空),断言的都是确定性行为,不联网。 导出只验三件事:能下载、文件确实是 xlsx、表头与筛选口径跟页面一致。 """ from __future__ import annotations import io from openpyxl import load_workbook from app.db import SessionLocal from app.models import CustomProject, CustomUpdate, ImportLog, Task, Update RAW = """1、需求评审完成 2、开发进度 60% 3、接口联调延期,等待对方提供文档 下一步:完成联调 """ CUSTOM_RAW = """1、合同金额 150,000 元,开发进度 60% 2、已计收 50,000 """ # ---------------------------------------------------------------- 小工具 def _parse(h, **kw): return h.admin.post("/api/ai/parse", json={"raw_text": RAW, "use_ai": False, **kw}) def _commit(h, **kw): body = {"raw_text": RAW, "mode": "rule", "parsed": {}} body.update(kw) return h.admin.post("/api/ai/commit", json=body) def _sheet(resp): """把响应当 xlsx 打开,返回 (工作表名, 全部行)。""" assert resp.status_code == 200, resp.text assert "spreadsheetml.sheet" in resp.headers["content-type"], resp.headers assert resp.content[:4] == b"PK\x03\x04" # xlsx 就是 zip 包 wb = load_workbook(io.BytesIO(resp.content)) rows = [list(r) for r in wb.active.iter_rows(values_only=True)] # build_xlsx 固定前两行是标题 + 导出时间,第 3 行才是表头 assert rows[1][0] and str(rows[1][0]).startswith("导出时间"), rows[:2] return wb.active.title, rows # ================================================================== 常规项目:AI 整理 def test_规则解析出摘要状态风险与子任务(h): r = _parse(h) assert r.status_code == 200, r.text data = r.json() assert data["mode"] == "rule" and data["error"] is None assert "未配置大模型" in (data["warning"] or "") # 没配 Key 要说清楚现在用的是本地规则 p = data["parsed"] assert set(p) == {"summary", "progress", "status", "risks", "next_steps", "tasks"} assert p["summary"] == "需求评审完成" assert p["progress"] == 60 # 取原文里出现的百分比 assert p["status"] == "at_risk" # 子任务里有延期 → 整体按最差状态报 assert p["risks"] and "延期" in p["risks"][0] assert p["next_steps"] and "下一步" in p["next_steps"][0] assert [t["status"] for t in p["tasks"]] == ["done", "in_progress", "at_risk"] assert all(t["content"] and t["name"] for t in p["tasks"]) def test_预览是只动的整理不会顺手建项目(h): r = _parse(h, project_name="只想预览的项目") assert r.status_code == 200, r.text assert r.json()["project"] is None # 预览不认得这个名字 names = [x["name"] for x in h.admin.get("/api/projects").json()] assert "只想预览的项目" not in names # 也不许偷偷建出来 p = h.project("已有项目") r = _parse(h, project_name=p["name"]) assert r.json()["project"]["id"] == p["id"] # 同名能认出来 assert r.json()["period"] is None def test_预览校验项目与周期是否存在(h): r = _parse(h, project_id=987654) assert r.status_code == 404 and "项目" in r.json()["detail"] r = _parse(h, period_id=987654) assert r.status_code == 404 and "周期" in r.json()["detail"] r = _parse(h, period_id=h.today_period_id) assert r.status_code == 200 and r.json()["period"]["id"] == h.today_period_id def test_确认写入按子任务落库并复用同名子任务(h): p = h.project("AI落地项目") period = h.today_period_id parsed = { "summary": "三条进展", "progress": 60, "status": "at_risk", "risks": ["文档延期"], "next_steps": ["完成联调"], "tasks": [ {"name": "开发", "content": "开发完成 60%", "progress": 60, "status": "in_progress"}, {"name": "联调", "content": "等对方文档", "progress": 0, "status": "at_risk", "risk": "文档未到"}, ], } r = _commit(h, project_id=p["id"], period_id=period, parsed=parsed) assert r.status_code == 200, r.text out = r.json() assert out["ok"] and len(out["created"]) == 2 by_task = {u["task_name"]: u for u in out["created"]} assert set(by_task) == {"开发", "联调"} assert by_task["开发"]["risk"] == "文档延期" # 整体风险落在第一条上 assert by_task["开发"]["next_step"] == "完成联调" assert by_task["联调"]["risk"] == "文档未到" # 子任务自己的风险优先 assert all(u["period_id"] == period for u in out["created"]) # 主档回写,时间线也按这一周聚合出来 detail = h.admin.get(f"/api/projects/{p['id']}").json() assert detail["project"]["progress"] == 60 and detail["project"]["status"] == "at_risk" assert [t["status"] for t in detail["timeline"]] == ["at_risk"] assert len(detail["timeline"][0]["updates"]) == 2 # 同名子任务复用,不重复建;新记录追加不覆盖旧的 r2 = _commit(h, project_id=p["id"], period_id=period, parsed={"tasks": [{"name": "开发", "content": "又推进了一点"}]}) assert r2.status_code == 200 and len(r2.json()["created"]) == 1 with SessionLocal() as s: assert s.query(Task).filter(Task.project_id == p["id"]).count() == 2 assert s.query(Update).filter(Update.project_id == p["id"]).count() == 3 assert s.query(ImportLog).filter(ImportLog.project_id == p["id"]).count() == 2 def test_确认写入没有子任务时只落一条(h): p = h.project("单条AI项目") r = _commit(h, project_name=p["name"], period_id=h.today_period_id, mode="ai", model="deepseek-chat", parsed={"summary": "整体推进", "progress": 40, "status": "in_progress", "risks": ["人手不足", "接口不稳"], "next_steps": ["补齐测试"], "tasks": []}) assert r.status_code == 200, r.text created = r.json()["created"] assert len(created) == 1 u = created[0] assert u["content"] == RAW # 原文整段留档 assert u["risk"] == "人手不足;接口不稳" assert u["next_step"] == "补齐测试" assert u["source"] == "ai" and u["model"] == "deepseek-chat" assert len(h.admin.get("/api/projects").json()) == 1 # 按同名找到已有项目,没有新建 with SessionLocal() as s: log = s.query(ImportLog).one() assert log.mode == "ai" and log.model == "deepseek-chat" assert log.raw_input == RAW and "整体推进" in log.parsed_json def test_确认写入缺少项目或周期会报错(h): r = _commit(h, period_id=h.today_period_id, parsed={}) assert r.status_code == 400 and "项目" in r.json()["detail"] p = h.project("要有周期") r = _commit(h, project_id=p["id"], period_id=987654, parsed={}) assert r.status_code == 404 and "周期" in r.json()["detail"] # ================================================================== 定制项目:AI 整理 def _custom_parse(h, **kw): return h.admin.post("/api/custom/ai/parse", json={"raw_text": CUSTOM_RAW, "use_ai": False, **kw}) def test_定制规则解析出阶段金额与本期计收(h): r = _custom_parse(h) assert r.status_code == 200, r.text data = r.json() assert data["mode"] == "rule" and "未配置大模型" in (data["warning"] or "") p = data["parsed"] assert p["stage"] == "developing" # 有「开发进度 60%」→ 在制,不算验收 assert p["progress"] == 60 assert p["amount"] == 150000.0 # 「金额 150,000 元」 assert p["revenue_amount"] is None # 没写累计计收就别编 assert p["revenue_delta"] == 50000.0 # 「已计收 50,000」算本期新增 assert len(p["updates"]) == 2 assert p["updates"][1]["revenue_delta"] == 50000.0 assert p["summary"].startswith("合同金额") def test_定制预览校验项目是否存在(h): r = _custom_parse(h, custom_project_id=987654) assert r.status_code == 404 and "定制项目" in r.json()["detail"] c = h.custom("预览用的定制单", stage="developing") r = _custom_parse(h, custom_project_id=c["id"], period_id=h.today_period_id) assert r.status_code == 200 assert r.json()["project"]["id"] == c["id"] assert r.json()["period"]["id"] == h.today_period_id def test_定制确认写入自动建档并按口径记账(h): period = h.today_period_id r = h.admin.post("/api/custom/ai/commit", json={ "raw_text": CUSTOM_RAW, "project_name": "AI新建的定制单", "mode": "rule", "period_id": period, "parsed": {"stage": "developing", "progress": 60, "amount": 150000, "summary": "开发中", "updates": [{"content": "开发进度 60%", "progress": 60, "stage": "developing", "revenue_delta": 50000}]}, }) assert r.status_code == 200, r.text out = r.json() cp = out["project"] assert cp["name"] == "AI新建的定制单" and len(out["created"]) == 1 assert cp["amount"] == 150000.0 # parsed.amount 是绝对值,直接落主档 assert cp["revenue_amount"] == 50000.0 # 计收走增量累加 assert cp["progress"] == 60 and cp["stage"] == "developing" assert cp["remark"] == "开发中" and cp["period_id"] == period assert out["created"][0]["amount_delta"] is None # 第二条记录只给增量:主档在现有金额上累加,不覆盖 r2 = h.admin.post("/api/custom/ai/commit", json={ "raw_text": "追加下单", "custom_project_id": cp["id"], "mode": "rule", "period_id": period, "parsed": {"updates": [{"content": "追加下单", "amount_delta": 30000}]}, }) assert r2.status_code == 200, r2.text cp2 = r2.json()["project"] assert cp2["amount"] == 180000.0 and cp2["revenue_amount"] == 50000.0 assert cp2["id"] == cp["id"] with SessionLocal() as s: assert s.query(CustomUpdate).filter(CustomUpdate.custom_project_id == cp["id"]).count() == 2 logs = s.query(ImportLog).all() assert len(logs) == 2 and all(l.project_id is None for l in logs) assert str(cp["id"]) in logs[0].parsed_json def test_定制确认写入缺少项目或周期会报错(h): r = h.admin.post("/api/custom/ai/commit", json={"raw_text": "随便写点", "period_id": h.today_period_id, "parsed": {}}) assert r.status_code == 400 and "项目" in r.json()["detail"] r = h.admin.post("/api/custom/ai/commit", json={"raw_text": "随便写点", "project_name": "临时建的项目", "period_id": 987654, "parsed": {}}) assert r.status_code == 404 and "周期" in r.json()["detail"] names = [x["name"] for x in h.admin.get("/api/custom/projects", params={"archived": "all"}).json()] assert "临时建的项目" not in names # 报错就什么都不留 # ================================================================== 导出 def _seed(h): """每类数据各来一条,导出用例共用。""" period = h.today_period_id p = h.project("导出-常规项目", is_key=True, owners=["张三"]) h.update(p["id"], period, content="推进中", status="at_risk", risk="等客户确认") # 主档金额不预先填,全靠周期记录里的增量累加出来(这才是页面上的录入口径) c = h.custom("导出-定制单", origin="华智下单", man_days=12, sign_date="2026-01-05", accept_date="Q1", accept_year=2026, project_status="进行中", region="华东", owner="张三") h.custom_update(c["id"], period, content="开发中", progress=50, amount_delta=120000, revenue_delta=20000) h.staff("张三", group="AI产品组", affiliation="汇智") h.focus("导出-重点事项", due_date="2026-10-09", delayed=True, status="in_progress") return period def test_六类导出都是可用的xlsx(h): _seed(h) checks = { "/api/export/custom": (["项目归属", "订单金额(元)", "验收时间"], "定制项目明细"), "/api/export/custom-updates": (["周期", "本期新增下单(元)", "本期新增计收(元)"], "定制项目记录"), "/api/export/projects": (["项目名称", "执行记录数", "最近更新周期"], "项目管理"), "/api/export/updates": (["周期", "执行情况", "状态"], "周期执行记录"), "/api/export/staff": (["姓名", "定制合同额(元)", "定制待计收(元)"], "人力资源库"), "/api/export/focus": (["工作内容", "录入周", "是否延期"], "每周重点工作"), } for url, (cols, sheet) in checks.items(): name, rows = _sheet(h.admin.get(url)) assert name == sheet, url header = [c for c in rows[2] if c] for col in cols: assert col in header, f"{url} 表头缺 {col}:{header}" assert len(rows) > 3, f"{url} 没有数据行:{rows}" # 内容抽查:验收时间、状态中文、负载金额都对得上 _, rows = _sheet(h.admin.get("/api/export/custom")) row = next(r for r in rows[3:] if r[1] == "导出-定制单") assert row[0] == "华智下单" and row[7] == 120000 and row[10] == "2026Q1" _, rows = _sheet(h.admin.get("/api/export/updates")) row = next(r for r in rows[3:] if r[1] == "导出-常规项目") assert row[5] == "风险" and row[8] == "手工" _, rows = _sheet(h.admin.get("/api/export/staff")) row = next(r for r in rows[3:] if r[1] == "张三") assert row[4] == 1 and row[7] == 120000 and row[8] == 100000 _, rows = _sheet(h.admin.get("/api/export/focus")) row = next(r for r in rows[3:] if r[1] == "导出-重点事项") assert row[5] == "进行中" and row[6] == "是" and row[3] == "2026-10-09" def test_定制导出带合计行并跟随筛选(h): _seed(h) other = h.custom("导出-另一单", origin="汇智直签", amount=30000, sign_date="2026-02-02", region="华南", project_status="已验收") _, rows = _sheet(h.admin.get("/api/export/custom")) total = rows[-1] assert total[0] == "合计" and total[1] == "2 个项目" assert total[6] == 12 and total[7] == 150000 # 人天合计、金额合计 assert len(rows) == 3 + 2 + 2 # 两行抬头 + 表头 + 两条数据 + 空行 + 合计 _, rows = _sheet(h.admin.get("/api/export/custom", params={"keyword": "另一单"})) assert rows[-1][1] == "1 个项目" and rows[3][1] == "导出-另一单" _, rows = _sheet(h.admin.get("/api/export/custom", params={"origin": "华智下单"})) assert rows[-1][1] == "1 个项目" h.admin.patch(f"/api/custom/projects/{other['id']}", json={"archived": True}) _, rows = _sheet(h.admin.get("/api/export/custom")) assert rows[-1][1] == "1 个项目" # 归档的默认不导 _, rows = _sheet(h.admin.get("/api/export/custom", params={"archived": "all"})) assert rows[-1][1] == "2 个项目" _, rows = _sheet(h.admin.get("/api/export/custom", params={"archived": "true"})) assert rows[-1][1] == "1 个项目" and rows[3][1] == "导出-另一单" def test_执行记录导出按顶栏周期筛选(h): p = h.project("周期导出") w1, w2 = h.period(2026, 3, 1), h.period(2026, 3, 2) w3 = h.period(2026, 4, 1) h.update(p["id"], w1["id"], content="三月第一周") h.update(p["id"], w2["id"], content="三月第二周") h.update(p["id"], w3["id"], content="四月第一周") _, rows = _sheet(h.admin.get("/api/export/updates", params={"period_id": w1["id"]})) assert [r[3] for r in rows[3:]] == ["三月第一周"] _, rows = _sheet(h.admin.get("/api/export/updates", params={"year": 2026, "month": 3})) assert [r[3] for r in rows[3:]] == ["三月第一周", "三月第二周"] # 按月 = 当月所有周 _, rows = _sheet(h.admin.get("/api/export/updates")) assert [r[3] for r in rows[3:]] == ["四月第一周"] # 不给条件 = 最新一周 # 认不出的周期不给空表,而是导出全量:导出是让人把数据带走的,不做隐式裁剪 _, rows = _sheet(h.admin.get("/api/export/updates", params={"period_id": 987654})) assert len(rows) == 3 + 3 # 定制周期记录同理 c = h.custom("定制导出单") h.custom_update(c["id"], w1["id"], content="定开三月", amount_delta=1000, revenue_delta=200) h.custom_update(c["id"], w3["id"], content="定开四月") _, rows = _sheet(h.admin.get("/api/export/custom-updates", params={"year": 2026, "month": 3})) assert [r[4] for r in rows[3:]] == ["定开三月"] _, rows = _sheet(h.admin.get("/api/export/custom-updates", params={"period_id": 987654})) assert [r[4] for r in rows[3:]] == ["定开三月", "定开四月"] assert rows[3][6] == 1000 and rows[3][7] == 200 def test_项目导出含归档开关与统计列(h): _seed(h) archived = h.project("导出-已归档项目", archived=True) _, rows = _sheet(h.admin.get("/api/export/projects")) names = [r[0] for r in rows[3:]] assert "导出-常规项目" in names and "导出-已归档项目" not in names # 默认与页面一致:不含归档 _, rows = _sheet(h.admin.get("/api/export/projects", params={"archived": "all"})) assert "导出-已归档项目" in [r[0] for r in rows[3:]] # 整库留档要显式 archived=all row = next(r for r in rows[3:] if r[0] == "导出-常规项目") assert row[3] == "进行中" and row[4] == "是" and row[8] == 1 assert row[9] and "第" in row[9] # 最近更新周期写了周次 _, rows = _sheet(h.admin.get("/api/export/projects", params={"archived": "false"})) names = [r[0] for r in rows[3:]] assert "导出-已归档项目" not in names _, rows = _sheet(h.admin.get("/api/export/projects", params={"keyword": "归档", "archived": "all"})) assert [r[0] for r in rows[3:]] == ["导出-已归档项目"] # 搜归档项目要显式放开归档口径 def test_导出精确跟随页面筛选(h): """导出参数必须接得住页面全部筛选(README「导出会带上页面当前的筛选条件」): 自研导出补负责人 / 只看未更新,人员导出补小组 / 关键字,执行记录导出认关键字。""" def names(path, **params): _, rows = _sheet(h.admin.get(path, params=params)) return [r[0] for r in rows[3:]] # 前两行标题/时间,第 3 行表头,之后是数据 pid = h.today_period_id a = h.project("张三点甲", owners=["张三"]) h.project("张王共管乙", owners=["张三", "王五"]) h.project("李四丙", owners=["李四"]) h.update(a["id"], pid, content="本周干了大事") assert set(names("/api/export/projects", owner="张三")) == {"张三点甲", "张王共管乙"} assert names("/api/export/projects", owner="李四") == ["李四丙"] idle = set(names("/api/export/projects", idle_only="true", period_id=pid)) assert "李四丙" in idle and "张三点甲" not in idle # 本期有记录的剔出「未更新」 _, upd = _sheet(h.admin.get("/api/export/updates", params={"period_id": pid, "keyword": "没这个"})) assert upd[3:] == [] _, upd = _sheet(h.admin.get("/api/export/updates", params={"period_id": pid, "keyword": "干了大事"})) assert len(upd[3:]) == 1 and upd[3][1] == "张三点甲" def staff_names(**params): _, rows = _sheet(h.admin.get("/api/export/staff", params=params)) return [r[1] for r in rows[3:]] # 人员表第 0 列是序号 h.staff("王五", group="定制产品组") h.staff("赵六", group="平台组") assert staff_names(group="定制产品组") == ["王五"] assert staff_names(keyword="赵六") == ["赵六"]