| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 |
- # app/services/agent/tools/builtin/ticket_tools.py
- from typing import Optional, Dict, Any, List
- from sqlalchemy.ext.asyncio import AsyncSession
- from sqlalchemy import select, desc
- from app.models.user import VasUser
- from app.models.ticket import VasTicket
- from app.models.ticket_message import VasTicketMessage
- from app.services.ticket_service import TicketService
- from app.services.agent.tools.registry import agent_tool
- from app.core.logger import logger
- ADMIN_CHECK_MSG = "Permission denied: This operation is restricted to system administrators (admin)"
- @agent_tool(
- name="admin_list_tickets",
- description="管理员查询工单列表,支持按工单状态(pending-待处理, info_required-需补充, in_progress-处理中, resolved-已解决, rejected-已拒绝, closed-已关闭)、关联订单号、用户ID或关键词筛选",
- )
- async def admin_list_tickets(
- status: Optional[str] = None,
- order_id: Optional[str] = None,
- user_id: Optional[str] = None,
- keyword: Optional[str] = None,
- limit: int = 15,
- offset: int = 0,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """管理员分页检索工单列表"""
- if current_user.role != "admin":
- return {"error": ADMIN_CHECK_MSG}
- limit = max(1, min(limit, 50))
- offset = max(0, offset)
- stmt = select(VasTicket)
- if status and status.strip():
- stmt = stmt.where(VasTicket.status == status.strip().lower())
- if order_id and order_id.strip():
- stmt = stmt.where(VasTicket.order_id == order_id.strip())
- if user_id and user_id.strip():
- stmt = stmt.where(VasTicket.user_id == user_id.strip())
- if keyword and keyword.strip():
- stmt = stmt.where(VasTicket.reason.ilike(f"%{keyword.strip()}%"))
- stmt = stmt.order_by(desc(VasTicket.created_at)).offset(offset).limit(limit)
- res = await db.execute(stmt)
- tickets = res.scalars().all()
- items = []
- for t in tickets:
- items.append({
- "ticket_id": t.id,
- "order_id": t.order_id,
- "user_id": t.user_id,
- "type": t.type,
- "reason": t.reason,
- "status": t.status,
- "created_at": t.created_at.strftime("%Y-%m-%d %H:%M:%S") if t.created_at else None,
- "updated_at": t.updated_at.strftime("%Y-%m-%d %H:%M:%S") if t.updated_at else None,
- })
- return {
- "count": len(items),
- "tickets": items,
- }
- @agent_tool(
- name="get_ticket_detail",
- description="获取指定工单ID的完整详细信息及往来沟通对话记录(包含用户描述、客服回复、时间线)",
- )
- async def get_ticket_detail(
- ticket_id: int,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """获取指定工单详情与对话记录"""
- t = await db.get(VasTicket, ticket_id)
- if not t:
- return {"error": f"Ticket #{ticket_id} does not exist"}
- if current_user.role != "admin" and str(t.user_id) != str(current_user.id):
- return {"error": "Permission denied: You cannot view this ticket"}
- # 查往来对话消息
- msg_stmt = (
- select(VasTicketMessage)
- .where(VasTicketMessage.ticket_id == ticket_id)
- .order_by(VasTicketMessage.created_at.asc())
- )
- msg_res = await db.execute(msg_stmt)
- messages = msg_res.scalars().all()
- msg_items = []
- for m in messages:
- msg_items.append({
- "id": m.id,
- "sender_type": m.sender_type,
- "sender_id": m.sender_id,
- "content": m.content,
- "created_at": m.created_at.strftime("%Y-%m-%d %H:%M:%S") if m.created_at else None,
- })
- return {
- "ticket_id": t.id,
- "order_id": t.order_id,
- "user_id": t.user_id,
- "type": t.type,
- "reason": t.reason,
- "status": t.status,
- "created_at": t.created_at.strftime("%Y-%m-%d %H:%M:%S") if t.created_at else None,
- "updated_at": t.updated_at.strftime("%Y-%m-%d %H:%M:%S") if t.updated_at else None,
- "messages_count": len(msg_items),
- "messages": msg_items,
- }
- @agent_tool(
- name="admin_reply_ticket",
- description="以官方管理员/客服身份在指定工单中回复用户消息,支持解答疑问或通知补件",
- is_dangerous=True,
- )
- async def admin_reply_ticket(
- ticket_id: int,
- content: str,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """管理员回复工单"""
- if current_user.role != "admin":
- return {"error": ADMIN_CHECK_MSG}
- clean_content = content.strip()
- if not clean_content:
- return {"error": "Reply content cannot be empty"}
- try:
- msg = await TicketService.add_message(
- db=db,
- ticket_id=ticket_id,
- sender_type="admin",
- sender_id=str(current_user.id),
- content=clean_content,
- )
- return {
- "success": True,
- "ticket_id": ticket_id,
- "message_id": msg.id,
- "content": msg.content,
- "created_at": msg.created_at.strftime("%Y-%m-%d %H:%M:%S"),
- }
- except Exception as e:
- return {"error": f"Failed to reply ticket #{ticket_id}: {str(e)}"}
- @agent_tool(
- name="admin_update_ticket_status",
- description="更新工单处理状态(pending-待处理, info_required-需补充, in_progress-处理中, resolved-已解决, rejected-已拒绝, closed-已关闭)",
- is_dangerous=True,
- )
- async def admin_update_ticket_status(
- ticket_id: int,
- status: str,
- note: Optional[str] = None,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """管理员更改工单状态"""
- if current_user.role != "admin":
- return {"error": ADMIN_CHECK_MSG}
- clean_status = status.strip().lower()
- valid_statuses = {"pending", "info_required", "in_progress", "resolved", "rejected", "closed"}
- if clean_status not in valid_statuses:
- return {"error": f"Invalid ticket status '{clean_status}'. Valid statuses: {sorted(list(valid_statuses))}"}
- try:
- ticket = await TicketService.update_status(
- db=db,
- ticket_id=ticket_id,
- status=clean_status,
- comment=note or "",
- admin_id=str(current_user.id),
- )
- if note and note.strip():
- await TicketService.add_message(
- db=db,
- ticket_id=ticket_id,
- sender_type="system",
- content=f"系统状态变更为 [{clean_status}]: {note.strip()}",
- )
- return {
- "success": True,
- "ticket_id": ticket.id,
- "new_status": ticket.status,
- "updated_at": ticket.updated_at.strftime("%Y-%m-%d %H:%M:%S") if ticket.updated_at else None,
- }
- except Exception as e:
- return {"error": f"Failed to update status for ticket #{ticket_id}: {str(e)}"}
|