buff/backend/app/api/client/announcement.py

"""
公告接口
"""
from fastapi import APIRouter, Depends
from sqlalchemy.orm import Session
from app.database import get_db
from app.models.announcement import Announcement

router = APIRouter()

@router.get("")
async def get_announcement(db: Session = Depends(get_db)):
    """获取公告列表"""
    # 获取所有启用的公告，按优先级和创建时间排序
    announcements = db.query(Announcement).filter(
        Announcement.is_active == 1
    ).order_by(Announcement.priority.desc(), Announcement.created_at.desc()).all()
    
    if not announcements:
        return {
            "code": 200,
            "msg": "成功",
            "data": []
        }
    
    return {
        "code": 200,
        "msg": "成功",
        "data": [
            {
                "title": announcement.title,
                "content": announcement.content
            }
            for announcement in announcements
        ]
    }