package com.dacrt.SBIABackend.repository;

import java.util.Optional;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.dacrt.SBIABackend.entity.Campaignunits;
import com.dacrt.SBIABackend.entity.Evalprocapps;
import com.dacrt.SBIABackend.entity.Evalprocesses;

@Repository
public interface EvalprocessesRepository extends JpaRepository<Evalprocesses,Integer>,JpaSpecificationExecutor<Evalprocesses>{
	@Query("SELECT e FROM Evalprocesses e WHERE e.id =?1")
	Optional<Evalprocesses> findByEvalprocessid(int id);
	
	@Query(value=" SELECT u FROM Evalprocesses u WHERE u.id= ?1 ")
	Evalprocesses getById(int id);
	
	boolean existsById(Integer id);
	
	@Query(value=" SELECT suplierst FROM Evalprocesses u WHERE u.id= ?1 ")
	int getStatusSupplierById(int id);
	
	@Query(value=" SELECT appst FROM Evalprocesses u WHERE u.id= ?1 ")
	int getStatusApprById(int id);
	
	@Query(value=" SELECT recordst FROM Evalprocesses u WHERE u.id= ?1 ")
	int getStatusRecordrById(int id);
	
	@Query(value=" SELECT inputst FROM Evalprocesses u WHERE u.id= ?1 ")
	int getStatusInputsById(int id);
	
}