Skip to content

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

3.9 KB
Raw Blame
# Admin work audit (visibility / audit_status)
from fastapi import APIRouter, Depends, HTTPException, Query
from sqlalchemy import func, select
from sqlalchemy.ext.asyncio import AsyncSession
from sqlalchemy.orm import aliased

from app.database import get_db
from app.deps import get_current_admin
from app.models import User, Work
from app.schemas import AdminWorkListOut, AdminWorkOut, AdminWorkPatch, PageMeta

router = APIRouter()


@router.get("/works", response_model=AdminWorkListOut,
    summary="分页查询已发布作品",
    description="管理员按审核状态、可见性、标题关键词和所属用户查询已发布作品,按作品编号倒序返回。",
    response_description="操作成功,返回结果详见响应结构",
)
async def list_works(
    audit_status: str | None = None,
    visibility: str | None = None,
    q: str | None = None,
    user_id: int | None = None,
    page: int = Query(1, ge=1),
    page_size: int = Query(20, ge=1, le=100),
    _admin: User = Depends(get_current_admin),
    db: AsyncSession = Depends(get_db),
) -> AdminWorkListOut:
    # Paginated published works
    owner = aliased(User)
    stmt = select(Work, owner.email).outerjoin(owner, owner.id == Work.user_id)
    count_stmt = select(func.count()).select_from(Work)

    if audit_status and audit_status.strip():
        stmt = stmt.where(Work.audit_status == audit_status.strip())
        count_stmt = count_stmt.where(Work.audit_status == audit_status.strip())
    if visibility and visibility.strip():
        stmt = stmt.where(Work.visibility == visibility.strip())
        count_stmt = count_stmt.where(Work.visibility == visibility.strip())
    if user_id is not None:
        stmt = stmt.where(Work.user_id == user_id)
        count_stmt = count_stmt.where(Work.user_id == user_id)
    if q and q.strip():
        like = f"%{q.strip()}%"
        filt = Work.title.ilike(like)
        stmt = stmt.where(filt)
        count_stmt = count_stmt.where(filt)

    total = int((await db.execute(count_stmt)).scalar_one() or 0)
    rows = (
        await db.execute(
            stmt.order_by(Work.id.desc()).offset((page - 1) * page_size).limit(page_size)
        )
    ).all()

    items: list[AdminWorkOut] = []
    for work, email in rows:
        data = AdminWorkOut.model_validate(work)
        data.user_email = email
        items.append(data)

    return AdminWorkListOut(items=items, meta=PageMeta(page=page, page_size=page_size, total=total))


@router.patch("/works/{work_id}", response_model=AdminWorkOut,
    summary="更新作品审核状态与可见性",
    description="管理员局部更新已发布作品。visibility 支持 public(公开)、private(私有)、unlisted(不列出);audit_status 支持 pending(待审核)、passed(通过)、rejected(拒绝)。",
    response_description="操作成功,返回结果详见响应结构",
)
async def patch_work(
    work_id: int,
    body: AdminWorkPatch,
    _admin: User = Depends(get_current_admin),
    db: AsyncSession = Depends(get_db),
) -> AdminWorkOut:
    # Update visibility / audit_status
    work = await db.get(Work, work_id)
    if not work:
        raise HTTPException(status_code=404, detail="作品不存在")

    if body.visibility is not None:
        vis = body.visibility.strip()
        if vis not in ("public", "private", "unlisted"):
            raise HTTPException(status_code=400, detail="visibility 无效")
        work.visibility = vis

    if body.audit_status is not None:
        audit = body.audit_status.strip()
        if audit not in ("pending", "passed", "rejected"):
            raise HTTPException(status_code=400, detail="audit_status 无效")
        work.audit_status = audit

    await db.commit()
    await db.refresh(work)

    owner = await db.get(User, work.user_id)
    data = AdminWorkOut.model_validate(work)
    data.user_email = owner.email if owner else None
    return data