InboundVerify

LogisticsHubIPA/InboundVerify

Fork 0

Commit Graph

Author	SHA1	Message	Date
Misaka	dc7653c256	fix(db_compare): anchor comparison on actual_offset so yunda reads fresh data 比对以实到扫描日（actual.scan_time::date）为锚，锚点日期必须等于实到下载日 = actual_offset。原 _site_undelivered_handler（runtime.py）与 _target_date_for（db_compare.py）误用 expected_offset 算锚点：韵达 exp=1 / act=0，锚点落到 today-1（昨天），读到历史数据。两处改用 actual_offset 后韵达锚点 = today，反推出 expected 的昨天批次正确参与比对。其余 3 站 exp == act == 0，锚点不变。 5 站真机验证：韵达 07-31 比对现读新鲜数据 107/104/3（修复前读昨天 116/115/1）；中通/安能/顺心不变；全站汇总报表重新生成。 Co-Authored-By: Claude <noreply@anthropic.com>	2026-07-31 22:58:12 +08:00
Misaka	3c7e9f2522	feat(db_compare): DB-based full summary report + wire 跑比对 to it 新增 build_full_report：4 站走 compare_site_date、百世走 baishi_daily_stats(基数) + undelivered_record(按 ingested_at 日期过滤)，复用 compare.build_summary 渲染 KPI/柱状图/口径说明，产 output/应到未到数据.xlsx。跑比对入口(__compare__)从 compare.main() Excel 路径切换到 build_full_report。百世未到件用基数差(undelivered_pieces)与应到/已到自洽。集成验证：前端跑比对 -> build_full_report -> /report 下载，各站未到件顺心8/中通10/韵达2/安能0/百世8。 Co-Authored-By: Claude <noreply@anthropic.com>	2026-07-31 21:56:39 +08:00
Misaka_Company	541836fd1b	feat(db_compare): add PostgreSQL-based comparison engine with SF handling Replace Excel-based undelivered comparison with DB queries for all four sites. The engine anchors on actual scan_time, reverse-lookups handover batches, and compares expected vs actual waybill-by-waybill. Shunxin SF waybills: use COUNT(*) instead of COUNT(DISTINCT piece_no) since SF piece numbers are random and not derivable from the waybill. Changes: - db_compare.py: new module with compare_site_date(), compare_site_batch(), write_result_excel(), and POST /compare API endpoint - runtime.py: switch _site_undelivered_handler from compare.write_site_file (Excel) to db_compare (DB); downloads succeed independently of comparison - server.py: add POST /compare endpoint with date validation - docs: implementation plan for Shunxin DB comparison Co-Authored-By: Claude <noreply@anthropic.com>	2026-07-31 16:31:54 +08:00

Author

SHA1

Message

Date

Misaka

dc7653c256

fix(db_compare): anchor comparison on actual_offset so yunda reads fresh data

比对以实到扫描日（actual.scan_time::date）为锚，锚点日期必须等于实到下载日 = actual_offset。
原 _site_undelivered_handler（runtime.py）与 _target_date_for（db_compare.py）误用
expected_offset 算锚点：韵达 exp=1 / act=0，锚点落到 today-1（昨天），读到历史数据。
两处改用 actual_offset 后韵达锚点 = today，反推出 expected 的昨天批次正确参与比对。
其余 3 站 exp == act == 0，锚点不变。

5 站真机验证：韵达 07-31 比对现读新鲜数据 107/104/3（修复前读昨天 116/115/1）；
中通/安能/顺心 不变；全站汇总报表重新生成。

Co-Authored-By: Claude <noreply@anthropic.com>

2026-07-31 22:58:12 +08:00

Misaka

3c7e9f2522

feat(db_compare): DB-based full summary report + wire 跑比对 to it

新增 build_full_report：4 站走 compare_site_date、百世走 baishi_daily_stats(基数) + undelivered_record(按 ingested_at 日期过滤)，复用 compare.build_summary 渲染 KPI/柱状图/口径说明，产 output/应到未到数据.xlsx。跑比对入口(__compare__)从 compare.main() Excel 路径切换到 build_full_report。百世未到件用基数差(undelivered_pieces)与应到/已到自洽。

集成验证：前端跑比对 -> build_full_report -> /report 下载，各站未到件 顺心8/中通10/韵达2/安能0/百世8。

Co-Authored-By: Claude <noreply@anthropic.com>

2026-07-31 21:56:39 +08:00

Misaka_Company

541836fd1b

feat(db_compare): add PostgreSQL-based comparison engine with SF handling

Replace Excel-based undelivered comparison with DB queries for all four
sites. The engine anchors on actual scan_time, reverse-lookups handover
batches, and compares expected vs actual waybill-by-waybill.

Shunxin SF waybills: use COUNT(*) instead of COUNT(DISTINCT piece_no)
since SF piece numbers are random and not derivable from the waybill.

Changes:
- db_compare.py: new module with compare_site_date(), compare_site_batch(),
  write_result_excel(), and POST /compare API endpoint
- runtime.py: switch _site_undelivered_handler from compare.write_site_file
  (Excel) to db_compare (DB); downloads succeed independently of comparison
- server.py: add POST /compare endpoint with date validation
- docs: implementation plan for Shunxin DB comparison

Co-Authored-By: Claude <noreply@anthropic.com>

2026-07-31 16:31:54 +08:00

3 Commits