From 4fabfe4dbd2eb28d07a4350597d314958cc1c281 Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期四, 09 十月 2025 11:16:43 +0800
Subject: [PATCH] 优化

---
 server/services/src/main/java/com/doumee/service/business/impl/DiscountMemberServiceImpl.java |   54 +++++++++++++++++++++++++++++++++---------------------
 1 files changed, 33 insertions(+), 21 deletions(-)

diff --git a/server/services/src/main/java/com/doumee/service/business/impl/DiscountMemberServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/DiscountMemberServiceImpl.java
index f22b329..479c726 100644
--- a/server/services/src/main/java/com/doumee/service/business/impl/DiscountMemberServiceImpl.java
+++ b/server/services/src/main/java/com/doumee/service/business/impl/DiscountMemberServiceImpl.java
@@ -11,10 +11,7 @@
 import com.doumee.dao.business.DiscountLogMapper;
 import com.doumee.dao.business.DiscountMemberMapper;
 import com.doumee.dao.business.join.DiscountMemberJoinMapper;
-import com.doumee.dao.business.model.Discount;
-import com.doumee.dao.business.model.DiscountLog;
-import com.doumee.dao.business.model.DiscountMember;
-import com.doumee.dao.business.model.Member;
+import com.doumee.dao.business.model.*;
 import com.doumee.dao.business.web.request.DiscountMemberDTO;
 import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.DiscountMemberService;
@@ -104,18 +101,20 @@
         if(Objects.isNull(discountMember)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY);
         }
-        List<DiscountLog> discountLogList = discountLogMapper.selectJoinList(DiscountLog.class,new MPJLambdaWrapper<DiscountLog>()
-                .selectAll(DiscountLog.class)
-                .selectAs(SystemUser::getRealname,DiscountLog::getCreatorName)
-                .eq(DiscountLog::getDiscountMemberId,discountMember.getId())
-                .eq(DiscountLog::getIsdeleted,Constants.ZERO)
-                .orderByDesc(DiscountLog::getId)
-        );
-        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(discountLogList)){
-            discountMember.setDiscountLogList(discountLogList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()));
-            discountMember.setOptLogList(discountLogList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()));
-            discountMember.setUseTimes(discountMember.getDiscountLogList().size());
-        }
+//        List<DiscountLog> discountLogList = discountLogMapper.selectJoinList(DiscountLog.class,new MPJLambdaWrapper<DiscountLog>()
+//                .selectAll(DiscountLog.class)
+//                .selectAs(SystemUser::getRealname,DiscountLog::getCreatorName)
+//                .leftJoin(SystemUser.class,SystemUser::getId,DiscountLog::getCreator)
+//                .eq(DiscountLog::getDiscountMemberId,discountMember.getId())
+//                .eq(DiscountLog::getIsdeleted,Constants.ZERO)
+//                .orderByDesc(DiscountLog::getId)
+//        );
+//        discountMember.setUseTimes(discountMember.getDiscountLogList().size());
+//        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(discountLogList)){
+//            discountMember.setDiscountLogList(discountLogList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()));
+//            discountMember.setOptLogList(discountLogList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()));
+//
+//        }
         return discountMember;
     }
 
@@ -138,12 +137,17 @@
         Utils.MP.blankToNull(pageWrap.getModel());
         DiscountMember model = pageWrap.getModel();
         queryWrapper.selectAll(DiscountMember.class)
+                .selectAs(Member::getOpenid,DiscountMember::getOpenid)
+                .select(" ( select count(1) from discount_log d where d.discount_member_id = t.id and d.type = 0 ) ",DiscountMember::getUseTimes)
                 .leftJoin(Member.class,Member::getId,DiscountMember::getMemberId)
                 .like(StringUtils.isNotBlank(model.getCode()),DiscountMember::getCode,model.getCode())
                 .like(StringUtils.isNotBlank(model.getName()),DiscountMember::getName,model.getName())
                 .like(StringUtils.isNotBlank(model.getOpenid()),Member::getOpenid,model.getOpenid())
                 .eq(Objects.nonNull(model.getStatus()),DiscountMember::getStatus,model.getStatus())
-                .orderByDesc(DiscountMember::getId);
+                .ge(Objects.nonNull(model.getStartCreateDate()),DiscountMember::getCreateDate, model.getStartCreateDate())
+                .le(Objects.nonNull(model.getEndCreateDate()),DiscountMember::getCreateDate, model.getEndCreateDate())
+                .ne(DiscountMember::getStatus,Constants.TWO)
+                .orderByDesc(DiscountMember::getCode);
         return PageData.from(discountMemberJoinMapper.selectJoinPage(page, DiscountMember.class,queryWrapper));
     }
 
@@ -164,9 +168,12 @@
                 .orderByDesc(DiscountMember::getId);
         List<DiscountMember> list = discountMemberJoinMapper.selectJoinList(DiscountMember.class,queryWrapper);
         if(CollectionUtils.isEmpty(list)){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏈煡璇㈠埌鍙姤搴熺殑濂楅鍗′俊鎭�");
+            return;
         }
         for (DiscountMember discountMember:list) {
+            if(!Constants.equalsInteger(discountMember.getStatus(),Constants.ZERO)){
+                continue;
+            }
             discountMemberMapper.update(null,new UpdateWrapper<DiscountMember>().lambda()
                     .set(DiscountMember::getStatus,Constants.ONE)
                     .eq(DiscountMember::getId,discountMember.getId())
@@ -190,7 +197,7 @@
     @Override
     public void adjust(DiscountMemberDTO model){
         if(Objects.isNull(model)
-        || Objects.isNull(model.getAddDays())){
+            || Objects.isNull(model.getAddDays())){
             throw new BusinessException(ResponseStatus.BAD_REQUEST);
         }
         LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
@@ -227,10 +234,11 @@
             discountLog.setDiscountMemberId(discountMember.getId());
             discountLog.setType(Constants.TWO);
             discountLog.setGoodsorderId(discountMember.getGoodsorderId());
-            discountLog.setEditInfo(model.getInfo());
+            discountLog.setInfo(model.getInfo());
             discountLog.setEditDays(model.getAddDays());
-            discountLog.setInfo("灏嗘湁鏁堟湡澧炲姞"+model.getAddDays()+"澶�, 璋冩暣鍚庢湁鏁堟湡鑷�"+useEndDate);
+            discountLog.setEditInfo("灏嗘湁鏁堟湡澧炲姞"+model.getAddDays()+"澶�, 璋冩暣鍚庢湁鏁堟湡鑷�"+useEndDate);
             discountLogMapper.insert(discountLog);
+
         }
     }
 
@@ -240,4 +248,8 @@
         QueryWrapper<DiscountMember> wrapper = new QueryWrapper<>(discountMember);
         return discountMemberMapper.selectCount(wrapper);
     }
+
+    
+    
+    
 }

--
Gitblit v1.9.3