package jnpf.elnMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import jnpf.elnEntity.template.ElnTemplateVersionEntity;
|
import jnpf.elnEntity.template.ElnTemplateVos;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
public interface ElnTemplateMapper extends BaseMapper<ElnTemplateVersionEntity> {
|
|
default ElnTemplateVersionEntity lockTemplateForUpdate(String tenantId, String templateId) {
|
return selectOne(Wrappers.<ElnTemplateVersionEntity>lambdaQuery()
|
.eq(ElnTemplateVersionEntity::getFTenantId, tenantId)
|
.eq(ElnTemplateVersionEntity::getId, templateId)
|
.and(query -> query.isNull(ElnTemplateVersionEntity::getFDeleteMark)
|
.or().eq(ElnTemplateVersionEntity::getFDeleteMark, 0))
|
.last("FOR UPDATE"));
|
}
|
|
@Select("SELECT m.muban_file "
|
+ "FROM eln_template_current_version c "
|
+ "JOIN eln_template m "
|
+ "ON m.f_tenant_id = c.f_tenant_id AND m.f_id = c.dangqian_muban_id "
|
+ "WHERE c.f_tenant_id = #{tenantId} "
|
+ "AND m.jianyan_xiangmu = #{jianyanXiangmu} "
|
+ "AND m.biz_status = 'PUBLISHED' "
|
+ "AND m.biz_enabled = 'enabled' "
|
+ "AND m.shengxiao_riqi <= CURRENT_TIMESTAMP "
|
+ "AND COALESCE(m.f_delete_mark, 0) = 0")
|
IPage<String> selectLatestTemplateFiles(IPage<String> page,
|
@Param("tenantId") String tenantId,
|
@Param("jianyanXiangmu") String jianyanXiangmu);
|
|
@Select("SELECT m.muban_file "
|
+ "FROM eln_template_current_version c "
|
+ "JOIN eln_template m "
|
+ "ON m.f_tenant_id = c.f_tenant_id AND m.f_id = c.dangqian_muban_id "
|
+ "WHERE c.f_tenant_id = #{tenantId} "
|
+ "AND m.jianyan_xiangmu_bianma = #{testDefinitionCode} "
|
+ "AND m.biz_status = 'PUBLISHED' "
|
+ "AND m.biz_enabled = 'enabled' "
|
+ "AND m.shengxiao_riqi <= CURRENT_TIMESTAMP "
|
+ "AND COALESCE(c.f_delete_mark, 0) = 0 "
|
+ "AND COALESCE(m.f_delete_mark, 0) = 0")
|
IPage<String> selectLatestTemplateFilesByTestDefinitionCode(
|
IPage<String> page,
|
@Param("tenantId") String tenantId,
|
@Param("testDefinitionCode") String testDefinitionCode);
|
|
@Select("SELECT m.f_id AS id, m.f_tenant_id AS fTenantId, "
|
+ "m.muban_bianhao AS mubanBianhao, m.muban_banben AS mubanBanben, "
|
+ "m.jianyan_xiangmu AS jianyanXiangmu, "
|
+ "m.jianyan_xiangmu_bianma AS jianyanXiangmuBianma, m.muban_file AS mubanFile, "
|
+ "m.biz_status AS bizStatus, m.biz_enabled AS bizEnabled, "
|
+ "m.shengxiao_riqi AS shengxiaoRiqi, m.f_delete_mark AS fDeleteMark "
|
+ "FROM eln_template_current_version c "
|
+ "JOIN eln_template m "
|
+ "ON m.f_tenant_id = c.f_tenant_id AND m.f_id = c.dangqian_muban_id "
|
+ "WHERE c.f_tenant_id = #{tenantId} "
|
+ "AND m.jianyan_xiangmu_bianma = #{testDefinitionCode} "
|
+ "AND m.biz_status = 'PUBLISHED' "
|
+ "AND m.biz_enabled = 'enabled' "
|
+ "AND m.shengxiao_riqi <= CURRENT_TIMESTAMP "
|
+ "AND COALESCE(c.f_delete_mark, 0) = 0 "
|
+ "AND COALESCE(m.f_delete_mark, 0) = 0")
|
List<ElnTemplateVersionEntity> selectCurrentPublishedByTestDefinition(
|
@Param("tenantId") String tenantId,
|
@Param("testDefinitionCode") String testDefinitionCode);
|
|
@Select({"<script>",
|
"SELECT m.muban_bianhao ",
|
"FROM eln_template m ",
|
"WHERE m.f_tenant_id = #{tenantId} ",
|
"AND COALESCE(m.f_delete_mark, 0) = 0 ",
|
"<if test='mubanFenlei != null'>",
|
"AND m.muban_fenlei = #{mubanFenlei} ",
|
"</if>",
|
"<if test='mubanBianhao != null'>",
|
"AND m.muban_bianhao = #{mubanBianhao} ",
|
"</if>",
|
"<if test='bizStatus != null'>",
|
"AND m.biz_status = #{bizStatus} ",
|
"</if>",
|
"<if test='bizEnabled != null'>",
|
"AND m.biz_enabled = #{bizEnabled} ",
|
"</if>",
|
"<if test='keywordPattern != null'>",
|
"AND (m.muban_bianhao LIKE #{keywordPattern} ",
|
"OR m.muban_banben LIKE #{keywordPattern} ",
|
"OR m.jianyan_xiangmu LIKE #{keywordPattern} ",
|
"OR m.jianyan_xiangmu_mingcheng LIKE #{keywordPattern}) ",
|
"</if>",
|
"GROUP BY m.muban_bianhao ",
|
"ORDER BY CASE WHEN MAX(COALESCE(m.chuangjian_shijian, m.f_creator_time)) ",
|
"IS NULL THEN 1 ELSE 0 END ASC, ",
|
"MAX(COALESCE(m.chuangjian_shijian, m.f_creator_time)) DESC, ",
|
"MAX(m.f_id) DESC",
|
"</script>"})
|
IPage<String> selectLatestTemplateCodes(
|
IPage<String> page,
|
@Param("tenantId") String tenantId,
|
@Param("mubanFenlei") String mubanFenlei,
|
@Param("mubanBianhao") String mubanBianhao,
|
@Param("bizStatus") String bizStatus,
|
@Param("bizEnabled") String bizEnabled,
|
@Param("keywordPattern") String keywordPattern);
|
|
@Select({"<script>",
|
"SELECT m.muban_bianhao AS mubanBianhao, ",
|
"COALESCE(e.jianyan_xiangmu, MAX(m.jianyan_xiangmu)) AS jianyanXiangmu, ",
|
"COALESCE(e.jianyan_xiangmu_bianma, MAX(m.jianyan_xiangmu_bianma)) AS jianyanXiangmuBianma, ",
|
"COALESCE(e.jianyan_xiangmu_mingcheng, MAX(m.jianyan_xiangmu_mingcheng)) AS jianyanXiangmuMingcheng, ",
|
"COALESCE(e.muban_fenlei, MAX(m.muban_fenlei)) AS mubanFenlei, ",
|
"COALESCE(e.muban_fenlei_mingcheng, MAX(m.muban_fenlei_mingcheng)) AS mubanFenleiMingcheng, ",
|
"e.f_id AS shengxiaoMubanId, ",
|
"e.muban_banben AS shengxiaoMubanBanben, ",
|
"e.biz_status AS bizStatus, e.biz_enabled AS bizEnabled, ",
|
"e.shengxiao_riqi AS shengxiaoRiqi, ",
|
"MAX(COALESCE(m.f_last_modify_time, m.f_creator_time)) AS gengxinShijian, ",
|
"MIN(COALESCE(m.chuangjian_shijian, m.f_creator_time)) AS chuangjianShijian ",
|
"FROM eln_template m ",
|
"LEFT JOIN eln_template_current_version c ON ",
|
"c.f_tenant_id = m.f_tenant_id ",
|
"AND c.muban_bianhao = m.muban_bianhao ",
|
"AND COALESCE(c.f_delete_mark, 0) = 0 ",
|
"LEFT JOIN eln_template e ON ",
|
"e.f_tenant_id = m.f_tenant_id ",
|
"AND e.f_id = c.dangqian_muban_id ",
|
"AND e.muban_bianhao = m.muban_bianhao ",
|
"AND COALESCE(e.f_delete_mark, 0) = 0 ",
|
"WHERE m.f_tenant_id = #{tenantId} ",
|
"AND COALESCE(m.f_delete_mark, 0) = 0 ",
|
"<if test='mubanFenlei != null'>",
|
"AND m.muban_fenlei = #{mubanFenlei} ",
|
"</if>",
|
"<if test='mubanBianhao != null'>",
|
"AND m.muban_bianhao = #{mubanBianhao} ",
|
"</if>",
|
"<if test='bizStatus != null'>",
|
"AND e.biz_status = #{bizStatus} ",
|
"</if>",
|
"<if test='bizEnabled != null'>",
|
"AND e.biz_enabled = #{bizEnabled} ",
|
"</if>",
|
"<if test='keywordPattern != null'>",
|
"AND (m.muban_bianhao LIKE #{keywordPattern} ",
|
"OR m.jianyan_xiangmu LIKE #{keywordPattern} ",
|
"OR m.jianyan_xiangmu_mingcheng LIKE #{keywordPattern} ",
|
"OR m.muban_fenlei_mingcheng LIKE #{keywordPattern}) ",
|
"</if>",
|
"GROUP BY m.muban_bianhao, e.f_id, e.muban_banben, ",
|
"e.jianyan_xiangmu, e.jianyan_xiangmu_bianma, e.jianyan_xiangmu_mingcheng, ",
|
"e.muban_fenlei, e.muban_fenlei_mingcheng, ",
|
"e.biz_status, e.biz_enabled, e.shengxiao_riqi ",
|
"ORDER BY MIN(COALESCE(m.chuangjian_shijian, m.f_creator_time)) DESC, ",
|
"m.muban_bianhao ASC",
|
"</script>"})
|
IPage<ElnTemplateVos.CatalogItem> selectTemplateDirectory(
|
IPage<ElnTemplateVos.CatalogItem> page,
|
@Param("tenantId") String tenantId,
|
@Param("mubanFenlei") String mubanFenlei,
|
@Param("mubanBianhao") String mubanBianhao,
|
@Param("bizStatus") String bizStatus,
|
@Param("bizEnabled") String bizEnabled,
|
@Param("keywordPattern") String keywordPattern);
|
|
@Select({"<script>",
|
"SELECT f_id AS id, fenlei_mingcheng AS name ",
|
"FROM eln_template_category ",
|
"WHERE f_tenant_id = #{tenantId} ",
|
"AND COALESCE(f_delete_mark, 0) = 0 ",
|
"AND f_id IN ",
|
"<foreach collection='templateCategoryIds' item='id' open='(' separator=',' close=')'>",
|
"#{id}",
|
"</foreach>",
|
"</script>"})
|
List<ElnTemplateVos.TemplateCategory> selectTemplateCategories(
|
@Param("tenantId") String tenantId,
|
@Param("templateCategoryIds") List<String> templateCategoryIds);
|
}
|
