package com.vantec.screen.repository;

import java.io.Serializable;
import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.vantec.screen.entity.DocumentHeader;
import com.vantec.screen.entity.DocumentStatus;

public interface DocumentHeaderRepository extends JpaRepository<DocumentHeader, Serializable>{
	
	@Query("select d from DocumentHeader d where d.bwlvs in ('943','945') and d.documentStatus = :documentStatus and d.dateUpdated >:dateUpdated order by dateUpdated asc")
    List<DocumentHeader> findAllWithBwlvsAndTimeAfter(@Param("documentStatus") DocumentStatus documentStatus,@Param("dateUpdated") Date dateUpdated);
	
	List<DocumentHeader> findByBwlvsAndDocumentStatus(String bwlvs,DocumentStatus status);
	
	
	@Query("select d from DocumentHeader d where d.dateUpdated between current_date()-1 and current_date()") //and d.dateUpdated <= :today")
	List<DocumentHeader> findOrderHeaderAndTimeAfter();
	
	DocumentHeader findByDocumentReferenceCode(String documentReference);
	
}

