from typing import List
from fastapi import HTTPException
from app.api.vendor_scorecard import schema
from app.dependency.authantication import JWTPayloadSchema
from app.locale.messages import Messages
from app.models.main.vendor_scorecard import TblVendorScorecard, VendorScorecardBase
from app.utils.schemas_utils import CustomResponse
from sqlalchemy.orm import Session

class VendorScorecardService:
    def __init__(self, db:Session, token:JWTPayloadSchema):
        self.db = db
        self.token = token
        
    async def create_vendor_scorecard(self, request:schema.VendorScorecardCreate):
        created_vendor_scorecard = VendorScorecardBase.model_validate(request.model_dump())
        TblVendorScorecard.create_vendor_scorecard(created_vendor_scorecard, self.db)
        self.db.commit()
        return CustomResponse(status="1", message=Messages.VENDOR_SCORECARD)
    
    async def get_vendor_scorecard(self, vendor_get_id:int):
        new_get_vendor_scorecard = TblVendorScorecard.get_vendor_scorecard(vendor_get_id, self.db)
        if not new_get_vendor_scorecard:
            raise HTTPException(status_code=404, detail="Vendor Get ID Not Found")
        return schema.VendorScorecardResponse.model_validate(new_get_vendor_scorecard)
    
    async def get_group_vendor_scorecard(self, group_id):
        new_get_group_vendor_scorecard = self.db.query(TblVendorScorecard).filter(TblVendorScorecard.group_id == group_id).all()
        if not new_get_group_vendor_scorecard:
            raise HTTPException(status_code=404, detail="Get Group ID not found")
        return [schema.VendorScorecardResponse.model_validate(get_group) for get_group in new_get_group_vendor_scorecard]
    
    async def update_vendor_scorecard(self, request:List[schema.VendorScorecardUpdate]):
        for req in request:
            updated_vendor_scorecard = VendorScorecardBase.model_validate(req.model_dump())
            if updated_vendor_scorecard is None:
                return CustomResponse(status="-1", message=Messages.VENDOR_SCORECARD_NOT)
            TblVendorScorecard.update_vendor_scorecord(updated_vendor_scorecard.vendor_scorecard_id, updated_vendor_scorecard, self.db)
        self.db.commit()
        return CustomResponse(status="1", message=Messages.VENDOR_METRICS_PRIORITY_UPDATE)
    
    async def delete_vendor_scorecard(self, vendor_scorecard_id:int):
        deleted_vendor_scorecard = TblVendorScorecard.deletee_vendore_scorecard(vendor_scorecard_id, self.db)
        if not deleted_vendor_scorecard:
            return CustomResponse(status="-1", message=Messages.VENDOR_METRICS_PRIORITY_NOT)
        return CustomResponse(status="1", message=Messages.VENDOR_METRICS_PRIORITY_DELETE)