List of usage examples for com.liferay.portal.kernel.dao.orm RestrictionsFactoryUtil ilike
public static Criterion ilike(String propertyName, Object value)
From source file:at.graz.meduni.liferay.portlet.bibbox.kdssmp.service.model.impl.KdssmpPatientImpl.java
License:Open Source License
public Event getLastEventOfType(String eventtype) { DynamicQuery dynamicQuery = EventLocalServiceUtil.dynamicQuery(); Criterion criterion = RestrictionsFactoryUtil.ilike("eventtype", eventtype); dynamicQuery.add(criterion);/*ww w . j a va 2 s . com*/ dynamicQuery.addOrder(OrderFactoryUtil.desc("eventdate")); try { List<Event> events = EventLocalServiceUtil.dynamicQuery(dynamicQuery); if (events.size() > 1) { return events.get(0); } } catch (SystemException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; }
From source file:at.graz.meduni.liferay.portlet.bibbox.service.impl.OrganizationSearchIndexLocalServiceImpl.java
License:Open Source License
/** * /*from w ww. j av a 2 s. c o m*/ */ public List<Long> getOrganizationIdByKeywordAndValue(String key, String value) { value = value.trim(); List<Long> returnvalue = new ArrayList<Long>(); try { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(OrganizationSearchIndex.class); Criterion criterion = RestrictionsFactoryUtil.ilike("searchvalue", StringPool.PERCENT + value + StringPool.PERCENT); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("key", key)); dynamicQuery.add(criterion); Order order_organisationid = OrderFactoryUtil.asc("organisationid"); dynamicQuery.addOrder(order_organisationid); List<OrganizationSearchIndex> serachresults = OrganizationSearchIndexLocalServiceUtil .dynamicQuery(dynamicQuery); for (OrganizationSearchIndex serachresult : serachresults) { if (!returnvalue.contains(serachresult.getOrganisationid())) { returnvalue.add(serachresult.getOrganisationid()); } } } catch (SystemException e) { // TODO Auto-generated catch block e.printStackTrace(); } return returnvalue; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.BioBankLocalServiceImpl.java
License:Open Source License
public String getBioBankFiltered(String keyword, String country, String materialtype, String diagnosisavailable, String biobanksize, String typeofbiobank) { String array = ""; try {// ww w .j a va 2s .co m DynamicQuery dynamicQuery = BioBankLocalServiceUtil.dynamicQuery(); Criterion criterion = null; if (!keyword.equalsIgnoreCase("")) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); subQuery.add(RestrictionsFactoryUtil.ilike("searchindexvalue", "%" + keyword + "%")); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } if (!country.equalsIgnoreCase("")) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); subQuery.add(PropertyFactoryUtil.forName("searchindexvalue").eq(country)); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } if (!diagnosisavailable.equalsIgnoreCase("")) { Criterion criterion_sub = createSearchDiagnosisString(diagnosisavailable); DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); subQuery.add(criterion_sub); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } if (!materialtype.equalsIgnoreCase("")) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); Criterion criterion_sub = RestrictionsFactoryUtil.like("searchindexkey", materialtype); criterion_sub = RestrictionsFactoryUtil.and(criterion_sub, RestrictionsFactoryUtil.like("searchindexvalue", "TRUE")); subQuery.add(criterion_sub); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } if (!typeofbiobank.equalsIgnoreCase("")) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); Criterion criterion_sub = RestrictionsFactoryUtil.like("searchindexkey", "objectClass"); criterion_sub = RestrictionsFactoryUtil.and(criterion_sub, RestrictionsFactoryUtil.like("searchindexvalue", "%" + typeofbiobank + "%")); subQuery.add(criterion_sub); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } if (!biobanksize.equalsIgnoreCase("")) { String bbsize = ""; if (biobanksize.equalsIgnoreCase("< 10 Samples")) { bbsize = "0"; } else if (biobanksize.equalsIgnoreCase("10 - 100 Samples")) { bbsize = "1"; } else if (biobanksize.equalsIgnoreCase("100 - 1.000 Samples")) { bbsize = "2"; } else if (biobanksize.equalsIgnoreCase("1.000 - 10.000 Samples")) { bbsize = "3"; } else if (biobanksize.equalsIgnoreCase("10.000 - 100.000 Samples")) { bbsize = "4"; } else if (biobanksize.equalsIgnoreCase("100.000 - 1.000.000 Samples")) { bbsize = "5"; } else if (biobanksize.equalsIgnoreCase("1.000.000 - 10.000.000 Samples")) { bbsize = "6"; } else if (biobanksize.equalsIgnoreCase("10.000.000 - 100.000.000 Samples")) { bbsize = "7"; } else if (biobanksize.equalsIgnoreCase("100.000.000 - 1.000.000.000 Samples")) { bbsize = "8"; } DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(SearchIndex.class); Criterion criterion_sub = RestrictionsFactoryUtil.like("searchindexkey", "biobankSize"); criterion_sub = RestrictionsFactoryUtil.and(criterion_sub, RestrictionsFactoryUtil.like("searchindexvalue", bbsize)); subQuery.add(criterion_sub); subQuery.setProjection(ProjectionFactoryUtil.property("organisationid")); if (criterion == null) { criterion = PropertyFactoryUtil.forName("organisationid").in(subQuery); } else { criterion = RestrictionsFactoryUtil.and(criterion, PropertyFactoryUtil.forName("organisationid").in(subQuery)); } } // Add Criterion to the Main Biobank Query if (criterion != null) { dynamicQuery.add(criterion); } List<BioBank> biobanks = BioBankLocalServiceUtil.dynamicQuery(dynamicQuery); String seperator = ""; for (BioBank biobank : biobanks) { String diagnosis_avialavble = ""; SearchIndex searchindex = SearchIndexLocalServiceUtil.getSearchIndex(biobank.getOrganisationid(), "diagnosisAvailable"); if (searchindex != null) { diagnosis_avialavble = searchindex.getSearchindexvalue().replaceAll("urn:miriam:", ""); } array += seperator + "{"; //Country array += "Country: '" + biobank.getBiobankcountry().replaceAll("'", "\\\\'") + "',"; //BB ID array += "'BB_ID': '" + biobank.getLdapbiobankID().replaceAll("'", "\\\\'") + "',"; //BB Diagnosis array += "'Diagnosis': '" + diagnosis_avialavble.replaceAll("'", "\\\\'") + "',"; //Name array += "Name: '" + biobank.getBiobankname().replaceAll("'", "\\\\'") + "',"; //Type array += "Type: '" + biobank.getBiobanktype().replaceAll("'", "\\\\'") + "',"; //Size array += "Size: '" + biobank.getBiobanksize().replaceAll("'", "\\\\'") + "',"; //Juristic Person array += "'Juristic Person': '" + biobank.getBiobankjuristicperson().replaceAll("'", "\\\\'") + "'"; array += "}"; seperator = ","; } } catch (Exception ex) { System.out.println("[" + date_format_apache_error.format(new Date()) + "] [info] [BBMRIERICDatabase-portlet::at.meduni.liferay.portlet.bbmrieric.service.impl.BioBankLocalServiceImpl::getBioBankFiltered] Could not get Biobank List filtered (" + keyword + ", " + country + ", " + materialtype + ", " + diagnosisavailable + ", " + biobanksize + ")."); ex.printStackTrace(); } return array; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java
License:Open Source License
private DynamicQuery getBiobankQueryForKeywords(String keyword) { DynamicQuery dynamicQuery = D2BiobankLocalServiceUtil.dynamicQuery(); ProjectionList projectionList = ProjectionFactoryUtil.projectionList(); projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId")); dynamicQuery.setProjection(projectionList); String[] keywords = keyword.split(" "); Criterion criterion = null;/*w ww . j a v a 2 s . c o m*/ if (!keyword.equals("")) { for (String search : keywords) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("bbmribiobankID", "%" + search + "%"); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankJurisdicalPerson", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankCountry", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankAcronym", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadRole", "%" + search + "%")); } else { criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bbmribiobankID", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankJurisdicalPerson", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankCountry", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankAcronym", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("biobankHeadRole", "%" + search + "%")); } } } if (criterion != null) { dynamicQuery.add(criterion); } return dynamicQuery; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java
License:Open Source License
private DynamicQuery getBiobankQuery(String country, String typeofbiobank) { DynamicQuery dynamicQuery = D2BiobankLocalServiceUtil.dynamicQuery(); Criterion criterion = null;//ww w. j a v a2 s .co m if (!country.equals("")) { criterion = RestrictionsFactoryUtil.ilike("biobankCountry", "%" + country + "%"); } if (!typeofbiobank.equals("")) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("biobankType", "%" + typeofbiobank.replaceAll(" ", "") + "%"); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("biobankType", "%" + typeofbiobank.replaceAll(" ", "") + "%")); } } if (criterion != null) { dynamicQuery.add(criterion); } return dynamicQuery; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java
License:Open Source License
private DynamicQuery getCollectionSubqueryForKeywords(String keyword) { DynamicQuery dynamicQuery = D2CollectionLocalServiceUtil.dynamicQuery(); ProjectionList projectionList = ProjectionFactoryUtil.projectionList(); projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId")); dynamicQuery.setProjection(projectionList); String[] keywords = keyword.split(" "); Criterion criterion = null;//from ww w . j ava 2s . c om if (!keyword.equals("")) { for (String search : keywords) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("bbmricollectionID", "%" + search + "%"); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionAcronym", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("temperatureOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("diagnosisAvailable", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadRole", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionSampleAccessDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionDataAccessDescription", "%" + search + "%")); } else { criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bbmricollectionID", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("bioresourceReference", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionAcronym", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("temperatureOther", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("diagnosisAvailable", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionHeadRole", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionSampleAccessDescription", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("collectionDataAccessDescription", "%" + search + "%")); } } } if (criterion != null) { dynamicQuery.add(criterion); } return dynamicQuery; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java
License:Open Source License
private DynamicQuery getCollectionSubquery(String materialtype, String diagnosisavailable, String biobanksize, long powerof, String typeofcollection) { DynamicQuery dynamicQuery = D2CollectionLocalServiceUtil.dynamicQuery(); ProjectionList projectionList = ProjectionFactoryUtil.projectionList(); projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId")); dynamicQuery.setProjection(projectionList); Criterion criterion = null;/*from w ww . j av a 2 s . c o m*/ if (!materialtype.equals("")) { String[] materialtypes = { "Plasma", "Serum", "Urine", "Saliva", "Faeces", "RNA", "Blood", "Tissue Frozen", "Tissue FFPE", "Immortalized Cell Lines", "Isolated Pathogen" }; boolean others = true; for (String materialtypes_tmp : materialtypes) { if (materialtype.equalsIgnoreCase(materialtypes_tmp)) { String colname = "materialStored" + materialtypes_tmp.replaceAll(" ", ""); if (criterion == null) { criterion = RestrictionsFactoryUtil.eq(colname, true); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq(colname, true)); } others = false; } } if (others) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + materialtype + "%"); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("materialStoredOther", "%" + materialtype + "%")); } } } if (!diagnosisavailable.equals("")) { if (criterion == null) { criterion = createSearchDiagnosisString(diagnosisavailable); } else { criterion = RestrictionsFactoryUtil.and(criterion, createSearchDiagnosisString(diagnosisavailable)); } } if (!biobanksize.equals("")) { if (criterion == null) { criterion = RestrictionsFactoryUtil.eq("collectionOrderOfMagnitude", powerof); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("collectionOrderOfMagnitude", powerof)); } } if (!typeofcollection.equals("")) { String[] typeofcollections = { "Case Control", "Cohort", "Cross Sectional", "Longitudinal", "Twin Study", "Quality Control", "Population Based", "Disease Specific", "Birth Cohort" }; boolean others = true; for (String typeofcollection_tmp : typeofcollections) { if (typeofcollection.equalsIgnoreCase(typeofcollection_tmp)) { String colname = "collectionType" + typeofcollection_tmp.replaceAll(" ", ""); if (criterion == null) { criterion = RestrictionsFactoryUtil.eq(colname, true); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq(colname, true)); } others = false; } } if (others) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + typeofcollection + "%"); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("collectionTypeOther", "%" + typeofcollection + "%")); } } } dynamicQuery.add(criterion); return dynamicQuery; }
From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.D2BiobankLocalServiceImpl.java
License:Open Source License
private DynamicQuery getContactInformationSubquery(String keyword) { DynamicQuery dynamicQuery = D2BiobankLocalServiceUtil.dynamicQuery(); ProjectionList projectionList = ProjectionFactoryUtil.projectionList(); projectionList.add(ProjectionFactoryUtil.groupProperty("biobankId")); dynamicQuery.setProjection(projectionList); DynamicQuery dynamicQuerySub = ContactInformationLocalServiceUtil.dynamicQuery(); ProjectionList projectionList_Sub = ProjectionFactoryUtil.projectionList(); projectionList_Sub.add(ProjectionFactoryUtil.groupProperty("contactID")); dynamicQuerySub.setProjection(projectionList_Sub); String[] keywords = keyword.split(" "); Criterion criterion = null;//from w w w. ja v a 2 s . c o m for (String search : keywords) { if (criterion == null) { criterion = RestrictionsFactoryUtil.ilike("contactID", "%" + search + "%"); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactEmail", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactCountry", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactPhone", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactAddress", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactZIP", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactCity", "%" + search + "%")); } else { criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactID", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactEmail", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactCountry", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactFirstName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactLastName", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactPhone", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactAddress", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactZIP", "%" + search + "%")); criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("contactCity", "%" + search + "%")); } } dynamicQuerySub.add(criterion); dynamicQuery.add(PropertyFactoryUtil.forName("contactIDRef").in(dynamicQuerySub)); return dynamicQuery; }
From source file:at.meduni.liferay.portlet.rdconnect.service.impl.CandidateLocalServiceImpl.java
License:Open Source License
public List<Candidate> getFilterdCandidates(String name, String country, String type, String source, String state) throws SystemException { if (country.equals("all")) { country = ""; }/*w w w . j ava 2 s . co m*/ if (type.equals("all")) { type = ""; } else { if (type.equals("Registry")) type = "Registr"; } if (source.equals("all")) { source = ""; } if (state.equals("all")) { state = ""; } // Dynamic Query for search DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Candidate.class); Criterion criterion = null; Criterion criterion_subunit = RestrictionsFactoryUtil.isNull("subunitof"); criterion_subunit = RestrictionsFactoryUtil.or(criterion_subunit, RestrictionsFactoryUtil.eq("subunitof", "")); Criterion criterion_diseases = RestrictionsFactoryUtil.ilike("diseasesfreetext", StringPool.PERCENT + name + StringPool.PERCENT); criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases, RestrictionsFactoryUtil.ilike("diseasescodes", StringPool.PERCENT + name + StringPool.PERCENT)); criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases, RestrictionsFactoryUtil.ilike("name", StringPool.PERCENT + name + StringPool.PERCENT)); criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases, RestrictionsFactoryUtil.ilike("candidatesubtype", StringPool.PERCENT + name + StringPool.PERCENT)); try { long searchlong = Long.valueOf(name); criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases, RestrictionsFactoryUtil.eq("candidateId", searchlong)); } catch (Exception e) { } criterion = RestrictionsFactoryUtil.ilike("source", StringPool.PERCENT + source + StringPool.PERCENT); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("country", StringPool.PERCENT + country + StringPool.PERCENT)); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("candidatetype", StringPool.PERCENT + type + StringPool.PERCENT)); if (state.equalsIgnoreCase("")) { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil .not(RestrictionsFactoryUtil.ilike("state", StringPool.PERCENT + "X" + StringPool.PERCENT))); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("state", StringPool.PERCENT + state + StringPool.PERCENT)); } criterion = RestrictionsFactoryUtil.and(criterion, criterion_diseases); criterion = RestrictionsFactoryUtil.and(criterion, criterion_subunit); dynamicQuery.add(criterion); Order countryOrder = OrderFactoryUtil.desc("country"); Order nameOrder = OrderFactoryUtil.desc("name"); //Order candidateidOrder = OrderFactoryUtil.asc("candidateId"); //Order masteridOrder = OrderFactoryUtil.desc("masterId"); dynamicQuery.addOrder(countryOrder); dynamicQuery.addOrder(nameOrder); List<Candidate> candidates = CandidateLocalServiceUtil.dynamicQuery(dynamicQuery); //List<Candidate> candidates = candidatePersistence.findByCNSTDD(country, name, source, type, diseases_freetext, diseases_code, ""); return candidates; }
From source file:at.meduni.liferay.portlet.rdconnect.service.impl.MasterCandidateLocalServiceImpl.java
License:Open Source License
public List<MasterCandidate> getFilterdCandidates(String searchstring, String country, String type, String state, String source) throws SystemException { if (country.equals("all")) { country = ""; }//from ww w .j a va2 s . c om if (type.equals("all")) { type = ""; } else { if (type.equals("Registry")) type = "Registr"; } if (state.equals("all")) { state = ""; } if (source.equals("all")) { source = ""; } List<MasterCandidate> mastercandidate = null; try { // Dynamic Query for search DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(MasterCandidateImpl.class); Criterion criterion = null; Criterion criterion_stringsearch_grouped = null; String[] searchstringarray = searchstring.split(" "); for (String searchstringsplit : searchstringarray) { Criterion criterion_stringsearch = RestrictionsFactoryUtil.ilike("diseasesfreetext", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("diseasescodes", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("name", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("candidatesubtype", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("country", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("candidatetype", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("url", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("contactperson", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("comment", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("address", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("mail", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil .ilike("head", StringPool.PERCENT + searchstringsplit + StringPool.PERCENT)); try { long searchlong = Long.valueOf(searchstringsplit); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil.eq("masterCandidateId", searchlong)); criterion_stringsearch = RestrictionsFactoryUtil.or(criterion_stringsearch, RestrictionsFactoryUtil.eq("organisationid", searchlong)); } catch (Exception e) { } if (criterion_stringsearch_grouped == null) { criterion_stringsearch_grouped = criterion_stringsearch; } else { criterion_stringsearch_grouped = RestrictionsFactoryUtil.or(criterion_stringsearch_grouped, criterion_stringsearch); } } criterion = RestrictionsFactoryUtil.ilike("country", StringPool.PERCENT + country + StringPool.PERCENT); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("candidatetype", StringPool.PERCENT + type + StringPool.PERCENT)); criterion = RestrictionsFactoryUtil.and(criterion, criterion_stringsearch_grouped); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("state", StringPool.PERCENT + state + StringPool.PERCENT)); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.sqlRestriction("state_ NOT ILIKE 'x'")); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.sqlRestriction("state_ NOT ILIKE '0'")); criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ilike("source", StringPool.PERCENT + source + StringPool.PERCENT)); dynamicQuery.add(criterion); Order countryOrder = OrderFactoryUtil.asc("country"); Order joinIdOrder = OrderFactoryUtil.asc("joinId"); Order nameOrder = OrderFactoryUtil.asc("name"); dynamicQuery.addOrder(countryOrder); dynamicQuery.addOrder(joinIdOrder); dynamicQuery.addOrder(nameOrder); mastercandidate = MasterCandidateLocalServiceUtil.dynamicQuery(dynamicQuery); } catch (Exception e) { e.printStackTrace(); } return mastercandidate; }