From f20a16d05a3bba20b0003d6bff8c2ec2133f8dae Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Wed, 31 May 2023 18:41:54 +0800
Subject: [PATCH] 责任人管理列表sql修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java | 24 ++++++++++++++++--------
1 files changed, 16 insertions(+), 8 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
index f239444..200b13d 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
@@ -47,6 +47,10 @@
return baseMapper.getDetailByCode(code);
}
+ public static void main(String[] args) {
+ System.out.println("420117007000".substring(7,9));
+ }
+
/**
* 获取水库对应责任人分页数据
* @param params 条件查询参数对象
@@ -57,22 +61,26 @@
public Object getAttResBaseUserPage(IPage<AttResBaseUserDTO> page,Map<String, Object> params) {
Object adCode = params.get("adCode");
+ Object adGrad = params.get("adGrad");
String ad_code = "";
+ String p_ad_code = "";
String code = adCode.toString();
- if (code.substring(0,4).indexOf("00") > -1) {
- ad_code = adCode.toString().substring(0,2);
- } else if (code.substring(0,6).indexOf("00") > -1) {
- ad_code = adCode.toString().substring(0,4);
+ if (adGrad.toString().equals("1")) {
+ p_ad_code = code.substring(0,2);
+ } else if (adGrad.toString().equals("2")) {
+ p_ad_code = code.substring(0,4);
+ } else if (adGrad.toString().equals("3")) {
+ p_ad_code = code.substring(0,7);
} else {
- ad_code = adCode.toString().substring(0,6);
+ ad_code = code;
}
- Object isExport = params.get("isExport");
+ Object isExport = params.get("isExport");
// 判断是否导出，导出不分页
if (null != isExport && !isExport.equals("")) {
- return baseMapper.getAttResBaseUserPage(null,ad_code,params);
+ return baseMapper.getAttResBaseUserPage(null,ad_code,p_ad_code,params);
}
- List<AttResBaseUserDTO> attResBaseUserDTOList = baseMapper.getAttResBaseUserPage(page,ad_code,params);
+ List<AttResBaseUserDTO> attResBaseUserDTOList = baseMapper.getAttResBaseUserPage(page,ad_code,p_ad_code,params);
// 返回数据
return page.setRecords(attResBaseUserDTOList);
}
--
Gitblit v1.9.3