com.mg.common.metadata.dao.MTemplateDaoCustomImpl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of mg-common Show documentation

There is a newer version: 1.0.5

package com.mg.common.metadata.dao;

import com.mg.framework.entity.metadata.MObjectEntity;
import com.mg.framework.entity.metadata.MTemplateEntity;
import com.mg.framework.entity.metadata.MTemplateTypeEnum;
import com.mg.framework.entity.metadata.QMTemplateEntity;
import com.mysema.query.jpa.impl.JPAQuery;
import org.springframework.stereotype.Component;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import java.util.List;

/**
 * Created by liukefu on 2015/9/29.
 */
@Component
public class MTemplateDaoCustomImpl implements MTemplateDaoCustom {

    @PersistenceContext
    private EntityManager entityManager;

    public List findCustomTemplates(MObjectEntity belongMObject,
                                                     MTemplateTypeEnum templateType, Boolean isSystem) {
        QMTemplateEntity obj = QMTemplateEntity.mTemplateEntity;

        JPAQuery query = new JPAQuery(entityManager);
        List templateList = query.from(obj)
                .where(obj.isSystem.eq(isSystem)
                                .and(obj.belongMObject.eq(belongMObject))
                                .and(obj.templateType.eq(templateType))
                )
                .orderBy(obj.isSystem.desc())
                .orderBy(obj.templateType.asc())
                .orderBy(obj.sort.asc())
                .list(obj);

        return templateList;
    }

    public List findTemplateAll(MObjectEntity belongMObject) {
        QMTemplateEntity obj = QMTemplateEntity.mTemplateEntity;

        JPAQuery query = new JPAQuery(entityManager);
        List templateList = query.from(obj)
                .where(obj.belongMObject.eq(belongMObject)
                )
                .orderBy(obj.isSystem.desc())
                .orderBy(obj.templateType.asc())
                .orderBy(obj.sort.asc())
                .list(obj);

        return templateList;
    }
}