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