factory

Commit Graph

Author	SHA1	Message	Date
caoqianming	1e94027e17	perf:销售发货批次隐藏可发数量为0的批次,并用子查询消除在途量N+1 - inm:MaterialBatchFilter 新增 count_canmio__gt 过滤,销售发货(sale_out)只展示可发>0的批次 - inm/wpm:count_mioing/count_working/count_handovering 改用关联子查询单次注解, 消除列表逐行属性的N+1(纯访问101→1),并保留decimal精度(修正原IntegerField截断导致可发/可用量偏大的隐患) - 新增 apps/utils/orm.py:inflight_sum(多聚合用子查询避免JOIN翻倍) + restql_wants (?query未取这些字段时跳过子查询) Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>	2026-07-16 11:57:21 +08:00

Author

SHA1

Message

Date

caoqianming

1e94027e17

perf:销售发货批次隐藏可发数量为0的批次,并用子查询消除在途量N+1

- inm:MaterialBatchFilter 新增 count_canmio__gt 过滤,销售发货(sale_out)只展示可发>0的批次
- inm/wpm:count_mioing/count_working/count_handovering 改用关联子查询单次注解,
  消除列表逐行属性的N+1(纯访问101→1),并保留decimal精度(修正原IntegerField截断
  导致可发/可用量偏大的隐患)
- 新增 apps/utils/orm.py:inflight_sum(多聚合用子查询避免JOIN翻倍) + restql_wants
  (?query未取这些字段时跳过子查询)

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

2026-07-16 11:57:21 +08:00

1 Commits