ticket_tools.py 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. # app/services/agent/tools/builtin/ticket_tools.py
  2. from typing import Optional, Dict, Any, List
  3. from sqlalchemy.ext.asyncio import AsyncSession
  4. from sqlalchemy import select, desc
  5. from app.models.user import VasUser
  6. from app.models.ticket import VasTicket
  7. from app.models.ticket_message import VasTicketMessage
  8. from app.services.ticket_service import TicketService
  9. from app.services.agent.tools.registry import agent_tool
  10. from app.core.logger import logger
  11. ADMIN_CHECK_MSG = "Permission denied: This operation is restricted to system administrators (admin)"
  12. @agent_tool(
  13. name="admin_list_tickets",
  14. description="管理员查询工单列表,支持按工单状态(pending-待处理, info_required-需补充, in_progress-处理中, resolved-已解决, rejected-已拒绝, closed-已关闭)、关联订单号、用户ID或关键词筛选",
  15. )
  16. async def admin_list_tickets(
  17. status: Optional[str] = None,
  18. order_id: Optional[str] = None,
  19. user_id: Optional[str] = None,
  20. keyword: Optional[str] = None,
  21. limit: int = 15,
  22. offset: int = 0,
  23. *,
  24. db: AsyncSession,
  25. current_user: VasUser,
  26. ) -> Dict[str, Any]:
  27. """管理员分页检索工单列表"""
  28. if current_user.role != "admin":
  29. return {"error": ADMIN_CHECK_MSG}
  30. limit = max(1, min(limit, 50))
  31. offset = max(0, offset)
  32. stmt = select(VasTicket)
  33. if status and status.strip():
  34. stmt = stmt.where(VasTicket.status == status.strip().lower())
  35. if order_id and order_id.strip():
  36. stmt = stmt.where(VasTicket.order_id == order_id.strip())
  37. if user_id and user_id.strip():
  38. stmt = stmt.where(VasTicket.user_id == user_id.strip())
  39. if keyword and keyword.strip():
  40. stmt = stmt.where(VasTicket.reason.ilike(f"%{keyword.strip()}%"))
  41. stmt = stmt.order_by(desc(VasTicket.created_at)).offset(offset).limit(limit)
  42. res = await db.execute(stmt)
  43. tickets = res.scalars().all()
  44. items = []
  45. for t in tickets:
  46. items.append({
  47. "ticket_id": t.id,
  48. "order_id": t.order_id,
  49. "user_id": t.user_id,
  50. "type": t.type,
  51. "reason": t.reason,
  52. "status": t.status,
  53. "created_at": t.created_at.strftime("%Y-%m-%d %H:%M:%S") if t.created_at else None,
  54. "updated_at": t.updated_at.strftime("%Y-%m-%d %H:%M:%S") if t.updated_at else None,
  55. })
  56. return {
  57. "count": len(items),
  58. "tickets": items,
  59. }
  60. @agent_tool(
  61. name="get_ticket_detail",
  62. description="获取指定工单ID的完整详细信息及往来沟通对话记录(包含用户描述、客服回复、时间线)",
  63. )
  64. async def get_ticket_detail(
  65. ticket_id: int,
  66. *,
  67. db: AsyncSession,
  68. current_user: VasUser,
  69. ) -> Dict[str, Any]:
  70. """获取指定工单详情与对话记录"""
  71. t = await db.get(VasTicket, ticket_id)
  72. if not t:
  73. return {"error": f"Ticket #{ticket_id} does not exist"}
  74. if current_user.role != "admin" and str(t.user_id) != str(current_user.id):
  75. return {"error": "Permission denied: You cannot view this ticket"}
  76. # 查往来对话消息
  77. msg_stmt = (
  78. select(VasTicketMessage)
  79. .where(VasTicketMessage.ticket_id == ticket_id)
  80. .order_by(VasTicketMessage.created_at.asc())
  81. )
  82. msg_res = await db.execute(msg_stmt)
  83. messages = msg_res.scalars().all()
  84. msg_items = []
  85. for m in messages:
  86. msg_items.append({
  87. "id": m.id,
  88. "sender_type": m.sender_type,
  89. "sender_id": m.sender_id,
  90. "content": m.content,
  91. "created_at": m.created_at.strftime("%Y-%m-%d %H:%M:%S") if m.created_at else None,
  92. })
  93. return {
  94. "ticket_id": t.id,
  95. "order_id": t.order_id,
  96. "user_id": t.user_id,
  97. "type": t.type,
  98. "reason": t.reason,
  99. "status": t.status,
  100. "created_at": t.created_at.strftime("%Y-%m-%d %H:%M:%S") if t.created_at else None,
  101. "updated_at": t.updated_at.strftime("%Y-%m-%d %H:%M:%S") if t.updated_at else None,
  102. "messages_count": len(msg_items),
  103. "messages": msg_items,
  104. }
  105. @agent_tool(
  106. name="admin_reply_ticket",
  107. description="以官方管理员/客服身份在指定工单中回复用户消息,支持解答疑问或通知补件",
  108. is_dangerous=True,
  109. )
  110. async def admin_reply_ticket(
  111. ticket_id: int,
  112. content: str,
  113. *,
  114. db: AsyncSession,
  115. current_user: VasUser,
  116. ) -> Dict[str, Any]:
  117. """管理员回复工单"""
  118. if current_user.role != "admin":
  119. return {"error": ADMIN_CHECK_MSG}
  120. clean_content = content.strip()
  121. if not clean_content:
  122. return {"error": "Reply content cannot be empty"}
  123. try:
  124. msg = await TicketService.add_message(
  125. db=db,
  126. ticket_id=ticket_id,
  127. sender_type="admin",
  128. sender_id=str(current_user.id),
  129. content=clean_content,
  130. )
  131. return {
  132. "success": True,
  133. "ticket_id": ticket_id,
  134. "message_id": msg.id,
  135. "content": msg.content,
  136. "created_at": msg.created_at.strftime("%Y-%m-%d %H:%M:%S"),
  137. }
  138. except Exception as e:
  139. return {"error": f"Failed to reply ticket #{ticket_id}: {str(e)}"}
  140. @agent_tool(
  141. name="admin_update_ticket_status",
  142. description="更新工单处理状态(pending-待处理, info_required-需补充, in_progress-处理中, resolved-已解决, rejected-已拒绝, closed-已关闭)",
  143. is_dangerous=True,
  144. )
  145. async def admin_update_ticket_status(
  146. ticket_id: int,
  147. status: str,
  148. note: Optional[str] = None,
  149. *,
  150. db: AsyncSession,
  151. current_user: VasUser,
  152. ) -> Dict[str, Any]:
  153. """管理员更改工单状态"""
  154. if current_user.role != "admin":
  155. return {"error": ADMIN_CHECK_MSG}
  156. clean_status = status.strip().lower()
  157. valid_statuses = {"pending", "info_required", "in_progress", "resolved", "rejected", "closed"}
  158. if clean_status not in valid_statuses:
  159. return {"error": f"Invalid ticket status '{clean_status}'. Valid statuses: {sorted(list(valid_statuses))}"}
  160. try:
  161. ticket = await TicketService.update_status(
  162. db=db,
  163. ticket_id=ticket_id,
  164. status=clean_status,
  165. comment=note or "",
  166. admin_id=str(current_user.id),
  167. )
  168. if note and note.strip():
  169. await TicketService.add_message(
  170. db=db,
  171. ticket_id=ticket_id,
  172. sender_type="system",
  173. content=f"系统状态变更为 [{clean_status}]: {note.strip()}",
  174. )
  175. return {
  176. "success": True,
  177. "ticket_id": ticket.id,
  178. "new_status": ticket.status,
  179. "updated_at": ticket.updated_at.strftime("%Y-%m-%d %H:%M:%S") if ticket.updated_at else None,
  180. }
  181. except Exception as e:
  182. return {"error": f"Failed to update status for ticket #{ticket_id}: {str(e)}"}