hus.censoCamas.repo

Interface CamaRepo

All Superinterfaces:

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

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

Method Summary

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)

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

findByGrupoAndSubgrupoAndTipoAndEstado

@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)

findByGrupoAndSubgrupo

@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)

findByGrupo

@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)

findByCodigo

java.util.Optional<Cama> findByCodigo(java.lang.String codigo)

findByCodigoAndDesocupada

@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)

findPaciente

@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)

findPacienteFinal

@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)