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.paymentmgt.service.persistence.PaymentFileFinderImpl.java

License:Open Source License

private List<PaymentFile> searchCustomerPaymentFile(long groupId, String[] keywords, boolean isCitizen,
        long customerId, int paymentStatus, boolean andOperator, int start, int end, OrderByComparator obc) {

    Session session = null;//ww  w  .  j a  v a 2  s  . c om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SEARCH_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.addEntity("PaymentFile", PaymentFileImpl.class);

        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);
        }

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

    return null;
}

---

From source file:org.opencps.processmgt.service.persistence.ServiceProcessFinderImpl.java

License:Open Source License

private List<ServiceProcess> _searchProcess(

        long groupId, boolean andOperator, String[] keywords, int start, int end) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;/*from  w ww .  j ava2 s.  co  m*/
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SQL_PROCESS_FINDER);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceprocess.processName)", StringPool.LIKE,
                true, keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceprocess.processNo)", StringPool.LIKE,
                true, keywords);

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addEntity("ServiceProcess", ServiceProcessImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);

        qPos.add(keywords, 2);
        qPos.add(keywords, 2);

        return (List<ServiceProcess>) 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.processmgt.service.persistence.ServiceProcessFinderImpl.java

License:Open Source License

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

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;//from   ww  w .  j  a v  a2 s  .co  m
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SQL_PROCESS_COUNT);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceprocess.processName)", StringPool.LIKE,
                true, keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceprocess.processNo)", StringPool.LIKE,
                true, keywords);

        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);
        qPos.add(keywords, 2);
        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) {
        try {
            throw new SystemException(e);
        } catch (SystemException se) {
            se.printStackTrace();
        }
    } finally {
        closeSession(session);
    }

    return 0;

}

---

From source file:org.opencps.servicemgt.service.persistence.ServiceInfoFinderImpl.java

License:Open Source License

/**
 * @param groupId/*from ww w .  j  ava  2s .  c  o  m*/
 * @param keywords
 * @param adminCode
 * @param domainCode
 * @param andOperator
 * @param start
 * @param end
 * @return
 */
private List<ServiceInfo> _searchService(long groupId, String[] keywords, String adminCode, String domainCode,
        boolean andOperator, int start, int end) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SEARCH_SERVICE_SQL);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE,
                true, keywords);

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

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        // remove condition query
        if (Validator.equals(adminCode, "0") || Validator.equals(adminCode, StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_serviceinfo.administrationCode = ?)", StringPool.BLANK);
        }

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

        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addEntity("ServiceInfo", ServiceInfoImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);

        qPos.add(keywords, 2);
        qPos.add(keywords, 2);

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

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

        return (List<ServiceInfo>) 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.servicemgt.service.persistence.ServiceInfoFinderImpl.java

License:Open Source License

/**
 * @param groupId//from   w w w .  j a v a2 s.c  om
 * @param keywords
 * @param adminCode
 * @param domainCode
 * @param andOperator
 * @return
 */
private int _countService(long groupId, String[] keywords, String adminCode, String domainCode,
        boolean andOperator) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_SERVICE_SQL);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_serviceinfo.serviceName)", StringPool.LIKE,
                true, keywords);

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

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        // remove condition query
        if (Validator.equals(adminCode, "0") || Validator.equals(adminCode, StringPool.BLANK)) {
            sql = StringUtil.replace(sql, "AND (opencps_serviceinfo.administrationCode = ?)", StringPool.BLANK);
        }

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

        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addScalar(COUNT_COLUMN_NAME, Type.INTEGER);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);

        qPos.add(keywords, 2);
        qPos.add(keywords, 2);

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

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

        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.servicemgt.service.persistence.TemplateFileFinderImpl.java

License:Open Source License

/**
 * @param groupId//from w w w .  ja  va 2s  .c o  m
 * @param andOperator
 * @param keywords
 * @return
 */
private int _countTemplateFile(long groupId, boolean andOperator, String[] keywords) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_TEMPLATE_SQL);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_templatefile.fileName)", StringPool.LIKE, true,
                keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_templatefile.fileNo)", StringPool.LIKE, true,
                keywords);

        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);
        qPos.add(keywords, 2);
        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) {
        try {
            throw new SystemException(e);
        } catch (SystemException se) {
            se.printStackTrace();
        }
    } finally {
        closeSession(session);
    }

    return 0;

}

---

From source file:org.opencps.servicemgt.service.persistence.TemplateFileFinderImpl.java

License:Open Source License

/**
 * @param groupId/*from ww  w . ja v a2  s  .c o  m*/
 * @param keywords
 * @param andOperator
 * @param start
 * @param end
 * @return
 */
private List<TemplateFile> _searchTemplateFile(long groupId, String[] keywords, boolean andOperator, int start,
        int end) {

    keywords = CustomSQLUtil.keywords(keywords);

    Session session = null;
    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SEARCH_TEMPLATE_SQL);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_templatefile.fileName)", StringPool.LIKE, true,
                keywords);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(opencps_templatefile.fileNo)", StringPool.LIKE, true,
                keywords);

        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addEntity("TemplateFile", TemplateFileImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);

        qPos.add(keywords, 2);
        qPos.add(keywords, 2);

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

    return null;

}

---

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