From d015cc0b48ca51a2b93b6c60c91dc352a104b1e7 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期一, 23 九月 2024 10:41:50 +0800 Subject: [PATCH] 删除密码加密 --- goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java index 424f49b..a5204a3 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java @@ -2,7 +2,10 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.gkhy.safePlatform.targetDuty.entity.TargetMng; +import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; + +import java.util.Map; /** * 目标指标(TargetMng)表数据库访问层 @@ -12,5 +15,20 @@ */ @Repository public interface TargetMngRepository extends BaseMapper<TargetMng> { + @Select("<script>select COUNT(1) from target_mng where 1=1 " + + "<if test =\"divideStatus !='' and divideStatus !=null\">and divide_status = #{divideStatus}</if> " + + "<if test =\"targetType !='' and targetType !=null\">and target_type = #{targetType}</if>" + + "<if test =\"qName !='' and qName !=null\">and q_name = #{qName}</if>" + + "<if test =\"indexNum !='' and indexNum !=null\">and index_num = #{indexNum}</if>" + + "</script> ") + Integer selectTotal(Map<String, Object> beanToMap); + @Select("<script>select COUNT(1) from (select a.target_id from target_divide_detail a INNER JOIN target_mng b on a.target_id = b.id \n" + + "WHERE a.id not in (select target_divide_detail_id from target_examine where examine_result = 1)\n" + + "<if test =\"divideStatus !='' and divideStatus !=null\">and b.divide_status = #{divideStatus}</if> " + + "<if test =\"targetType !='' and targetType !=null\">and b.target_type = #{targetType}</if>" + + "<if test =\"qName !='' and qName !=null\">and b.q_name = #{qName}</if>" + + "<if test =\"indexNum !='' and indexNum !=null\">and b.index_num = #{indexNum}</if>" + + "GROUP BY a.target_id) x</script> ") + Integer selectNoComplete(Map<String, Object> beanToMap); } \ No newline at end of file -- Gitblit v1.9.2