from __future__ import annotations
from fastapi import APIRouter, Depends, HTTPException, Query
from sqlalchemy.orm import Session
from sqlalchemy import func as sqlfunc

from app.database import get_db
from app.auth import get_current_user
from app.models.news import News
from app.schemas.news import NewsSchema, NewsResponse, NewsListResponse

router = APIRouter(prefix="/api/news", tags=["新闻动态"], dependencies=[Depends(get_current_user)])


@router.get("/", response_model=NewsListResponse)
def list_news(
    page: int = Query(1, ge=1),
    page_size: int = Query(20, ge=1, le=100),
    keyword: str = Query("", description="搜索关键词"),
    db: Session = Depends(get_db),
):
    query = db.query(News)
    if keyword:
        query = query.filter(News.title.contains(keyword) | News.summary.contains(keyword))
    total = query.count()
    items = query.order_by(News.sort_order, News.id.desc()).offset((page - 1) * page_size).limit(page_size).all()
    return NewsListResponse(
        items=[NewsResponse.model_validate(n) for n in items],
        total=total,
    )


@router.post("/", response_model=NewsResponse, status_code=201)
def create_news(req: NewsSchema, db: Session = Depends(get_db)):
    max_order = db.query(sqlfunc.max(News.sort_order)).scalar() or 0
    news = News(**req.model_dump(), sort_order=max_order + 1)
    db.add(news)
    db.commit()
    db.refresh(news)
    return NewsResponse.model_validate(news)


@router.put("/{news_id}", response_model=NewsResponse)
def update_news(news_id: int, req: NewsSchema, db: Session = Depends(get_db)):
    news = db.query(News).get(news_id)
    if not news:
        raise HTTPException(status_code=404, detail="新闻不存在")
    for key, val in req.model_dump().items():
        setattr(news, key, val)
    db.commit()
    db.refresh(news)
    return NewsResponse.model_validate(news)


@router.delete("/{news_id}")
def delete_news(news_id: int, db: Session = Depends(get_db)):
    news = db.query(News).get(news_id)
    if not news:
        raise HTTPException(status_code=404, detail="新闻不存在")
    db.delete(news)
    db.commit()
    return {"message": "删除成功"}


@router.put("/reorder/batch")
def reorder_news(ids: list[int], db: Session = Depends(get_db)):
    for i, nid in enumerate(ids):
        db.query(News).filter(News.id == nid).update({"sort_order": i})
    db.commit()
    return {"message": "排序更新成功"}