缺陷 #19
open任务导出“新专家”判定未排除无效Task，早期deleted遮挡首次finished访谈
0%
Description
用户报告（非本QA复查生产）：专家574035、项目2227，早期Task5888为deleted（9月24日），后Task6095为finished（9月28日），预期6095标记新专家；实际用户观察未标记。源码只读初查：api/projects/views.py project_tasks_common_template对expert_id全部非空started_at做Min，未过滤有效finished状态，逐行也仅比较时间。范围：本地backend最小修复与隔离测试；禁止提交/推送/部署/生产查询操作、共享业务数据写，不重建已清本地大PG。本记录独立于#16财务46项，不覆盖原报告或结果。验收口径：首次有效已完成访谈；deleted/cancelled/未完成及其他非finished不参与首次历史；跨项目历史仍需纳入，不能因当前导出筛选范围而重新算新；并列started_at及NULL沿用现有契约，不扩为按ID唯一打标或其他口径。独立QA拟检查：无效早期遮挡、首个/后续finished、跨项目历史、无效当前行不打标、并列/NULL兼容、导出列/格式及批量查询回归。当前仅预检与计划，未运行测试、未修复或声称通过；等Backend实现后统筹再放源码review/实际隔离导出回归。证据目录outputs/task-export-new-expert-20261021/。未设置watcher、群组收件人或主动群发；现有CLI create未提供notify开关，未更改服务端通知配置。
RA Updated by Redmine Admin 21 days ago
独立QA只读review（2026-10-21，当前本地未提交候选，未部署）：固定HEAD e62185c，views.py SHA a4128aa17a62ec4695fe7d4a656780c15b1d60a5aab1f7473118e8d434f80fec、新测试SHA83d8550d91876b171521069d98b9ea5930e341eafd514195e5a09885a9bbb284，前后两次一致。REV01 Pass/源码：历史聚合只finished非空时间，四无效状态排除；REV02 Pass/源码：当前行亦须finished，同时间无效行不误标；REV03 Pass/源码测试设计：全局expert历史不受project/date/task导出筛选截断，测试参数实际映射有效；REV04 Pass/源码测试设计：NULL/无专家不标、并列最早时间旧语义保留，无finished全空；REV05 Pass/测试设计：真实APIClient GET/v1/tasks/export，解析response.content实际XLSX L列，不mock聚合/模板或镜像实现，另断言模板表头/A/K/L/附加状态列；REV06 Pass/Standards：循环外一次批量Min，无新增逐行ORM/N+1，其他列/样式/任务列表过滤和30天模型口径未改（未做querycount压测）；REV07 Pass/作者证据读取：red-history及red-current-row各1test/4失败，green-history1testOK，green-regression67tests/1.836sOK=11新增+56旧，此为作者执行非QA重跑；REV08 Pass/QA静态：diff--check退出0、业务diff仅2+/0-、hash稳定。code-review技能两隔离只读轴Standards/Spec均无阻断，主QA同意，辅助无DB/写。当前AOCI工具未提供，仅source-bound不冒称全库认知。完整逐项报告outputs/task-export-new-expert-20261021/qa-independent-review.md，简明口径export-semantics.md。本轮QA未运行测试/DB、未新建临时库、无浏览器/共享或生产查询，作者runner/清理证据不当独立执行。未commit/push/部署/关闭本缺陷；用户生产观察仍仅报告，原#16不改。若后续需独立真实导出重跑由root另排串行隔离目标。8项Pass仅对应检查层级，不是8个独立功能实测Pass。
RA Updated by Redmine Admin 21 days ago
测试发布构建期限定fixture准备（不是发布后功能Pass）：仅合法test管理员认证及GET，无导出/Task写。项目90 HTTP200/code404项目不存在，未重试。项目92 GET200，唯一QA-REC-261021-R2-6f91-untaxed-task-project/company10；公司10合同14 active/RMB读回。专家574236全5状态Task列表GET200=0；专家574235只有QA102项目88/89的Task125 finished/2026-10-21T10:00及126 finished/started_at null，均无录制/meeting。现有可测首访/NULL/无专家XLSX冒烟，缺四种无效历史不能替代主缺陷。建议最小新链2Task：同零历史合成专家574236/project92/contract14，早deleted(10月20日09时)晚finished(11时)，费用0/no-record/no自动会，具体payload outputs/task-export-new-expert-20261021/minimal-new-task-proposal.json，尚未创建，等root释放。副作用必须明确：POST仍enqueue录制检查（worker按状态/is_recorded等在发送前skip的源码路径，非实际运行证据）；Task/项目活动/last_task_created_at/成员及linkcode写；finished可能捕获本Task归属快照；update_related_table若存在ProjectCandidates会改topic_status，执行前请BE确认574236旧关联安全。详existing-fixture-readout.md及predeploy-fixture-read-r2/r3.json。BW客户端完整JSON后退出挂起已有界终止，secret仅内存/标准输入；最初失败API请求0，后续没有复用失败业务写。未查生产574035、未恢复PG、未动#16或旧Task。仍等待新BE实际版本门禁，不将旧站准备当修复验收。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-ENV Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
Direct test API 1.20.5b3; FE unchanged per Ops receipt, not reverified here
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-AUTH Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
Standard test login; role admin/su verified; no credential persistence
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-FIXTURE Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
All five exact allowed synthetic Tasks verified; expert574235 full five-status history contains only125/126
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-XLSX-125 Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
GET /tasks/export?project_id=88&task_id=125&status=finished HTTP200, Content-Type application/vnd.ms-excel; sheet=新建项目; A2=125, K2=46316.41666666666, L2=新专家, W2=已结束; original22headers=true; W1任务状态; all data rows exactly permitted Task. file=test-b3-task-125.xlsx, bytes=7287, SHA256=83b03aff579a5bbd44ae252bbfc972efce097b653094dc1aee91fd2553af88b7
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-XLSX-126 Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
GET /tasks/export?project_id=89&task_id=126&status=finished HTTP200, Content-Type application/vnd.ms-excel; sheet=新建项目; A2=126, K2=null, L2=null, W2=已结束; original22headers=true; W1任务状态; all data rows exactly permitted Task. file=test-b3-task-126.xlsx, bytes=7272, SHA256=be0e349a57d08f6f11297c59b7c45ce60f13de4f17fac2722ff1b2cff5278423
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-XLSX-127 Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
GET /tasks/export?project_id=91&task_id=127&status=finished HTTP200, Content-Type application/vnd.ms-excel; sheet=新建项目; A2=127, K2=46297.41666666666, L2=null, W2=已结束; original22headers=true; W1任务状态; all data rows exactly permitted Task. file=test-b3-task-127.xlsx, bytes=7258, SHA256=69f8c843c4ac09f1aaa7ad7231d0eeefcd48df4fdc7f5f0c8d6c225e623820c1
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-XLSX-128 Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
GET /tasks/export?project_id=91&task_id=128&status=finished HTTP200, Content-Type application/vnd.ms-excel; sheet=新建项目; A2=128, K2=46298.41666666666, L2=null, W2=已结束; original22headers=true; W1任务状态; all data rows exactly permitted Task. file=test-b3-task-128.xlsx, bytes=7261, SHA256=b68f481c47b34f70260e10239352d2e504533574a0ab6f05e8880efbe3cf8556
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-XLSX-129 Pass
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
GET /tasks/export?project_id=92&task_id=129&status=finished HTTP200, Content-Type application/vnd.ms-excel; sheet=新建项目; A2=129, K2=46299.41666666666, L2=null, W2=已结束; original22headers=true; W1任务状态; all data rows exactly permitted Task. file=test-b3-task-129.xlsx, bytes=7268, SHA256=62ad14bc58c3808d759a0cc65c34e41ea8b6819b390881477124ac773a140a7f
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-INVALID-HISTORY Blocked
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
No approved existing earlier deleted/cancelled/ongoing/failed Task for the synthetic expert; no fixture creation/status mutation authorized. Author isolated67 tests separate, not live proof.
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-LIVE-20261021] LIVE-CROSS-HISTORY-TIES Blocked
执行23:04 Asia/Shanghai；仅test BE1.20.5b3/22a9ffa，合法管理员；本条为实际限定只读验收或明确fixture阻塞，非旧#13/#16结果。
Existing125/126 provide one finished dated and one NULL, no later dated finished or tied earliest pair. Global older-history/tie scenarios not established on test.
证据 outputs/task-export-new-expert-20261021/test-b3-results.json 与 test-b3-results.md。无业务写/新fixture/状态流转/DB写/生产/浏览器；作者67隔离tests单列，不冒称共享站主deleted场景通过。不关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-EARLY-DELETED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Earlier deleted excluded; both earliest finished marked new
实际：{"invalidRow":{"id":130,"A":"130","K":"46305.33333333334","L":null,"W":"错误取消","expectedL":null,"expectedW":"错误取消","timePass":true,"labelPass":true,"statusPass":true},"firstRows":[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true},{"id":135,"A":"135","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-EARLY-CANCELLED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Earlier cancelled excluded; both earliest finished marked new
实际：{"invalidRow":{"id":131,"A":"131","K":"46305.375","L":null,"W":"客户取消","expectedL":null,"expectedW":"客户取消","timePass":true,"labelPass":true,"statusPass":true},"firstRows":[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true},{"id":135,"A":"135","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-EARLY-ONGOING Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Earlier ongoing excluded; both earliest finished marked new
实际：{"invalidRow":{"id":132,"A":"132","K":"46305.41666666666","L":null,"W":"进展中","expectedL":null,"expectedW":"进展中","timePass":true,"labelPass":true,"statusPass":true},"firstRows":[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true},{"id":135,"A":"135","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-EARLY-FAILED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Earlier failed excluded; both earliest finished marked new
实际：{"invalidRow":{"id":133,"A":"133","K":"46305.45833333334","L":null,"W":"失败","expectedL":null,"expectedW":"失败","timePass":true,"labelPass":true,"statusPass":true},"firstRows":[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true},{"id":135,"A":"135","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-CURRENT-DELETED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Non-finished current row at earliest finished timestamp has blank L
实际：{"id":136,"A":"136","K":"46307.41666666666","L":null,"W":"错误取消","expectedL":null,"expectedW":"错误取消","timePass":true,"labelPass":true,"statusPass":true}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-CURRENT-CANCELLED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Non-finished current row at earliest finished timestamp has blank L
实际：{"id":137,"A":"137","K":"46307.41666666666","L":null,"W":"客户取消","expectedL":null,"expectedW":"客户取消","timePass":true,"labelPass":true,"statusPass":true}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-CURRENT-ONGOING Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Non-finished current row at earliest finished timestamp has blank L
实际：{"id":138,"A":"138","K":"46307.41666666666","L":null,"W":"进展中","expectedL":null,"expectedW":"进展中","timePass":true,"labelPass":true,"statusPass":true}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-CURRENT-FAILED Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Non-finished current row at earliest finished timestamp has blank L
实际：{"id":139,"A":"139","K":"46307.41666666666","L":null,"W":"失败","expectedL":null,"expectedW":"失败","timePass":true,"labelPass":true,"statusPass":true}
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-TIES Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Both tied earliest finished rows marked new
实际：[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true},{"id":135,"A":"135","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-CROSS-PROJECT Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Only later Task exported; earlier valid global history outside filter still makes L blank
实际：[{"id":140,"A":"140","K":"46308.41666666666","L":null,"W":"已结束","expectedL":null,"expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]
证据：[{"file":"h2-later-project.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&project_id=92"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-DATE-OUTSIDE Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Only later Task exported; earlier valid global history outside filter still makes L blank
实际：[{"id":140,"A":"140","K":"46308.41666666666","L":null,"W":"已结束","expectedL":null,"expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]
证据：[{"file":"h2-later-date.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&start_at=2026-10-13T00:00:00&end_at=2026-10-13T23:59:59"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-TASK-OUTSIDE Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Only later Task exported; earlier valid global history outside filter still makes L blank
实际：[{"id":140,"A":"140","K":"46308.41666666666","L":null,"W":"已结束","expectedL":null,"expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]
证据：[{"file":"h2-later-task.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&task_id=140"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-FIRST-SINGLE Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Single earliest Task filter retains new label
实际：[{"id":134,"A":"134","K":"46307.41666666666","L":"新专家","W":"已结束","expectedL":"新专家","expectedW":"已结束","timePass":true,"labelPass":true,"statusPass":true}]
证据：[{"file":"h2-first-single.xlsx","sha256":"844525e478b6ad7d4251d531f0ab25d58d114b8f613a0bf42bec3d74f8541448","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&task_id=134"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。
RA Updated by Redmine Admin 20 days ago
[QA19-B3-H2-20261021] H2-XLSX-CONTRACT Pass
执行2026-10-21 23:20:32–23:20:59 Asia/Shanghai；层级真实测试API/XLSX，BE1.20.5b3/final22a9ffa，合法管理员。用户/统筹明确放行新合成fixture后执行，非旧#13/#16、非作者本地67tests。
前提：专家574236原零Task/零项目关联，P91/合同13新Task130–139及P92/合同14新Task140，唯一QA19-20261021-H2标记；11条一次POST全200/code200，逐条manifest+GET，actual/total/tax均0，telephone/is_recorded=false、成本0/会议null。
预期：Exact permitted A sets, original22headers+W1, K and actual status map across five actual workbooks
实际：[{"file":"h2-all11.xlsx","headerPass":true,"rows":11},{"file":"h2-later-project.xlsx","headerPass":true,"rows":1},{"file":"h2-later-date.xlsx","headerPass":true,"rows":1},{"file":"h2-later-task.xlsx","headerPass":true,"rows":1},{"file":"h2-first-single.xlsx","headerPass":true,"rows":1}]
证据：[{"file":"h2-all11.xlsx","sha256":"c095711156c8bb049152fd9faa872ac6df0da7ce92e2d6f4fb6f294691a07f8c","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed"},{"file":"h2-later-project.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&project_id=92"},{"file":"h2-later-date.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&start_at=2026-10-13T00:00:00&end_at=2026-10-13T23:59:59"},{"file":"h2-later-task.xlsx","sha256":"48427a04e71c36361dab37a49f4c64fe8e7c4b037cb3a416534b0af3c059b0fb","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&task_id=140"},{"file":"h2-first-single.xlsx","sha256":"844525e478b6ad7d4251d531f0ab25d58d114b8f613a0bf42bec3d74f8541448","http":200,"path":"/tasks/export?expert_id=574236&status=finished,deleted,cancelled,ongoing,failed&task_id=134"}]
完整payload/主键/HTTP/读回/单元格：outputs/task-export-new-expert-20261021/history-samples/manifest-h2.json；逐条表results-h2.md。该14项已全部实际Pass，原181/182两Blocked本轮覆盖通过，历史不覆盖、不额外计父项Pass。新记录保留，不改旧Task/生产/DB/源码，不触发真实付款/审批/会议；正常测试活动/快照/最多11录制check副作用获准，未宣称独立worker日志审核。未关闭本issue。