From f1125e6aef88ac7dd23fb38a226a66390d33de08 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期一, 25 八月 2025 19:32:19 +0800
Subject: [PATCH] 短信模板管理,资质上下架

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysQualificationsController.java     |   14 +++
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysMessageTemplateServiceImpl.java |   26 ++++++
 ruoyi-system/src/main/resources/mapper/system/TSysMessageTemplateMapper.xml                  |   12 +++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysMessageTemplateController.java    |   97 +++++++++++++++++++++++
 ruoyi-system/src/main/java/com/ruoyi/system/query/TSysMessageTemplateQuery.java              |   15 +++
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysMessageTemplateMapper.java            |   13 +++
 ruoyi-system/src/main/java/com/ruoyi/system/service/TSysMessageTemplateService.java          |   16 ++++
 7 files changed, 191 insertions(+), 2 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysMessageTemplateController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysMessageTemplateController.java
index 7c6855f..1f3b7cc 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysMessageTemplateController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysMessageTemplateController.java
@@ -1,8 +1,21 @@
 package com.ruoyi.web.controller.api;
 
 
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.ruoyi.common.annotation.Log;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.system.model.TSysMessageTemplate;
+import com.ruoyi.system.query.TSysMessageTemplateQuery;
+import com.ruoyi.system.service.TSysMessageTemplateService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
 
 /**
  * <p>
@@ -12,9 +25,89 @@
  * @author xiaochen
  * @since 2025-08-20
  */
+@Api(tags = "短信模板管理")
 @RestController
 @RequestMapping("/t-sys-message-template")
 public class TSysMessageTemplateController {
 
+    private final TSysMessageTemplateService sysMessageTemplateService;
+    @Autowired
+    public TSysMessageTemplateController(TSysMessageTemplateService sysMessageTemplateService) {
+        this.sysMessageTemplateService = sysMessageTemplateService;
+    }
+
+    /**
+     * 获取短信模板管理管理列表
+     */
+    @ApiOperation(value = "获取短信模板管理分页列表")
+    @PostMapping(value = "/pageList")
+    public R<PageInfo<TSysMessageTemplate>> pageList(@RequestBody TSysMessageTemplateQuery query) {
+        return R.ok(sysMessageTemplateService.pageList(query));
+    }
+
+    /**
+     * 获取短信模板管理管理列表
+     */
+    @ApiOperation(value = "获取短信模板管理列表")
+    @PostMapping(value = "/list")
+    public R<List<TSysMessageTemplate>> list() {
+        return R.ok(sysMessageTemplateService.list(Wrappers.lambdaQuery(TSysMessageTemplate.class).orderByDesc(TSysMessageTemplate::getCreateTime)));
+    }
+
+    /**
+     * 添加短信模板管理管理
+     */
+    @Log(title = "短信模板管理信息-新增短信模板管理", businessType = BusinessType.INSERT)
+    @ApiOperation(value = "添加短信模板管理")
+    @PostMapping(value = "/add")
+    public R<Boolean> add(@Validated @RequestBody TSysMessageTemplate dto) {
+        if (sysMessageTemplateService.isExit(dto)) {
+            return R.fail("短信模板管理名称已存在");
+        }
+        return R.ok(sysMessageTemplateService.save(dto));
+    }
+
+    /**
+     * 修改短信模板管理
+     */
+    @Log(title = "短信模板管理信息-修改短信模板管理", businessType = BusinessType.UPDATE)
+    @ApiOperation(value = "修改短信模板管理")
+    @PostMapping(value = "/update")
+    public R<Boolean> update(@Validated @RequestBody TSysMessageTemplate dto) {
+        if (sysMessageTemplateService.isExit(dto)) {
+            return R.fail("短信模板管理名称已存在");
+        }
+        return R.ok(sysMessageTemplateService.updateById(dto));
+    }
+
+    /**
+     * 查看短信模板管理详情
+     */
+    @ApiOperation(value = "查看短信模板管理详情")
+    @GetMapping(value = "/getDetailById")
+    public R<TSysMessageTemplate> getDetailById(@RequestParam String id) {
+        return R.ok(sysMessageTemplateService.getById(id));
+    }
+
+    /**
+     * 删除短信模板管理
+     */
+    @Log(title = "短信模板管理信息-删除短信模板管理", businessType = BusinessType.DELETE)
+    @ApiOperation(value = "删除短信模板管理")
+    @DeleteMapping(value = "/deleteById")
+    public R<Boolean> deleteById(@RequestParam String id) {
+        return R.ok(sysMessageTemplateService.removeById(id));
+    }
+
+    /**
+     * 批量删除短信模板管理
+     */
+    @Log(title = "短信模板管理信息-删除短信模板管理", businessType = BusinessType.DELETE)
+    @ApiOperation(value = "批量删除短信模板管理")
+    @DeleteMapping(value = "/deleteByIds")
+    public R<Boolean> deleteByIds(@RequestBody List<String> ids) {
+        return R.ok(sysMessageTemplateService.removeByIds(ids));
+    }
+    
 }
 
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysQualificationsController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysQualificationsController.java
index 72cdd55..ef2f6e9 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysQualificationsController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TSysQualificationsController.java
@@ -109,5 +109,19 @@
         return R.ok(sysQualificationsService.removeByIds(ids));
     }
 
+    /**
+     * 批量删除资质管理
+     */
+    @Log(title = "资质管理信息-上下架", businessType = BusinessType.UPDATE)
+    @ApiOperation(value = "批量删除资质管理")
+    @PutMapping(value = "/upAndDown")
+    public R<String> upAndDown(@RequestParam(value = "id") String id,
+                                @RequestParam(value = "status")Integer status) {
+        sysQualificationsService.update(Wrappers.<TSysQualifications>lambdaUpdate()
+                .set(TSysQualifications::getStatus,status)
+                .eq(TSysQualifications::getId,id));
+        return R.ok();
+    }
+
 }
 
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysMessageTemplateMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysMessageTemplateMapper.java
index 6d371bd..0765689 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysMessageTemplateMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysMessageTemplateMapper.java
@@ -1,7 +1,12 @@
 package com.ruoyi.system.mapper;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.model.TSysMessageTemplate;
+import com.ruoyi.system.query.TSysMessageTemplateQuery;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
 
 /**
  * <p>
@@ -13,4 +18,12 @@
  */
 public interface TSysMessageTemplateMapper extends BaseMapper<TSysMessageTemplate> {
 
+    /**
+     * 分页查询
+     * @param query
+     * @param pageInfo
+     * @return
+     */
+    List<TSysMessageTemplate> pageList(@Param("query") TSysMessageTemplateQuery query, @Param("pageInfo")PageInfo<TSysMessageTemplate> pageInfo);
+
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/TSysMessageTemplateQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/TSysMessageTemplateQuery.java
new file mode 100644
index 0000000..0a5d468
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/TSysMessageTemplateQuery.java
@@ -0,0 +1,15 @@
+package com.ruoyi.system.query;
+
+import com.ruoyi.common.core.domain.BasePage;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "短信模板管理查询参数query")
+public class TSysMessageTemplateQuery extends BasePage {
+
+    @ApiModelProperty(value = "模板名称")
+    private String templateName;
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysMessageTemplateService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysMessageTemplateService.java
index cf49895..0f15a18 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysMessageTemplateService.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TSysMessageTemplateService.java
@@ -1,7 +1,9 @@
 package com.ruoyi.system.service;
 
 import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.model.TSysMessageTemplate;
+import com.ruoyi.system.query.TSysMessageTemplateQuery;
 
 /**
  * <p>
@@ -13,4 +15,18 @@
  */
 public interface TSysMessageTemplateService extends IService<TSysMessageTemplate> {
 
+    /**
+     * 判断是否存在
+     * @param dto
+     * @return
+     */
+    boolean isExit(TSysMessageTemplate dto);
+
+    /**
+     * 分页列表
+     * @param query
+     * @return
+     */
+    PageInfo<TSysMessageTemplate> pageList(TSysMessageTemplateQuery query);
+
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysMessageTemplateServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysMessageTemplateServiceImpl.java
index 7e37b9e..e227d61 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysMessageTemplateServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TSysMessageTemplateServiceImpl.java
@@ -1,10 +1,18 @@
 package com.ruoyi.system.service.impl;
 
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.system.model.TSysChronicDisease;
+import com.ruoyi.system.model.TSysMessageTemplate;
 import com.ruoyi.system.model.TSysMessageTemplate;
 import com.ruoyi.system.mapper.TSysMessageTemplateMapper;
+import com.ruoyi.system.query.TSysMessageTemplateQuery;
 import com.ruoyi.system.service.TSysMessageTemplateService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import org.springframework.stereotype.Service;
+
+import java.util.List;
 
 /**
  * <p>
@@ -17,4 +25,22 @@
 @Service
 public class TSysMessageTemplateServiceImpl extends ServiceImpl<TSysMessageTemplateMapper, TSysMessageTemplate> implements TSysMessageTemplateService {
 
+    @Override
+    public boolean isExit(TSysMessageTemplate dto) {
+        if(StringUtils.isNotEmpty(dto.getId())){
+            // 修改
+            return this.count(Wrappers.lambdaQuery(TSysMessageTemplate.class).ne(TSysMessageTemplate::getId, dto.getId()).eq(TSysMessageTemplate::getTemplateName, dto.getTemplateName())) > 0;
+        }else {
+            // 新增
+            return this.count(Wrappers.lambdaQuery(TSysMessageTemplate.class).eq(TSysMessageTemplate::getTemplateName, dto.getTemplateName())) > 0;
+        }
+    }
+
+    @Override
+    public PageInfo<TSysMessageTemplate> pageList(TSysMessageTemplateQuery query) {
+        PageInfo<TSysMessageTemplate> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+        List<TSysMessageTemplate> list = this.baseMapper.pageList(query,pageInfo);
+        pageInfo.setRecords(list);
+        return pageInfo;
+    }
 }
diff --git a/ruoyi-system/src/main/resources/mapper/system/TSysMessageTemplateMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TSysMessageTemplateMapper.xml
index 3ecae7c..a55c7a0 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TSysMessageTemplateMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TSysMessageTemplateMapper.xml
@@ -19,5 +19,17 @@
     <sql id="Base_Column_List">
         id, template_name, template_code, template_content, create_time, update_time, create_by, update_by, disabled
     </sql>
+    <select id="pageList" resultType="com.ruoyi.system.model.TSysMessageTemplate">
+        SELECT
+        <include refid="Base_Column_List"/>
+            FROM t_sys_message_template
+        <where>
+            <if test="query.templateName != null and query.templateName != ''">
+                AND template_name LIKE concat('%',#{query.templateName},'%')
+            </if>
+            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
+        </where>
+        ORDER BY create_time DESC
+    </select>
 
 </mapper>

--
Gitblit v1.7.1