pl_plan_service.py 45 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458
  1. """运输计划业务逻辑"""
  2. import json
  3. from datetime import date, datetime
  4. from decimal import Decimal
  5. from typing import Optional, Union
  6. from fastapi import HTTPException
  7. from sqlalchemy import and_, exists, func, or_, select
  8. from sqlalchemy.orm import Session
  9. from app.core.utils import generate_uuid
  10. from app.models.crm_models import CrmProduct
  11. from app.models.pl_models import (
  12. PlCarrier,
  13. PlFreightSettlement,
  14. PlFreightSettlementTransport,
  15. PlPersonnel,
  16. PlPlan,
  17. PlPlanChange,
  18. PlPlanProduct,
  19. PlPlanTransport,
  20. PlTransport,
  21. PlTransportSiteLink,
  22. PlVehicle,
  23. PlVehiclePersonnel,
  24. )
  25. from app.schemas.pl.plan import (
  26. PlanArchiveFreightBlock,
  27. PlanArchiveProductItem,
  28. PlanCreateFull,
  29. PlanDriverFeedbackUpdateBody,
  30. PlanProductCreate,
  31. PlanSiteFeedbackUpdateBody,
  32. PlanTransportCreateBlock,
  33. )
  34. from app.services.pl_brand_archive import persist_plan_product_brand_qtys, validate_brand_qty_rows
  35. from app.services.pl_feedback_brand_qty import persist_transport_product_feedback
  36. from app.services.pl_freight_settlement_service import sync_draft_settlement_freight_for_transport
  37. from app.services.pl_transport_resource_snapshot_service import (
  38. apply_resource_snapshot_json,
  39. build_transport_resource_snapshot,
  40. clear_resource_snapshot,
  41. )
  42. def determine_plan_type(supplier_name: Optional[str], destination_name: Optional[str]) -> str:
  43. if destination_name and ("安庆山峡" in destination_name or "安徽云栋" in destination_name):
  44. return "inbound"
  45. if supplier_name and ("安庆山峡" in supplier_name or "安徽云栋" in supplier_name):
  46. return "outbound"
  47. return "direct"
  48. def is_ton_product_unit(unit: Optional[str]) -> bool:
  49. code = (unit or "").strip()
  50. if not code:
  51. return True
  52. return code in ("dun", "吨")
  53. def _product_quantity(prod: PlanProductCreate) -> Decimal:
  54. if prod.quantity is not None:
  55. return Decimal(str(prod.quantity))
  56. if prod.inbound_estimate_qty is not None:
  57. return Decimal(str(prod.inbound_estimate_qty))
  58. if prod.outbound_estimate_qty is not None:
  59. return Decimal(str(prod.outbound_estimate_qty))
  60. return Decimal("0")
  61. def _product_create_actual_qty(prod: PlanProductCreate) -> Decimal:
  62. if prod.actual_qty is not None:
  63. return Decimal(str(prod.actual_qty))
  64. return Decimal("0")
  65. def _plan_product_actual_qty(prod: PlPlanProduct) -> Decimal:
  66. if prod.actual_qty is not None:
  67. return Decimal(str(prod.actual_qty))
  68. return Decimal("0")
  69. def sum_product_actual_quantities(products: list[PlanProductCreate]) -> Decimal:
  70. return sum(_product_create_actual_qty(p) for p in products)
  71. def sum_plan_product_actual_quantities(products: list[PlPlanProduct]) -> Decimal:
  72. return sum(_plan_product_actual_qty(p) for p in products)
  73. def _estimate_qty_fields(plan_type: str, qty: Optional[Decimal]) -> dict:
  74. if qty is None:
  75. return {}
  76. q = float(qty)
  77. if plan_type == "inbound":
  78. return {"inbound_estimate_qty": q, "outbound_estimate_qty": q}
  79. if plan_type == "outbound":
  80. return {"outbound_estimate_qty": q, "inbound_estimate_qty": q}
  81. return {"inbound_estimate_qty": q, "outbound_estimate_qty": q}
  82. def build_plan_product(
  83. *,
  84. tenant_no: str,
  85. plan_id: str,
  86. plan_type: str,
  87. prod: PlanProductCreate,
  88. order_num: int,
  89. user_id: str,
  90. dept_id: str,
  91. ) -> PlPlanProduct:
  92. qty = _product_quantity(prod)
  93. estimates = _estimate_qty_fields(plan_type, qty if qty else None)
  94. tax_price = prod.tax_price
  95. return PlPlanProduct(
  96. id=generate_uuid(),
  97. tenant_no=tenant_no,
  98. plan_id=plan_id,
  99. product_id=prod.product_id,
  100. product_no=prod.product_no,
  101. product_name=prod.product_name,
  102. brand_mode=prod.brand_mode,
  103. brand_id=prod.brand_id,
  104. brand_name=prod.brand_name,
  105. model=prod.model,
  106. unit=prod.unit or "吨",
  107. category_name=prod.category_name,
  108. package_spec=prod.package_spec,
  109. delivery_method=prod.delivery_method,
  110. quantity=qty if qty else None,
  111. actual_qty=Decimal(str(prod.actual_qty)) if prod.actual_qty is not None else None,
  112. tax_price=tax_price,
  113. tax_amount=prod.tax_amount,
  114. tax_subtotal=prod.tax_subtotal,
  115. is_explosive=prod.is_explosive,
  116. is_toxic=prod.is_toxic,
  117. purchase_cert_url=prod.purchase_cert_url,
  118. transport_cert_url=prod.transport_cert_url,
  119. legal_use_cert_url=prod.legal_use_cert_url,
  120. inbound_price=tax_price,
  121. outbound_price=tax_price,
  122. inbound_amount=prod.tax_subtotal,
  123. outbound_amount=prod.tax_subtotal,
  124. remark=prod.remark,
  125. order_num=order_num,
  126. create_by=user_id,
  127. create_dept_id=dept_id,
  128. **estimates,
  129. )
  130. def _apply_vehicle_snapshot_to_plan_transport(
  131. db: Session,
  132. *,
  133. tenant_no: str,
  134. plan: PlPlan,
  135. transport: Optional[PlTransport],
  136. vehicle: PlVehicle,
  137. driver_id: Optional[str],
  138. ) -> None:
  139. snapshot = build_transport_resource_snapshot(
  140. db,
  141. tenant_no,
  142. vehicle.id,
  143. selected_driver_id=driver_id,
  144. )
  145. apply_resource_snapshot_json(plan=plan, transport=transport, snapshot=snapshot)
  146. def _resolve_driver(
  147. db: Session,
  148. tenant_no: str,
  149. vehicle_id: str,
  150. driver_id: Optional[str],
  151. ) -> tuple[Optional[str], Optional[str], Optional[str]]:
  152. """解析司机:显式选择优先,否则取车辆关联司机;均无则允许为空。"""
  153. if driver_id:
  154. personnel = (
  155. db.query(PlPersonnel)
  156. .filter(
  157. PlPersonnel.id == driver_id,
  158. PlPersonnel.tenant_no == tenant_no,
  159. PlPersonnel.del_flag == 0,
  160. )
  161. .first()
  162. )
  163. if personnel:
  164. return personnel.id, personnel.personnel_name, personnel.phone_no
  165. default_link = (
  166. db.query(PlVehiclePersonnel)
  167. .filter(
  168. PlVehiclePersonnel.vehicle_id == vehicle_id,
  169. PlVehiclePersonnel.tenant_no == tenant_no,
  170. PlVehiclePersonnel.del_flag == 0,
  171. PlVehiclePersonnel.role == "driver",
  172. )
  173. .order_by(PlVehiclePersonnel.is_default.desc(), PlVehiclePersonnel.order_num.asc())
  174. .first()
  175. )
  176. if default_link:
  177. personnel = (
  178. db.query(PlPersonnel)
  179. .filter(
  180. PlPersonnel.id == default_link.personnel_id,
  181. PlPersonnel.del_flag == 0,
  182. )
  183. .first()
  184. )
  185. if personnel:
  186. return personnel.id, personnel.personnel_name, personnel.phone_no
  187. return None, None, None
  188. def _calc_freight_amount(
  189. freight_type: str,
  190. products: list[PlPlanProduct],
  191. transport_qty: Optional[Decimal],
  192. freight_price: Optional[Decimal],
  193. freight_amount: Optional[Decimal],
  194. ) -> Decimal:
  195. if freight_type == "by_trip":
  196. return Decimal(str(freight_amount or 0))
  197. qty = transport_qty
  198. if qty is None:
  199. qty = sum_plan_product_actual_quantities(products)
  200. if freight_price is not None:
  201. computed = qty * Decimal(str(freight_price))
  202. if freight_amount is not None:
  203. return Decimal(str(freight_amount))
  204. return computed
  205. return Decimal(str(freight_amount or 0))
  206. def fetch_hazard_flags_map(
  207. db: Session,
  208. tenant_no: str,
  209. product_ids: Optional[list[str]] = None,
  210. ) -> dict[str, tuple[int, int]]:
  211. """批量从 CRM 产品主数据读取易制毒/易制爆标识。"""
  212. from app.models.crm_models import CrmProduct
  213. ids = [str(pid) for pid in (product_ids or []) if pid]
  214. if not ids:
  215. return {}
  216. rows = (
  217. db.query(CrmProduct.id, CrmProduct.is_toxic, CrmProduct.is_explosive)
  218. .filter(
  219. CrmProduct.id.in_(ids),
  220. CrmProduct.tenant_no == tenant_no,
  221. CrmProduct.del_flag == 0,
  222. )
  223. .all()
  224. )
  225. return {
  226. str(row.id): (int(row.is_toxic or 0), int(row.is_explosive or 0))
  227. for row in rows
  228. }
  229. def resolve_hazard_flags_from_crm(
  230. db: Session,
  231. tenant_no: str,
  232. product_id: Optional[str],
  233. *,
  234. hazard_map: Optional[dict[str, tuple[int, int]]] = None,
  235. ) -> tuple[int, int]:
  236. """从 CRM 产品主数据读取易制毒/易制爆标识(不读计划产品快照)。"""
  237. if not product_id:
  238. return 0, 0
  239. if hazard_map is not None:
  240. return hazard_map.get(str(product_id), (0, 0))
  241. from app.models.crm_models import CrmProduct
  242. row = (
  243. db.query(CrmProduct)
  244. .filter(
  245. CrmProduct.id == product_id,
  246. CrmProduct.tenant_no == tenant_no,
  247. CrmProduct.del_flag == 0,
  248. )
  249. .first()
  250. )
  251. if not row:
  252. return 0, 0
  253. return int(row.is_toxic or 0), int(row.is_explosive or 0)
  254. def plan_has_hazard_products(
  255. db: Session,
  256. tenant_no: str,
  257. products: list[PlPlanProduct],
  258. ) -> bool:
  259. return bool(collect_hazard_product_ids(db, tenant_no, products))
  260. def _cert_url_blank(column):
  261. """证书 URL 为空(NULL / 空串 / 纯空白)。"""
  262. return func.nullif(func.trim(func.coalesce(column, "")), "").is_(None)
  263. def plan_has_hazard_product_exists(tenant_no: str):
  264. """列表筛选:计划下存在 CRM 标识为易制毒/易制爆的产品。"""
  265. return exists(
  266. select(PlPlanProduct.id)
  267. .select_from(PlPlanProduct)
  268. .join(
  269. CrmProduct,
  270. and_(
  271. CrmProduct.id == PlPlanProduct.product_id,
  272. CrmProduct.tenant_no == tenant_no,
  273. CrmProduct.del_flag == 0,
  274. ),
  275. )
  276. .where(
  277. PlPlanProduct.plan_id == PlPlan.id,
  278. PlPlanProduct.tenant_no == tenant_no,
  279. PlPlanProduct.del_flag == 0,
  280. or_(CrmProduct.is_toxic == 1, CrmProduct.is_explosive == 1),
  281. )
  282. )
  283. def plan_has_incomplete_hazard_cert_exists(tenant_no: str):
  284. """列表筛选:存在危化产品且至少一张必需证书未上传。"""
  285. toxic_incomplete = and_(
  286. CrmProduct.is_toxic == 1,
  287. or_(
  288. _cert_url_blank(PlPlanProduct.purchase_cert_url),
  289. _cert_url_blank(PlPlanProduct.transport_cert_url),
  290. ),
  291. )
  292. explosive_incomplete = and_(
  293. CrmProduct.is_explosive == 1,
  294. _cert_url_blank(PlPlanProduct.legal_use_cert_url),
  295. )
  296. return exists(
  297. select(PlPlanProduct.id)
  298. .select_from(PlPlanProduct)
  299. .join(
  300. CrmProduct,
  301. and_(
  302. CrmProduct.id == PlPlanProduct.product_id,
  303. CrmProduct.tenant_no == tenant_no,
  304. CrmProduct.del_flag == 0,
  305. ),
  306. )
  307. .where(
  308. PlPlanProduct.plan_id == PlPlan.id,
  309. PlPlanProduct.tenant_no == tenant_no,
  310. PlPlanProduct.del_flag == 0,
  311. or_(toxic_incomplete, explosive_incomplete),
  312. )
  313. )
  314. def collect_hazard_product_ids(
  315. db: Session,
  316. tenant_no: str,
  317. products: list[Union[PlPlanProduct, PlanProductCreate]],
  318. ) -> frozenset[str]:
  319. product_ids = [str(p.product_id) for p in products if getattr(p, "product_id", None)]
  320. if not product_ids:
  321. return frozenset()
  322. hazard_map = fetch_hazard_flags_map(db, tenant_no, product_ids)
  323. hazard_ids: set[str] = set()
  324. for prod in products:
  325. product_id = getattr(prod, "product_id", None)
  326. if not product_id:
  327. continue
  328. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  329. db,
  330. tenant_no,
  331. product_id,
  332. hazard_map=hazard_map,
  333. )
  334. if is_toxic or is_explosive:
  335. hazard_ids.add(str(product_id))
  336. return frozenset(hazard_ids)
  337. def clear_hazard_cert_ready(plan: PlPlan) -> None:
  338. plan.hazard_cert_ready = 0
  339. plan.hazard_cert_ready_by = None
  340. plan.hazard_cert_ready_time = None
  341. def _required_hazard_cert_fields(is_toxic: int, is_explosive: int) -> list[str]:
  342. fields: list[str] = []
  343. if is_toxic:
  344. fields.extend(["purchase_cert_url", "transport_cert_url"])
  345. if is_explosive:
  346. fields.append("legal_use_cert_url")
  347. return fields
  348. def _is_hazard_product_cert_complete(
  349. product: PlPlanProduct,
  350. *,
  351. is_toxic: int,
  352. is_explosive: int,
  353. ) -> bool:
  354. for field in _required_hazard_cert_fields(is_toxic, is_explosive):
  355. if not str(getattr(product, field, "") or "").strip():
  356. return False
  357. return True
  358. def all_hazard_products_cert_complete(
  359. db: Session,
  360. tenant_no: str,
  361. products: list[PlPlanProduct],
  362. ) -> bool:
  363. """计划内所有危化品产品的所需证书槽位均已上传。"""
  364. if not products:
  365. return True
  366. hazard_map = fetch_hazard_flags_map(
  367. db,
  368. tenant_no,
  369. [product.product_id for product in products if product.product_id],
  370. )
  371. has_hazard = False
  372. for product in products:
  373. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  374. db,
  375. tenant_no,
  376. product.product_id,
  377. hazard_map=hazard_map,
  378. )
  379. if not (is_toxic or is_explosive):
  380. continue
  381. has_hazard = True
  382. if not _is_hazard_product_cert_complete(
  383. product,
  384. is_toxic=is_toxic,
  385. is_explosive=is_explosive,
  386. ):
  387. return False
  388. return has_hazard
  389. def maybe_auto_set_hazard_cert_ready(
  390. db: Session,
  391. *,
  392. tenant_no: str,
  393. plan: PlPlan,
  394. products: list[PlPlanProduct],
  395. user_id: str,
  396. ) -> None:
  397. """全部危化品证书已上传时,自动标记证书齐备(与人工确认等效)。"""
  398. if int(plan.hazard_cert_ready or 0):
  399. return
  400. if not all_hazard_products_cert_complete(db, tenant_no, products):
  401. return
  402. plan.hazard_cert_ready = 1
  403. plan.hazard_cert_ready_by = user_id
  404. plan.hazard_cert_ready_time = datetime.now()
  405. def validate_hazard_cert_ready_for_transport(
  406. db: Session,
  407. tenant_no: str,
  408. plan: PlPlan,
  409. products: list[PlPlanProduct],
  410. ) -> None:
  411. if not plan_has_hazard_products(db, tenant_no, products):
  412. return
  413. if int(plan.hazard_cert_ready or 0):
  414. return
  415. if all_hazard_products_cert_complete(db, tenant_no, products):
  416. return
  417. raise HTTPException(
  418. status_code=400,
  419. detail="该计划危化品证书尚未确认齐备,请至危化品证上传页操作",
  420. )
  421. def set_hazard_cert_ready(
  422. db: Session,
  423. *,
  424. tenant_no: str,
  425. plan_id: str,
  426. ready: bool,
  427. user_id: str,
  428. ) -> PlPlan:
  429. plan = (
  430. db.query(PlPlan)
  431. .filter(
  432. PlPlan.id == plan_id,
  433. PlPlan.tenant_no == tenant_no,
  434. PlPlan.del_flag == 0,
  435. )
  436. .first()
  437. )
  438. if not plan:
  439. raise HTTPException(status_code=404, detail="计划不存在")
  440. if plan.archive_status == "archived":
  441. raise HTTPException(status_code=400, detail="已归档的计划不能修改证书齐备状态")
  442. if plan.follow_status == "cancelled":
  443. raise HTTPException(status_code=400, detail="已作废的计划不能修改证书齐备状态")
  444. products = (
  445. db.query(PlPlanProduct)
  446. .filter(
  447. PlPlanProduct.plan_id == plan_id,
  448. PlPlanProduct.tenant_no == tenant_no,
  449. PlPlanProduct.del_flag == 0,
  450. )
  451. .all()
  452. )
  453. has_hazard = plan_has_hazard_products(db, tenant_no, products)
  454. if ready:
  455. if not has_hazard:
  456. raise HTTPException(status_code=400, detail="该计划不含易制毒/易制爆产品,无需确认证书齐备")
  457. plan.hazard_cert_ready = 1
  458. plan.hazard_cert_ready_by = user_id
  459. plan.hazard_cert_ready_time = datetime.now()
  460. else:
  461. clear_hazard_cert_ready(plan)
  462. plan.update_by = user_id
  463. db.commit()
  464. db.refresh(plan)
  465. return plan
  466. def update_plan_product_certs(
  467. db: Session,
  468. *,
  469. tenant_no: str,
  470. plan_id: str,
  471. items: list,
  472. user_id: str,
  473. ) -> list[PlPlanProduct]:
  474. plan = (
  475. db.query(PlPlan)
  476. .filter(
  477. PlPlan.id == plan_id,
  478. PlPlan.tenant_no == tenant_no,
  479. PlPlan.del_flag == 0,
  480. )
  481. .first()
  482. )
  483. if not plan:
  484. raise HTTPException(status_code=404, detail="计划不存在")
  485. if plan.archive_status == "archived":
  486. raise HTTPException(status_code=400, detail="已归档的计划不能修改")
  487. existing_rows = (
  488. db.query(PlPlanProduct)
  489. .filter(
  490. PlPlanProduct.plan_id == plan_id,
  491. PlPlanProduct.tenant_no == tenant_no,
  492. PlPlanProduct.del_flag == 0,
  493. )
  494. .all()
  495. )
  496. hazard_map = fetch_hazard_flags_map(
  497. db,
  498. tenant_no,
  499. [row.product_id for row in existing_rows if row.product_id],
  500. )
  501. updated: list[PlPlanProduct] = []
  502. for item in items:
  503. row = (
  504. db.query(PlPlanProduct)
  505. .filter(
  506. PlPlanProduct.id == item.id,
  507. PlPlanProduct.plan_id == plan_id,
  508. PlPlanProduct.tenant_no == tenant_no,
  509. PlPlanProduct.del_flag == 0,
  510. )
  511. .first()
  512. )
  513. if not row:
  514. raise HTTPException(status_code=404, detail=f"计划产品不存在: {item.id}")
  515. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  516. db, tenant_no, row.product_id, hazard_map=hazard_map
  517. )
  518. if not (is_toxic or is_explosive):
  519. raise HTTPException(status_code=400, detail=f"产品【{row.product_name}】无需上传危化品证书")
  520. row.purchase_cert_url = (item.purchase_cert_url or "").strip() or None
  521. row.transport_cert_url = (item.transport_cert_url or "").strip() or None
  522. row.legal_use_cert_url = (item.legal_use_cert_url or "").strip() or None
  523. row.update_by = user_id
  524. updated.append(row)
  525. maybe_auto_set_hazard_cert_ready(
  526. db,
  527. tenant_no=tenant_no,
  528. plan=plan,
  529. products=existing_rows,
  530. user_id=user_id,
  531. )
  532. plan.update_by = user_id
  533. db.commit()
  534. for row in updated:
  535. db.refresh(row)
  536. return updated
  537. def _generate_transport_no(db: Session) -> str:
  538. now = date.today()
  539. prefix = f"SXYS{now.strftime('%Y%m')}"
  540. last = (
  541. db.query(PlTransport)
  542. .filter(PlTransport.transport_no.like(f"{prefix}%"))
  543. .order_by(PlTransport.transport_no.desc())
  544. .first()
  545. )
  546. seq = 1
  547. if last and last.transport_no:
  548. try:
  549. seq = int(last.transport_no[-6:]) + 1
  550. except ValueError:
  551. seq = 1
  552. return f"{prefix}{seq:06d}"
  553. def _resolve_transport_context(
  554. db: Session,
  555. *,
  556. tenant_no: str,
  557. plan: PlPlan,
  558. transport_payload: PlanTransportCreateBlock,
  559. products: list[PlPlanProduct],
  560. ) -> tuple[
  561. PlVehicle,
  562. Optional[str],
  563. Optional[str],
  564. Optional[str],
  565. Optional[str],
  566. Optional[str],
  567. Decimal,
  568. Optional[Decimal],
  569. ]:
  570. vehicle = (
  571. db.query(PlVehicle)
  572. .filter(
  573. PlVehicle.id == transport_payload.vehicle_id,
  574. PlVehicle.tenant_no == tenant_no,
  575. PlVehicle.del_flag == 0,
  576. )
  577. .first()
  578. )
  579. if not vehicle:
  580. raise HTTPException(status_code=400, detail="车辆不存在")
  581. driver_id, driver_name, driver_phone = _resolve_driver(
  582. db, tenant_no, transport_payload.vehicle_id, transport_payload.driver_id
  583. )
  584. carrier_id = transport_payload.carrier_id or vehicle.carrier_id
  585. carrier_name = vehicle.carrier_name
  586. if carrier_id:
  587. carrier = (
  588. db.query(PlCarrier)
  589. .filter(PlCarrier.id == carrier_id, PlCarrier.del_flag == 0)
  590. .first()
  591. )
  592. if carrier:
  593. carrier_name = carrier.carrier_name
  594. freight_amount = _calc_freight_amount(
  595. transport_payload.freight_type,
  596. products,
  597. transport_payload.transport_qty,
  598. transport_payload.freight_price,
  599. transport_payload.freight_amount,
  600. )
  601. transport_qty = transport_payload.transport_qty
  602. if transport_qty is None and transport_payload.freight_type == "by_weight":
  603. transport_qty = sum_plan_product_actual_quantities(products)
  604. return (
  605. vehicle,
  606. driver_id,
  607. driver_name,
  608. driver_phone,
  609. carrier_id,
  610. carrier_name,
  611. freight_amount,
  612. transport_qty,
  613. )
  614. def _apply_payload_to_transport_row(
  615. transport: PlTransport,
  616. *,
  617. vehicle: PlVehicle,
  618. driver_id: Optional[str],
  619. driver_name: Optional[str],
  620. driver_phone: Optional[str],
  621. carrier_id: Optional[str],
  622. carrier_name: Optional[str],
  623. plan: PlPlan,
  624. transport_payload: PlanTransportCreateBlock,
  625. freight_amount: Decimal,
  626. transport_qty: Optional[Decimal],
  627. user_id: str,
  628. ) -> None:
  629. transport.vehicle_id = vehicle.id
  630. transport.license_plate = vehicle.license_plate
  631. transport.driver_id = driver_id
  632. transport.driver_name = driver_name
  633. transport.driver_phone = driver_phone
  634. transport.carrier_id = carrier_id
  635. transport.carrier_name = carrier_name
  636. transport.start_point = plan.pickup_address
  637. transport.end_point = plan.destination_address or plan.destination_name
  638. transport.distance_km = transport_payload.distance_km
  639. transport.transport_qty = transport_qty
  640. transport.freight_price = transport_payload.freight_price
  641. transport.freight_amount = freight_amount or 0
  642. transport.freight_type = transport_payload.freight_type
  643. if transport_payload.has_invoice is not None:
  644. transport.has_invoice = transport_payload.has_invoice
  645. transport.unit = "吨" if transport_payload.freight_type == "by_weight" else "趟"
  646. if transport_payload.remark is not None:
  647. transport.remark = transport_payload.remark
  648. transport.update_by = user_id
  649. def upsert_draft_transport_for_plan(
  650. db: Session,
  651. *,
  652. tenant_no: str,
  653. plan: PlPlan,
  654. transport_payload: PlanTransportCreateBlock,
  655. products: list[PlPlanProduct],
  656. user_id: str,
  657. dept_id: str,
  658. ) -> None:
  659. """写入/更新草稿运输单(pl_transport + pl_plan_transport),计划保持待安排。"""
  660. (
  661. vehicle,
  662. driver_id,
  663. driver_name,
  664. driver_phone,
  665. carrier_id,
  666. carrier_name,
  667. freight_amount,
  668. transport_qty,
  669. ) = _resolve_transport_context(
  670. db,
  671. tenant_no=tenant_no,
  672. plan=plan,
  673. transport_payload=transport_payload,
  674. products=products,
  675. )
  676. transport: Optional[PlTransport] = None
  677. if plan.transport_id:
  678. transport = (
  679. db.query(PlTransport)
  680. .filter(
  681. PlTransport.id == plan.transport_id,
  682. PlTransport.tenant_no == tenant_no,
  683. PlTransport.del_flag == 0,
  684. )
  685. .first()
  686. )
  687. if transport:
  688. _apply_payload_to_transport_row(
  689. transport,
  690. vehicle=vehicle,
  691. driver_id=driver_id,
  692. driver_name=driver_name,
  693. driver_phone=driver_phone,
  694. carrier_id=carrier_id,
  695. carrier_name=carrier_name,
  696. plan=plan,
  697. transport_payload=transport_payload,
  698. freight_amount=freight_amount,
  699. transport_qty=transport_qty,
  700. user_id=user_id,
  701. )
  702. if transport.transport_status == "draft":
  703. pass
  704. else:
  705. transport_no = _generate_transport_no(db)
  706. transport = PlTransport(
  707. id=generate_uuid(),
  708. tenant_no=tenant_no,
  709. transport_no=transport_no,
  710. transport_status="draft",
  711. approval_status="none",
  712. remark=transport_payload.remark,
  713. create_by=user_id,
  714. create_dept_id=dept_id,
  715. )
  716. db.add(transport)
  717. db.flush()
  718. db.add(
  719. PlPlanTransport(
  720. id=generate_uuid(),
  721. tenant_no=tenant_no,
  722. plan_id=plan.id,
  723. transport_id=transport.id,
  724. create_by=user_id,
  725. create_dept_id=dept_id,
  726. )
  727. )
  728. plan.transport_id = transport.id
  729. plan.transport_no = transport_no
  730. _apply_payload_to_transport_row(
  731. transport,
  732. vehicle=vehicle,
  733. driver_id=driver_id,
  734. driver_name=driver_name,
  735. driver_phone=driver_phone,
  736. carrier_id=carrier_id,
  737. carrier_name=carrier_name,
  738. plan=plan,
  739. transport_payload=transport_payload,
  740. freight_amount=freight_amount,
  741. transport_qty=transport_qty,
  742. user_id=user_id,
  743. )
  744. plan.vehicle_id = vehicle.id
  745. plan.license_plate = vehicle.license_plate
  746. plan.driver_id = driver_id
  747. plan.driver_name = driver_name
  748. _apply_vehicle_snapshot_to_plan_transport(
  749. db,
  750. tenant_no=tenant_no,
  751. plan=plan,
  752. transport=transport,
  753. vehicle=vehicle,
  754. driver_id=driver_id,
  755. )
  756. plan.freight_amount = freight_amount or 0
  757. if plan.transport_id:
  758. sync_draft_settlement_freight_for_transport(
  759. db,
  760. tenant_no=tenant_no,
  761. transport_id=plan.transport_id,
  762. freight_amount=freight_amount or Decimal("0"),
  763. user_id=user_id,
  764. )
  765. if plan.transport_status != "arranged":
  766. plan.transport_status = "pending"
  767. def clear_draft_transport_for_plan(
  768. db: Session,
  769. *,
  770. tenant_no: str,
  771. plan: PlPlan,
  772. user_id: str,
  773. ) -> None:
  774. """清除计划上的草稿运输单及车辆预选。"""
  775. transport: Optional[PlTransport] = None
  776. if plan.transport_id:
  777. transport = (
  778. db.query(PlTransport)
  779. .filter(
  780. PlTransport.id == plan.transport_id,
  781. PlTransport.tenant_no == tenant_no,
  782. PlTransport.del_flag == 0,
  783. )
  784. .first()
  785. )
  786. if transport and transport.transport_status == "draft":
  787. transport.del_flag = 1
  788. transport.update_by = user_id
  789. db.query(PlPlanTransport).filter(
  790. PlPlanTransport.plan_id == plan.id,
  791. PlPlanTransport.transport_id == transport.id,
  792. PlPlanTransport.tenant_no == tenant_no,
  793. PlPlanTransport.del_flag == 0,
  794. ).update({"del_flag": 1, "update_by": user_id})
  795. plan.transport_id = None
  796. plan.transport_no = None
  797. plan.vehicle_id = None
  798. plan.license_plate = None
  799. plan.driver_id = None
  800. plan.driver_name = None
  801. clear_resource_snapshot(plan=plan, transport=transport)
  802. plan.freight_amount = 0
  803. if plan.transport_status != "arranged":
  804. plan.transport_status = "pending"
  805. def sync_transport_prefill_for_plan(
  806. db: Session,
  807. *,
  808. tenant_no: str,
  809. plan: PlPlan,
  810. transport_payload: PlanTransportCreateBlock,
  811. products: list[PlPlanProduct],
  812. user_id: str,
  813. dept_id: str = "",
  814. ) -> None:
  815. """同步运输预选到草稿运输子表(pl_transport)。"""
  816. upsert_draft_transport_for_plan(
  817. db,
  818. tenant_no=tenant_no,
  819. plan=plan,
  820. transport_payload=transport_payload,
  821. products=products,
  822. user_id=user_id,
  823. dept_id=dept_id or user_id,
  824. )
  825. def apply_vehicle_prefill_to_plan(
  826. db: Session,
  827. *,
  828. tenant_no: str,
  829. plan: PlPlan,
  830. transport_payload: PlanTransportCreateBlock,
  831. products: list[PlPlanProduct],
  832. user_id: str = "",
  833. dept_id: str = "",
  834. ) -> None:
  835. """兼容旧调用:写入草稿运输子表。"""
  836. upsert_draft_transport_for_plan(
  837. db,
  838. tenant_no=tenant_no,
  839. plan=plan,
  840. transport_payload=transport_payload,
  841. products=products,
  842. user_id=user_id,
  843. dept_id=dept_id or user_id,
  844. )
  845. def create_transport_for_plan(
  846. db: Session,
  847. *,
  848. tenant_no: str,
  849. plan: PlPlan,
  850. products: list[PlPlanProduct],
  851. transport_payload: PlanTransportCreateBlock,
  852. user_id: str,
  853. dept_id: str,
  854. generate_transport_no,
  855. ) -> PlTransport:
  856. vehicle = (
  857. db.query(PlVehicle)
  858. .filter(
  859. PlVehicle.id == transport_payload.vehicle_id,
  860. PlVehicle.tenant_no == tenant_no,
  861. PlVehicle.del_flag == 0,
  862. )
  863. .first()
  864. )
  865. if not vehicle:
  866. raise HTTPException(status_code=400, detail="车辆不存在")
  867. validate_hazard_cert_ready_for_transport(db, tenant_no, plan, products)
  868. driver_id, driver_name, driver_phone = _resolve_driver(
  869. db, tenant_no, transport_payload.vehicle_id, transport_payload.driver_id
  870. )
  871. carrier_name = vehicle.carrier_name
  872. carrier_id = transport_payload.carrier_id or vehicle.carrier_id
  873. if carrier_id:
  874. carrier = (
  875. db.query(PlCarrier)
  876. .filter(PlCarrier.id == carrier_id, PlCarrier.del_flag == 0)
  877. .first()
  878. )
  879. if carrier:
  880. carrier_name = carrier.carrier_name
  881. freight_amount = _calc_freight_amount(
  882. transport_payload.freight_type,
  883. products,
  884. transport_payload.transport_qty,
  885. transport_payload.freight_price,
  886. transport_payload.freight_amount,
  887. )
  888. transport_qty = transport_payload.transport_qty
  889. if transport_qty is None and transport_payload.freight_type == "by_weight":
  890. transport_qty = sum_plan_product_actual_quantities(products)
  891. transport_no = generate_transport_no(db)
  892. transport = PlTransport(
  893. id=generate_uuid(),
  894. tenant_no=tenant_no,
  895. transport_no=transport_no,
  896. vehicle_id=vehicle.id,
  897. license_plate=vehicle.license_plate,
  898. driver_id=driver_id,
  899. driver_name=driver_name,
  900. driver_phone=driver_phone,
  901. carrier_id=carrier_id,
  902. carrier_name=carrier_name,
  903. start_point=plan.pickup_address,
  904. end_point=plan.destination_address or plan.destination_name,
  905. distance_km=transport_payload.distance_km,
  906. unit="吨" if transport_payload.freight_type == "by_weight" else "趟",
  907. transport_qty=transport_qty,
  908. freight_price=transport_payload.freight_price,
  909. freight_amount=freight_amount or 0,
  910. freight_type=transport_payload.freight_type,
  911. has_invoice=transport_payload.has_invoice if transport_payload.has_invoice is not None else 0,
  912. transport_status="draft",
  913. approval_status="none",
  914. remark=transport_payload.remark,
  915. create_by=user_id,
  916. create_dept_id=dept_id,
  917. )
  918. db.add(transport)
  919. db.add(
  920. PlPlanTransport(
  921. id=generate_uuid(),
  922. tenant_no=tenant_no,
  923. plan_id=plan.id,
  924. transport_id=transport.id,
  925. create_by=user_id,
  926. create_dept_id=dept_id,
  927. )
  928. )
  929. plan.transport_id = transport.id
  930. plan.transport_no = transport_no
  931. plan.vehicle_id = vehicle.id
  932. plan.license_plate = vehicle.license_plate
  933. plan.driver_id = driver_id
  934. plan.driver_name = driver_name
  935. _apply_vehicle_snapshot_to_plan_transport(
  936. db,
  937. tenant_no=tenant_no,
  938. plan=plan,
  939. transport=transport,
  940. vehicle=vehicle,
  941. driver_id=driver_id,
  942. )
  943. plan.transport_status = "arranged"
  944. plan.follow_status = "arranged"
  945. plan.freight_amount = freight_amount or 0
  946. return transport
  947. PLAN_SELECTABLE_CONTRACT_STATUSES = ("approved", "executing")
  948. def assert_contract_selectable_for_plan(
  949. db: Session,
  950. contract_id: str,
  951. tenant_no: str,
  952. ) -> None:
  953. from app.models.crm_models import CrmContract
  954. contract = (
  955. db.query(CrmContract)
  956. .filter(
  957. CrmContract.id == contract_id,
  958. CrmContract.tenant_no == tenant_no,
  959. CrmContract.del_flag == 0,
  960. )
  961. .first()
  962. )
  963. if not contract:
  964. raise HTTPException(status_code=404, detail="合同不存在")
  965. if contract.status not in PLAN_SELECTABLE_CONTRACT_STATUSES:
  966. raise HTTPException(status_code=422, detail="仅已审批或执行中的合同可关联运输计划")
  967. def validate_create_full(payload: PlanCreateFull) -> None:
  968. if not payload.contract_id:
  969. raise HTTPException(status_code=422, detail="请选择合同")
  970. if not payload.products:
  971. raise HTTPException(status_code=422, detail="请至少保留一条产品明细")
  972. transport = payload.transport
  973. if not transport or not transport.vehicle_id:
  974. return
  975. if payload.has_freight:
  976. if transport.freight_type == "by_weight":
  977. if not transport.freight_price or Decimal(str(transport.freight_price)) <= 0:
  978. raise HTTPException(status_code=422, detail="按重量计费时请填写运输单价")
  979. qty = transport.transport_qty or sum_product_actual_quantities(payload.products)
  980. if qty <= 0:
  981. raise HTTPException(status_code=422, detail="运输量必须大于0,请填写产品实际数量或运输量")
  982. elif transport.freight_type == "by_trip":
  983. if not transport.freight_amount or Decimal(str(transport.freight_amount)) <= 0:
  984. raise HTTPException(status_code=422, detail="按趟计费时请填写运费金额")
  985. def calc_plan_total_amount(products: list[PlanProductCreate]) -> Decimal:
  986. total = Decimal("0")
  987. for prod in products:
  988. if prod.tax_subtotal is not None:
  989. total += Decimal(str(prod.tax_subtotal))
  990. return total
  991. _LOCKED_SETTLEMENT_STATUSES = ("approving", "approved", "confirmed")
  992. def transport_has_locked_freight_settlement(
  993. db: Session, tenant_no: str, transport_id: Optional[str]
  994. ) -> bool:
  995. if not transport_id:
  996. return False
  997. return (
  998. db.query(PlFreightSettlementTransport.id)
  999. .join(
  1000. PlFreightSettlement,
  1001. PlFreightSettlement.id == PlFreightSettlementTransport.settlement_id,
  1002. )
  1003. .filter(
  1004. PlFreightSettlementTransport.transport_id == transport_id,
  1005. PlFreightSettlementTransport.tenant_no == tenant_no,
  1006. PlFreightSettlementTransport.del_flag == 0,
  1007. PlFreightSettlement.tenant_no == tenant_no,
  1008. PlFreightSettlement.del_flag == 0,
  1009. PlFreightSettlement.settlement_status.in_(_LOCKED_SETTLEMENT_STATUSES),
  1010. )
  1011. .first()
  1012. is not None
  1013. )
  1014. def sync_archive_qty_from_io_order(
  1015. db: Session,
  1016. *,
  1017. tenant_no: str,
  1018. plan: PlPlan,
  1019. items: list[PlanArchiveProductItem],
  1020. ) -> list[PlanArchiveProductItem]:
  1021. """若存在入库/出库单,用明细 actual_qty 覆盖归档提交中的实际数量(权威来源)。"""
  1022. from app.models.pl_models import PlInboundOrder, PlInboundOrderItem, PlOutboundOrder, PlOutboundOrderItem
  1023. if plan.plan_type not in ("inbound", "outbound"):
  1024. return items
  1025. header_m = PlInboundOrder if plan.plan_type == "inbound" else PlOutboundOrder
  1026. item_m = PlInboundOrderItem if plan.plan_type == "inbound" else PlOutboundOrderItem
  1027. header = (
  1028. db.query(header_m)
  1029. .filter(
  1030. header_m.tenant_no == tenant_no,
  1031. header_m.plan_id == plan.id,
  1032. header_m.status != "voided",
  1033. header_m.del_flag == 0,
  1034. )
  1035. .order_by(header_m.create_time.desc())
  1036. .first()
  1037. )
  1038. if not header:
  1039. return items
  1040. io_items = (
  1041. db.query(item_m)
  1042. .filter(item_m.order_id == header.id, item_m.del_flag == 0)
  1043. .all()
  1044. )
  1045. qty_by_plan_product = {
  1046. row.plan_product_id: Decimal(str(row.actual_qty))
  1047. for row in io_items
  1048. if row.actual_qty is not None
  1049. }
  1050. if not qty_by_plan_product:
  1051. return items
  1052. out: list[PlanArchiveProductItem] = []
  1053. for item in items:
  1054. qty = qty_by_plan_product.get(item.id)
  1055. if qty is not None:
  1056. out.append(PlanArchiveProductItem(id=item.id, actual_qty=qty))
  1057. else:
  1058. out.append(item)
  1059. return out
  1060. def apply_archive_product_quantities(
  1061. db: Session,
  1062. *,
  1063. tenant_no: str,
  1064. plan: PlPlan,
  1065. items: list[PlanArchiveProductItem],
  1066. user_id: str,
  1067. sync_from_io_order: bool = True,
  1068. ) -> None:
  1069. if sync_from_io_order:
  1070. items = sync_archive_qty_from_io_order(db, tenant_no=tenant_no, plan=plan, items=items)
  1071. product_map = {
  1072. row.id: row
  1073. for row in db.query(PlPlanProduct).filter(
  1074. PlPlanProduct.plan_id == plan.id,
  1075. PlPlanProduct.tenant_no == tenant_no,
  1076. PlPlanProduct.del_flag == 0,
  1077. ).all()
  1078. }
  1079. for item in items:
  1080. prod = product_map.get(item.id)
  1081. if not prod:
  1082. raise HTTPException(status_code=400, detail=f"产品明细不存在: {item.id}")
  1083. actual = Decimal(str(item.actual_qty))
  1084. prod.actual_qty = actual
  1085. price_in = prod.inbound_price or prod.tax_price
  1086. price_out = prod.outbound_price or prod.tax_price
  1087. if plan.plan_type == "inbound":
  1088. prod.inbound_qty = actual
  1089. if price_in is not None:
  1090. prod.inbound_amount = actual * Decimal(str(price_in))
  1091. elif plan.plan_type == "outbound":
  1092. prod.outbound_qty = actual
  1093. if price_out is not None:
  1094. prod.outbound_amount = actual * Decimal(str(price_out))
  1095. prod.update_by = user_id
  1096. brand_rows = []
  1097. if item.brand_qtys:
  1098. brand_rows = [
  1099. {
  1100. "brandId": bq.brand_id or "",
  1101. "brandName": bq.brand_name,
  1102. "qty": bq.qty,
  1103. }
  1104. for bq in item.brand_qtys
  1105. ]
  1106. try:
  1107. validate_brand_qty_rows(
  1108. brand_mode=prod.brand_mode,
  1109. required_brand_id=prod.brand_id,
  1110. actual_qty=actual,
  1111. rows=brand_rows,
  1112. )
  1113. except ValueError as exc:
  1114. raise HTTPException(status_code=400, detail=str(exc)) from exc
  1115. persist_plan_product_brand_qtys(
  1116. db,
  1117. tenant_no=tenant_no,
  1118. plan_id=plan.id,
  1119. plan_product_id=prod.id,
  1120. brand_mode=prod.brand_mode,
  1121. rows=brand_rows,
  1122. user_id=user_id,
  1123. dept_id=getattr(prod, "create_dept_id", "") or "",
  1124. )
  1125. def apply_archive_freight(
  1126. db: Session,
  1127. *,
  1128. tenant_no: str,
  1129. plan: PlPlan,
  1130. freight: PlanArchiveFreightBlock,
  1131. user_id: str,
  1132. ) -> None:
  1133. has_freight = int(freight.has_freight if freight.has_freight is not None else plan.has_freight or 0)
  1134. plan.has_freight = has_freight
  1135. plan.update_by = user_id
  1136. if has_freight != 1:
  1137. plan.freight_amount = Decimal("0")
  1138. if not plan.transport_id:
  1139. return
  1140. if transport_has_locked_freight_settlement(db, tenant_no, plan.transport_id):
  1141. raise HTTPException(status_code=400, detail="运输单已纳入运费结算,无法修改运费")
  1142. transport = (
  1143. db.query(PlTransport)
  1144. .filter(
  1145. PlTransport.id == plan.transport_id,
  1146. PlTransport.tenant_no == tenant_no,
  1147. PlTransport.del_flag == 0,
  1148. )
  1149. .first()
  1150. )
  1151. if not transport:
  1152. raise HTTPException(status_code=400, detail="关联运输单不存在")
  1153. transport.freight_amount = Decimal("0")
  1154. transport.freight_price = None
  1155. transport.transport_qty = None
  1156. transport.update_by = user_id
  1157. sync_draft_settlement_freight_for_transport(
  1158. db,
  1159. tenant_no=tenant_no,
  1160. transport_id=plan.transport_id,
  1161. freight_amount=Decimal("0"),
  1162. user_id=user_id,
  1163. )
  1164. return
  1165. if not plan.transport_id:
  1166. raise HTTPException(status_code=400, detail="计划有运输费用但未安排运输,请先安排运输")
  1167. if transport_has_locked_freight_settlement(db, tenant_no, plan.transport_id):
  1168. raise HTTPException(status_code=400, detail="运输单已纳入运费结算,无法修改运费")
  1169. transport = (
  1170. db.query(PlTransport)
  1171. .filter(
  1172. PlTransport.id == plan.transport_id,
  1173. PlTransport.tenant_no == tenant_no,
  1174. PlTransport.del_flag == 0,
  1175. )
  1176. .first()
  1177. )
  1178. if not transport:
  1179. raise HTTPException(status_code=400, detail="关联运输单不存在")
  1180. transport.distance_km = freight.distance_km
  1181. transport.freight_type = freight.freight_type or "by_weight"
  1182. transport.freight_price = freight.freight_price
  1183. amount = freight.freight_amount or Decimal("0")
  1184. transport.freight_amount = amount
  1185. freight_type = freight.freight_type or transport.freight_type or "by_weight"
  1186. plan_products = (
  1187. db.query(PlPlanProduct)
  1188. .filter(
  1189. PlPlanProduct.plan_id == plan.id,
  1190. PlPlanProduct.tenant_no == tenant_no,
  1191. PlPlanProduct.del_flag == 0,
  1192. )
  1193. .all()
  1194. )
  1195. if freight.transport_qty is not None:
  1196. transport.transport_qty = freight.transport_qty
  1197. elif freight_type == "by_weight":
  1198. transport.transport_qty = sum_plan_product_actual_quantities(plan_products)
  1199. if freight_type == "by_weight" and (transport.transport_qty or 0) <= 0:
  1200. raise HTTPException(status_code=400, detail="运输量必须大于0,请先填写产品实际数量")
  1201. if freight.has_invoice is not None:
  1202. transport.has_invoice = freight.has_invoice
  1203. transport.update_by = user_id
  1204. plan.freight_amount = amount
  1205. sync_draft_settlement_freight_for_transport(
  1206. db,
  1207. tenant_no=tenant_no,
  1208. transport_id=plan.transport_id,
  1209. freight_amount=amount,
  1210. user_id=user_id,
  1211. )
  1212. def record_plan_change(
  1213. db: Session,
  1214. *,
  1215. tenant_no: str,
  1216. plan_id: str,
  1217. change_type: str,
  1218. change_content: str,
  1219. user_id: str,
  1220. user_name: Optional[str],
  1221. dept_id: str,
  1222. ) -> None:
  1223. db.add(
  1224. PlPlanChange(
  1225. id=generate_uuid(),
  1226. tenant_no=tenant_no,
  1227. plan_id=plan_id,
  1228. change_type=change_type,
  1229. change_content=change_content,
  1230. change_user_id=user_id,
  1231. change_user_name=user_name,
  1232. create_by=user_id,
  1233. create_dept_id=dept_id,
  1234. )
  1235. )
  1236. def apply_plan_driver_feedback(
  1237. db: Session,
  1238. *,
  1239. tenant_no: str,
  1240. plan: PlPlan,
  1241. payload: PlanDriverFeedbackUpdateBody,
  1242. user_id: str,
  1243. ) -> PlTransport:
  1244. if plan.follow_status == "cancelled":
  1245. raise HTTPException(status_code=400, detail="已作废的计划不能编辑司机回传")
  1246. if not plan.transport_id:
  1247. raise HTTPException(status_code=400, detail="计划未安排运输,无法编辑司机回传")
  1248. transport = (
  1249. db.query(PlTransport)
  1250. .filter(
  1251. PlTransport.id == plan.transport_id,
  1252. PlTransport.tenant_no == tenant_no,
  1253. PlTransport.del_flag == 0,
  1254. )
  1255. .first()
  1256. )
  1257. if not transport:
  1258. raise HTTPException(status_code=404, detail="运输单不存在")
  1259. if payload.products is not None:
  1260. products_payload = [
  1261. {
  1262. "planProductId": item.plan_product_id,
  1263. "actualQty": item.actual_qty,
  1264. "brandQtys": [b.model_dump(by_alias=True) for b in (item.brand_qtys or [])],
  1265. }
  1266. for item in payload.products
  1267. ]
  1268. try:
  1269. persist_transport_product_feedback(
  1270. db,
  1271. tenant_no=tenant_no,
  1272. transport=transport,
  1273. plan_id=plan.id,
  1274. products=products_payload,
  1275. user_id=user_id,
  1276. enforce_brand=True,
  1277. )
  1278. except ValueError as exc:
  1279. raise HTTPException(status_code=400, detail=str(exc)) from exc
  1280. elif payload.feedback_qty is not None:
  1281. transport.feedback_qty = payload.feedback_qty
  1282. if payload.feedback_remark is not None:
  1283. transport.feedback_remark = payload.feedback_remark.strip() if payload.feedback_remark else None
  1284. if payload.feedback_images is not None:
  1285. transport.feedback_images = json.dumps([item for item in payload.feedback_images if item])
  1286. transport.feedback_time = payload.feedback_time or datetime.now()
  1287. transport.update_by = user_id
  1288. return transport
  1289. def apply_plan_site_feedback(
  1290. db: Session,
  1291. *,
  1292. tenant_no: str,
  1293. plan: PlPlan,
  1294. link_id: str,
  1295. payload: PlanSiteFeedbackUpdateBody,
  1296. user_id: str,
  1297. ) -> PlTransportSiteLink:
  1298. if plan.follow_status == "cancelled":
  1299. raise HTTPException(status_code=400, detail="已作废的计划不能编辑现场回传")
  1300. link = (
  1301. db.query(PlTransportSiteLink)
  1302. .filter(
  1303. PlTransportSiteLink.id == link_id,
  1304. PlTransportSiteLink.plan_id == plan.id,
  1305. PlTransportSiteLink.tenant_no == tenant_no,
  1306. PlTransportSiteLink.del_flag == 0,
  1307. )
  1308. .first()
  1309. )
  1310. if not link:
  1311. raise HTTPException(status_code=404, detail="现场链接不存在")
  1312. if payload.site_feedback_remark is not None:
  1313. link.site_feedback_remark = (
  1314. payload.site_feedback_remark.strip() if payload.site_feedback_remark else None
  1315. )
  1316. if payload.site_feedback_images is not None:
  1317. link.site_feedback_images = json.dumps([item for item in payload.site_feedback_images if item])
  1318. link.site_feedback_time = payload.site_feedback_time or datetime.now()
  1319. link.update_by = user_id
  1320. return link