Example usage for org.hibernate.criterion Restrictions ne

List of usage examples for org.hibernate.criterion Restrictions ne

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public List<Integer> findIdsOverdueForUser(Integer userId, Date date) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    addUserCriteria(criteria, userId);//from w ww .  j  a va 2  s  .c o  m
    criteria.add(Restrictions.lt("dueDate", date)).createAlias("invoiceStatus", "s")
            .add(Restrictions.ne("s.id", Constants.INVOICE_STATUS_PAID)).add(Restrictions.eq("isReview", 0))
            .setProjection(Projections.id()).addOrder(Order.desc("id"));
    return criteria.list();
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public Collection findWithBalanceByUser(UserDTO user) {

    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    criteria.add(Restrictions.eq("baseUser", user));
    criteria.add(Restrictions.ne("balance", BigDecimal.ZERO));
    criteria.add(Restrictions.eq("isReview", 0));
    criteria.add(Restrictions.eq("deleted", 0));

    return criteria.list();

}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public BigDecimal findTotalBalanceByUser(Integer userId) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);

    addUserCriteria(criteria, userId);//from w w  w .j a v  a2  s . co  m
    criteria.add(Restrictions.eq("isReview", 0));

    criteria.createAlias("invoiceStatus", "s").add(Restrictions.ne("s.id", Constants.INVOICE_STATUS_PAID));

    criteria.setProjection(Projections.sum("balance"));
    criteria.setComment("InvoiceDAS.findTotalBalanceByUser");

    Object ttlBal = criteria.uniqueResult();

    return (ttlBal == null ? BigDecimal.ZERO : (BigDecimal) ttlBal);
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

/**
 * Returns the sum total balance of all unpaid invoices for the given user.
 *
 * @param userId user id/*  ww w  . java  2  s . c o m*/
 * @return total balance of all unpaid invoices.
 */
public BigDecimal findTotalAmountOwed(Integer userId) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    addUserCriteria(criteria, userId);
    criteria.createAlias("invoiceStatus", "status");
    criteria.add(Restrictions.ne("status.id", Constants.INVOICE_STATUS_PAID));
    criteria.add(Restrictions.eq("isReview", 0));
    criteria.setProjection(Projections.sum("balance"));
    criteria.setComment("InvoiceDAS.findTotalAmountOwed");

    return (criteria.uniqueResult() == null ? BigDecimal.ZERO : (BigDecimal) criteria.uniqueResult());
}

From source file:com.sapienter.jbilling.server.order.db.OrderDAS.java

License:Open Source License

/**
 * Finds active recurring orders for a given user
 * @param userId/*from  w  w  w  .  j av  a  2  s .c o m*/
 * @return
 */
public List<OrderDTO> findByUserSubscriptions(Integer userId) {
    // I need to access an association, so I can't use the parent helper class
    Criteria criteria = getSession().createCriteria(OrderDTO.class).createAlias("orderStatus", "s")
            .add(Restrictions.eq("s.id", Constants.ORDER_STATUS_ACTIVE)).add(Restrictions.eq("deleted", 0))
            .createAlias("baseUserByUserId", "u").add(Restrictions.eq("u.id", userId))
            .createAlias("orderPeriod", "p").add(Restrictions.ne("p.id", Constants.ORDER_PERIOD_ONCE));

    return criteria.list();
}

From source file:com.sapienter.jbilling.server.payment.db.PaymentDAS.java

License:Open Source License

public BigDecimal findTotalRevenueByUser(Integer userId) {
    Criteria criteria = getSession().createCriteria(PaymentDTO.class);
    criteria.add(Restrictions.eq("deleted", 0)).createAlias("baseUser", "u")
            .add(Restrictions.eq("u.id", userId)).createAlias("paymentResult", "pr")
            .add(Restrictions.ne("pr.id", CommonConstants.PAYMENT_RESULT_FAILED));
    criteria.add(Restrictions.eq("isRefund", 0));
    criteria.setProjection(Projections.sum("amount"));
    criteria.setComment("PaymentDAS.findTotalRevenueByUser-Gross Receipts");

    BigDecimal grossReceipts = criteria.uniqueResult() == null ? BigDecimal.ZERO
            : (BigDecimal) criteria.uniqueResult();

    Criteria criteria2 = getSession().createCriteria(PaymentDTO.class);
    criteria2.add(Restrictions.eq("deleted", 0)).createAlias("baseUser", "u")
            .add(Restrictions.eq("u.id", userId)).createAlias("paymentResult", "pr")
            .add(Restrictions.ne("pr.id", CommonConstants.PAYMENT_RESULT_FAILED));
    criteria2.add(Restrictions.eq("isRefund", 1));
    criteria2.setProjection(Projections.sum("amount"));
    criteria2.setComment("PaymentDAS.findTotalRevenueByUser-Gross Refunds");

    BigDecimal refunds = criteria2.uniqueResult() == null ? BigDecimal.ZERO
            : (BigDecimal) criteria2.uniqueResult();

    //net revenue = gross - all refunds
    return (grossReceipts.subtract(refunds));
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * //  w  ww. j a va2  s.c  om
 * @param vote
 * @return
 */
public Page<Vote> find(Page<Vote> page, Vote vote, int type) {
    //System.out.println(page.getPageNo() + "---------------- ?count");
    //System.out.println(page.getPageSize() + "----------------?size");
    DetachedCriteria dc = voteDao.createDetachedCriteria();

    //      dc.createAlias("createBy.office", "office");
    //      dc.add(dataScopeFilter(user, "office", "createBy"));
    if (type == 0) {//
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.FIELD_DEL_FLAG, Vote.DEL_FLAG_NORMAL));
        System.out.println("0");
    } else if (type == 1) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("1");
    } else if (type == 2) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_YES));
        System.out.println("2");
    } else if (type == 3) {//?
        dc.add(Restrictions.lt(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("3");
    } else if (type == 4) {//?
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        //??
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        //?
        for (UserVote ut : list) {
            dc.add(Restrictions.ne(Vote.VOTE_ID, ut.getVoteId()));
        }
    } else if (type == 5) {//??
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        List<String> list1 = new ArrayList();
        for (UserVote uVote : list) {
            list1.add(uVote.getVoteId());
        }
        dc.add(Restrictions.in(Vote.VOTE_ID, list1));
    }
    dc.addOrder(Order.desc("createDate"));
    return voteDao.find(page, dc);
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ?//from  w ww .j  av  a 2 s  .co  m
 * @param user
 * @return
 */
public List<User> getList(User user) {
    User currentUser = UserUtils.getUser();
    DetachedCriteria dc = userDao.createDetachedCriteria();

    dc.createAlias("company", "company");
    if (user.getCompany() != null && StringUtils.isNotBlank(user.getCompany().getId())) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }

    dc.createAlias("office", "office");
    if (user.getOffice() != null && StringUtils.isNotBlank(user.getOffice().getId())) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }

    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", "1"));
    }
    if (user.getUserType() != null && !"".equals(user.getUserType())) {
        dc.add(Restrictions.eq("userType", user.getUserType()));
    }

    dc.add(dataScopeFilter(currentUser, "office", ""));

    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        String userName = EncodedUtil.decodeValue(user.getName());
        dc.add(Restrictions.like("name", "%" + userName + "%"));
    }
    if (StringUtils.isNotEmpty(user.getUserType())) {
        dc.add(Restrictions.eq("userType", user.getUserType()));
    }

    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));

    return userDao.find(dc);

}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ?id??/*from  ww w. jav a2s. c o m*/
 * @param page
 * @param searchName
 * @param officeId
 * @return
 */
public Page<User> findByOffice(Page<User> page, String searchName, String officeId) {
    DetachedCriteria dc = userDao.createDetachedCriteria();

    dc.createAlias("office", "office");
    if (StringUtils.isNotBlank(officeId)) {
        dc.add(Restrictions.eq("office.id", officeId));
    }

    if (StringUtils.isNotBlank(searchName)) {
        dc.add(Restrictions.or(Restrictions.like("name", "%" + searchName + "%"),
                Restrictions.like("mobile", "%" + searchName + "%")));
    }
    dc.add(Restrictions.ne("userType", "2"));//
    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));
    return userDao.find(page, dc);
}

From source file:com.selfsoft.business.service.impl.TbFixEntrustServiceImpl.java

public List<TbFixEntrust> findByTbFixEntrust(TbFixEntrust tbFixEntrust) {
    // TODO Auto-generated method stub
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixEntrust.class);

    if (null != tbFixEntrust) {

        if (null != tbFixEntrust.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbFixEntrust.getId()));
        }//  ww  w  . j  a va2 s.  c om

        if (null != tbFixEntrust.getEntrustCode() && !"".equals(tbFixEntrust.getEntrustCode())) {
            detachedCriteria.add(Restrictions.like("entrustCode", "%" + tbFixEntrust.getEntrustCode() + "%"));
        }
        if (null != tbFixEntrust.getFixDateStart()) {
            detachedCriteria.add(Restrictions.ge("fixDate", tbFixEntrust.getFixDateStart()));
        }
        if (null != tbFixEntrust.getFixDateEnd()) {
            detachedCriteria
                    .add(Restrictions.le("fixDate", CommonMethod.addDate(tbFixEntrust.getFixDateEnd(), 1)));
        }

        if (null != tbFixEntrust.getMinutes()) {

            Date newDate = new Date();

            tbFixEntrust.setEstimateDateStart(newDate);

            tbFixEntrust.setEstimateDateEnd(CommonMethod.addMinute(new Date(), tbFixEntrust.getMinutes()));

            if (null != tbFixEntrust.getEstimateDateStart()) {
                detachedCriteria.add(Restrictions.ge("estimateDate", tbFixEntrust.getEstimateDateStart()));
            }
            if (null != tbFixEntrust.getEstimateDateEnd()) {
                detachedCriteria.add(Restrictions.le("estimateDate", tbFixEntrust.getEstimateDateEnd()));
            }
        }

        if (null != tbFixEntrust.getTbCustomer()) {

            boolean customerCodeBoolean = (null != tbFixEntrust.getTbCustomer().getCustomerCode()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerCode()));

            boolean customerNameBoolean = (null != tbFixEntrust.getTbCustomer().getCustomerName()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerName()));

            boolean telephoneBoolean = (null != tbFixEntrust.getTbCustomer().getTelephone()
                    && !"".equals(tbFixEntrust.getTbCustomer().getTelephone()));

            if (customerCodeBoolean || customerNameBoolean || telephoneBoolean) {

                detachedCriteria.createAlias("tbCustomer", "tbCustomer");
            }

            if (null != tbFixEntrust.getTbCustomer().getCustomerCode()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerCode())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerCode",
                        "%" + tbFixEntrust.getTbCustomer().getCustomerCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCustomer().getCustomerName()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerName())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerName",
                        "%" + tbFixEntrust.getTbCustomer().getCustomerName() + "%"));
            }

            if (null != tbFixEntrust.getTbCustomer().getTelephone()
                    && !"".equals(tbFixEntrust.getTbCustomer().getTelephone())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.telephone",
                        "%" + tbFixEntrust.getTbCustomer().getTelephone() + "%"));
            }
        }

        if (null != tbFixEntrust.getTbCarInfo()) {
            detachedCriteria.createAlias("tbCarInfo", "tbCarInfo");

            if (null != tbFixEntrust.getTbCarInfo().getLicenseCode()) {
                detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                        "%" + tbFixEntrust.getTbCarInfo().getLicenseCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCarInfo().getChassisCode()) {
                detachedCriteria.add(Restrictions.like("tbCarInfo.chassisCode",
                        "%" + tbFixEntrust.getTbCarInfo().getChassisCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCarInfo().getTmCarModelType()) {
                detachedCriteria.createAlias("tbCarInfo.tmCarModelType", "tmCarModelType");

                if (null != tbFixEntrust.getTbCarInfo().getTmCarModelType().getId()) {
                    detachedCriteria.add(Restrictions.eq("tmCarModelType.id",
                            tbFixEntrust.getTbCarInfo().getTmCarModelType().getId()));
                }
            }
        }

        if (null != tbFixEntrust.getIsvalid()) {
            detachedCriteria.add(Restrictions.eq("isvalid", tbFixEntrust.getIsvalid()));
        }

        if (null != tbFixEntrust.getIsFinish()) {
            detachedCriteria.add(Restrictions.eq("isFinish", tbFixEntrust.getIsFinish()));
        }

        if (null != tbFixEntrust.getEntrustStatus()) {
            detachedCriteria.add(Restrictions.eq("entrustStatus", tbFixEntrust.getEntrustStatus()));
        }

        if (null != tbFixEntrust.getWjg() && !"".equals(tbFixEntrust.getWjg())) {

            if ("wjg".equals(tbFixEntrust.getWjg())) {

                detachedCriteria.add(Restrictions.ne("entrustStatus", 2L));

                detachedCriteria.add(Restrictions.ne("entrustStatus", 3L));

            }

            else if ("yjg".equals(tbFixEntrust.getWjg())) {

                detachedCriteria.add(Restrictions.or(Restrictions.eq("entrustStatus", 2L),
                        Restrictions.eq("entrustStatus", 3L)));

            }
        }

        if (null != tbFixEntrust.getJsqk() && !"".equals(tbFixEntrust.getJsqk())) {

            if ("wjs".equals(tbFixEntrust.getJsqk())) {

                detachedCriteria.add(Restrictions.ne("entrustStatus", 3L));

            }

            else if ("yjs".equals(tbFixEntrust.getJsqk())) {

                detachedCriteria.add(Restrictions.eq("entrustStatus", 3L));

            }
        }

        if (null != tbFixEntrust.getTmUser() && null != tbFixEntrust.getTmUser().getId()) {

            detachedCriteria.add(Restrictions.eq("tmUser.id", tbFixEntrust.getTmUser().getId()));

        }

    }
    return tbFixEntrustDao.findByCriteria(detachedCriteria, tbFixEntrust);
}