vehicle_recharge.py 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355
  1. """车辆 ETC/加油充值 API"""
  2. from datetime import date, datetime
  3. from typing import List, Optional
  4. from pydantic import BaseModel, Field
  5. from fastapi import APIRouter, Depends, HTTPException, Query, status
  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.tenant_context import get_tenant_no
  10. from app.utils.excel_export import (
  11. EXPORT_MAX_ROWS,
  12. ExportColumn,
  13. ExportValidationError,
  14. export_rows_to_xlsx_response,
  15. filter_export_columns,
  16. )
  17. from app.schemas.pl.vehicle_recharge import (
  18. VehicleRechargeApplyCreate,
  19. VehicleRechargeApplyListResponse,
  20. VehicleRechargeApplyOption,
  21. VehicleRechargeApplyRead,
  22. VehicleRechargeApplyUpdate,
  23. VehicleRechargeDisburseBoardListResponse,
  24. VehicleRechargeRecordCreate,
  25. VehicleRechargeRecordListResponse,
  26. VehicleRechargeRecordRead,
  27. VehicleRechargeRecordUpdate,
  28. )
  29. from app.services import pl_vehicle_recharge_service as svc
  30. apply_router = APIRouter(prefix="/vehicle-recharge-apply", tags=["运输计划-ETC加油申请"])
  31. record_router = APIRouter(prefix="/vehicle-recharge-record", tags=["运输计划-ETC加油发放"])
  32. @apply_router.get("/", response_model=VehicleRechargeApplyListResponse)
  33. def list_applies(
  34. q: Optional[str] = Query(default=None),
  35. recharge_type: Optional[str] = Query(default=None, alias="rechargeType"),
  36. status: Optional[str] = Query(default=None),
  37. apply_date_from: Optional[date] = Query(default=None, alias="applyDateFrom"),
  38. apply_date_to: Optional[date] = Query(default=None, alias="applyDateTo"),
  39. applicant_id: Optional[str] = Query(default=None, alias="applicantId"),
  40. page: int = Query(default=1, ge=1),
  41. page_size: int = Query(default=20, ge=1, le=500, alias="pageSize"),
  42. db: Session = Depends(get_db),
  43. user: DbUserContext = Depends(get_db_current_user),
  44. ) -> VehicleRechargeApplyListResponse:
  45. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  46. items, total = svc.list_applies(
  47. db,
  48. tenant_no,
  49. user,
  50. q=q,
  51. recharge_type=recharge_type,
  52. status=status,
  53. apply_date_from=apply_date_from,
  54. apply_date_to=apply_date_to,
  55. applicant_id=applicant_id,
  56. page=page,
  57. page_size=page_size,
  58. )
  59. return VehicleRechargeApplyListResponse(
  60. items=items, total=total, page=page, pageSize=page_size
  61. )
  62. @apply_router.get("/pending-options", response_model=list[VehicleRechargeApplyOption])
  63. def pending_apply_options(
  64. db: Session = Depends(get_db),
  65. user: DbUserContext = Depends(get_db_current_user),
  66. ) -> list[VehicleRechargeApplyOption]:
  67. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  68. rows = svc.list_pending_apply_options(db, tenant_no, user)
  69. return [VehicleRechargeApplyOption.model_validate(row) for row in rows]
  70. RECHARGE_APPLY_EXPORT_COLUMNS = [
  71. ExportColumn(title="申请单号", field="applyNo"),
  72. ExportColumn(title="车牌号", field="licensePlate"),
  73. ExportColumn(title="充值类型", field="rechargeType"),
  74. ExportColumn(title="申请日期", field="applyDate"),
  75. ExportColumn(title="期初公里数", field="odometerKm"),
  76. ExportColumn(title="申请人", field="applicantName"),
  77. ExportColumn(title="状态", field="status"),
  78. ExportColumn(title="创建时间", field="createTime"),
  79. ]
  80. class RechargeApplyExportBody(BaseModel):
  81. q: Optional[str] = None
  82. recharge_type: Optional[str] = Field(default=None, alias="rechargeType")
  83. status: Optional[str] = None
  84. apply_date_from: Optional[date] = Field(default=None, alias="applyDateFrom")
  85. apply_date_to: Optional[date] = Field(default=None, alias="applyDateTo")
  86. ids: Optional[List[str]] = None
  87. columns: Optional[List[str]] = None
  88. model_config = {"populate_by_name": True}
  89. @apply_router.post("/export")
  90. def export_recharge_applies(
  91. body: RechargeApplyExportBody,
  92. db: Session = Depends(get_db),
  93. user: DbUserContext = Depends(get_db_current_user),
  94. ):
  95. try:
  96. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  97. items, _ = svc.list_applies(
  98. db, tenant_no, user,
  99. q=body.q, recharge_type=body.recharge_type, status=body.status,
  100. apply_date_from=body.apply_date_from, apply_date_to=body.apply_date_to,
  101. ids=body.ids, page=1, page_size=EXPORT_MAX_ROWS, max_page_size=EXPORT_MAX_ROWS,
  102. )
  103. rows = []
  104. for item in items:
  105. data = item.model_dump(by_alias=True)
  106. for k, v in list(data.items()):
  107. if hasattr(v, 'isoformat'):
  108. data[k] = str(v)[:19]
  109. rows.append(data)
  110. cols = filter_export_columns(RECHARGE_APPLY_EXPORT_COLUMNS, body.columns)
  111. date_str = datetime.now().strftime("%Y%m%d")
  112. return export_rows_to_xlsx_response(
  113. db, tenant_no=tenant_no, sheet_title="充值申请", columns=cols, rows=rows,
  114. filename_stem=f"充值申请_{date_str}",
  115. )
  116. except ExportValidationError as e:
  117. raise HTTPException(status_code=400, detail=str(e)) from e
  118. @apply_router.get("/{id}", response_model=VehicleRechargeApplyRead)
  119. def get_apply(
  120. id: str,
  121. db: Session = Depends(get_db),
  122. user: DbUserContext = Depends(get_db_current_user),
  123. ) -> VehicleRechargeApplyRead:
  124. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  125. return svc.get_apply(db, tenant_no, user, id)
  126. @apply_router.post("/", response_model=VehicleRechargeApplyRead, status_code=status.HTTP_201_CREATED)
  127. def create_apply(
  128. payload: VehicleRechargeApplyCreate,
  129. db: Session = Depends(get_db),
  130. user: DbUserContext = Depends(get_db_current_user),
  131. ) -> VehicleRechargeApplyRead:
  132. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  133. return svc.create_apply(db, tenant_no, user, payload)
  134. @apply_router.put("/{id}", response_model=VehicleRechargeApplyRead)
  135. def update_apply(
  136. id: str,
  137. payload: VehicleRechargeApplyUpdate,
  138. db: Session = Depends(get_db),
  139. user: DbUserContext = Depends(get_db_current_user),
  140. ) -> VehicleRechargeApplyRead:
  141. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  142. return svc.update_apply(db, tenant_no, user, id, payload)
  143. @apply_router.post("/{id}/cancel", response_model=VehicleRechargeApplyRead)
  144. def cancel_apply(
  145. id: str,
  146. db: Session = Depends(get_db),
  147. user: DbUserContext = Depends(get_db_current_user),
  148. ) -> VehicleRechargeApplyRead:
  149. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  150. return svc.cancel_apply(db, tenant_no, user, id)
  151. @apply_router.delete("/{ids}", status_code=status.HTTP_204_NO_CONTENT)
  152. def delete_applies(
  153. ids: str,
  154. db: Session = Depends(get_db),
  155. user: DbUserContext = Depends(get_db_current_user),
  156. ) -> None:
  157. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  158. apply_ids = [item for item in ids.split(",") if item]
  159. svc.delete_applies(db, tenant_no, user, apply_ids)
  160. @record_router.get("/", response_model=VehicleRechargeRecordListResponse)
  161. def list_records(
  162. q: Optional[str] = Query(default=None),
  163. recharge_type: Optional[str] = Query(default=None, alias="rechargeType"),
  164. recharge_date_from: Optional[date] = Query(default=None, alias="rechargeDateFrom"),
  165. recharge_date_to: Optional[date] = Query(default=None, alias="rechargeDateTo"),
  166. gas_station: Optional[str] = Query(default=None, alias="gasStation"),
  167. apply_no: Optional[str] = Query(default=None, alias="applyNo"),
  168. page: int = Query(default=1, ge=1),
  169. page_size: int = Query(default=20, ge=1, le=500, alias="pageSize"),
  170. db: Session = Depends(get_db),
  171. user: DbUserContext = Depends(get_db_current_user),
  172. ) -> VehicleRechargeRecordListResponse:
  173. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  174. items, total = svc.list_records(
  175. db,
  176. tenant_no,
  177. user,
  178. q=q,
  179. recharge_type=recharge_type,
  180. recharge_date_from=recharge_date_from,
  181. recharge_date_to=recharge_date_to,
  182. gas_station=gas_station,
  183. apply_no=apply_no,
  184. page=page,
  185. page_size=page_size,
  186. )
  187. return VehicleRechargeRecordListResponse(
  188. items=items, total=total, page=page, pageSize=page_size
  189. )
  190. @record_router.get("/disburse-board", response_model=VehicleRechargeDisburseBoardListResponse)
  191. def list_disburse_board(
  192. q: Optional[str] = Query(default=None),
  193. recharge_type: Optional[str] = Query(default=None, alias="rechargeType"),
  194. apply_status: Optional[str] = Query(default=None, alias="applyStatus"),
  195. apply_date_from: Optional[date] = Query(default=None, alias="applyDateFrom"),
  196. apply_date_to: Optional[date] = Query(default=None, alias="applyDateTo"),
  197. recharge_date_from: Optional[date] = Query(default=None, alias="rechargeDateFrom"),
  198. recharge_date_to: Optional[date] = Query(default=None, alias="rechargeDateTo"),
  199. page: int = Query(default=1, ge=1),
  200. page_size: int = Query(default=20, ge=1, le=500, alias="pageSize"),
  201. db: Session = Depends(get_db),
  202. user: DbUserContext = Depends(get_db_current_user),
  203. ) -> VehicleRechargeDisburseBoardListResponse:
  204. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  205. items, total = svc.list_disburse_board(
  206. db,
  207. tenant_no,
  208. user,
  209. q=q,
  210. recharge_type=recharge_type,
  211. apply_status=apply_status,
  212. apply_date_from=apply_date_from,
  213. apply_date_to=apply_date_to,
  214. recharge_date_from=recharge_date_from,
  215. recharge_date_to=recharge_date_to,
  216. page=page,
  217. page_size=page_size,
  218. )
  219. return VehicleRechargeDisburseBoardListResponse(
  220. items=items, total=total, page=page, pageSize=page_size
  221. )
  222. RECHARGE_DISBURSE_EXPORT_COLUMNS = [
  223. ExportColumn(title="申请单号", field="applyNo"),
  224. ExportColumn(title="车牌号", field="licensePlate"),
  225. ExportColumn(title="充值类型", field="rechargeType"),
  226. ExportColumn(title="申请日期", field="applyDate"),
  227. ExportColumn(title="申请人", field="applicantName"),
  228. ExportColumn(title="申请状态", field="applyStatus"),
  229. ExportColumn(title="期初公里数", field="odometerKm"),
  230. ExportColumn(title="充值日期", field="rechargeDate"),
  231. ExportColumn(title="充值金额", field="amount"),
  232. ExportColumn(title="加油站", field="gasStation"),
  233. ]
  234. class RechargeDisburseExportBody(BaseModel):
  235. q: Optional[str] = None
  236. recharge_type: Optional[str] = Field(default=None, alias="rechargeType")
  237. apply_status: Optional[str] = Field(default=None, alias="applyStatus")
  238. apply_date_from: Optional[date] = Field(default=None, alias="applyDateFrom")
  239. apply_date_to: Optional[date] = Field(default=None, alias="applyDateTo")
  240. recharge_date_from: Optional[date] = Field(default=None, alias="rechargeDateFrom")
  241. recharge_date_to: Optional[date] = Field(default=None, alias="rechargeDateTo")
  242. ids: Optional[List[str]] = None
  243. columns: Optional[List[str]] = None
  244. model_config = {"populate_by_name": True}
  245. @record_router.post("/disburse-board/export")
  246. def export_recharge_disburse_board(
  247. body: RechargeDisburseExportBody,
  248. db: Session = Depends(get_db),
  249. user: DbUserContext = Depends(get_db_current_user),
  250. ):
  251. try:
  252. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  253. items, _ = svc.list_disburse_board(
  254. db, tenant_no, user,
  255. q=body.q, recharge_type=body.recharge_type, apply_status=body.apply_status,
  256. apply_date_from=body.apply_date_from, apply_date_to=body.apply_date_to,
  257. recharge_date_from=body.recharge_date_from, recharge_date_to=body.recharge_date_to,
  258. ids=body.ids, page=1, page_size=EXPORT_MAX_ROWS, max_page_size=EXPORT_MAX_ROWS,
  259. )
  260. rows = []
  261. for item in items:
  262. data = item.model_dump(by_alias=True)
  263. for k, v in list(data.items()):
  264. if hasattr(v, 'isoformat'):
  265. data[k] = str(v)[:19]
  266. rows.append(data)
  267. cols = filter_export_columns(RECHARGE_DISBURSE_EXPORT_COLUMNS, body.columns)
  268. date_str = datetime.now().strftime("%Y%m%d")
  269. return export_rows_to_xlsx_response(
  270. db, tenant_no=tenant_no, sheet_title="充值发放", columns=cols, rows=rows,
  271. filename_stem=f"充值发放_{date_str}",
  272. )
  273. except ExportValidationError as e:
  274. raise HTTPException(status_code=400, detail=str(e)) from e
  275. @record_router.get("/{id}", response_model=VehicleRechargeRecordRead)
  276. def get_record(
  277. id: str,
  278. db: Session = Depends(get_db),
  279. user: DbUserContext = Depends(get_db_current_user),
  280. ) -> VehicleRechargeRecordRead:
  281. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  282. return svc.get_record(db, tenant_no, user, id)
  283. @record_router.post("/", response_model=VehicleRechargeRecordRead, status_code=status.HTTP_201_CREATED)
  284. def create_record(
  285. payload: VehicleRechargeRecordCreate,
  286. db: Session = Depends(get_db),
  287. user: DbUserContext = Depends(get_db_current_user),
  288. ) -> VehicleRechargeRecordRead:
  289. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  290. return svc.create_record(db, tenant_no, user, payload)
  291. @record_router.put("/{id}", response_model=VehicleRechargeRecordRead)
  292. def update_record(
  293. id: str,
  294. payload: VehicleRechargeRecordUpdate,
  295. db: Session = Depends(get_db),
  296. user: DbUserContext = Depends(get_db_current_user),
  297. ) -> VehicleRechargeRecordRead:
  298. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  299. return svc.update_record(db, tenant_no, user, id, payload)
  300. @record_router.delete("/{ids}", status_code=status.HTTP_204_NO_CONTENT)
  301. def delete_records(
  302. ids: str,
  303. db: Session = Depends(get_db),
  304. user: DbUserContext = Depends(get_db_current_user),
  305. ) -> None:
  306. tenant_no = get_tenant_no(db, user.to_tenant_user_dict())
  307. record_ids = [item for item in ids.split(",") if item]
  308. svc.delete_records(db, tenant_no, user, record_ids)