Example usage for com.liferay.portal.kernel.dao.orm Type BOOLEAN

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm Type BOOLEAN.

Prototype

Type BOOLEAN

To view the source code for com.liferay.portal.kernel.dao.orm Type BOOLEAN.

Click Source Link

Usage

From source file:com.liferay.chat.service.persistence.impl.StatusFinderImpl.java

License:Open Source License

protected void addScalars(SQLQuery sqlQuery) {
    sqlQuery.addScalar("awake", Type.BOOLEAN);
    sqlQuery.addScalar("firstName", Type.STRING);
    sqlQuery.addScalar("groupId", Type.LONG);
    sqlQuery.addScalar("lastName", Type.STRING);
    //sqlQuery.addScalar("male", Type.BOOLEAN);
    sqlQuery.addScalar("middleName", Type.STRING);
    sqlQuery.addScalar("portraitId", Type.LONG);
    sqlQuery.addScalar("screenName", Type.STRING);
    sqlQuery.addScalar("userId", Type.LONG);
    sqlQuery.addScalar("userUuid", Type.STRING);
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findByModifiedDate(long companyId, long userId, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;/* www  .j a v a  2 s. co m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_MODIFIED_DATE);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(userId);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findBySocialRelationType(long userId, int type, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;//from   ww  w .j  av a2s. c  om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_SOCIAL_RELATION_TYPE);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);
        qPos.add(type);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findByUsersGroups(long userId, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;/*from   ww  w .  jav a  2  s .  c  om*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_USERS_GROUPS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

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

License:Open Source License

/**
 * @param serviceInfoId/*from   w  w  w  .  j ava2  s . c om*/
 * @param processStepId
 * @param loginUserId
 * @param assignToUserId
 * @param start
 * @param end
 * @param orderByComparator
 * @return
 */
public List searchProcessOrder(long serviceInfoId,

        long processStepId, long loginUserId, long assignToUserId, int start, int end,
        OrderByComparator orderByComparator) {

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

        String sql = CustomSQLUtil.get(SQL_PROCESS_ORDER_FINDER);

        if (serviceInfoId <= 0) {
            sql = StringUtil.replace(sql, "AND opencps_processorder.serviceInfoId = ?", StringPool.BLANK);
        }

        if (processStepId <= 0) {
            sql = StringUtil.replace(sql, "AND opencps_processstep.processStepId = ?", StringPool.BLANK);
        }

        SQLQuery q = session.createSQLQuery(sql);

        q.setCacheable(false);

        q.addEntity("ProcessOrder", ProcessOrderImpl.class);

        q.addScalar("serviceConfigId", Type.LONG);
        q.addScalar("subjectId", Type.STRING);
        q.addScalar("subjectName", Type.STRING);
        q.addScalar("receptionNo", Type.STRING);
        q.addScalar("serviceName", Type.STRING);
        q.addScalar("stepName", Type.STRING);
        q.addScalar("sequenceNo", Type.STRING);
        q.addScalar("daysDuration", Type.INTEGER);
        q.addScalar("referenceDossierPartId", Type.LONG);
        q.addScalar("readOnly", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        if (serviceInfoId > 0) {
            qPos.add(serviceInfoId);
        }

        if (processStepId > 0) {
            qPos.add(processStepId);
        }

        qPos.add(loginUserId);
        qPos.add(assignToUserId);

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.list(q, getDialect(), start, end).iterator();

        List<ProcessOrderBean> processOrderBeans = new ArrayList<ProcessOrderBean>();

        if (itr.hasNext()) {
            while (itr.hasNext()) {
                ProcessOrderBean processOrderBean = new ProcessOrderBean();

                Object[] objects = itr.next();

                ProcessOrder processOrder = (ProcessOrder) objects[0];

                long serviceConfigId = GetterUtil.getLong(objects[1]);
                String subjectId = (String) objects[2];
                String subjectName = (String) objects[3];
                String receptionNo = (String) objects[4];
                String serviceName = (String) objects[5];
                String stepName = (String) objects[6];
                String sequenceNo = (String) objects[7];
                int daysDuration = GetterUtil.getInteger(objects[8]);
                long referenceDossierPartId = GetterUtil.getLong(objects[9]);

                boolean readOnly = GetterUtil.getBoolean(objects[10]);

                processOrderBean.setActionDatetime(processOrder.getActionDatetime());
                processOrderBean.setActionUserId(processOrder.getActionUserId());
                processOrderBean.setAssignToUserId(processOrder.getAssignToUserId());
                // processOrderBean.setAssignToUserName(assignToUserName);
                processOrderBean.setCompanyId(processOrder.getCompanyId());
                processOrderBean.setDaysDuration(daysDuration);
                // processOrderBean.setDealine(dealine);
                processOrderBean.setDossierId(processOrder.getDossierId());
                processOrderBean.setDossierStatus(processOrder.getDossierStatus());
                processOrderBean.setDossierTemplateId(processOrder.getDossierTemplateId());
                processOrderBean.setFileGroupId(processOrder.getFileGroupId());
                processOrderBean.setGovAgencyCode(processOrder.getGovAgencyCode());
                processOrderBean.setGovAgencyName(processOrder.getGovAgencyName());
                processOrderBean.setGovAgencyOrganizationId(processOrder.getGovAgencyOrganizationId());
                processOrderBean.setGroupId(processOrder.getGroupId());
                processOrderBean.setProcessOrderId(processOrder.getProcessOrderId());
                processOrderBean.setProcessStepId(processStepId);
                processOrderBean.setReceptionNo(receptionNo);
                processOrderBean.setReferenceDossierPartId(referenceDossierPartId);
                processOrderBean.setSequenceNo(sequenceNo);
                processOrderBean.setServiceConfigId(serviceConfigId);
                processOrderBean.setServiceInfoId(processOrder.getServiceInfoId());
                processOrderBean.setServiceName(serviceName);
                processOrderBean.setServiceProcessId(processOrder.getServiceProcessId());
                processOrderBean.setStepName(stepName);
                processOrderBean.setSubjectId(subjectId);
                processOrderBean.setSubjectName(subjectName);
                processOrderBean.setUserId(processOrder.getUserId());
                processOrderBean.setReadOnly(readOnly);

                processOrderBeans.add(processOrderBean);
            }
        }

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

    return null;

}

---