From 086adfdf1d5340a3503da5b5ebcae9073775450e Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期一, 30 十二月 2024 13:59:40 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v4' into master-v4 --- src/main/java/com/mzl/flower/mapper/SmsTemplateMapper.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/SmsTemplateMapper.java b/src/main/java/com/mzl/flower/mapper/SmsTemplateMapper.java index e1ad8cb..4232475 100644 --- a/src/main/java/com/mzl/flower/mapper/SmsTemplateMapper.java +++ b/src/main/java/com/mzl/flower/mapper/SmsTemplateMapper.java @@ -2,9 +2,11 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.mzl.flower.dto.request.sms.SmsTemplateQueryDTO; +import com.mzl.flower.dto.response.sms.SmsTemplateListVO; import com.mzl.flower.entity.SmsTemplateDO; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; import java.util.List; @@ -20,4 +22,11 @@ List<SmsTemplateDO> queryPage(@Param("dto") SmsTemplateQueryDTO dto, Page page); + + @Select("select id,name from t_sms_template where deleted = '0'") + List<SmsTemplateListVO> getAllTemplateName(); + + + @Select("select * from t_sms_template where deleted = '0' and name = #{name} limit 1") + SmsTemplateDO selectTemplateByName(String name); } -- Gitblit v1.9.3