List of usage examples for com.liferay.portal.kernel.util StringPool PERIOD
String PERIOD
To view the source code for com.liferay.portal.kernel.util StringPool PERIOD.
Click Source Link
From source file:org.opencps.dossiermgt.service.persistence.ServiceConfigFinderImpl.java
License:Open Source License
/** * @param groupId//from w w w. j a v a 2 s . c o m * @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//w w w . j av a 2 s . co 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.processmgt.portlet.ProcessOrderPortlet.java
License:Open Source License
/** * @param actionRequest//ww w .j a va 2s . c o m * @param actionResponse * @throws IOException */ public void cloneDossierFile(ActionRequest actionRequest, ActionResponse actionResponse) throws IOException { /*AccountBean accountBean = AccountUtil.getAccountBeanFromAttribute(actionRequest);*/ AccountBean accountBean = AccountUtil.getAccountBean(actionRequest); Dossier dossier = null; DossierFile dossierFile = null; DossierPart dossierPart = null; boolean updated = false; long cloneDossierFileId = ParamUtil.getLong(actionRequest, "cloneDossierFileId"); long dossierId = ParamUtil.getLong(actionRequest, DossierDisplayTerms.DOSSIER_ID); long dossierPartId = ParamUtil.getLong(actionRequest, DossierFileDisplayTerms.DOSSIER_PART_ID); long groupDossierPartId = ParamUtil.getLong(actionRequest, "groupDossierPartId"); long fileGroupId = ParamUtil.getLong(actionRequest, DossierDisplayTerms.FILE_GROUP_ID); String groupName = ParamUtil.getString(actionRequest, DossierFileDisplayTerms.GROUP_NAME); String redirectURL = ParamUtil.getString(actionRequest, "redirectURL"); try { validateCloneDossierFile(dossierId, dossierPartId, cloneDossierFileId, accountBean); dossierFile = DossierFileLocalServiceUtil.getDossierFile(cloneDossierFileId); long fileEntryId = dossierFile.getFileEntryId(); FileEntry fileEntry = DLAppServiceUtil.getFileEntry(fileEntryId); ServiceContext serviceContext = ServiceContextFactory.getInstance(actionRequest); serviceContext.setAddGroupPermissions(true); serviceContext.setAddGuestPermissions(true); dossier = DossierLocalServiceUtil.getDossier(dossierId); dossierPart = DossierPartLocalServiceUtil.getDossierPart(dossierPartId); /* * DLFolder accountFolder = accountBean.getAccountFolder(); DLFolder * dossierFolder = DLFolderUtil.addFolder( * serviceContext.getUserId(), serviceContext.getScopeGroupId(), * serviceContext.getScopeGroupId(), false, * accountFolder.getFolderId(), * String.valueOf(dossier.getCounter()), StringPool.BLANK, false, * serviceContext); */ DossierFileLocalServiceUtil.addDossierFile(serviceContext.getUserId(), dossierId, dossierPartId, dossierPart.getTemplateFileNo(), groupName, fileGroupId, groupDossierPartId, accountBean.getOwnerUserId(), accountBean.getOwnerOrganizationId(), dossierFile.getDisplayName(), StringPool.BLANK, dossierFile != null ? dossierFile.getFileEntryId() : 0, PortletConstants.DOSSIER_FILE_MARK_UNKNOW, dossierFile.getDossierFileType(), dossierFile.getDossierFileNo(), dossierFile.getDossierFileDate(), dossierFile.getOriginal(), PortletConstants.DOSSIER_FILE_SYNC_STATUS_NOSYNC, dossier.getFolderId(), fileEntry.getTitle() + StringPool.PERIOD + fileEntry.getExtension(), fileEntry.getMimeType(), fileEntry.getTitle(), StringPool.BLANK, StringPool.BLANK, fileEntry.getContentStream(), fileEntry.getSize(), serviceContext); updated = true; } catch (Exception e) { updated = false; if (e instanceof DuplicateFileException) { SessionErrors.add(actionRequest, DuplicateFileException.class); } else if (e instanceof NoSuchDossierException) { SessionErrors.add(actionRequest, NoSuchDossierException.class); } else if (e instanceof NoSuchDossierPartException) { SessionErrors.add(actionRequest, NoSuchDossierPartException.class); } else if (e instanceof NoSuchAccountException) { SessionErrors.add(actionRequest, NoSuchAccountException.class); } else if (e instanceof NoSuchAccountTypeException) { SessionErrors.add(actionRequest, NoSuchAccountTypeException.class); } else if (e instanceof NoSuchAccountFolderException) { SessionErrors.add(actionRequest, NoSuchAccountFolderException.class); } else if (e instanceof NoSuchAccountOwnUserIdException) { SessionErrors.add(actionRequest, NoSuchAccountOwnUserIdException.class); } else if (e instanceof NoSuchAccountOwnOrgIdException) { SessionErrors.add(actionRequest, NoSuchAccountOwnOrgIdException.class); } else if (e instanceof PermissionDossierException) { SessionErrors.add(actionRequest, PermissionDossierException.class); } else if (e instanceof NoSuchFileEntryException) { SessionErrors.add(actionRequest, NoSuchFileEntryException.class); } else if (e instanceof RolePermissionsException) { SessionErrors.add(actionRequest, RolePermissionsException.class); } else { SessionErrors.add(actionRequest, "upload-error"); } _log.error(e); } finally { if (updated) { if (Validator.isNotNull(redirectURL)) { actionResponse.sendRedirect(redirectURL); } } else { actionResponse.setRenderParameter("redirectURL", redirectURL); actionResponse.setRenderParameter("content", "upload-file"); actionResponse.setRenderParameter("tab1", "select-file"); actionResponse.setRenderParameter("jspPage", "/html/portlets/processmgt/processorder/modal_dialog.jsp"); } } }
From source file:org.opencps.usermgt.service.impl.WorkingUnitLocalServiceImpl.java
License:Open Source License
protected String getTreeIndex(long workingunitId, long parentWorkingUnitId, int sibling) throws NoSuchWorkingUnitException, SystemException { if (parentWorkingUnitId == 0) { return String.valueOf(sibling); } else if (parentWorkingUnitId > 0) { WorkingUnit workingUnit = workingUnitPersistence.findByPrimaryKey(parentWorkingUnitId); return workingUnit.getTreeIndex() + StringPool.PERIOD + String.valueOf(workingunitId); } else {/*from w w w .j a v a2s . c o m*/ throw new NoSuchWorkingUnitException(); } }
From source file:org.vaadin.tori.service.LiferayToriMailService.java
License:Apache License
private static String getMailId(final long companyId, final long categoryId, final long messageId) throws PortalException, SystemException { Company company = CompanyLocalServiceUtil.getCompany(companyId); String mx = company.getMx();/*from w w w . j a v a 2s .c om*/ StringBundler sb = new StringBundler(10); sb.append(StringPool.LESS_THAN); sb.append(POP_PORTLET_PREFIX); sb.append(categoryId); sb.append(StringPool.PERIOD); sb.append(messageId); sb.append(StringPool.AT); String sd = PropsUtil.get(PropsKeys.POP_SERVER_SUBDOMAIN); if (sd != null && !"null".equals(sd.toLowerCase())) { sb.append(sd); sb.append(StringPool.PERIOD); } sb.append(mx); sb.append(StringPool.GREATER_THAN); return sb.toString(); }