| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- # 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, case
- 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.coalesce(func.sum(case((VasOrder.status == 'completed', 1), else_=0)), 0).label("completed_orders"),
- func.coalesce(func.sum(case((VasOrder.status == 'pending', 1), else_=0)), 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,
- }
|