advance.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268
  1. from typing import List, Optional
  2. from fastapi import APIRouter, Depends, HTTPException, status
  3. from sqlalchemy import or_, func
  4. from sqlalchemy.orm import Session
  5. from app.database import get_db
  6. from app.core.deps import get_current_user
  7. from app.models.user import User
  8. from app.models.advance import AdvanceApply
  9. from app.models.reimburse import ReimburseOffset
  10. from app.schemas.common import ApiResponse, PagedData
  11. from app.schemas.advance import (
  12. AdvanceApplyCreate,
  13. AdvanceApplyUpdate,
  14. AdvanceApplyOut,
  15. AdvanceApprovalCreate,
  16. AdvanceApprovalOut,
  17. AdvanceMyStatsOut,
  18. AdvanceApproverPendingStatsOut,
  19. )
  20. from app.services.advance import AdvanceService
  21. from app.services.expense_item import ExpenseItemService
  22. from app.models.workflow import WorkflowDef
  23. from app.utils.codegen import generate_apply_code
  24. from app.utils.date_range import build_create_time_filters
  25. router = APIRouter(prefix="/api/advances", tags=["备用金管理"])
  26. @router.get("/", response_model=ApiResponse[PagedData[AdvanceApplyOut]])
  27. def list_advances(
  28. page: int = 1,
  29. pageSize: int = 10,
  30. status: str | None = None,
  31. keyword: str = "",
  32. applicantId: Optional[int] = None,
  33. applyDate: Optional[str] = None,
  34. applyDateStart: Optional[str] = None,
  35. applyDateEnd: Optional[str] = None,
  36. db: Session = Depends(get_db),
  37. current_user: User = Depends(get_current_user),
  38. ):
  39. filters = [AdvanceApply.del_flag == 0]
  40. if status:
  41. filters.append(AdvanceApply.status == status)
  42. if keyword:
  43. filters.append(or_(AdvanceApply.apply_code.contains(keyword), AdvanceApply.applicant_name.contains(keyword)))
  44. if applicantId is not None:
  45. filters.append(AdvanceApply.applicant_id == applicantId)
  46. filters.extend(
  47. build_create_time_filters(
  48. AdvanceApply.create_time, applyDate, applyDateStart, applyDateEnd
  49. )
  50. )
  51. rows, total = AdvanceService.get_paged(db, page=page, page_size=pageSize, filters=filters)
  52. out_rows = [AdvanceApplyOut.model_validate(r) for r in rows]
  53. if out_rows:
  54. offset_map = dict(
  55. db.query(ReimburseOffset.advance_id, func.coalesce(func.sum(ReimburseOffset.offset_amount), 0))
  56. .filter(ReimburseOffset.advance_id.in_([r.id for r in rows]))
  57. .group_by(ReimburseOffset.advance_id)
  58. .all()
  59. )
  60. for out_row in out_rows:
  61. out_row.offset_amount = float(offset_map.get(out_row.id, 0))
  62. paged_data = PagedData(rows=out_rows, total=total, page=page, page_size=pageSize)
  63. return ApiResponse(data=paged_data)
  64. @router.get("/my", response_model=ApiResponse[PagedData[AdvanceApplyOut]])
  65. def my_advances(
  66. page: int = 1,
  67. pageSize: int = 10,
  68. status: str | None = None,
  69. keyword: str = "",
  70. applyDate: Optional[str] = None,
  71. applyDateStart: Optional[str] = None,
  72. applyDateEnd: Optional[str] = None,
  73. db: Session = Depends(get_db),
  74. current_user: User = Depends(get_current_user),
  75. ):
  76. filters = [AdvanceApply.del_flag == 0, AdvanceApply.applicant_id == current_user.id]
  77. if status:
  78. filters.append(AdvanceApply.status == status)
  79. if keyword:
  80. filters.append(or_(AdvanceApply.apply_code.contains(keyword), AdvanceApply.applicant_name.contains(keyword)))
  81. filters.extend(
  82. build_create_time_filters(
  83. AdvanceApply.create_time, applyDate, applyDateStart, applyDateEnd
  84. )
  85. )
  86. rows, total = AdvanceService.get_paged(db, page=page, page_size=pageSize, filters=filters)
  87. out_rows = [AdvanceApplyOut.model_validate(r) for r in rows]
  88. if out_rows:
  89. offset_map = dict(
  90. db.query(ReimburseOffset.advance_id, func.coalesce(func.sum(ReimburseOffset.offset_amount), 0))
  91. .filter(ReimburseOffset.advance_id.in_([r.id for r in rows]))
  92. .group_by(ReimburseOffset.advance_id)
  93. .all()
  94. )
  95. for out_row in out_rows:
  96. out_row.offset_amount = float(offset_map.get(out_row.id, 0))
  97. paged_data = PagedData(rows=out_rows, total=total, page=page, page_size=pageSize)
  98. return ApiResponse(data=paged_data)
  99. @router.get("/my/stats", response_model=ApiResponse[AdvanceMyStatsOut])
  100. def my_advance_stats(
  101. db: Session = Depends(get_db),
  102. current_user: User = Depends(get_current_user),
  103. ):
  104. data = AdvanceService.my_apply_stats(db, current_user.id)
  105. return ApiResponse(data=AdvanceMyStatsOut.model_validate(data))
  106. @router.get("/stats/status-counts", response_model=ApiResponse[dict])
  107. def advance_status_counts(
  108. db: Session = Depends(get_db),
  109. current_user: User = Depends(get_current_user),
  110. ):
  111. return ApiResponse(data=AdvanceService.global_status_counts(db))
  112. @router.get("/pending-approval", response_model=ApiResponse[PagedData[AdvanceApplyOut]])
  113. def pending_approval(
  114. page: int = 1,
  115. pageSize: int = 10,
  116. keyword: str = "",
  117. applicantId: Optional[int] = None,
  118. applyDate: Optional[str] = None,
  119. applyDateStart: Optional[str] = None,
  120. applyDateEnd: Optional[str] = None,
  121. db: Session = Depends(get_db),
  122. current_user: User = Depends(get_current_user),
  123. ):
  124. rows, total = AdvanceService.pending_approval(
  125. db,
  126. current_user,
  127. page=page,
  128. page_size=pageSize,
  129. keyword=keyword,
  130. applicant_id=applicantId,
  131. apply_date=applyDate,
  132. apply_date_start=applyDateStart,
  133. apply_date_end=applyDateEnd,
  134. )
  135. out_rows = [AdvanceApplyOut.model_validate(r) for r in rows]
  136. paged_data = PagedData(rows=out_rows, total=total, page=page, page_size=pageSize)
  137. return ApiResponse(data=paged_data)
  138. @router.get("/pending-approval/stats", response_model=ApiResponse[AdvanceApproverPendingStatsOut])
  139. def advance_pending_approval_stats(
  140. db: Session = Depends(get_db),
  141. current_user: User = Depends(get_current_user),
  142. ):
  143. data = AdvanceService.pending_approval_stats(db, current_user)
  144. return ApiResponse(data=AdvanceApproverPendingStatsOut.model_validate(data))
  145. @router.get("/approved-by-me", response_model=ApiResponse[PagedData[AdvanceApplyOut]])
  146. def approved_by_me(
  147. page: int = 1,
  148. pageSize: int = 10,
  149. keyword: str = "",
  150. applicantId: Optional[int] = None,
  151. applyDate: Optional[str] = None,
  152. applyDateStart: Optional[str] = None,
  153. applyDateEnd: Optional[str] = None,
  154. db: Session = Depends(get_db),
  155. current_user: User = Depends(get_current_user),
  156. ):
  157. rows, total = AdvanceService.approved_by_me(
  158. db,
  159. current_user,
  160. page=page,
  161. page_size=pageSize,
  162. keyword=keyword,
  163. applicant_id=applicantId,
  164. apply_date=applyDate,
  165. apply_date_start=applyDateStart,
  166. apply_date_end=applyDateEnd,
  167. )
  168. out_rows = [AdvanceApplyOut.model_validate(r) for r in rows]
  169. paged_data = PagedData(rows=out_rows, total=total, page=page, page_size=pageSize)
  170. return ApiResponse(data=paged_data)
  171. @router.get("/{advance_id}", response_model=ApiResponse[AdvanceApplyOut])
  172. def get_advance(advance_id: int, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  173. advance = AdvanceService.get_by_id(db, advance_id)
  174. if not advance:
  175. raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="备用金申请不存在")
  176. out = AdvanceApplyOut.model_validate(advance)
  177. total_offset = (
  178. db.query(func.coalesce(func.sum(ReimburseOffset.offset_amount), 0))
  179. .filter(ReimburseOffset.advance_id == advance_id)
  180. .scalar()
  181. )
  182. out.offset_amount = float(total_offset or 0)
  183. return ApiResponse(data=out)
  184. @router.get("/{advance_id}/approvals", response_model=ApiResponse[List[AdvanceApprovalOut]])
  185. def get_approvals(advance_id: int, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  186. approvals = AdvanceService.get_approvals(db, advance_id)
  187. return ApiResponse(data=[AdvanceApprovalOut.model_validate(a) for a in approvals])
  188. @router.post("/", response_model=ApiResponse[AdvanceApplyOut])
  189. def create_advance(body: AdvanceApplyCreate, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  190. data = body.model_dump(exclude_unset=True)
  191. eid = data.get("expense_item_id")
  192. if eid is not None:
  193. if not ExpenseItemService.get_by_id(db, int(eid)):
  194. raise HTTPException(status_code=status.HTTP_400_BAD_REQUEST, detail=f"费用项目 {eid} 不存在")
  195. data["applicant_id"] = current_user.id
  196. data["applicant_name"] = current_user.real_name or current_user.username
  197. data["apply_code"] = generate_apply_code(db, "BYJ")
  198. data["status"] = "draft"
  199. wf = db.query(WorkflowDef).filter(WorkflowDef.biz_type == "advance", WorkflowDef.del_flag == 0).first()
  200. if wf:
  201. data["wf_id"] = wf.id
  202. advance = AdvanceService.create(db, data)
  203. return ApiResponse(data=AdvanceApplyOut.model_validate(advance))
  204. @router.put("/{advance_id}", response_model=ApiResponse[AdvanceApplyOut])
  205. def update_advance(advance_id: int, body: AdvanceApplyUpdate, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  206. data = body.model_dump(exclude_unset=True)
  207. if "expense_item_id" in data and data["expense_item_id"] is not None:
  208. eid = int(data["expense_item_id"])
  209. if not ExpenseItemService.get_by_id(db, eid):
  210. raise HTTPException(status_code=status.HTTP_400_BAD_REQUEST, detail=f"费用项目 {eid} 不存在")
  211. advance = AdvanceService.update(db, advance_id, data)
  212. if not advance:
  213. raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="备用金申请不存在")
  214. return ApiResponse(data=AdvanceApplyOut.model_validate(advance))
  215. @router.post("/{advance_id}/submit", response_model=ApiResponse[AdvanceApplyOut])
  216. def submit_advance(advance_id: int, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  217. advance = AdvanceService.submit(db, advance_id, current_user)
  218. if not advance:
  219. raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="备用金申请不存在")
  220. return ApiResponse(data=AdvanceApplyOut.model_validate(advance))
  221. @router.post("/{advance_id}/approve", response_model=ApiResponse[AdvanceApplyOut])
  222. def approve_advance(advance_id: int, body: AdvanceApprovalCreate, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  223. advance = AdvanceService.approve(db, advance_id, current_user, body.approval_opinion or "")
  224. if not advance:
  225. raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="备用金申请不存在")
  226. return ApiResponse(data=AdvanceApplyOut.model_validate(advance))
  227. @router.post("/{advance_id}/reject", response_model=ApiResponse[AdvanceApplyOut])
  228. def reject_advance(advance_id: int, body: AdvanceApprovalCreate, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  229. advance = AdvanceService.reject(db, advance_id, current_user, body.approval_opinion or "")
  230. if not advance:
  231. raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="备用金申请不存在")
  232. return ApiResponse(data=AdvanceApplyOut.model_validate(advance))
  233. @router.delete("/{advance_id}", response_model=ApiResponse[None])
  234. def delete_advance(advance_id: int, db: Session = Depends(get_db), current_user: User = Depends(get_current_user)):
  235. AdvanceService.soft_delete(db, advance_id)
  236. return ApiResponse(data=None)