Example usage for org.hibernate.criterion Restrictions ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value) 

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:org.nema.medical.mint.server.domain.StudyDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<MINTStudy> getMostRecentStudies(final int max, final int seconds) {
    final Calendar calendar = Calendar.getInstance(GMT);
    calendar.add(Calendar.SECOND, -between(1, MAXSECONDS, seconds));

    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(MINTStudy.class)
            .add(Restrictions.ge("lastModified", calendar.getTime())).addOrder(Order.desc("lastModified"));

    //Eliminate deleted studies from search results
    detachedCriteria.add(Restrictions.ne("studyVersion", "-1"));

    final List<MINTStudy> list = getHibernateTemplate().findByCriteria(detachedCriteria, 0,
            between(1, 50, max));//from   ww w  . jav  a  2s .co m
    return list;
}

---

From source file:org.openbp.server.persistence.hibernate.HibernatePersistenceContext.java

License:Apache License

/**
 * Returns a list of the objects of a particular type that match the given criterion.
 *
 * @param query Query to run/*from  www .  j ava  2  s. c o  m*/
 * @return The list or null
 * @throws PersistenceException On error
 */
public Collection runQuery(final PersistenceQuery query) throws PersistenceException {
    TransactionGuard tg = new TransactionGuard(this);
    try {
        Class cls = getMappedObjectClass(query.getObjectClass(), false);
        Criteria hc = getHibernateSession().createCriteria(cls);
        if (query.getMaxResults() > 0) {
            hc.setMaxResults(query.getMaxResults());
        }

        for (Iterator it = query.getOrderings(); it.hasNext();) {
            PersistenceOrdering ordering = (PersistenceOrdering) it.next();

            Order ho = ordering.isAscending() ? Order.asc(ordering.getPropertyName())
                    : Order.desc(ordering.getPropertyName());
            hc.addOrder(ho);
        }

        for (Iterator it = query.getCriterions(); it.hasNext();) {
            PersistenceCriterion criterion = (PersistenceCriterion) it.next();

            String property = criterion.getProperty();
            String operator = criterion.getOperator();
            Object value = criterion.getOperand();
            if (PersistenceCriterion.OPERATOR_EQ.equals(operator)) {
                hc = hc.add(Restrictions.eq(property, value));
            } else if (PersistenceCriterion.OPERATOR_EQ_OR_NULL.equals(operator)) {
                hc = hc.add(Restrictions.disjunction().add(Restrictions.isNull(property))
                        .add(Restrictions.eq(property, value)));
            } else if (PersistenceCriterion.OPERATOR_NEQ.equals(operator)) {
                hc = hc.add(Restrictions.ne(property, value));
            } else if (PersistenceCriterion.OPERATOR_GT.equals(operator)) {
                hc = hc.add(Restrictions.gt(property, value));
            } else if (PersistenceCriterion.OPERATOR_GTE.equals(operator)) {
                hc = hc.add(Restrictions.ge(property, value));
            } else if (PersistenceCriterion.OPERATOR_LT.equals(operator)) {
                hc = hc.add(Restrictions.lt(property, value));
            } else if (PersistenceCriterion.OPERATOR_LTE.equals(operator)) {
                hc = hc.add(Restrictions.le(property, value));
            } else if (PersistenceCriterion.OPERATOR_LIKE.equals(operator)) {
                hc = hc.add(Restrictions.gt(property, value));
            } else if (PersistenceCriterion.OPERATOR_NULL.equals(operator)) {
                hc = hc.add(Restrictions.isNull(property));
            } else if (PersistenceCriterion.OPERATOR_ALIAS.equals(operator)) {
                hc = hc.createAlias(property, (String) value);
            }
        }

        // Run query and wrap result list into a collection that calls onLoad for each element that is being accessed.
        Collection root = hc.list();
        return new DeferedOnLoadCollection(root, this);
    } catch (HibernateException e) {
        tg.doCatch();
        throw createLoggedException(e);
    } finally {
        tg.doFinally();
    }
}

---

From source file:org.openbravo.advpaymentmngt.ad_actionbutton.MatchTransaction.java

License:Open Source License

/**
 * Merges given bank statement line with other bank statement lines with the same line number and
 * not matched with any transaction.//  w  w  w . j  a v a  2s  . co  m
 * 
 * @param bsline
 *          Bank Statement Line.
 */
private void mergeBankStatementLine(FIN_BankStatementLine bsline) {
    BigDecimal totalCredit = bsline.getCramount();
    BigDecimal totalDebit = bsline.getDramount();
    FIN_BankStatement bs = bsline.getBankStatement();
    OBCriteria<FIN_BankStatementLine> obc = OBDal.getInstance().createCriteria(FIN_BankStatementLine.class);
    obc.add(Restrictions.eq(FIN_BankStatementLine.PROPERTY_BANKSTATEMENT, bsline.getBankStatement()));
    obc.add(Restrictions.eq(FIN_BankStatementLine.PROPERTY_LINENO, bsline.getLineNo()));
    obc.add(Restrictions.ne(FIN_BankStatementLine.PROPERTY_ID, bsline.getId()));
    obc.add(Restrictions.isNull(FIN_BankStatementLine.PROPERTY_FINANCIALACCOUNTTRANSACTION));

    if (obc.list().size() > 0) {
        bs.setProcessed(false);
        OBDal.getInstance().save(bs);
        OBDal.getInstance().flush();

        for (FIN_BankStatementLine bsl : obc.list()) {
            totalCredit = totalCredit.add(bsl.getCramount());
            totalDebit = totalDebit.add(bsl.getDramount());
            for (FIN_ReconciliationLineTemp tempbsline : getRecTempLines(bsl)) {
                tempbsline.setBankStatementLine(bsline);
                OBDal.getInstance().save(tempbsline);
            }
            OBDal.getInstance().remove(bsl);
        }

        if (totalCredit.compareTo(BigDecimal.ZERO) != 0 && totalDebit.compareTo(BigDecimal.ZERO) != 0) {
            BigDecimal total = totalCredit.subtract(totalDebit);
            if (total.compareTo(BigDecimal.ZERO) == -1) {
                bsline.setCramount(BigDecimal.ZERO);
                bsline.setDramount(total.abs());
            } else {
                bsline.setCramount(total);
                bsline.setDramount(BigDecimal.ZERO);
            }
        } else {
            bsline.setCramount(totalCredit);
            bsline.setDramount(totalDebit);
        }

        OBDal.getInstance().save(bsline);
        OBDal.getInstance().flush();

        bs.setProcessed(true);
        OBDal.getInstance().save(bs);
        OBDal.getInstance().flush();
    }

}

---

From source file:org.openbravo.advpaymentmngt.dao.AdvPaymentMngtDao.java

License:Open Source License

@Deprecated
public List<FIN_Payment> getCustomerPaymentsWithCredit(BusinessPartner bp, boolean isReceipt) {
    OBCriteria<FIN_Payment> obcPayment = OBDal.getInstance().createCriteria(FIN_Payment.class);
    obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_BUSINESSPARTNER, bp));
    obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_RECEIPT, isReceipt));
    obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_GENERATEDCREDIT, BigDecimal.ZERO));
    obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_STATUS, "RPAP"));
    obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_STATUS, "RPVOID"));
    obcPayment.add(/*  w w  w. j  a  v a 2s . c om*/
            Restrictions.neProperty(FIN_Payment.PROPERTY_GENERATEDCREDIT, FIN_Payment.PROPERTY_USEDCREDIT));
    obcPayment.addOrderBy(FIN_Payment.PROPERTY_PAYMENTDATE, true);
    obcPayment.addOrderBy(FIN_Payment.PROPERTY_DOCUMENTNO, true);
    return obcPayment.list();
}

---

From source file:org.openbravo.advpaymentmngt.dao.AdvPaymentMngtDao.java

License:Open Source License

/**
 * Returns the list of credit payments for the selected business partner that belongs to the legal
 * entity's natural tree of the given organization
 *///from w  w w . ja  v  a 2  s .  c  om
public List<FIN_Payment> getCustomerPaymentsWithCredit(Organization org, BusinessPartner bp,
        boolean isReceipt) {

    try {
        OBContext.setAdminMode(true);
        OBCriteria<FIN_Payment> obcPayment = OBDal.getInstance().createCriteria(FIN_Payment.class);
        obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_BUSINESSPARTNER, bp));
        obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_RECEIPT, isReceipt));
        obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_GENERATEDCREDIT, BigDecimal.ZERO));
        obcPayment.add(
                Restrictions.neProperty(FIN_Payment.PROPERTY_GENERATEDCREDIT, FIN_Payment.PROPERTY_USEDCREDIT));
        final Organization legalEntity = FIN_Utility.getLegalEntityOrg(org);
        Set<String> orgIds = OBContext.getOBContext().getOrganizationStructureProvider()
                .getChildTree(legalEntity.getId(), true);
        obcPayment.add(Restrictions.in("organization.id", orgIds));
        obcPayment.addOrderBy(FIN_Payment.PROPERTY_PAYMENTDATE, true);
        obcPayment.addOrderBy(FIN_Payment.PROPERTY_DOCUMENTNO, true);

        List<FIN_Payment> paymentList = new ArrayList<FIN_Payment>();
        for (FIN_Payment fp : obcPayment.list()) {
            if ((FIN_Utility.seqnumberpaymentstatus(fp.getStatus())) >= (FIN_Utility
                    .seqnumberpaymentstatus(FIN_Utility.invoicePaymentStatus(fp)))) {
                paymentList.add(fp);
            }

        }
        return paymentList;
    } finally {
        OBContext.restorePreviousMode();
    }
}

---

From source file:org.openbravo.advpaymentmngt.dao.AdvPaymentMngtDao.java

License:Open Source License

public List<FIN_Payment> getCustomerPaymentsWithUsedCredit(BusinessPartner bp, Boolean isReceipt) {
    OBCriteria<FIN_Payment> obcPayment = OBDal.getInstance().createCriteria(FIN_Payment.class);
    obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_BUSINESSPARTNER, bp));
    obcPayment.add(Restrictions.eq(FIN_Payment.PROPERTY_RECEIPT, isReceipt));
    obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_GENERATEDCREDIT, BigDecimal.ZERO));
    obcPayment.add(Restrictions.ne(FIN_Payment.PROPERTY_USEDCREDIT, BigDecimal.ZERO));
    obcPayment.addOrderBy(FIN_Payment.PROPERTY_PAYMENTDATE, false);
    obcPayment.addOrderBy(FIN_Payment.PROPERTY_DOCUMENTNO, false);
    return obcPayment.list();
}

---

From source file:org.openbravo.advpaymentmngt.process.FIN_PaymentMonitorProcess.java

License:Open Source License

private static Long getDaysTillDue(Invoice invoice) {
    // Calculate days till due
    final OBCriteria<FIN_PaymentSchedule> obc = OBDal.getInstance().createCriteria(FIN_PaymentSchedule.class);
    // For Background process execution at system level
    if (OBContext.getOBContext().isInAdministratorMode()) {
        obc.setFilterOnReadableClients(false);
        obc.setFilterOnReadableOrganization(false);
    }/*  w ww.j a  v a 2  s .  com*/
    obc.add(Restrictions.eq(FIN_PaymentSchedule.PROPERTY_INVOICE, invoice));
    obc.add(Restrictions.ne(FIN_PaymentSchedule.PROPERTY_OUTSTANDINGAMOUNT, BigDecimal.ZERO));
    obc.setProjection(Projections.min(FIN_PaymentSchedule.PROPERTY_DUEDATE));
    Object o = obc.list().get(0);
    if (o != null) {
        return (FIN_Utility.getDaysToDue((Date) o));
    } else {
        return 0L;
    }
}

---

From source file:org.openbravo.advpaymentmngt.utility.APRM_MatchingUtility.java

License:Open Source License

/**
 * Merges given bank statement line with other bank statement lines with the same line number and
 * not matched with any transaction.//from w w  w  .j  av a2s .c  om
 * 
 * @param bsline
 *          Bank Statement Line.
 */
private static void mergeBankStatementLine(FIN_BankStatementLine bsline) {
    BigDecimal totalCredit = bsline.getCramount();
    BigDecimal totalDebit = bsline.getDramount();
    FIN_BankStatement bs = bsline.getBankStatement();
    OBCriteria<FIN_BankStatementLine> obc = OBDal.getInstance().createCriteria(FIN_BankStatementLine.class);
    obc.add(Restrictions.eq(FIN_BankStatementLine.PROPERTY_BANKSTATEMENT, bsline.getBankStatement()));
    obc.add(Restrictions.eq(FIN_BankStatementLine.PROPERTY_LINENO, bsline.getLineNo()));
    obc.add(Restrictions.ne(FIN_BankStatementLine.PROPERTY_ID, bsline.getId()));
    obc.add(Restrictions.isNull(FIN_BankStatementLine.PROPERTY_FINANCIALACCOUNTTRANSACTION));
    // Following list should contain just 2 elements maximum
    final List<FIN_BankStatementLine> splitLines = obc.list();

    if (!splitLines.isEmpty()) {
        // bs is set a false, because it is processed bs cannot be edited
        bs.setProcessed(false);
        OBDal.getInstance().save(bs);
        OBDal.getInstance().flush();

        for (final FIN_BankStatementLine bsl : splitLines) {
            totalCredit = totalCredit.add(bsl.getCramount());
            totalDebit = totalDebit.add(bsl.getDramount());
            OBDal.getInstance().remove(bsl);
        }

        if (totalCredit.compareTo(BigDecimal.ZERO) != 0 && totalDebit.compareTo(BigDecimal.ZERO) != 0) {
            BigDecimal total = totalCredit.subtract(totalDebit);
            if (total.compareTo(BigDecimal.ZERO) == -1) {
                bsline.setCramount(BigDecimal.ZERO);
                bsline.setDramount(total.abs());
            } else {
                bsline.setCramount(total);
                bsline.setDramount(BigDecimal.ZERO);
            }
        } else {
            bsline.setCramount(totalCredit);
            bsline.setDramount(totalDebit);
        }
        // Required to persist current bank statement line merges so that it is not rollbacked
        // afterwards because of a future error
        OBDal.getInstance().save(bsline);
        OBDal.getInstance().flush();

        // bs is set a true, because it was the status at the beginning of this function
        bs.setProcessed(true);
        OBDal.getInstance().save(bs);
        OBDal.getInstance().flush();
    }

}

---

From source file:org.openbravo.advpaymentmngt.utility.FIN_Utility.java

License:Open Source License

/**
 * Generic OBCriteria.//from w w w  . j a v a2  s.co  m
 * 
 * @param clazz
 *          Class (entity).
 * @param setFilterClient
 *          If true then only objects from readable clients are returned, if false then objects
 *          from all clients are returned
 * @param setFilterOrg
 *          If true then when querying (for example call list()) a filter on readable
 *          organizations is added to the query, if false then this is not done
 * @param values
 *          Value. Property, value and operator.
 * @return All the records that satisfy the conditions.
 */
public static <T extends BaseOBObject> List<T> getAllInstances(Class<T> clazz, boolean setFilterClient,
        boolean setFilterOrg, Value... values) {
    OBCriteria<T> obc = OBDal.getInstance().createCriteria(clazz);
    obc.setFilterOnReadableClients(setFilterClient);
    obc.setFilterOnReadableOrganization(setFilterOrg);
    for (Value value : values) {
        if (value.getValue() == null && "==".equals(value.getOperator())) {
            obc.add(Restrictions.isNull(value.getField()));
        } else if (value.getValue() == null && "!=".equals(value.getOperator())) {
            obc.add(Restrictions.isNotNull(value.getField()));
        } else if ("==".equals(value.getOperator())) {
            obc.add(Restrictions.eq(value.getField(), value.getValue()));
        } else if ("!=".equals(value.getOperator())) {
            obc.add(Restrictions.ne(value.getField(), value.getValue()));
        } else if ("<".equals(value.getOperator())) {
            obc.add(Restrictions.lt(value.getField(), value.getValue()));
        } else if (">".equals(value.getOperator())) {
            obc.add(Restrictions.gt(value.getField(), value.getValue()));
        } else if ("<=".equals(value.getOperator())) {
            obc.add(Restrictions.le(value.getField(), value.getValue()));
        } else if (">=".equals(value.getOperator())) {
            obc.add(Restrictions.ge(value.getField(), value.getValue()));
        } else {
            obc.add(Restrictions.eq(value.getField(), value.getValue()));
        }
    }
    return obc.list();
}

---

From source file:org.openbravo.advpaymentmngt.utility.FIN_Utility.java

License:Open Source License

/**
 * Generic OBCriteria./*w w w  . j a v  a  2  s .c  o  m*/
 * 
 * @param clazz
 *          Class (entity).
 * @param values
 *          Value. Property, value and operator.
 * @return One record that satisfies the conditions.
 */
public static <T extends BaseOBObject> T getOneInstance(Class<T> clazz, Value... values) {
    OBCriteria<T> obc = OBDal.getInstance().createCriteria(clazz);
    obc.setFilterOnReadableClients(false);
    obc.setFilterOnReadableOrganization(false);
    obc.add(Restrictions.ne(Client.PROPERTY_ID, "0"));
    for (Value value : values) {
        if (value.getValue() == null && "==".equals(value.getOperator())) {
            obc.add(Restrictions.isNull(value.getField()));
        } else if (value.getValue() == null && "!=".equals(value.getOperator())) {
            obc.add(Restrictions.isNotNull(value.getField()));
        } else if ("==".equals(value.getOperator())) {
            obc.add(Restrictions.eq(value.getField(), value.getValue()));
        } else if ("!=".equals(value.getOperator())) {
            obc.add(Restrictions.ne(value.getField(), value.getValue()));
        } else if ("<".equals(value.getOperator())) {
            obc.add(Restrictions.lt(value.getField(), value.getValue()));
        } else if (">".equals(value.getOperator())) {
            obc.add(Restrictions.gt(value.getField(), value.getValue()));
        } else if ("<=".equals(value.getOperator())) {
            obc.add(Restrictions.le(value.getField(), value.getValue()));
        } else if (">=".equals(value.getOperator())) {
            obc.add(Restrictions.ge(value.getField(), value.getValue()));
        } else {
            obc.add(Restrictions.eq(value.getField(), value.getValue()));
        }
    }

    final List<T> listt = obc.list();
    if (listt != null && listt.size() > 0) {
        return listt.get(0);
    } else {
        return null;
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »