70 行
2.4 KiB
Python
70 行
2.4 KiB
Python
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.story import Story
|
|
from app.schemas.story import StorySchema, StoryResponse, StoryListResponse
|
|
|
|
router = APIRouter(prefix="/api/stories", tags=["客户故事"], dependencies=[Depends(get_current_user)])
|
|
|
|
|
|
@router.get("/", response_model=StoryListResponse)
|
|
def list_stories(
|
|
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(Story)
|
|
if keyword:
|
|
query = query.filter(Story.title.contains(keyword) | Story.customer_name.contains(keyword))
|
|
total = query.count()
|
|
items = query.order_by(Story.sort_order, Story.id.desc()).offset((page - 1) * page_size).limit(page_size).all()
|
|
return StoryListResponse(
|
|
items=[StoryResponse.model_validate(s) for s in items],
|
|
total=total,
|
|
)
|
|
|
|
|
|
@router.post("/", response_model=StoryResponse, status_code=201)
|
|
def create_story(req: StorySchema, db: Session = Depends(get_db)):
|
|
max_order = db.query(sqlfunc.max(Story.sort_order)).scalar() or 0
|
|
story = Story(**req.model_dump(), sort_order=max_order + 1)
|
|
db.add(story)
|
|
db.commit()
|
|
db.refresh(story)
|
|
return StoryResponse.model_validate(story)
|
|
|
|
|
|
@router.put("/{story_id}", response_model=StoryResponse)
|
|
def update_story(story_id: int, req: StorySchema, db: Session = Depends(get_db)):
|
|
story = db.query(Story).get(story_id)
|
|
if not story:
|
|
raise HTTPException(status_code=404, detail="故事不存在")
|
|
for key, val in req.model_dump().items():
|
|
setattr(story, key, val)
|
|
db.commit()
|
|
db.refresh(story)
|
|
return StoryResponse.model_validate(story)
|
|
|
|
|
|
@router.delete("/{story_id}")
|
|
def delete_story(story_id: int, db: Session = Depends(get_db)):
|
|
story = db.query(Story).get(story_id)
|
|
if not story:
|
|
raise HTTPException(status_code=404, detail="故事不存在")
|
|
db.delete(story)
|
|
db.commit()
|
|
return {"message": "删除成功"}
|
|
|
|
|
|
@router.put("/reorder/batch")
|
|
def reorder_stories(ids: list[int], db: Session = Depends(get_db)):
|
|
for i, sid in enumerate(ids):
|
|
db.query(Story).filter(Story.id == sid).update({"sort_order": i})
|
|
db.commit()
|
|
return {"message": "排序更新成功"}
|