user_tools.py 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  1. # app/services/agent/tools/builtin/user_tools.py
  2. from typing import Optional, Dict, Any, List
  3. from sqlalchemy.ext.asyncio import AsyncSession
  4. from sqlalchemy import select, or_, desc
  5. from app.models.user import VasUser
  6. from app.models.order import VasOrder
  7. from app.services.agent.tools.registry import agent_tool
  8. from app.core.logger import logger
  9. ADMIN_CHECK_MSG = "Permission denied: This operation is restricted to system administrators (admin)"
  10. @agent_tool(
  11. name="admin_list_users",
  12. description="管理员查询全站用户列表,支持按手机号、昵称、用户ID关键词检索,可按角色(admin/user)筛选",
  13. )
  14. async def admin_list_users(
  15. keyword: Optional[str] = None,
  16. role: Optional[str] = None,
  17. limit: int = 15,
  18. offset: int = 0,
  19. *,
  20. db: AsyncSession,
  21. current_user: VasUser,
  22. ) -> Dict[str, Any]:
  23. """管理员分页查询用户列表"""
  24. if current_user.role != "admin":
  25. return {"error": ADMIN_CHECK_MSG}
  26. limit = max(1, min(limit, 50))
  27. offset = max(0, offset)
  28. stmt = select(VasUser)
  29. if role and role.strip():
  30. stmt = stmt.where(VasUser.role == role.strip().lower())
  31. if keyword and keyword.strip():
  32. kw = f"%{keyword.strip()}%"
  33. stmt = stmt.where(
  34. or_(
  35. VasUser.id.ilike(kw),
  36. VasUser.phone.ilike(kw),
  37. VasUser.nickname.ilike(kw),
  38. )
  39. )
  40. stmt = stmt.order_by(desc(VasUser.created_at)).offset(offset).limit(limit)
  41. res = await db.execute(stmt)
  42. users = res.scalars().all()
  43. items = []
  44. for u in users:
  45. items.append({
  46. "user_id": u.id,
  47. "nickname": u.nickname,
  48. "phone": u.phone,
  49. "role": u.role,
  50. "preferred_language": u.preferred_language,
  51. "created_at": u.created_at.strftime("%Y-%m-%d %H:%M:%S") if u.created_at else None,
  52. })
  53. return {
  54. "count": len(items),
  55. "users": items,
  56. }
  57. @agent_tool(
  58. name="admin_get_user_detail",
  59. description="获取指定用户的完整档案信息及历史订单总数统计",
  60. )
  61. async def admin_get_user_detail(
  62. user_id: str,
  63. *,
  64. db: AsyncSession,
  65. current_user: VasUser,
  66. ) -> Dict[str, Any]:
  67. """查询指定用户详细信息与业务画像"""
  68. if current_user.role != "admin":
  69. return {"error": ADMIN_CHECK_MSG}
  70. stmt = select(VasUser).where(VasUser.id == user_id.strip())
  71. res = await db.execute(stmt)
  72. user = res.scalar_one_or_none()
  73. if not user:
  74. return {"error": f"User '{user_id}' does not exist"}
  75. # 统计历史订单总数
  76. order_stmt = select(VasOrder).where(VasOrder.user_id == user.id)
  77. order_res = await db.execute(order_stmt)
  78. user_orders = order_res.scalars().all()
  79. status_counts: Dict[str, int] = {}
  80. for o in user_orders:
  81. st = o.status or "unknown"
  82. status_counts[st] = status_counts.get(st, 0) + 1
  83. return {
  84. "user_id": user.id,
  85. "nickname": user.nickname,
  86. "phone": user.phone,
  87. "role": user.role,
  88. "avatar_url": user.avatar_url,
  89. "timezone": user.timezone,
  90. "preferred_language": user.preferred_language,
  91. "created_at": user.created_at.strftime("%Y-%m-%d %H:%M:%S") if user.created_at else None,
  92. "total_orders": len(user_orders),
  93. "order_status_summary": status_counts,
  94. }
  95. @agent_tool(
  96. name="admin_update_user_role",
  97. description="修改指定用户的系统权限角色(user-普通用户, admin-超级管理员)",
  98. is_dangerous=True,
  99. )
  100. async def admin_update_user_role(
  101. user_id: str,
  102. new_role: str,
  103. *,
  104. db: AsyncSession,
  105. current_user: VasUser,
  106. ) -> Dict[str, Any]:
  107. """管理员修改用户角色权限"""
  108. if current_user.role != "admin":
  109. return {"error": ADMIN_CHECK_MSG}
  110. clean_role = new_role.strip().lower()
  111. if clean_role not in ("admin", "user"):
  112. return {"error": "Invalid role. Supported roles: 'admin', 'user'"}
  113. stmt = select(VasUser).where(VasUser.id == user_id.strip())
  114. res = await db.execute(stmt)
  115. user = res.scalar_one_or_none()
  116. if not user:
  117. return {"error": f"User '{user_id}' does not exist"}
  118. old_role = user.role
  119. user.role = clean_role
  120. await db.commit()
  121. await db.refresh(user)
  122. logger.info(f"👑 [AI_AGENT] Updated user role: user={user.id} ({old_role} -> {clean_role}) by admin={current_user.id}")
  123. return {
  124. "success": True,
  125. "user_id": user.id,
  126. "previous_role": old_role,
  127. "new_role": user.role,
  128. }