Examples with WorkspaceNode fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode used on opensource projects

Example 36 with WorkspaceNode

use of fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode in project muikku by otavanopisto.

the class WorkspaceNodeDAO method listByParentSortByOrderNumber.

public List<WorkspaceNode> listByParentSortByOrderNumber(WorkspaceNode parent) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<WorkspaceNode> criteria = criteriaBuilder.createQuery(WorkspaceNode.class);
    Root<WorkspaceNode> root = criteria.from(WorkspaceNode.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.equal(root.get(WorkspaceNode_.parent), parent));
    criteria.orderBy(criteriaBuilder.asc(root.get(WorkspaceNode_.orderNumber)));
    return entityManager.createQuery(criteria).getResultList();
}

Example 37 with WorkspaceNode

use of fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode in project muikku by otavanopisto.

the class WorkspaceNodeDAO method listByParentAndHiddenSortByOrderNumber.

public List<WorkspaceNode> listByParentAndHiddenSortByOrderNumber(WorkspaceNode parent, Boolean hidden) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<WorkspaceNode> criteria = criteriaBuilder.createQuery(WorkspaceNode.class);
    Root<WorkspaceNode> root = criteria.from(WorkspaceNode.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.and(criteriaBuilder.equal(root.get(WorkspaceNode_.parent), parent), criteriaBuilder.equal(root.get(WorkspaceNode_.hidden), hidden)));
    criteria.orderBy(criteriaBuilder.asc(root.get(WorkspaceNode_.orderNumber)));
    return entityManager.createQuery(criteria).getResultList();
}

Example 38 with WorkspaceNode

use of fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode in project muikku by otavanopisto.

the class WorkspaceNodeDAO method listByParentAndHidden.

public List<WorkspaceNode> listByParentAndHidden(WorkspaceNode parent, Boolean hidden) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<WorkspaceNode> criteria = criteriaBuilder.createQuery(WorkspaceNode.class);
    Root<WorkspaceNode> root = criteria.from(WorkspaceNode.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.and(criteriaBuilder.equal(root.get(WorkspaceNode_.parent), parent), criteriaBuilder.equal(root.get(WorkspaceNode_.hidden), hidden)));
    return entityManager.createQuery(criteria).getResultList();
}

Example 39 with WorkspaceNode

use of fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode in project muikku by otavanopisto.

the class WorkspaceNodeDAO method getMaximumOrderNumber.

public Integer getMaximumOrderNumber(WorkspaceNode parent) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<Integer> criteria = criteriaBuilder.createQuery(Integer.class);
    Root<WorkspaceNode> root = criteria.from(WorkspaceNode.class);
    criteria.select(criteriaBuilder.max(root.get(WorkspaceNode_.orderNumber)));
    criteria.where(criteriaBuilder.equal(root.get(WorkspaceNode_.parent), parent));
    return entityManager.createQuery(criteria).getSingleResult();
}

Example 40 with WorkspaceNode

use of fi.otavanopisto.muikku.plugins.workspace.model.WorkspaceNode in project muikku by otavanopisto.

the class WorkspaceNodeDAO method listParentByOrderNumberGreaterSortByGreater.

public List<WorkspaceNode> listParentByOrderNumberGreaterSortByGreater(WorkspaceNode parent, Integer orderNumber, Integer firstResult, Integer maxResults) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<WorkspaceNode> criteria = criteriaBuilder.createQuery(WorkspaceNode.class);
    Root<WorkspaceNode> root = criteria.from(WorkspaceNode.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.and(criteriaBuilder.equal(root.get(WorkspaceNode_.parent), parent), criteriaBuilder.greaterThan(root.get(WorkspaceNode_.orderNumber), orderNumber)));
    criteria.orderBy(criteriaBuilder.asc(root.get(WorkspaceNode_.orderNumber)));
    TypedQuery<WorkspaceNode> query = entityManager.createQuery(criteria);
    if (firstResult != null) {
        query.setFirstResult(firstResult);
    }
    if (maxResults != null) {
        query.setMaxResults(maxResults);
    }
    return query.getResultList();
}