• Home
• fi.foyt.fni
• persistence
• 3.2.120
• source code
• MaterialDAO.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

fi.foyt.fni.persistence.dao.materials.MaterialDAO Maven / Gradle / Ivy

package fi.foyt.fni.persistence.dao.materials;

import java.util.Collection;
import java.util.Date;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Join;
import javax.persistence.criteria.Root;

import fi.foyt.fni.persistence.model.materials.Material_;
import fi.foyt.fni.persistence.dao.GenericDAO;
import fi.foyt.fni.persistence.model.materials.Folder;
import fi.foyt.fni.persistence.model.materials.Material;
import fi.foyt.fni.persistence.model.materials.MaterialPublicity;
import fi.foyt.fni.persistence.model.materials.MaterialRole;
import fi.foyt.fni.persistence.model.materials.MaterialType;
import fi.foyt.fni.persistence.model.materials.UserMaterialRole;
import fi.foyt.fni.persistence.model.materials.UserMaterialRole_;
import fi.foyt.fni.persistence.model.users.User;

public class MaterialDAO extends GenericDAO {

	private static final long serialVersionUID = 1L;


	public Material findByParentFolderAndUrlName(Folder parentFolder, String urlName) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
        criteriaBuilder.and(
          criteriaBuilder.equal(root.get(Material_.parentFolder), parentFolder),
          criteriaBuilder.equal(root.get(Material_.urlName), urlName)
        )
    );
    
    return getSingleResult(entityManager.createQuery(criteria));
  }
  
  public Material findByRootFolderAndUrlName(User creator, String urlName) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
        criteriaBuilder.and(
          criteriaBuilder.isNull(root.get(Material_.parentFolder)),
          criteriaBuilder.equal(root.get(Material_.urlName), urlName),
          criteriaBuilder.equal(root.get(Material_.creator), creator)
        )
    );
    
    return getSingleResult(entityManager.createQuery(criteria));
  }
  
  public List listByParentFolder(Folder parentFolder) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.equal(root.get(Material_.parentFolder), parentFolder)
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }

	public List listByParentFolderAndTypes(Folder parentFolder, Collection types) {
		EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
    	criteriaBuilder.and(
        criteriaBuilder.equal(root.get(Material_.parentFolder), parentFolder),
        root.get(Material_.type).in(types)
      )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }
	
  public List listByRootFolder() {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.isNull(root.get(Material_.parentFolder))
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }
  
  public List listByRootFolderAndCreator(User creator) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.and(
        criteriaBuilder.isNull(root.get(Material_.parentFolder)),
        criteriaBuilder.equal(root.get(Material_.creator), creator)
       )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }
	
  public List listByRootFolderAndTypesAndCreator(Collection types, User creator) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
    	criteriaBuilder.and(
    	  criteriaBuilder.isNull(root.get(Material_.parentFolder)),
        root.get(Material_.type).in(types),
        criteriaBuilder.equal(root.get(Material_.creator), creator)
      )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }

	public List listByRootFolderAndUserAndRoles(User user, Collection roles) {
		EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(UserMaterialRole.class);
    Join materialJoin = root.join(UserMaterialRole_.material);
    
    criteria.select(root.get(UserMaterialRole_.material)).distinct(true);
    criteria.where(
        criteriaBuilder.and(
          criteriaBuilder.isNull(materialJoin.get(Material_.parentFolder)),
          criteriaBuilder.equal(root.get(UserMaterialRole_.user), user),
          root.get(UserMaterialRole_.role).in(roles)
        )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }

	public List listByRootFolderAndUserAndTypesAndRoles(User user, Collection types, Collection roles) {
		EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(UserMaterialRole.class);
    Join materialJoin = root.join(UserMaterialRole_.material);
    
    criteria.select(root.get(UserMaterialRole_.material)).distinct(true);
    criteria.where(
        criteriaBuilder.and(
          criteriaBuilder.isNull(materialJoin.get(Material_.parentFolder)),
          criteriaBuilder.equal(root.get(UserMaterialRole_.user), user),
          materialJoin.get(Material_.type).in(types),
          root.get(UserMaterialRole_.role).in(roles)
        )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }

  public List listByModifierExcludingTypesSortByModified(User modifier, Collection types, int firstResult, int maxResults) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    
    
    criteria.where(
      criteriaBuilder.and(
        criteriaBuilder.equal(root.get(Material_.modifier), modifier),
        criteriaBuilder.not(root.get(Material_.type).in(types))
      )
    );
    
    criteria.orderBy(criteriaBuilder.desc(root.get(Material_.modified)));
    
    TypedQuery query = entityManager.createQuery(criteria);
    query.setFirstResult(firstResult);
    query.setMaxResults(maxResults);
    
    return query.getResultList();
  }
  
  public List listByModifiedAfter(Date modifiedAfter) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Material.class);
    Root root = criteria.from(Material.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.greaterThan(root.get(Material_.modified), modifiedAfter)
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }

  public Long countByCreator(User creator) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Long.class);
    Root root = criteria.from(Material.class);
    criteria.select(criteriaBuilder.count(root));
    criteria.where(
      criteriaBuilder.equal(root.get(Material_.creator), creator)
    );
    
    return entityManager.createQuery(criteria).getSingleResult();
  }
  
  public Material updatePublicity(Material material, MaterialPublicity publicity, User modifier) {
  	material.setPublicity(publicity);
  	material.setModified(new Date());
		material.setModifier(modifier);
		
  	getEntityManager().persist(material);
  	return material;
  }

	public Material updateParentFolder(Material material, Folder parentFolder, User modifier) {
		material.setParentFolder(parentFolder);
		material.setModified(new Date());
		material.setModifier(modifier);
		
  	getEntityManager().persist(material);
  	
  	return material;
  }

  public Material updateUrlName(Material material, String urlName, User modifier) {
    EntityManager entityManager = getEntityManager();

    material.setUrlName(urlName);
    material.setModified(new Date());
    material.setModifier(modifier);
    
    entityManager.persist(material);
    return material;
  }

  
  public Material updateTitle(Material material, String title, User modifier) {
    EntityManager entityManager = getEntityManager();

    material.setTitle(title);
    material.setModified(new Date());
    material.setModifier(modifier);
    
    entityManager.persist(material);
    return material;
  }
}