import os
from typing import List
from fastapi import APIRouter
#from fastapi.responses import FileResponse
from app.api.company.schemas import Company, Role, RoleRequest, Seafarer, Vessel, VesselTypesResponse
from app.api.company.service import CompanyService

company_router = APIRouter()

EXCEL_DIR = os.getenv("EXCEL_DIR", "download_excel")
EXCEL_FILENAME = "Offline dashboard.xlsx"
EXCEL_PATH = os.path.join(EXCEL_DIR, EXCEL_FILENAME)

@company_router.get("/companies", response_model=List[Company])
def get_companies():
    return CompanyService().get_all_companies()

@company_router.get("/vessels/company/{company_id}", response_model=List[Vessel])
def get_vessels_by_company(company_id: int):
    return CompanyService().get_vessels_by_company(company_id)

@company_router.get("/seafarers/vessel/{vessel_id}", response_model=List[Seafarer])
def get_seafarers_by_vessel(vessel_id: int):
    return CompanyService().get_seafarers_by_vessel(vessel_id)

@company_router.get("/roles/{company_id}", response_model=List[Role])
def get_roles(company_id: str):
    return CompanyService().get_roles(company_id)

@company_router.get("/vessels/company/{company_id}/types",response_model=VesselTypesResponse)
def get_vessel_types_by_company(company_id: int):
    return CompanyService().get_vessel_types(company_id)