MonthChkRepositoryJpa.java

MonthChkRepositoryJpa.java

	@Override
	public List<MonthChkItem> getMonthChkItems(Long year, Person person) {
		CriteriaBuilder builder=entityManager.getCriteriaBuilder();
		CriteriaQuery<MonthChkItem> query=builder.createQuery(MonthChkItem.class);
		Root<MonthChkItem> monthChkItem=query.from(MonthChkItem.class);
		Join<MonthChkItem,MonthChk> monthChk = monthChkItem.join("monthChk",JoinType.LEFT);
		List<Predicate> criteria=new ArrayList<Predicate>();
		if(year!=null){
			criteria.add(builder.equal(monthChk.get("year"), year));
		}
		if(person!=null){
			criteria.add(builder.equal(monthChk.get("person"), person));
		}
		
	
		if(criteria.size()==1){
			query.where(criteria.get(0));
		}else{
			query.where(builder.and(criteria.toArray(new Predicate[0])));
		}
		query.orderBy(
				builder.asc(monthChk.get("year")), 
				builder.asc(monthChk.get("month")),
				builder.asc(monthChkItem.get("sn"))
			);
		return entityManager.createQuery(query).getResultList();
	}