public interface CamaRepo extends org.springframework.data.jpa.repository.JpaRepository<Cama,java.lang.Integer>
| Modifier and Type | Method and Description |
|---|---|
java.util.Optional<Cama> |
findByCodigo(java.lang.String codigo) |
java.util.Optional<Cama> |
findByCodigoAndDesocupada(java.lang.String codigo) |
java.util.List<Cama> |
findByGrupo(java.lang.String grupo) |
java.util.List<Cama> |
findByGrupoAndSubgrupo(java.lang.String grupo,
java.lang.String subgrupo) |
java.util.List<Cama> |
findByGrupoAndSubgrupoAndTipoAndEstado(java.lang.String grupo,
java.lang.String subgrupo,
java.lang.String tipo,
java.lang.String estado) |
java.lang.String |
findPaciente(int cama) |
java.lang.String |
findPacienteFinal(int cama) |
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlushfindAll@Query(value="select distinct c.* \nfrom HPNDEFCAM as c \nJOIN HPNTIPOCA as t \non c.HPNTIPOCA = t.oid \nJOIN HPNSUBGRU as s \non c.HPNSUBGRU = s.oid \nJOIN HPNGRUPOS as g \non c.HPNGRUPOS = g.oid \nwhere g.HGRNOMBRE like ?1 \nand s.hsunombre like ?2 \nand t.HTINOMBRE like \'%\'+ ?3 \nand (c.HCAESTADO like \'%\'+ ?4)",
nativeQuery=true)
java.util.List<Cama> findByGrupoAndSubgrupoAndTipoAndEstado(java.lang.String grupo,
java.lang.String subgrupo,
java.lang.String tipo,
java.lang.String estado)
@Query(value="select distinct c.* \nfrom HPNDEFCAM as c \nJOIN HPNSUBGRU as s \non c.HPNSUBGRU = s.oid \nJOIN HPNGRUPOS as g \non c.HPNGRUPOS = g.oid \nwhere g.HGRNOMBRE like ?1 \nand S.hsunombre like ?2 ",
nativeQuery=true)
java.util.List<Cama> findByGrupoAndSubgrupo(java.lang.String grupo,
java.lang.String subgrupo)
@Query(value="select distinct c.* \nfrom HPNDEFCAM as c \nJOIN HPNGRUPOS as g \non c.HPNGRUPOS = g.oid \nwhere g.HGRNOMBRE like ?1 ",
nativeQuery=true)
java.util.List<Cama> findByGrupo(java.lang.String grupo)
java.util.Optional<Cama> findByCodigo(java.lang.String codigo)
@Query(value="select * \nfrom HPNDEFCAM as c \nwhere c.HCACODIGO like ?1 \nand c.HCAESTADO like \'1\' ",
nativeQuery=true)
java.util.Optional<Cama> findByCodigoAndDesocupada(java.lang.String codigo)
@Query(value="select top (1) replace(ISNULL(PACPRINOM,\'\')+\' \'+ISNULL(PACSEGNOM,\'\')+\' \'+ISNULL(PACPRIAPE,\'\')+\' \'+ISNULL(PACSEGAPE,\'\'), \' \',\' \') as paciente, g.pacnumdoc as documento, i.AINCONSEC as consecutivo, i.AINFECING as fechaIngreso\nfrom GENPACIEN as g\njoin ADNINGRESO as i\non g.oid = i.GENPACIEN\nwhere i.HPNDEFCAM like ?1\nand i.AINESTADO like \'0\'\norder by i.AINFECING desc ",
nativeQuery=true)
java.lang.String findPaciente(int cama)
@Query(value="select top (1) replace(ISNULL(PACPRINOM,\'\')+\' \'+ISNULL(PACSEGNOM,\'\')+\' \'+ISNULL(PACPRIAPE,\'\')+\' \'+ISNULL(PACSEGAPE,\'\'), \' \',\' \') as paciente, g.pacnumdoc as documento, i.AINCONSEC as consecutivo, i.AINFECING as fechaIngreso\nfrom GENPACIEN as g\njoin ADNINGRESO as i\non g.oid = i.GENPACIEN\nwhere i.HPNDEFCAM like ?1\norder by i.AINFECING desc ",
nativeQuery=true)
java.lang.String findPacienteFinal(int cama)