From b9903ead016b8b1aa68eb04b48fca3b53fdab0d3 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 30 十二月 2024 10:42:43 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master-v4' 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