Example usage for com.liferay.portal.kernel.dao.orm SQLQuery setMaxResults

List of usage examples for com.liferay.portal.kernel.dao.orm SQLQuery setMaxResults

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.orm.*
  5. SQLQuery
  6. setMaxResults

Introduction

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

Prototype

public Query setMaxResults(int maxResults);

Source Link

Usage

From source file:at.meduni.liferay.portlet.bbmrieric.service.persistence.D2BiobankPersistenceImpl.java

License:Open Source License

protected D2Biobank filterGetByGroupId_PrevAndNext(Session session, D2Biobank d2Biobank, long groupId,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//from   w  w w  . j  a v  a  2 s . c o  m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(D2BiobankModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(D2BiobankModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), D2Biobank.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, D2BiobankImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, D2BiobankImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(d2Biobank);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<D2Biobank> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.persistence.D2BiobankPersistenceImpl.java

License:Open Source License

protected D2Biobank filterGetByBiobankName_PrevAndNext(Session session, D2Biobank d2Biobank, long groupId,
        String biobankName, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*from w ww .j  a  v  a  2  s . com*/

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_BIOBANKNAME_GROUPID_2);

    boolean bindBiobankName = false;

    if (biobankName == null) {
        query.append(_FINDER_COLUMN_BIOBANKNAME_BIOBANKNAME_1);
    } else if (biobankName.equals(StringPool.BLANK)) {
        query.append(_FINDER_COLUMN_BIOBANKNAME_BIOBANKNAME_3);
    } else {
        bindBiobankName = true;

        query.append(_FINDER_COLUMN_BIOBANKNAME_BIOBANKNAME_2);
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(D2BiobankModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(D2BiobankModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), D2Biobank.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, D2BiobankImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, D2BiobankImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (bindBiobankName) {
        qPos.add(biobankName);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(d2Biobank);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<D2Biobank> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.persistence.D2BiobankPersistenceImpl.java

License:Open Source License

protected D2Biobank filterGetByG_S_PrevAndNext(Session session, D2Biobank d2Biobank, long groupId, int status,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;// w  ww.  ja  v  a2 s.  c o m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_G_S_GROUPID_2);

    query.append(_FINDER_COLUMN_G_S_STATUS_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(D2BiobankModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(D2BiobankModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), D2Biobank.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, D2BiobankImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, D2BiobankImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    qPos.add(status);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(d2Biobank);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<D2Biobank> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.persistence.D2BiobankPersistenceImpl.java

License:Open Source License

protected D2Biobank filterGetByNotUUID_PrevAndNext(Session session, D2Biobank d2Biobank, long groupId,
        String updateuuid, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;// w  w w  .j ava2 s .  co m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_NOTUUID_GROUPID_2);

    boolean bindUpdateuuid = false;

    if (updateuuid == null) {
        query.append(_FINDER_COLUMN_NOTUUID_UPDATEUUID_1);
    } else if (updateuuid.equals(StringPool.BLANK)) {
        query.append(_FINDER_COLUMN_NOTUUID_UPDATEUUID_3);
    } else {
        bindUpdateuuid = true;

        query.append(_FINDER_COLUMN_NOTUUID_UPDATEUUID_2);
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_D2BIOBANK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(D2BiobankModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(D2BiobankModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), D2Biobank.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, D2BiobankImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, D2BiobankImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (bindUpdateuuid) {
        qPos.add(updateuuid);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(d2Biobank);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<D2Biobank> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:br.com.prodevelopment.associado.service.persistence.AssociadoPersistenceImpl.java

License:Open Source License

protected Associado filterGetByC_G_PrevAndNext(Session session, Associado associado, long companyId,
        long groupId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//from  w  w  w.  j a v  a  2 s .c o  m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_C_G_COMPANYID_2);

    query.append(_FINDER_COLUMN_C_G_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(AssociadoModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(AssociadoModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Associado.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, AssociadoImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, AssociadoImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(associado);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Associado> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:br.com.prodevelopment.associado.service.persistence.AssociadoPersistenceImpl.java

License:Open Source License

protected Associado filterGetByC_G_NOME_PrevAndNext(Session session, Associado associado, long companyId,
        long groupId, String nome, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*w ww  .  j a v a2  s .  c o m*/

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_C_G_NOME_COMPANYID_2);

    query.append(_FINDER_COLUMN_C_G_NOME_GROUPID_2);

    boolean bindNome = false;

    if (nome == null) {
        query.append(_FINDER_COLUMN_C_G_NOME_NOME_1);
    } else if (nome.equals(StringPool.BLANK)) {
        query.append(_FINDER_COLUMN_C_G_NOME_NOME_3);
    } else {
        bindNome = true;

        query.append(_FINDER_COLUMN_C_G_NOME_NOME_2);
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_ASSOCIADO_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(AssociadoModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(AssociadoModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Associado.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, AssociadoImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, AssociadoImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    qPos.add(groupId);

    if (bindNome) {
        qPos.add(nome);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(associado);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Associado> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.appuntivari.esempio.service.persistence.RelazioniSistemiPersistenceImpl.java

License:Open Source License

protected RelazioniSistemi filterGetBySistemaFrom_PrevAndNext(Session session,
        RelazioniSistemi relazioniSistemi, String sistemaFrom, OrderByComparator orderByComparator,
        boolean previous) {
    StringBundler query = null;//www.  j  av a 2s  .c  o  m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_NO_INLINE_DISTINCT_WHERE_1);
    }

    if (sistemaFrom == null) {
        query.append(_FINDER_COLUMN_SISTEMAFROM_SISTEMAFROM_1);
    } else {
        if (sistemaFrom.equals(StringPool.BLANK)) {
            query.append(_FINDER_COLUMN_SISTEMAFROM_SISTEMAFROM_3);
        } else {
            query.append(_FINDER_COLUMN_SISTEMAFROM_SISTEMAFROM_2);
        }
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    }

    else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(RelazioniSistemiModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(RelazioniSistemiModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), RelazioniSistemi.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, RelazioniSistemiImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, RelazioniSistemiImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    if (sistemaFrom != null) {
        qPos.add(sistemaFrom);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(relazioniSistemi);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<RelazioniSistemi> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.appuntivari.esempio.service.persistence.RelazioniSistemiPersistenceImpl.java

License:Open Source License

protected RelazioniSistemi filterGetBySistemaTo_PrevAndNext(Session session, RelazioniSistemi relazioniSistemi,
        String sistemaTo, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//from ww w.j av a  2  s .c  om

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_NO_INLINE_DISTINCT_WHERE_1);
    }

    if (sistemaTo == null) {
        query.append(_FINDER_COLUMN_SISTEMATO_SISTEMATO_1);
    } else {
        if (sistemaTo.equals(StringPool.BLANK)) {
            query.append(_FINDER_COLUMN_SISTEMATO_SISTEMATO_3);
        } else {
            query.append(_FINDER_COLUMN_SISTEMATO_SISTEMATO_2);
        }
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_RELAZIONISISTEMI_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    }

    else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(RelazioniSistemiModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(RelazioniSistemiModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), RelazioniSistemi.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, RelazioniSistemiImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, RelazioniSistemiImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    if (sistemaTo != null) {
        qPos.add(sistemaTo);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(relazioniSistemi);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<RelazioniSistemi> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.appuntivari.esempio.service.persistence.SistemiPersistenceImpl.java

License:Open Source License

protected Sistemi filterGetBySistema_PrevAndNext(Session session, Sistemi sistemi, String sistema,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//  ww w .  j av  a 2  s  . c o  m

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SISTEMI_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SISTEMI_NO_INLINE_DISTINCT_WHERE_1);
    }

    if (sistema == null) {
        query.append(_FINDER_COLUMN_SISTEMA_SISTEMA_1);
    } else {
        if (sistema.equals(StringPool.BLANK)) {
            query.append(_FINDER_COLUMN_SISTEMA_SISTEMA_3);
        } else {
            query.append(_FINDER_COLUMN_SISTEMA_SISTEMA_2);
        }
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SISTEMI_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    }

    else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(SistemiModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(SistemiModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Sistemi.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, SistemiImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, SistemiImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    if (sistema != null) {
        qPos.add(sistema);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(sistemi);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Sistemi> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.appuntivari.esempio.service.persistence.SistemiPersistenceImpl.java

License:Open Source License

protected Sistemi filterGetByDescrizione_PrevAndNext(Session session, Sistemi sistemi, String descrizione,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*from   w ww.  j  av a2s  .c o  m*/

    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SISTEMI_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SISTEMI_NO_INLINE_DISTINCT_WHERE_1);
    }

    if (descrizione == null) {
        query.append(_FINDER_COLUMN_DESCRIZIONE_DESCRIZIONE_1);
    } else {
        if (descrizione.equals(StringPool.BLANK)) {
            query.append(_FINDER_COLUMN_DESCRIZIONE_DESCRIZIONE_3);
        } else {
            query.append(_FINDER_COLUMN_DESCRIZIONE_DESCRIZIONE_2);
        }
    }

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SISTEMI_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    }

    else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(SistemiModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(SistemiModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Sistemi.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, SistemiImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, SistemiImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    if (descrizione != null) {
        qPos.add(descrizione);
    }

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(sistemi);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Sistemi> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}