public interface IngresoRepo extends org.springframework.data.jpa.repository.JpaRepository<Ingreso,java.lang.Integer>
| 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) |
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlushfindAll@Query(value="Select * from ADNINGRESO \nwhere AINCONSEC LIKE ?1 \nand AINESTADO like \'0\'",
nativeQuery=true)
java.util.Optional<Ingreso> findIngresoRegistradoByConsecutivo(int consecutivo)
@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)
@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)
@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)