base_data.py 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947
  1. """运输计划管理 - 基础数据 API(承运商、车辆、人员)"""
  2. from datetime import datetime
  3. from typing import Optional
  4. from fastapi import APIRouter, Depends, HTTPException, Query, status
  5. from sqlalchemy import case, func, or_
  6. from sqlalchemy.orm import Session
  7. from app.core.database import get_db
  8. from app.core.db_auth import DbUserContext, get_db_current_user
  9. from app.core.delete_guard import assert_row_deletable_by_creator, user_info_from_context
  10. from app.services.pl_data_scope import apply_pl_scope, assert_pl_row_in_scope
  11. from app.core.tenant_context import get_tenant_no
  12. from app.core.utils import generate_uuid
  13. from app.models.pl_models import (
  14. PlCarrier,
  15. PlPersonnel,
  16. PlVehicle,
  17. PlVehicleDriver,
  18. PlVehiclePersonnel,
  19. )
  20. from app.schemas.pl import (
  21. CarrierAuditReject,
  22. CarrierCreate,
  23. CarrierListResponse,
  24. CarrierRead,
  25. CarrierUpdate,
  26. carrier_to_read,
  27. DriverCreate,
  28. DriverListResponse,
  29. DriverRead,
  30. DriverUpdate,
  31. PersonnelCreate,
  32. PersonnelDetailRead,
  33. PersonnelListResponse,
  34. PersonnelRead,
  35. PersonnelUpdate,
  36. VehicleCreate,
  37. VehicleDetailRead,
  38. VehicleDriverCreate,
  39. VehicleListResponse,
  40. VehicleRead,
  41. VehicleUpdate,
  42. )
  43. from app.services.pl_cert_service import (
  44. certs_to_read,
  45. list_owner_certs,
  46. nearest_expire_date,
  47. save_owner_certs,
  48. )
  49. from app.services.pl_carrier_service import (
  50. carrier_eligible_for_transport,
  51. carrier_qualification_complete,
  52. )
  53. from app.services.pl_personnel_service import (
  54. load_vehicle_personnel_rows,
  55. load_vehicle_personnel_summaries,
  56. save_vehicle_personnel,
  57. )
  58. router = APIRouter(prefix="", tags=["运输计划-基础数据"])
  59. # =============================================================================
  60. # 承运商 API
  61. # =============================================================================
  62. @router.get("/carrier", response_model=CarrierListResponse)
  63. def list_carriers(
  64. q: Optional[str] = Query(default=None, description="模糊搜索"),
  65. status: Optional[str] = Query(default=None, description="状态"),
  66. audit_status: Optional[str] = Query(default=None, alias="auditStatus", description="审核状态"),
  67. page: int = Query(default=1, ge=1),
  68. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  69. db: Session = Depends(get_db),
  70. user: DbUserContext = Depends(get_db_current_user),
  71. ) -> CarrierListResponse:
  72. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  73. query = db.query(PlCarrier).filter(
  74. PlCarrier.tenant_no == tenant_no,
  75. PlCarrier.del_flag == 0,
  76. )
  77. if status:
  78. query = query.filter(PlCarrier.status == status)
  79. if audit_status:
  80. query = query.filter(PlCarrier.audit_status == audit_status)
  81. if q:
  82. query = query.filter(
  83. or_(
  84. func.lower(PlCarrier.carrier_name).contains(q.lower()),
  85. func.lower(PlCarrier.contact_name).contains(q.lower()),
  86. )
  87. )
  88. query = apply_pl_scope(query, PlCarrier, user, db, tenant_no)
  89. query = query.order_by(
  90. case((PlCarrier.order_num.is_(None), 1), else_=0).asc(),
  91. PlCarrier.create_time.desc(),
  92. )
  93. total = query.count()
  94. offset = (page - 1) * page_size
  95. rows = query.offset(offset).limit(page_size).all()
  96. return CarrierListResponse(
  97. total=total,
  98. list=[carrier_to_read(row) for row in rows],
  99. )
  100. @router.post("/carrier", response_model=CarrierRead, status_code=status.HTTP_201_CREATED)
  101. def create_carrier(
  102. payload: CarrierCreate,
  103. db: Session = Depends(get_db),
  104. user: DbUserContext = Depends(get_db_current_user),
  105. ) -> CarrierRead:
  106. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  107. carrier = PlCarrier(
  108. id=generate_uuid(),
  109. tenant_no=tenant_no,
  110. carrier_name=payload.carrier_name,
  111. contact_name=payload.contact_name,
  112. contact_phone=payload.contact_phone,
  113. status=payload.status,
  114. business_license_urls=payload.business_license_urls.strip(),
  115. road_transport_license_urls=payload.road_transport_license_urls.strip(),
  116. transport_agreement_urls=payload.transport_agreement_urls.strip(),
  117. transport_agreement_expire_date=payload.transport_agreement_expire_date,
  118. audit_status="pending",
  119. remark=payload.remark,
  120. create_by=user.id,
  121. create_dept_id=user.dept_id,
  122. )
  123. db.add(carrier)
  124. db.commit()
  125. db.refresh(carrier)
  126. return carrier_to_read(carrier)
  127. @router.get("/carrier/{id}", response_model=CarrierRead)
  128. def get_carrier(
  129. id: str,
  130. db: Session = Depends(get_db),
  131. user: DbUserContext = Depends(get_db_current_user),
  132. ) -> CarrierRead:
  133. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  134. carrier = _get_carrier(db, tenant_no, id, user)
  135. return carrier_to_read(carrier)
  136. @router.put("/carrier/{id}", response_model=CarrierRead)
  137. def update_carrier(
  138. id: str,
  139. payload: CarrierUpdate,
  140. db: Session = Depends(get_db),
  141. user: DbUserContext = Depends(get_db_current_user),
  142. ) -> CarrierRead:
  143. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  144. carrier = _get_carrier(db, tenant_no, id, user)
  145. payload_data = payload.model_dump(exclude_unset=True)
  146. qual_keys = (
  147. "business_license_urls",
  148. "road_transport_license_urls",
  149. "transport_agreement_urls",
  150. "transport_agreement_expire_date",
  151. )
  152. qual_changed = any(key in payload_data for key in qual_keys)
  153. for key, value in payload_data.items():
  154. setattr(carrier, key, value)
  155. if qual_changed and carrier.audit_status == "approved":
  156. carrier.audit_status = "pending"
  157. carrier.audit_by = None
  158. carrier.audit_time = None
  159. carrier.audit_remark = None
  160. carrier.update_by = user.id
  161. db.commit()
  162. db.refresh(carrier)
  163. return carrier_to_read(carrier)
  164. @router.delete("/carrier/{id}", status_code=status.HTTP_204_NO_CONTENT)
  165. def delete_carrier(
  166. id: str,
  167. db: Session = Depends(get_db),
  168. user: DbUserContext = Depends(get_db_current_user),
  169. ) -> None:
  170. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  171. carrier = _get_carrier(db, tenant_no, id, user)
  172. assert_row_deletable_by_creator(carrier, user_info_from_context(user))
  173. carrier.del_flag = 1
  174. carrier.update_by = user.id
  175. db.commit()
  176. @router.post("/carrier/{id}/approve", response_model=CarrierRead)
  177. def approve_carrier(
  178. id: str,
  179. db: Session = Depends(get_db),
  180. user: DbUserContext = Depends(get_db_current_user),
  181. ) -> CarrierRead:
  182. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  183. carrier = _get_carrier(db, tenant_no, id, user)
  184. if carrier.audit_status == "approved":
  185. raise HTTPException(status_code=400, detail="承运商已审核通过")
  186. if not carrier_qualification_complete(carrier):
  187. raise HTTPException(status_code=400, detail="承运商资质附件不完整,无法审核通过")
  188. carrier.audit_status = "approved"
  189. carrier.audit_by = user.id
  190. carrier.audit_time = datetime.now()
  191. carrier.audit_remark = None
  192. carrier.update_by = user.id
  193. db.commit()
  194. db.refresh(carrier)
  195. return carrier_to_read(carrier)
  196. @router.post("/carrier/{id}/reject", response_model=CarrierRead)
  197. def reject_carrier(
  198. id: str,
  199. payload: CarrierAuditReject,
  200. db: Session = Depends(get_db),
  201. user: DbUserContext = Depends(get_db_current_user),
  202. ) -> CarrierRead:
  203. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  204. carrier = _get_carrier(db, tenant_no, id, user)
  205. if carrier.audit_status == "approved":
  206. raise HTTPException(status_code=400, detail="承运商已审核通过,无法驳回")
  207. carrier.audit_status = "rejected"
  208. carrier.audit_by = user.id
  209. carrier.audit_time = datetime.now()
  210. carrier.audit_remark = (payload.remark or "").strip() or None
  211. carrier.update_by = user.id
  212. db.commit()
  213. db.refresh(carrier)
  214. return carrier_to_read(carrier)
  215. def _get_carrier(db: Session, tenant_no: str, carrier_id: str, user: DbUserContext) -> PlCarrier:
  216. carrier = (
  217. db.query(PlCarrier)
  218. .filter(
  219. PlCarrier.id == carrier_id,
  220. PlCarrier.tenant_no == tenant_no,
  221. PlCarrier.del_flag == 0,
  222. )
  223. .first()
  224. )
  225. if not carrier:
  226. raise HTTPException(status_code=404, detail="承运商不存在")
  227. assert_pl_row_in_scope(db, carrier, PlCarrier, user, tenant_no)
  228. return carrier
  229. # =============================================================================
  230. # 车辆 API
  231. # =============================================================================
  232. def _vehicle_to_read(
  233. vehicle: PlVehicle,
  234. summary: Optional[str] = None,
  235. default_driver_name: Optional[str] = None,
  236. ) -> VehicleRead:
  237. data = VehicleRead.model_validate(vehicle)
  238. if summary is not None:
  239. data.personnel_summary = summary
  240. if default_driver_name is not None:
  241. data.default_driver_name = default_driver_name
  242. return data
  243. def _vehicle_to_detail(
  244. db: Session, tenant_no: str, vehicle: PlVehicle
  245. ) -> VehicleDetailRead:
  246. summaries = load_vehicle_personnel_summaries(db, tenant_no, [vehicle.id])
  247. summary, default_name = summaries.get(vehicle.id, ("", None))
  248. personnel_list = load_vehicle_personnel_rows(db, tenant_no, vehicle.id)
  249. cert_list = certs_to_read(
  250. list_owner_certs(db, tenant_no, "vehicle", vehicle.id)
  251. )
  252. base = _vehicle_to_read(vehicle, summary, default_name)
  253. return VehicleDetailRead(
  254. **base.model_dump(by_alias=False),
  255. personnel_list=personnel_list,
  256. cert_list=cert_list,
  257. )
  258. @router.get("/vehicle", response_model=VehicleListResponse)
  259. def list_vehicles(
  260. q: Optional[str] = Query(default=None, description="模糊搜索车牌号"),
  261. vehicle_type: Optional[str] = Query(default=None, alias="vehicleType", description="车辆类型"),
  262. carrier_id: Optional[str] = Query(default=None, alias="carrierId", description="承运商ID"),
  263. vehicle_status: Optional[str] = Query(default=None, alias="vehicleStatus", description="车辆状态"),
  264. exclude_ineligible_carrier: Optional[bool] = Query(
  265. default=False,
  266. alias="excludeIneligibleCarrier",
  267. description="排除资质不全或协议过期的承运商车辆",
  268. ),
  269. page: int = Query(default=1, ge=1),
  270. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  271. db: Session = Depends(get_db),
  272. user: DbUserContext = Depends(get_db_current_user),
  273. ) -> VehicleListResponse:
  274. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  275. query = db.query(PlVehicle).filter(
  276. PlVehicle.tenant_no == tenant_no,
  277. PlVehicle.del_flag == 0,
  278. )
  279. if vehicle_type:
  280. query = query.filter(PlVehicle.vehicle_type == vehicle_type)
  281. if carrier_id:
  282. query = query.filter(PlVehicle.carrier_id == carrier_id)
  283. if vehicle_status:
  284. query = query.filter(PlVehicle.vehicle_status == vehicle_status)
  285. if q:
  286. query = query.filter(PlVehicle.license_plate.contains(q))
  287. query = apply_pl_scope(query, PlVehicle, user, db, tenant_no)
  288. query = query.order_by(
  289. case((PlVehicle.order_num.is_(None), 1), else_=0).asc(),
  290. PlVehicle.create_time.desc(),
  291. )
  292. if exclude_ineligible_carrier:
  293. vehicles = query.all()
  294. carrier_ids = {
  295. v.carrier_id for v in vehicles if v.vehicle_type == "carrier" and v.carrier_id
  296. }
  297. carrier_map: dict[str, PlCarrier] = {}
  298. if carrier_ids:
  299. carriers = (
  300. db.query(PlCarrier)
  301. .filter(
  302. PlCarrier.id.in_(carrier_ids),
  303. PlCarrier.tenant_no == tenant_no,
  304. PlCarrier.del_flag == 0,
  305. )
  306. .all()
  307. )
  308. carrier_map = {c.id: c for c in carriers}
  309. vehicles = [
  310. v
  311. for v in vehicles
  312. if v.vehicle_type != "carrier"
  313. or not v.carrier_id
  314. or (
  315. v.carrier_id in carrier_map
  316. and carrier_eligible_for_transport(carrier_map[v.carrier_id])
  317. )
  318. ]
  319. summaries = load_vehicle_personnel_summaries(
  320. db, tenant_no, [v.id for v in vehicles]
  321. )
  322. items = [
  323. _vehicle_to_read(v, *summaries.get(v.id, ("", None)))
  324. for v in vehicles
  325. ]
  326. return VehicleListResponse(total=len(items), list=items)
  327. total = query.count()
  328. offset = (page - 1) * page_size
  329. vehicles = query.offset(offset).limit(page_size).all()
  330. summaries = load_vehicle_personnel_summaries(
  331. db, tenant_no, [v.id for v in vehicles]
  332. )
  333. return VehicleListResponse(
  334. total=total,
  335. list=[
  336. _vehicle_to_read(v, *summaries.get(v.id, ("", None)))
  337. for v in vehicles
  338. ],
  339. )
  340. @router.post("/vehicle", response_model=VehicleDetailRead, status_code=status.HTTP_201_CREATED)
  341. def create_vehicle(
  342. payload: VehicleCreate,
  343. db: Session = Depends(get_db),
  344. user: DbUserContext = Depends(get_db_current_user),
  345. ) -> VehicleDetailRead:
  346. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  347. existing = (
  348. db.query(PlVehicle)
  349. .filter(
  350. PlVehicle.license_plate == payload.license_plate,
  351. PlVehicle.del_flag == 0,
  352. )
  353. .first()
  354. )
  355. if existing:
  356. raise HTTPException(status_code=400, detail="车牌号已存在")
  357. vehicle = PlVehicle(
  358. id=generate_uuid(),
  359. tenant_no=tenant_no,
  360. vehicle_type=payload.vehicle_type,
  361. carrier_id=payload.carrier_id,
  362. carrier_name=payload.carrier_name,
  363. license_plate=payload.license_plate,
  364. trailer_no=payload.trailer_no,
  365. load_capacity=payload.load_capacity,
  366. vehicle_status=payload.vehicle_status,
  367. remark=payload.remark,
  368. create_by=user.id,
  369. create_dept_id=user.dept_id,
  370. )
  371. db.add(vehicle)
  372. db.flush()
  373. try:
  374. save_vehicle_personnel(
  375. db,
  376. vehicle.id,
  377. payload.personnel_list,
  378. tenant_no,
  379. user_id=user.id,
  380. dept_id=user.dept_id,
  381. )
  382. save_owner_certs(
  383. db,
  384. "vehicle",
  385. vehicle.id,
  386. payload.cert_list,
  387. tenant_no,
  388. user_id=user.id,
  389. dept_id=user.dept_id,
  390. )
  391. db.commit()
  392. except HTTPException:
  393. db.rollback()
  394. raise
  395. except Exception:
  396. db.rollback()
  397. raise
  398. db.refresh(vehicle)
  399. return _vehicle_to_detail(db, tenant_no, vehicle)
  400. @router.get("/vehicle/{id}", response_model=VehicleDetailRead)
  401. def get_vehicle(
  402. id: str,
  403. db: Session = Depends(get_db),
  404. user: DbUserContext = Depends(get_db_current_user),
  405. ) -> VehicleDetailRead:
  406. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  407. vehicle = _get_vehicle(db, tenant_no, id, user)
  408. return _vehicle_to_detail(db, tenant_no, vehicle)
  409. @router.put("/vehicle/{id}", response_model=VehicleDetailRead)
  410. def update_vehicle(
  411. id: str,
  412. payload: VehicleUpdate,
  413. db: Session = Depends(get_db),
  414. user: DbUserContext = Depends(get_db_current_user),
  415. ) -> VehicleDetailRead:
  416. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  417. vehicle = _get_vehicle(db, tenant_no, id, user)
  418. personnel_list = payload.personnel_list
  419. cert_list = payload.cert_list
  420. data = payload.model_dump(
  421. exclude_unset=True, exclude={"personnel_list", "cert_list"}
  422. )
  423. for key, value in data.items():
  424. setattr(vehicle, key, value)
  425. vehicle.update_by = user.id
  426. try:
  427. if personnel_list is not None:
  428. save_vehicle_personnel(
  429. db,
  430. vehicle.id,
  431. personnel_list,
  432. tenant_no,
  433. user_id=user.id,
  434. dept_id=user.dept_id,
  435. )
  436. if cert_list is not None:
  437. save_owner_certs(
  438. db,
  439. "vehicle",
  440. vehicle.id,
  441. cert_list,
  442. tenant_no,
  443. user_id=user.id,
  444. dept_id=user.dept_id,
  445. )
  446. db.commit()
  447. except HTTPException:
  448. db.rollback()
  449. raise
  450. except Exception:
  451. db.rollback()
  452. raise
  453. db.refresh(vehicle)
  454. return _vehicle_to_detail(db, tenant_no, vehicle)
  455. @router.delete("/vehicle/{id}", status_code=status.HTTP_204_NO_CONTENT)
  456. def delete_vehicle(
  457. id: str,
  458. db: Session = Depends(get_db),
  459. user: DbUserContext = Depends(get_db_current_user),
  460. ) -> None:
  461. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  462. vehicle = _get_vehicle(db, tenant_no, id, user)
  463. assert_row_deletable_by_creator(vehicle, user_info_from_context(user))
  464. vehicle.del_flag = 1
  465. vehicle.update_by = user.id
  466. db.commit()
  467. def _get_vehicle(db: Session, tenant_no: str, vehicle_id: str, user: DbUserContext) -> PlVehicle:
  468. vehicle = (
  469. db.query(PlVehicle)
  470. .filter(
  471. PlVehicle.id == vehicle_id,
  472. PlVehicle.tenant_no == tenant_no,
  473. PlVehicle.del_flag == 0,
  474. )
  475. .first()
  476. )
  477. if not vehicle:
  478. raise HTTPException(status_code=404, detail="车辆不存在")
  479. assert_pl_row_in_scope(db, vehicle, PlVehicle, user, tenant_no)
  480. return vehicle
  481. # =============================================================================
  482. # 人员 API
  483. # =============================================================================
  484. def _personnel_to_read(
  485. db: Session, tenant_no: str, personnel: PlPersonnel
  486. ) -> PersonnelRead:
  487. nearest = nearest_expire_date(db, tenant_no, "personnel", personnel.id)
  488. data = PersonnelRead.model_validate(personnel)
  489. data.nearest_expire_date = nearest
  490. return data
  491. def _personnel_to_detail(
  492. db: Session, tenant_no: str, personnel: PlPersonnel
  493. ) -> PersonnelDetailRead:
  494. base = _personnel_to_read(db, tenant_no, personnel)
  495. cert_list = certs_to_read(
  496. list_owner_certs(db, tenant_no, "personnel", personnel.id)
  497. )
  498. return PersonnelDetailRead(
  499. **base.model_dump(by_alias=False),
  500. cert_list=cert_list,
  501. )
  502. @router.get("/personnel", response_model=PersonnelListResponse)
  503. def list_personnel(
  504. q: Optional[str] = Query(default=None, description="模糊搜索姓名/手机号"),
  505. status: Optional[str] = Query(default=None, description="状态"),
  506. page: int = Query(default=1, ge=1),
  507. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  508. db: Session = Depends(get_db),
  509. user: DbUserContext = Depends(get_db_current_user),
  510. ) -> PersonnelListResponse:
  511. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  512. query = db.query(PlPersonnel).filter(
  513. PlPersonnel.tenant_no == tenant_no,
  514. PlPersonnel.del_flag == 0,
  515. )
  516. if status:
  517. query = query.filter(PlPersonnel.status == status)
  518. if q:
  519. query = query.filter(
  520. or_(
  521. func.lower(PlPersonnel.personnel_name).contains(q.lower()),
  522. PlPersonnel.phone_no.contains(q),
  523. )
  524. )
  525. query = apply_pl_scope(query, PlPersonnel, user, db, tenant_no)
  526. query = query.order_by(
  527. case((PlPersonnel.order_num.is_(None), 1), else_=0).asc(),
  528. PlPersonnel.create_time.desc(),
  529. )
  530. total = query.count()
  531. offset = (page - 1) * page_size
  532. rows = query.offset(offset).limit(page_size).all()
  533. return PersonnelListResponse(
  534. total=total,
  535. list=[_personnel_to_read(db, tenant_no, p) for p in rows],
  536. )
  537. @router.post("/personnel", response_model=PersonnelDetailRead, status_code=status.HTTP_201_CREATED)
  538. def create_personnel(
  539. payload: PersonnelCreate,
  540. db: Session = Depends(get_db),
  541. user: DbUserContext = Depends(get_db_current_user),
  542. ) -> PersonnelDetailRead:
  543. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  544. personnel = PlPersonnel(
  545. id=generate_uuid(),
  546. tenant_no=tenant_no,
  547. personnel_name=payload.personnel_name,
  548. phone_no=payload.phone_no,
  549. age=payload.age,
  550. id_card_no=payload.id_card_no,
  551. status=payload.status,
  552. remark=payload.remark,
  553. create_by=user.id,
  554. create_dept_id=user.dept_id,
  555. )
  556. db.add(personnel)
  557. db.flush()
  558. try:
  559. save_owner_certs(
  560. db,
  561. "personnel",
  562. personnel.id,
  563. payload.cert_list,
  564. tenant_no,
  565. user_id=user.id,
  566. dept_id=user.dept_id,
  567. )
  568. db.commit()
  569. except Exception:
  570. db.rollback()
  571. raise
  572. db.refresh(personnel)
  573. return _personnel_to_detail(db, tenant_no, personnel)
  574. @router.get("/personnel/{id}", response_model=PersonnelDetailRead)
  575. def get_personnel(
  576. id: str,
  577. db: Session = Depends(get_db),
  578. user: DbUserContext = Depends(get_db_current_user),
  579. ) -> PersonnelDetailRead:
  580. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  581. personnel = _get_personnel(db, tenant_no, id, user)
  582. return _personnel_to_detail(db, tenant_no, personnel)
  583. @router.put("/personnel/{id}", response_model=PersonnelDetailRead)
  584. def update_personnel(
  585. id: str,
  586. payload: PersonnelUpdate,
  587. db: Session = Depends(get_db),
  588. user: DbUserContext = Depends(get_db_current_user),
  589. ) -> PersonnelDetailRead:
  590. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  591. personnel = _get_personnel(db, tenant_no, id, user)
  592. cert_list = payload.cert_list
  593. data = payload.model_dump(exclude_unset=True, exclude={"cert_list"})
  594. for key, value in data.items():
  595. setattr(personnel, key, value)
  596. personnel.update_by = user.id
  597. try:
  598. if cert_list is not None:
  599. save_owner_certs(
  600. db,
  601. "personnel",
  602. personnel.id,
  603. cert_list,
  604. tenant_no,
  605. user_id=user.id,
  606. dept_id=user.dept_id,
  607. )
  608. db.commit()
  609. except Exception:
  610. db.rollback()
  611. raise
  612. db.refresh(personnel)
  613. return _personnel_to_detail(db, tenant_no, personnel)
  614. @router.delete("/personnel/{id}", status_code=status.HTTP_204_NO_CONTENT)
  615. def delete_personnel(
  616. id: str,
  617. db: Session = Depends(get_db),
  618. user: DbUserContext = Depends(get_db_current_user),
  619. ) -> None:
  620. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  621. personnel = _get_personnel(db, tenant_no, id, user)
  622. assert_row_deletable_by_creator(personnel, user_info_from_context(user))
  623. personnel.del_flag = 1
  624. personnel.update_by = user.id
  625. db.commit()
  626. def _get_personnel(db: Session, tenant_no: str, personnel_id: str, user: DbUserContext) -> PlPersonnel:
  627. personnel = (
  628. db.query(PlPersonnel)
  629. .filter(
  630. PlPersonnel.id == personnel_id,
  631. PlPersonnel.tenant_no == tenant_no,
  632. PlPersonnel.del_flag == 0,
  633. )
  634. .first()
  635. )
  636. if not personnel:
  637. raise HTTPException(status_code=404, detail="人员不存在")
  638. assert_pl_row_in_scope(db, personnel, PlPersonnel, user, tenant_no)
  639. return personnel
  640. # =============================================================================
  641. # 司机 API(兼容别名,内部使用 pl_personnel)
  642. # =============================================================================
  643. def _personnel_to_driver_read(personnel: PlPersonnel) -> DriverRead:
  644. return DriverRead(
  645. id=personnel.id,
  646. driver_name=personnel.personnel_name,
  647. phone_no=personnel.phone_no,
  648. id_card_no=personnel.id_card_no,
  649. tenant_no=personnel.tenant_no,
  650. order_num=personnel.order_num,
  651. remark=personnel.remark,
  652. create_by=personnel.create_by,
  653. create_dept_id=personnel.create_dept_id,
  654. create_time=personnel.create_time,
  655. update_by=personnel.update_by,
  656. update_time=personnel.update_time,
  657. del_flag=personnel.del_flag,
  658. )
  659. @router.get("/driver", response_model=DriverListResponse)
  660. def list_drivers(
  661. q: Optional[str] = Query(default=None, description="模糊搜索姓名/手机号"),
  662. page: int = Query(default=1, ge=1),
  663. page_size: int = Query(default=20, ge=1, le=100, alias="pageSize"),
  664. db: Session = Depends(get_db),
  665. user: DbUserContext = Depends(get_db_current_user),
  666. ) -> DriverListResponse:
  667. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  668. query = db.query(PlPersonnel).filter(
  669. PlPersonnel.tenant_no == tenant_no,
  670. PlPersonnel.del_flag == 0,
  671. )
  672. if q:
  673. query = query.filter(
  674. or_(
  675. func.lower(PlPersonnel.personnel_name).contains(q.lower()),
  676. PlPersonnel.phone_no.contains(q),
  677. )
  678. )
  679. query = apply_pl_scope(query, PlPersonnel, user, db, tenant_no)
  680. query = query.order_by(
  681. case((PlPersonnel.order_num.is_(None), 1), else_=0).asc(),
  682. PlPersonnel.create_time.desc(),
  683. )
  684. total = query.count()
  685. offset = (page - 1) * page_size
  686. rows = query.offset(offset).limit(page_size).all()
  687. return DriverListResponse(
  688. total=total,
  689. list=[_personnel_to_driver_read(p) for p in rows],
  690. )
  691. @router.post("/driver", response_model=DriverRead, status_code=status.HTTP_201_CREATED)
  692. def create_driver(
  693. payload: DriverCreate,
  694. db: Session = Depends(get_db),
  695. user: DbUserContext = Depends(get_db_current_user),
  696. ) -> DriverRead:
  697. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  698. personnel = PlPersonnel(
  699. id=generate_uuid(),
  700. tenant_no=tenant_no,
  701. personnel_name=payload.driver_name,
  702. phone_no=payload.phone_no,
  703. id_card_no=payload.id_card_no,
  704. status="1",
  705. remark=payload.remark,
  706. create_by=user.id,
  707. create_dept_id=user.dept_id,
  708. )
  709. db.add(personnel)
  710. db.commit()
  711. db.refresh(personnel)
  712. return _personnel_to_driver_read(personnel)
  713. @router.get("/driver/{id}", response_model=DriverRead)
  714. def get_driver(
  715. id: str,
  716. db: Session = Depends(get_db),
  717. user: DbUserContext = Depends(get_db_current_user),
  718. ) -> DriverRead:
  719. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  720. personnel = _get_personnel(db, tenant_no, id, user)
  721. return _personnel_to_driver_read(personnel)
  722. @router.put("/driver/{id}", response_model=DriverRead)
  723. def update_driver(
  724. id: str,
  725. payload: DriverUpdate,
  726. db: Session = Depends(get_db),
  727. user: DbUserContext = Depends(get_db_current_user),
  728. ) -> DriverRead:
  729. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  730. personnel = _get_personnel(db, tenant_no, id, user)
  731. if payload.driver_name is not None:
  732. personnel.personnel_name = payload.driver_name
  733. if payload.phone_no is not None:
  734. personnel.phone_no = payload.phone_no
  735. if payload.id_card_no is not None:
  736. personnel.id_card_no = payload.id_card_no
  737. if payload.remark is not None:
  738. personnel.remark = payload.remark
  739. personnel.update_by = user.id
  740. db.commit()
  741. db.refresh(personnel)
  742. return _personnel_to_driver_read(personnel)
  743. @router.delete("/driver/{id}", status_code=status.HTTP_204_NO_CONTENT)
  744. def delete_driver(
  745. id: str,
  746. db: Session = Depends(get_db),
  747. user: DbUserContext = Depends(get_db_current_user),
  748. ) -> None:
  749. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  750. personnel = _get_personnel(db, tenant_no, id, user)
  751. assert_row_deletable_by_creator(personnel, user_info_from_context(user))
  752. personnel.del_flag = 1
  753. personnel.update_by = user.id
  754. db.commit()
  755. # =============================================================================
  756. # 车辆-司机绑定 API(兼容,写入 pl_vehicle_personnel)
  757. # =============================================================================
  758. @router.post("/vehicle-driver", status_code=status.HTTP_201_CREATED)
  759. def bind_vehicle_driver(
  760. payload: VehicleDriverCreate,
  761. db: Session = Depends(get_db),
  762. user: DbUserContext = Depends(get_db_current_user),
  763. ) -> dict:
  764. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  765. _get_vehicle(db, tenant_no, payload.vehicle_id, user)
  766. _get_personnel(db, tenant_no, payload.driver_id, user)
  767. if payload.is_default == 1:
  768. db.query(PlVehiclePersonnel).filter(
  769. PlVehiclePersonnel.vehicle_id == payload.vehicle_id,
  770. PlVehiclePersonnel.role == "driver",
  771. PlVehiclePersonnel.del_flag == 0,
  772. ).update({"is_default": 0})
  773. vd = PlVehiclePersonnel(
  774. id=generate_uuid(),
  775. tenant_no=tenant_no,
  776. vehicle_id=payload.vehicle_id,
  777. personnel_id=payload.driver_id,
  778. role="driver",
  779. is_default=payload.is_default,
  780. create_by=user.id,
  781. create_dept_id=user.dept_id,
  782. )
  783. db.add(vd)
  784. db.commit()
  785. return {"id": vd.id}
  786. @router.delete("/vehicle-driver/{id}", status_code=status.HTTP_204_NO_CONTENT)
  787. def unbind_vehicle_driver(
  788. id: str,
  789. db: Session = Depends(get_db),
  790. user: DbUserContext = Depends(get_db_current_user),
  791. ) -> None:
  792. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  793. vd = (
  794. db.query(PlVehiclePersonnel)
  795. .filter(
  796. PlVehiclePersonnel.id == id,
  797. PlVehiclePersonnel.tenant_no == tenant_no,
  798. PlVehiclePersonnel.del_flag == 0,
  799. )
  800. .first()
  801. )
  802. if not vd:
  803. vd = (
  804. db.query(PlVehicleDriver)
  805. .filter(
  806. PlVehicleDriver.id == id,
  807. PlVehicleDriver.tenant_no == tenant_no,
  808. PlVehicleDriver.del_flag == 0,
  809. )
  810. .first()
  811. )
  812. if vd:
  813. if isinstance(vd, PlVehiclePersonnel):
  814. assert_pl_row_in_scope(db, vd, PlVehiclePersonnel, user, tenant_no)
  815. else:
  816. assert_pl_row_in_scope(db, vd, PlVehicleDriver, user, tenant_no)
  817. assert_row_deletable_by_creator(vd, user_info_from_context(user))
  818. vd.del_flag = 1
  819. db.commit()