/*
* (non-Javadoc)
* @see com.csit.dao.CompetitionPhotoDAO#query(com.csit.model.CompetitionPhoto, java.lang.Integer, java.lang.Integer)
*/
@SuppressWarnings("unchecked")
@Override
public List<CompetitionPhoto> query(CompetitionPhoto model, Integer page, Integer rows) {
Criteria criteria = getCurrentSession().createCriteria(CompetitionPhoto.class);
if (model != null
&& model.getCompetition() != null
&& model.getCompetition().getCompetitionId() != null) {
criteria.add(Restrictions.eq("competition", model.getCompetition()));
}
if (StringUtils.isNotEmpty(model.getPhotoType())) {
criteria.add(Restrictions.eq("photoType", model.getPhotoType()));
}
criteria.setFirstResult(PageUtil.getPageBegin(page, rows));
criteria.setMaxResults(rows);
criteria.addOrder(Order.desc("array"));
return criteria.list();
}
/*
* (non-Javadoc)
* @see com.csit.dao.CompetitionPhotoDAO#query(java.lang.Integer, java.lang.String, java.lang.Integer, java.lang.Integer)
*/
@SuppressWarnings("unchecked")
@Override
public List<CompetitionPhoto> query(
Integer competitionId, String photoType, Integer page, Integer rows) {
Criteria criteria = getCurrentSession().createCriteria(CompetitionPhoto.class);
criteria.createAlias("picture", "picture", CriteriaSpecification.LEFT_JOIN);
if (competitionId != null) {
criteria.add(Restrictions.eq("competition.competitionId", competitionId));
}
if (StringUtils.isNotEmpty(photoType)) {
criteria.add(Restrictions.eq("photoType", photoType));
}
criteria.setFirstResult(PageUtil.getPageBegin(page, rows));
criteria.setMaxResults(rows);
criteria.addOrder(Order.asc("array"));
return criteria.list();
}
@SuppressWarnings("unchecked")
@Override
public List<Reply> query(Reply model, Integer page, Integer rows) {
Criteria criteria = getCurrentSession().createCriteria(Reply.class);
criteria.createAlias("potential", "potential", CriteriaSpecification.LEFT_JOIN);
criteria.createAlias(
"potentialStuStatus", "potentialStuStatus", CriteriaSpecification.LEFT_JOIN);
criteria.createAlias("user", "user", CriteriaSpecification.LEFT_JOIN);
if (model != null && model.getPotential().getPotentialId() != null) {
criteria.add(Restrictions.eq("potential.potentialId", model.getPotential().getPotentialId()));
}
if (model != null
&& model.getPotentialStuStatus() != null
&& model.getPotentialStuStatus().getPotentialStuStatusId() != null) {
criteria.add(
Restrictions.eq(
"potentialStuStatus.potentialStuStatusId",
model.getPotentialStuStatus().getPotentialStuStatusId()));
}
if (model != null && model.getReplyDate() != null) {
criteria.add(Restrictions.eq("replyDate", model.getReplyDate()));
}
if (model != null && model.getNextReplyDate() != null) {
criteria.add(Restrictions.eq("nextReplyDate", model.getNextReplyDate()));
}
if (rows == null || rows < 0) {
rows = GobelConstants.DEFAULTPAGESIZE;
}
criteria.setFirstResult(PageUtil.getPageBegin(page, rows));
criteria.setMaxResults(rows);
criteria.addOrder(Order.asc("replyId"));
return criteria.list();
}
