vas_task.py 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. from typing import List, Optional
  2. from fastapi import APIRouter, Query, Depends
  3. from sqlalchemy.ext.asyncio import AsyncSession
  4. from app.core.redis import get_redis_client
  5. from app.core.database import get_db
  6. from redis.asyncio import Redis
  7. from app.utils.response import success
  8. from app.schemas.common import ApiResponse, PageResponse
  9. from app.schemas.vas_task import VasExpiringTaskItem, VasTaskOut, VasTaskUpdate
  10. from app.services.vas_task_service import VasTaskService
  11. public_router = APIRouter()
  12. protected_router = APIRouter()
  13. admin_required_router = APIRouter()
  14. @admin_required_router.get("/vas/task/list", summary="获取待执行的任务", tags=["textskin"], response_model=ApiResponse[PageResponse[VasTaskOut]])
  15. async def vas_task_list(
  16. page: int = Query(1, description="第几页"),
  17. size: int = Query(20, description="分页大小"),
  18. keyword: str = Query("", description="查询条件 (可搜任务ID/订单号/路由/商品/客户)"),
  19. status: str = Query("", description="task 状态索引"),
  20. routing_key: str = Query("", description="路由键"),
  21. script_version: str = Query("", description="脚本版本"),
  22. product_id: Optional[int] = Query(None, description="所属商品ID"),
  23. sort_by: str = Query("created_at", description="排序字段: created_at, priority, updated_at, id, order_id"),
  24. sort_order: str = Query("desc", description="排序顺序: desc, asc"),
  25. db: AsyncSession = Depends(get_db)
  26. ):
  27. tasks = await VasTaskService.list_task(
  28. db=db,
  29. status=status,
  30. routing_key=routing_key,
  31. script_version=script_version,
  32. keyword=keyword,
  33. product_id=product_id,
  34. sort_by=sort_by,
  35. sort_order=sort_order,
  36. page=page,
  37. size=size,
  38. )
  39. return success(data=tasks)
  40. @admin_required_router.get("/vas/task/expiring", summary="获取即将过期的任务列表", tags=["textskin"], response_model=ApiResponse[List[VasExpiringTaskItem]])
  41. async def vas_task_get_expiring_tasks(
  42. days: int = 3,
  43. db: AsyncSession = Depends(get_db)
  44. ):
  45. """获取即将过期的任务列表"""
  46. tasks = await VasTaskService.get_expiring_tasks(db, threshold_days=days)
  47. return success(data=tasks)
  48. @admin_required_router.post("/vas/task/update", summary="更新任务数据", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  49. async def vas_task_update(
  50. id: int,
  51. payload: VasTaskUpdate,
  52. db: AsyncSession = Depends(get_db)
  53. ):
  54. task = await VasTaskService.update(db, id, payload)
  55. return success(data=task)
  56. @admin_required_router.get("/vas/task/get_by_order", summary="根据订单查找任务", tags=["textskin"], response_model=ApiResponse[List[VasTaskOut]])
  57. async def vas_task_query_by_order(
  58. order_id: str = Query(..., description="订单编号"),
  59. script_version: str = Query("", description="脚本版本, 用来向后兼容"),
  60. db: AsyncSession = Depends(get_db)
  61. ):
  62. tasks = await VasTaskService.get_task_by_order_id(db, order_id)
  63. return success(data=tasks)
  64. @admin_required_router.post("/vas/task/pause", summary="暂停任务", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  65. async def vas_task_pause(task_id: int, db: AsyncSession = Depends(get_db)):
  66. obj = await VasTaskService.pause(db, task_id)
  67. return success(data=obj)
  68. @admin_required_router.get("/vas/task/detail", summary="根据taskid查找任务", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  69. async def vas_task_query_by_id(
  70. task_id: int = Query(..., description="任务Id"),
  71. db: AsyncSession = Depends(get_db)
  72. ):
  73. task = await VasTaskService.get_task_by_id(db, task_id)
  74. return success(data=task)
  75. @admin_required_router.post("/vas/task/return_to_queue", summary="重新进入等候状态", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  76. async def vas_task_return_to_queue(task_id: int, db: AsyncSession = Depends(get_db)):
  77. obj = await VasTaskService.return_to_queue(db, task_id)
  78. return success(data=obj)
  79. @admin_required_router.post("/vas/task/manual_confirm", summary="设置任务完成", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  80. async def vas_task_manual_confirm(
  81. task_id: int,
  82. db: AsyncSession = Depends(get_db),
  83. redis_client: Redis = Depends(get_redis_client)
  84. ):
  85. obj = await VasTaskService.manual_confirm(db, task_id, redis_client)
  86. return success(data=obj)
  87. @admin_required_router.get("/vas/task/pop", summary="任务出队(pop)", tags=["textskin"], response_model=ApiResponse[VasTaskOut])
  88. async def vas_task_pop_task(
  89. queue_name: str = Query("", description="队列名字"),
  90. cooldown_seconds: int = Query(30, description="冷却时间 默认30秒"),
  91. db: AsyncSession = Depends(get_db),
  92. ):
  93. task = await VasTaskService.pop_vas_task(db, queue_name, cooldown_seconds)
  94. return success(data=task)