from fastapi import APIRouter, Depends
from sqlalchemy.orm import Session
from app.api.category_wish_inventory import schema
from app.api.category_wish_inventory.service import CategoryWishInventoryService
from app.database.main.mysql import get_db
from app.dependency.authantication import JWTPayloadSchema, get_current_student

category_wish_inventory_routre = APIRouter()

@category_wish_inventory_routre.post("/create_category_wish_inventory", response_model_exclude_none=True)
async def create_category_wish_inventory(request:schema.CategoryWishInventoryCreate, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).create_category_wish_inventory(request)

@category_wish_inventory_routre.get("/get_margin_sales{group_id}",response_model_exclude_none=True)
async def get_margin_sales(db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).get()

@category_wish_inventory_routre.get("/get_category_name", response_model_exclude_none=True)
async def get_category_name(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).get_category_name_excel(group_id)

@category_wish_inventory_routre.get("/get_group_id{group_id}", response_model_exclude_none=True)
async def get_group_id(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).get_group_id(group_id)

@category_wish_inventory_routre.put("/update_category_wish_inventory", response_model_exclude_none=True)
async def update_category_wish_inventory(request:schema.CategoryWishInventoryUpdate, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).update_category_wish_inventory(request)

@category_wish_inventory_routre.delete("/delete_category_wish_inventory", response_model_exclude_none=True)
async def delete_category_wish_inventory(group_id:list[int], db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryWishInventoryService(db,token).delete_category_wish_inventory(group_id)