public_transport_site.py 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
  1. """运输计划 · 现场按段免登录公共 API(一车多卸)"""
  2. from __future__ import annotations
  3. from typing import Optional
  4. from fastapi import APIRouter, Depends, File, Form, HTTPException, Query, UploadFile
  5. from sqlalchemy.orm import Session
  6. from app.core.database import get_db
  7. from app.core.response import error_response, success_response
  8. from app.models.pl_models import PlTransport
  9. from app.schemas.pl.transport import PublicTransportSiteStopFeedback
  10. from app.services.pl_site_plan_service import (
  11. build_site_history_page,
  12. build_site_page_for_transport,
  13. save_site_feedback_for_transport,
  14. upload_site_attachment_for_transport,
  15. )
  16. router = APIRouter(prefix="/public/pl/transport-site", tags=["运输计划-现场按段公共"])
  17. def _get_transport_by_site_token(db: Session, token: str) -> PlTransport:
  18. transport = (
  19. db.query(PlTransport)
  20. .filter(
  21. PlTransport.site_access_token == token,
  22. PlTransport.del_flag == 0,
  23. )
  24. .first()
  25. )
  26. if not transport:
  27. raise HTTPException(status_code=404, detail="链接无效或已失效")
  28. return transport
  29. @router.get("/{token}/history")
  30. def get_public_transport_site_history(
  31. token: str,
  32. date: str = Query(..., description="筛选日 YYYY-MM-DD"),
  33. q: Optional[str] = Query(None, description="车牌号/产品名称模糊"),
  34. db: Session = Depends(get_db),
  35. ):
  36. transport = _get_transport_by_site_token(db, token)
  37. page, err = build_site_history_page(
  38. db,
  39. tenant_no=transport.tenant_no,
  40. date_str=date,
  41. keyword=q,
  42. license_plate_hint=transport.license_plate,
  43. )
  44. if err:
  45. return error_response(400, err)
  46. return success_response(page.model_dump(by_alias=True))
  47. @router.get("/{token}")
  48. def get_public_transport_site(token: str, db: Session = Depends(get_db)):
  49. transport = _get_transport_by_site_token(db, token)
  50. page = build_site_page_for_transport(db, transport)
  51. return success_response(page.model_dump(by_alias=True))
  52. @router.post("/{token}/feedback")
  53. def save_public_site_stop_feedback(
  54. token: str,
  55. payload: PublicTransportSiteStopFeedback,
  56. db: Session = Depends(get_db),
  57. ):
  58. transport = _get_transport_by_site_token(db, token)
  59. ok, err = save_site_feedback_for_transport(
  60. db,
  61. transport,
  62. stop_type=payload.stop_type,
  63. stop_id=payload.stop_id,
  64. quantity=payload.quantity,
  65. attachment_urls=payload.attachment_urls,
  66. remark=payload.remark,
  67. )
  68. if not ok:
  69. return error_response(400, err or "保存失败")
  70. db.commit()
  71. return success_response({"success": True, "message": "保存成功"})
  72. @router.post("/{token}/attachments")
  73. def upload_public_site_attachment(
  74. token: str,
  75. file: UploadFile = File(...),
  76. folder: Optional[str] = Form(""),
  77. db: Session = Depends(get_db),
  78. ):
  79. transport = _get_transport_by_site_token(db, token)
  80. data, err = upload_site_attachment_for_transport(
  81. db, transport, file=file, folder=folder
  82. )
  83. if err:
  84. code, msg = err
  85. return error_response(code, msg)
  86. return success_response(data)