public ClinicLiteVoCollection listClinicsforLocation(LocationRefVo voLocRef, String strClinicName) { //WDEV-15039 ArrayList<String> names = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); String prepend = " where clin.isActive = 1 and "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (voLocRef != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(voLocRef.getID_Location()); prepend = " and "; } if (strClinicName != null && strClinicName.length() > 0) { hql.append(prepend + " (upper(clin.clinicName) like :clinName) "); names.add("clinName"); values.add("%" + strClinicName.toUpperCase() + "%"); } List clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
public ClinicLiteVoCollection listClinicsForLocationByClinicName(LocationRefVo refLocationVo, String strClinicName) { ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); String prepend = " where "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (refLocationVo != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(refLocationVo.getID_Location()); prepend = " and "; } if (strClinicName != null && strClinicName.length() > 0) { hql.append(prepend + " (upper(clin.clinicName) like :clinName) "); names.add("clinName"); values.add("%" + strClinicName.toUpperCase() + "%"); } List clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
public ClinicLiteVoCollection listClinicsForLocationByClinicName(LocationRefVo refLocationVo, String strClinicName) { ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); String prepend = " where "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (refLocationVo != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(refLocationVo.getID_Location()); prepend = " and "; } if (strClinicName != null && strClinicName.length() > 0) { hql.append(prepend + " (clin.upperName like :clinName) "); //WDEV-20219 names.add("clinName"); values.add("%" + strClinicName.toUpperCase() + "%"); } List clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
public ClinicLiteVoCollection listClinicsForLocationByClinicName(LocationRefVo refLocationVo, String strClinicName, Boolean activeOnly) { ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); String prepend = " where "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (refLocationVo != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(refLocationVo.getID_Location()); prepend = " and "; } if (strClinicName != null && strClinicName.length() > 0) { hql.append(prepend + " (upper(clin.clinicName) like :clinName) "); names.add("clinName"); values.add("%" + strClinicName.toUpperCase() + "%"); } if (activeOnly != null && activeOnly) { hql.append(prepend + " clin.isActive like :Active"); names.add("Active"); values.add(Boolean.TRUE); } List clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
public ClinicLiteVoCollection listClinics(String nameFilter, LocationRefVo voLocRef) { ArrayList<String> names = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); String prepend = " where "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (voLocRef != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(voLocRef.getID_Location()); prepend = " and "; } if (nameFilter != null && nameFilter.length() > 0) { hql.append(prepend + " (upper(clin.clinicName) like :clinName) "); names.add("clinName"); values.add("%" + nameFilter.toUpperCase() + "%"); prepend = " and "; } hql.append(prepend + " clin.isActive = 1 "); List<?> clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
public ClinicLiteVoCollection listClinics(String nameFilter, LocationRefVo voLocRef) { ArrayList<String> names = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); String prepend = " where "; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("from Clinic clin "); if (voLocRef != null) { hql.append(prepend + " clin.clinicLocation.id = :idLocation "); names.add("idLocation"); values.add(voLocRef.getID_Location()); prepend = " and "; } if (nameFilter != null && nameFilter.length() > 0) { hql.append(prepend + " (clin.upperName like :clinName) "); //WDEV-20219 names.add("clinName"); values.add("%" + nameFilter.toUpperCase() + "%"); prepend = " and "; } hql.append(prepend + " clin.isActive = 1 "); List<?> clinics = factory.find(hql.toString(), names, values, 1000); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics).sort(true); }
private ICspTypeSpecifier[] listProfileClinics() { DomainFactory factory = getDomainFactory(); ClinicLiteVoCollection voCollClinics = ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(factory.listDomainObjects(Clinic.class)); return voCollClinics.toICspTypeSpecifierArray(); }
public ClinicLiteVoCollection listClinics() { DomainFactory factory = getDomainFactory(); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(factory.listDomainObjects(Clinic.class)); }
public ClinicLiteVoCollection listClinicsForHospitalByNameLite(LocationRefVo location, String name) { DomainFactory factory = getDomainFactory(); List clinics = factory.find("from Clinic clin where clin.clinicLocation.id = :idLocation and upper(clin.clinicName) like :clinName and clin.isActive = 1 order by clin.clinicName", new String[]{"idLocation", "clinName"}, new Object[]{location.getID_Location(), "%" + name.toUpperCase() + "%"}); return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics); }
public ClinicLiteVoCollection listClinicsForHospitalByNameLite(LocationRefVo location, String name) { DomainFactory factory = getDomainFactory(); List clinics = factory.find("from Clinic clin where clin.clinicLocation.id = :idLocation and clin.upperName like :clinName and clin.isActive = 1 order by clin.upperName", new String[]{"idLocation", "clinName"}, new Object[]{location.getID_Location(), "%" + name.toUpperCase() + "%"}); //WDEV-20219 return ClinicLiteVoAssembler.createClinicLiteVoCollectionFromClinic(clinics); }