/** * listInvestigations */ public ims.ocrr.vo.InvestigationIndexLiteVoCollection listInvestigations(String name, Boolean beginWith) { if (name != null) { name.replaceAll("%", ""); if (beginWith != null) name = (!beginWith ? "%" + name.toUpperCase() + "%" : name.toUpperCase() + "%"); else name = name.toUpperCase() + "%"; } return InvestigationIndexLiteVoAssembler.createInvestigationIndexLiteVoCollectionFromInvestigationIndex(getDomainFactory().find("select distinct i1_1 from InvestigationIndex as i1_1 left join i1_1.synonyms as i2_1 where (i1_1.category = :cat and ((i2_1.upperName like :name and i2_1.activeStatus = :Active) or i1_1.upperName like :name ) and i1_1.activeStatus = :status and i1_1.isProfile = :isProfile) order by i1_1.upperName", new String[] { "name", "cat", "status", "isProfile", "Active" }, new Object[] { name, getDomLookup(Category.CLINICAL), getDomLookup(PreActiveActiveInactiveStatus.ACTIVE), Boolean.FALSE, Boolean.TRUE })); }
public InvestigationIndexLiteVoCollection listInvestigationTypesSynonyms(String name, Boolean beginWith) { if(name != null) { name.replaceAll("%", ""); if(beginWith != null) name = (!beginWith ? "%" + name.toUpperCase() + "%" : name.toUpperCase() + "%"); else name = name.toUpperCase() + "%"; } return InvestigationIndexLiteVoAssembler.createInvestigationIndexLiteVoCollectionFromInvestigationIndex( getDomainFactory().find("select distinct i1_1 from InvestigationIndex as i1_1 left join i1_1.synonyms as i2_1 where (i1_1.category = :category and ((i2_1.upperName like :name and i2_1.activeStatus = :Active) or i1_1.upperName like :name )and i1_1.activeStatus = :status and i1_1.isProfile = :isProfile) order by i1_1.upperName", new String[] {"category", "name", "status", "isProfile", "Active"}, new Object[] {getDomLookup(Category.PATHOLOGY), name, getDomLookup(PreActiveActiveInactiveStatus.ACTIVE), Boolean.FALSE,Boolean.TRUE})); }
public InvestigationIndexLiteVoCollection listExamsSynonyms(String name,Boolean beginWith) { if(name != null) { name.replaceAll("%", ""); if(beginWith != null) name = (!beginWith ? "%" + name.toUpperCase() + "%" : name.toUpperCase() + "%"); else name = name.toUpperCase() + "%"; } return InvestigationIndexLiteVoAssembler.createInvestigationIndexLiteVoCollectionFromInvestigationIndex( getDomainFactory().find("select distinct i1_1 from InvestigationIndex as i1_1 left join i1_1.synonyms as i2_1 where (i1_1.category = :cat and ((i2_1.upperName like :name and i2_1.activeStatus = :Active) or i1_1.upperName like :name ) and i1_1.activeStatus = :status and i1_1.isProfile = :isProfile) order by i1_1.upperName", new String[] {"name", "cat", "status", "isProfile", "Active"}, new Object[] {name, getDomLookup(Category.CLINICALIMAGING), getDomLookup(PreActiveActiveInactiveStatus.ACTIVE), Boolean.FALSE, Boolean.TRUE})); }
public ims.ocrr.vo.InvestigationIndexLiteVoCollection listInvestigationTypes(String name) { if(name != null) name = name.toUpperCase(); return InvestigationIndexLiteVoAssembler.createInvestigationIndexLiteVoCollectionFromInvestigationIndex( getDomainFactory().find("from InvestigationIndex as i1_1 where (i1_1.category = :category and i1_1.upperName like :name and i1_1.activeStatus = :status and i1_1.isProfile = :isProfile) order by i1_1.upperName", new String[] {"category", "name", "status", "isProfile"}, new Object[] {getDomLookup(Category.PATHOLOGY), name, getDomLookup(PreActiveActiveInactiveStatus.ACTIVE), Boolean.FALSE})); }
/** * listExams */ public ims.ocrr.vo.InvestigationIndexLiteVoCollection listExams(String name) { if(name != null) name = name.toUpperCase(); return InvestigationIndexLiteVoAssembler.createInvestigationIndexLiteVoCollectionFromInvestigationIndex( getDomainFactory().find("from InvestigationIndex as i1_1 where (i1_1.category = :cat and i1_1.upperName like :name and i1_1.activeStatus = :status and i1_1.isProfile = :isProfile) order by i1_1.upperName", new String[] {"name", "cat", "status", "isProfile"}, new Object[] {name, getDomLookup(Category.CLINICALIMAGING), getDomLookup(PreActiveActiveInactiveStatus.ACTIVE), Boolean.FALSE})); }