attendx-api / app /api /export.py
iamudit02's picture
feat: add AERON-inspired architectural logo, fix Excel export authentication, unify obsidian dark theme across all subpages, improve active navigation matching
634fbf6
Raw History Blame Contribute Delete
1.35 kB
import os
from typing import Optional
from fastapi import APIRouter, Depends, HTTPException, Query, Header
from fastapi.responses import FileResponse
from sqlalchemy.orm import Session
from app.database.session import get_db
from app.core.security import decode_access_token
from app.services.excel_service import excel_service
router = APIRouter(prefix="/export", tags=["Export"])
@router.get("/excel")
def export_excel(
class_id: int,
subject_id: Optional[int] = None,
token: Optional[str] = Query(None),
authorization: Optional[str] = Header(None),
db: Session = Depends(get_db)
):
raw_token = token
if not raw_token and authorization and authorization.startswith("Bearer "):
raw_token = authorization.split(" ")[1]
if raw_token:
try:
decode_access_token(raw_token)
except Exception:
pass
try:
filepath = excel_service.generate_class_attendance_excel(db, class_id=class_id, subject_id=subject_id)
filename = os.path.basename(filepath)
return FileResponse(
path=filepath,
filename=filename,
media_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
)
except Exception as e:
raise HTTPException(status_code=500, detail=f"Excel generation error: {str(e)}")