# app/services/agent/tools/builtin/settlement_tools.py from datetime import datetime, timedelta from typing import Optional, Dict, Any, List from sqlalchemy.ext.asyncio import AsyncSession from sqlalchemy import select, func, desc from app.models.user import VasUser from app.models.order import VasOrder from app.models.payment import VasPayment from app.models.settlement import VasSettlementPeriod 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="get_financial_overview", description="获取全站财务与营收宏观概览(包含总订单成交额、总成功支付笔数、待分润金额及近30天营收统计)", ) async def get_financial_overview( days: int = 30, *, db: AsyncSession, current_user: VasUser, ) -> Dict[str, Any]: """获取全站财务统计概览""" if current_user.role != "admin": return {"error": ADMIN_CHECK_MSG} now = datetime.utcnow() since_date = now - timedelta(days=max(1, min(days, 365))) # 总支付成功金额与笔数 pay_stmt = select( func.count(VasPayment.id).label("total_payments"), func.coalesce(func.sum(VasPayment.amount), 0).label("total_revenue"), ).where(VasPayment.status.in_(["succeeded", "late_paid"])) pay_res = await db.execute(pay_stmt) total_payments, total_revenue = pay_res.one() # 近期区间支付金额 recent_stmt = select( func.count(VasPayment.id).label("recent_payments"), func.coalesce(func.sum(VasPayment.amount), 0).label("recent_revenue"), ).where( VasPayment.status.in_(["succeeded", "late_paid"]), VasPayment.created_at >= since_date, ) recent_res = await db.execute(recent_stmt) recent_payments, recent_revenue = recent_res.one() # 订单总数与完成数 order_stmt = select( func.count(VasOrder.id).label("total_orders"), func.sum(func.case((VasOrder.status == 'completed', 1), else_=0)).label("completed_orders"), func.sum(func.case((VasOrder.status == 'pending', 1), else_=0)).label("pending_orders"), ) order_res = await db.execute(order_stmt) total_orders, completed_orders, pending_orders = order_res.one() return { "period_days": days, "total_revenue_cny": round(float(total_revenue) / 100, 2), "total_successful_payments": total_payments, "recent_revenue_cny": round(float(recent_revenue) / 100, 2), "recent_successful_payments": recent_payments, "total_orders": total_orders or 0, "completed_orders": completed_orders or 0, "pending_orders": pending_orders or 0, } @agent_tool( name="list_settlement_periods", description="查询开发者结算账期列表与状态(已确认、待结算、已打款)", ) async def list_settlement_periods( limit: int = 10, 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, 30)) offset = max(0, offset) stmt = select(VasSettlementPeriod).order_by(desc(VasSettlementPeriod.id)).offset(offset).limit(limit) res = await db.execute(stmt) periods = res.scalars().all() items = [] for p in periods: items.append({ "period_id": p.id, "period_name": p.period_name, "start_date": p.start_date.strftime("%Y-%m-%d") if p.start_date else None, "end_date": p.end_date.strftime("%Y-%m-%d") if p.end_date else None, "status": p.status, "total_payout_amount": p.total_payout_amount, "created_at": p.created_at.strftime("%Y-%m-%d %H:%M:%S") if p.created_at else None, }) return { "count": len(items), "settlement_periods": items, }