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:org.opencps.dossiermgt.service.persistence.DossierFinderImpl.java
License:Open Source License
/** * @param groupId/*ww w . ja va 2s. co m*/ * @param userId * @param keywords * @param serviceDomainTreeIndex * @param dossierStatus * @param andOperator * @param start * @param end * @param obc * @return */ private List<DossierBean> searchDossierByUser(long groupId, long userId, String[] keywords, String serviceDomainTreeIndex, String dossierStatus, boolean andOperator, int start, int end, OrderByComparator obc) { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(SEARCH_DOSSIER_BY_USER); if (keywords != null && keywords.length > 0) { sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE, true, keywords); sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_service_config.govAgencyName)", StringPool.LIKE, true, keywords); sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossier.subjectName)", StringPool.LIKE, true, keywords); sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossier.receptionNo)", StringPool.LIKE, true, keywords); } else { sql = StringUtil.replace(sql, "AND ((lower(opencps_serviceinfo.serviceName) LIKE ? [$AND_OR_NULL_CHECK$]) OR (lower(opencps_service_config.govAgencyName) LIKE ? [$AND_OR_NULL_CHECK$]) OR (lower(opencps_dossier.subjectName) LIKE ? [$AND_OR_NULL_CHECK$]) OR (lower(opencps_dossier.receptionNo) LIKE ? [$AND_OR_NULL_CHECK$]))", StringPool.BLANK); } if (Validator.isNull(serviceDomainTreeIndex)) { sql = StringUtil.replace(sql, "AND (opencps_dossier.serviceDomainIndex LIKE ? OR opencps_dossier.serviceDomainIndex = ?)", StringPool.BLANK); } else { if (StringUtil.contains(serviceDomainTreeIndex, StringPool.PERIOD)) { sql = StringUtil.replace(sql, "AND (opencps_dossier.serviceDomainIndex LIKE ? OR opencps_dossier.serviceDomainIndex = ?)", "AND (opencps_dossier.serviceDomainIndex LIKE ?)"); serviceDomainTreeIndex = serviceDomainTreeIndex.substring(0, serviceDomainTreeIndex.indexOf(StringPool.PERIOD) + 1); } } if (Validator.isNull(dossierStatus)) { sql = StringUtil.replace(sql, "AND (opencps_dossier.dossierStatus = ?)", StringPool.BLANK); } sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); SQLQuery q = session.createSQLQuery(sql); q.addEntity("Dossier", DossierImpl.class); q.addScalar("SERVICE_NAME", Type.STRING); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(userId); if (Validator.isNotNull(serviceDomainTreeIndex) && StringUtil.contains(serviceDomainTreeIndex, StringPool.PERIOD)) { qPos.add(serviceDomainTreeIndex + StringPool.PERCENT); } else if (Validator.isNotNull(serviceDomainTreeIndex) && !StringUtil.contains(serviceDomainTreeIndex, StringPool.PERIOD)) { qPos.add(serviceDomainTreeIndex + StringPool.PERIOD + StringPool.PERCENT); qPos.add(serviceDomainTreeIndex); } if (keywords != null && keywords.length > 0) { qPos.add(keywords, 2); qPos.add(keywords, 2); qPos.add(keywords, 2); qPos.add(keywords, 2); } if (Validator.isNotNull(dossierStatus)) { qPos.add(dossierStatus); } Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.list(q, getDialect(), start, end).iterator(); List<DossierBean> dossierBeans = new ArrayList<DossierBean>(); if (itr.hasNext()) { while (itr.hasNext()) { DossierBean dossierBean = new DossierBean(); Object[] objects = itr.next(); Dossier dossier = (Dossier) objects[0]; String serviceName = (String) objects[1]; dossierBean.setDossierId(dossier.getDossierId()); dossierBean.setDossier(dossier); dossierBean.setServiceName(serviceName); dossierBeans.add(dossierBean); } } return dossierBeans; } catch (Exception e) { _log.error(e); } finally { closeSession(session); } return null; }
From source file:org.opencps.dossiermgt.service.persistence.ServiceConfigFinderImpl.java
License:Open Source License
/** * @param groupId/*from w w w . ja va 2s. com*/ * @param keywords * @param servicePortal * @param serviceOnegate * @param serviceBackoffice * @param serviceCitizen * @param serviceBusinees * @param serviceDomainIndex * @param govAgencyIndex * @param andOperator * @return */ private int _countServiceConfigAdvance(long groupId, String[] keywords, int servicePortal, int serviceOnegate, int serviceBackoffice, int serviceCitizen, int serviceBusinees, String serviceDomainIndex, String govAgencyIndex, boolean andOperator) { Session session = null; try { session = openSession(); // get sql command from sql xml String sql = CustomSQLUtil.get(COUNT_SERVICE_CONFIG_ADVANCE_SQL); if (keywords != null && keywords.length > 0) { sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE, true, keywords); } else { sql = StringUtil.replace(sql, "AND ((lower(opencps_serviceinfo.serviceName) LIKE ? [$AND_OR_NULL_CHECK$]))", StringPool.BLANK); } if (servicePortal != 1 && servicePortal != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.servicePortal = ?", StringPool.BLANK); } if (serviceOnegate != 1 && serviceOnegate != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceOnegate = ?", StringPool.BLANK); } if (serviceBackoffice != 1 && serviceBackoffice != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceBackoffice = ?", StringPool.BLANK); } if (serviceCitizen != 1 && serviceCitizen != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceCitizen = ?", StringPool.BLANK); } if (serviceBusinees != 1 && serviceBusinees != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceBusinees = ?", StringPool.BLANK); } if (Validator.isNull(serviceDomainIndex)) { sql = StringUtil.replace(sql, "AND (opencps_service_config.serviceDomainIndex LIKE ? OR opencps_service_config.serviceDomainIndex = ?)", StringPool.BLANK); } else { if (StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { serviceDomainIndex = serviceDomainIndex.substring(0, serviceDomainIndex.indexOf(StringPool.PERIOD) + 1); sql = StringUtil.replace(sql, "AND (opencps_service_config.serviceDomainIndex LIKE ? OR opencps_service_config.serviceDomainIndex = ?)", "AND (opencps_service_config.serviceDomainIndex LIKE ?"); } } if (Validator.isNull(govAgencyIndex)) { sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyIndex LIKE ? OR opencps_service_config.govAgencyIndex = ?)", StringPool.BLANK); } else { if (StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { govAgencyIndex = govAgencyIndex.substring(0, govAgencyIndex.indexOf(StringPool.PERIOD) + 1); sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyIndex LIKE ? OR opencps_service_config.govAgencyIndex = ?)", "AND (opencps_service_config.govAgencyIndex LIKE ?"); } } sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); SQLQuery q = session.createSQLQuery(sql); q.setCacheable(false); q.addScalar(COUNT_COLUMN_NAME, Type.INTEGER); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); if (keywords != null && keywords.length > 0) { qPos.add(keywords, 2); } if (servicePortal == 1) { qPos.add(true); } else if (servicePortal == 0) { qPos.add(false); } if (serviceOnegate == 1) { qPos.add(true); } else if (serviceOnegate == 0) { qPos.add(false); } if (serviceBackoffice == 1) { qPos.add(true); } else if (serviceBackoffice == 0) { qPos.add(false); } if (serviceCitizen == 1) { qPos.add(true); } else if (serviceCitizen == 0) { qPos.add(false); } if (serviceBusinees == 1) { qPos.add(true); } else if (serviceBusinees == 0) { qPos.add(false); } if (Validator.isNotNull(serviceDomainIndex) && StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { qPos.add(serviceDomainIndex + StringPool.PERCENT); } else if (Validator.isNotNull(serviceDomainIndex) && !StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { qPos.add(serviceDomainIndex + StringPool.PERIOD + StringPool.PERCENT); qPos.add(serviceDomainIndex); } if (Validator.isNotNull(govAgencyIndex) && StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { qPos.add(govAgencyIndex + StringPool.PERCENT); } else if (Validator.isNotNull(govAgencyIndex) && !StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { qPos.add(govAgencyIndex + StringPool.PERIOD + StringPool.PERCENT); qPos.add(govAgencyIndex); } Iterator<Integer> itr = q.iterate(); if (itr.hasNext()) { Integer count = itr.next(); if (count != null) { return count.intValue(); } } } catch (Exception e) { _log.error(e); } finally { session.close(); } return 0; }
From source file:org.opencps.dossiermgt.service.persistence.ServiceConfigFinderImpl.java
License:Open Source License
/** * @param groupId//from w w w . ja v a 2s . c o m * @param keywords * @param servicePortal * @param serviceOnegate * @param serviceBackoffice * @param serviceCitizen * @param serviceBusinees * @param serviceDomainIndex * @param govAgencyIndex * @param start * @param end * @param orderByComparator * @param andOperator * @return */ private List<ServiceBean> _searchServiceConfigAdvance(long groupId, String[] keywords, int servicePortal, int serviceOnegate, int serviceBackoffice, int serviceCitizen, int serviceBusinees, String serviceDomainIndex, String govAgencyIndex, int start, int end, OrderByComparator orderByComparator, boolean andOperator) { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(SEARCH_SERVICE_CONFIG_ADVANCE_SQL); if (keywords != null && keywords.length > 0) { sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE, true, keywords); } else { sql = StringUtil.replace(sql, "AND ((lower(opencps_serviceinfo.serviceName) LIKE ? [$AND_OR_NULL_CHECK$]))", StringPool.BLANK); } if (servicePortal != 1 && servicePortal != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.servicePortal = ?", StringPool.BLANK); } if (serviceOnegate != 1 && serviceOnegate != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceOnegate = ?", StringPool.BLANK); } if (serviceBackoffice != 1 && serviceBackoffice != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceBackoffice = ?", StringPool.BLANK); } if (serviceCitizen != 1 && serviceCitizen != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceCitizen = ?", StringPool.BLANK); } if (serviceBusinees != 1 && serviceBusinees != 0) { sql = StringUtil.replace(sql, "AND opencps_service_config.serviceBusinees = ?", StringPool.BLANK); } if (Validator.isNull(serviceDomainIndex)) { sql = StringUtil.replace(sql, "AND (opencps_service_config.serviceDomainIndex LIKE ? OR opencps_service_config.serviceDomainIndex = ?)", StringPool.BLANK); } else { if (StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { serviceDomainIndex = serviceDomainIndex.substring(0, serviceDomainIndex.indexOf(StringPool.PERIOD) + 1); sql = StringUtil.replace(sql, "AND (opencps_service_config.serviceDomainIndex LIKE ? OR opencps_service_config.serviceDomainIndex = ?)", "AND (opencps_service_config.serviceDomainIndex LIKE ?"); } } if (Validator.isNull(govAgencyIndex)) { sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyIndex LIKE ? OR opencps_service_config.govAgencyIndex = ?)", StringPool.BLANK); } else { if (StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { govAgencyIndex = govAgencyIndex.substring(0, govAgencyIndex.indexOf(StringPool.PERIOD) + 1); sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyIndex LIKE ? OR opencps_service_config.govAgencyIndex = ?)", "AND (opencps_service_config.govAgencyIndex LIKE ?"); } } sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); SQLQuery q = session.createSQLQuery(sql); q.setCacheable(false); q.addEntity("ServiceConfig", ServiceConfigImpl.class); q.addScalar("serviceName", Type.STRING); q.addScalar("fullName", Type.STRING); q.addScalar("serviceNo", Type.STRING); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); if (keywords != null && keywords.length > 0) { qPos.add(keywords, 2); } if (servicePortal == 1) { qPos.add(true); } else if (servicePortal == 0) { qPos.add(false); } if (serviceOnegate == 1) { qPos.add(true); } else if (serviceOnegate == 0) { qPos.add(false); } if (serviceBackoffice == 1) { qPos.add(true); } else if (serviceBackoffice == 0) { qPos.add(false); } if (serviceCitizen == 1) { qPos.add(true); } else if (serviceCitizen == 0) { qPos.add(false); } if (serviceBusinees == 1) { qPos.add(true); } else if (serviceBusinees == 0) { qPos.add(false); } if (Validator.isNotNull(serviceDomainIndex) && StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { qPos.add(serviceDomainIndex + StringPool.PERCENT); } else if (Validator.isNotNull(serviceDomainIndex) && !StringUtil.contains(serviceDomainIndex, StringPool.PERIOD)) { qPos.add(serviceDomainIndex + StringPool.PERIOD + StringPool.PERCENT); qPos.add(serviceDomainIndex); } if (Validator.isNotNull(govAgencyIndex) && StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { qPos.add(govAgencyIndex + StringPool.PERCENT); } else if (Validator.isNotNull(govAgencyIndex) && !StringUtil.contains(govAgencyIndex, StringPool.PERIOD)) { qPos.add(govAgencyIndex + StringPool.PERIOD + StringPool.PERCENT); qPos.add(govAgencyIndex); } Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.list(q, getDialect(), start, end).iterator(); List<ServiceBean> serviceBeans = new ArrayList<ServiceBean>(); if (itr.hasNext()) { while (itr.hasNext()) { ServiceBean serviceBean = new ServiceBean(); Object[] objects = itr.next(); ServiceConfig serviceConfig = (ServiceConfig) objects[0]; String serviceName = (String) objects[1]; String fullName = (String) objects[2]; String serviceNo = (String) objects[3]; serviceBean.setCompanyId(serviceConfig.getCompanyId()); serviceBean.setDossierTemplateId(serviceConfig.getDossierTemplateId()); serviceBean.setFullName(fullName); serviceBean.setDomainCode(serviceConfig.getDomainCode()); serviceBean.setLevel(serviceConfig.getServiceLevel()); serviceBean.setGovAgencyCode(serviceConfig.getGovAgencyCode()); serviceBean.setGovAgencyIndex(serviceConfig.getGovAgencyIndex()); serviceBean.setGovAgencyName(serviceConfig.getGovAgencyName()); serviceBean.setGovAgencyOrganizationId(serviceConfig.getGovAgencyOrganizationId()); serviceBean.setGroupId(groupId); serviceBean.setServiceAdministrationIndex(serviceConfig.getServiceAdministrationIndex()); serviceBean.setServiceBackoffice(serviceConfig.getServiceBackoffice()); serviceBean.setServiceBusinees(serviceConfig.getServiceBusinees()); serviceBean.setServiceCitizen(serviceConfig.getServiceCitizen()); serviceBean.setServiceConfigId(serviceConfig.getServiceConfigId()); serviceBean.setServiceDomainIndex(serviceDomainIndex); serviceBean.setServiceInfoId(serviceConfig.getServiceInfoId()); serviceBean.setServiceLevel(serviceConfig.getServiceLevel()); serviceBean.setServiceName(serviceName); serviceBean.setServiceNo(serviceNo); serviceBean.setServiceOnegate(serviceConfig.getServiceOnegate()); serviceBean.setServicePortal(serviceConfig.getServicePortal()); serviceBean.setServiceProcessId(serviceConfig.getServiceProcessId()); serviceBean.setUserId(serviceConfig.getUserId()); serviceBeans.add(serviceBean); } } return serviceBeans; } catch (Exception e) { _log.error(e); } finally { session.close(); } return null; }
From source file:org.opencps.servicemgt.service.impl.ServiceInfoLocalServiceImpl.java
License:Open Source License
public List<ServiceInfo> getServiceInFosByG_DI(long groupId, String domainIndex) throws SystemException { String bufferDomainIndex = Validator.isNotNull(domainIndex) ? StringPool.PERCENT + domainIndex + StringPool.PERCENT : StringPool.PERCENT + StringPool.PERCENT; return serviceInfoPersistence.findByG_DI(groupId, bufferDomainIndex); }