from typing import Annotated from fastapi import APIRouter, Depends, HTTPException, Query, status from sqlalchemy import or_, select from sqlalchemy.orm import selectinload from app.core.config import settings from app.core.deps import AnyAdmin, DbSession, ManagerAdmin from app.middleware.rate_limit import RateLimiter from app.models import Enquiry, EnquiryNote, EnquiryStatus from app.schemas.common import MessageResponse, Page from app.schemas.enquiry import ( EnquiryCreate, EnquiryDetail, EnquiryListItem, EnquiryNoteOut, EnquiryUpdate, ) from app.utils.helpers import escape_like, paginate public_router = APIRouter(tags=["Enquiries"]) admin_router = APIRouter(prefix="/admin/enquiries", tags=["Admin: enquiries"]) enquiry_limiter = RateLimiter("enquiry", settings.PUBLIC_FORM_RATE_LIMIT_PER_MINUTE) THANK_YOU = "Thank you! Our team will contact you shortly." def _detail(e: Enquiry) -> EnquiryDetail: data = EnquiryListItem.model_validate(e).model_dump() return EnquiryDetail( **data, address=e.address, monthly_bill=float(e.monthly_bill) if e.monthly_bill is not None else None, message=e.message, notes=[EnquiryNoteOut.from_note(n) for n in e.notes], ) async def _get_enquiry(db, enquiry_id: int) -> Enquiry: enquiry = await db.scalar( select(Enquiry) .where(Enquiry.id == enquiry_id) .options(selectinload(Enquiry.notes).joinedload(EnquiryNote.author)) ) if not enquiry: raise HTTPException(status.HTTP_404_NOT_FOUND, "Enquiry not found") return enquiry @public_router.post( "/enquiries", response_model=MessageResponse, status_code=status.HTTP_201_CREATED, dependencies=[Depends(enquiry_limiter)], summary="Submit a solar enquiry (public website form)", ) async def create_enquiry(body: EnquiryCreate, db: DbSession): if body.website: # honeypot filled -> silently ignore bot submission return MessageResponse(message=THANK_YOU) db.add(Enquiry(**body.model_dump(exclude={"website"}))) await db.commit() return MessageResponse(message=THANK_YOU) @admin_router.get("", response_model=Page[EnquiryListItem]) async def list_enquiries( _: AnyAdmin, db: DbSession, search: Annotated[str | None, Query(max_length=100, description="Name, phone, email or city")] = None, status_filter: Annotated[EnquiryStatus | None, Query(alias="status")] = None, page: Annotated[int, Query(ge=1)] = 1, page_size: Annotated[int, Query(ge=1, le=100)] = 20, ): stmt = select(Enquiry).order_by(Enquiry.created_at.desc(), Enquiry.id.desc()) if status_filter: stmt = stmt.where(Enquiry.status == status_filter) if search and (term := search.strip()): like = f"%{escape_like(term)}%" stmt = stmt.where( or_( Enquiry.name.ilike(like), Enquiry.phone.ilike(like), Enquiry.email.ilike(like), Enquiry.city.ilike(like), ) ) rows, total = await paginate(db, stmt, page, page_size) return Page(items=rows, total=total, page=page, page_size=page_size) @admin_router.get("/{enquiry_id}", response_model=EnquiryDetail) async def get_enquiry(enquiry_id: int, _: AnyAdmin, db: DbSession): return _detail(await _get_enquiry(db, enquiry_id)) @admin_router.patch("/{enquiry_id}", response_model=EnquiryDetail) async def update_enquiry(enquiry_id: int, body: EnquiryUpdate, admin: AnyAdmin, db: DbSession): if body.status is None and body.note is None: raise HTTPException(status.HTTP_422_UNPROCESSABLE_CONTENT, "Provide a status and/or a note") enquiry = await _get_enquiry(db, enquiry_id) if body.status is not None: enquiry.status = body.status if body.note: db.add(EnquiryNote(enquiry_id=enquiry.id, author_id=admin.id, content=body.note)) await db.commit() db.expire(enquiry) return _detail(await _get_enquiry(db, enquiry_id)) @admin_router.delete("/{enquiry_id}", status_code=status.HTTP_204_NO_CONTENT) async def delete_enquiry(enquiry_id: int, _: ManagerAdmin, db: DbSession): enquiry = await db.get(Enquiry, enquiry_id) if not enquiry: raise HTTPException(status.HTTP_404_NOT_FOUND, "Enquiry not found") await db.delete(enquiry) await db.commit()