From edb2fff00f6990217f7c39ebc2adb611a1c60478 Mon Sep 17 00:00:00 2001
From: nickchange <126672920+nickchange@users.noreply.github.com>
Date: 星期六, 28 十月 2023 11:21:57 +0800
Subject: [PATCH] 10.28

---
 cloud-server-competition/src/main/java/com/dsh/competition/util/ResultUtil.java                     |    2 
 cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_edit.html   |    9 +++-
 cloud-server-competition/src/main/resources/mapper/CompetitionMapper.xml                            |   34 ++++++++++------
 cloud-server-competition/src/main/java/com/dsh/competition/controller/ParticipantController.java    |   17 +++++++-
 cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java |    4 ++
 cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_add.html    |    8 +++
 cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java    |   22 +++++++++++
 7 files changed, 77 insertions(+), 19 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 6d76e67..62ddfb2 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
@@ -251,6 +251,10 @@
 
 
 
+
+    @Autowired
+    private CompetitionService competitionService;
+
     @ResponseBody
     @PostMapping("/api/competition/paymentCompetition")
     @ApiOperation(value = "赛事报名", tags = {"APP-赛事活动列表"})
@@ -260,10 +264,28 @@
     })
     public ResultUtil paymentCompetition(PaymentCompetitionVo paymentCompetitionVo){
         try {
+
+
+            Competition byId = competitionService.getById(paymentCompetitionVo.getId());
+            Date date = byId.getEndTime(); // Assuming you have a Date object
+
+            // Check if the date is past the current time
+            boolean isPast = date.after(new Date());
+
+            if (!isPast) {
+                return new ResultUtil(0,"已超过截至报名时间");
+            }
+
+
+
+
             Integer uid = tokenUtil.getUserIdFormRedis();
             if(null == uid){
                 return ResultUtil.tokenErr();
             }
+
+
+
             return cttService.paymentCompetition(uid, paymentCompetitionVo);
         }catch (Exception e){
             e.printStackTrace();
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/controller/ParticipantController.java b/cloud-server-competition/src/main/java/com/dsh/competition/controller/ParticipantController.java
index 28e64f0..5d483c2 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/controller/ParticipantController.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/controller/ParticipantController.java
@@ -13,6 +13,7 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import java.util.ArrayList;
 import java.util.List;
 
 
@@ -59,15 +60,27 @@
     @PostMapping("/api/participant/queryParticipantList")
     @ApiOperation(value = "获取参赛人员列表", tags = {"APP-赛事活动列表", ""})
     @ApiImplicitParams({
-            @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
+            @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
+            @ApiImplicitParam(value = "isPre(1过滤)", name = "是否过滤未实名", required = true, dataType = "int")
     })
-    public ResultUtil<List<ParticipantVo>> queryParticipantList(){
+    public ResultUtil<List<ParticipantVo>> queryParticipantList(Integer isPre){
         try {
             Integer uid = tokenUtil.getUserIdFormRedis();
             if(null == uid){
                 return ResultUtil.tokenErr();
             }
             List<ParticipantVo> participantVos = participantService.queryParticipantList(uid);
+            if (isPre!=null){
+                List<ParticipantVo> filteredParticipants = new ArrayList<>();
+
+                for (ParticipantVo participant : participantVos) {
+                    if (participant.getIdcard() != null && !participant.getIdcard().isEmpty()) {
+                        filteredParticipants.add(participant);
+                    }
+                }
+            return ResultUtil.success(filteredParticipants);
+            }
+
             return ResultUtil.success(participantVos);
         }catch (Exception e){
             e.printStackTrace();
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java
index 0e35e4b..6315975 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java
@@ -96,6 +96,10 @@
     @Override
     public List<CompetitionListVo> queryCompetitionList(String cityCode, String content, Integer registerCondition, String heat) throws Exception {
         List<CompetitionListVo> competitionListVos = this.baseMapper.queryCompetitionList(cityCode, content, registerCondition, heat);
+
+
+
+
         return competitionListVos;
     }
 
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/util/ResultUtil.java b/cloud-server-competition/src/main/java/com/dsh/competition/util/ResultUtil.java
index 9bb46ad..174b034 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/util/ResultUtil.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/util/ResultUtil.java
@@ -50,7 +50,7 @@
         return code;
     }
 
-    private ResultUtil(Integer code, String msg) {
+    public ResultUtil(Integer code, String msg) {
         this.code = code;
         this.msg = msg;
     }
diff --git a/cloud-server-competition/src/main/resources/mapper/CompetitionMapper.xml b/cloud-server-competition/src/main/resources/mapper/CompetitionMapper.xml
index ddc2650..4483e47 100644
--- a/cloud-server-competition/src/main/resources/mapper/CompetitionMapper.xml
+++ b/cloud-server-competition/src/main/resources/mapper/CompetitionMapper.xml
@@ -13,20 +13,27 @@
         aa.introduction,
         aa.registerEndTime,
         aa.age,
-        aa.heat
+        (aa.baseNumber+aa.userCompetitionCount) as heat
         from (
-            select
-            a.id,
-            a.`name`,
-            a.coverDrawing,
-            a.city as cityName,
-            a.registerCondition,
-            a.introduction,
-            DATE_FORMAT(a.registerEndTime, '%Y-%m-%d %H:%i') registerEndTime,
-            CONCAT(a.startAge, '-', a.endAge) age,
-            (a.baseNumber + a.applicantsNumber) heat
-            from t_competition a
-            where a.auditStatus = 2 and a.`status` = 2 and a.state = 1
+        SELECT
+        a.id,
+        a.`name`,
+        a.coverDrawing,
+        a.city AS cityName,
+        a.registerCondition,
+        a.introduction,
+        DATE_FORMAT(a.registerEndTime, '%Y-%m-%d %H:%i') AS registerEndTime,
+        CONCAT(a.startAge, '-', a.endAge) AS age,
+        a.baseNumber,
+        COUNT(uc.competitionId) AS userCompetitionCount
+        FROM
+        t_competition a
+        LEFT JOIN
+        t_user_competition5 uc ON a.id = uc.competitionId
+        WHERE
+        a.auditStatus = 2
+        AND a.`status` IN (1, 2)
+        AND a.state = 1
             <if test="null != cityCode and '' != cityCode">
                 and a.cityCode = #{cityCode}
             </if>
@@ -36,6 +43,7 @@
             <if test="null != registerCondition">
                 and a.registerCondition = #{registerCondition}
             </if>
+        GROUP BY a.id
             order by a.insertTime desc
         ) as aa
         <if test="null != heat and '' != heat">
diff --git a/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_add.html b/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_add.html
index c51efd8..49b090e 100644
--- a/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_add.html
+++ b/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_add.html
@@ -192,6 +192,11 @@
 
             }
         });
+        if (oneId==2 || oneId==25|| oneId==27){
+            $("#t3").hide()
+        }
+
+
         ajax.set("id",oneId);
         ajax.start();
     }
@@ -209,8 +214,9 @@
     }
     function updateT(e) {
         var oneId = $('#type option:selected').text();
+
         console.log(oneId);
-        if (oneId!="详情"){
+        if (oneId!="详情"&&oneId!="指定商品"&&oneId!="指定折扣"){
             $("#t3").hide()
         }else{
             $("#t3").show()
diff --git a/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_edit.html b/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_edit.html
index 454942c..ac867b8 100644
--- a/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_edit.html
+++ b/cloud-server-management/src/main/webapp/WEB-INF/view/system/advertisement/advertisement_edit.html
@@ -44,7 +44,7 @@
 <script type="text/javascript" src="http://webapi.amap.com/maps?v=1.4.15&key=77b37f0753049c4e712ea79a24e0719c"></script>
 <div class="ibox float-e-margins">
     <input hidden id="roleType" value="${roleType}">
-    <input hidden id="type" value="${type}">
+    <input hidden id="type1" value="${type}">
     <input hidden id="turnId" value="${data.turnId}">
     <input hidden id="id" value="${data.id}">
     <input hidden id="img1" value="${data.img}">
@@ -204,6 +204,11 @@
 
             }
         });
+
+
+        if (oneId==2 || oneId==25|| oneId==27){
+            $("#t3").hide()
+        }
         ajax.set("id",oneId);
         ajax.start();
     }
@@ -222,7 +227,7 @@
     function updateT(e) {
         var oneId = $('#type option:selected').text();
         console.log(oneId);
-        if (oneId!="详情"){
+        if (oneId!="详情"&&oneId!="指定商品"&&oneId!="指定折扣"){
             $("#t3").hide()
         }else{
             $("#t3").show()

--
Gitblit v1.7.1