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:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Check if Accounting code is in use//from w w  w . ja v a 2s. c om
  *
 * @param proj
 * @param company 
 * @return
 */
public boolean accountingCodeInUse(Project proj, Company company) {

    Criteria crit = getSession().createCriteria(getPersistentClass()).setProjection(Projections.rowCount())
            .add(Restrictions.eq(Project.ACCOUNTINGCODE, proj.getAccountingCode()))
            .add(Restrictions.ne(Project.IDPROJECT, proj.getIdProject())).createCriteria(Project.PERFORMINGORG)
            .add(Restrictions.eq(Performingorg.COMPANY, company));

    return ((Integer) crit.uniqueResult() > 0);
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Project> findByProgram(Program program, boolean investiment) {

    List<Project> list = new ArrayList<Project>();

    Criteria crit = getSession().createCriteria(getPersistentClass());
    crit.add(Restrictions.eq(Project.PROGRAM, program));

    if (investiment) {
        crit.add(Restrictions.ne(Project.INVESTMENTSTATUS, Constants.INVESTMENT_APPROVED));

        list.addAll(crit.list());//from   w ww. ja  v a2  s  . c  om
    } else {
        crit.add(Restrictions.eq(Project.INVESTMENTSTATUS, Constants.INVESTMENT_APPROVED));

        list.addAll(crit.list());
    }
    return list;
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Check if chart label is in use//from   w  w  w. ja  v  a 2  s  .c  o  m
 * @param proj
 * @param company
 * @return
 */
public boolean chartLabelInUse(Project proj, Company company) {

    Criteria crit = getSession().createCriteria(getPersistentClass()).setProjection(Projections.rowCount())
            .add(Restrictions.eq(Project.CHARTLABEL, proj.getChartLabel()))
            .add(Restrictions.ne(Project.IDPROJECT, proj.getIdProject())).createCriteria(Project.PERFORMINGORG)
            .add(Restrictions.eq(Performingorg.COMPANY, company));

    return ((Integer) crit.uniqueResult() > 0);
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * //www  .  j a  v a 2s .c o  m
 * @param program
 * @return
 */
public Double getBudgetBottomUp(Program program, boolean projectsDisabled) {

    Criteria crit = getSession().createCriteria(getPersistentClass())
            .setProjection(Projections.sum(Project.TCV)).add(Restrictions.eq(Project.PROGRAM, program));

    // Projects disabled
    if (projectsDisabled) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    Double budget = (Double) crit.uniqueResult();

    return (budget == null ? 0 : budget);
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Sum priority by program/*from   w  w  w  .j  ava 2 s .  com*/
 * @param program
 * @return
 */
public Integer sumPriorityByProgram(Program program, boolean projectsDisabled) {

    Criteria crit = getSession().createCriteria(getPersistentClass())
            .setProjection(Projections.sum(Project.PRIORITY)).add(Restrictions.eq(Project.PROGRAM, program))
            .add(Restrictions.disjunction()
                    .add(Restrictions.eq(Project.INVESTMENTSTATUS, Constants.INVESTMENT_APPROVED))
                    .add(Restrictions.eq(Project.INVESTMENTSTATUS, Constants.INVESTMENT_IN_PROCESS)));

    // Projects not disabled
    if (projectsDisabled) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    Integer priority = (Integer) crit.uniqueResult();

    return (priority == null ? 0 : priority);
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Search projects with list investment status
 * @param program//from  www .j a va  2s. co m
 * @param investmentStatus 
 * @return
 */
@SuppressWarnings("unchecked")
public List<Project> findByProgramAndInvestmentStatus(Program program, List<String> investmentStatus,
        boolean projectsDisabled) {

    Criteria crit = getSession().createCriteria(getPersistentClass())
            .add(Restrictions.eq(Project.PROGRAM, program));

    Disjunction disjunction = Restrictions.disjunction();

    for (String status : investmentStatus) {
        disjunction.add(Restrictions.eq(Project.INVESTMENTSTATUS, status));
    }
    crit.add(disjunction);

    // Projects not disabled
    if (projectsDisabled) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    crit.addOrder(Order.asc(Project.TCV));

    return crit.list();
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Find projects by program and show or not show projects disabled
 * //ww  w .  ja  v  a  2s .  c  om
 * @param program
 * @param projectsDisabled
 * @return
 */
@SuppressWarnings("unchecked")
public List<Project> findByProgramAndProjectsDisabled(Program program, boolean projectsDisabled) {

    List<Project> projects = null;

    if (program.getIdProgram() != -1) {

        Criteria crit = getSession().createCriteria(getPersistentClass());

        crit.add(Restrictions.eq("program.idProgram", program.getIdProgram()));

        // Projects not disabled
        if (projectsDisabled) {

            crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                    .add(Restrictions.isNull(Project.DISABLE)));
        }

        projects = crit.list();
    }

    return projects;
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * // w w w  .  j av a  2s  .  co m
 * @param performingorg
 * @param projectsDisabled
 * @return
 */
@SuppressWarnings("unchecked")
public List<Project> findByPO(Performingorg performingorg, boolean projectsDisabled) {

    Criteria crit = getSession().createCriteria(getPersistentClass())
            .add(Restrictions.eq(Project.PERFORMINGORG, performingorg))
            .add(Restrictions.or(Restrictions.eq(Project.STATUS, Constants.STATUS_CONTROL),
                    Restrictions.eq(Project.STATUS, Constants.STATUS_PLANNING)));

    // Projects not disabled
    if (projectsDisabled) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    return crit.list();
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Find by user role and not Initiating project
 * //from   w w w .  j  av a 2s.  c  o  m
 * @param user
 * @param enableDisable
 * @return
 */
@SuppressWarnings("unchecked")
public List<Project> findByUser(Employee user, Boolean enableDisable) {

    // Create criteria
    Criteria crit = getSession().createCriteria(getPersistentClass());

    // Not initiating projects
    crit.add(Restrictions.ne(Project.STATUS, Constants.STATUS_INITIATING));

    if (Constants.ROLE_PM == user.getResourceprofiles().getIdProfile()) {

        // By Project Manager
        crit.add(Restrictions.eq(Project.EMPLOYEEBYPROJECTMANAGER, user));
    } else if (Constants.ROLE_FM == user.getResourceprofiles().getIdProfile()) {

        // By Functional Manager
        crit.add(Restrictions.eq(Project.EMPLOYEEBYFUNCTIONALMANAGER, user));
    } else if (Constants.ROLE_IM == user.getResourceprofiles().getIdProfile()) {

        // By Investment Manager
        crit.add(Restrictions.eq(Project.EMPLOYEEBYINVESTMENTMANAGER, user));
    } else if (Constants.ROLE_SPONSOR == user.getResourceprofiles().getIdProfile()) {

        // By Sponsor
        crit.add(Restrictions.eq(Project.EMPLOYEEBYSPONSOR, user));
    } else {

        // Other case by PO
        crit.add(Restrictions.eq(Project.PERFORMINGORG, user.getPerformingorg()));
    }

    // If setting disabled is enabled restrict projects not disabled
    if (enableDisable) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Boolean.TRUE))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    // order by project name
    crit.addOrder(Order.asc(Project.PROJECTNAME));

    List<String> joins = new ArrayList<String>();
    joins.add(Project.PERFORMINGORG);
    joins.add(Project.EMPLOYEEBYPROJECTMANAGER);
    joins.add(Project.EMPLOYEEBYPROJECTMANAGER + "." + Employee.CONTACT);

    addJoins(crit, joins);

    return crit.list();
}

From source file:es.sm2.openppm.core.dao.ProjectDAO.java

License:Open Source License

/**
 * Search projects with list project status
 *
 * @param po/*from  w w  w .j a v  a  2s .c om*/
 * @param projectStatus
 * @param projectsDisabled
 * @return
 */
public List<Project> findByPOAndProjectStatus(Performingorg po, List<String> projectStatus,
        boolean projectsDisabled) {

    // Create criteria
    Criteria crit = getSession().createCriteria(getPersistentClass());

    // Filter by PO
    if (po != null) {
        crit.add(Restrictions.eq(Project.PERFORMINGORG, po));
    }

    // Filter by proejct status
    if (ValidateUtil.isNotNull(projectStatus)) {
        crit.add(Restrictions.in(Project.STATUS, projectStatus));
    }

    // Projects not disabled
    if (projectsDisabled) {

        crit.add(Restrictions.disjunction().add(Restrictions.ne(Project.DISABLE, Constants.SELECTED))
                .add(Restrictions.isNull(Project.DISABLE)));
    }

    // Filter investments rejected
    crit.add(Restrictions.ne(Project.INVESTMENTSTATUS, Constants.INVESTMENT_REJECTED));

    // Order
    crit.addOrder(Order.asc(Project.CHARTLABEL));

    return crit.list();
}