List of usage examples for com.liferay.portal.kernel.util OrderByComparator getOrderByConditionValues
public Object[] getOrderByConditionValues(Object obj)
From source file:at.bibbox.reactjsservice.service.persistence.ToolInformationPersistenceImpl.java
License:Open Source License
protected ToolInformation getByCategory_PrevAndNext(Session session, ToolInformation toolInformation, String category, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from w w w .j ava 2 s .c o m*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_TOOLINFORMATION_WHERE); boolean bindCategory = false; if (category == null) { query.append(_FINDER_COLUMN_CATEGORY_CATEGORY_1); } else if (category.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_CATEGORY_CATEGORY_3); } else { bindCategory = true; query.append(_FINDER_COLUMN_CATEGORY_CATEGORY_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ToolInformationModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindCategory) { qPos.add(category); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(toolInformation); for (Object value : values) { qPos.add(value); } } List<ToolInformation> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ConfigurationPersistenceImpl.java
License:Open Source License
protected Configuration getByoptionsFinderKey_PrevAndNext(Session session, Configuration configuration, String scope, String optionkey, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from w w w . ja v a 2 s .com*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_CONFIGURATION_WHERE); boolean bindScope = false; if (scope == null) { query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_SCOPE_1); } else if (scope.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_SCOPE_3); } else { bindScope = true; query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_SCOPE_2); } boolean bindOptionkey = false; if (optionkey == null) { query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_OPTIONKEY_1); } else if (optionkey.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_OPTIONKEY_3); } else { bindOptionkey = true; query.append(_FINDER_COLUMN_OPTIONSFINDERKEY_OPTIONKEY_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ConfigurationModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindScope) { qPos.add(scope); } if (bindOptionkey) { qPos.add(optionkey); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(configuration); for (Object value : values) { qPos.add(value); } } List<Configuration> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ConfigurationPersistenceImpl.java
License:Open Source License
protected Configuration getByoptionsFinder_PrevAndNext(Session session, Configuration configuration, String scope, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*w ww . ja v a 2 s .c o m*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_CONFIGURATION_WHERE); boolean bindScope = false; if (scope == null) { query.append(_FINDER_COLUMN_OPTIONSFINDER_SCOPE_1); } else if (scope.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_OPTIONSFINDER_SCOPE_3); } else { bindScope = true; query.append(_FINDER_COLUMN_OPTIONSFINDER_SCOPE_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ConfigurationModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindScope) { qPos.add(scope); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(configuration); for (Object value : values) { qPos.add(value); } } List<Configuration> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ConfigurationPersistenceImpl.java
License:Open Source License
protected Configuration getByOptionsFinderForKey_PrevAndNext(Session session, Configuration configuration, String optionkey, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from w ww . j a v a 2s . c o m*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_CONFIGURATION_WHERE); boolean bindOptionkey = false; if (optionkey == null) { query.append(_FINDER_COLUMN_OPTIONSFINDERFORKEY_OPTIONKEY_1); } else if (optionkey.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_OPTIONSFINDERFORKEY_OPTIONKEY_3); } else { bindOptionkey = true; query.append(_FINDER_COLUMN_OPTIONSFINDERFORKEY_OPTIONKEY_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ConfigurationModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindOptionkey) { qPos.add(optionkey); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(configuration); for (Object value : values) { qPos.add(value); } } List<Configuration> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.FahrzeugPersistenceImpl.java
License:Open Source License
protected Fahrzeug getByTyp_PrevAndNext(Session session, Fahrzeug fahrzeug, String typ, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;//from ww w . ja v a 2 s. c o m if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_FAHRZEUG_WHERE); boolean bindTyp = false; if (typ == null) { query.append(_FINDER_COLUMN_TYP_TYP_1); } else if (typ.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_TYP_TYP_3); } else { bindTyp = true; query.append(_FINDER_COLUMN_TYP_TYP_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(FahrzeugModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindTyp) { qPos.add(typ); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(fahrzeug); for (Object value : values) { qPos.add(value); } } List<Fahrzeug> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ObjectDataPersistenceImpl.java
License:Open Source License
protected ObjectData getByEvent_PrevAndNext(Session session, ObjectData objectData, long puchmuseumsobjectId, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from w w w.j a v a 2 s . com*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_OBJECTDATA_WHERE); query.append(_FINDER_COLUMN_EVENT_PUCHMUSEUMSOBJECTID_2); if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ObjectDataModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(puchmuseumsobjectId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(objectData); for (Object value : values) { qPos.add(value); } } List<ObjectData> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ObjectImagePersistenceImpl.java
License:Open Source License
protected ObjectImage getByObject_PrevAndNext(Session session, ObjectImage objectImage, long puchmuseumsobjectId, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;//from w w w . ja va2s .co m if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_OBJECTIMAGE_WHERE); query.append(_FINDER_COLUMN_OBJECT_PUCHMUSEUMSOBJECTID_2); if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ObjectImageModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(puchmuseumsobjectId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(objectImage); for (Object value : values) { qPos.add(value); } } List<ObjectImage> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.ParameterOptionsConfigurationPersistenceImpl.java
License:Open Source License
protected ParameterOptionsConfiguration getByOptionsForParameter_PrevAndNext(Session session, ParameterOptionsConfiguration parameterOptionsConfiguration, long parameterconfigurationId, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from www . ja va2 s . co m*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_PARAMETEROPTIONSCONFIGURATION_WHERE); query.append(_FINDER_COLUMN_OPTIONSFORPARAMETER_PARAMETERCONFIGURATIONID_2); if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(ParameterOptionsConfigurationModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(parameterconfigurationId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(parameterOptionsConfiguration); for (Object value : values) { qPos.add(value); } } List<ParameterOptionsConfiguration> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.PersonPersistenceImpl.java
License:Open Source License
protected Person getByVorname_PrevAndNext(Session session, Person person, String vorname, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;//from ww w. j ava 2s . c om if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_PERSON_WHERE); boolean bindVorname = false; if (vorname == null) { query.append(_FINDER_COLUMN_VORNAME_VORNAME_1); } else if (vorname.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_VORNAME_VORNAME_3); } else { bindVorname = true; query.append(_FINDER_COLUMN_VORNAME_VORNAME_2); } if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(PersonModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); if (bindVorname) { qPos.add(vorname); } if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(person); for (Object value : values) { qPos.add(value); } } List<Person> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }
From source file:at.graz.hmmc.liferay.portlet.puch.service.persistence.TransaktionDataPersistenceImpl.java
License:Open Source License
protected TransaktionData getByTransaction_PrevAndNext(Session session, TransaktionData transaktionData, long transaktionId, OrderByComparator orderByComparator, boolean previous) { StringBundler query = null;/*from www. j a va 2 s. c o m*/ if (orderByComparator != null) { query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_TRANSAKTIONDATA_WHERE); query.append(_FINDER_COLUMN_TRANSACTION_TRANSAKTIONID_2); if (orderByComparator != null) { String[] orderByConditionFields = orderByComparator.getOrderByConditionFields(); if (orderByConditionFields.length > 0) { query.append(WHERE_AND); } for (int i = 0; i < orderByConditionFields.length; i++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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++) { query.append(_ORDER_BY_ENTITY_ALIAS); 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 { query.append(TransaktionDataModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(transaktionId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(transaktionData); for (Object value : values) { qPos.add(value); } } List<TransaktionData> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } }