package com.dacrt.SBIABackend.repository;

import java.util.Optional;

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

import com.dacrt.SBIABackend.entity.Facilities;
import com.dacrt.SBIABackend.entity.Requesters;
import com.dacrt.SBIABackend.entity.Resources;
import com.dacrt.SBIABackend.entity.Serviceoffers;

@Repository
public interface RequestersRepository extends JpaRepository<Requesters,Integer>,JpaSpecificationExecutor<Requesters>{
	
	Optional<Requesters> findByName(String name);
	
	@Query(" SELECT s from Requesters s where s.id = ?1 ")
	Optional<Requesters> encontrarId(Integer id);
	
	boolean existsByName(String name);
	Requesters findById(int id);
	boolean existsById(int id);
	
	Optional<Requesters> getByName(String name);
	
	@Query(value=" SELECT count(*) from main.regreports s where s.requesterid = ?1 ",nativeQuery=true)
	int findRequesters(int id);
}