| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277 |
- """运输计划业务逻辑"""
- import json
- from datetime import date, datetime
- from decimal import Decimal
- from typing import Optional, Union
- from fastapi import HTTPException
- from sqlalchemy.orm import Session
- from app.core.utils import generate_uuid
- from app.models.pl_models import (
- PlCarrier,
- PlFreightSettlement,
- PlFreightSettlementTransport,
- PlPersonnel,
- PlPlan,
- PlPlanChange,
- PlPlanProduct,
- PlPlanTransport,
- PlTransport,
- PlTransportSiteLink,
- PlVehicle,
- PlVehiclePersonnel,
- )
- from app.schemas.pl.plan import (
- PlanArchiveFreightBlock,
- PlanArchiveProductItem,
- PlanCreateFull,
- PlanDriverFeedbackUpdateBody,
- PlanProductCreate,
- PlanSiteFeedbackUpdateBody,
- PlanTransportCreateBlock,
- )
- from app.services.pl_freight_settlement_service import sync_draft_settlement_freight_for_transport
- from app.services.pl_transport_resource_snapshot_service import (
- apply_resource_snapshot_json,
- build_transport_resource_snapshot,
- clear_resource_snapshot,
- )
- def determine_plan_type(supplier_name: Optional[str], destination_name: Optional[str]) -> str:
- if destination_name and ("安庆山峡" in destination_name or "安徽云栋" in destination_name):
- return "inbound"
- if supplier_name and ("安庆山峡" in supplier_name or "安徽云栋" in supplier_name):
- return "outbound"
- return "direct"
- def is_ton_product_unit(unit: Optional[str]) -> bool:
- code = (unit or "").strip()
- if not code:
- return True
- return code in ("dun", "吨")
- def _product_quantity(prod: PlanProductCreate) -> Decimal:
- if prod.quantity is not None:
- return Decimal(str(prod.quantity))
- if prod.inbound_estimate_qty is not None:
- return Decimal(str(prod.inbound_estimate_qty))
- if prod.outbound_estimate_qty is not None:
- return Decimal(str(prod.outbound_estimate_qty))
- return Decimal("0")
- def _product_create_actual_qty(prod: PlanProductCreate) -> Decimal:
- if prod.actual_qty is not None:
- return Decimal(str(prod.actual_qty))
- return Decimal("0")
- def _plan_product_actual_qty(prod: PlPlanProduct) -> Decimal:
- if prod.actual_qty is not None:
- return Decimal(str(prod.actual_qty))
- return Decimal("0")
- def sum_product_actual_quantities(products: list[PlanProductCreate]) -> Decimal:
- return sum(_product_create_actual_qty(p) for p in products)
- def sum_plan_product_actual_quantities(products: list[PlPlanProduct]) -> Decimal:
- return sum(_plan_product_actual_qty(p) for p in products)
- def _estimate_qty_fields(plan_type: str, qty: Optional[Decimal]) -> dict:
- if qty is None:
- return {}
- q = float(qty)
- if plan_type == "inbound":
- return {"inbound_estimate_qty": q, "outbound_estimate_qty": q}
- if plan_type == "outbound":
- return {"outbound_estimate_qty": q, "inbound_estimate_qty": q}
- return {"inbound_estimate_qty": q, "outbound_estimate_qty": q}
- def build_plan_product(
- *,
- tenant_no: str,
- plan_id: str,
- plan_type: str,
- prod: PlanProductCreate,
- order_num: int,
- user_id: str,
- dept_id: str,
- ) -> PlPlanProduct:
- qty = _product_quantity(prod)
- estimates = _estimate_qty_fields(plan_type, qty if qty else None)
- tax_price = prod.tax_price
- return PlPlanProduct(
- id=generate_uuid(),
- tenant_no=tenant_no,
- plan_id=plan_id,
- product_id=prod.product_id,
- product_no=prod.product_no,
- product_name=prod.product_name,
- model=prod.model,
- unit=prod.unit or "吨",
- category_name=prod.category_name,
- package_spec=prod.package_spec,
- delivery_method=prod.delivery_method,
- quantity=qty if qty else None,
- actual_qty=Decimal(str(prod.actual_qty)) if prod.actual_qty is not None else None,
- tax_price=tax_price,
- tax_amount=prod.tax_amount,
- tax_subtotal=prod.tax_subtotal,
- is_explosive=prod.is_explosive,
- is_toxic=prod.is_toxic,
- purchase_cert_url=prod.purchase_cert_url,
- transport_cert_url=prod.transport_cert_url,
- legal_use_cert_url=prod.legal_use_cert_url,
- inbound_price=tax_price,
- outbound_price=tax_price,
- inbound_amount=prod.tax_subtotal,
- outbound_amount=prod.tax_subtotal,
- remark=prod.remark,
- order_num=order_num,
- create_by=user_id,
- create_dept_id=dept_id,
- **estimates,
- )
- def _apply_vehicle_snapshot_to_plan_transport(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- transport: Optional[PlTransport],
- vehicle: PlVehicle,
- driver_id: str,
- ) -> None:
- snapshot = build_transport_resource_snapshot(
- db,
- tenant_no,
- vehicle.id,
- selected_driver_id=driver_id,
- )
- apply_resource_snapshot_json(plan=plan, transport=transport, snapshot=snapshot)
- def _resolve_driver(
- db: Session,
- tenant_no: str,
- vehicle_id: str,
- driver_id: Optional[str],
- ) -> tuple[str, str, Optional[str]]:
- if driver_id:
- personnel = (
- db.query(PlPersonnel)
- .filter(
- PlPersonnel.id == driver_id,
- PlPersonnel.tenant_no == tenant_no,
- PlPersonnel.del_flag == 0,
- )
- .first()
- )
- if personnel:
- return personnel.id, personnel.personnel_name, personnel.phone_no
- default_link = (
- db.query(PlVehiclePersonnel)
- .filter(
- PlVehiclePersonnel.vehicle_id == vehicle_id,
- PlVehiclePersonnel.tenant_no == tenant_no,
- PlVehiclePersonnel.del_flag == 0,
- PlVehiclePersonnel.role == "driver",
- )
- .order_by(PlVehiclePersonnel.is_default.desc(), PlVehiclePersonnel.order_num.asc())
- .first()
- )
- if default_link:
- personnel = (
- db.query(PlPersonnel)
- .filter(
- PlPersonnel.id == default_link.personnel_id,
- PlPersonnel.del_flag == 0,
- )
- .first()
- )
- if personnel:
- return personnel.id, personnel.personnel_name, personnel.phone_no
- raise HTTPException(status_code=400, detail="请选择司机或确保车辆已关联默认司机")
- def _calc_freight_amount(
- freight_type: str,
- products: list[PlPlanProduct],
- transport_qty: Optional[Decimal],
- freight_price: Optional[Decimal],
- freight_amount: Optional[Decimal],
- ) -> Decimal:
- if freight_type == "by_trip":
- return Decimal(str(freight_amount or 0))
- qty = transport_qty
- if qty is None:
- qty = sum_plan_product_actual_quantities(products)
- if freight_price is not None:
- computed = qty * Decimal(str(freight_price))
- if freight_amount is not None:
- return Decimal(str(freight_amount))
- return computed
- return Decimal(str(freight_amount or 0))
- def fetch_hazard_flags_map(
- db: Session,
- tenant_no: str,
- product_ids: Optional[list[str]] = None,
- ) -> dict[str, tuple[int, int]]:
- """批量从 CRM 产品主数据读取易制毒/易制爆标识。"""
- from app.models.crm_models import CrmProduct
- ids = [str(pid) for pid in (product_ids or []) if pid]
- if not ids:
- return {}
- rows = (
- db.query(CrmProduct.id, CrmProduct.is_toxic, CrmProduct.is_explosive)
- .filter(
- CrmProduct.id.in_(ids),
- CrmProduct.tenant_no == tenant_no,
- CrmProduct.del_flag == 0,
- )
- .all()
- )
- return {
- str(row.id): (int(row.is_toxic or 0), int(row.is_explosive or 0))
- for row in rows
- }
- def resolve_hazard_flags_from_crm(
- db: Session,
- tenant_no: str,
- product_id: Optional[str],
- *,
- hazard_map: Optional[dict[str, tuple[int, int]]] = None,
- ) -> tuple[int, int]:
- """从 CRM 产品主数据读取易制毒/易制爆标识(不读计划产品快照)。"""
- if not product_id:
- return 0, 0
- if hazard_map is not None:
- return hazard_map.get(str(product_id), (0, 0))
- from app.models.crm_models import CrmProduct
- row = (
- db.query(CrmProduct)
- .filter(
- CrmProduct.id == product_id,
- CrmProduct.tenant_no == tenant_no,
- CrmProduct.del_flag == 0,
- )
- .first()
- )
- if not row:
- return 0, 0
- return int(row.is_toxic or 0), int(row.is_explosive or 0)
- def plan_has_hazard_products(
- db: Session,
- tenant_no: str,
- products: list[PlPlanProduct],
- ) -> bool:
- return bool(collect_hazard_product_ids(db, tenant_no, products))
- def collect_hazard_product_ids(
- db: Session,
- tenant_no: str,
- products: list[Union[PlPlanProduct, PlanProductCreate]],
- ) -> frozenset[str]:
- product_ids = [str(p.product_id) for p in products if getattr(p, "product_id", None)]
- if not product_ids:
- return frozenset()
- hazard_map = fetch_hazard_flags_map(db, tenant_no, product_ids)
- hazard_ids: set[str] = set()
- for prod in products:
- product_id = getattr(prod, "product_id", None)
- if not product_id:
- continue
- is_toxic, is_explosive = resolve_hazard_flags_from_crm(
- db,
- tenant_no,
- product_id,
- hazard_map=hazard_map,
- )
- if is_toxic or is_explosive:
- hazard_ids.add(str(product_id))
- return frozenset(hazard_ids)
- def clear_hazard_cert_ready(plan: PlPlan) -> None:
- plan.hazard_cert_ready = 0
- plan.hazard_cert_ready_by = None
- plan.hazard_cert_ready_time = None
- def _required_hazard_cert_fields(is_toxic: int, is_explosive: int) -> list[str]:
- fields: list[str] = []
- if is_toxic:
- fields.extend(["purchase_cert_url", "transport_cert_url"])
- if is_explosive:
- fields.append("legal_use_cert_url")
- return fields
- def _is_hazard_product_cert_complete(
- product: PlPlanProduct,
- *,
- is_toxic: int,
- is_explosive: int,
- ) -> bool:
- for field in _required_hazard_cert_fields(is_toxic, is_explosive):
- if not str(getattr(product, field, "") or "").strip():
- return False
- return True
- def all_hazard_products_cert_complete(
- db: Session,
- tenant_no: str,
- products: list[PlPlanProduct],
- ) -> bool:
- """计划内所有危化品产品的所需证书槽位均已上传。"""
- if not products:
- return True
- hazard_map = fetch_hazard_flags_map(
- db,
- tenant_no,
- [product.product_id for product in products if product.product_id],
- )
- has_hazard = False
- for product in products:
- is_toxic, is_explosive = resolve_hazard_flags_from_crm(
- db,
- tenant_no,
- product.product_id,
- hazard_map=hazard_map,
- )
- if not (is_toxic or is_explosive):
- continue
- has_hazard = True
- if not _is_hazard_product_cert_complete(
- product,
- is_toxic=is_toxic,
- is_explosive=is_explosive,
- ):
- return False
- return has_hazard
- def maybe_auto_set_hazard_cert_ready(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- products: list[PlPlanProduct],
- user_id: str,
- ) -> None:
- """全部危化品证书已上传时,自动标记证书齐备(与人工确认等效)。"""
- if int(plan.hazard_cert_ready or 0):
- return
- if not all_hazard_products_cert_complete(db, tenant_no, products):
- return
- plan.hazard_cert_ready = 1
- plan.hazard_cert_ready_by = user_id
- plan.hazard_cert_ready_time = datetime.now()
- def validate_hazard_cert_ready_for_transport(
- db: Session,
- tenant_no: str,
- plan: PlPlan,
- products: list[PlPlanProduct],
- ) -> None:
- if not plan_has_hazard_products(db, tenant_no, products):
- return
- if int(plan.hazard_cert_ready or 0):
- return
- if all_hazard_products_cert_complete(db, tenant_no, products):
- return
- raise HTTPException(
- status_code=400,
- detail="该计划危化品证书尚未确认齐备,请至危化品证上传页操作",
- )
- def set_hazard_cert_ready(
- db: Session,
- *,
- tenant_no: str,
- plan_id: str,
- ready: bool,
- user_id: str,
- ) -> PlPlan:
- plan = (
- db.query(PlPlan)
- .filter(
- PlPlan.id == plan_id,
- PlPlan.tenant_no == tenant_no,
- PlPlan.del_flag == 0,
- )
- .first()
- )
- if not plan:
- raise HTTPException(status_code=404, detail="计划不存在")
- if plan.archive_status == "archived":
- raise HTTPException(status_code=400, detail="已归档的计划不能修改证书齐备状态")
- if plan.follow_status == "cancelled":
- raise HTTPException(status_code=400, detail="已作废的计划不能修改证书齐备状态")
- products = (
- db.query(PlPlanProduct)
- .filter(
- PlPlanProduct.plan_id == plan_id,
- PlPlanProduct.tenant_no == tenant_no,
- PlPlanProduct.del_flag == 0,
- )
- .all()
- )
- has_hazard = plan_has_hazard_products(db, tenant_no, products)
- if ready:
- if not has_hazard:
- raise HTTPException(status_code=400, detail="该计划不含易制毒/易制爆产品,无需确认证书齐备")
- plan.hazard_cert_ready = 1
- plan.hazard_cert_ready_by = user_id
- plan.hazard_cert_ready_time = datetime.now()
- else:
- clear_hazard_cert_ready(plan)
- plan.update_by = user_id
- db.commit()
- db.refresh(plan)
- return plan
- def update_plan_product_certs(
- db: Session,
- *,
- tenant_no: str,
- plan_id: str,
- items: list,
- user_id: str,
- ) -> list[PlPlanProduct]:
- plan = (
- db.query(PlPlan)
- .filter(
- PlPlan.id == plan_id,
- PlPlan.tenant_no == tenant_no,
- PlPlan.del_flag == 0,
- )
- .first()
- )
- if not plan:
- raise HTTPException(status_code=404, detail="计划不存在")
- if plan.archive_status == "archived":
- raise HTTPException(status_code=400, detail="已归档的计划不能修改")
- existing_rows = (
- db.query(PlPlanProduct)
- .filter(
- PlPlanProduct.plan_id == plan_id,
- PlPlanProduct.tenant_no == tenant_no,
- PlPlanProduct.del_flag == 0,
- )
- .all()
- )
- hazard_map = fetch_hazard_flags_map(
- db,
- tenant_no,
- [row.product_id for row in existing_rows if row.product_id],
- )
- updated: list[PlPlanProduct] = []
- for item in items:
- row = (
- db.query(PlPlanProduct)
- .filter(
- PlPlanProduct.id == item.id,
- PlPlanProduct.plan_id == plan_id,
- PlPlanProduct.tenant_no == tenant_no,
- PlPlanProduct.del_flag == 0,
- )
- .first()
- )
- if not row:
- raise HTTPException(status_code=404, detail=f"计划产品不存在: {item.id}")
- is_toxic, is_explosive = resolve_hazard_flags_from_crm(
- db, tenant_no, row.product_id, hazard_map=hazard_map
- )
- if not (is_toxic or is_explosive):
- raise HTTPException(status_code=400, detail=f"产品【{row.product_name}】无需上传危化品证书")
- row.purchase_cert_url = (item.purchase_cert_url or "").strip() or None
- row.transport_cert_url = (item.transport_cert_url or "").strip() or None
- row.legal_use_cert_url = (item.legal_use_cert_url or "").strip() or None
- row.update_by = user_id
- updated.append(row)
- maybe_auto_set_hazard_cert_ready(
- db,
- tenant_no=tenant_no,
- plan=plan,
- products=existing_rows,
- user_id=user_id,
- )
- plan.update_by = user_id
- db.commit()
- for row in updated:
- db.refresh(row)
- return updated
- def _generate_transport_no(db: Session) -> str:
- now = date.today()
- prefix = f"SXYS{now.strftime('%Y%m')}"
- last = (
- db.query(PlTransport)
- .filter(PlTransport.transport_no.like(f"{prefix}%"))
- .order_by(PlTransport.transport_no.desc())
- .first()
- )
- seq = 1
- if last and last.transport_no:
- try:
- seq = int(last.transport_no[-6:]) + 1
- except ValueError:
- seq = 1
- return f"{prefix}{seq:06d}"
- def _resolve_transport_context(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- transport_payload: PlanTransportCreateBlock,
- products: list[PlPlanProduct],
- ) -> tuple[PlVehicle, str, str, Optional[str], Optional[str], Optional[str], Decimal, Optional[Decimal]]:
- vehicle = (
- db.query(PlVehicle)
- .filter(
- PlVehicle.id == transport_payload.vehicle_id,
- PlVehicle.tenant_no == tenant_no,
- PlVehicle.del_flag == 0,
- )
- .first()
- )
- if not vehicle:
- raise HTTPException(status_code=400, detail="车辆不存在")
- driver_id, driver_name, driver_phone = _resolve_driver(
- db, tenant_no, transport_payload.vehicle_id, transport_payload.driver_id
- )
- carrier_id = transport_payload.carrier_id or vehicle.carrier_id
- carrier_name = vehicle.carrier_name
- if carrier_id:
- carrier = (
- db.query(PlCarrier)
- .filter(PlCarrier.id == carrier_id, PlCarrier.del_flag == 0)
- .first()
- )
- if carrier:
- carrier_name = carrier.carrier_name
- freight_amount = _calc_freight_amount(
- transport_payload.freight_type,
- products,
- transport_payload.transport_qty,
- transport_payload.freight_price,
- transport_payload.freight_amount,
- )
- transport_qty = transport_payload.transport_qty
- if transport_qty is None and transport_payload.freight_type == "by_weight":
- transport_qty = sum_plan_product_actual_quantities(products)
- return (
- vehicle,
- driver_id,
- driver_name,
- driver_phone,
- carrier_id,
- carrier_name,
- freight_amount,
- transport_qty,
- )
- def _apply_payload_to_transport_row(
- transport: PlTransport,
- *,
- vehicle: PlVehicle,
- driver_id: str,
- driver_name: str,
- driver_phone: Optional[str],
- carrier_id: Optional[str],
- carrier_name: Optional[str],
- plan: PlPlan,
- transport_payload: PlanTransportCreateBlock,
- freight_amount: Decimal,
- transport_qty: Optional[Decimal],
- user_id: str,
- ) -> None:
- transport.vehicle_id = vehicle.id
- transport.license_plate = vehicle.license_plate
- transport.driver_id = driver_id
- transport.driver_name = driver_name
- transport.driver_phone = driver_phone
- transport.carrier_id = carrier_id
- transport.carrier_name = carrier_name
- transport.start_point = plan.pickup_address
- transport.end_point = plan.destination_address or plan.destination_name
- transport.distance_km = transport_payload.distance_km
- transport.transport_qty = transport_qty
- transport.freight_price = transport_payload.freight_price
- transport.freight_amount = freight_amount or 0
- transport.freight_type = transport_payload.freight_type
- if transport_payload.has_invoice is not None:
- transport.has_invoice = transport_payload.has_invoice
- transport.unit = "吨" if transport_payload.freight_type == "by_weight" else "趟"
- if transport_payload.remark is not None:
- transport.remark = transport_payload.remark
- transport.update_by = user_id
- def upsert_draft_transport_for_plan(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- transport_payload: PlanTransportCreateBlock,
- products: list[PlPlanProduct],
- user_id: str,
- dept_id: str,
- ) -> None:
- """写入/更新草稿运输单(pl_transport + pl_plan_transport),计划保持待安排。"""
- (
- vehicle,
- driver_id,
- driver_name,
- driver_phone,
- carrier_id,
- carrier_name,
- freight_amount,
- transport_qty,
- ) = _resolve_transport_context(
- db,
- tenant_no=tenant_no,
- plan=plan,
- transport_payload=transport_payload,
- products=products,
- )
- transport: Optional[PlTransport] = None
- if plan.transport_id:
- transport = (
- db.query(PlTransport)
- .filter(
- PlTransport.id == plan.transport_id,
- PlTransport.tenant_no == tenant_no,
- PlTransport.del_flag == 0,
- )
- .first()
- )
- if transport:
- _apply_payload_to_transport_row(
- transport,
- vehicle=vehicle,
- driver_id=driver_id,
- driver_name=driver_name,
- driver_phone=driver_phone,
- carrier_id=carrier_id,
- carrier_name=carrier_name,
- plan=plan,
- transport_payload=transport_payload,
- freight_amount=freight_amount,
- transport_qty=transport_qty,
- user_id=user_id,
- )
- if transport.transport_status == "draft":
- pass
- else:
- transport_no = _generate_transport_no(db)
- transport = PlTransport(
- id=generate_uuid(),
- tenant_no=tenant_no,
- transport_no=transport_no,
- transport_status="draft",
- approval_status="none",
- remark=transport_payload.remark,
- create_by=user_id,
- create_dept_id=dept_id,
- )
- db.add(transport)
- db.flush()
- db.add(
- PlPlanTransport(
- id=generate_uuid(),
- tenant_no=tenant_no,
- plan_id=plan.id,
- transport_id=transport.id,
- create_by=user_id,
- create_dept_id=dept_id,
- )
- )
- plan.transport_id = transport.id
- plan.transport_no = transport_no
- _apply_payload_to_transport_row(
- transport,
- vehicle=vehicle,
- driver_id=driver_id,
- driver_name=driver_name,
- driver_phone=driver_phone,
- carrier_id=carrier_id,
- carrier_name=carrier_name,
- plan=plan,
- transport_payload=transport_payload,
- freight_amount=freight_amount,
- transport_qty=transport_qty,
- user_id=user_id,
- )
- plan.vehicle_id = vehicle.id
- plan.license_plate = vehicle.license_plate
- plan.driver_id = driver_id
- plan.driver_name = driver_name
- _apply_vehicle_snapshot_to_plan_transport(
- db,
- tenant_no=tenant_no,
- plan=plan,
- transport=transport,
- vehicle=vehicle,
- driver_id=driver_id,
- )
- plan.freight_amount = freight_amount or 0
- if plan.transport_id:
- sync_draft_settlement_freight_for_transport(
- db,
- tenant_no=tenant_no,
- transport_id=plan.transport_id,
- freight_amount=freight_amount or Decimal("0"),
- user_id=user_id,
- )
- if plan.transport_status != "arranged":
- plan.transport_status = "pending"
- def clear_draft_transport_for_plan(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- user_id: str,
- ) -> None:
- """清除计划上的草稿运输单及车辆预选。"""
- transport: Optional[PlTransport] = None
- if plan.transport_id:
- transport = (
- db.query(PlTransport)
- .filter(
- PlTransport.id == plan.transport_id,
- PlTransport.tenant_no == tenant_no,
- PlTransport.del_flag == 0,
- )
- .first()
- )
- if transport and transport.transport_status == "draft":
- transport.del_flag = 1
- transport.update_by = user_id
- db.query(PlPlanTransport).filter(
- PlPlanTransport.plan_id == plan.id,
- PlPlanTransport.transport_id == transport.id,
- PlPlanTransport.tenant_no == tenant_no,
- PlPlanTransport.del_flag == 0,
- ).update({"del_flag": 1, "update_by": user_id})
- plan.transport_id = None
- plan.transport_no = None
- plan.vehicle_id = None
- plan.license_plate = None
- plan.driver_id = None
- plan.driver_name = None
- clear_resource_snapshot(plan=plan, transport=transport)
- plan.freight_amount = 0
- if plan.transport_status != "arranged":
- plan.transport_status = "pending"
- def sync_transport_prefill_for_plan(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- transport_payload: PlanTransportCreateBlock,
- products: list[PlPlanProduct],
- user_id: str,
- dept_id: str = "",
- ) -> None:
- """同步运输预选到草稿运输子表(pl_transport)。"""
- upsert_draft_transport_for_plan(
- db,
- tenant_no=tenant_no,
- plan=plan,
- transport_payload=transport_payload,
- products=products,
- user_id=user_id,
- dept_id=dept_id or user_id,
- )
- def apply_vehicle_prefill_to_plan(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- transport_payload: PlanTransportCreateBlock,
- products: list[PlPlanProduct],
- user_id: str = "",
- dept_id: str = "",
- ) -> None:
- """兼容旧调用:写入草稿运输子表。"""
- upsert_draft_transport_for_plan(
- db,
- tenant_no=tenant_no,
- plan=plan,
- transport_payload=transport_payload,
- products=products,
- user_id=user_id,
- dept_id=dept_id or user_id,
- )
- def create_transport_for_plan(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- products: list[PlPlanProduct],
- transport_payload: PlanTransportCreateBlock,
- user_id: str,
- dept_id: str,
- generate_transport_no,
- ) -> PlTransport:
- vehicle = (
- db.query(PlVehicle)
- .filter(
- PlVehicle.id == transport_payload.vehicle_id,
- PlVehicle.tenant_no == tenant_no,
- PlVehicle.del_flag == 0,
- )
- .first()
- )
- if not vehicle:
- raise HTTPException(status_code=400, detail="车辆不存在")
- validate_hazard_cert_ready_for_transport(db, tenant_no, plan, products)
- driver_id, driver_name, driver_phone = _resolve_driver(
- db, tenant_no, transport_payload.vehicle_id, transport_payload.driver_id
- )
- carrier_name = vehicle.carrier_name
- carrier_id = transport_payload.carrier_id or vehicle.carrier_id
- if carrier_id:
- carrier = (
- db.query(PlCarrier)
- .filter(PlCarrier.id == carrier_id, PlCarrier.del_flag == 0)
- .first()
- )
- if carrier:
- carrier_name = carrier.carrier_name
- freight_amount = _calc_freight_amount(
- transport_payload.freight_type,
- products,
- transport_payload.transport_qty,
- transport_payload.freight_price,
- transport_payload.freight_amount,
- )
- transport_qty = transport_payload.transport_qty
- if transport_qty is None and transport_payload.freight_type == "by_weight":
- transport_qty = sum_plan_product_actual_quantities(products)
- transport_no = generate_transport_no(db)
- transport = PlTransport(
- id=generate_uuid(),
- tenant_no=tenant_no,
- transport_no=transport_no,
- vehicle_id=vehicle.id,
- license_plate=vehicle.license_plate,
- driver_id=driver_id,
- driver_name=driver_name,
- driver_phone=driver_phone,
- carrier_id=carrier_id,
- carrier_name=carrier_name,
- start_point=plan.pickup_address,
- end_point=plan.destination_address or plan.destination_name,
- distance_km=transport_payload.distance_km,
- unit="吨" if transport_payload.freight_type == "by_weight" else "趟",
- transport_qty=transport_qty,
- freight_price=transport_payload.freight_price,
- freight_amount=freight_amount or 0,
- freight_type=transport_payload.freight_type,
- has_invoice=transport_payload.has_invoice if transport_payload.has_invoice is not None else 0,
- transport_status="draft",
- approval_status="none",
- remark=transport_payload.remark,
- create_by=user_id,
- create_dept_id=dept_id,
- )
- db.add(transport)
- db.add(
- PlPlanTransport(
- id=generate_uuid(),
- tenant_no=tenant_no,
- plan_id=plan.id,
- transport_id=transport.id,
- create_by=user_id,
- create_dept_id=dept_id,
- )
- )
- plan.transport_id = transport.id
- plan.transport_no = transport_no
- plan.vehicle_id = vehicle.id
- plan.license_plate = vehicle.license_plate
- plan.driver_id = driver_id
- plan.driver_name = driver_name
- _apply_vehicle_snapshot_to_plan_transport(
- db,
- tenant_no=tenant_no,
- plan=plan,
- transport=transport,
- vehicle=vehicle,
- driver_id=driver_id,
- )
- plan.transport_status = "arranged"
- plan.freight_amount = freight_amount or 0
- return transport
- PLAN_SELECTABLE_CONTRACT_STATUSES = ("approved", "executing")
- def assert_contract_selectable_for_plan(
- db: Session,
- contract_id: str,
- tenant_no: str,
- ) -> None:
- from app.models.crm_models import CrmContract
- contract = (
- db.query(CrmContract)
- .filter(
- CrmContract.id == contract_id,
- CrmContract.tenant_no == tenant_no,
- CrmContract.del_flag == 0,
- )
- .first()
- )
- if not contract:
- raise HTTPException(status_code=404, detail="合同不存在")
- if contract.status not in PLAN_SELECTABLE_CONTRACT_STATUSES:
- raise HTTPException(status_code=422, detail="仅已审批或执行中的合同可关联运输计划")
- def validate_create_full(payload: PlanCreateFull) -> None:
- if not payload.contract_id:
- raise HTTPException(status_code=422, detail="请选择合同")
- if not payload.products:
- raise HTTPException(status_code=422, detail="请至少保留一条产品明细")
- transport = payload.transport
- if not transport or not transport.vehicle_id:
- return
- if payload.has_freight:
- if transport.freight_type == "by_weight":
- if not transport.freight_price or Decimal(str(transport.freight_price)) <= 0:
- raise HTTPException(status_code=422, detail="按重量计费时请填写运输单价")
- qty = transport.transport_qty or sum_product_actual_quantities(payload.products)
- if qty <= 0:
- raise HTTPException(status_code=422, detail="运输量必须大于0,请填写产品实际数量或运输量")
- elif transport.freight_type == "by_trip":
- if not transport.freight_amount or Decimal(str(transport.freight_amount)) <= 0:
- raise HTTPException(status_code=422, detail="按趟计费时请填写运费金额")
- def calc_plan_total_amount(products: list[PlanProductCreate]) -> Decimal:
- total = Decimal("0")
- for prod in products:
- if prod.tax_subtotal is not None:
- total += Decimal(str(prod.tax_subtotal))
- return total
- _LOCKED_SETTLEMENT_STATUSES = ("approving", "approved", "confirmed")
- def transport_has_locked_freight_settlement(
- db: Session, tenant_no: str, transport_id: Optional[str]
- ) -> bool:
- if not transport_id:
- return False
- return (
- db.query(PlFreightSettlementTransport.id)
- .join(
- PlFreightSettlement,
- PlFreightSettlement.id == PlFreightSettlementTransport.settlement_id,
- )
- .filter(
- PlFreightSettlementTransport.transport_id == transport_id,
- PlFreightSettlementTransport.tenant_no == tenant_no,
- PlFreightSettlementTransport.del_flag == 0,
- PlFreightSettlement.tenant_no == tenant_no,
- PlFreightSettlement.del_flag == 0,
- PlFreightSettlement.settlement_status.in_(_LOCKED_SETTLEMENT_STATUSES),
- )
- .first()
- is not None
- )
- def apply_archive_product_quantities(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- items: list[PlanArchiveProductItem],
- user_id: str,
- ) -> None:
- product_map = {
- row.id: row
- for row in db.query(PlPlanProduct).filter(
- PlPlanProduct.plan_id == plan.id,
- PlPlanProduct.tenant_no == tenant_no,
- PlPlanProduct.del_flag == 0,
- ).all()
- }
- for item in items:
- prod = product_map.get(item.id)
- if not prod:
- raise HTTPException(status_code=400, detail=f"产品明细不存在: {item.id}")
- actual = Decimal(str(item.actual_qty))
- prod.actual_qty = actual
- price_in = prod.inbound_price or prod.tax_price
- price_out = prod.outbound_price or prod.tax_price
- if plan.plan_type == "inbound":
- prod.inbound_qty = actual
- if price_in is not None:
- prod.inbound_amount = actual * Decimal(str(price_in))
- elif plan.plan_type == "outbound":
- prod.outbound_qty = actual
- if price_out is not None:
- prod.outbound_amount = actual * Decimal(str(price_out))
- prod.update_by = user_id
- def apply_archive_freight(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- freight: PlanArchiveFreightBlock,
- user_id: str,
- ) -> None:
- has_freight = int(freight.has_freight if freight.has_freight is not None else plan.has_freight or 0)
- plan.has_freight = has_freight
- plan.update_by = user_id
- if has_freight != 1:
- plan.freight_amount = Decimal("0")
- if not plan.transport_id:
- return
- if transport_has_locked_freight_settlement(db, tenant_no, plan.transport_id):
- raise HTTPException(status_code=400, detail="运输单已纳入运费结算,无法修改运费")
- transport = (
- db.query(PlTransport)
- .filter(
- PlTransport.id == plan.transport_id,
- PlTransport.tenant_no == tenant_no,
- PlTransport.del_flag == 0,
- )
- .first()
- )
- if not transport:
- raise HTTPException(status_code=400, detail="关联运输单不存在")
- transport.freight_amount = Decimal("0")
- transport.freight_price = None
- transport.transport_qty = None
- transport.update_by = user_id
- sync_draft_settlement_freight_for_transport(
- db,
- tenant_no=tenant_no,
- transport_id=plan.transport_id,
- freight_amount=Decimal("0"),
- user_id=user_id,
- )
- return
- if not plan.transport_id:
- raise HTTPException(status_code=400, detail="计划有运输费用但未安排运输,请先安排运输")
- if transport_has_locked_freight_settlement(db, tenant_no, plan.transport_id):
- raise HTTPException(status_code=400, detail="运输单已纳入运费结算,无法修改运费")
- transport = (
- db.query(PlTransport)
- .filter(
- PlTransport.id == plan.transport_id,
- PlTransport.tenant_no == tenant_no,
- PlTransport.del_flag == 0,
- )
- .first()
- )
- if not transport:
- raise HTTPException(status_code=400, detail="关联运输单不存在")
- transport.distance_km = freight.distance_km
- transport.freight_type = freight.freight_type or "by_weight"
- transport.freight_price = freight.freight_price
- amount = freight.freight_amount or Decimal("0")
- transport.freight_amount = amount
- freight_type = freight.freight_type or transport.freight_type or "by_weight"
- plan_products = (
- db.query(PlPlanProduct)
- .filter(
- PlPlanProduct.plan_id == plan.id,
- PlPlanProduct.tenant_no == tenant_no,
- PlPlanProduct.del_flag == 0,
- )
- .all()
- )
- if freight.transport_qty is not None:
- transport.transport_qty = freight.transport_qty
- elif freight_type == "by_weight":
- transport.transport_qty = sum_plan_product_actual_quantities(plan_products)
- if freight_type == "by_weight" and (transport.transport_qty or 0) <= 0:
- raise HTTPException(status_code=400, detail="运输量必须大于0,请先填写产品实际数量")
- if freight.has_invoice is not None:
- transport.has_invoice = freight.has_invoice
- transport.update_by = user_id
- plan.freight_amount = amount
- sync_draft_settlement_freight_for_transport(
- db,
- tenant_no=tenant_no,
- transport_id=plan.transport_id,
- freight_amount=amount,
- user_id=user_id,
- )
- def record_plan_change(
- db: Session,
- *,
- tenant_no: str,
- plan_id: str,
- change_type: str,
- change_content: str,
- user_id: str,
- user_name: Optional[str],
- dept_id: str,
- ) -> None:
- db.add(
- PlPlanChange(
- id=generate_uuid(),
- tenant_no=tenant_no,
- plan_id=plan_id,
- change_type=change_type,
- change_content=change_content,
- change_user_id=user_id,
- change_user_name=user_name,
- create_by=user_id,
- create_dept_id=dept_id,
- )
- )
- def apply_plan_driver_feedback(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- payload: PlanDriverFeedbackUpdateBody,
- user_id: str,
- ) -> PlTransport:
- if plan.follow_status == "cancelled":
- raise HTTPException(status_code=400, detail="已作废的计划不能编辑司机回传")
- if not plan.transport_id:
- raise HTTPException(status_code=400, detail="计划未安排运输,无法编辑司机回传")
- transport = (
- db.query(PlTransport)
- .filter(
- PlTransport.id == plan.transport_id,
- PlTransport.tenant_no == tenant_no,
- PlTransport.del_flag == 0,
- )
- .first()
- )
- if not transport:
- raise HTTPException(status_code=404, detail="运输单不存在")
- if payload.feedback_qty is not None:
- transport.feedback_qty = payload.feedback_qty
- if payload.feedback_remark is not None:
- transport.feedback_remark = payload.feedback_remark.strip() if payload.feedback_remark else None
- if payload.feedback_images is not None:
- transport.feedback_images = json.dumps([item for item in payload.feedback_images if item])
- transport.feedback_time = payload.feedback_time or datetime.now()
- transport.update_by = user_id
- return transport
- def apply_plan_site_feedback(
- db: Session,
- *,
- tenant_no: str,
- plan: PlPlan,
- link_id: str,
- payload: PlanSiteFeedbackUpdateBody,
- user_id: str,
- ) -> PlTransportSiteLink:
- if plan.follow_status == "cancelled":
- raise HTTPException(status_code=400, detail="已作废的计划不能编辑现场回传")
- link = (
- db.query(PlTransportSiteLink)
- .filter(
- PlTransportSiteLink.id == link_id,
- PlTransportSiteLink.plan_id == plan.id,
- PlTransportSiteLink.tenant_no == tenant_no,
- PlTransportSiteLink.del_flag == 0,
- )
- .first()
- )
- if not link:
- raise HTTPException(status_code=404, detail="现场链接不存在")
- if payload.site_feedback_remark is not None:
- link.site_feedback_remark = (
- payload.site_feedback_remark.strip() if payload.site_feedback_remark else None
- )
- if payload.site_feedback_images is not None:
- link.site_feedback_images = json.dumps([item for item in payload.site_feedback_images if item])
- link.site_feedback_time = payload.site_feedback_time or datetime.now()
- link.update_by = user_id
- return link
|