plan.py 62 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811
  1. """运输计划管理 - 计划 API"""
  2. import re
  3. from datetime import date
  4. from typing import Optional
  5. from fastapi import APIRouter, Body, Depends, HTTPException, Query, status
  6. from sqlalchemy import func, or_
  7. from sqlalchemy.orm import Session
  8. from app.core.config import settings
  9. from app.core.database import get_db
  10. from app.core.db_auth import DbUserContext, get_db_current_user
  11. from app.core.delete_guard import assert_row_deletable_by_creator, user_info_from_context
  12. from app.services.pl_data_scope import apply_pl_scope, assert_pl_row_in_scope
  13. from app.core.tenant_context import get_tenant_no
  14. from app.core.utils import generate_uuid
  15. from app.models.crm_models import CrmContract, CrmContractProduct, CrmProduct
  16. from app.models.db_models import DbInboundOutbound
  17. from app.models.pl_models import (
  18. PlCarrier,
  19. PlDriver,
  20. PlPlan,
  21. PlPlanProduct,
  22. PlPlanTransport,
  23. PlTransport,
  24. PlTransportDbLink,
  25. PlTransportSiteLink,
  26. PlVehicle,
  27. )
  28. from app.schemas.pl import PlanProductCreate
  29. from app.schemas.pl.plan import (
  30. CreateFromContractRequest,
  31. PlanArchiveBody,
  32. PlanArchiveBrandQtyItem,
  33. PlanContractGapListResponse,
  34. PlanContractGapRead,
  35. PlanCreate,
  36. PlanCreateFull,
  37. PlanDriverFeedbackUpdateBody,
  38. HazardCertReadyBody,
  39. PlanInboundSlipTemplateSave,
  40. PlanDeliverySlipTemplateSave,
  41. PlanSubpackSlipTemplateSave,
  42. PlanListQuery,
  43. PlanListResponse,
  44. PlanProductCertsUpdate,
  45. PlanProductRead,
  46. PlanRead,
  47. PlanSideContractsUpdateBody,
  48. PlanSiteFeedbackUpdateBody,
  49. PlanUpdate,
  50. PlanWithProducts,
  51. )
  52. from app.services.pl_plan_contract_gap import list_plan_contract_gaps, update_plan_side_contracts
  53. from app.services.pl_brand_archive import load_brand_qtys_by_plan_product_ids
  54. from app.services.pl_product_display import (
  55. load_crm_product_alias_maps,
  56. resolve_product_display_names,
  57. )
  58. from app.schemas.pl.transport import (
  59. PlanArrangeInfoRead,
  60. TransportInventoryLinkRead,
  61. TransportIoOrderBrief,
  62. TransportSiteLinkRead,
  63. )
  64. from app.services.pl_dibang_bridge_service import revoke_regeneratable_dibang_for_transport
  65. from app.services.pl_inventory_link_read import build_transport_inventory_link_read
  66. from app.services.pl_io_order_service import get_active_io_order_for_plan, void_io_orders_for_plan
  67. from app.services.pl_site_link_read import build_transport_site_link_read_from_row
  68. from app.services.pl_transport_site_service import revoke_site_links_for_transport
  69. from app.services.pl_inventory_service import apply_archive_inventory_for_plan
  70. from app.services.pl_plan_service import (
  71. apply_archive_freight,
  72. apply_archive_product_quantities,
  73. apply_plan_driver_feedback,
  74. apply_plan_site_feedback,
  75. apply_vehicle_prefill_to_plan,
  76. assert_contract_selectable_for_plan,
  77. build_plan_product,
  78. calc_plan_total_amount,
  79. clear_draft_transport_for_plan,
  80. clear_hazard_cert_ready,
  81. collect_hazard_product_ids,
  82. determine_plan_type,
  83. fetch_hazard_flags_map,
  84. load_plan_contracts_grouped,
  85. plan_has_hazard_product_exists,
  86. plan_has_incomplete_hazard_cert_exists,
  87. record_plan_change,
  88. replace_plan_contracts,
  89. resolve_hazard_flags_from_crm,
  90. set_hazard_cert_ready,
  91. sync_transport_prefill_for_plan,
  92. update_plan_product_certs,
  93. validate_create_full,
  94. validate_hazard_cert_ready_for_transport,
  95. validate_plan_party_contracts,
  96. )
  97. router = APIRouter(prefix="/plan", tags=["运输计划-计划管理"])
  98. _PLAN_NO_SEQ_WIDTH = 3
  99. def _resolve_list_product_name(
  100. product: PlPlanProduct,
  101. *,
  102. standard_by_id: dict[str, str],
  103. alias_options_by_id: dict[str, list[str]],
  104. ) -> str:
  105. """列表展示用:优先 CRM 标准名(详情仍返回库内 product_name,以便编辑反推别名)。"""
  106. display_name, _alias = resolve_product_display_names(
  107. saved_product_name=product.product_name,
  108. product_id=product.product_id,
  109. standard_by_id=standard_by_id,
  110. alias_options_by_id=alias_options_by_id,
  111. )
  112. return display_name or (product.product_name or "")
  113. def _resolve_create_date(value: Optional[date]) -> date:
  114. return value or date.today()
  115. def _generate_plan_no(db: Session) -> str:
  116. """生成计划编号 POYYYYMMDD###(当日 3 位序号,每日重置)"""
  117. today = date.today()
  118. prefix = f"PO{today.strftime('%Y%m%d')}"
  119. # uk_plan_no 对全表生效(含软删),取号时不能过滤 del_flag
  120. rows = (
  121. db.query(PlPlan.plan_no)
  122. .filter(PlPlan.plan_no.like(f"{prefix}%"))
  123. .all()
  124. )
  125. max_seq = 0
  126. for (plan_no,) in rows:
  127. suffix = (plan_no or "")[len(prefix) :]
  128. if suffix.isdigit():
  129. max_seq = max(max_seq, int(suffix))
  130. seq = max_seq + 1
  131. return f"{prefix}{seq:0{_PLAN_NO_SEQ_WIDTH}d}"
  132. _SUBPACK_SLIP_NO_SEQ_WIDTH = 3
  133. _SUBPACK_SLIP_NO_CANONICAL_PATTERN = re.compile(r"^NO:SXFZ(\d{8})-(\d+)$")
  134. _SUBPACK_SLIP_NO_BARE_PATTERN = re.compile(r"^SXFZ(\d{8})-(\d+)$")
  135. _SUBPACK_SLIP_NO_LEGACY_PATTERNS = (
  136. re.compile(r"^NO:SXFZ-(\d{4})-(\d{2})-(\d{2})-(\d+)$"),
  137. re.compile(r"^SXFZ-(\d{4})-(\d{2})-(\d{2})-(\d+)$"),
  138. )
  139. def _format_subpack_slip_no(day: str, seq: int) -> str:
  140. return f"NO:SXFZ{day}-{int(seq):0{_SUBPACK_SLIP_NO_SEQ_WIDTH}d}"
  141. def _normalize_subpack_slip_no(slip_no: str) -> Optional[str]:
  142. """将历史分装单号统一为 NO:SXFZYYYYMMDD-###"""
  143. raw = (slip_no or "").strip()
  144. if not raw:
  145. return None
  146. matched = _SUBPACK_SLIP_NO_CANONICAL_PATTERN.match(raw)
  147. if matched:
  148. day, seq = matched.groups()
  149. return _format_subpack_slip_no(day, int(seq))
  150. matched = _SUBPACK_SLIP_NO_BARE_PATTERN.match(raw)
  151. if matched:
  152. day, seq = matched.groups()
  153. return _format_subpack_slip_no(day, int(seq))
  154. for pattern in _SUBPACK_SLIP_NO_LEGACY_PATTERNS:
  155. matched = pattern.match(raw)
  156. if matched:
  157. year, month, day, seq = matched.groups()
  158. return _format_subpack_slip_no(f"{year}{month}{day}", int(seq))
  159. return None
  160. def _subpack_slip_no_seq(slip_no: str, day_prefix: str) -> int:
  161. normalized = _normalize_subpack_slip_no(slip_no)
  162. if not normalized or not normalized.startswith(day_prefix):
  163. return 0
  164. suffix = normalized[len(day_prefix) :]
  165. return int(suffix) if suffix.isdigit() else 0
  166. def _ensure_subpack_slip_no(db: Session, tenant_no: str, plan: PlPlan) -> str:
  167. """分配分装单号 NO:SXFZYYYYMMDD-###(按租户每日递增)"""
  168. existing = (plan.subpack_slip_no or "").strip()
  169. if existing:
  170. normalized = _normalize_subpack_slip_no(existing)
  171. if normalized:
  172. if normalized != existing:
  173. plan.subpack_slip_no = normalized
  174. return normalized
  175. today = date.today()
  176. prefix = f"NO:SXFZ{today.strftime('%Y%m%d')}-"
  177. rows = (
  178. db.query(PlPlan.subpack_slip_no)
  179. .filter(
  180. PlPlan.tenant_no == tenant_no,
  181. PlPlan.subpack_slip_no.isnot(None),
  182. PlPlan.subpack_slip_no != "",
  183. )
  184. .all()
  185. )
  186. max_seq = 0
  187. for (slip_no,) in rows:
  188. max_seq = max(max_seq, _subpack_slip_no_seq(slip_no or "", prefix))
  189. next_no = f"{prefix}{max_seq + 1:0{_SUBPACK_SLIP_NO_SEQ_WIDTH}d}"
  190. plan.subpack_slip_no = next_no
  191. return next_no
  192. def _determine_plan_type(supplier_name: Optional[str], destination_name: Optional[str]) -> str:
  193. """根据供应商和目的地自动判断单据类型"""
  194. return determine_plan_type(supplier_name, destination_name)
  195. def _get_plan_type_label(plan_type: str) -> str:
  196. labels = {
  197. "direct": "直销单",
  198. "inbound": "入库单",
  199. "outbound": "出库单",
  200. }
  201. return labels.get(plan_type, plan_type)
  202. def _generate_notify_message(plan: PlPlan, products: list) -> str:
  203. """生成通知信息"""
  204. product_names = "、".join([p.product_name for p in products[:3]])
  205. if len(products) > 3:
  206. product_names += "等"
  207. return f"""计划号:{plan.plan_no}
  208. 企业名称:{plan.customer_name or ''}
  209. 提货单位:{plan.destination_name or ''}
  210. 到货时间:{plan.contract_end_date or ''}
  211. 药品名称:{product_names}
  212. 到货吨位:{sum(float(p.inbound_estimate_qty or p.outbound_estimate_qty or 0) for p in products)}吨
  213. 备注:"""
  214. # =============================================================================
  215. # 计划列表
  216. # =============================================================================
  217. def _plan_product_name_exists(db: Session, tenant_no: str, keyword: str):
  218. """子查询:计划产品名称模糊匹配。"""
  219. return (
  220. db.query(PlPlanProduct.id)
  221. .filter(
  222. PlPlanProduct.plan_id == PlPlan.id,
  223. PlPlanProduct.tenant_no == tenant_no,
  224. PlPlanProduct.del_flag == 0,
  225. func.lower(PlPlanProduct.product_name).contains(keyword.lower()),
  226. )
  227. .exists()
  228. )
  229. def _plan_plate_match(keyword: str):
  230. """车牌号 / 挂车号模糊匹配。"""
  231. kw = keyword.lower()
  232. return or_(
  233. func.lower(PlPlan.license_plate).contains(kw),
  234. func.lower(PlPlan.trailer_no).contains(kw),
  235. )
  236. @router.get("/", response_model=PlanListResponse)
  237. def list_plans(
  238. q: Optional[str] = Query(
  239. default=None,
  240. description="模糊搜索(计划编号/供方名称/需方名称/产品名称/车牌号)",
  241. ),
  242. plan_no: Optional[str] = Query(default=None, description="计划编号"),
  243. plan_type: Optional[str] = Query(default=None, alias="planType", description="单据类型"),
  244. follow_status: Optional[str] = Query(default=None, alias="followStatus", description="跟进状态"),
  245. transport_status: Optional[str] = Query(default=None, alias="transportStatus", description="运输状态"),
  246. archive_status: Optional[str] = Query(default=None, alias="archiveStatus", description="归档状态"),
  247. customer_name: Optional[str] = Query(default=None, alias="customerName", description="客户名称"),
  248. product_name: Optional[str] = Query(default=None, alias="productName", description="产品名称"),
  249. license_plate: Optional[str] = Query(default=None, alias="licensePlate", description="车牌号"),
  250. plan_date_from: Optional[date] = Query(default=None, alias="planDateFrom", description="计划日期开始"),
  251. plan_date_to: Optional[date] = Query(default=None, alias="planDateTo", description="计划日期结束"),
  252. has_hazard_product: Optional[int] = Query(
  253. default=None,
  254. alias="hasHazardProduct",
  255. description="1=仅含易制毒/易制爆产品的计划",
  256. ),
  257. cert_upload_status: Optional[str] = Query(
  258. default=None,
  259. alias="certUploadStatus",
  260. description="incomplete=至少一张必需危化证书未上传",
  261. ),
  262. page: int = Query(default=1, ge=1),
  263. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  264. db: Session = Depends(get_db),
  265. user: DbUserContext = Depends(get_db_current_user),
  266. ) -> PlanListResponse:
  267. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  268. query = db.query(PlPlan).filter(
  269. PlPlan.tenant_no == tenant_no,
  270. PlPlan.del_flag == 0,
  271. )
  272. if q:
  273. q_kw = q.strip()
  274. if q_kw:
  275. q_lower = q_kw.lower()
  276. query = query.filter(
  277. or_(
  278. PlPlan.plan_no.contains(q_kw),
  279. func.lower(PlPlan.supplier_name).contains(q_lower),
  280. func.lower(PlPlan.customer_name).contains(q_lower),
  281. func.lower(PlPlan.destination_name).contains(q_lower),
  282. _plan_product_name_exists(db, tenant_no, q_kw),
  283. _plan_plate_match(q_kw),
  284. )
  285. )
  286. if plan_no:
  287. query = query.filter(PlPlan.plan_no.contains(plan_no))
  288. if plan_type:
  289. query = query.filter(PlPlan.plan_type == plan_type)
  290. if follow_status:
  291. query = query.filter(PlPlan.follow_status == follow_status)
  292. if transport_status:
  293. query = query.filter(PlPlan.transport_status == transport_status)
  294. if archive_status:
  295. query = query.filter(PlPlan.archive_status == archive_status)
  296. if customer_name:
  297. query = query.filter(func.lower(PlPlan.customer_name).contains(customer_name.lower()))
  298. if product_name:
  299. product_name_kw = product_name.strip()
  300. if product_name_kw:
  301. query = query.filter(_plan_product_name_exists(db, tenant_no, product_name_kw))
  302. if license_plate:
  303. plate_kw = license_plate.strip()
  304. if plate_kw:
  305. query = query.filter(_plan_plate_match(plate_kw))
  306. if plan_date_from:
  307. query = query.filter(PlPlan.plan_date >= plan_date_from)
  308. if plan_date_to:
  309. query = query.filter(PlPlan.plan_date <= plan_date_to)
  310. if has_hazard_product == 1:
  311. query = query.filter(plan_has_hazard_product_exists(tenant_no))
  312. if (cert_upload_status or "").strip().lower() == "incomplete":
  313. query = query.filter(plan_has_incomplete_hazard_cert_exists(tenant_no))
  314. query = apply_pl_scope(query, PlPlan, user, db, tenant_no)
  315. # 统计总数
  316. total = query.count()
  317. # 分页
  318. offset = (page - 1) * page_size
  319. plans = query.order_by(PlPlan.create_time.desc()).offset(offset).limit(page_size).all()
  320. plan_ids = [plan.id for plan in plans]
  321. products_by_plan: dict[str, list[PlPlanProduct]] = {}
  322. all_products: list[PlPlanProduct] = []
  323. if plan_ids:
  324. all_products = (
  325. db.query(PlPlanProduct)
  326. .filter(
  327. PlPlanProduct.plan_id.in_(plan_ids),
  328. PlPlanProduct.del_flag == 0,
  329. )
  330. .order_by(PlPlanProduct.order_num)
  331. .all()
  332. )
  333. for product in all_products:
  334. products_by_plan.setdefault(product.plan_id, []).append(product)
  335. product_ids = [product.product_id for product in all_products if product.product_id]
  336. hazard_map = fetch_hazard_flags_map(
  337. db,
  338. tenant_no,
  339. product_ids,
  340. )
  341. standard_by_id, alias_options_by_id = load_crm_product_alias_maps(
  342. db,
  343. tenant_no=tenant_no,
  344. product_ids=product_ids,
  345. )
  346. brand_qtys_by_pp = load_brand_qtys_by_plan_product_ids(
  347. db,
  348. tenant_no=tenant_no,
  349. plan_product_ids=[p.id for p in all_products],
  350. )
  351. contracts_by_plan = load_plan_contracts_grouped(db, tenant_no, plan_ids)
  352. result_list: list[PlanWithProducts] = []
  353. for plan in plans:
  354. enriched_products: list[PlanProductRead] = []
  355. for product in products_by_plan.get(plan.id, []):
  356. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  357. db,
  358. tenant_no,
  359. product.product_id,
  360. hazard_map=hazard_map,
  361. )
  362. item = PlanProductRead.model_validate(product)
  363. raw_brand_qtys = brand_qtys_by_pp.get(product.id) or None
  364. brand_qtys = (
  365. [PlanArchiveBrandQtyItem.model_validate(x) for x in raw_brand_qtys]
  366. if raw_brand_qtys
  367. else None
  368. )
  369. item = item.model_copy(
  370. update={
  371. "is_toxic": is_toxic,
  372. "is_explosive": is_explosive,
  373. "brand_qtys": brand_qtys,
  374. "product_name": _resolve_list_product_name(
  375. product,
  376. standard_by_id=standard_by_id,
  377. alias_options_by_id=alias_options_by_id,
  378. ),
  379. }
  380. )
  381. enriched_products.append(item)
  382. plan_item = PlanWithProducts.model_validate(plan)
  383. plan_item.products = enriched_products
  384. supplier_contracts, demander_contracts = contracts_by_plan.get(plan.id, ([], []))
  385. plan_item.supplier_contracts = supplier_contracts
  386. plan_item.demander_contracts = demander_contracts
  387. if not (plan_item.personnel_summary or "").strip():
  388. snapshot = plan_item.resource_snapshot
  389. if snapshot and snapshot.personnel_summary:
  390. plan_item.personnel_summary = snapshot.personnel_summary
  391. elif plan_item.driver_name:
  392. plan_item.personnel_summary = f"{plan_item.driver_name}(驾)"
  393. result_list.append(plan_item)
  394. return PlanListResponse(total=total, list=result_list)
  395. @router.get("/count-by-contract")
  396. def count_plans_by_contract(
  397. contract_ids: str = Query(..., alias="contractIds", description="合同ID,逗号分隔"),
  398. db: Session = Depends(get_db),
  399. user: DbUserContext = Depends(get_db_current_user),
  400. ) -> dict:
  401. from app.models.pl_models import PlPlanContract
  402. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  403. ids = [item.strip() for item in contract_ids.split(",") if item.strip()]
  404. if not ids:
  405. return {"counts": {}}
  406. # 旧单:主表 contract_id;新单:pl_plan_contract 分侧关联(按计划去重计数)
  407. legacy_rows = (
  408. db.query(PlPlan.contract_id, func.count(PlPlan.id))
  409. .filter(
  410. PlPlan.tenant_no == tenant_no,
  411. PlPlan.del_flag == 0,
  412. PlPlan.contract_id.in_(ids),
  413. )
  414. )
  415. legacy_rows = apply_pl_scope(legacy_rows, PlPlan, user, db, tenant_no).group_by(PlPlan.contract_id).all()
  416. counts: dict[str, int] = {contract_id: count for contract_id, count in legacy_rows}
  417. link_q = (
  418. db.query(PlPlanContract.contract_id, PlPlan.id)
  419. .join(PlPlan, PlPlan.id == PlPlanContract.plan_id)
  420. .filter(
  421. PlPlanContract.tenant_no == tenant_no,
  422. PlPlanContract.del_flag == 0,
  423. PlPlanContract.contract_id.in_(ids),
  424. PlPlan.tenant_no == tenant_no,
  425. PlPlan.del_flag == 0,
  426. )
  427. )
  428. link_q = apply_pl_scope(link_q, PlPlan, user, db, tenant_no)
  429. seen: set[tuple[str, str]] = set()
  430. for contract_id, plan_id in link_q.all():
  431. key = (contract_id, plan_id)
  432. if key in seen:
  433. continue
  434. seen.add(key)
  435. # 若旧主表已计过同一计划+合同,不再重复加(新单主表 contract_id 应为空)
  436. counts[contract_id] = counts.get(contract_id, 0) + 1
  437. return {"counts": counts}
  438. @router.get("/contract-gaps", response_model=PlanContractGapListResponse)
  439. def list_contract_gaps(
  440. page: int = Query(default=1, ge=1),
  441. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  442. plan_no: Optional[str] = Query(default=None, alias="planNo", description="计划编号"),
  443. gap_type: Optional[str] = Query(
  444. default=None,
  445. alias="gapType",
  446. description="缺口类型:supplier | demander | both",
  447. ),
  448. customer_keyword: Optional[str] = Query(
  449. default=None,
  450. alias="customerKeyword",
  451. description="供方或需方名称关键词",
  452. ),
  453. plan_date_from: Optional[date] = Query(default=None, alias="planDateFrom"),
  454. plan_date_to: Optional[date] = Query(default=None, alias="planDateTo"),
  455. q: Optional[str] = Query(
  456. default=None,
  457. description="模糊搜索(计划编号/供方名称/需方名称)",
  458. ),
  459. db: Session = Depends(get_db),
  460. user: DbUserContext = Depends(get_db_current_user),
  461. ) -> PlanContractGapListResponse:
  462. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  463. total, items = list_plan_contract_gaps(
  464. db,
  465. tenant_no=tenant_no,
  466. user=user,
  467. page=page,
  468. page_size=page_size,
  469. plan_no=plan_no,
  470. gap_type=gap_type,
  471. customer_keyword=customer_keyword,
  472. plan_date_from=plan_date_from,
  473. plan_date_to=plan_date_to,
  474. q=q,
  475. )
  476. return PlanContractGapListResponse(total=total, list=items)
  477. @router.put("/{id}/contracts/{side}", response_model=PlanContractGapRead)
  478. def put_plan_side_contracts(
  479. id: str,
  480. side: str,
  481. payload: PlanSideContractsUpdateBody,
  482. db: Session = Depends(get_db),
  483. user: DbUserContext = Depends(get_db_current_user),
  484. ) -> PlanContractGapRead:
  485. """单侧保存计划合同关联(合同补全)。"""
  486. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  487. plan = _get_plan(db, tenant_no, id, user)
  488. result = update_plan_side_contracts(
  489. db,
  490. tenant_no=tenant_no,
  491. plan=plan,
  492. side=side,
  493. contracts=payload.contracts,
  494. user_id=user.id,
  495. dept_id=user.dept_id,
  496. )
  497. plan.update_by = user.id
  498. db.commit()
  499. return result
  500. # =============================================================================
  501. # 创建计划
  502. # =============================================================================
  503. @router.post("/", response_model=PlanRead, status_code=status.HTTP_201_CREATED)
  504. def create_plan(
  505. payload: PlanCreate,
  506. db: Session = Depends(get_db),
  507. user: DbUserContext = Depends(get_db_current_user),
  508. ) -> PlanRead:
  509. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  510. # 生成计划编号
  511. plan_no = _generate_plan_no(db)
  512. # 单据类型由前端显式选择;未选则存空,不再自动推断为直销单
  513. plan_type = (payload.plan_type or "").strip()
  514. plan = PlPlan(
  515. id=generate_uuid(),
  516. tenant_no=tenant_no,
  517. plan_no=plan_no,
  518. create_date=_resolve_create_date(payload.create_date),
  519. plan_date=payload.plan_date,
  520. belongs_company=payload.belongs_company,
  521. plan_type=plan_type,
  522. follow_status="pending_arrange",
  523. transport_status=payload.transport_status or "pending",
  524. archive_status=payload.archive_status or "unarchived",
  525. complete_status=payload.complete_status or "no",
  526. contract_id=payload.contract_id,
  527. contract_no=payload.contract_no,
  528. supplier_id=payload.supplier_id,
  529. supplier_name=payload.supplier_name,
  530. destination_id=payload.destination_id,
  531. destination_name=payload.destination_name,
  532. customer_id=payload.customer_id,
  533. customer_name=payload.customer_name,
  534. contact_name=payload.contact_name,
  535. contact_phone=payload.contact_phone,
  536. party_a=payload.party_a,
  537. party_b=payload.party_b,
  538. contract_start_date=payload.contract_start_date,
  539. contract_end_date=payload.contract_end_date,
  540. delivery_method=payload.delivery_method,
  541. settlement_method=payload.settlement_method,
  542. has_freight=payload.has_freight,
  543. pickup_address=payload.pickup_address,
  544. pickup_lng=payload.pickup_lng,
  545. pickup_lat=payload.pickup_lat,
  546. pickup_time=payload.pickup_time,
  547. pickup_contact=payload.pickup_contact,
  548. pickup_notes=payload.pickup_notes,
  549. destination_address=payload.destination_address,
  550. destination_lng=payload.destination_lng,
  551. destination_lat=payload.destination_lat,
  552. delivery_time=payload.delivery_time,
  553. delivery_contact=payload.delivery_contact,
  554. destination_notes=payload.destination_notes,
  555. follow_user_id=payload.follow_user_id or user.id,
  556. follow_user_name=payload.follow_user_name or user.nick_name,
  557. remark=payload.remark,
  558. create_by=user.id,
  559. create_dept_id=user.dept_id,
  560. )
  561. db.add(plan)
  562. # 添加产品明细
  563. if payload.products:
  564. for idx, prod in enumerate(payload.products):
  565. pp = build_plan_product(
  566. tenant_no=tenant_no,
  567. plan_id=plan.id,
  568. plan_type=plan_type,
  569. prod=prod,
  570. order_num=idx,
  571. user_id=user.id,
  572. dept_id=user.dept_id,
  573. )
  574. db.add(pp)
  575. plan.total_amount = calc_plan_total_amount(payload.products or [])
  576. db.commit()
  577. db.refresh(plan)
  578. return plan
  579. @router.post("/create-full", response_model=PlanWithProducts, status_code=status.HTTP_201_CREATED)
  580. def create_plan_full(
  581. payload: PlanCreateFull,
  582. db: Session = Depends(get_db),
  583. user: DbUserContext = Depends(get_db_current_user),
  584. ) -> PlanWithProducts:
  585. """创建运输计划(完整表单:供方/需方 + 产品库产品 + 可选预选车辆,不自动安排运输)"""
  586. validate_create_full(payload)
  587. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  588. supplier_contracts, demander_contracts = validate_plan_party_contracts(
  589. db,
  590. tenant_no,
  591. supplier_id=payload.supplier_id,
  592. supplier_name=payload.supplier_name,
  593. customer_id=payload.customer_id,
  594. customer_name=payload.customer_name,
  595. supplier_contracts=payload.supplier_contracts,
  596. demander_contracts=payload.demander_contracts,
  597. require_products=payload.products,
  598. )
  599. plan_no = _generate_plan_no(db)
  600. # 单据类型由前端显式选择;未选则存空,不再自动推断为直销单
  601. plan_type = (payload.plan_type or "").strip()
  602. has_vehicle = bool(payload.transport and payload.transport.vehicle_id)
  603. demander_name = (payload.customer_name or "").strip() or None
  604. plan = PlPlan(
  605. id=generate_uuid(),
  606. tenant_no=tenant_no,
  607. plan_no=plan_no,
  608. create_date=_resolve_create_date(payload.create_date),
  609. plan_date=payload.plan_date,
  610. belongs_company=payload.belongs_company,
  611. plan_type=plan_type,
  612. follow_status="pending_arrange",
  613. transport_status="pending",
  614. archive_status="unarchived",
  615. complete_status="no",
  616. contract_id=None,
  617. contract_no=None,
  618. supplier_id=payload.supplier_id,
  619. supplier_name=payload.supplier_name,
  620. destination_id=payload.customer_id or payload.destination_id,
  621. destination_name=demander_name or payload.destination_name,
  622. customer_id=payload.customer_id,
  623. customer_name=payload.customer_name,
  624. contact_name=payload.contact_name,
  625. contact_phone=payload.contact_phone,
  626. party_a=payload.party_a,
  627. party_b=payload.party_b,
  628. contract_start_date=payload.contract_start_date,
  629. contract_end_date=payload.contract_end_date,
  630. delivery_method=payload.delivery_method,
  631. settlement_method=payload.settlement_method,
  632. has_freight=payload.has_freight,
  633. pickup_address=payload.pickup_address,
  634. pickup_lng=payload.pickup_lng,
  635. pickup_lat=payload.pickup_lat,
  636. pickup_time=payload.pickup_time,
  637. pickup_contact=payload.pickup_contact,
  638. pickup_notes=payload.pickup_notes,
  639. destination_address=payload.destination_address,
  640. destination_lng=payload.destination_lng,
  641. destination_lat=payload.destination_lat,
  642. delivery_time=payload.delivery_time,
  643. delivery_contact=payload.delivery_contact,
  644. destination_notes=payload.destination_notes,
  645. total_amount=calc_plan_total_amount(payload.products or []),
  646. follow_user_id=payload.follow_user_id or user.id,
  647. follow_user_name=payload.follow_user_name or user.nick_name,
  648. remark=payload.remark,
  649. create_by=user.id,
  650. create_dept_id=user.dept_id,
  651. )
  652. db.add(plan)
  653. db.flush()
  654. plan_products: list[PlPlanProduct] = []
  655. for idx, prod in enumerate(payload.products or []):
  656. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  657. db,
  658. tenant_no,
  659. prod.product_id,
  660. )
  661. prod_payload = prod.model_copy(update={"is_toxic": is_toxic, "is_explosive": is_explosive})
  662. pp = build_plan_product(
  663. tenant_no=tenant_no,
  664. plan_id=plan.id,
  665. plan_type=plan_type,
  666. prod=prod_payload,
  667. order_num=idx,
  668. user_id=user.id,
  669. dept_id=user.dept_id,
  670. )
  671. db.add(pp)
  672. plan_products.append(pp)
  673. replace_plan_contracts(
  674. db,
  675. tenant_no=tenant_no,
  676. plan_id=plan.id,
  677. supplier_contracts=supplier_contracts,
  678. demander_contracts=demander_contracts,
  679. user_id=user.id,
  680. dept_id=user.dept_id,
  681. )
  682. if has_vehicle and payload.transport:
  683. apply_vehicle_prefill_to_plan(
  684. db,
  685. tenant_no=tenant_no,
  686. plan=plan,
  687. transport_payload=payload.transport,
  688. products=plan_products,
  689. user_id=user.id,
  690. dept_id=user.dept_id,
  691. )
  692. db.commit()
  693. db.refresh(plan)
  694. result = PlanWithProducts.model_validate(plan)
  695. result.products = plan_products
  696. result.supplier_contracts = supplier_contracts
  697. result.demander_contracts = demander_contracts
  698. return result
  699. # =============================================================================
  700. # 从合同创建计划
  701. # =============================================================================
  702. @router.post("/create-from-contract", response_model=PlanRead, status_code=status.HTTP_201_CREATED)
  703. def create_from_contract(
  704. payload: CreateFromContractRequest,
  705. db: Session = Depends(get_db),
  706. user: DbUserContext = Depends(get_db_current_user),
  707. ) -> PlanRead:
  708. """从 CRM 合同发起计划"""
  709. from app.models.crm_models import CrmContract, CrmContractProduct
  710. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  711. # 查询合同信息
  712. contract = (
  713. db.query(CrmContract)
  714. .filter(CrmContract.id == payload.contract_id, CrmContract.del_flag == 0)
  715. .first()
  716. )
  717. if not contract:
  718. raise HTTPException(status_code=404, detail="合同不存在")
  719. assert_contract_selectable_for_plan(db, contract.id, tenant_no)
  720. # 生成计划编号
  721. plan_no = _generate_plan_no(db)
  722. # 自动判断单据类型
  723. plan_type = _determine_plan_type(contract.supplier_name, contract.customer_name)
  724. plan = PlPlan(
  725. id=generate_uuid(),
  726. tenant_no=tenant_no,
  727. plan_no=plan_no,
  728. create_date=_resolve_create_date(payload.create_date),
  729. plan_date=payload.plan_date,
  730. belongs_company=contract.belongs_company or "shanxia",
  731. plan_type=plan_type,
  732. follow_status="pending_arrange",
  733. transport_status="pending",
  734. archive_status="unarchived",
  735. complete_status="no",
  736. contract_id=contract.id,
  737. contract_no=contract.contract_no,
  738. supplier_id=contract.supplier_id,
  739. supplier_name=(contract.party_a or contract.supplier_name or "").strip() or None,
  740. destination_id=contract.customer_id,
  741. # 客户名称严格跟合同「客户名称」;目的地名称与客户保持一致(不再取需方可章名 party_b)
  742. destination_name=(contract.customer_name or "").strip() or None,
  743. customer_id=contract.customer_id,
  744. customer_name=(contract.customer_name or "").strip() or None,
  745. contact_name=contract.contact_name,
  746. contact_phone=contract.contact_phone,
  747. party_a=contract.party_a,
  748. party_b=contract.party_b,
  749. contract_start_date=contract.start_date,
  750. contract_end_date=contract.end_date,
  751. delivery_method=contract.delivery_method,
  752. settlement_method=contract.settlement_method,
  753. has_freight=1 if contract.settlement_method and "含运" in contract.settlement_method else 0,
  754. follow_user_id=payload.follow_user_id or user.id,
  755. follow_user_name=payload.follow_user_name or user.nick_name,
  756. create_by=user.id,
  757. create_dept_id=user.dept_id,
  758. )
  759. db.add(plan)
  760. # 查询合同产品明细
  761. contract_products = (
  762. db.query(CrmContractProduct)
  763. .filter(
  764. CrmContractProduct.contract_id == contract.id,
  765. CrmContractProduct.del_flag == 0,
  766. )
  767. .all()
  768. )
  769. # 添加产品明细
  770. for idx, cp in enumerate(contract_products):
  771. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  772. db,
  773. tenant_no,
  774. cp.product_id,
  775. )
  776. pp = PlPlanProduct(
  777. id=generate_uuid(),
  778. tenant_no=tenant_no,
  779. plan_id=plan.id,
  780. product_id=cp.product_id,
  781. product_no=cp.product_no,
  782. product_name=cp.product_name,
  783. brand_mode=cp.brand_mode,
  784. brand_id=cp.brand_id,
  785. brand_name=cp.brand_name,
  786. model=cp.model,
  787. unit=cp.unit or "吨",
  788. is_explosive=is_explosive,
  789. is_toxic=is_toxic,
  790. inbound_estimate_qty=cp.quantity,
  791. outbound_estimate_qty=cp.quantity,
  792. order_num=idx,
  793. create_by=user.id,
  794. create_dept_id=user.dept_id,
  795. )
  796. db.add(pp)
  797. db.commit()
  798. db.refresh(plan)
  799. return plan
  800. # =============================================================================
  801. # 获取计划详情
  802. # =============================================================================
  803. @router.get("/{id}", response_model=PlanWithProducts)
  804. def get_plan(
  805. id: str,
  806. db: Session = Depends(get_db),
  807. user: DbUserContext = Depends(get_db_current_user),
  808. ) -> PlanWithProducts:
  809. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  810. plan = _get_plan(db, tenant_no, id, user)
  811. products = (
  812. db.query(PlPlanProduct)
  813. .filter(
  814. PlPlanProduct.plan_id == id,
  815. PlPlanProduct.del_flag == 0,
  816. )
  817. .order_by(PlPlanProduct.order_num)
  818. .all()
  819. )
  820. hazard_map = fetch_hazard_flags_map(
  821. db,
  822. tenant_no,
  823. [product.product_id for product in products if product.product_id],
  824. )
  825. brand_qtys_by_pp = load_brand_qtys_by_plan_product_ids(
  826. db,
  827. tenant_no=tenant_no,
  828. plan_product_ids=[p.id for p in products],
  829. )
  830. enriched_products = []
  831. for product in products:
  832. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  833. db,
  834. tenant_no,
  835. product.product_id,
  836. hazard_map=hazard_map,
  837. )
  838. item = PlanProductRead.model_validate(product)
  839. raw_brand_qtys = brand_qtys_by_pp.get(product.id) or None
  840. brand_qtys = (
  841. [PlanArchiveBrandQtyItem.model_validate(x) for x in raw_brand_qtys]
  842. if raw_brand_qtys
  843. else None
  844. )
  845. item = item.model_copy(
  846. update={
  847. "is_toxic": is_toxic,
  848. "is_explosive": is_explosive,
  849. "brand_qtys": brand_qtys,
  850. }
  851. )
  852. enriched_products.append(item)
  853. result = PlanWithProducts.model_validate(plan)
  854. result.products = enriched_products
  855. supplier_contracts, demander_contracts = load_plan_contracts_grouped(
  856. db, tenant_no, [id]
  857. ).get(id, ([], []))
  858. result.supplier_contracts = supplier_contracts
  859. result.demander_contracts = demander_contracts
  860. return result
  861. # =============================================================================
  862. # 更新计划
  863. # =============================================================================
  864. @router.put("/{id}", response_model=PlanRead)
  865. def update_plan(
  866. id: str,
  867. payload: PlanUpdate,
  868. db: Session = Depends(get_db),
  869. user: DbUserContext = Depends(get_db_current_user),
  870. ) -> PlanRead:
  871. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  872. plan = _get_plan(db, tenant_no, id, user)
  873. if plan.follow_status == "cancelled":
  874. raise HTTPException(status_code=400, detail="已作废的计划不能修改")
  875. # 更新主表字段(跟进状态仅由业务动作接口维护,忽略客户端写入)
  876. update_data = payload.model_dump(
  877. exclude_unset=True,
  878. exclude={"products", "transport", "follow_status", "supplier_contracts", "demander_contracts"},
  879. )
  880. for key, value in update_data.items():
  881. setattr(plan, key, value)
  882. # 新模型:单一合同字段不再作为写入源
  883. if "supplier_contracts" in payload.model_fields_set or "demander_contracts" in payload.model_fields_set:
  884. plan.contract_id = None
  885. plan.contract_no = None
  886. if payload.customer_id is not None or payload.customer_name is not None:
  887. plan.destination_id = plan.customer_id
  888. plan.destination_name = plan.customer_name
  889. supplier_id = plan.supplier_id
  890. supplier_name = plan.supplier_name
  891. customer_id = plan.customer_id
  892. customer_name = plan.customer_name
  893. supplier_contracts_in = (
  894. payload.supplier_contracts
  895. if "supplier_contracts" in payload.model_fields_set
  896. else load_plan_contracts_grouped(db, tenant_no, [id]).get(id, ([], []))[0]
  897. )
  898. demander_contracts_in = (
  899. payload.demander_contracts
  900. if "demander_contracts" in payload.model_fields_set
  901. else load_plan_contracts_grouped(db, tenant_no, [id]).get(id, ([], []))[1]
  902. )
  903. # 编辑保存若带了产品或任一侧合同字段,按新规则完整校验供方/需方
  904. if (
  905. payload.products is not None
  906. or "supplier_contracts" in payload.model_fields_set
  907. or "demander_contracts" in payload.model_fields_set
  908. or payload.supplier_id is not None
  909. or payload.customer_id is not None
  910. ):
  911. supplier_contracts, demander_contracts = validate_plan_party_contracts(
  912. db,
  913. tenant_no,
  914. supplier_id=supplier_id,
  915. supplier_name=supplier_name,
  916. customer_id=customer_id,
  917. customer_name=customer_name,
  918. supplier_contracts=supplier_contracts_in,
  919. demander_contracts=demander_contracts_in,
  920. require_products=payload.products if payload.products is not None else None,
  921. )
  922. replace_plan_contracts(
  923. db,
  924. tenant_no=tenant_no,
  925. plan_id=id,
  926. supplier_contracts=supplier_contracts,
  927. demander_contracts=demander_contracts,
  928. user_id=user.id,
  929. dept_id=user.dept_id,
  930. )
  931. else:
  932. supplier_contracts, demander_contracts = load_plan_contracts_grouped(db, tenant_no, [id]).get(
  933. id, ([], [])
  934. )
  935. plan_type = payload.plan_type or plan.plan_type
  936. # 更新产品明细
  937. if payload.products is not None:
  938. existing_products = (
  939. db.query(PlPlanProduct)
  940. .filter(
  941. PlPlanProduct.plan_id == id,
  942. PlPlanProduct.del_flag == 0,
  943. )
  944. .all()
  945. )
  946. old_hazard_product_ids = collect_hazard_product_ids(db, tenant_no, existing_products)
  947. cert_by_product_id = {
  948. row.product_id: (
  949. row.purchase_cert_url,
  950. row.transport_cert_url,
  951. row.legal_use_cert_url,
  952. )
  953. for row in existing_products
  954. }
  955. db.query(PlPlanProduct).filter(
  956. PlPlanProduct.plan_id == id,
  957. PlPlanProduct.del_flag == 0,
  958. ).update({"del_flag": 1})
  959. plan_products: list[PlPlanProduct] = []
  960. for idx, prod in enumerate(payload.products):
  961. is_toxic, is_explosive = resolve_hazard_flags_from_crm(
  962. db,
  963. tenant_no,
  964. prod.product_id,
  965. )
  966. purchase_cert = prod.purchase_cert_url
  967. transport_cert = prod.transport_cert_url
  968. legal_use_cert = prod.legal_use_cert_url
  969. old_certs = cert_by_product_id.get(prod.product_id, (None, None, None))
  970. old_purchase, old_transport, old_legal_use = old_certs
  971. purchase_cert = purchase_cert or old_purchase
  972. transport_cert = transport_cert or old_transport
  973. legal_use_cert = legal_use_cert or old_legal_use
  974. prod_payload = prod.model_copy(
  975. update={
  976. "is_toxic": is_toxic,
  977. "is_explosive": is_explosive,
  978. "purchase_cert_url": purchase_cert,
  979. "transport_cert_url": transport_cert,
  980. "legal_use_cert_url": legal_use_cert,
  981. }
  982. )
  983. pp = build_plan_product(
  984. tenant_no=tenant_no,
  985. plan_id=id,
  986. plan_type=plan_type,
  987. prod=prod_payload,
  988. order_num=idx,
  989. user_id=user.id,
  990. dept_id=user.dept_id,
  991. )
  992. db.add(pp)
  993. plan_products.append(pp)
  994. new_hazard_product_ids = collect_hazard_product_ids(db, tenant_no, payload.products)
  995. if old_hazard_product_ids != new_hazard_product_ids:
  996. clear_hazard_cert_ready(plan)
  997. plan.total_amount = calc_plan_total_amount(payload.products)
  998. else:
  999. plan_products = (
  1000. db.query(PlPlanProduct)
  1001. .filter(
  1002. PlPlanProduct.plan_id == id,
  1003. PlPlanProduct.del_flag == 0,
  1004. )
  1005. .all()
  1006. )
  1007. # 同步运输预选 / 关联运输单运费
  1008. if payload.transport is not None:
  1009. if payload.transport.vehicle_id:
  1010. sync_transport_prefill_for_plan(
  1011. db,
  1012. tenant_no=tenant_no,
  1013. plan=plan,
  1014. transport_payload=payload.transport,
  1015. products=plan_products,
  1016. user_id=user.id,
  1017. dept_id=user.dept_id,
  1018. )
  1019. else:
  1020. clear_draft_transport_for_plan(
  1021. db,
  1022. tenant_no=tenant_no,
  1023. plan=plan,
  1024. user_id=user.id,
  1025. )
  1026. plan.update_by = user.id
  1027. db.commit()
  1028. db.refresh(plan)
  1029. result = PlanRead.model_validate(plan)
  1030. result.supplier_contracts = supplier_contracts
  1031. result.demander_contracts = demander_contracts
  1032. return result
  1033. @router.patch("/{id}/product-certs", response_model=PlanWithProducts)
  1034. def patch_plan_product_certs(
  1035. id: str,
  1036. payload: PlanProductCertsUpdate,
  1037. db: Session = Depends(get_db),
  1038. user: DbUserContext = Depends(get_db_current_user),
  1039. ) -> PlanWithProducts:
  1040. """更新计划危化品产品证书(购买证/运输证/合法使用证明,不触发安排运输)"""
  1041. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1042. _get_plan(db, tenant_no, id, user)
  1043. update_plan_product_certs(
  1044. db,
  1045. tenant_no=tenant_no,
  1046. plan_id=id,
  1047. items=payload.products,
  1048. user_id=user.id,
  1049. )
  1050. plan = _get_plan(db, tenant_no, id, user)
  1051. products = (
  1052. db.query(PlPlanProduct)
  1053. .filter(
  1054. PlPlanProduct.plan_id == id,
  1055. PlPlanProduct.del_flag == 0,
  1056. )
  1057. .order_by(PlPlanProduct.order_num)
  1058. .all()
  1059. )
  1060. result = PlanWithProducts.model_validate(plan)
  1061. result.products = products
  1062. return result
  1063. @router.patch("/{id}/hazard-cert-ready", response_model=PlanWithProducts)
  1064. def patch_plan_hazard_cert_ready(
  1065. id: str,
  1066. payload: HazardCertReadyBody,
  1067. db: Session = Depends(get_db),
  1068. user: DbUserContext = Depends(get_db_current_user),
  1069. ) -> PlanWithProducts:
  1070. """标记或取消危化品证书齐备(人工确认)"""
  1071. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1072. _get_plan(db, tenant_no, id, user)
  1073. set_hazard_cert_ready(
  1074. db,
  1075. tenant_no=tenant_no,
  1076. plan_id=id,
  1077. ready=payload.ready,
  1078. user_id=user.id,
  1079. )
  1080. plan = _get_plan(db, tenant_no, id, user)
  1081. products = (
  1082. db.query(PlPlanProduct)
  1083. .filter(
  1084. PlPlanProduct.plan_id == id,
  1085. PlPlanProduct.del_flag == 0,
  1086. )
  1087. .order_by(PlPlanProduct.order_num)
  1088. .all()
  1089. )
  1090. result = PlanWithProducts.model_validate(plan)
  1091. result.products = products
  1092. return result
  1093. def _build_driver_url(token: str) -> str:
  1094. origin = (settings.PUBLIC_WEB_ORIGIN or "").rstrip("/")
  1095. return f"{origin}/#/public/pl/transport/{token}"
  1096. @router.get("/{id}/arrange-info", response_model=PlanArrangeInfoRead)
  1097. def get_plan_arrange_info(
  1098. id: str,
  1099. db: Session = Depends(get_db),
  1100. user: DbUserContext = Depends(get_db_current_user),
  1101. ) -> PlanArrangeInfoRead:
  1102. """获取计划已安排运输后的司机链接与地磅出入库关联(供查看弹窗复制简述/二维码)。"""
  1103. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1104. plan = _get_plan(db, tenant_no, id, user)
  1105. empty = PlanArrangeInfoRead(driver_url=None, license_plate=None, site_records=[], inventory_records=[])
  1106. if plan.follow_status == "cancelled" or plan.transport_status != "arranged" or not plan.transport_id:
  1107. return empty
  1108. transport = (
  1109. db.query(PlTransport)
  1110. .filter(
  1111. PlTransport.id == plan.transport_id,
  1112. PlTransport.tenant_no == tenant_no,
  1113. PlTransport.del_flag == 0,
  1114. )
  1115. .first()
  1116. )
  1117. if not transport or transport.transport_status == "cancelled":
  1118. return empty
  1119. token = (transport.driver_access_token or "").strip()
  1120. driver_url = _build_driver_url(token) if token else None
  1121. site_rows = (
  1122. db.query(PlTransportSiteLink)
  1123. .filter(
  1124. PlTransportSiteLink.tenant_no == tenant_no,
  1125. PlTransportSiteLink.plan_id == id,
  1126. PlTransportSiteLink.transport_id == transport.id,
  1127. PlTransportSiteLink.del_flag == 0,
  1128. )
  1129. .order_by(PlTransportSiteLink.create_time.asc())
  1130. .all()
  1131. )
  1132. product_name_by_id = {
  1133. item.id: item.product_name or ""
  1134. for item in db.query(PlPlanProduct)
  1135. .filter(
  1136. PlPlanProduct.plan_id == id,
  1137. PlPlanProduct.del_flag == 0,
  1138. )
  1139. .all()
  1140. }
  1141. site_records: list[TransportSiteLinkRead] = [
  1142. build_transport_site_link_read_from_row(
  1143. row,
  1144. product_name=product_name_by_id.get(row.plan_product_id, row.product or ""),
  1145. )
  1146. for row in site_rows
  1147. ]
  1148. links = (
  1149. db.query(PlTransportDbLink)
  1150. .filter(
  1151. PlTransportDbLink.tenant_no == tenant_no,
  1152. PlTransportDbLink.plan_id == id,
  1153. PlTransportDbLink.transport_id == transport.id,
  1154. PlTransportDbLink.del_flag == 0,
  1155. )
  1156. .all()
  1157. )
  1158. inventory_records: list[TransportInventoryLinkRead] = []
  1159. for link in links:
  1160. product = (
  1161. db.query(PlPlanProduct)
  1162. .filter(
  1163. PlPlanProduct.id == link.plan_product_id,
  1164. PlPlanProduct.del_flag == 0,
  1165. )
  1166. .first()
  1167. )
  1168. inventory = (
  1169. db.query(DbInboundOutbound)
  1170. .filter(
  1171. DbInboundOutbound.id == link.db_inventory_id,
  1172. DbInboundOutbound.tenant_no == tenant_no,
  1173. DbInboundOutbound.del_flag == 0,
  1174. )
  1175. .first()
  1176. )
  1177. inventory_records.append(
  1178. build_transport_inventory_link_read(
  1179. db,
  1180. plan_product_id=link.plan_product_id,
  1181. product_name=(product.product_name if product else "") or "",
  1182. db_purchase_plan_id=link.db_purchase_plan_id,
  1183. db_inventory_id=link.db_inventory_id,
  1184. batch_no=(inventory.batch_no if inventory else "") or "",
  1185. plan_no=plan.plan_no or "",
  1186. )
  1187. )
  1188. io_order_brief = None
  1189. active_io = get_active_io_order_for_plan(db, tenant_no, plan)
  1190. if active_io:
  1191. kind, header = active_io
  1192. from app.services.pl_io_order_service import build_io_order_site_url
  1193. token = (header.site_access_token or "").strip()
  1194. io_order_brief = TransportIoOrderBrief(
  1195. kind=kind,
  1196. order_id=header.id,
  1197. order_no=header.order_no,
  1198. site_access_token=token or None,
  1199. site_url=build_io_order_site_url(kind, token) if token else None,
  1200. status=header.status,
  1201. )
  1202. if not site_records and token and header.status != "voided":
  1203. site_records = [
  1204. TransportSiteLinkRead(
  1205. plan_product_id="",
  1206. product_name=header.order_no,
  1207. site_link_id=header.id,
  1208. plan_no=plan.plan_no or "",
  1209. business_type="入库" if kind == "inbound" else "出库",
  1210. site_access_token=token,
  1211. site_url=build_io_order_site_url(kind, token),
  1212. )
  1213. ]
  1214. return PlanArrangeInfoRead(
  1215. driver_url=driver_url,
  1216. license_plate=transport.license_plate or plan.license_plate,
  1217. site_records=site_records,
  1218. inventory_records=inventory_records,
  1219. io_order=io_order_brief,
  1220. )
  1221. # =============================================================================
  1222. # 跟进状态:等通知 / 取消等通知
  1223. # =============================================================================
  1224. @router.post("/{id}/wait-notice", response_model=PlanRead)
  1225. def mark_plan_wait_notice(
  1226. id: str,
  1227. db: Session = Depends(get_db),
  1228. user: DbUserContext = Depends(get_db_current_user),
  1229. ) -> PlanRead:
  1230. """将跟进状态从「待安排」设为「等通知」。"""
  1231. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1232. plan = _get_plan(db, tenant_no, id, user)
  1233. if plan.follow_status == "cancelled":
  1234. raise HTTPException(status_code=400, detail="已取消的计划不能标记等通知")
  1235. if plan.archive_status == "archived":
  1236. raise HTTPException(status_code=400, detail="已归档的计划不能标记等通知")
  1237. if plan.follow_status != "pending_arrange":
  1238. raise HTTPException(status_code=400, detail="仅待安排状态可标记为等通知")
  1239. plan.follow_status = "wait_notice"
  1240. plan.update_by = user.id
  1241. db.commit()
  1242. db.refresh(plan)
  1243. return plan
  1244. @router.post("/{id}/cancel-wait-notice", response_model=PlanRead)
  1245. def cancel_plan_wait_notice(
  1246. id: str,
  1247. db: Session = Depends(get_db),
  1248. user: DbUserContext = Depends(get_db_current_user),
  1249. ) -> PlanRead:
  1250. """将跟进状态从「等通知」改回「待安排」。"""
  1251. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1252. plan = _get_plan(db, tenant_no, id, user)
  1253. if plan.follow_status != "wait_notice":
  1254. raise HTTPException(status_code=400, detail="仅等通知状态可取消等通知")
  1255. if plan.archive_status == "archived":
  1256. raise HTTPException(status_code=400, detail="已归档的计划不能取消等通知")
  1257. plan.follow_status = "pending_arrange"
  1258. plan.update_by = user.id
  1259. db.commit()
  1260. db.refresh(plan)
  1261. return plan
  1262. # =============================================================================
  1263. # 取消计划
  1264. # =============================================================================
  1265. @router.post("/{id}/cancel", response_model=PlanRead)
  1266. def cancel_plan(
  1267. id: str,
  1268. db: Session = Depends(get_db),
  1269. user: DbUserContext = Depends(get_db_current_user),
  1270. ) -> PlanRead:
  1271. """作废运输计划:取消跟进状态、作废关联地磅出入库单、取消运输单。"""
  1272. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1273. plan = _get_plan(db, tenant_no, id, user)
  1274. if plan.follow_status == "cancelled":
  1275. raise HTTPException(status_code=400, detail="计划已作废")
  1276. if plan.archive_status == "archived":
  1277. raise HTTPException(status_code=400, detail="已归档的计划不能作废")
  1278. if plan.transport_id:
  1279. transport = (
  1280. db.query(PlTransport)
  1281. .filter(
  1282. PlTransport.id == plan.transport_id,
  1283. PlTransport.tenant_no == tenant_no,
  1284. PlTransport.del_flag == 0,
  1285. )
  1286. .first()
  1287. )
  1288. if transport:
  1289. try:
  1290. revoke_regeneratable_dibang_for_transport(
  1291. db,
  1292. tenant_no=tenant_no,
  1293. transport_id=transport.id,
  1294. user_id=user.id,
  1295. )
  1296. except ValueError as exc:
  1297. raise HTTPException(status_code=400, detail=str(exc)) from exc
  1298. revoke_site_links_for_transport(
  1299. db,
  1300. tenant_no=tenant_no,
  1301. transport_id=transport.id,
  1302. user_id=user.id,
  1303. )
  1304. transport.transport_status = "cancelled"
  1305. transport.update_by = user.id
  1306. void_io_orders_for_plan(
  1307. db, tenant_no=tenant_no, plan_id=plan.id, user_id=user.id
  1308. )
  1309. plan.follow_status = "cancelled"
  1310. plan.transport_status = "pending"
  1311. plan.update_by = user.id
  1312. db.commit()
  1313. db.refresh(plan)
  1314. return plan
  1315. # =============================================================================
  1316. # 归档计划
  1317. # =============================================================================
  1318. @router.post("/{id}/archive", response_model=PlanWithProducts)
  1319. def archive_plan(
  1320. id: str,
  1321. payload: Optional[PlanArchiveBody] = Body(default=None),
  1322. db: Session = Depends(get_db),
  1323. user: DbUserContext = Depends(get_db_current_user),
  1324. ) -> PlanWithProducts:
  1325. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1326. plan = _get_plan(db, tenant_no, id, user)
  1327. if plan.follow_status == "cancelled":
  1328. raise HTTPException(status_code=400, detail="已作废的计划不能归档")
  1329. already_archived = plan.archive_status == "archived"
  1330. if not already_archived:
  1331. products = (
  1332. db.query(PlPlanProduct)
  1333. .filter(
  1334. PlPlanProduct.plan_id == plan.id,
  1335. PlPlanProduct.tenant_no == tenant_no,
  1336. PlPlanProduct.del_flag == 0,
  1337. )
  1338. .order_by(PlPlanProduct.order_num)
  1339. .all()
  1340. )
  1341. validate_hazard_cert_ready_for_transport(db, tenant_no, plan, products)
  1342. if payload is None:
  1343. if already_archived:
  1344. raise HTTPException(status_code=400, detail="计划已归档,请提交归档表单以调整内容")
  1345. plan.archive_status = "archived"
  1346. plan.complete_status = "yes"
  1347. plan.follow_status = "completed"
  1348. plan.update_by = user.id
  1349. db.commit()
  1350. return get_plan(id, db, user)
  1351. apply_archive_product_quantities(
  1352. db, tenant_no=tenant_no, plan=plan, items=payload.products, user_id=user.id
  1353. )
  1354. apply_archive_inventory_for_plan(
  1355. db,
  1356. tenant_no=tenant_no,
  1357. plan=plan,
  1358. user_id=user.id,
  1359. dept_id=user.dept_id or "",
  1360. )
  1361. if payload.freight is not None:
  1362. apply_archive_freight(
  1363. db, tenant_no=tenant_no, plan=plan, freight=payload.freight, user_id=user.id
  1364. )
  1365. elif int(plan.has_freight or 0) == 1 and not already_archived:
  1366. if not plan.transport_id:
  1367. raise HTTPException(status_code=400, detail="计划有运输费用但未安排运输,请先安排运输")
  1368. if not already_archived:
  1369. plan.archive_status = "archived"
  1370. plan.complete_status = "yes"
  1371. plan.follow_status = "completed"
  1372. plan.update_by = user.id
  1373. record_plan_change(
  1374. db,
  1375. tenant_no=tenant_no,
  1376. plan_id=plan.id,
  1377. change_type="archive_adjust" if already_archived else "archive",
  1378. change_content="调整归档内容" if already_archived else "运输计划归档",
  1379. user_id=user.id,
  1380. user_name=user.name or None,
  1381. dept_id=user.dept_id,
  1382. )
  1383. db.commit()
  1384. return get_plan(id, db, user)
  1385. @router.patch("/{id}/driver-feedback", response_model=PlanWithProducts)
  1386. def update_plan_driver_feedback(
  1387. id: str,
  1388. payload: PlanDriverFeedbackUpdateBody,
  1389. db: Session = Depends(get_db),
  1390. user: DbUserContext = Depends(get_db_current_user),
  1391. ) -> PlanWithProducts:
  1392. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1393. plan = _get_plan(db, tenant_no, id, user)
  1394. apply_plan_driver_feedback(
  1395. db,
  1396. tenant_no=tenant_no,
  1397. plan=plan,
  1398. payload=payload,
  1399. user_id=user.id,
  1400. )
  1401. record_plan_change(
  1402. db,
  1403. tenant_no=tenant_no,
  1404. plan_id=plan.id,
  1405. change_type="feedback_adjust",
  1406. change_content="归档人员更新司机回传信息",
  1407. user_id=user.id,
  1408. user_name=user.name or None,
  1409. dept_id=user.dept_id,
  1410. )
  1411. plan.update_by = user.id
  1412. db.commit()
  1413. return get_plan(id, db, user)
  1414. @router.patch("/{id}/site-feedback/{link_id}", response_model=PlanWithProducts)
  1415. def update_plan_site_feedback(
  1416. id: str,
  1417. link_id: str,
  1418. payload: PlanSiteFeedbackUpdateBody,
  1419. db: Session = Depends(get_db),
  1420. user: DbUserContext = Depends(get_db_current_user),
  1421. ) -> PlanWithProducts:
  1422. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1423. plan = _get_plan(db, tenant_no, id, user)
  1424. link = apply_plan_site_feedback(
  1425. db,
  1426. tenant_no=tenant_no,
  1427. plan=plan,
  1428. link_id=link_id,
  1429. payload=payload,
  1430. user_id=user.id,
  1431. )
  1432. product_label = (link.product or "现场").strip()
  1433. record_plan_change(
  1434. db,
  1435. tenant_no=tenant_no,
  1436. plan_id=plan.id,
  1437. change_type="feedback_adjust",
  1438. change_content=f"归档人员更新现场回传信息({product_label})",
  1439. user_id=user.id,
  1440. user_name=user.name or None,
  1441. dept_id=user.dept_id,
  1442. )
  1443. plan.update_by = user.id
  1444. db.commit()
  1445. return get_plan(id, db, user)
  1446. # =============================================================================
  1447. # 入库单打印模板
  1448. # =============================================================================
  1449. @router.get("/{id}/inbound-slip-template")
  1450. def get_inbound_slip_template(
  1451. id: str,
  1452. db: Session = Depends(get_db),
  1453. user: DbUserContext = Depends(get_db_current_user),
  1454. ) -> str:
  1455. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1456. plan = _get_plan(db, tenant_no, id, user)
  1457. return plan.slip_template_content or ""
  1458. @router.put("/{id}/inbound-slip-template", status_code=status.HTTP_204_NO_CONTENT)
  1459. def save_inbound_slip_template(
  1460. id: str,
  1461. payload: PlanInboundSlipTemplateSave,
  1462. db: Session = Depends(get_db),
  1463. user: DbUserContext = Depends(get_db_current_user),
  1464. ) -> None:
  1465. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1466. plan = _get_plan(db, tenant_no, id, user)
  1467. if plan.plan_type != "inbound":
  1468. raise HTTPException(status_code=400, detail="仅入库单计划支持保存入库单打印模板")
  1469. if plan.transport_status != "arranged":
  1470. raise HTTPException(status_code=400, detail="请先完成运输安排后再保存入库单打印模板")
  1471. plan.slip_template_content = payload.slip_template_content or ""
  1472. plan.update_by = user.id
  1473. db.commit()
  1474. # =============================================================================
  1475. # 送(提)货单打印模板
  1476. # =============================================================================
  1477. @router.get("/{id}/delivery-slip-template")
  1478. def get_delivery_slip_template(
  1479. id: str,
  1480. db: Session = Depends(get_db),
  1481. user: DbUserContext = Depends(get_db_current_user),
  1482. ) -> str:
  1483. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1484. plan = _get_plan(db, tenant_no, id, user)
  1485. return plan.delivery_slip_template_content or ""
  1486. @router.put("/{id}/delivery-slip-template", status_code=status.HTTP_204_NO_CONTENT)
  1487. def save_delivery_slip_template(
  1488. id: str,
  1489. payload: PlanDeliverySlipTemplateSave,
  1490. db: Session = Depends(get_db),
  1491. user: DbUserContext = Depends(get_db_current_user),
  1492. ) -> None:
  1493. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1494. plan = _get_plan(db, tenant_no, id, user)
  1495. if plan.plan_type == "inbound":
  1496. raise HTTPException(status_code=400, detail="入库单计划请使用入库单打印模板")
  1497. if plan.transport_status != "arranged":
  1498. raise HTTPException(status_code=400, detail="请先完成运输安排后再保存送(提)货单打印模板")
  1499. plan.delivery_slip_template_content = payload.delivery_slip_template_content or ""
  1500. plan.update_by = user.id
  1501. db.commit()
  1502. # =============================================================================
  1503. # 分装单打印模板
  1504. # =============================================================================
  1505. @router.get("/{id}/subpack-slip-template")
  1506. def get_subpack_slip_template(
  1507. id: str,
  1508. db: Session = Depends(get_db),
  1509. user: DbUserContext = Depends(get_db_current_user),
  1510. ) -> str:
  1511. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1512. plan = _get_plan(db, tenant_no, id, user)
  1513. return plan.subpack_slip_template_content or ""
  1514. @router.put("/{id}/subpack-slip-template", status_code=status.HTTP_204_NO_CONTENT)
  1515. def save_subpack_slip_template(
  1516. id: str,
  1517. payload: PlanSubpackSlipTemplateSave,
  1518. db: Session = Depends(get_db),
  1519. user: DbUserContext = Depends(get_db_current_user),
  1520. ) -> None:
  1521. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1522. plan = _get_plan(db, tenant_no, id, user)
  1523. if plan.plan_type == "inbound":
  1524. raise HTTPException(status_code=400, detail="入库单计划请使用入库单打印模板")
  1525. plan.subpack_slip_template_content = payload.subpack_slip_template_content or ""
  1526. plan.update_by = user.id
  1527. db.commit()
  1528. @router.post("/{id}/subpack-slip-no")
  1529. def ensure_subpack_slip_no(
  1530. id: str,
  1531. db: Session = Depends(get_db),
  1532. user: DbUserContext = Depends(get_db_current_user),
  1533. ) -> str:
  1534. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1535. plan = _get_plan(db, tenant_no, id, user)
  1536. if plan.plan_type == "inbound":
  1537. raise HTTPException(status_code=400, detail="入库单计划不支持分装单号")
  1538. slip_no = _ensure_subpack_slip_no(db, tenant_no, plan)
  1539. plan.update_by = user.id
  1540. db.commit()
  1541. return slip_no
  1542. # =============================================================================
  1543. # 删除计划
  1544. # =============================================================================
  1545. @router.delete("/{id}", status_code=status.HTTP_204_NO_CONTENT)
  1546. def delete_plan(
  1547. id: str,
  1548. db: Session = Depends(get_db),
  1549. user: DbUserContext = Depends(get_db_current_user),
  1550. ) -> None:
  1551. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  1552. plan = _get_plan(db, tenant_no, id, user)
  1553. if plan.follow_status not in ("pending_arrange", "wait_notice"):
  1554. raise HTTPException(status_code=400, detail="只能删除待安排或等通知且未安排运输的计划")
  1555. if plan.transport_status != "pending":
  1556. raise HTTPException(status_code=400, detail="已安排运输的计划不能删除")
  1557. if plan.archive_status == "archived":
  1558. raise HTTPException(status_code=400, detail="已归档的计划不能删除")
  1559. assert_row_deletable_by_creator(plan, user_info_from_context(user))
  1560. plan.del_flag = 1
  1561. plan.update_by = user.id
  1562. db.query(PlPlanProduct).filter(
  1563. PlPlanProduct.plan_id == id,
  1564. PlPlanProduct.tenant_no == tenant_no,
  1565. PlPlanProduct.del_flag == 0,
  1566. ).update({"del_flag": 1, "update_by": user.id}, synchronize_session=False)
  1567. db.query(PlPlanTransport).filter(
  1568. PlPlanTransport.plan_id == id,
  1569. PlPlanTransport.tenant_no == tenant_no,
  1570. PlPlanTransport.del_flag == 0,
  1571. ).update({"del_flag": 1, "update_by": user.id}, synchronize_session=False)
  1572. db.commit()
  1573. # =============================================================================
  1574. # 辅助函数
  1575. # =============================================================================
  1576. def _get_plan(db: Session, tenant_no: str, plan_id: str, user: DbUserContext) -> PlPlan:
  1577. plan = (
  1578. db.query(PlPlan)
  1579. .filter(
  1580. PlPlan.id == plan_id,
  1581. PlPlan.tenant_no == tenant_no,
  1582. PlPlan.del_flag == 0,
  1583. )
  1584. .first()
  1585. )
  1586. if not plan:
  1587. raise HTTPException(status_code=404, detail="计划不存在")
  1588. assert_pl_row_in_scope(db, plan, PlPlan, user, tenant_no)
  1589. return plan