Example usage for com.liferay.portal.kernel.util StringPool LIKE

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.util StringPool LIKE.

Prototype

String LIKE

To view the source code for com.liferay.portal.kernel.util StringPool LIKE.

Click Source Link

Usage

From source file:org.opencps.dossiermgt.service.persistence.DossierFinderImpl.java

License:Open Source License

/**
 * @param groupId/*  w  w w.j  a v a2  s  .c  o 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.DossierFinderImpl.java

License:Open Source License

/**
 * @param dossiertype//from w w w . j av a2s.  c o m
 * @param organizationcode
 * @param status
 * @param fromdate
 * @param todate
 * @param documentyear
 * @param customername
 * @return
 */
public int countDossierForRemoteService(String dossiertype, String organizationcode, String processStepId,
        String status, String fromdate, String todate, int documentyear, String customername) {

    Session session = null;
    String[] keywords = null;
    boolean andOperator = false;
    if (Validator.isNotNull(customername)) {
        keywords = CustomSQLUtil.keywords(customername);
    } else {
        andOperator = true;
    }

    DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_DOSSIER_FOR_REMOTE_SERVICE);
        if ("-1".equals(dossiertype)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.serviceInfoId = ?", StringPool.BLANK);
        }

        if ("-1".equals(status) || "".equals(status) || Validator.isNull(status)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.dossierStatus = ?", StringPool.BLANK);
        }
        if (Validator.isNull(processStepId) || "-1".equals(processStepId)) {
            sql = StringUtil.replace(sql, "AND opencps_processorder.processStepId = ?", StringPool.BLANK);
        }
        if (Validator.isNull(todate) || "".equals(todate)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.receiveDatetime <= ?", StringPool.BLANK);
        }
        if (Validator.isNull(fromdate) || "".equals(fromdate)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.receiveDatetime >= ?", StringPool.BLANK);
        }
        if (documentyear <= 0) {
            sql = StringUtil.replace(sql, "AND YEAR(opencps_dossier.receiveDatetime) = ?", StringPool.BLANK);
        }
        if (keywords == null || keywords.length == 0) {
            sql = StringUtil.replace(sql,
                    "AND (lower(opencps_dossier.subjectName) LIKE ? [$AND_OR_NULL_CHECK$])", StringPool.BLANK);
        } else {
            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossier.subjectName)", StringPool.LIKE,
                    true, keywords);
        }

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        _log.info("Count sql: " + sql);
        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.INTEGER);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(organizationcode);
        if (!"-1".equals(dossiertype)) {
            qPos.add(dossiertype);
        }
        _log.info("Gov agency code: " + organizationcode);
        if (Validator.isNotNull(processStepId) && !"-1".equals(processStepId)) {
            qPos.add(processStepId);
        }
        if (!"-1".equals(status)) {
            qPos.add(status);
        }
        if (Validator.isNotNull(todate) && !"".equals(todate)) {
            // _log.info("To date: " + sdf.format(todate));
            // qPos.add(sdf.format(todate));
            qPos.add(todate);
        }
        if (Validator.isNotNull(fromdate) && !"".equals(fromdate)) {
            // _log.info("From date: " + sdf.format(fromdate));
            // qPos.add(sdf.format(fromdate));
            qPos.add(fromdate);
        }
        if (documentyear > 0) {
            qPos.add(documentyear);
        }
        if (keywords != null && keywords.length > 0) {
            qPos.add(keywords, 2);
        }

        Iterator<Integer> itr = q.iterate();

        if (itr.hasNext()) {
            Integer count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;

    } catch (Exception e) {
        _log.error(e);
    } finally {
        closeSession(session);
    }

    return 0;

}

---

From source file:org.opencps.dossiermgt.service.persistence.DossierFinderImpl.java

License:Open Source License

/**
 * @param dossiertype/*from w w w . ja va  2  s  . com*/
 * @param organizationcode
 * @param status
 * @param fromdate
 * @param todate
 * @param documentyear
 * @param customername
 * @return
 */
public List<Dossier> searchDossierForRemoteService(String dossiertype, String organizationcode,
        String processStepId, String status, String fromdate, String todate, int documentyear,
        String customername, int start, int end) {

    Session session = null;
    String[] keywords = null;
    boolean andOperator = false;
    if (Validator.isNotNull(customername)) {
        keywords = CustomSQLUtil.keywords(customername);
    } else {
        andOperator = true;
    }
    DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SEARCH_DOSSIER_FOR_REMOTE_SERVICE);
        if (Validator.isNull(processStepId) || "-1".equals(processStepId)) {
            sql = StringUtil.replace(sql, "AND opencps_processorder.processStepId = ?", StringPool.BLANK);
        }
        if ("-1".equals(status) || "".equals(status) || Validator.isNull(status)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.dossierStatus = ?", StringPool.BLANK);
        }
        if ("-1".equals(dossiertype)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.serviceInfoId = ?", StringPool.BLANK);
        }
        if (Validator.isNull(todate) || "".equals(todate)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.receiveDatetime <= ?", StringPool.BLANK);
        }
        if (Validator.isNull(fromdate) || "".equals(fromdate)) {
            sql = StringUtil.replace(sql, "AND opencps_dossier.receiveDatetime >= ?", StringPool.BLANK);
        }
        if (documentyear <= 0) {
            sql = StringUtil.replace(sql, "AND YEAR(opencps_dossier.receiveDatetime) = ?", StringPool.BLANK);
        }
        if (keywords == null || keywords.length == 0) {
            sql = StringUtil.replace(sql,
                    "AND (lower(opencps_dossier.subjectName) LIKE ? [$AND_OR_NULL_CHECK$])", StringPool.BLANK);
        } else {
            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossier.subjectName)", StringPool.LIKE,
                    true, keywords);
        }

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        _log.info("Search dossier sql: " + sql);
        SQLQuery q = session.createSQLQuery(sql);
        q.addEntity("Dossier", DossierImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(organizationcode);
        if (!"-1".equals(dossiertype)) {
            qPos.add(dossiertype);
        }
        if (Validator.isNotNull(processStepId) && !"-1".equals(processStepId)) {
            qPos.add(processStepId);
        }
        if (!"-1".equals(status)) {
            qPos.add(status);
        }
        if (Validator.isNotNull(todate) && !"".equals(todate)) {
            // qPos.add(sdf.format(todate));
            qPos.add(todate);
        }
        if (Validator.isNotNull(fromdate) && !"".equals(fromdate)) {
            // qPos.add(sdf.format(fromdate));
            qPos.add(fromdate);
        }
        if (documentyear > 0) {
            qPos.add(documentyear);
        }
        if (keywords != null && keywords.length > 0) {
            _log.info("Keyword: " + Arrays.toString(keywords));
            qPos.add(keywords, 2);
        }
        return (List<Dossier>) QueryUtil.list(q, getDialect(), start, end);
    } 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 ww  w . java 2s. co  m*/
 * @param keywords
 * @param govAgencyCode
 * @param domainCode
 * @param andOperator
 * @return
 */
private int _countServiceConfig(long groupId, String[] keywords, String govAgencyCode, String domainCode,
        boolean andOperator) {

    keywords = CustomSQLUtil.keywords(keywords, false);

    Session session = null;

    try {
        session = openSession();
        // get sql command from sql xml
        String sql = CustomSQLUtil.get(COUNT_SERVICE_CONFIG_SQL);

        if (keywords != null && keywords.length > 0) {
            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossiertemplate.templateName)",
                    StringPool.LIKE, true, keywords);

            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE,
                    true, keywords);
        } else {
            sql = StringUtil.replace(sql,
                    "INNER JOIN opencps_serviceinfo ON opencps_service_config.serviceInfoId = opencps_serviceinfo.serviceinfoId",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "INNER JOIN opencps_dossiertemplate ON opencps_service_config.dossierTemplateId = opencps_dossiertemplate.dossierTemplateId",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "AND ((lower(opencps_dossiertemplate.templateName) LIKE ? [$AND_OR_NULL_CHECK$]))",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "OR ((lower(opencps_serviceinfo.serviceName) LIKE ? [$AND_OR_NULL_CHECK$]))",
                    StringPool.BLANK);
        }
        // remove condition query
        if (govAgencyCode.equals(StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyCode = ?)", StringPool.BLANK);
        }

        if (domainCode.equals("0") || domainCode.equals(StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_service_config.domainCode = ?)", StringPool.BLANK);
        }

        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);
            qPos.add(keywords, 2);
        }
        if (!govAgencyCode.equals(StringPool.BLANK)) {
            qPos.add(govAgencyCode);
        }

        if (!domainCode.equals(StringPool.BLANK) && !domainCode.equals("0")) {
            qPos.add(domainCode);
        }

        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 ww w. j  a  va 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/*from   w  w w .j a  v a  2  s. co m*/
 * @param keywords
 * @param govAgencyCode
 * @param domainCode
 * @param andOperator
 * @param start
 * @param end
 * @return
 */
private List<ServiceConfig> _searchServiceConfig(long groupId, String[] keywords, String govAgencyCode,
        String domainCode, boolean andOperator, int start, int end) {

    keywords = CustomSQLUtil.keywords(keywords, false);

    Session session = null;

    try {
        session = openSession();
        // get sql command from sql xml
        String sql = CustomSQLUtil.get(SEARCH_SERVICE_CONFIG_SQL);

        if (keywords != null && keywords.length > 0) {
            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_dossiertemplate.templateName)",
                    StringPool.LIKE, true, keywords);

            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE,
                    true, keywords);
        } else {
            sql = StringUtil.replace(sql,
                    "INNER JOIN opencps_serviceinfo ON opencps_service_config.serviceInfoId = opencps_serviceinfo.serviceinfoId",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "INNER JOIN opencps_dossiertemplate ON opencps_service_config.dossierTemplateId = opencps_dossiertemplate.dossierTemplateId",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "AND ((lower(opencps_dossiertemplate.templateName) LIKE ? [$AND_OR_NULL_CHECK$]))",
                    StringPool.BLANK);
            sql = StringUtil.replace(sql,
                    "OR ((lower(opencps_serviceinfo.serviceName) LIKE ? [$AND_OR_NULL_CHECK$]))",
                    StringPool.BLANK);
        }

        // remove condition query
        if (govAgencyCode.equals(StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_service_config.govAgencyCode = ?)", StringPool.BLANK);
        }

        if (domainCode.equals("0") || domainCode.equals(StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_service_config.domainCode = ?)", StringPool.BLANK);
        }

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);
        SQLQuery q = session.createSQLQuery(sql);
        q.setCacheable(false);
        q.addEntity("ServiceConfig", ServiceConfigImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);

        if (keywords != null && keywords.length > 0) {
            qPos.add(keywords, 2);
            qPos.add(keywords, 2);
        }

        if (!govAgencyCode.equals(StringPool.BLANK)) {
            qPos.add(govAgencyCode);
        }

        if (!domainCode.equals(StringPool.BLANK) && !domainCode.equals("0")) {
            qPos.add(domainCode);
        }

        return (List<ServiceConfig>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        _log.error(e);
    } finally {
        session.close();
    }

    return null;
}

---

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  om*/
 * @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.paymentmgt.service.persistence.PaymentFileFinderImpl.java

License:Open Source License

private List<PaymentFile> _searchPaymentFiles(long groupId, String paymentStatus, boolean andOperator,
        String[] keywords, int start, int end) {

    keywords = CustomSQLUtil.keywords(keywords);
    System.out.println("PaymentFileFinderImpl.groupId()" + groupId);
    System.out.println("PaymentFileFinderImpl.groupId()" + paymentStatus);
    System.out.println("PaymentFileFinderImpl.groupId()" + keywords);
    Session session = null;/* ww w.  jav a  2 s.  c o  m*/
    try {
        session = openSession();
        String sql = CustomSQLUtil.get(SQL_PAYMENT_FINDER);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_payment_file.paymentName)", StringPool.LIKE,
                true, keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_acc_citizen.fullName)", StringPool.LIKE, true,
                keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_acc_business.name)", StringPool.LIKE, true,
                keywords);

        //            sql = StringUtil
        //                         .replace(
        //                             sql, "AND (opencps_payment_file.paymentStatus = ?)",
        //                             StringPool.BLANK);

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        System.out.println("PaymentFileFinderImpl._searchPaymentFiles()" + sql);
        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addEntity("PaymentFile", PaymentFileImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(keywords, 8);

        qPos.add(paymentStatus);

        return (List<PaymentFile>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        try {
            throw new SystemException(e);
        } catch (SystemException se) {
            se.printStackTrace();
        }
    } finally {
        closeSession(session);
    }
    return null;
}

---

From source file:org.opencps.paymentmgt.service.persistence.PaymentFileFinderImpl.java

License:Open Source License

private int _countPaymentFiles(long groupId, String paymentStatus, boolean andOperator, String[] keywords) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;//from  w  w w .  j av  a  2  s  . c  o  m
    try {
        session = openSession();
        String sql = CustomSQLUtil.get(SQL_PAYMENT_COUNT);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_payment_file.paymentName)", StringPool.LIKE,
                true, keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_acc_citizen.fullName)", StringPool.LIKE, true,
                keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_acc_business.name)", StringPool.LIKE, true,
                keywords);

        //            sql = StringUtil
        //                         .replace(
        //                             sql, "AND (opencps_payment_file.paymentStatus = ?)",
        //                             StringPool.BLANK);

        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(keywords, 8);

        qPos.add(paymentStatus);

        Iterator<Integer> itr = q.iterate();

        if (itr.hasNext()) {

            Integer count = itr.next();

            if (count != null) {

                return count.intValue();

            }

        }

        return 0;

    }

    catch (Exception e) {

        try {

            throw new SystemException(e);

        }

        catch (SystemException se) {

            se.printStackTrace();

        }

    }

    finally {

        closeSession(session);

    }

    return 0;

}

---

From source file:org.opencps.paymentmgt.service.persistence.PaymentFileFinderImpl.java

License:Open Source License

private int countCustomerPaymentFile(long groupId, String[] keywords, boolean isCitizen, long customerId,
        int paymentStatus, boolean andOperator) {

    Session session = null;//from   w w w  . j av a  2 s .c  o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_CUSTOMER_PAYMENTFILE);

        if (keywords != null && keywords.length > 0) {
            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_payment_file.paymentName)", StringPool.LIKE,
                    true, keywords);

            sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_payment_file.accountUserName)",
                    StringPool.LIKE, true, keywords);
        }

        if (keywords == null || keywords.length == 0) {
            sql = StringUtil.replace(sql,
                    "AND (lower(opencps_payment_file.paymentName) LIKE ? [$AND_OR_NULL_CHECK$])",
                    StringPool.BLANK);

            sql = StringUtil.replace(sql,
                    "OR (lower(opencps_payment_file.accountUserName) LIKE ? [$AND_OR_NULL_CHECK$])",
                    StringPool.BLANK);
        }

        if (paymentStatus < 0) {
            sql = StringUtil.replace(sql, "AND (opencps_payment_file.paymentStatus = ?)", StringPool.BLANK);
        }
        if (isCitizen) {
            sql = StringUtil.replace(sql, "AND (opencps_payment_file.ownerOrganizationId=?)", StringPool.BLANK);
        } else {
            sql = StringUtil.replace(sql, "AND (opencps_payment_file.ownerUserId=?)", StringPool.BLANK);
        }

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.INTEGER);

        QueryPos qPos = QueryPos.getInstance(q);

        //qPos.add(groupId);

        qPos.add(customerId);

        if (keywords != null && keywords.length > 0) {
            qPos.add(keywords, 2);
            qPos.add(keywords, 2);
        }

        if (paymentStatus >= 0) {
            qPos.add(paymentStatus);
        }

        Iterator<Integer> itr = q.iterate();

        if (itr.hasNext()) {
            Integer count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;

    } catch (Exception e) {
        _log.error(e);
    } finally {
        closeSession(session);
    }

    return 0;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• »