From fc2adc3521931c2f7bc5b2f3a3d94ebf407828d6 Mon Sep 17 00:00:00 2001
From: yxm <zhp1521624>
Date: Mon, 01 Jul 2024 09:40:55 +0800
Subject: [PATCH] 水库堤防白蚁普查资料当前页压缩导出新增条件优化v20240701
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 54 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java
index 902b9f5..6ac1707 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java
@@ -4,16 +4,19 @@
import cn.gistack.sm.sjztmd.mapper.TbResDykeMapper;
import cn.gistack.sm.sjztmd.service.ITbResDykeService;
import cn.gistack.sm.sjztmd.vo.TbResDykeVO;
+import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.Data;
+import org.springblade.core.tool.utils.StringUtil;
import org.springframework.stereotype.Service;
import java.util.List;
@Data
@Service
+@DS("zt")
public class TbResDykeServiceImpl extends ServiceImpl<TbResDykeMapper, TbResDyke> implements ITbResDykeService {
@Override
public TbResDykeVO getDetail(TbResDyke resDyke) {
@@ -22,10 +25,61 @@
@Override
public Object getList(IPage<TbResDykeVO> page, TbResDykeVO tbResDykeVO) {
+
+ if (StringUtil.isNotBlank(tbResDykeVO.getAdCode())){
+ //若行政区划不为空
+ String adCode =tbResDykeVO.getAdCode();
+
+ if (adCode.substring(0,4).indexOf("00") > -1) {
+ //前四位包含00说明是湖北省 4200/00000000
+ adCode =StringUtil.format("%{}%",adCode.substring(0,2));
+ } else if (adCode.substring(0,6).indexOf("00") > -1) {
+ //前六位包含00说明是市级 420100/000000
+// adCode = paramAd.substring(0,4);
+ adCode =StringUtil.format("%{}%",adCode.substring(0,4));
+ }else if (adCode.substring(0,8).indexOf("00") > -1){
+ //前8位包含00 说明是区级 42011700/0000
+// adCode = paramAd.substring(0,6);
+ adCode =StringUtil.format("%{}%",adCode.substring(0,6));
+ }
+ tbResDykeVO.setAdCode(adCode);
+ }
+
if (tbResDykeVO.getIsPage()){
return page.setRecords(baseMapper.getPage(page,tbResDykeVO));
}else {
return baseMapper.getPage(null,tbResDykeVO);
}
}
+
+ @Override
+ public IPage<TbResDykeVO> findTbResDykePcBy(IPage<TbResDykeVO> page, TbResDykeVO tbResDykeVO) {
+
+ if (StringUtil.isNotBlank(tbResDykeVO.getAdCode())){
+ //若行政区划不为空
+ String adCode =tbResDykeVO.getAdCode();
+
+ if (adCode.substring(0,4).indexOf("00") > -1) {
+ //前四位包含00说明是湖北省 4200/00000000
+ adCode =StringUtil.format("%{}%",adCode.substring(0,2));
+ } else if (adCode.substring(0,6).indexOf("00") > -1) {
+ //前六位包含00说明是市级 420100/000000
+// adCode = paramAd.substring(0,4);
+ adCode =StringUtil.format("%{}%",adCode.substring(0,4));
+ }else if (adCode.substring(0,8).indexOf("00") > -1){
+ //前8位包含00 说明是区级 42011700/0000
+// adCode = paramAd.substring(0,6);
+ adCode =StringUtil.format("%{}%",adCode.substring(0,6));
+ }
+ tbResDykeVO.setAdCode(adCode);
+ }
+
+
+
+ if (tbResDykeVO.getIsPage()){
+ return page.setRecords(baseMapper.findTbResDykePcBy(page,tbResDykeVO));
+ }else {
+ return page.setRecords(baseMapper.findTbResDykePcBy(null,tbResDykeVO));
+ }
+ }
}
--
Gitblit v1.9.3