From 59ad364486c751e68ea61125badeabcbd318fcb2 Mon Sep 17 00:00:00 2001
From: lisy <linlangsur163@163.com>
Date: 星期五, 07 七月 2023 17:49:17 +0800
Subject: [PATCH] 去除xml中的unionall连表查询语句

---
 cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java b/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
index 41ac205..b8706ca 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
@@ -49,7 +49,10 @@
                 .eq("payType",3 )
                 .eq("auditStatus",2));
         List<Integer> comIds = list.stream().map(Competition::getId).collect(Collectors.toList());
-        List<UserCompetition> userCompetitions = ucttService.queryUsersCompetetions(sourseList.getStartTime(),sourseList.getEndTime(),sourseList.getAppUserId(),comIds);
+        List<UserCompetition> userCompetitions = ucttService.list(new QueryWrapper<UserCompetition>()
+                .between("insertTime", sourseList.getStartTime(),sourseList.getEndTime() )
+                .eq("userId", sourseList.getAppUserId())
+                .in("competitionId",comIds ));
         if (userCompetitions.size() > 0){
             userCompetitions.forEach(coms ->{
                 PurchaseRecordVo recordVo = new PurchaseRecordVo();

--
Gitblit v1.7.1