from typing import Annotated from fastapi import APIRouter, File, HTTPException, Query, UploadFile, status from sqlalchemy import select from app.core.deps import AnyAdmin, DbSession from app.models import Service from app.schemas.content import ServiceAdmin, ServiceCreate, ServicePublic, ServiceUpdate from app.routes.single_image import image_files, remove_image, replace_image from app.services.image_processing import delete_media_files from app.utils.helpers import unique_slug public_router = APIRouter(prefix="/services", tags=["Services"]) admin_router = APIRouter(prefix="/admin/services", tags=["Admin: services"]) _ORDER = (Service.sort_order, Service.id) async def _get(db, service_id: int) -> Service: service = await db.get(Service, service_id) if not service: raise HTTPException(status.HTTP_404_NOT_FOUND, "Service not found") return service @public_router.get("", response_model=list[ServicePublic], summary="Published services") async def list_services(db: DbSession): rows = await db.scalars(select(Service).where(Service.is_published.is_(True)).order_by(*_ORDER)) return [ServicePublic.build(s) for s in rows] @public_router.get("/{id_or_slug}", response_model=ServicePublic) async def get_service(id_or_slug: str, db: DbSession): cond = Service.id == int(id_or_slug) if id_or_slug.isdigit() else Service.slug == id_or_slug service = await db.scalar(select(Service).where(cond, Service.is_published.is_(True))) if not service: raise HTTPException(status.HTTP_404_NOT_FOUND, "Service not found") return ServicePublic.build(service) @admin_router.get("", response_model=list[ServiceAdmin]) async def admin_list_services( _: AnyAdmin, db: DbSession, is_published: Annotated[bool | None, Query()] = None ): stmt = select(Service).order_by(*_ORDER) if is_published is not None: stmt = stmt.where(Service.is_published.is_(is_published)) return [ServiceAdmin.build(s) for s in await db.scalars(stmt)] @admin_router.get("/{service_id}", response_model=ServiceAdmin) async def admin_get_service(service_id: int, _: AnyAdmin, db: DbSession): return ServiceAdmin.build(await _get(db, service_id)) @admin_router.post("", response_model=ServiceAdmin, status_code=status.HTTP_201_CREATED) async def create_service(body: ServiceCreate, _: AnyAdmin, db: DbSession): data = body.model_dump() data["slug"] = await unique_slug(db, Service, data["slug"] or data["title"]) service = Service(**data) db.add(service) await db.commit() await db.refresh(service) return ServiceAdmin.build(service) @admin_router.put("/{service_id}", response_model=ServiceAdmin) async def update_service(service_id: int, body: ServiceUpdate, _: AnyAdmin, db: DbSession): service = await _get(db, service_id) data = body.model_dump(exclude_unset=True) for required in ("title", "sort_order", "is_published"): if required in data and data[required] is None: raise HTTPException(status.HTTP_422_UNPROCESSABLE_CONTENT, f"'{required}' cannot be null") if data.get("slug"): data["slug"] = await unique_slug(db, Service, data["slug"], exclude_id=service.id) else: data.pop("slug", None) for key, value in data.items(): setattr(service, key, value) await db.commit() await db.refresh(service) return ServiceAdmin.build(service) @admin_router.delete("/{service_id}", status_code=status.HTTP_204_NO_CONTENT) async def delete_service(service_id: int, _: AnyAdmin, db: DbSession): service = await _get(db, service_id) files = image_files(service) await db.delete(service) await db.commit() delete_media_files(*files) @admin_router.post( "/{service_id}/image", response_model=ServiceAdmin, summary="Upload/replace the service image (auto-watermarked)", ) async def upload_service_image( service_id: int, _: AnyAdmin, db: DbSession, file: Annotated[UploadFile, File(description="JPG/JPEG/PNG/WEBP image")], ): service = await _get(db, service_id) await replace_image(db, service, file) return ServiceAdmin.build(service) @admin_router.delete("/{service_id}/image", response_model=ServiceAdmin) async def delete_service_image(service_id: int, _: AnyAdmin, db: DbSession): service = await _get(db, service_id) await remove_image(db, service) return ServiceAdmin.build(service)