pl_plan_archive_export.py 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746
  1. """运输计划归档导出:装货×送货按产品配对成行(一产品一行)。"""
  2. from __future__ import annotations
  3. from datetime import date, datetime
  4. from decimal import Decimal
  5. from typing import Optional, Union
  6. from sqlalchemy.orm import Session
  7. from app.models.pl_models import PlPlan, PlPlanContract, PlPlanProduct, PlTransport
  8. from app.schemas.pl.plan import PlanDeliveryRead, PlanLoadRead, PlanStopProductRead
  9. from app.services.pl.plan_list_filters import customer_name_matches_keywords
  10. from app.services.pl_internal_customer import is_internal_customer_name
  11. from app.services.pl_plan_stop_service import load_plan_stops_grouped
  12. from app.services.pl_product_display import load_crm_product_alias_maps, resolve_product_display_names
  13. StopKind = str # "load" | "delivery"
  14. def _unique_contract_nos(*sources: Optional[str]) -> str:
  15. """按出现顺序去重拼接合同编号。"""
  16. seen: list[str] = []
  17. for raw in sources:
  18. for part in str(raw or "").replace(",", ",").split(","):
  19. no = part.strip()
  20. if no and no not in seen:
  21. seen.append(no)
  22. return "、".join(seen)
  23. def _contract_nos_from_stop_links(contracts: Optional[list]) -> list[str]:
  24. """段次合同关联 → 编号列表(去重保序)。"""
  25. seen: list[str] = []
  26. for item in contracts or []:
  27. no = (
  28. getattr(item, "contract_no", None)
  29. or (item.get("contractNo") if isinstance(item, dict) else None)
  30. or getattr(item, "contractNo", None)
  31. or ""
  32. )
  33. no = str(no or "").strip()
  34. if not no:
  35. cid = (
  36. getattr(item, "contract_id", None)
  37. or (item.get("contractId") if isinstance(item, dict) else None)
  38. or getattr(item, "contractId", None)
  39. or ""
  40. )
  41. no = str(cid or "").strip()
  42. if no and no not in seen:
  43. seen.append(no)
  44. return seen
  45. def format_stop_contract_export_label(
  46. kind: StopKind,
  47. contracts: Optional[list],
  48. customer_name: Optional[str],
  49. ) -> str:
  50. """与前端列表一致:有编号显示编号;山峡/云栋缺合同 → 装货出库 / 送货入库。"""
  51. nos = _contract_nos_from_stop_links(contracts)
  52. if nos:
  53. return "、".join(nos)
  54. if is_internal_customer_name(customer_name):
  55. return "出库" if kind == "load" else "入库"
  56. return ""
  57. def format_row_contract_export_label(
  58. *,
  59. load: Optional[PlanLoadRead] = None,
  60. delivery: Optional[PlanDeliveryRead] = None,
  61. fallback: str = "",
  62. ) -> str:
  63. """配对行:装/送两侧合同文案去重拼接;无段次时回退 fallback。"""
  64. parts: list[str] = []
  65. if load is not None:
  66. parts.append(
  67. format_stop_contract_export_label("load", load.contracts, load.customer_name)
  68. )
  69. if delivery is not None:
  70. parts.append(
  71. format_stop_contract_export_label(
  72. "delivery", delivery.contracts, delivery.customer_name
  73. )
  74. )
  75. return _unique_contract_nos(*parts) or (fallback or "")
  76. def _load_contract_nos_by_plan(
  77. db: Session, tenant_no: str, plan_ids: list[str]
  78. ) -> dict[str, list[str]]:
  79. if not plan_ids:
  80. return {}
  81. rows = (
  82. db.query(PlPlanContract)
  83. .filter(
  84. PlPlanContract.tenant_no == tenant_no,
  85. PlPlanContract.del_flag == 0,
  86. PlPlanContract.plan_id.in_(plan_ids),
  87. )
  88. .order_by(PlPlanContract.order_num.asc(), PlPlanContract.create_time.asc())
  89. .all()
  90. )
  91. out: dict[str, list[str]] = {pid: [] for pid in plan_ids}
  92. for row in rows:
  93. no = (row.contract_no or "").strip()
  94. if not no:
  95. continue
  96. bucket = out.setdefault(row.plan_id, [])
  97. if no not in bucket:
  98. bucket.append(no)
  99. return out
  100. PLAN_TYPE_LABELS = {
  101. "direct": "直销单",
  102. "inbound": "入库单",
  103. "outbound": "出库单",
  104. }
  105. ARCHIVE_STATUS_LABELS = {
  106. "archived": "已归档",
  107. "unarchived": "未归档",
  108. "draft": "已暂存",
  109. }
  110. FOLLOW_STATUS_LABELS = {
  111. "wait_notice": "等通知",
  112. "pending_arrange": "待安排",
  113. "arranged": "已安排",
  114. "completed": "已完成",
  115. "cancelled": "已取消",
  116. "draft": "待安排",
  117. "processing": "进行中",
  118. }
  119. FREIGHT_TYPE_LABELS = {
  120. "by_weight": "按重量",
  121. "by_trip": "按趟",
  122. }
  123. def resolve_archive_list_io_column(kind: StopKind, customer_name: Optional[str]) -> str:
  124. """装货/送货段入库出库列方向(与前端 resolveArchiveListIoColumn 一致)。"""
  125. internal = is_internal_customer_name(customer_name)
  126. if kind == "load":
  127. return "outbound" if internal else "inbound"
  128. return "inbound" if internal else "outbound"
  129. def _format_date_value(value: Optional[Union[date, datetime, str]]) -> str:
  130. if value is None:
  131. return ""
  132. return str(value)[:10]
  133. def _format_plate_display(license_plate: Optional[str], trailer_no: Optional[str]) -> str:
  134. plate = (license_plate or "").strip()
  135. trailer = (trailer_no or "").strip()
  136. if not plate and not trailer:
  137. return ""
  138. if plate and trailer:
  139. return f"{plate}{trailer}"
  140. return plate or trailer
  141. def _get_stop_archive_actual_qty(product: PlanStopProductRead, kind: StopKind) -> Optional[Decimal]:
  142. return product.inbound_qty if kind == "load" else product.outbound_qty
  143. def _get_stop_archive_unit_price(product: PlanStopProductRead, kind: StopKind) -> Optional[Decimal]:
  144. return product.inbound_price if kind == "load" else product.outbound_price
  145. def _get_stop_archive_amount(product: PlanStopProductRead, kind: StopKind) -> Optional[Decimal]:
  146. stored = product.inbound_amount if kind == "load" else product.outbound_amount
  147. if stored is not None:
  148. return stored
  149. qty = _get_stop_archive_actual_qty(product, kind)
  150. price = _get_stop_archive_unit_price(product, kind)
  151. if qty is not None and price is not None:
  152. return qty * price
  153. return None
  154. def _stop_kind_label(kind: StopKind, delivery_seq: Optional[int] = None) -> str:
  155. if kind == "load":
  156. return "装货"
  157. return f"送货 #{delivery_seq or 1}"
  158. def _stop_time(kind: StopKind, stop: Union[PlanLoadRead, PlanDeliveryRead]) -> str:
  159. if kind == "load":
  160. return _format_date_value(getattr(stop, "load_time", None))
  161. return _format_date_value(getattr(stop, "delivery_time", None))
  162. def _product_match_key(product: PlanStopProductRead) -> tuple[str, str]:
  163. return (
  164. str(product.product_id or "").strip(),
  165. str(product.package_spec or "").strip(),
  166. )
  167. def _load_legacy_products_by_plan(
  168. db: Session, tenant_no: str, plan_ids: list[str]
  169. ) -> dict[str, list[PlPlanProduct]]:
  170. if not plan_ids:
  171. return {}
  172. products = (
  173. db.query(PlPlanProduct)
  174. .filter(
  175. PlPlanProduct.tenant_no == tenant_no,
  176. PlPlanProduct.del_flag == 0,
  177. PlPlanProduct.plan_id.in_(plan_ids),
  178. )
  179. .order_by(PlPlanProduct.order_num)
  180. .all()
  181. )
  182. grouped: dict[str, list[PlPlanProduct]] = {}
  183. for product in products:
  184. grouped.setdefault(product.plan_id, []).append(product)
  185. return grouped
  186. def _plan_common_export_fields(
  187. plan: PlPlan,
  188. transport: Optional[PlTransport],
  189. *,
  190. contract_nos: Optional[list[str]] = None,
  191. ) -> dict:
  192. freight_type_raw = transport.freight_type if transport else "by_weight"
  193. freight_type_label = FREIGHT_TYPE_LABELS.get(freight_type_raw, freight_type_raw or "")
  194. freight_price = transport.freight_price if transport else None
  195. freight_amount = plan.freight_amount
  196. if freight_amount is None and transport is not None:
  197. freight_amount = transport.freight_amount
  198. plan_date = _format_date_value(plan.plan_date)
  199. link_nos = contract_nos or []
  200. return {
  201. "planId": plan.id or "",
  202. "planNo": plan.plan_no or "",
  203. "contractNo": _unique_contract_nos(plan.contract_no, *link_nos),
  204. "planDate": plan_date,
  205. "archiveStatus": ARCHIVE_STATUS_LABELS.get(plan.archive_status or "", plan.archive_status or ""),
  206. "followStatus": FOLLOW_STATUS_LABELS.get(plan.follow_status or "", plan.follow_status or ""),
  207. "planType": PLAN_TYPE_LABELS.get(plan.plan_type or "", plan.plan_type or ""),
  208. "licensePlate": _format_plate_display(plan.license_plate, plan.trailer_no),
  209. "erpEntered": "是" if int(plan.erp_entered or 0) == 1 else "否",
  210. "freightType": freight_type_label,
  211. "freightPrice": freight_price,
  212. "freightAmount": freight_amount,
  213. "remark": plan.remark or "",
  214. }
  215. def _empty_pair_side_fields(*, side: str) -> dict:
  216. """side: load | delivery"""
  217. prefix = "load" if side == "load" else "delivery"
  218. return {
  219. f"{prefix}Customer": "",
  220. f"{prefix}Address": "",
  221. f"{prefix}Time": "",
  222. f"{prefix}PlanQty": None,
  223. f"{prefix}ActualQty": None,
  224. f"{prefix}InboundQty": None,
  225. f"{prefix}OutboundQty": None,
  226. f"{prefix}UnitPrice": None,
  227. f"{prefix}Amount": None,
  228. }
  229. def _empty_product_identity_fields() -> dict:
  230. return {
  231. "productName": "",
  232. "brandName": "",
  233. "aliasName": "",
  234. "model": "",
  235. "packageSpec": "",
  236. "unit": "",
  237. }
  238. def _format_export_brand_name(plan_product: Optional[PlPlanProduct]) -> str:
  239. """与表单「品牌」列一致:仅指定品牌时导出品牌名。"""
  240. if plan_product is None:
  241. return ""
  242. if (plan_product.brand_mode or "").strip() != "required":
  243. return ""
  244. return (plan_product.brand_name or "").strip()
  245. def _resolve_export_product_display(
  246. plan_product: Optional[PlPlanProduct],
  247. stop_product: Optional[PlanStopProductRead],
  248. *,
  249. standard_by_id: dict[str, str],
  250. alias_options_by_id: dict[str, list[str]],
  251. ) -> tuple[str, str]:
  252. """返回 (展示用产品名称, 别名)。"""
  253. saved_name = ""
  254. product_id = ""
  255. if plan_product is not None:
  256. saved_name = plan_product.product_name or ""
  257. product_id = plan_product.product_id or ""
  258. elif stop_product is not None:
  259. saved_name = stop_product.product_name or ""
  260. product_id = stop_product.product_id or ""
  261. display_name, alias = resolve_product_display_names(
  262. saved_product_name=saved_name,
  263. product_id=product_id,
  264. standard_by_id=standard_by_id,
  265. alias_options_by_id=alias_options_by_id,
  266. )
  267. return (display_name or saved_name or "").strip(), (alias or "").strip()
  268. def _lookup_plan_product(
  269. stop_product: PlanStopProductRead,
  270. plan_products_by_id: dict[str, PlPlanProduct],
  271. plan_products_by_product_id: dict[str, PlPlanProduct],
  272. ) -> Optional[PlPlanProduct]:
  273. plan_product_id = str(getattr(stop_product, "plan_product_id", None) or "").strip()
  274. if plan_product_id and plan_product_id in plan_products_by_id:
  275. return plan_products_by_id[plan_product_id]
  276. product_id = str(stop_product.product_id or "").strip()
  277. if product_id and product_id in plan_products_by_product_id:
  278. return plan_products_by_product_id[product_id]
  279. return None
  280. def _side_qty_fields(
  281. product: PlanStopProductRead,
  282. kind: StopKind,
  283. customer_name: Optional[str],
  284. *,
  285. side: str,
  286. ) -> dict:
  287. prefix = "load" if side == "load" else "delivery"
  288. actual_qty = _get_stop_archive_actual_qty(product, kind)
  289. unit_price = _get_stop_archive_unit_price(product, kind)
  290. amount = _get_stop_archive_amount(product, kind)
  291. io_col = resolve_archive_list_io_column(kind, customer_name)
  292. inbound_qty = actual_qty if io_col == "inbound" else None
  293. outbound_qty = actual_qty if io_col == "outbound" else None
  294. return {
  295. f"{prefix}PlanQty": product.plan_qty,
  296. f"{prefix}ActualQty": actual_qty,
  297. f"{prefix}InboundQty": inbound_qty,
  298. f"{prefix}OutboundQty": outbound_qty,
  299. f"{prefix}UnitPrice": unit_price,
  300. f"{prefix}Amount": amount,
  301. }
  302. def _product_identity_from_stop(
  303. product: PlanStopProductRead,
  304. *,
  305. plan_product: Optional[PlPlanProduct] = None,
  306. standard_by_id: Optional[dict[str, str]] = None,
  307. alias_options_by_id: Optional[dict[str, list[str]]] = None,
  308. ) -> dict:
  309. display_name, alias_name = _resolve_export_product_display(
  310. plan_product,
  311. product,
  312. standard_by_id=standard_by_id or {},
  313. alias_options_by_id=alias_options_by_id or {},
  314. )
  315. return {
  316. "productName": display_name or (product.product_name or ""),
  317. "brandName": _format_export_brand_name(plan_product),
  318. "aliasName": alias_name,
  319. "model": product.model or "",
  320. "packageSpec": product.package_spec or "",
  321. "unit": product.unit or "",
  322. }
  323. def _append_stop_product_rows(
  324. rows: list[dict],
  325. row_no: int,
  326. plan_common: dict,
  327. kind: StopKind,
  328. stop: Union[PlanLoadRead, PlanDeliveryRead],
  329. delivery_seq: Optional[int],
  330. products: list[PlanStopProductRead],
  331. *,
  332. plan_products_by_id: Optional[dict[str, PlPlanProduct]] = None,
  333. plan_products_by_product_id: Optional[dict[str, PlPlanProduct]] = None,
  334. standard_by_id: Optional[dict[str, str]] = None,
  335. alias_options_by_id: Optional[dict[str, list[str]]] = None,
  336. ) -> int:
  337. """单侧筛选回退:仍按段×产品一行,但写入配对列结构(另一侧留空)。"""
  338. customer_name = stop.customer_name or ""
  339. side = "load" if kind == "load" else "delivery"
  340. product_rows = products or [None]
  341. by_id = plan_products_by_id or {}
  342. by_product_id = plan_products_by_product_id or {}
  343. for product in product_rows:
  344. row_no += 1
  345. row = {
  346. **plan_common,
  347. "rowNo": row_no,
  348. "deliveryStopKind": _stop_kind_label(kind, delivery_seq) if kind == "delivery" else "",
  349. **_empty_pair_side_fields(side="load"),
  350. **_empty_pair_side_fields(side="delivery"),
  351. **_empty_product_identity_fields(),
  352. }
  353. row[f"{side}Customer"] = customer_name
  354. row[f"{side}Address"] = stop.address or ""
  355. row[f"{side}Time"] = _stop_time(kind, stop)
  356. # 兼容旧测试/调用方字段名
  357. row["stopKind"] = _stop_kind_label(kind, delivery_seq)
  358. row["stopCustomer"] = customer_name
  359. row["stopAddress"] = stop.address or ""
  360. row["stopTime"] = _stop_time(kind, stop)
  361. row["contractNo"] = format_stop_contract_export_label(
  362. kind, stop.contracts, customer_name
  363. ) or (plan_common.get("contractNo") or "")
  364. if product is not None:
  365. plan_product = _lookup_plan_product(product, by_id, by_product_id)
  366. row.update(
  367. _product_identity_from_stop(
  368. product,
  369. plan_product=plan_product,
  370. standard_by_id=standard_by_id,
  371. alias_options_by_id=alias_options_by_id,
  372. )
  373. )
  374. side_fields = _side_qty_fields(product, kind, customer_name, side=side)
  375. row.update(side_fields)
  376. # 兼容旧单侧字段
  377. row["planQty"] = side_fields[f"{side}PlanQty"]
  378. row["actualQty"] = side_fields[f"{side}ActualQty"]
  379. row["inboundQty"] = side_fields[f"{side}InboundQty"]
  380. row["outboundQty"] = side_fields[f"{side}OutboundQty"]
  381. row["unitPrice"] = side_fields[f"{side}UnitPrice"]
  382. row["amount"] = side_fields[f"{side}Amount"]
  383. else:
  384. row.update(
  385. {
  386. "planQty": None,
  387. "actualQty": None,
  388. "inboundQty": None,
  389. "outboundQty": None,
  390. "unitPrice": None,
  391. "amount": None,
  392. }
  393. )
  394. rows.append(row)
  395. return row_no
  396. def _append_paired_product_rows(
  397. rows: list[dict],
  398. row_no: int,
  399. plan_common: dict,
  400. load: PlanLoadRead,
  401. delivery: PlanDeliveryRead,
  402. delivery_seq: int,
  403. *,
  404. plan_products_by_id: Optional[dict[str, PlPlanProduct]] = None,
  405. plan_products_by_product_id: Optional[dict[str, PlPlanProduct]] = None,
  406. standard_by_id: Optional[dict[str, str]] = None,
  407. alias_options_by_id: Optional[dict[str, list[str]]] = None,
  408. ) -> int:
  409. """装货×送货按 productId+packageSpec 内连接,一产品一行。"""
  410. load_customer = load.customer_name or ""
  411. delivery_customer = delivery.customer_name or ""
  412. load_by_key: dict[tuple[str, str], PlanStopProductRead] = {}
  413. by_id = plan_products_by_id or {}
  414. by_product_id = plan_products_by_product_id or {}
  415. for product in load.products or []:
  416. key = _product_match_key(product)
  417. if not key[0]:
  418. continue
  419. # 同键多条时保留首条
  420. load_by_key.setdefault(key, product)
  421. for product_d in delivery.products or []:
  422. key = _product_match_key(product_d)
  423. if not key[0]:
  424. continue
  425. product_l = load_by_key.get(key)
  426. if product_l is None:
  427. continue
  428. row_no += 1
  429. load_fields = _side_qty_fields(product_l, "load", load_customer, side="load")
  430. delivery_fields = _side_qty_fields(
  431. product_d, "delivery", delivery_customer, side="delivery"
  432. )
  433. plan_product = _lookup_plan_product(product_l, by_id, by_product_id)
  434. row = {
  435. **plan_common,
  436. "rowNo": row_no,
  437. "deliveryStopKind": _stop_kind_label("delivery", delivery_seq),
  438. "loadCustomer": load_customer,
  439. "loadAddress": load.address or "",
  440. "loadTime": _stop_time("load", load),
  441. "deliveryCustomer": delivery_customer,
  442. "deliveryAddress": delivery.address or "",
  443. "deliveryTime": _stop_time("delivery", delivery),
  444. "contractNo": format_row_contract_export_label(
  445. load=load,
  446. delivery=delivery,
  447. fallback=str(plan_common.get("contractNo") or ""),
  448. ),
  449. **_product_identity_from_stop(
  450. product_l,
  451. plan_product=plan_product,
  452. standard_by_id=standard_by_id,
  453. alias_options_by_id=alias_options_by_id,
  454. ),
  455. **load_fields,
  456. **delivery_fields,
  457. }
  458. rows.append(row)
  459. return row_no
  460. def _append_legacy_plan_product_rows(
  461. rows: list[dict],
  462. row_no: int,
  463. plan: PlPlan,
  464. plan_common: dict,
  465. products: list[PlPlanProduct],
  466. *,
  467. standard_by_id: Optional[dict[str, str]] = None,
  468. alias_options_by_id: Optional[dict[str, list[str]]] = None,
  469. ) -> int:
  470. """无段表数据时回退计划产品级导出(兼容旧数据)。"""
  471. product_rows = products or [None]
  472. fallback_no = str(plan_common.get("contractNo") or "")
  473. if fallback_no:
  474. legacy_contract_no = fallback_no
  475. else:
  476. legacy_contract_no = _unique_contract_nos(
  477. format_stop_contract_export_label("load", None, plan.supplier_name),
  478. format_stop_contract_export_label(
  479. "delivery", None, plan.customer_name or plan.destination_name
  480. ),
  481. )
  482. for product in product_rows:
  483. row_no += 1
  484. row = {
  485. **plan_common,
  486. "rowNo": row_no,
  487. "deliveryStopKind": "",
  488. **_empty_pair_side_fields(side="load"),
  489. **_empty_pair_side_fields(side="delivery"),
  490. **_empty_product_identity_fields(),
  491. "loadCustomer": plan.supplier_name or plan.customer_name or "",
  492. "loadAddress": "",
  493. "deliveryCustomer": plan.customer_name or "",
  494. "deliveryAddress": plan.destination_name or "",
  495. "deliveryTime": _format_date_value(plan.delivery_time),
  496. "contractNo": legacy_contract_no,
  497. # 兼容旧字段
  498. "stopKind": "",
  499. "stopCustomer": plan.customer_name or plan.supplier_name or "",
  500. "stopAddress": plan.destination_name or "",
  501. "stopTime": _format_date_value(plan.delivery_time),
  502. "planQty": None,
  503. "actualQty": None,
  504. "inboundQty": None,
  505. "outboundQty": None,
  506. "unitPrice": None,
  507. "amount": None,
  508. }
  509. if product is not None:
  510. display_name, alias_name = _resolve_export_product_display(
  511. product,
  512. None,
  513. standard_by_id=standard_by_id or {},
  514. alias_options_by_id=alias_options_by_id or {},
  515. )
  516. row.update(
  517. {
  518. "productName": display_name or (product.product_name or ""),
  519. "brandName": _format_export_brand_name(product),
  520. "aliasName": alias_name,
  521. "model": product.model or "",
  522. "packageSpec": product.package_spec or "",
  523. "unit": product.unit or "",
  524. "loadPlanQty": product.quantity,
  525. "loadActualQty": product.actual_qty,
  526. "loadInboundQty": product.inbound_qty,
  527. "loadOutboundQty": product.outbound_qty,
  528. "loadUnitPrice": product.inbound_price or product.outbound_price,
  529. "loadAmount": product.inbound_amount or product.outbound_amount,
  530. "planQty": product.quantity,
  531. "actualQty": product.actual_qty,
  532. "inboundQty": product.inbound_qty,
  533. "outboundQty": product.outbound_qty,
  534. "unitPrice": product.inbound_price or product.outbound_price,
  535. "amount": product.inbound_amount or product.outbound_amount,
  536. }
  537. )
  538. rows.append(row)
  539. return row_no
  540. def build_plan_archive_export_rows(
  541. db: Session,
  542. tenant_no: str,
  543. plans: list[PlPlan],
  544. transports_by_id: dict[str, PlTransport],
  545. *,
  546. stop_kind: Optional[str] = None,
  547. stop_customer_keywords: Optional[list] = None,
  548. ) -> list[dict]:
  549. """构建归档导出数据行。
  550. 默认:装货×送货按产品内连接,一产品配对一行。
  551. stop_kind 为 load / delivery 时回退为单侧段×产品一行(列写入对应侧)。
  552. stop_customer_keywords 非空时:配对模式下装或送任一匹配即保留;单侧模式仅匹配该侧客户。
  553. """
  554. if not plans:
  555. return []
  556. include_load = stop_kind != "delivery"
  557. include_delivery = stop_kind != "load"
  558. pair_mode = include_load and include_delivery
  559. keywords = [str(item).strip() for item in (stop_customer_keywords or []) if str(item).strip()]
  560. def _keep_customer(name: Optional[str]) -> bool:
  561. if not keywords:
  562. return True
  563. return customer_name_matches_keywords(name, keywords)
  564. plan_ids = [plan.id for plan in plans]
  565. stops_by_plan = load_plan_stops_grouped(db, tenant_no, plan_ids)
  566. legacy_products_by_plan = _load_legacy_products_by_plan(db, tenant_no, plan_ids)
  567. contract_nos_by_plan = _load_contract_nos_by_plan(db, tenant_no, plan_ids)
  568. crm_product_ids: list[str] = []
  569. for products in legacy_products_by_plan.values():
  570. for product in products:
  571. if product.product_id:
  572. crm_product_ids.append(product.product_id)
  573. for load_read, delivery_reads in stops_by_plan.values():
  574. for stop in ([load_read] if load_read is not None else []) + list(delivery_reads or []):
  575. for stop_product in stop.products or []:
  576. if stop_product.product_id:
  577. crm_product_ids.append(stop_product.product_id)
  578. standard_by_id, alias_options_by_id = load_crm_product_alias_maps(
  579. db,
  580. tenant_no=tenant_no,
  581. product_ids=crm_product_ids,
  582. )
  583. rows: list[dict] = []
  584. row_no = 0
  585. for plan in plans:
  586. transport = transports_by_id.get(plan.transport_id) if plan.transport_id else None
  587. plan_common = _plan_common_export_fields(
  588. plan,
  589. transport,
  590. contract_nos=contract_nos_by_plan.get(plan.id, []),
  591. )
  592. load_read, delivery_reads = stops_by_plan.get(plan.id, (None, []))
  593. plan_products = legacy_products_by_plan.get(plan.id, [])
  594. plan_products_by_id = {str(p.id): p for p in plan_products if p.id}
  595. plan_products_by_product_id: dict[str, PlPlanProduct] = {}
  596. for product in plan_products:
  597. pid = str(product.product_id or "").strip()
  598. if pid and pid not in plan_products_by_product_id:
  599. plan_products_by_product_id[pid] = product
  600. has_stops = load_read is not None or bool(delivery_reads)
  601. if not has_stops:
  602. if not include_load:
  603. continue
  604. legacy_customer = plan.customer_name or plan.supplier_name or ""
  605. if not _keep_customer(legacy_customer):
  606. continue
  607. row_no = _append_legacy_plan_product_rows(
  608. rows,
  609. row_no,
  610. plan,
  611. plan_common,
  612. plan_products,
  613. standard_by_id=standard_by_id,
  614. alias_options_by_id=alias_options_by_id,
  615. )
  616. continue
  617. if pair_mode:
  618. if load_read is None:
  619. continue
  620. for idx, delivery_read in enumerate(delivery_reads):
  621. if keywords and not (
  622. _keep_customer(load_read.customer_name)
  623. or _keep_customer(delivery_read.customer_name)
  624. ):
  625. continue
  626. delivery_seq = delivery_read.seq or (idx + 1)
  627. row_no = _append_paired_product_rows(
  628. rows,
  629. row_no,
  630. plan_common,
  631. load_read,
  632. delivery_read,
  633. delivery_seq,
  634. plan_products_by_id=plan_products_by_id,
  635. plan_products_by_product_id=plan_products_by_product_id,
  636. standard_by_id=standard_by_id,
  637. alias_options_by_id=alias_options_by_id,
  638. )
  639. continue
  640. # 单侧筛选:旧逻辑
  641. if include_load and load_read is not None and _keep_customer(load_read.customer_name):
  642. row_no = _append_stop_product_rows(
  643. rows,
  644. row_no,
  645. plan_common,
  646. "load",
  647. load_read,
  648. None,
  649. load_read.products or [],
  650. plan_products_by_id=plan_products_by_id,
  651. plan_products_by_product_id=plan_products_by_product_id,
  652. standard_by_id=standard_by_id,
  653. alias_options_by_id=alias_options_by_id,
  654. )
  655. if include_delivery:
  656. for idx, delivery_read in enumerate(delivery_reads):
  657. if not _keep_customer(delivery_read.customer_name):
  658. continue
  659. delivery_seq = delivery_read.seq or (idx + 1)
  660. row_no = _append_stop_product_rows(
  661. rows,
  662. row_no,
  663. plan_common,
  664. "delivery",
  665. delivery_read,
  666. delivery_seq,
  667. delivery_read.products or [],
  668. plan_products_by_id=plan_products_by_id,
  669. plan_products_by_product_id=plan_products_by_product_id,
  670. standard_by_id=standard_by_id,
  671. alias_options_by_id=alias_options_by_id,
  672. )
  673. return rows