@Override public List<ResourcePermission> findByR_S(long roleId, int[] scopes, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_R_S); sql = StringUtil.replace(sql, "[$SCOPE$]", getScopes(scopes)); SQLQuery q = session.createSQLQuery(sql); q.addEntity("ResourcePermission", ResourcePermissionImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(roleId); qPos.add(scopes); return (List<ResourcePermission>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<MicroblogsEntry> findByU_T_MU( long userId, int type, long microblogsEntryUserId, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_U_MU); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MicroblogsEntry", MicroblogsEntryImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(MicroblogsEntryConstants.TYPE_EVERYONE); qPos.add(userId); qPos.add(type); qPos.add(microblogsEntryUserId); return (List<MicroblogsEntry>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<MBThread> filterFindByG_C(long groupId, long categoryId, int start, int end) throws SystemException { if (!InlineSQLHelperUtil.isEnabled(groupId)) { return MBThreadUtil.findByG_C(groupId, categoryId, start, end); } Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_G_C); sql = InlineSQLHelperUtil.replacePermissionCheck( sql, MBMessage.class.getName(), "MBThread.rootMessageId", groupId); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBThread", MBThreadImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(categoryId); return (List<MBThread>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public int countByS_G_U(long groupId, long userId) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_S_G_U); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(MBCategory.class.getName())); qPos.add(groupId); qPos.add(userId); Iterator<Long> itr = q.list().iterator(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<JIRAAction> findByCD_P(Date createDate, long projectId, int start, int end) throws SystemException { Timestamp createDate_TS = CalendarUtil.getTimestamp(createDate); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_CD_P); SQLQuery q = session.createSQLQuery(sql); q.addEntity("jiraaction", JIRAActionImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(projectId); qPos.add(createDate_TS); return (List<JIRAAction>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public int countByG_U_C_A( long groupId, long userId, long[] categoryIds, boolean anonymous, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_G_U_C); if (ArrayUtil.isEmpty(categoryIds)) { sql = StringUtil.replace(sql, "(MBThread.categoryId = ?) AND", StringPool.BLANK); } else { sql = StringUtil.replace( sql, "MBThread.categoryId = ?", "MBThread.categoryId = " + StringUtil.merge(categoryIds, " OR MBThread.categoryId = ")); } sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(userId); qPos.add(anonymous); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<WallEntry> findByG1_G2_U1_U2( long groupId1, long groupId2, long userId1, long userId2, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_G1_G2_U1_U2); SQLQuery q = session.createSQLQuery(sql); q.addEntity("SN_WallEntry", WallEntryImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId1); qPos.add(groupId2); qPos.add(userId1); qPos.add(userId2); return (List<WallEntry>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<MBThread> findByS_G_U(long groupId, long userId, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_S_G_U); sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBThread", MBThreadImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(MBThread.class.getName())); qPos.add(groupId); qPos.add(userId); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } return (List<MBThread>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(), queryDefinition.getEnd()); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<MBCategory> findByS_G_U(long groupId, long userId, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_S_G_U); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBCategory", MBCategoryImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(MBCategory.class.getName())); qPos.add(groupId); qPos.add(userId); return (List<MBCategory>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<NotificationEntry> getNotificationEntryByUserId( long usreId, String typeNotification, int start, int end) throws SystemException { List list = null; // / This stuff is basic set up Session session = null; try { session = openSession(); // Here ends the basic set up;x` String sql = ""; // now we build the query. Note that we use the name of the tables // from the database! if (typeNotification.equals("NOTIFICATIONUSERIDFROM")) { sql = CustomSQLUtil.get(SQL_getNotificationEntryByUserIdFrom); } else { sql = CustomSQLUtil.get(SQL_getNotificationEntryByUserIdTo); } SQLQuery query = session.createSQLQuery(sql); query.addEntity("NotificationEntry", NotificationEntryImpl.class); QueryPos qPos = QueryPos.getInstance(query); qPos.add(usreId); list = QueryUtil.list(query, getDialect(), start, end); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { closeSession(session); } return list; }
public int getNotificationEntryByUserIdCount(long usreId, String typeNotification) throws SystemException { Session session = null; int count = 0; try { session = openSession(); String sql = ""; if (typeNotification.equals("NOTIFICATIONUSERIDFROM")) { sql = CustomSQLUtil.get(SQL_getNotificationEntryByUserIdCountFrom); } else { sql = CustomSQLUtil.get(SQL_getNotificationEntryByUserIdCountTo); } SQLQuery query = session.createSQLQuery(sql); // query.addEntity("vrbt_service", ServiceImpl.class); QueryPos qPos = QueryPos.getInstance(query); qPos.add(usreId); Object obj = query.uniqueResult(); count = Integer.valueOf(obj.toString()); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); throw processException(e); } finally { closeSession(session); } return count; }
public List<MicroblogsEntry> findByUserId(long userId, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_USER_ID); sql = StringUtil.replace(sql, "[$JOIN_BY_SOCIAL_RELATION$]", _joinBySocialRelationSQL); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MicroblogsEntry", MicroblogsEntryImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(MicroblogsEntryConstants.TYPE_EVERYONE); qPos.add(userId); qPos.add(userId); qPos.add(userId); return (List<MicroblogsEntry>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
protected int doCountByG_C( long groupId, long categoryId, QueryDefinition queryDefinition, boolean inlineSQLHelper) throws SystemException { if (!inlineSQLHelper || !InlineSQLHelperUtil.isEnabled(groupId)) { if (queryDefinition.isExcludeStatus()) { return MBThreadUtil.countByG_C_NotS(groupId, categoryId, queryDefinition.getStatus()); } else { if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { return MBThreadUtil.countByG_C_S(groupId, categoryId, queryDefinition.getStatus()); } else { return MBThreadUtil.countByG_C(groupId, categoryId); } } } Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_G_C); sql = updateSQL(sql, queryDefinition); sql = InlineSQLHelperUtil.replacePermissionCheck( sql, MBMessage.class.getName(), "MBThread.rootMessageId", groupId); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(categoryId); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } }
@Override public List<ResourcePermission> findByResource( long companyId, long groupId, String name, String primKey) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_RESOURCE); SQLQuery q = session.createSQLQuery(sql); q.addEntity("ResourcePermission", ResourcePermissionImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); qPos.add(name); qPos.add(primKey); qPos.add(String.valueOf(groupId)); return (List<ResourcePermission>) QueryUtil.list(q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public int countByGroupId(long groupId) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_GROUP_ID); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<SocialActivity> findByUserOrganizations(long userId, int start, int end) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_USER_ORGANIZATIONS); SQLQuery q = session.createSQLQuery(sql); q.addEntity("SocialActivity", SocialActivityImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(userId); return (List<SocialActivity>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public int countByParents(String listParent) throws SystemException { Session session = null; try { session = openSession(); StringBuffer query = new StringBuffer(); query.append("SELECT COUNT(*) as total FROM Vlookupprice WHERE listParent LIKE ?"); SQLQuery q = session.createSQLQuery(query.toString()); q.addScalar("total", Type.LONG); int queryPos = 0; q.setString(queryPos++, "%" + listParent + "%"); Long count = null; Iterator ite = q.list().iterator(); while (ite.hasNext()) { count = (Long) ite.next(); } if (count == null) { count = new Long(0); } return count.intValue(); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<CalEvent> findByFutureReminders() throws SystemException { Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.HOUR, -24); Timestamp calendar_TS = CalendarUtil.getTimestamp(calendar.getTime()); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_FUTURE_REMINDERS); SQLQuery q = session.createSQLQuery(sql); q.addEntity("CalEvent", CalEventImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(CalEventConstants.REMIND_BY_NONE); qPos.add(calendar_TS); qPos.add(calendar_TS); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
protected List<Long> countByC_FN_MN_LN_SN_EA_S( Session session, long companyId, String[] firstNames, String[] middleNames, String[] lastNames, String[] screenNames, String[] emailAddresses, int status, LinkedHashMap<String, Object> params, boolean andOperator) { String sql = CustomSQLUtil.get(COUNT_BY_C_FN_MN_LN_SN_EA_S); sql = CustomSQLUtil.replaceKeywords( sql, "lower(User_.firstName)", StringPool.LIKE, false, firstNames); sql = CustomSQLUtil.replaceKeywords( sql, "lower(User_.middleName)", StringPool.LIKE, false, middleNames); sql = CustomSQLUtil.replaceKeywords( sql, "lower(User_.lastName)", StringPool.LIKE, false, lastNames); sql = CustomSQLUtil.replaceKeywords( sql, "lower(User_.screenName)", StringPool.LIKE, false, screenNames); sql = CustomSQLUtil.replaceKeywords( sql, "lower(User_.emailAddress)", StringPool.LIKE, true, emailAddresses); if (status == WorkflowConstants.STATUS_ANY) { sql = StringUtil.replace(sql, _STATUS_SQL, StringPool.BLANK); } sql = replaceJoinAndWhere(sql, params); sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); SQLQuery q = session.createSQLQuery(sql); q.addScalar("userId", Type.LONG); QueryPos qPos = QueryPos.getInstance(q); setJoin(qPos, params); qPos.add(companyId); qPos.add(false); qPos.add(firstNames, 2); qPos.add(middleNames, 2); qPos.add(lastNames, 2); qPos.add(screenNames, 2); qPos.add(emailAddresses, 2); if (status != WorkflowConstants.STATUS_ANY) { qPos.add(status); } return q.list(true); }
protected List<MBThread> doFindByS_G_U_C( long groupId, long userId, long[] categoryIds, QueryDefinition queryDefinition, boolean inlineSQLHelper) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_S_G_U_C); if (ArrayUtil.isEmpty(categoryIds)) { sql = StringUtil.replace(sql, "(MBThread.categoryId = ?) AND", StringPool.BLANK); } else { sql = StringUtil.replace( sql, "MBThread.categoryId = ?", "MBThread.categoryId = " + StringUtil.merge(categoryIds, " OR MBThread.categoryId = ")); } sql = updateSQL(sql, queryDefinition); if (inlineSQLHelper) { sql = InlineSQLHelperUtil.replacePermissionCheck( sql, MBMessage.class.getName(), "MBThread.rootMessageId", groupId); } SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBThread", MBThreadImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(MBThread.class.getName())); qPos.add(groupId); qPos.add(userId); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } return (List<MBThread>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(), queryDefinition.getEnd()); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public int countByG_SD_T( long groupId, Date startDateGT, Date startDateLT, boolean timeZoneSensitive, String[] types) throws SystemException { Timestamp startDateGT_TS = CalendarUtil.getTimestamp(startDateGT); Timestamp startDateLT_TS = CalendarUtil.getTimestamp(startDateLT); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_G_SD_T); sql = StringUtil.replace(sql, "[$TYPE$]", getTypes(types)); SQLQuery q = session.createSQLQuery(sql); q.addEntity("CalEvent", CalEventImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(startDateGT_TS); qPos.add(startDateLT_TS); qPos.add(timeZoneSensitive); qPos.add(false); if ((types != null) && (types.length > 0) && ((types.length > 1) || Validator.isNotNull(types[0]))) { for (String type : types) { qPos.add(type); } } Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public int countByG_U_LPD( long groupId, long userId, Date lastPostDate, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_G_U_LPD); if (userId <= 0) { sql = StringUtil.replace(sql, _INNER_JOIN_SQL, StringPool.BLANK); sql = StringUtil.replace(sql, _USER_ID_SQL, StringPool.BLANK); } sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(lastPostDate); if (userId > 0) { qPos.add(userId); } if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<MBThread> findByG_U_C_A( long groupId, long userId, long[] categoryIds, boolean anonymous, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_G_U_C_A); if (ArrayUtil.isEmpty(categoryIds)) { sql = StringUtil.replace(sql, "(MBThread.categoryId = ?) AND", StringPool.BLANK); } else { sql = StringUtil.replace( sql, "MBThread.categoryId = ?", "MBThread.categoryId = " + StringUtil.merge(categoryIds, " OR MBThread.categoryId = ")); } sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBThread", MBThreadImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(userId); qPos.add(anonymous); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } return (List<MBThread>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(), queryDefinition.getEnd()); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
/** * Returns an ordered range of all the h r holidaies associated with the h r office. * * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances. * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} * will return the full result set. * * @param pk the primary key of the h r office * @param start the lower bound of the range of h r offices * @param end the upper bound of the range of h r offices (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of h r holidaies associated with the h r office * @throws SystemException if a system exception occurred */ public List<com.liferay.hr.model.HRHoliday> getHRHolidaies( long pk, int start, int end, OrderByComparator orderByComparator) throws SystemException { Object[] finderArgs = new Object[] { pk, String.valueOf(start), String.valueOf(end), String.valueOf(orderByComparator) }; List<com.liferay.hr.model.HRHoliday> list = (List<com.liferay.hr.model.HRHoliday>) FinderCacheUtil.getResult(FINDER_PATH_GET_HRHOLIDAIES, finderArgs, this); if (list == null) { Session session = null; try { session = openSession(); String sql = null; if (orderByComparator != null) { sql = _SQL_GETHRHOLIDAIES.concat(ORDER_BY_CLAUSE).concat(orderByComparator.getOrderBy()); } else { sql = _SQL_GETHRHOLIDAIES; } SQLQuery q = session.createSQLQuery(sql); q.addEntity("HRHoliday", com.liferay.hr.model.impl.HRHolidayImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(pk); list = (List<com.liferay.hr.model.HRHoliday>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw processException(e); } finally { if (list == null) { FinderCacheUtil.removeResult(FINDER_PATH_GET_HRHOLIDAIES, finderArgs); } else { hrHolidayPersistence.cacheResult(list); FinderCacheUtil.putResult(FINDER_PATH_GET_HRHOLIDAIES, finderArgs, list); } closeSession(session); } } return list; }
@Override public List<CalEvent> findByG_SD_T( long groupId, Date startDateGT, Date startDateLT, boolean timeZoneSensitive, String[] types, int start, int end) throws SystemException { Timestamp startDateGT_TS = CalendarUtil.getTimestamp(startDateGT); Timestamp startDateLT_TS = CalendarUtil.getTimestamp(startDateLT); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_G_SD_T); sql = StringUtil.replace(sql, "[$TYPE$]", getTypes(types)); SQLQuery q = session.createSQLQuery(sql); q.addEntity("CalEvent", CalEventImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(startDateGT_TS); qPos.add(startDateLT_TS); qPos.add(timeZoneSensitive); qPos.add(false); if ((types != null) && (types.length > 0) && ((types.length > 1) || Validator.isNotNull(types[0]))) { for (String type : types) { qPos.add(type); } } return (List<CalEvent>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List<PaymentPlugin> findByTransactionAndPaymentMethod( long transactionId, long paymentMethodId, Boolean configured, int start, int end, OrderByComparator obc) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_TRANSACTIONID_AND_PAYMENTMETHODID); if (configured == null) { sql = StringUtil.replace(sql, "(Payment_PaymentPlugin.configured = ?) AND", ""); sql = StringUtil.replace(sql, "(Payment_PaymentPluginConfig.configured = ?) AND", ""); } CustomSQLUtil.replaceOrderBy(sql, obc); SQLQuery q = session.createSQLQuery(sql); q.addEntity("Payment_PaymentPlugin", PaymentPluginImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(transactionId); qPos.add(paymentMethodId); if (configured != null) { qPos.add(configured); qPos.add(configured); } List<PaymentPlugin> results = (List<PaymentPlugin>) QueryUtil.list(q, getDialect(), start, end); return results; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public List findByParents(String listParent, int start, int end) throws SystemException { Session session = null; try { session = openSession(); StringBuffer query = new StringBuffer(); query.append("SELECT * FROM Vlookupprice WHERE listParent LIKE ?"); SQLQuery q = session.createSQLQuery(query.toString()); q.addEntity("Vlookupprice", VlookuppriceImpl.class); int queryPos = 0; q.setString(queryPos++, "%" + listParent + "%"); return QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
public int countByTransactionAndPaymentMethod( long transactionId, long paymentMethodId, Boolean configured) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_TRANSACTIONID_AND_PAYMENTMETHODID); if (configured == null) { sql = StringUtil.replace(sql, "(Payment_PaymentPlugin.configured = ?) AND", ""); sql = StringUtil.replace(sql, "(Payment_PaymentPluginConfig.configured = ?) AND", ""); } SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(transactionId); qPos.add(paymentMethodId); if (configured != null) { qPos.add(configured); qPos.add(configured); } Iterator<Long> itr = q.list().iterator(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public int countByG_U_A( long groupId, long userId, boolean anonymous, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_G_U_A); sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(userId); qPos.add(anonymous); if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } Iterator<Long> itr = q.iterate(); if (itr.hasNext()) { Long count = itr.next(); if (count != null) { return count.intValue(); } } return 0; } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<MBThread> findByG_U_LPD( long groupId, long userId, Date lastPostDate, QueryDefinition queryDefinition) throws SystemException { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_G_U_LPD); if (userId <= 0) { sql = StringUtil.replace(sql, _INNER_JOIN_SQL, StringPool.BLANK); sql = StringUtil.replace(sql, _USER_ID_SQL, StringPool.BLANK); } sql = updateSQL(sql, queryDefinition); SQLQuery q = session.createSQLQuery(sql); q.addEntity("MBThread", MBThreadImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(groupId); qPos.add(lastPostDate); if (userId > 0) { qPos.add(userId); } if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) { qPos.add(queryDefinition.getStatus()); } return (List<MBThread>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(), queryDefinition.getEnd()); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }