List of usage examples for com.liferay.portal.kernel.util StringPool PERCENT
String PERCENT
To view the source code for com.liferay.portal.kernel.util StringPool PERCENT.
Click Source Link
From source file:com.hitss.layer.service.impl.SolicitudEvaluacionDesempennoLocalServiceImpl.java
License:Open Source License
private DynamicQuery query(SolicitudEvaluacionDesempenno solicitudEvaluacion, Date fechaEvaluacionInicio, Date fechaEvaluacionFin, String orden, String campoOrden) { DynamicQuery query = DynamicQueryFactoryUtil.forClass(SolicitudEvaluacionDesempenno.class); if (Validator.isNotNull(solicitudEvaluacion)) { if (Validator.isNotNull(solicitudEvaluacion.getDescripcion())) { query.add(PropertyFactoryUtil.forName("descripcion") .like(StringPool.PERCENT + solicitudEvaluacion.getDescripcion() + StringPool.PERCENT)); }//from w w w .ja v a 2s .co m if (Validator.isNotNull(solicitudEvaluacion.getEstado())) { query.add(PropertyFactoryUtil.forName("estado").eq(solicitudEvaluacion.getEstado())); } } if (Validator.isNotNull(solicitudEvaluacion) && Validator.isNotNull(fechaEvaluacionFin)) { if (Validator.isNotNull(fechaEvaluacionInicio) && Validator.isNotNull(fechaEvaluacionFin)) { query.add( RestrictionsFactoryUtil.between("fechaInicio", fechaEvaluacionInicio, fechaEvaluacionFin)); } } query.add(PropertyFactoryUtil.forName("activo").eq(true)); query.addOrder(OrderFactoryUtil.desc("fechamodifica")); return query; }
From source file:com.htmsd.slayer.service.impl.ShoppingItemLocalServiceImpl.java
License:Open Source License
public List<ShoppingItem> searchItems(int status, String keyword, int start, int end) { String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingItem.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("updateUserName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("name"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("productCode"); junctionOR.add(property.like(likeKeyword)); dynamicQuery.add(junctionOR);/*ww w .j av a2 s .c om*/ dynamicQuery.add(RestrictionsFactoryUtil.eq("status", status)); List<ShoppingItem> searchList = new ArrayList<ShoppingItem>(); try { searchList = ShoppingItemLocalServiceUtil.dynamicQuery(dynamicQuery, start, end); } catch (SystemException e) { } return searchList; }
From source file:com.htmsd.slayer.service.impl.ShoppingItemLocalServiceImpl.java
License:Open Source License
public int searchCount(int status, String keyword) { String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingItem.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("updateUserName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("name"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("productCode"); junctionOR.add(property.like(likeKeyword)); dynamicQuery.add(junctionOR);//from ww w .j a v a 2 s . co m dynamicQuery.add(RestrictionsFactoryUtil.eq("status", status)); int searchCount = 0; try { searchCount = (int) ShoppingItemLocalServiceUtil.dynamicQueryCount(dynamicQuery); } catch (SystemException e) { } return searchCount; }
From source file:com.htmsd.slayer.service.impl.ShoppingOrderLocalServiceImpl.java
License:Open Source License
@SuppressWarnings("unchecked") public List<ShoppingOrder> searchShoppingOrder(int start, int end, long sellerId, boolean isSellerList, String keyword, String tabName) { _log.info("In searchShoppingOrder keyword is :-->> " + keyword); String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingOrder.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("sellerName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); if (CommonUtil.isNumeric(keyword)) { property = PropertyFactoryUtil.forName("quantity"); junctionOR.add(property.eq(Integer.valueOf(keyword))); }//from w w w. ja va 2s . c o m if (keyword.startsWith("HT")) { String orderId = keyword.substring(7, keyword.length()); _log.info("Order ItemId is ==>" + Long.valueOf(orderId)); junctionOR.add(RestrictionsFactoryUtil.eq("orderId", Long.valueOf(orderId))); } if (keyword.contains("-")) { Criterion criterion = PropertyFactoryUtil.forName("createDate") .between(getFromDateAndToDate(0, 0, 0, keyword), getFromDateAndToDate(23, 59, 59, keyword)); junctionOR.add(criterion); } dynamicQuery.add(junctionOR); if (isSellerList) { dynamicQuery.add(RestrictionsFactoryUtil.eq("sellerId", sellerId)); } else { dynamicQuery.add(RestrictionsFactoryUtil.eq("orderStatus", getOrderStatusByTabName(tabName))); } List<ShoppingOrder> searchList = new ArrayList<ShoppingOrder>(); try { searchList = ShoppingOrderLocalServiceUtil.dynamicQuery(dynamicQuery, start, end); } catch (SystemException e) { e.printStackTrace(); } return searchList; }
From source file:com.htmsd.slayer.service.impl.ShoppingOrderLocalServiceImpl.java
License:Open Source License
public int searchCount(long sellerId, boolean isSellerList, String tabName, String keyword) { _log.info("searchCount for Keyword :" + keyword); String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingOrder.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("sellerName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); if (CommonUtil.isNumeric(keyword)) { property = PropertyFactoryUtil.forName("quantity"); junctionOR.add(property.eq(Integer.valueOf(keyword))); }/*ww w. j av a2s .c o m*/ if (keyword.startsWith("HT")) { String orderId = keyword.substring(7, keyword.length()); junctionOR.add(RestrictionsFactoryUtil.eq("orderId", Long.valueOf(orderId))); } if (keyword.contains("-")) { Criterion criterion = PropertyFactoryUtil.forName("createDate") .between(getFromDateAndToDate(0, 0, 0, keyword), getFromDateAndToDate(23, 59, 59, keyword)); junctionOR.add(criterion); } dynamicQuery.add(junctionOR); if (isSellerList) { dynamicQuery.add(RestrictionsFactoryUtil.eq("sellerId", sellerId)); } else { dynamicQuery.add(RestrictionsFactoryUtil.eq("orderStatus", getOrderStatusByTabName(tabName))); } int searchCount = 0; try { searchCount = (int) ShoppingOrderLocalServiceUtil.dynamicQueryCount(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return searchCount; }
From source file:com.liferay.bbb.service.impl.BBBMeetingLocalServiceImpl.java
License:Open Source License
protected DynamicQuery buildDynamicQuery(long groupId, long userId, String name, String description, int status, boolean andSearch) { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(BBBMeeting.class, getClassLoader()); if (groupId > 0) { Property property = PropertyFactoryUtil.forName("groupId"); dynamicQuery.add(property.eq(groupId)); }//www .j a v a 2 s. com if (userId > 0) { Property property = PropertyFactoryUtil.forName("userId"); dynamicQuery.add(property.eq(userId)); } if (status != BBBMeetingConstants.STATUS_ANY) { Property property = PropertyFactoryUtil.forName("status"); dynamicQuery.add(property.eq(status)); } Junction junction = null; if (andSearch) { junction = RestrictionsFactoryUtil.conjunction(); } else { junction = RestrictionsFactoryUtil.disjunction(); } if (Validator.isNotNull(name)) { Property property = PropertyFactoryUtil.forName("name"); String value = StringUtil.quote(name, StringPool.PERCENT); junction.add(property.like(value)); } if (Validator.isNotNull(description)) { Property property = PropertyFactoryUtil.forName("description"); String value = StringUtil.quote(description, StringPool.PERCENT); junction.add(property.like(value)); } dynamicQuery.add(junction); return dynamicQuery; }
From source file:com.liferay.customsql.CustomSQL.java
License:Open Source License
public String[] keywords(String keywords, boolean lowerCase) { if (Validator.isNull(keywords)) { return new String[] { null }; }/* w w w . j a va 2 s. c o m*/ if (_CUSTOM_SQL_AUTO_ESCAPE_WILDCARDS_ENABLED) { keywords = escapeWildCards(keywords); } if (lowerCase) { keywords = StringUtil.toLowerCase(keywords); } keywords = keywords.trim(); List<String> keywordsList = new ArrayList<String>(); for (int i = 0; i < keywords.length(); i++) { char c = keywords.charAt(i); if (c == CharPool.QUOTE) { int pos = i + 1; i = keywords.indexOf(CharPool.QUOTE, pos); if (i == -1) { i = keywords.length(); } if (i > pos) { String keyword = keywords.substring(pos, i); keywordsList.add(StringUtil.quote(keyword, StringPool.PERCENT)); } } else { while (Character.isWhitespace(c)) { i++; c = keywords.charAt(i); } int pos = i; while (!Character.isWhitespace(c)) { i++; if (i == keywords.length()) { break; } c = keywords.charAt(i); } String keyword = keywords.substring(pos, i); keywordsList.add(StringUtil.quote(keyword, StringPool.PERCENT)); } } return keywordsList.toArray(new String[keywordsList.size()]); }
From source file:com.liferay.document.library.repository.cmis.search.CMISParameterValueUtil.java
License:Open Source License
public static String formatParameterValue(String field, String value, boolean wildcard, QueryConfig queryConfig) {/*from www . j a v a 2 s . co m*/ if (field.equals(Field.CREATE_DATE) || field.equals(Field.MODIFIED_DATE)) { try { DateFormat searchSimpleDateFormat = DateFormatFactoryUtil .getSimpleDateFormat(_INDEX_DATE_FORMAT_PATTERN); Date date = searchSimpleDateFormat.parse(value); DateFormat cmisSimpleDateFormat = DateFormatFactoryUtil .getSimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.000'Z'"); value = cmisSimpleDateFormat.format(date); } catch (ParseException pe) { if (_log.isWarnEnabled()) { _log.warn("Unable to parse date " + value + " for field " + field); } } } else { String productName = StringPool.BLANK; if (queryConfig != null) { productName = (String) queryConfig.getAttribute("repositoryProductName"); } if (Validator.isNotNull(productName) && productName.startsWith("Alfresco")) { value = StringUtil.replace(value, CharPool.APOSTROPHE, "\\'"); } else { value = StringUtil.replace(value, new char[] { CharPool.APOSTROPHE, CharPool.UNDERLINE }, new String[] { "\\'", "\\_" }); } if (wildcard) { value = StringUtil.replace(value, new char[] { CharPool.PERCENT, CharPool.STAR }, new String[] { "\\%", StringPool.PERCENT }); } } return value; }
From source file:com.liferay.jira.metrics.service.impl.JiraProjectLocalServiceImpl.java
License:Open Source License
public List<JiraProject> getInstalledJiraProjects() throws PortalException, SystemException { List<PortletPreferences> preferences = PortletPreferencesFinderUtil .findByPortletId(PortletKeys.JIRA_METRICS_PORTLET_ID + StringPool.PERCENT); if ((preferences == null) || preferences.isEmpty()) { return new ArrayList<JiraProject>(); }//from w w w . ja v a 2 s . co m List<JiraProject> jiraProjects = new ArrayList<JiraProject>(); for (PortletPreferences preference : preferences) { String xmlPreference = preference.getPreferences(); javax.portlet.PortletPreferences jxPortletPreferences = PortletPreferencesFactoryUtil .fromDefaultXML(xmlPreference); String jiraProjectName = jxPortletPreferences.getValue("jiraProject", null); JiraProject jiraProject = getJiraProjectByProjectLabel(jiraProjectName); if (!jiraProjects.contains(jiraProject)) { jiraProjects.add(jiraProject); } } return jiraProjects; }
From source file:com.liferay.jira.metrics.service.impl.JiraStatusLocalServiceImpl.java
License:Open Source License
public List<JiraStatus> getInstalledJiraStatuses(JiraProject jiraProject) throws PortalException, SystemException { List<PortletPreferences> preferences = PortletPreferencesFinderUtil .findByPortletId(PortletKeys.JIRA_METRICS_PORTLET_ID + StringPool.PERCENT); if ((preferences == null) || preferences.isEmpty()) { return new ArrayList<JiraStatus>(); }//from w w w .j av a 2s. com String projectKey = jiraProject.getKey(); List<JiraStatus> jiraStatuses = new ArrayList<JiraStatus>(); for (PortletPreferences preference : preferences) { String xmlPreference = preference.getPreferences(); javax.portlet.PortletPreferences jxPortletPreferences = PortletPreferencesFactoryUtil .fromDefaultXML(xmlPreference); String jiraProjectKeyPreference = jxPortletPreferences.getValue(PortletKeys.PREFERENCE_JIRA_PROJECT_KEY, null); if (projectKey.equals(jiraProjectKeyPreference)) { String[] jiraStatusNames = jxPortletPreferences.getValues(PortletKeys.PREFERENCE_JIRA_STATUSES, null); for (String jiraStatusName : jiraStatusNames) { JiraStatus jiraStatus = JiraStatusLocalServiceUtil.getJiraStatusByName(jiraStatusName); if (!jiraStatuses.contains(jiraStatus)) { jiraStatuses.add(jiraStatus); } } } } return jiraStatuses; }