com.inkubator.hrm.dao.impl.RecruitmenSelectionSeriesDetailDaoImpl.java Source code

Introduction

Here is the source code for com.inkubator.hrm.dao.impl.RecruitmenSelectionSeriesDetailDaoImpl.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.inkubator.hrm.dao.impl;

import com.inkubator.datacore.dao.impl.IDAOImpl;
import com.inkubator.hrm.HRMConstant;
import com.inkubator.hrm.dao.RecruitmenSelectionSeriesDetailDao;
import com.inkubator.hrm.entity.PaySalaryGrade;
import com.inkubator.hrm.entity.RecruitmenSelectionSeriesDetail;
import com.inkubator.hrm.entity.RecruitmenSelectionSeriesDetailId;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.FetchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.sql.JoinType;
import org.springframework.context.annotation.Lazy;
import org.springframework.stereotype.Repository;

/**
 *
 * @author Deni
 */
@Repository(value = "recruitmenSelectionSeriesDetailDao")
@Lazy
public class RecruitmenSelectionSeriesDetailDaoImpl extends IDAOImpl<RecruitmenSelectionSeriesDetail>
        implements RecruitmenSelectionSeriesDetailDao {

    @Override
    public Class<RecruitmenSelectionSeriesDetail> getEntityClass() {
        return RecruitmenSelectionSeriesDetail.class;
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getByParam(int firstResult, int maxResults, Order order) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.addOrder(order);
        criteria.setFirstResult(firstResult);
        criteria.setMaxResults(maxResults);
        return criteria.list();
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getAllDataBySelectionSeriesId(Long id, int firstResult,
            int maxResults, Order order) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", id));
        criteria.setFetchMode("recruitmenSelectionSeries", FetchMode.JOIN);
        criteria.setFetchMode("recruitSelectionType", FetchMode.JOIN);
        criteria.setFetchMode("recruitLettersByAcceptLetterId", FetchMode.JOIN);
        criteria.setFetchMode("recruitLettersByRejectLetterId", FetchMode.JOIN);
        criteria.addOrder(order);
        criteria.setFirstResult(firstResult);
        criteria.setMaxResults(maxResults);
        return criteria.list();
    }

    @Override
    public Integer getLastIndexBySelectionSeriesId(Long id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", id));
        criteria.setProjection(Projections.max("listOrder"));
        return (Integer) criteria.uniqueResult();
    }

    @Override
    public Long getTotalBySelectionSeriesId(Long id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", id));
        return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
    }

    @Override
    public RecruitmenSelectionSeriesDetail getByListOrderAndRecSelectionSeriesId(Integer number, Long id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.createAlias("recruitmenSelectionSeries", "recruitmenSelectionSeries", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("listOrder", number));
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", id));
        return (RecruitmenSelectionSeriesDetail) criteria.uniqueResult();
    }

    @Override
    public RecruitmenSelectionSeriesDetail getEntityByPk(RecruitmenSelectionSeriesDetailId id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.add(Restrictions.eq("id", id));
        criteria.setFetchMode("recruitSelectionType", FetchMode.JOIN);
        return (RecruitmenSelectionSeriesDetail) criteria.uniqueResult();
    }

    @Override
    public Long getTotalByPk(RecruitmenSelectionSeriesDetailId id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.add(Restrictions.eq("id", id));
        return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getListBySelectionSeriesId(Long id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.createAlias("recruitmenSelectionSeries", "recruitmenSelectionSeries", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", id));
        criteria.setFetchMode("recruitSelectionType", FetchMode.JOIN);
        return criteria.list();
    }

    @Override
    public RecruitmenSelectionSeriesDetail getEntityByRecruitSelectionTypeAndRecruitmenSelectionSeries(
            Long recruitSelectionType, Long recruitSelectionSeries) {

        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.createAlias("recruitSelectionType", "recruitSelectionType", JoinType.INNER_JOIN);
        criteria.createAlias("recruitmenSelectionSeries", "recruitmenSelectionSeries", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("recruitSelectionType.id", recruitSelectionType));
        criteria.add(Restrictions.eq("recruitmenSelectionSeries.id", recruitSelectionSeries));
        return (RecruitmenSelectionSeriesDetail) criteria.uniqueResult();
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getAllByRecruitRecruitSelectionTypeId(long id) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        criteria.createAlias("recruitSelectionType", "rs", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("rs.id", id));
        return criteria.list();
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getEntityBySelectionSeriesId(Long id) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public void saveAndMerge(RecruitmenSelectionSeriesDetail detail) {
        getCurrentSession().update(detail);
        getCurrentSession().flush();
    }

    @Override
    public List<RecruitmenSelectionSeriesDetail> getAllWithLetterSpesific(Integer letterType) {
        Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
        if (letterType.equals(HRMConstant.LETTER_TYPE_OFFERING)) {
            criteria.createAlias("recruitLettersByAcceptLetterId", "ra");
            criteria.add(Restrictions.eq("ra.leterTypeId", letterType));
        }
        if (letterType.equals(HRMConstant.LETTER_TYPE_REJECT)) {
            criteria.createAlias("recruitLettersByRejectLetterId", "rj");
            criteria.add(Restrictions.eq("rj.leterTypeId", letterType));
        }

        return criteria.list();
    }

}