hus.censoCamas.repo

Interface IngresoRepo

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Ingreso,java.lang.Integer>, org.springframework.data.jpa.repository.JpaRepository<Ingreso,java.lang.Integer>, org.springframework.data.repository.PagingAndSortingRepository<Ingreso,java.lang.Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Ingreso>, org.springframework.data.repository.Repository<Ingreso,java.lang.Integer>

public interface IngresoRepo
extends org.springframework.data.jpa.repository.JpaRepository<Ingreso,java.lang.Integer>

Method Summary

Modifier and Type	Method and Description
java.util.Optional<Ingreso>	findByPacienteOrderByFechaIngresoDesc(int paciente)
java.util.Optional<Ingreso>	findIngresoRegistradoByConsecutivo(int consecutivo)
java.util.Optional<java.util.List<Ingreso>>	findIngresoRegistradoByPacienteDocumento(java.lang.String documento)
java.util.Optional<java.util.List<Ingreso>>	findIngresoRegistradoByPacienteNombre(java.lang.String nombre)

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Method Detail

findIngresoRegistradoByConsecutivo

@Query(value="Select * from ADNINGRESO \nwhere AINCONSEC LIKE ?1 \nand AINESTADO like \'0\'",
       nativeQuery=true)
java.util.Optional<Ingreso> findIngresoRegistradoByConsecutivo(int consecutivo)

findIngresoRegistradoByPacienteNombre

@Query(value="Select i.*\nfrom ADNINGRESO as i \njoin GENPACIEN as p\non i.genpacien = p.oid\nwhere replace(ISNULL(PACPRINOM,\'\')+\' \'+ISNULL(PACSEGNOM,\'\')+\' \'+ISNULL(PACPRIAPE,\'\')+\' \'+ISNULL(PACSEGAPE,\'\'), \'   \',\' \') LIKE %?1% \nand i.ainestado like \'0\'\norder by i.ainfecing desc",
       nativeQuery=true)
java.util.Optional<java.util.List<Ingreso>> findIngresoRegistradoByPacienteNombre(java.lang.String nombre)

findIngresoRegistradoByPacienteDocumento

@Query(value="Select i.*\nfrom ADNINGRESO as i \njoin GENPACIEN as p\non i.genpacien = p.oid\nwhere p.PACNUMDOC LIKE %?1% \nand i.ainestado like \'0\'\norder by i.ainfecing desc",
       nativeQuery=true)
java.util.Optional<java.util.List<Ingreso>> findIngresoRegistradoByPacienteDocumento(java.lang.String documento)

findByPacienteOrderByFechaIngresoDesc

@Query(value="Select top(1) i.* from ADNINGRESO as i\njoin GENPACIEN as p \non p.oid = i.GENPACIEN  \nwhere i.GENPACIEN LIKE ?1 \nand i.AINESTADO like \'0\' \nOrder by i.AINFECING desc",
       nativeQuery=true)
java.util.Optional<Ingreso> findByPacienteOrderByFechaIngresoDesc(int paciente)