public InvestigationIndexShortVoCollection listProfilesUsingInvestigation(InvestigationIndexRefVo invIndex) { if (invIndex == null) throw new CodingRuntimeException("parameter invIndex is null in method listProfilesUsingInvestigation"); DomainFactory factory = getDomainFactory(); return InvestigationIndexShortVoAssembler.createInvestigationIndexShortVoCollectionFromInvestigationIndex(getAssociatedItems(factory, invIndex.getID_InvestigationIndex())); }
/** * listInvestigationIndex */ public InvestigationIndexShortVoCollection listInvestigationIndex(String name, ServiceShortVo service, Category categoryLookup, PreActiveActiveInactiveStatus status,Boolean isProfile) { DomainFactory factory = getDomainFactory(); String hql = " select distinct invIndex from InvestigationIndex invIndex "; StringBuffer condStr = new StringBuffer(); String andStr = " "; ArrayList markers = new ArrayList(); ArrayList values = new ArrayList(); // please ensure no other criteria goes above this search element/// if(service != null) { condStr.append(andStr + " join invIndex.investigations as inv where inv.activeStatus.id <> :activeStatusId and inv.providerService.locationService.service.id = :idService"); //WDEV-17025 markers.add("activeStatusId"); values.add(PreActiveActiveInactiveStatus.INACTIVE.getID()); markers.add("idService"); values.add(service.getID_Service()); andStr = " and "; } else andStr = " where "; //////////////////////////////////////////////////////////////////// if(name != null) { condStr.append(andStr + " invIndex.upperName like :name"); markers.add("name"); values.add(name.toUpperCase() + "%"); andStr = " and "; } if(categoryLookup != null) { condStr.append(andStr + " invIndex.category = :category"); markers.add("category"); values.add(getDomLookup(categoryLookup)); andStr = " and "; } if(isProfile != null) { condStr.append(andStr + " invIndex.isProfile = :isProfile"); markers.add("isProfile"); values.add(isProfile); andStr = " and "; } if(status != null) { condStr.append(andStr + " invIndex.activeStatus = :status"); markers.add("status"); values.add(getDomLookup(status)); andStr = " and "; } hql += condStr.toString(); return InvestigationIndexShortVoAssembler.createInvestigationIndexShortVoCollectionFromInvestigationIndex(factory.find(hql,markers,values)).sort(); }
/** * listInvestigationIndex */ public InvestigationIndexShortVoCollection listInvestigationIndex(String name, String investigationCode, ServiceShortVo service, Category categoryLookup, PreActiveActiveInactiveStatus status, Boolean isProfile) { DomainFactory factory = getDomainFactory(); String hql = " select distinct invIndex from Investigation as inv left join inv.investigationIndex as invIndex"; StringBuffer condStr = new StringBuffer(); String andStr = " "; ArrayList<String> markers = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); // please ensure no other criteria goes above this search element/// if (investigationCode != null) { condStr.append(andStr + " where inv.providerInvCode = :invCode"); markers.add("invCode"); values.add(investigationCode); andStr = " and "; } else andStr = " where "; //////////////////////////////////////////////////////////////////// if(name != null) { condStr.append(andStr + " invIndex.upperName like :name"); markers.add("name"); values.add(name.toUpperCase() + "%"); andStr = " and "; } if(categoryLookup != null) { condStr.append(andStr + " invIndex.category = :category"); markers.add("category"); values.add(getDomLookup(categoryLookup)); andStr = " and "; } if(isProfile != null) { condStr.append(andStr + " invIndex.isProfile = :isProfile"); markers.add("isProfile"); values.add(isProfile); andStr = " and "; } if(status != null) { condStr.append(andStr + " invIndex.activeStatus = :status"); markers.add("status"); values.add(getDomLookup(status)); andStr = " and "; } hql += condStr.toString(); return InvestigationIndexShortVoAssembler.createInvestigationIndexShortVoCollectionFromInvestigationIndex(factory.find(hql,markers,values)).sort(); }