io.mosip.kernel.masterdata.repository.ValidDocumentRepository Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of kernel-masterdata-service Show documentation
Mosip commons project
There is a newer version: 1.2.1.0
Show newest version
package io.mosip.kernel.masterdata.repository;

import java.time.LocalDateTime;
import java.util.List;

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

import io.mosip.kernel.core.dataaccess.spi.repository.BaseRepository;
import io.mosip.kernel.masterdata.entity.ValidDocument;
import io.mosip.kernel.masterdata.entity.id.ValidDocumentID;

/**
 * Repository for valid document.
 * 
 * @author Ritesh Sinha
 * @since 1.0.0
 *
 */
@Repository
public interface ValidDocumentRepository extends BaseRepository {

	/**
	 * Method to find valid document based on code provided.
	 * 
	 * @param code the document category code.
	 * @return list of valid document.
	 */
	@Query("FROM ValidDocument WHERE docCategoryCode=?1 AND (isDeleted is null OR isDeleted = false) and isActive = true")
	List findByDocCategoryCode(String code);
	
	/**
	 * Method to find valid document based on code provided.
	 * 
	 * @param code the document category code.
	 * @return list of valid document.
	 */
	@Query("FROM ValidDocument v WHERE v.docCategoryCode=?1 and v.langCode=?2 AND (isDeleted is null OR isDeleted = false) and isActive = true")
	List findByDocCategoryCodeAndLangCode(String code, String langCode);
	
	/**
	 * Method to find valid document based on code provided.
	 * 
	 * @param code the document category code.
	 * @return list of valid document.
	 */
	@Query("FROM ValidDocument WHERE docCategoryCode=?1 AND (isDeleted is null OR isDeleted = false) and isActive = true")
	ValidDocument findByDocCategCode(String code);

	/**
	 * Method to find valid document based on code provided.
	 * 
	 * @param code the document type code.
	 * @return list of valid document.
	 */
	@Query("FROM ValidDocument WHERE docTypeCode=?1 AND (isDeleted is null OR isDeleted = false) and isActive = true")
	List findByDocTypeCode(String code);

	/**
	 * Method to delete valid document based on document category and type codes
	 * provided.
	 * 
	 * @param deletedDateTime the Date and time of deletion.
	 * @param docCategoryCode the document category code.
	 * @param docTypeCode     the document type code.
	 * @param updatedBy       the caller of deletion
	 * 
	 * @return the number of rows affected.
	 */
	@Modifying
	@Query("UPDATE ValidDocument v SET v.updatedBy=?4,v.isDeleted =true , v.deletedDateTime = ?1 ,isActive = false WHERE v.docCategoryCode =?2 and v.docTypeCode =?3 and (v.isDeleted is null or v.isDeleted =false)")
	int deleteValidDocument(LocalDateTime deletedDateTime, String docCategoryCode, String docTypeCode,
			String updatedBy);

	/**
	 * Method to find valid document based on Document Category code and Document
	 * Type code provided.
	 * 
	 * @param docCategoryCode the document category code.
	 * @param docTypeCode     the document type code.
	 * @return ValidDocument
	 */
	@Query("FROM ValidDocument WHERE docCategoryCode=?1 AND docTypeCode =?2 AND (isDeleted is null OR isDeleted = false)")
	ValidDocument findByDocCategoryCodeAndDocTypeCode(String docCategoryCode, String docTypeCode);

	/**
	 * Method to map valid document based on Document Category code and Document
	 * Type code provided.
	 * 
	 * @param updatedBy       the caller of updation
	 * @param updatedDateTime the Date and time of updation.
	 * @param docCategoryCode the document category code.
	 * @param docTypeCode     the document type code.
	 * 
	 * @return the number of rows affected.
	 */
	@Modifying
	@Query("UPDATE ValidDocument v SET v.isActive=?1, v.updatedBy=?2, v.updatedDateTime=?3 WHERE v.docCategoryCode=?4 and v.docTypeCode=?5 and (v.isDeleted is null or v.isDeleted =false)")
	int updateDocCategoryAndDocTypeMapping(boolean isActive, String updatedBy, LocalDateTime updatedDateTime,
			String docCategoryCode, String docTypeCode);

}