From eeb3b46afe7da500bce62daad35ded0886df3b88 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期四, 09 一月 2025 18:31:12 +0800
Subject: [PATCH] Merge branch 'master-v4' of http://47.96.225.205:8888/r/flowerbackend-v2 into master-v4
---
src/main/java/com/mzl/flower/mapper/SmsTaskDetailMapper.java | 14 ++++----------
1 files changed, 4 insertions(+), 10 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/SmsTaskDetailMapper.java b/src/main/java/com/mzl/flower/mapper/SmsTaskDetailMapper.java
index 0342bbe..77d9166 100644
--- a/src/main/java/com/mzl/flower/mapper/SmsTaskDetailMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/SmsTaskDetailMapper.java
@@ -25,14 +25,8 @@
List<SmsPhoneResultVO> queryPage(@Param("dto") SmsTaskDetailQueryDTO dto, Page page);
- @Select("SELECT\n" +
- "\tt.id,\n" +
- "\tt.NAME AS smsTaskName ,\n" +
- "\tt.num as totalNum,\n" +
- "\tst.`name` as smsTemplateName\n" +
- "FROM\n" +
- "\tt_sms_task t\n" +
- "\tLEFT JOIN t_sms_template st ON t.sms_template_id = st.id\n" +
- "\tleft join t_sms_task_detail std ON t.id = std.sms_task_id")
- SmsTaskDetailVO getCountBySmsTaskId(Long id);
+ SmsTaskDetailVO getCountBySmsTaskId(@Param("id") Long id);
+
+ @Select("select count(1) from t_sms_task_detail where sms_task_id =#{id} and deleted = '0'")
+ Integer getBySmsTaskId(@Param("id")Long id);
}
--
Gitblit v1.9.3