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

category_captinship_planning_router = APIRouter()

@category_captinship_planning_router.post("/create_category_captinship_planning", response_model_exclude_none=True)
async def create_category_captinship_planning(request:schema.CategoryCaptinshipPlanningCreate, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).create_category_captinship_planning_new(request)

@category_captinship_planning_router.get("/get_category_captinship_planning", response_model_exclude_none=True)
async def get_category_captinship_planning(category_plan_get_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).get_category_captinship_planning(category_plan_get_id)

@category_captinship_planning_router.get("/get_group_category_captinship_planning", response_model_exclude_none=True)
async def get_group_category_captinship_planning(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).get_group_category_captinship_planning(group_id)

@category_captinship_planning_router.get("/get_excel_new", response_model_exclude_none=True)
async def get_excel(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).get_excel_category_captinship_planning(group_id)

@category_captinship_planning_router.put("/update_category_captinship_planning", response_model_exclude_none=True)
async def update_category_captinship_planning(request:schema.CategoryCaptinshipPlanningUpdate, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).update_category_captinship_planning(request)

@category_captinship_planning_router.delete("/delete_category_captinship_planning", response_model_exclude_none=True)
async def delete_category_captinship_planning(group_id:int, db:Session = Depends(get_db),token: JWTPayloadSchema = Depends(get_current_student)):
    return await CategoryCaptinshipPlanningService(db,token).delete_category_captinship_planning(group_id)