From da981624e169b181b170e5d92986e190b9ff8052 Mon Sep 17 00:00:00 2001
From: songhuangfeng123 <shf18767906695@163.com>
Date: 星期一, 22 八月 2022 10:33:24 +0800
Subject: [PATCH] 目标fix
---
goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/repository/TargetMngRepository.java | 4 ++--
1 files changed, 2 insertions(+), 2 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 45d375e..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
@@ -23,12 +23,12 @@
"</script> ")
Integer selectTotal(Map<String, Object> beanToMap);
- @Select("<script>select COUNT(target_id) from target_divide_detail a INNER JOIN target_mng b on a.target_id = b.id \n" +
+ @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</script> ")
+ "GROUP BY a.target_id) x</script> ")
Integer selectNoComplete(Map<String, Object> beanToMap);
}
\ No newline at end of file
--
Gitblit v1.9.2