package com.dacrt.SBIABackend.repository;

import java.util.Date;
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.Coveragechannelshistory;

@Repository
public interface CoveragechannelshistoryRepository extends JpaRepository<Coveragechannelshistory,Integer>,JpaSpecificationExecutor<Coveragechannelshistory>{
	@Query("SELECT e FROM Coveragechannelshistory e WHERE e.coveragechannelid.id =?1 and e.id =?2")
	Optional<Coveragechannelshistory> findByCoveragechannelhistory(int coveragechannelid, int coveragechannelhistoryid);
	
	@Query("SELECT count(e) FROM Coveragechannelshistory e WHERE e.coveragechannelid.id =?1 and date=?2")
	int existByCoveragechannelshistory(int coveragechannelid, Date fecha);
	
	@Query("SELECT e FROM Coveragechannelshistory e WHERE e.coveragechannelid.id =?1 and date=?2")
	Optional<Coveragechannelshistory> findByCoveragechannelshistory(int coveragechannelid, Date fecha);
	
	@Query("SELECT count(e) FROM Coveragechannelshistory e WHERE e.coveragechannelid.id =?1 and date > ?2")
	int findByCoveragechannelshistoryFecha(int coveragechannelid, Date fecha);
}