| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149 |
- # app/services/agent/tools/builtin/user_tools.py
- from typing import Optional, Dict, Any, List
- from sqlalchemy.ext.asyncio import AsyncSession
- from sqlalchemy import select, or_, desc
- from app.models.user import VasUser
- from app.models.order import VasOrder
- 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_users",
- description="管理员查询全站用户列表,支持按手机号、昵称、用户ID关键词检索,可按角色(admin/user)筛选",
- )
- async def admin_list_users(
- keyword: Optional[str] = None,
- role: 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(VasUser)
- if role and role.strip():
- stmt = stmt.where(VasUser.role == role.strip().lower())
- if keyword and keyword.strip():
- kw = f"%{keyword.strip()}%"
- stmt = stmt.where(
- or_(
- VasUser.id.ilike(kw),
- VasUser.phone.ilike(kw),
- VasUser.nickname.ilike(kw),
- )
- )
- stmt = stmt.order_by(desc(VasUser.created_at)).offset(offset).limit(limit)
- res = await db.execute(stmt)
- users = res.scalars().all()
- items = []
- for u in users:
- items.append({
- "user_id": u.id,
- "nickname": u.nickname,
- "phone": u.phone,
- "role": u.role,
- "preferred_language": u.preferred_language,
- "created_at": u.created_at.strftime("%Y-%m-%d %H:%M:%S") if u.created_at else None,
- })
- return {
- "count": len(items),
- "users": items,
- }
- @agent_tool(
- name="admin_get_user_detail",
- description="获取指定用户的完整档案信息及历史订单总数统计",
- )
- async def admin_get_user_detail(
- user_id: str,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """查询指定用户详细信息与业务画像"""
- if current_user.role != "admin":
- return {"error": ADMIN_CHECK_MSG}
- stmt = select(VasUser).where(VasUser.id == user_id.strip())
- res = await db.execute(stmt)
- user = res.scalar_one_or_none()
- if not user:
- return {"error": f"User '{user_id}' does not exist"}
- # 统计历史订单总数
- order_stmt = select(VasOrder).where(VasOrder.user_id == user.id)
- order_res = await db.execute(order_stmt)
- user_orders = order_res.scalars().all()
- status_counts: Dict[str, int] = {}
- for o in user_orders:
- st = o.status or "unknown"
- status_counts[st] = status_counts.get(st, 0) + 1
- return {
- "user_id": user.id,
- "nickname": user.nickname,
- "phone": user.phone,
- "role": user.role,
- "avatar_url": user.avatar_url,
- "timezone": user.timezone,
- "preferred_language": user.preferred_language,
- "created_at": user.created_at.strftime("%Y-%m-%d %H:%M:%S") if user.created_at else None,
- "total_orders": len(user_orders),
- "order_status_summary": status_counts,
- }
- @agent_tool(
- name="admin_update_user_role",
- description="修改指定用户的系统权限角色(user-普通用户, admin-超级管理员)",
- is_dangerous=True,
- )
- async def admin_update_user_role(
- user_id: str,
- new_role: str,
- *,
- db: AsyncSession,
- current_user: VasUser,
- ) -> Dict[str, Any]:
- """管理员修改用户角色权限"""
- if current_user.role != "admin":
- return {"error": ADMIN_CHECK_MSG}
- clean_role = new_role.strip().lower()
- if clean_role not in ("admin", "user"):
- return {"error": "Invalid role. Supported roles: 'admin', 'user'"}
- stmt = select(VasUser).where(VasUser.id == user_id.strip())
- res = await db.execute(stmt)
- user = res.scalar_one_or_none()
- if not user:
- return {"error": f"User '{user_id}' does not exist"}
- old_role = user.role
- user.role = clean_role
- await db.commit()
- await db.refresh(user)
- logger.info(f"👑 [AI_AGENT] Updated user role: user={user.id} ({old_role} -> {clean_role}) by admin={current_user.id}")
- return {
- "success": True,
- "user_id": user.id,
- "previous_role": old_role,
- "new_role": user.role,
- }
|