From 1a21c37e2c41236c89e97a33e9da65c5fe7971b6 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期三, 01 六月 2022 18:11:08 +0800
Subject: [PATCH] bug修改

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComActAcidRecordApi.java                  |    4 ++--
 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java                             |    2 +-
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml                                        |    6 ++++--
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActAcidRecordDao.java                  |    3 ++-
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActAcidRecordServiceImpl.java |    5 +++--
 springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ComActAcidRecordApi.java                                      |    4 ++--
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActAcidRecordService.java          |    3 ++-
 7 files changed, 16 insertions(+), 11 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ComActAcidRecordApi.java b/springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ComActAcidRecordApi.java
index f4fac0f..7d2c436 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ComActAcidRecordApi.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ComActAcidRecordApi.java
@@ -126,8 +126,8 @@
     }
     @ApiOperation(value = "新版查看详情",response = ComActAcidRecordVO.class)
     @GetMapping("/detailByApp")
-    public R detailByApp(@RequestParam("id")Long id){
-        return this.communityService.detailByApp(id);
+    public R detailByApp(@RequestParam("id")Long id,@RequestParam("localCity")String localCity){
+        return this.communityService.detailByApp(id,localCity);
     }
 
     /**
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
index bb2ffdb..2278b59 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -9648,7 +9648,7 @@
      * @return 删除结果
      */
     @GetMapping("/comActAcidRecord/detailByApp")
-    R detailByApp(@RequestParam("id") Long id);
+    R detailByApp(@RequestParam("id") Long id,@RequestParam("localCity")String localCity);
 
     @GetMapping("/comActAcidRecord/charts")
     R charts(@RequestParam("date")String date,@RequestParam("localCity")String localCity);
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComActAcidRecordApi.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComActAcidRecordApi.java
index 016a62b..93bf0bf 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComActAcidRecordApi.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComActAcidRecordApi.java
@@ -158,7 +158,7 @@
     }
 
     @GetMapping("/detailByApp")
-    public R detailByApp(@RequestParam("id")Long id){
-        return this.comActAcidRecordService.detailByApp(id);
+    public R detailByApp(@RequestParam("id")Long id,@RequestParam("localCity")String localCity){
+        return this.comActAcidRecordService.detailByApp(id,localCity);
     }
 }
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActAcidRecordDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActAcidRecordDao.java
index 8316a04..b2731a9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActAcidRecordDao.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActAcidRecordDao.java
@@ -10,6 +10,7 @@
 import org.apache.ibatis.annotations.Mapper;
 import com.panzhihua.service_community.entity.ComActAcidRecord;
 import org.apache.ibatis.annotations.Param;
+import org.springframework.web.bind.annotation.RequestParam;
 
 import java.util.List;
 
@@ -89,7 +90,7 @@
      * @param id
      * @return
      */
-    ComActAcidRecordVO selectLastNext(Long id);
+    ComActAcidRecordVO selectLastNext(@RequestParam("id") Long id,@RequestParam("localCity")String localCity);
 
     /**
      * 查询区级填报人数
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActAcidRecordService.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActAcidRecordService.java
index 94f5483..c76aafe 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActAcidRecordService.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActAcidRecordService.java
@@ -6,6 +6,7 @@
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO;
 import com.panzhihua.service_community.entity.ComActAcidRecord;
+import org.springframework.web.bind.annotation.RequestParam;
 
 /**
  * (ComActAcidRecord)表服务接口
@@ -95,7 +96,7 @@
      * @param id
      * @return
      */
-    R detailByApp(Long id);
+    R detailByApp(Long id,String localCity);
 
     /**
      * 后台查看详情
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActAcidRecordServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActAcidRecordServiceImpl.java
index f0b145c..2337aa0 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActAcidRecordServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActAcidRecordServiceImpl.java
@@ -24,6 +24,7 @@
 import org.springframework.beans.BeanUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.bind.annotation.RequestParam;
 
 import javax.annotation.Resource;
 import java.math.BigDecimal;
@@ -458,9 +459,9 @@
     }
 
     @Override
-    public R detailByApp(Long id) {
+    public R detailByApp(Long id,String localCity) {
         ComActAcidRecord comActAcidRecord=this.baseMapper.selectById(id);
-        ComActAcidRecordVO comActAcidRecordVO=this.baseMapper.selectLastNext(id);
+        ComActAcidRecordVO comActAcidRecordVO=this.baseMapper.selectLastNext(id,localCity);
         BeanUtils.copyProperties(comActAcidRecord,comActAcidRecordVO);
         return R.ok(comActAcidRecordVO);
     }
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
index 30fc016..e466f36 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
@@ -274,8 +274,10 @@
     </select>
 
     <select id="selectLastNext" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO">
-        select(select min(id) from com_act_acid_record where id > #{id} and check_status = 0)            next_id,
-              (select max(id) as next_id from com_act_acid_record where #{id} > id and check_status = 0) last_id
+        select(select min(id) from com_act_acid_record where id > #{id} and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like
+        concat('%',#{localCity},'%')</if>)            next_id,
+              (select max(id) as next_id from com_act_acid_record where #{id} > id and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like
+        concat('%',#{localCity},'%')</if>) last_id
     </select>
 
     <select id="selectAcidCount" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidChartsVO">

--
Gitblit v1.7.1