Spaces:
Runtime error
Runtime error
File size: 1,346 Bytes
67ac4d2 634fbf6 67ac4d2 634fbf6 67ac4d2 634fbf6 67ac4d2 634fbf6 67ac4d2 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | 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)}")
|