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

Introduction

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

Prototype

Type TIMESTAMP

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

Click Source Link

Usage

From source file:com.liferay.blogs.service.persistence.impl.BlogsStatsUserFinderImpl.java

License:Open Source License

@Override
public List<BlogsStatsUser> findByGroupIds(long companyId, long groupId, int start, int end) {

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

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_GROUP_IDS);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("lastPostDate", Type.TIMESTAMP);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(groupId);

        List<BlogsStatsUser> statsUsers = new ArrayList<>();

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

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long userId = (Long) array[0];
            Date lastPostDate = (Date) array[1];

            List<BlogsStatsUser> curStatsUsers = BlogsStatsUserUtil.findByU_L(userId, lastPostDate);

            if (!curStatsUsers.isEmpty()) {
                BlogsStatsUser statsUser = curStatsUsers.get(0);

                statsUsers.add(statsUser);
            }
        }

        return statsUsers;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinderImpl.java

License:Open Source License

public List<BlogsStatsUser> findByGroupIds(long companyId, long groupId, int start, int end)
        throws SystemException {

    Session session = null;/*from  ww w  .  j  a va  2 s  .com*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_GROUP_IDS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("lastPostDate", Type.TIMESTAMP);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(groupId);

        List<BlogsStatsUser> statsUsers = new ArrayList<BlogsStatsUser>();

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

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long userId = (Long) array[0];
            Date lastPostDate = (Date) array[1];

            List<BlogsStatsUser> curStatsUsers = BlogsStatsUserUtil.findByU_L(userId, lastPostDate);

            if (!curStatsUsers.isEmpty()) {
                BlogsStatsUser statsUser = curStatsUsers.get(0);

                statsUsers.add(statsUser);
            }
        }

        return statsUsers;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---