# 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, }