From 923fa13e40ca7c38bb9560c0d0c37f2787b0b548 Mon Sep 17 00:00:00 2001
From: rx <auster_i@163.com>
Date: 星期三, 13 十二月 2023 19:13:20 +0800
Subject: [PATCH] 审批备注修改

---
 phi_platform_user/src/main/java/com/hx/phip/controller/market/MarketActivityController.java |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/phi_platform_user/src/main/java/com/hx/phip/controller/market/MarketActivityController.java b/phi_platform_user/src/main/java/com/hx/phip/controller/market/MarketActivityController.java
index 9c9345a..91e393f 100644
--- a/phi_platform_user/src/main/java/com/hx/phip/controller/market/MarketActivityController.java
+++ b/phi_platform_user/src/main/java/com/hx/phip/controller/market/MarketActivityController.java
@@ -753,7 +753,7 @@
                 .append(" , date_format( c.issueStartTime, '%Y-%m-%d %H:%i:%s') as issueStartTime ")
                 .append(" , date_format( c.issueEndTime, '%Y-%m-%d %H:%i:%s') as issueEndTime ")
                 .append(" , CASE c.type WHEN 0 THEN c.discountNum ELSE c.discountAmount END AS couponPrice")
-                .append(" , rr.opName,rr.userName,rr.CIQ ")
+                .append(" , rr.opName,rr.userName,rr.CIQ,ri.approveRemark as remark ")
                 .append(" FROM market_activity ma")
                 .append(" LEFT JOIN market_activity_item mai ON ma.id = mai.marketActivityId")
                 .append(" LEFT JOIN coupon c ON mai.commonId = c.id AND mai.commonType = #{m.commonType} ")
@@ -768,7 +768,7 @@
             sql.append(" AND ri.approveStatus in (0,1,2,3)");
         }
 
-        sql.append(" ORDER BY c.createTime DESC ");
+        sql.append(" ORDER BY ri.createTime DESC ");
         sqlSentence.setSqlSentence(sql.toString());
 
         PageHelper.startPage(dto.getPageNum() == null ? 1 : dto.getPageNum(), dto.getPageSize() == null ? 10 : dto.getPageSize());

--
Gitblit v1.8.0