From 539c3737214ced4eecb23f874670e365253d4439 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期一, 14 十一月 2022 16:07:07 +0800
Subject: [PATCH] 消息管理bug

---
 ycl-platform/src/main/resources/application-dev.yml                             |    2 
 ycl-platform/src/main/java/com/ycl/mapper/message/MessageMapper.java            |    3 +
 ycl-platform/src/main/java/com/ycl/service/message/IMessageService.java         |    3 +
 ycl-platform/src/main/resources/mapper/message/MessageMapper.xml                |   47 +++++++++++++++++++++++
 ycl-platform/src/main/java/com/ycl/controller/message/MessageController.java    |    6 +-
 ycl-platform/src/main/java/com/ycl/service/message/impl/MessageServiceImpl.java |    3 +
 6 files changed, 57 insertions(+), 7 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/controller/message/MessageController.java b/ycl-platform/src/main/java/com/ycl/controller/message/MessageController.java
index 5518ca2..7c4f590 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/message/MessageController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/message/MessageController.java
@@ -7,9 +7,9 @@
 import com.ycl.dto.message.MessageParam;
 import com.ycl.entity.message.Message;
 import com.ycl.service.message.IMessageService;
+import com.ycl.vo.message.MessageVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
-import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.security.core.context.SecurityContextHolder;
 import org.springframework.validation.annotation.Validated;
@@ -20,7 +20,7 @@
 
 /**
  * <p>
- *   娑堟伅绠$悊  鍓嶇鎺у埗鍣�
+ * 娑堟伅绠$悊  鍓嶇鎺у埗鍣�
  * </p>
  *
  * @author mg
@@ -58,7 +58,7 @@
     @ApiOperation(value = "鑾峰彇娑堟伅鍒嗛〉鏌ヨ")
     @RequestMapping(value = "/list", method = RequestMethod.GET)
     @ResponseBody
-    public CommonResult<IPage<Message>> list(MessageParam messageParam) {
+    public CommonResult<IPage<MessageVO>> list(MessageParam messageParam) {
         return CommonResult.success(iMessageService.list(messageParam));
     }
 
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/message/MessageMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/message/MessageMapper.java
index 5a3e663..181a7e3 100644
--- a/ycl-platform/src/main/java/com/ycl/mapper/message/MessageMapper.java
+++ b/ycl-platform/src/main/java/com/ycl/mapper/message/MessageMapper.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ycl.dto.message.MessageParam;
 import com.ycl.entity.message.Message;
+import com.ycl.vo.message.MessageVO;
 
 /**
  * <p>
@@ -14,5 +15,5 @@
  * @since 2022-10-08
  */
 public interface MessageMapper extends BaseMapper<Message> {
-    Page<Message> selectMessagePage(Page<Message> page, MessageParam messageParam);
+    Page<MessageVO> selectMessagePage(Page<Message> page, MessageParam messageParam);
 }
diff --git a/ycl-platform/src/main/java/com/ycl/service/message/IMessageService.java b/ycl-platform/src/main/java/com/ycl/service/message/IMessageService.java
index b9c9bda..571a72e 100644
--- a/ycl-platform/src/main/java/com/ycl/service/message/IMessageService.java
+++ b/ycl-platform/src/main/java/com/ycl/service/message/IMessageService.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.ycl.dto.message.MessageParam;
 import com.ycl.entity.message.Message;
+import com.ycl.vo.message.MessageVO;
 
 import java.util.List;
 
@@ -19,7 +20,7 @@
 
     String sendMessage(Message message);
 
-    Page<Message> list(MessageParam messageParam);
+    Page<MessageVO> list(MessageParam messageParam);
 
     Boolean deleteMessages(List<Long> ids);
 }
diff --git a/ycl-platform/src/main/java/com/ycl/service/message/impl/MessageServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/message/impl/MessageServiceImpl.java
index 8c09bae..a0e5d92 100644
--- a/ycl-platform/src/main/java/com/ycl/service/message/impl/MessageServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/message/impl/MessageServiceImpl.java
@@ -19,6 +19,7 @@
 import com.ycl.mapper.user.UmsAdminMapper;
 import com.ycl.service.message.IMessageService;
 import com.ycl.utils.MD5Util;
+import com.ycl.vo.message.MessageVO;
 import lombok.SneakyThrows;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.BeanUtils;
@@ -195,7 +196,7 @@
     }
 
     @Override
-    public Page<Message> list(MessageParam messageParam) {
+    public Page<MessageVO> list(MessageParam messageParam) {
         Page<Message> page = new Page<>(messageParam.getCurrent(), messageParam.getPageSize());
         return messageMapper.selectMessagePage(page,messageParam);
     }
diff --git a/ycl-platform/src/main/resources/application-dev.yml b/ycl-platform/src/main/resources/application-dev.yml
index 5b4153a..d6b0744 100644
--- a/ycl-platform/src/main/resources/application-dev.yml
+++ b/ycl-platform/src/main/resources/application-dev.yml
@@ -62,5 +62,5 @@
   ecName: ycl
   apId: 1
   sign: sign
-  url: http://localhost:8082/sccg/text/sms_res/fail
+  url: http://localhost:8082/sccg/text/sms_res
 
diff --git a/ycl-platform/src/main/resources/mapper/message/MessageMapper.xml b/ycl-platform/src/main/resources/mapper/message/MessageMapper.xml
index f7827ce..c0962e3 100644
--- a/ycl-platform/src/main/resources/mapper/message/MessageMapper.xml
+++ b/ycl-platform/src/main/resources/mapper/message/MessageMapper.xml
@@ -33,4 +33,51 @@
         id, parent_id, head, channel_code, message_type, body, target_from, target_to, message_number, random_code, over_time, send_time, is_scan, status, is_view, remark, version, create_user, create_time, update_user, update_time, respond_result
     </sql>
 
+    <select id="selectMessagePage" parameterType="com.ycl.dto.message.MessageParam"
+            resultType="com.ycl.vo.message.MessageVO">
+        SELECT
+        t1.id,
+        t2.username as targetFrom,
+        t3.column_name as messageTypeName,
+        t1.`status`,
+        t1.body,
+        t1.send_time,
+        t1.create_time,
+        t1.respond_result,
+        t1.head,
+        t4.username as createUser
+        FROM
+        `ums_message` t1
+        LEFT JOIN ums_admin t2 ON t1.target_from = t2.id
+        left join ums_admin t4 on t1.create_user = t4.id
+        LEFT JOIN ums_message_column t3 ON t3.id = t1.message_type
+        <where>
+            <if test="messageParam.head !=null and messageParam.head !=''">
+                t1.head like concat('%',#{messageParam.head},'%')
+            </if>
+            <if test="messageParam.channelCode !='' and messageParam.channelCode != null">
+                and t1.channel_code=#{messageParam.channelCode}
+            </if>
+            <if test="messageParam.messageType != null">
+                and t1.message_type=#{messageParam.messageType}
+            </if>
+            <if test="messageParam.startTime != null and messageParam.startTime != '' and messageParam.endTime != null and messageParam.endTime != '' ">
+                and t1.create_time between #{messageParam.startTime} and #{messageParam.endTime}
+            </if>
+
+            <if test="messageParam.status != null">
+                and t1.status=#{messageParam.status}
+            </if>
+            <if test="messageParam.respondResult !=null and messageParam.respondResult !='' ">
+                and t1.respond_result={messageParam.respondResult}
+            </if>
+            <if test="messageParam.sort==1">
+                ORDER BY t1.create_time desc
+            </if>
+            <if test="messageParam.sort==0">
+                ORDER BY t1.create_time asc
+            </if>
+        </where>
+    </select>
+
 </mapper>

--
Gitblit v1.8.0