Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
package io.mosip.kernel.masterdata.repository;
import java.time.LocalDateTime;
import java.util.List;
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.MachineHistory;
/**
* Repository function to fetching machine History Details
*
* @author Megha Tanga
* @since 1.0.0
*
*/
@Repository
public interface MachineHistoryRepository extends BaseRepository {
/**
* This method trigger query to fetch Machine History Details based on Machine
* History Id, language code and effective date time
*
* @param id Machine History id provided by user
* @param langCode language code provided by user
* @param effectDtimes effective Date and time provided by user in the format
* "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"
* @return List Machine History Details fetched from database
*/
@Query(value = "Select m.eff_dtimes, m.id,m.cr_by, m.cr_dtimes, m.del_dtimes, m.is_active, m.is_deleted, m.upd_by, m.upd_dtimes, m.ip_address, m.lang_code, m.mac_address, m.mspec_id, m.name, m.serial_num, m.validity_end_dtimes, m.zone_code,m.regcntr_id, m.key_index, m.public_key, m.sign_public_key, m.sign_key_index from master.machine_master_h m where m.id = ?1 and m.lang_code = ?2 and m.eff_dtimes <= ?3 and ( m.is_deleted = false or m.is_deleted is null) order by m.eff_dtimes desc limit 1", nativeQuery = true)
List findByFirstByIdAndLangCodeAndEffectDtimesLessThanEqualAndIsDeletedFalseOrIsDeletedIsNull(
String id, String langCode, LocalDateTime effectDtimes);
@Query(value = "Select m.eff_dtimes, m.id,m.cr_by, m.cr_dtimes, m.del_dtimes, m.is_active, m.is_deleted, m.upd_by, m.upd_dtimes, m.ip_address, m.lang_code, m.mac_address, m.mspec_id, m.name, m.serial_num, m.validity_end_dtimes, m.zone_code,m.regcntr_id, m.key_index, m.public_key, m.sign_public_key, m.sign_key_index from master.machine_master_h m where m.regcntr_id = ?1 and m.id = ?2 and m.eff_dtimes <= ?3 and ( m.is_deleted = false or m.is_deleted is null) order by m.eff_dtimes desc ", nativeQuery = true)
List findByCntrIdAndMachineIdAndEffectivetimesLessThanEqualAndIsDeletedFalseOrIsDeletedIsNull(
String registrationCenterId, String machineId, LocalDateTime lDateAndTime);
}
