Skip to content

PRINTFILM: AI short-video marketing and AI short-drama creation platform

3.4 KB
Raw Blame
# Dashboard stats for admin console
from fastapi import APIRouter, Depends, HTTPException, Query
from sqlalchemy.ext.asyncio import AsyncSession

from app.database import get_db
from app.deps import get_current_admin
from app.models import User
from app.schemas import (
    AdminDailyUsageOut,
    AdminStatsOut,
    AdminTopUserOut,
    AdminUsageBucketOut,
)
from app.services.admin.stats import build_admin_dashboard_stats

router = APIRouter()

_ALLOWED_STATS_DAYS = frozenset({1, 7, 14, 30})
_ALLOWED_TOP_METRICS = frozenset({"charge", "calls"})


def _validate_stats_days(raw: int) -> int:
    """仅允许固定档位,非法值返回 422。"""
    if raw not in _ALLOWED_STATS_DAYS:
        allowed = ", ".join(str(v) for v in sorted(_ALLOWED_STATS_DAYS))
        raise HTTPException(status_code=422, detail=f"days must be one of: {allowed}")
    return raw


def _normalize_top_metric(raw: str) -> str:
    metric = (raw or "charge").strip().lower()
    if metric not in _ALLOWED_TOP_METRICS:
        allowed = ", ".join(sorted(_ALLOWED_TOP_METRICS))
        raise HTTPException(status_code=422, detail=f"top_metric must be one of: {allowed}")
    return metric


@router.get("/stats", response_model=AdminStatsOut,
    summary="查看运营总览",
    description="管理员查看用户与充值统计、AI 调用量和费用,以及指定时间窗口内的趋势、能力分布与用户排行。今日、本月与累计指标使用各自固定的统计范围。",
    response_description="操作成功,返回结果详见响应结构",
)
async def admin_stats(
    days: int = Query(default=7, description="趋势与分布时间窗口(天),仅支持 1/7/14/30"),
    domain: str = Query(default="all", max_length=32, description="领域筛选,all 为全部"),
    capability: str = Query(default="all", max_length=32, description="能力筛选,all 为全部"),
    top_metric: str = Query(default="charge", description="用户排行排序指标:charge/calls"),
    _admin: User = Depends(get_current_admin),
    db: AsyncSession = Depends(get_db),
) -> AdminStatsOut:
    """用户/充值 + AI 调用量/费用/趋势/排行。"""
    window_days = _validate_stats_days(days)
    metric = _normalize_top_metric(top_metric)
    raw = await build_admin_dashboard_stats(
        db,
        days=window_days,
        domain=domain.strip() or "all",
        capability=capability.strip() or "all",
        top_metric=metric,
    )
    return AdminStatsOut(
        user_count=raw["user_count"],
        order_paid_total_fen=raw["order_paid_total_fen"],
        order_paid_today_fen=raw["order_paid_today_fen"],
        project_status_counts=raw["project_status_counts"],
        drama_project_count=raw["drama_project_count"],
        usage_calls_today=raw["usage_calls_today"],
        usage_calls_month=raw["usage_calls_month"],
        usage_calls_total=raw["usage_calls_total"],
        usage_charge_today_fen=raw["usage_charge_today_fen"],
        usage_charge_month_fen=raw["usage_charge_month_fen"],
        usage_charge_total_fen=raw["usage_charge_total_fen"],
        usage_by_capability=[AdminUsageBucketOut(**x) for x in raw["usage_by_capability"]],
        usage_by_domain=[AdminUsageBucketOut(**x) for x in raw["usage_by_domain"]],
        daily_usage=[AdminDailyUsageOut(**x) for x in raw["daily_usage"]],
        top_users_by_charge=[AdminTopUserOut(**x) for x in raw["top_users_by_charge"]],
    )