# app/services/agent/tools/builtin/payment_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.payment import VasPayment 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="list_payments", description="管理员查询支付流水记录,支持按支付状态(pending-待支付, succeeded-支付成功, failed-失败, refunded-已退款)、订单号、支付通道provider(creem, stripe, wechat等)筛选", ) async def list_payments( status: Optional[str] = None, order_id: Optional[str] = None, provider: 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(VasPayment) if status and status.strip(): stmt = stmt.where(VasPayment.status == status.strip().lower()) if order_id and order_id.strip(): stmt = stmt.where(VasPayment.order_id == order_id.strip()) if provider and provider.strip(): stmt = stmt.where(VasPayment.provider.ilike(f"%{provider.strip()}%")) stmt = stmt.order_by(desc(VasPayment.created_at)).offset(offset).limit(limit) res = await db.execute(stmt) payments = res.scalars().all() items = [] for p in payments: items.append({ "payment_id": p.id, "order_id": p.order_id, "provider": p.provider, "amount": p.amount, "currency": p.currency, "status": p.status, "created_at": p.created_at.strftime("%Y-%m-%d %H:%M:%S") if p.created_at else None, "paid_at": p.paid_at.strftime("%Y-%m-%d %H:%M:%S") if getattr(p, "paid_at", None) else None, }) return { "count": len(items), "payments": items, }