# 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)}"}