from fastapi import APIRouter, Depends, UploadFile,File
from sqlalchemy.orm import Session
from app.api.inventory_excel.service import InventoryExcelService
from app.database.main.mysql import get_db
from app.dependency.authantication import JWTPayloadSchema, get_current_student

inventory_excel_router = APIRouter()

@inventory_excel_router.get("download_inventory_excel")
async def download_inventory_excel(db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await InventoryExcelService(db,token).download_inventory_excel()

@inventory_excel_router.post("upload_inventory_excel")
async def upload_inventory_excel(file:UploadFile = File(...), db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await InventoryExcelService(db,token).upload_inventory_excel(file)