pl_plan_service.py 39 KB

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