From 6cfff55d44314e88fefd6e3adb290ec16b303f89 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期五, 05 一月 2024 10:42:53 +0800
Subject: [PATCH] 1、供产品导数据临时用(用户，机构，部门，仓库，库管员 可删) 2、选择库管员增加过滤参数
---
consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java | 376 ++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 294 insertions(+), 82 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
index 2654c55..ea2e9ab 100644
--- a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
@@ -11,6 +11,9 @@
import java.util.Optional;
import java.util.Set;
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.TypeReference;
+import lombok.extern.slf4j.Slf4j;
import org.apache.commons.compress.utils.Lists;
import org.apache.commons.lang3.ObjectUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -21,7 +24,6 @@
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
-
import com.alibaba.excel.EasyExcelFactory;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
@@ -62,7 +64,6 @@
import com.walker.infrastructure.utils.PhoneNumberUtils;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.web.ResponseValue;
-
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
@@ -76,6 +77,7 @@
@Api(value = "鏈烘瀯鐢ㄦ埛淇℃伅", tags = "鏈烘瀯鐢ㄦ埛淇℃伅")
@RestController
@RequestMapping("/pc/fin/sys/tenant/user")
+@Slf4j
public class FinSysTenantUserController extends BaseController {
private String roleName;
@@ -186,6 +188,214 @@
return ResponseValue.success(1);
}
+ // 渚涗骇鍝佸鏁版嵁涓存椂鐢�(鍙垹)
+ public ResponseValue add1(FinSysTenantUser user) {
+ FinSysTenantUser tenantUser = new FinSysTenantUser();
+ CommonUtil.copyProperties(user, tenantUser);
+
+ if (tenantUser == null) {
+ return ResponseValue.error("鍙傛暟涓虹┖");
+ }
+ // 鏍规嵁鍛樺伐缂栧彿鏌ヨ锛屽鏋滃瓨鍦ㄥ垯鎻愮ず
+ FinSysTenantUser userCode = finSysTenantUserService.getByUserCode(tenantUser.getUserCode());
+ if (userCode != null) {
+ return ResponseValue.error("鍛樺伐缂栧彿閲嶅");
+ }
+ if (StringUtils.isEmpty(tenantUser.getTenantId()) || "0".equals(tenantUser.getTenantId())) {
+ return ResponseValue.error("娣诲姞鏃惰閫夋嫨鍖哄幙");
+ }
+
+ // 鎻掑叆绯荤粺鐢ㄦ埛
+ buildTenantUser(tenantUser, null);
+ this.finSysTenantUserService.insert(tenantUser);
+
+ // 鎻掑叆骞冲彴鐢ㄦ埛
+ S_user_core userCore = getsUserCore(tenantUser);
+ this.userService.insert(userCore);
+ // 鎻掑叆骞冲彴鏈烘瀯
+ // 灏戣鑹瞚d
+ // 鏈烘瀯id 澶氫釜
+ List<Long> roleList = user.getRoleList();
+ if (!CollectionUtils.isEmpty(roleList)) {
+ // 鐢ㄦ埛id
+ Long sysUserId = tenantUser.getSysUserId();
+ this.finSysTenantUserService.execInsertRoleUserList(roleList, sysUserId);
+ }
+ // this.getFinCustomerCache().remove();
+ return ResponseValue.success(1);
+ }
+
+ // 瀵兼暟鎹复鏃�(鍙垹)
+ //@GetMapping("/sx")
+ public String sx() {
+ List<Map<String, Object>> selLi = new ArrayList<>();
+ // 鐪佸垎鍏徃
+ String jsonObjq = "[{\"jg\":\"鐪佸叕鍙告笭閬撳钩鍙伴儴\",\"bm\":\"鐪佸叕鍙告笭閬撳钩鍙伴儴\",\"name\":\"鍒樼孩鑿奬",\"sex\":\"濂砛",\"userCode\":\"03552178\",\"phone\":18737105228,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙搁噾铻嶄笟鍔￠儴\",\"bm\":\"鐪佸叕鍙搁噾铻嶄笟鍔￠儴\",\"name\":\"鍒樻捣闇瀄",\"sex\":\"濂砛",\"userCode\":\"01505065\",\"phone\":13523087226,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙稿競鍦鸿惀閿�閮╘",\"bm\":\"鐪佸叕鍙稿競鍦鸿惀閿�閮╘",\"name\":\"寮犵孩褰琝",\"sex\":\"鐢穃",\"userCode\":\"03361744\",\"phone\":15803876096,\"isOk\":\"鍚"},{\"jg\":\"娌冲崡鐪佸垎鍏徃\",\"bm\":\"鐪佸叕鍙稿姙鍏\",\"name\":\"椹尟鏁廫",\"sex\":\"鐢穃",\"userCode\":\"01502670\",\"phone\":13903710700,\"isOk\":\"鏄痋"},{\"jg\":\"娌冲崡鐪佸垎鍏徃\",\"bm\":\"鐪佸叕鍙稿姙鍏\",\"name\":\"钁ｅ穽\",\"sex\":\"鐢穃",\"userCode\":\"04046134\",\"phone\":15837923999,\"isOk\":\"鏄痋"},{\"jg\":\"娌冲崡鐪佸浗闄呬笟鍔″垎鍏徃\",\"bm\":\"杩愯惀閮╘",\"name\":\"宕斿畨鏍揬",\"sex\":\"鐢穃",\"userCode\":\"04062648\",\"phone\":13383711855,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙镐紒涓氬彂灞曚笌绉戞妧閮╘",\"bm\":\"鐪佸垎鍏徃浼佷笟鍙戝睍涓庣鎶�閮╘",\"name\":\"鐗т簯榫橽",\"sex\":\"鐢穃",\"userCode\":\"03994216\",\"phone\":18239947091,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙稿瘎閫掍簨涓氶儴\",\"bm\":\"蹇�掑寘瑁归儴\",\"name\":\"鏉庝匠鎬",\"sex\":\"濂砛",\"userCode\":\"04099973\",\"phone\":18503806796,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙镐笓涓氬叕鍙竆",\"bm\":\"鐪佺墿娴佷笟鍔″垎鍏徃\",\"name\":\"璧靛啗娴‐",\"sex\":\"鐢穃",\"userCode\":\"03823583\",\"phone\":18695817002,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙歌繍钀ョ鐞嗛儴\",\"bm\":\"鐪佸叕鍙歌繍钀ョ鐞嗛儴\",\"name\":\"鍚撮箯\",\"sex\":\"鐢穃",\"userCode\":\"03830501\",\"phone\":18703649829,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙稿璁￠儴\",\"bm\":\"鐪佸叕鍙稿璁￠儴\",\"name\":\"鍚存槬鏅揬",\"sex\":\"濂砛",\"userCode\":\"03687276\",\"phone\":15224998605,\"isOk\":\"鍚"},{\"jg\":\"鐪佸煿璁腑蹇僜",\"bm\":\"鐪佸煿璁腑蹇僜",\"name\":\"寰愮孩鑾塡",\"sex\":\"濂砛",\"userCode\":\"01500210\",\"phone\":18603712875,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙稿璁￠儴\",\"bm\":\"鐪佸叕鍙稿璁￠儴\",\"name\":\"寮犳収\",\"sex\":\"濂砛",\"userCode\":\"01503158\",\"phone\":13939066027,\"isOk\":\"鍚"},{\"jg\":\"鍏氬鍏氬缓宸ヤ綔閮╘",\"bm\":\"鍏氬鍏氬缓宸ヤ綔閮╘",\"name\":\"璧甸懌\",\"sex\":\"鐢穃",\"userCode\":\"01500027\",\"phone\":18603850005,\"isOk\":\"鍚"},{\"jg\":\"鐪佹姤鍒婂彂琛屼腑蹇僜",\"bm\":\"闆跺敭涓氬姟瀹",\"name\":\"鍚曡壋楣",\"sex\":\"濂砛",\"userCode\":\"01504870\",\"phone\":15936222211,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙告湇鍔¤川閲忛儴\",\"bm\":\"鐪佸叕鍙告湇鍔¤川閲忛儴\",\"name\":\"鐜嬪▉\",\"sex\":\"濂砛",\"userCode\":\"03890426\",\"phone\":18637467979,\"isOk\":\"鍚"},{\"jg\":\"鐪侀偖鏀垮伐浼歕",\"bm\":\"鐪侀偖鏀垮伐浼歕",\"name\":\"鏉庢湞瀹嘰",\"sex\":\"鐢穃",\"userCode\":\"03425375\",\"phone\":13676970007,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙搁泦閭笌鏂囧寲浼犲獟閮╘",\"bm\":\"鐪佸叕鍙搁泦閭笌鏂囧寲浼犲獟閮╘",\"name\":\"瀛欑繑\",\"sex\":\"鐢穃",\"userCode\":\"01504413\",\"phone\":18236911185,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙稿畨鍏ㄤ繚鍗儴\",\"bm\":\"鐪佸叕鍙稿畨鍏ㄤ繚鍗儴\",\"name\":\"閮檽鑱僜",\"sex\":\"鐢穃",\"userCode\":\"03215667\",\"phone\":13526691093,\"isOk\":\"鍚"},{\"jg\":\"鐪佸叕鍙稿畨鍏ㄤ繚鍗儴\",\"bm\":\"鐪佸叕鍙稿畨鍏ㄤ繚鍗儴\",\"name\":\"寰愯緣\",\"sex\":\"鐢穃",\"userCode\":\"03563970\",\"phone\":13613837861,\"isOk\":\"鏄痋"},{\"jg\":\"娌冲崡鐪佹満瑕侀�氫俊灞�\",\"bm\":\"閫氫俊瀹",\"name\":\"绋嬭緣\",\"sex\":\"鐢穃",\"userCode\":\"03223176\",\"phone\":13937163121,\"isOk\":\"鏄痋"},{\"jg\":\"鐪佸叕鍙哥邯濮斿姙\",\"bm\":\"鐪佸叕鍙哥邯濮斿姙\",\"name\":\"鐧介暱閿怽",\"sex\":\"濂砛",\"userCode\":\"01504608\",\"phone\":15936205391,\"isOk\":\"\"}]";
+ Long dqq = 100L;
+ Map<String, Object> dqMap = new HashMap<>();
+ dqMap.put("dq", dqq);
+ dqMap.put("jsonObj", jsonObjq);
+ selLi.add(dqMap);
+ // 娲涢槼
+ String jsonObjLy = "[{\"jg\":\"娲涢槼甯傚垎鍏徃\",\"bm\":\"甯傚垎鍏徃鍔炲叕瀹",\"name\":\"寮犲啺\",\"sex\":\"鐢穃",\"userCode\":\"03759601\",\"phone\":13937928371,\"isOk\":\"鏄痋"},{\"jg\":\"娲涢槼甯傚垎鍏徃\",\"bm\":\"甯傚垎鍏徃鍔炲叕瀹",\"name\":\"浠昏繙鑼筡",\"sex\":\"濂砛",\"userCode\":\"03674597\",\"phone\":15896551283,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃璐㈠姟閮╘",\"bm\":\"甯傚垎鍏徃璐㈠姟閮╘",\"name\":\"寮犻拪鐑絓",\"sex\":\"鐢穃",\"userCode\":\"04034306\",\"phone\":18039580366,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍏氬鍏氬缓宸ヤ綔閮╘",\"bm\":\"甯傚垎鍏徃鍏氬鍏氬缓宸ヤ綔閮╘",\"name\":\"瀛ｆ尟鍒‐",\"sex\":\"鐢穃",\"userCode\":\"01510981\",\"phone\":13939933919,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃绾鍔炲叕瀹",\"bm\":\"甯傚垎鍏徃绾鍔炲叕瀹",\"name\":\"鍒橀潤\",\"sex\":\"濂砛",\"userCode\":\"03683369\",\"phone\":18103884255,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"bm\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"name\":\"閮捣钃塡",\"sex\":\"濂砛",\"userCode\":\"01510011\",\"phone\":13903880036,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃閭斂宸ヤ細\",\"bm\":\"甯傚垎鍏徃閭斂宸ヤ細\",\"name\":\"娌堥洴绔",\"sex\":\"濂砛",\"userCode\":\"04151632\",\"phone\":13838866710,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"bm\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"name\":\"寮犵惓\",\"sex\":\"濂砛",\"userCode\":\"03361080\",\"phone\":15138789615,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"name\":\"鏉庢潹\",\"sex\":\"濂砛",\"userCode\":\"01511005\",\"phone\":13403798177,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"bm\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"name\":\"鐜嬮敗楣廫",\"sex\":\"鐢穃",\"userCode\":\"01510959\",\"phone\":13803791652,\"isOk\":\"鍚"},{\"jg\":\"鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"鏈鸿閫氫俊鍒嗗眬\",\"name\":\"鐜嬫柊濂嘰",\"sex\":\"鐢穃",\"userCode\":\"03696444\",\"phone\":15937960867,\"isOk\":\"鍚"},{\"jg\":\"涓夌骇鐗╂祦浣撶郴寤鸿宸ヤ綔涓撶彮\",\"bm\":\"涓夌骇鐗╂祦浣撶郴寤鸿宸ヤ綔涓撶彮\",\"name\":\"鏉庡\",\"sex\":\"鐢穃",\"userCode\":\"03773656\",\"phone\":18637973399,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"bm\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"name\":\"姝︿附濞焅",\"sex\":\"濂砛",\"userCode\":\"01510731\",\"phone\":13938860508,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"bm\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"name\":\"鑰胯緣\",\"sex\":\"濂砛",\"userCode\":\"01510263\",\"phone\":18503791195,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃闆嗛偖鏂囧寲浼犲獟閮╘",\"bm\":\"甯傚垎鍏徃闆嗛偖鏂囧寲浼犲獟閮╘",\"name\":\"鐜嬫搸鍗嶾",\"sex\":\"濂砛",\"userCode\":\"01510701\",\"phone\":13837906227,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"bm\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"name\":\"鐜嬭悓\",\"sex\":\"鐢穃",\"userCode\":\"01510278\",\"phone\":13849927054,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"bm\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"name\":\"寮犵憸\",\"sex\":\"濂砛",\"userCode\":\"03388290\",\"phone\":13303797187,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍥介檯閮╘",\"bm\":\"甯傚垎鍏徃鍥介檯閮╘",\"name\":\"琚佹ⅵ娉絓",\"sex\":\"濂砛",\"userCode\":\"04018427\",\"phone\":13837570555,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃蹇寘閮╘",\"bm\":\"甯傚垎鍏徃蹇寘閮╘",\"name\":\"妯婁紵鐠焅",\"sex\":\"濂砛",\"userCode\":\"01510617\",\"phone\":13938823944,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏍囧揩閮╘",\"bm\":\"甯傚垎鍏徃鏍囧揩閮╘",\"name\":\"鐢冲皬鑺砛",\"sex\":\"濂砛",\"userCode\":\"03291311\",\"phone\":13693802105,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鐗╂祦閮╘",\"bm\":\"甯傚垎鍏徃鐗╂祦閮╘",\"name\":\"姝﹀皬濞焅",\"sex\":\"濂砛",\"userCode\":\"01510277\",\"phone\":13783100717,\"isOk\":\"鍚"},{\"jg\":\"娲涢槼甯傝タ宸ュ尯鍒嗗叕鍙竆",\"bm\":\"瑗垮伐鍖哄垎鍏徃\",\"name\":\"鐜嬪嘲\",\"sex\":\"鐢穃",\"userCode\":\"03222623\",\"phone\":15637917771,\"isOk\":\"鏄痋"},{\"jg\":\"娲涢槼甯傝�佸煄鍖虹�嶆渤鍖哄垎鍏徃\",\"bm\":\"鐎嶆渤鍖哄垎鍏徃\",\"name\":\"灏ゆ槑杈塡",\"sex\":\"濂砛",\"userCode\":\"01511182\",\"phone\":13698807787,\"isOk\":\"鏄痋"},{\"jg\":\"娲涢槼甯傛锭瑗垮尯鍒嗗叕鍙竆",\"bm\":\"娑цタ鍖哄垎鍏徃\",\"name\":\"浠樻檽涓絓",\"sex\":\"濂砛",\"userCode\":\"01515181\",\"phone\":13838410612,\"isOk\":\"鏄痋"},{\"jg\":\"娲涢槼甯傛礇榫欏尯鍒嗗叕鍙竆",\"bm\":\"娲涢緳鍖哄垎鍏徃\",\"name\":\"濮柊涔怽",\"sex\":\"鐢穃",\"userCode\":\"03207269\",\"phone\":13707690099,\"isOk\":\"鏄痋"},{\"jg\":\"娲涢槼甯傚悏鍒╁尯鍒嗗叕鍙竆",\"bm\":\"鍚夊埄鍖哄垎鍏徃\",\"name\":\"浜庨暱鍐沑",\"sex\":\"鐢穃",\"userCode\":\"01511215\",\"phone\":13700796606,\"isOk\":\"鏄痋"},{\"jg\":\"鍋冨笀甯傚垎鍏徃\",\"bm\":\"鍋冨笀甯傚垎鍏徃\",\"name\":\"涔斾簹鍧",\"sex\":\"鐢穃",\"userCode\":\"03928890\",\"phone\":18838811901,\"isOk\":\"鏄痋"},{\"jg\":\"瀛熸触鍘垮垎鍏徃\",\"bm\":\"瀛熸触鍘垮垎鍏徃\",\"name\":\"瀹嬩簹鍐沑",\"sex\":\"鐢穃",\"userCode\":\"01511776\",\"phone\":18937979877,\"isOk\":\"鏄痋"},{\"jg\":\"鏂板畨鍘垮垎鍏徃\",\"bm\":\"鏂板畨鍘垮垎鍏徃\",\"name\":\"鏌充笘寮篭",\"sex\":\"鐢穃",\"userCode\":\"01511988\",\"phone\":13837903567,\"isOk\":\"鏄痋"},{\"jg\":\"浼婂窛鍘垮垎鍏徃\",\"bm\":\"浼婂窛鍘垮垎鍏徃\",\"name\":\"鐜嬬伩鏈漒",\"sex\":\"鐢穃",\"userCode\":\"01512126\",\"phone\":13633888158,\"isOk\":\"鏄痋"},{\"jg\":\"姹濋槼鍘垮垎鍏徃\",\"bm\":\"姹濋槼鍘垮垎鍏徃\",\"name\":\"榛勪簹鏌痋",\"sex\":\"鐢穃",\"userCode\":\"03469514\",\"phone\":15896509000,\"isOk\":\"鏄痋"},{\"jg\":\"宓╁幙鍒嗗叕鍙竆",\"bm\":\"宓╁幙鍒嗗叕鍙竆",\"name\":\"寮犺敁\",\"sex\":\"濂砛",\"userCode\":\"01512531\",\"phone\":13461096641,\"isOk\":\"鏄痋"},{\"jg\":\"娲涘畞鍘垮垎鍏徃\",\"bm\":\"娲涘畞鍘垮垎鍏徃\",\"name\":\"寮犵孩浼焅",\"sex\":\"鐢穃",\"userCode\":\"01512666\",\"phone\":\"13608463677\",\"isOk\":\"鏄痋"},{\"jg\":\"鏍惧窛鍘垮垎鍏徃\",\"bm\":\"鏍惧窛鍘垮垎鍏徃\",\"name\":\"浠绘眽鏅揬",\"sex\":\"鐢穃",\"userCode\":\"01513030\",\"phone\":13213643888,\"isOk\":\"鏄痋"},{\"jg\":\"瀹滈槼鍘垮垎鍏徃\",\"bm\":\"瀹滈槼鍘垮垎鍏徃\",\"name\":\"灏瑰彫閿媆",\"sex\":\"鐢穃",\"userCode\":\"01513087\",\"phone\":13598159606,\"isOk\":\"鏄痋"}]";
+ Long dqLy = 100003L;
+ Map<String, Object> dqMapLy = new HashMap<>();
+ dqMapLy.put("dq", dqLy);
+ dqMapLy.put("jsonObj", jsonObjLy);
+ selLi.add(dqMapLy);
+
+ // 鏂颁埂
+ String jsonObjXx = "[{\"jg\":\"鏂颁埂甯傜孩鏃楀尯鍒嗗叕鍙竆",\"bm\":\"绾㈡棗鍖哄垎鍏徃\",\"name\":\"浣曡秴\",\"sex\":\"鐢穃",\"userCode\":\"03210567\",\"phone\":15537301123,\"isOk\":\"鏄痋"},{\"jg\":\"鏂颁埂甯傚崼婊ㄥ尯鍒嗗叕鍙竆",\"bm\":\"鍗花鍖哄垎鍏徃\",\"name\":\"娲壓鍑孿",\"sex\":\"濂砛",\"userCode\":\"04228999\",\"phone\":13193529810,\"isOk\":\"鏄痋"},{\"jg\":\"鏂颁埂鍘垮垎鍏徃\",\"bm\":\"鏂颁埂鍘垮垎鍏徃\",\"name\":\"鐜嬬強\",\"sex\":\"濂砛",\"userCode\":\"01520346\",\"phone\":18503738081,\"isOk\":\"鏄痋"},{\"jg\":\"鍗緣甯傚垎鍏徃\",\"bm\":\"鍗緣甯傚垎鍏徃\",\"name\":\"鏉庡箍楣廫",\"sex\":\"鐢穃",\"userCode\":\"03301600\",\"phone\":13803805869,\"isOk\":\"鏄痋"},{\"jg\":\"闀垮灒鍘垮垎鍏徃\",\"bm\":\"闀垮灒鍘垮垎鍏徃\",\"name\":\"鐗涜儨娉",\"sex\":\"鐢穃",\"userCode\":\"03899135\",\"phone\":18790652979,\"isOk\":\"鏄痋"},{\"jg\":\"鑾峰槈鍘垮垎鍏徃\",\"bm\":\"鑾峰槈鍘垮垎鍏徃\",\"name\":\"鍒樼礌绾",\"sex\":\"濂砛",\"userCode\":\"01521199\",\"phone\":13937334224,\"isOk\":\"鏄痋"},{\"jg\":\"杈夊幙甯傚垎鍏徃\",\"bm\":\"杈夊幙甯傚垎鍏徃\",\"name\":\"鐢虫柊鍑痋",\"sex\":\"鐢穃",\"userCode\":\"01521360\",\"phone\":18537330511,\"isOk\":\"鏄痋"},{\"jg\":\"鍘熼槼鍘垮垎鍏徃\",\"bm\":\"鍘熼槼鍘垮垎鍏徃\",\"name\":\"鍒樿秴\",\"sex\":\"鐢穃",\"userCode\":\"01521730\",\"phone\":13707650123,\"isOk\":\"鏄痋"},{\"jg\":\"寤舵触鍘垮垎鍏徃\",\"bm\":\"寤舵触鍘垮垎鍏徃\",\"name\":\"寮犻湶\",\"sex\":\"濂砛",\"userCode\":\"01522001\",\"phone\":13937370037,\"isOk\":\"鏄痋"},{\"jg\":\"灏佷笜鍘垮垎鍏徃\",\"bm\":\"灏佷笜鍘垮垎鍏徃\",\"name\":\"澶忕淮楂榎",\"sex\":\"鐢穃",\"userCode\":\"04075391\",\"phone\":15136797778,\"isOk\":\"鏄痋"},{\"jg\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"bm\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"name\":\"寮犳潐鏉塡",\"sex\":\"濂砛",\"userCode\":\"03826195\",\"phone\":15937377509,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"bm\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"name\":\"寮犻┌\",\"sex\":\"鐢穃",\"userCode\":\"04176306\",\"phone\":13598636235,\"isOk\":\"鍚"},{\"jg\":\"鏂颁埂甯傚垎鍏徃\",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"鏉滃崥鏂嘰",\"sex\":\"鐢穃",\"userCode\":\"03823498\",\"phone\":15637388663,\"isOk\":\"鏄痋"},{\"jg\":\"鏂颁埂甯傚垎鍏徃\",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"鐜嬫槅\",\"sex\":\"鐢穃",\"userCode\":\"03302561\",\"phone\":13525080106,\"isOk\":\"鍚"},{\"jg\":\"鏂颁埂甯傚垎鍏徃\",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"鏉庡博\",\"sex\":\"濂砛",\"userCode\":\"01519703\",\"phone\":15837361011,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃绾鍔瀄",\"bm\":\"甯傚垎鍏徃绾鍔瀄",\"name\":\"鍚寸惓鐞砛",\"sex\":\"濂砛",\"userCode\":\"03204711\",\"phone\":13462330456,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍏氬缓宸ヤ綔閮╘",\"bm\":\"甯傚垎鍏徃鍏氬缓宸ヤ綔閮╘",\"name\":\"钖涚帀濠穃",\"sex\":\"濂砛",\"userCode\":\"03364895\",\"phone\":18503738050,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"bm\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"name\":\"闄堟檽鑸猏",\"sex\":\"鐢穃",\"userCode\":\"04034140\",\"phone\":13525071200,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"bm\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"name\":\"璐归\",\"sex\":\"濂砛",\"userCode\":\"04034097\",\"phone\":15036606066,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"bm\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"name\":\"濞勬捣娑沑",\"sex\":\"鐢穃",\"userCode\":\"01519606\",\"phone\":15836171777,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"bm\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"name\":\"璐剧惇\",\"sex\":\"濂砛",\"userCode\":\"03363899\",\"phone\":18237396886,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"鏉ㄦ晱\",\"sex\":\"濂砛",\"userCode\":\"01521917\",\"phone\":13782581260,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"鍛ㄦ柊鏂癨",\"sex\":\"濂砛",\"userCode\":\"01519517\",\"phone\":13781959890,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"name\":\"閮崕\",\"sex\":\"濂砛",\"userCode\":\"01520280\",\"phone\":13782571861,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"甯傚垎鍏徃鏈鸿閫氫俊鍒嗗眬\",\"name\":\"鍘熷ぇ浼焅",\"sex\":\"鐢穃",\"userCode\":\"01519161\",\"phone\":18637398236,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃宸ヤ細\",\"bm\":\"甯傚垎鍏徃宸ヤ細\",\"name\":\"闊╅\",\"sex\":\"鐢穃",\"userCode\":\"01520297\",\"phone\":\"13462349483\",\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"bm\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"name\":\"鍛ㄦ枃鍒歕",\"sex\":\"鐢穃",\"userCode\":\"03364889\",\"phone\":15993017558,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鐗╂祦璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鐗╂祦璐ｄ换涓績\",\"name\":\"鍒樼\",\"sex\":\"濂砛",\"userCode\":\"01519734\",\"phone\":13462202288,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏍囧揩璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鏍囧揩璐ｄ换涓績\",\"name\":\"绁佺伩姊梊",\"sex\":\"濂砛",\"userCode\":\"03448285\",\"phone\":18625956096,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍥介檯璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鍥介檯璐ｄ换涓績\",\"name\":\"闄堟絿\",\"sex\":\"濂砛",\"userCode\":\"04099763\",\"phone\":15660143332,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃璐㈠姟閮╘",\"bm\":\"甯傚垎鍏徃璐㈠姟閮╘",\"name\":\"瀹嬫磥\",\"sex\":\"濂砛",\"userCode\":\"03359178\",\"phone\":13663732775,\"isOk\":\"鍚"}]";
+ Long dqXx = 100007L;
+ Map<String, Object> dqMapXx = new HashMap<>();
+ dqMapXx.put("dq", dqXx);
+ dqMapXx.put("jsonObj", jsonObjXx);
+ selLi.add(dqMapXx);
+
+ // 鐒︿綔
+ String jsonObjJz = "[{\"jg\":\"鐒︿綔甯傚垎鍏徃\",\"bm\":\"甯傚叕鍙稿姙鍏\",\"name\":\"琚佹槑\",\"sex\":\"鐢穃",\"userCode\":\"01522429\",\"phone\":13938160410,\"isOk\":\"鏄痋"},{\"jg\":\"璐㈠姟閮╘",\"bm\":\"璐㈠姟閮╘",\"name\":\"鏉庣堪鏋梊",\"sex\":\"鐢穃",\"userCode\":\"04104297\",\"phone\":17638919096,\"isOk\":\"鍚"},{\"jg\":\"浜哄姏璧勬簮閮╘",\"bm\":\"浜哄姏璧勬簮閮╘",\"name\":\"璧电憺鏄孿",\"sex\":\"鐢穃",\"userCode\":\"01522936\",\"phone\":13939198378,\"isOk\":\"鍚"},{\"jg\":\"鍏氬缓宸ヤ綔閮╘",\"bm\":\"鍏氬缓宸ヤ綔閮╘",\"name\":\"甯歌壋\",\"sex\":\"濂砛",\"userCode\":\"01522695\",\"phone\":15993797171,\"isOk\":\"鍚"},{\"jg\":\"宸ヤ細\",\"bm\":\"宸ヤ細\",\"name\":\"鐜嬫弧涓璡",\"sex\":\"鐢穃",\"userCode\":\"01522496\",\"phone\":13938159133,\"isOk\":\"鍚"},{\"jg\":\"甯傚満钀ラ攢閮╘",\"bm\":\"甯傚満钀ラ攢閮╘",\"name\":\"閮┃鑿瞈",\"sex\":\"濂砛",\"userCode\":\"03886838\",\"phone\":18300601166,\"isOk\":\"鍚"},{\"jg\":\"鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"鏈嶅姟璐ㄩ噺閮╘",\"name\":\"浠濆崼寮篭",\"sex\":\"鐢穃",\"userCode\":\"01522937\",\"phone\":18236859609,\"isOk\":\"鍚"},{\"jg\":\"杩愯惀绠＄悊閮╘",\"bm\":\"杩愯惀绠＄悊閮╘",\"name\":\"渚帀濠穃",\"sex\":\"濂砛",\"userCode\":\"04035146\",\"phone\":15639177955,\"isOk\":\"鍚"},{\"jg\":\"缃戣矾杩愯惀涓績\",\"bm\":\"缃戣矾杩愯惀涓績\",\"name\":\"钄＄\",\"sex\":\"鐢穃",\"userCode\":\"03481688\",\"phone\":18603916101,\"isOk\":\"鍚"},{\"jg\":\"涓夌骇鐗╂祦浣撶郴寤鸿涓揬",\"bm\":\"涓夌骇鐗╂祦浣撶郴寤鸿涓撶彮\",\"name\":\"闊﹀缓鐞哱",\"sex\":\"鐢穃",\"userCode\":\"01522952\\n\",\"phone\":\"15978781080\\n\",\"isOk\":\"鍚"},{\"jg\":\"閲戣瀺涓氬姟閮╘",\"bm\":\"閲戣瀺涓氬姟閮╘",\"name\":\"鏉庡噷蹇梊",\"sex\":\"鐢穃",\"userCode\":\"04104055\",\"phone\":15539128318,\"isOk\":\"鍚"},{\"jg\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"鏉ㄦ捣鑹砛",\"sex\":\"濂砛",\"userCode\":\"01523490\",\"phone\":13939190999,\"isOk\":\"鍚"},{\"jg\":\"娓犻亾骞冲彴閮╘",\"bm\":\"娓犻亾骞冲彴閮╘",\"name\":\"娈垫槅鏄嶾",\"sex\":\"鐢穃",\"userCode\":\"01522588\",\"phone\":13938193778,\"isOk\":\"鍚"},{\"jg\":\"鍥介檯鐗╂祦涓撲笟璐ｄ换涓績\",\"bm\":\"鍥介檯鐗╂祦涓撲笟璐ｄ换涓績\",\"name\":\"鍒樼孩鐞碶",\"sex\":\"濂砛",\"userCode\":\"01523196 \",\"phone\":13598509735,\"isOk\":\"鍚"},{\"jg\":\"蹇�掑寘瑁逛笓涓氳矗浠讳腑蹇僜",\"bm\":\"蹇�掑寘瑁逛笓涓氳矗浠讳腑蹇僜",\"name\":\"閮藉皬涓絓",\"sex\":\"濂砛",\"userCode\":\"03252380\",\"phone\":13723199928,\"isOk\":\"鍚"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"name\":\"闄堟弧蹇僜",\"sex\":\"濂砛",\"userCode\":\"03335415\",\"phone\":13639624533,\"isOk\":\"鏄痋"},{\"jg\":\"鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"鏈鸿閫氫俊鍒嗗眬\",\"name\":\"寮犻瓘寮篭",\"sex\":\"鐢穃",\"userCode\":\"01522560\",\"phone\":13803919688,\"isOk\":\"鏄痋"},{\"jg\":\"瑙ｆ斁鍖哄垎鍏徃\",\"bm\":\"瑙ｆ斁鍖哄垎鍏徃\",\"name\":\"鏉庢晱鏉癨",\"sex\":\"濂砛",\"userCode\":\"01522596\",\"phone\":18236859535,\"isOk\":\"鏄痋"},{\"jg\":\"楂樻柊鍖哄垎鍏徃\",\"bm\":\"楂樻柊鍖哄垎鍏徃\",\"name\":\"鍒樼孩姊匼",\"sex\":\"濂砛",\"userCode\":\"03679240\",\"phone\":15517775737,\"isOk\":\"鏄痋"},{\"jg\":\"淇鍘垮垎鍏徃\",\"bm\":\"淇鍘垮垎鍏徃\",\"name\":\"鎴愯壋闇瀄",\"sex\":\"濂砛",\"userCode\":\"01523336\",\"phone\":13939151863,\"isOk\":\"鍚"},{\"jg\":\"鍗氱埍鍘垮垎鍏徃\",\"bm\":\"鍗氱埍鍘垮垎鍏徃\",\"name\":\"璧垫柊鐢焅",\"sex\":\"鐢穃",\"userCode\":\"01523486\",\"phone\":13839149788,\"isOk\":\"鏄痋"},{\"jg\":\"娌侀槼甯傚垎鍏徃\",\"bm\":\"娌侀槼甯傚垎鍏徃\",\"name\":\"鐜嬫枌\",\"sex\":\"鐢穃",\"userCode\":\"03268284\",\"phone\":13613910732,\"isOk\":\"鍚"},{\"jg\":\"瀛熷窞甯傚垎鍏徃\",\"bm\":\"瀛熷窞甯傚垎鍏徃\",\"name\":\"鐢板畨蹇燶",\"sex\":\"鐢穃",\"userCode\":\"03772928\",\"phone\":13938152349,\"isOk\":\"鏄痋"},{\"jg\":\"娓╁幙鍒嗗叕鍙竆",\"bm\":\"娓╁幙鍒嗗叕鍙竆",\"name\":\"寮犲崰鍐沑",\"sex\":\"鐢穃",\"userCode\":\"01524134\",\"phone\":13839122000,\"isOk\":\"鏄痋"},{\"jg\":\"姝﹂櫉鍘垮垎鍏徃\",\"bm\":\"姝﹂櫉鍘垮垎鍏徃\",\"name\":\"瀛欐枃鍐沑",\"sex\":\"鐢穃",\"userCode\":\"03569319\",\"phone\":15939199904,\"isOk\":\"鍚"}]";
+ Long dqJz = 100008L;
+ Map<String, Object> dqMapJz = new HashMap<>();
+ dqMapJz.put("dq", dqJz);
+ dqMapJz.put("jsonObj", jsonObjJz);
+ selLi.add(dqMapJz);
+
+ // 鍟嗕笜
+ String jsonObjSq = "[{\"jg\":\"鍟嗕笜甯傚尯鍒嗗叕鍙竆",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"瀹嬩咕\",\"sex\":\"濂砛",\"userCode\":\"01530524\",\"phone\":13673708862,\"isOk\":\"鍚"},{\"jg\":\"鍟嗕笜甯傚尯鍒嗗叕鍙竆",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"寮犲姴鏉綷",\"sex\":\"鐢穃",\"userCode\":\"01531091\",\"phone\":13462901736,\"isOk\":\"鏄痋"},{\"jg\":\"鍟嗕笜甯傚尯鍒嗗叕鍙竆",\"bm\":\"甯傚垎鍏徃缁煎悎鍔瀄",\"name\":\"浠诲疂鐝峔",\"sex\":\"濂砛",\"userCode\":\"01530908\",\"phone\":15937069188,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃璐㈠姟閮╘",\"bm\":\"甯傚垎鍏徃璐㈠姟閮╘",\"name\":\"寮犵帀鏌盶",\"sex\":\"鐢穃",\"userCode\":\"03618449\",\"phone\":18137017776,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃浜烘暀閮╘",\"bm\":\"甯傚垎鍏徃浜烘暀閮╘",\"name\":\"寮犳檽鑹砛",\"sex\":\"濂砛",\"userCode\":\"03210927\",\"phone\":13781631208,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃甯傚満閮╘",\"bm\":\"甯傚垎鍏徃甯傚満閮╘",\"name\":\"鑼冩ⅵ鏌痋",\"sex\":\"鐢穃",\"userCode\":\"04104148\",\"phone\":18737037775,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺\",\"bm\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"name\":\"鍚曞崜鍏碶",\"sex\":\"鐢穃",\"userCode\":\"03931926\",\"phone\":18637077718,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"bm\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"name\":\"鑼冭繍鍏碶",\"sex\":\"鐢穃",\"userCode\":\"03271626\",\"phone\":15836857001,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃闆嗛偖涓庣淮鎶や紶濯掗儴\",\"bm\":\"甯傚垎鍏徃闆嗛偖涓庣淮鎶や紶濯掗儴\",\"name\":\"宕斾功寮篭",\"sex\":\"鐢穃",\"userCode\":\"01530899\",\"phone\":13603709601,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"bm\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"name\":\"鐜嬭寽\",\"sex\":\"濂砛",\"userCode\":\"01530920\",\"phone\":15236862588,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈鸿灞�\",\"bm\":\"甯傚垎鍏徃鏈鸿灞�\",\"name\":\"鍛ㄥ己\",\"sex\":\"鐢穃",\"userCode\":\"03347143\",\"phone\":13526329955,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"bm\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"name\":\"璺姃闃砛",\"sex\":\"濂砛",\"userCode\":\"03446939\",\"phone\":15303704567,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃蹇�掑寘瑁归儴\",\"bm\":\"甯傚垎鍏徃蹇�掑寘瑁归儴\",\"name\":\"绋嬫浖\",\"sex\":\"濂砛",\"userCode\":\"03250233\",\"phone\":19139055879,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏍囧噯蹇�掗儴\",\"bm\":\"甯傚垎鍏徃鏍囧噯蹇�掗儴\",\"name\":\"璧靛啝瀹嘰",\"sex\":\"鐢穃",\"userCode\":\"03383431\",\"phone\":18503700905,\"isOk\":\"鍚"},{\"jg\":\"甯傚尯鍒嗗叕鍙竆",\"bm\":\"甯傚尯鍒嗗叕鍙竆",\"name\":\"鏈卞竻\",\"sex\":\"鐢穃",\"userCode\":\"01530863\",\"phone\":13037534321,\"isOk\":\"鏄痋"},{\"jg\":\"姘稿煄甯傚垎鍏徃\",\"bm\":\"姘稿煄甯傚垎鍏徃\",\"name\":\"鍚撮湝\",\"sex\":\"鐢穃",\"userCode\":3630201,\"phone\":13781590766,\"isOk\":\"鏄痋"},{\"jg\":\"澶忛倯鍘垮垎鍏徃\",\"bm\":\"澶忛倯鍘垮垎鍏徃\",\"name\":\"鏉庡崜娲媆",\"sex\":\"鐢穃",\"userCode\":\"04222417\",\"phone\":15713610166,\"isOk\":\"鏄痋"},{\"jg\":\"铏炲煄鍘垮垎鍏徃\",\"bm\":\"铏炲煄鍘垮垎鍏徃\",\"name\":\"璐惧郴宄癨",\"sex\":\"鐢穃",\"userCode\":\"03734792\",\"phone\":13271056969,\"isOk\":\"鏄痋"},{\"jg\":\"閮婂尯鍒嗗叕鍙竆",\"bm\":\"閮婂尯鍒嗗叕鍙竆",\"name\":\"鏉庤繙鏉癨",\"sex\":\"鐢穃",\"userCode\":\"04176514\",\"phone\":13526303157,\"isOk\":\"鏄痋"},{\"jg\":\"鏌樺煄鍘垮垎鍏徃\",\"bm\":\"鏌樺煄鍘垮垎鍏徃\",\"name\":\"闊╅亾姘慭",\"sex\":\"鐢穃",\"userCode\":\"01532380\",\"phone\":13781547966,\"isOk\":\"鏄痋"},{\"jg\":\"瀹侀櫟鍘垮垎鍏徃\",\"bm\":\"瀹侀櫟鍘垮垎鍏徃\",\"name\":\"寰愭墠鍗嶾",\"sex\":\"濂砛",\"userCode\":\"01532663\",\"phone\":15993929910,\"isOk\":\"鏄痋"},{\"jg\":\"鐫㈠幙鍒嗗叕鍙竆",\"bm\":\"鐫㈠幙鍒嗗叕鍙竆",\"name\":\"鏋楄寽\",\"sex\":\"濂砛",\"userCode\":\"03818703\",\"phone\":18037095520,\"isOk\":\"鏄痋"},{\"jg\":\"姘戞潈鍘垮垎鍏徃\",\"bm\":\"姘戞潈鍘垮垎鍏徃\",\"name\":\"姣曚笘绁",\"sex\":\"鐢穃",\"userCode\":\"01533025\",\"phone\":18337066569,\"isOk\":\"鏄痋"}]";
+ Long dqSq = 100013L;
+ Map<String, Object> dqMapSq = new HashMap<>();
+ dqMapSq.put("dq", dqSq);
+ dqMapSq.put("jsonObj", jsonObjSq);
+ selLi.add(dqMapSq);
+
+ // 璁告槍
+ String jsonObjXc = "[{\"jg\":\"寤哄崡鍖哄垎鍏徃\",\"bm\":\"寤哄崡鍖哄垎鍏徃\",\"name\":\"榛勮彶鑿瞈",\"sex\":\"濂砛",\"userCode\":\"03554953\",\"phone\":15638785667,\"isOk\":\"鏄痋"},{\"jg\":\"寤哄寳鍖哄垎鍏徃\",\"bm\":\"寤哄寳鍖哄垎鍏徃\",\"name\":\"闄堣幑鑾筡",\"sex\":\"濂砛",\"userCode\":\"03452284\",\"phone\":18864680605,\"isOk\":\"鏄痋"},{\"jg\":\"闀胯憶甯傚垎鍏徃\",\"bm\":\"闀胯憶甯傚垎鍏徃\",\"name\":\"寮犲缓鍐淺",\"sex\":\"鐢穃",\"userCode\":\"01528570\",\"phone\":15136823766,\"isOk\":\"鏄痋"},{\"jg\":\"绂瑰窞甯傚垎鍏徃\",\"bm\":\"绂瑰窞甯傚垎鍏徃\",\"name\":\"璧电户浼焅",\"sex\":\"鐢穃",\"userCode\":\"01528248\",\"phone\":13639666968,\"isOk\":\"鏄痋"},{\"jg\":\"閯㈤櫟鍘垮垎鍏徃\",\"bm\":\"閯㈤櫟鍘垮垎鍏徃\",\"name\":\"椹瘏椋瀄",\"sex\":\"鐢穃",\"userCode\":\"03424227\",\"phone\":13598975685,\"isOk\":\"鏄痋"},{\"jg\":\"寤哄畨鍖哄垎鍏徃\",\"bm\":\"寤哄畨鍖哄垎鍏徃\",\"name\":\"瀹嬩簹\",\"sex\":\"鐢穃",\"userCode\":\"03463083\",\"phone\":15617222699,\"isOk\":\"鏄痋"},{\"jg\":\"瑗勫煄鍘垮垎鍏徃\",\"bm\":\"瑗勫煄鍘垮垎鍏徃\",\"name\":\"涓佷簹濞焅",\"sex\":\"濂砛",\"userCode\":\"01528695\",\"phone\":13409389827,\"isOk\":\"鏄痋"},{\"jg\":\"璁告槍甯傚垎鍏徃\",\"bm\":\"璁告槍甯傚垎鍏徃\",\"name\":\"钁涢\",\"sex\":\"鐢穃",\"userCode\":\"01528228\",\"phone\":15936376880,\"isOk\":\"鏄痋"},{\"jg\":\"甯傚垎鍏徃璐㈠姟閮╘",\"bm\":\"甯傚垎鍏徃璐㈠姟閮╘",\"name\":\"寰愮礌璐瀄",\"sex\":\"濂砛",\"userCode\":\"01528921\",\"phone\":15603743166,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"bm\":\"甯傚垎鍏徃甯傚満钀ラ攢閮╘",\"name\":\"闄堟槬绾",\"sex\":\"濂砛",\"userCode\":\"01527674\",\"phone\":15603899126,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"bm\":\"甯傚垎鍏徃浜哄姏璧勬簮閮╘",\"name\":\"鏇硅緣\",\"sex\":\"鐢穃",\"userCode\":\"03829538\",\"phone\":15503743300,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"甯傚垎鍏徃鏈嶅姟璐ㄩ噺閮╘",\"name\":\"搴风礌鏄嶾",\"sex\":\"鐢穃",\"userCode\":\"01527887\",\"phone\":18837411185,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍏氬缓宸ヤ綔閮╘",\"bm\":\"甯傚垎鍏徃鍏氬缓宸ヤ綔閮╘",\"name\":\"寮犱腹鍗塡",\"sex\":\"濂砛",\"userCode\":\"03829542\",\"phone\":15037446316,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"bm\":\"甯傚垎鍏徃閲戣瀺涓氬姟閮╘",\"name\":\"璧甸\",\"sex\":\"鐢穃",\"userCode\":\"01527748\",\"phone\":18503741197,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"bm\":\"甯傚垎鍏徃娓犻亾骞冲彴閮╘",\"name\":\"闃磋敋妗刓",\"sex\":\"鐢穃",\"userCode\":\"03785422\",\"phone\":18530916215,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"甯傚垎鍏徃闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"楂樻櫒宄癨",\"sex\":\"鐢穃",\"userCode\":\"03167465\",\"phone\":18697378101,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"甯傚垎鍏徃鏈鸿閫氫俊鍒嗗眬\",\"name\":\"寰愬織宄癨",\"sex\":\"鐢穃",\"userCode\":\"01527726\",\"phone\":13598999166,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"bm\":\"甯傚垎鍏徃杩愯惀绠＄悊閮╘",\"name\":\"鑻忔瘏\",\"sex\":\"鐢穃",\"userCode\":\"01527616\",\"phone\":18623809688,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鐗瑰揩璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鐗瑰揩璐ｄ换涓績\",\"name\":\"鐜嬮潤\",\"sex\":\"濂砛",\"userCode\":\"01528057\",\"phone\":15603895177,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃蹇寘璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃蹇寘璐ｄ换涓績\",\"name\":\"宕旀枃濂嶾",\"sex\":\"鐢穃",\"userCode\":\"01527891\",\"phone\":\"187374031113\",\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鍥介檯璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鍥介檯璐ｄ换涓績\",\"name\":\"鐜嬩附涓絓",\"sex\":\"濂砛",\"userCode\":\"03890009\",\"phone\":18737418298,\"isOk\":\"鍚"},{\"jg\":\"甯傚垎鍏徃鐗╂祦璐ｄ换涓績\",\"bm\":\"甯傚垎鍏徃鐗╂祦璐ｄ换涓績\",\"name\":\"绋嬫槦\",\"sex\":\"濂砛",\"userCode\":\"03965374\",\"phone\":15638781678,\"isOk\":\"鍚"}]";
+ Long dqXc = 100010L;
+ Map<String, Object> dqMapXc = new HashMap<>();
+ dqMapXc.put("dq", dqXc);
+ dqMapXc.put("jsonObj", jsonObjXc);
+ selLi.add(dqMapXc);
+
+
+ // 瀹夐槼
+ String jsonObjAy = "[{\"jg\":\"璐㈠姟閮╘",\"bm\":\"璐㈠姟閮╘",\"name\":\"鐢版尟浼焅",\"sex\":\"鐢穃",\"userCode\":\"03252092\",\"phone\":18537205062,\"isOk\":\"鏄痋"},{\"jg\":\"甯傚満钀ラ攢閮╘",\"bm\":\"甯傚満钀ラ攢閮╘",\"name\":\"寮犳収濞淺",\"sex\":\"濂砛",\"userCode\":\"01517434\",\"phone\":18537201686,\"isOk\":\"\"},{\"jg\":\"瀹夐槼甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"鐜嬬撼\",\"sex\":\"濂砛",\"userCode\":\"01516979\",\"phone\":13937208056,\"isOk\":\"\"},{\"jg\":\"浜哄姏璧勬簮閮╘",\"bm\":\"浜哄姏璧勬簮閮╘",\"name\":\"甯镐竾鍒‐",\"sex\":\"濂砛",\"userCode\":\"03688129\",\"phone\":15836365600,\"isOk\":\"\"},{\"jg\":\"鍏氬鍏氬缓宸ヤ綔閮╘",\"bm\":\"鍏氬鍏氬缓宸ヤ綔閮╘",\"name\":\"璁歌悕\",\"sex\":\"濂砛",\"userCode\":\"03963493\",\"phone\":18537206571,\"isOk\":\"\"},{\"jg\":\"绾鍔炲叕瀹",\"bm\":\"绾鍔炲叕瀹",\"name\":\"寮犳湅浼焅",\"sex\":\"鐢穃",\"userCode\":\"01517482\",\"phone\":18537205283,\"isOk\":\"\"},{\"jg\":\"鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"鏈嶅姟璐ㄩ噺閮╘",\"name\":\"寮犳洣\",\"sex\":\"濂砛",\"userCode\":\"03894377\",\"phone\":18503721669,\"isOk\":\"\"},{\"jg\":\"閲戣瀺涓氬姟閮╘",\"bm\":\"閲戣瀺涓氬姟閮╘",\"name\":\"寮犺濞淺",\"sex\":\"濂砛",\"userCode\":\"01525739\",\"phone\":18537201813,\"isOk\":\"\"},{\"jg\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"鏉滅憺寮篭",\"sex\":\"鐢穃",\"userCode\":\"01515685\",\"phone\":17603721968,\"isOk\":\"\"},{\"jg\":\"娓犻亾骞冲彴閮╘",\"bm\":\"娓犻亾骞冲彴閮╘",\"name\":\"鏉ㄧ孩\",\"sex\":\"濂砛",\"userCode\":\"01517259\",\"phone\":18037299990,\"isOk\":\"\"},{\"jg\":\"鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"鏈鸿閫氫俊鍒嗗眬\",\"name\":\"钁ｅ潳\",\"sex\":\"鐢穃",\"userCode\":\"03696188\",\"phone\":18567721602,\"isOk\":\"\"},{\"jg\":\"宸ヤ細\",\"bm\":\"宸ヤ細\",\"name\":\"鐜嬪埄钀峔",\"sex\":\"濂砛",\"userCode\":\"01516973\",\"phone\":17698303900,\"isOk\":\"\"},{\"jg\":\"瀵勯�掍簨涓氶儴\",\"bm\":\"瀵勯�掍簨涓氶儴\",\"name\":\"閮懢鐝慭",\"sex\":\"鐢穃",\"userCode\":1515825,\"phone\":18837215926,\"isOk\":\"\"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"name\":\"浠昏崳濞淺",\"sex\":\"濂砛",\"userCode\":\"03776328\",\"phone\":15836322356,\"isOk\":\"\"},{\"jg\":\"杩愯惀绠＄悊閮╘",\"bm\":\"杩愯惀绠＄悊閮╘",\"name\":\"鐗涙枃闈橽",\"sex\":\"濂砛",\"userCode\":\"03559114\",\"phone\":13523325066,\"isOk\":\"\"},{\"jg\":\"瀹夐槼鍘垮垎鍏徃\",\"bm\":\"瀹夐槼鍘垮垎鍏徃\",\"name\":\"瀹嬬拠\",\"sex\":\"濂砛",\"userCode\":\"03363695\",\"phone\":13683722950,\"isOk\":\"\"},{\"jg\":\"鏋楀窞甯傚垎鍏徃\",\"bm\":\"鏋楀窞甯傚垎鍏徃\",\"name\":\"閭撴檽鏋梊",\"sex\":\"濂砛",\"userCode\":\"03363779\",\"phone\":13673722927,\"isOk\":\"鏄痋"},{\"jg\":\"婊戝幙鍒嗗叕鍙竆",\"bm\":\"婊戝幙鍒嗗叕鍙竆",\"name\":\"閭垫箾娲媆",\"sex\":\"鐢穃",\"userCode\":\"03347421\",\"phone\":18537205255,\"isOk\":\"鏄痋"},{\"jg\":\"鍐呴粍鍘垮垎鍏徃\",\"bm\":\"鍐呴粍鍘垮垎鍏徃\",\"name\":\"鏉庡笇鍫俓",\"sex\":\"鐢穃",\"userCode\":\"01516257\",\"phone\":13613728836,\"isOk\":\"鏄痋"},{\"jg\":\"姹ら槾鍘垮垎鍏徃\",\"bm\":\"姹ら槾鍘垮垎鍏徃\",\"name\":\"杩炴ⅵ\",\"sex\":\"濂砛",\"userCode\":\"03364262\",\"phone\":15993801114,\"isOk\":\"鏄痋"},{\"jg\":\"榫欏畨鍖哄垎鍏徃\",\"bm\":\"榫欏畨鍖哄垎鍏徃\",\"name\":\"鏉庡織濞淺",\"sex\":\"濂砛",\"userCode\":\"01516312\",\"phone\":13460821473,\"isOk\":\"鏄痋"},{\"jg\":\"鏂囧嘲鍖哄垎鍏徃\",\"bm\":\"鏂囧嘲鍖哄垎鍏徃\",\"name\":\"鍒樺ぇ浼焅",\"sex\":\"鐢穃",\"userCode\":\"03994629\",\"phone\":18537200905,\"isOk\":\"鏄痋"}]";
+ Long dqAy = 100005L;
+ Map<String, Object> dqMapAy = new HashMap<>();
+ dqMapAy.put("dq", dqAy);
+ dqMapAy.put("jsonObj", jsonObjAy);
+ selLi.add(dqMapAy);
+
+
+ // 鍛ㄥ彛
+ String jsonObjZk = "[{\"jg\":\"鍛ㄥ彛甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"鐜嬪磭鍏塡",\"sex\":\"鐢穃",\"userCode\":\"03696337\",\"phone\":18272856661,\"isOk\":\"鏄痋"},{\"jg\":\"甯傚垎鍏徃璐㈠姟閮╘",\"bm\":\"甯傚垎鍏徃璐㈠姟閮╘",\"name\":\"鐜嬫シ鏂嘰",\"sex\":\"鐢穃",\"userCode\":\"04195483\",\"phone\":15503942999,\"isOk\":\"\"}]";
+ Long dqZk = 100014L;
+ Map<String, Object> dqMapZk = new HashMap<>();
+ dqMapZk.put("dq", dqZk);
+ dqMapZk.put("jsonObj", jsonObjZk);
+ selLi.add(dqMapZk);
+
+ // 寮�灏�
+ String jsonObjKf = "[{\"jg\":\"寮�灏佸競瀹嬪煄鍖哄垎鍏徃\",\"bm\":\"瀹嬪煄鍖哄垎鍏徃\",\"name\":\"鐜嬬惓\",\"sex\":\"濂砛",\"userCode\":\"01508234\",\"phone\":13723227800,\"isOk\":\"鏄痋"},{\"jg\":\"寮�灏佸競鏂板尯鍒嗗叕鍙竆",\"bm\":\"鏂板尯鍒嗗叕鍙竆",\"name\":\"鏌存櫠\",\"sex\":\"濂砛",\"userCode\":\"01508342\",\"phone\":13903787795,\"isOk\":\"鏄痋"},{\"jg\":\"鏉炲幙鍒嗗叕鍙竆",\"bm\":\"鏉炲幙鍒嗗叕鍙竆",\"name\":\"鏉ㄦ案姘慭",\"sex\":\"鐢穃",\"userCode\":\"01508854\",\"phone\":\"13937804028\",\"isOk\":\"鏄痋"},{\"jg\":\"閫氳鍘垮垎鍏徃\",\"bm\":\"閫氳鍘垮垎鍏徃\",\"name\":\"鏉庡崼\",\"sex\":\"鐢穃",\"userCode\":\"03283795\",\"phone\":13781114087,\"isOk\":\"鏄痋"},{\"jg\":\"灏夋皬鍘垮垎鍏徃\",\"bm\":\"灏夋皬鍘垮垎鍏徃\",\"name\":\"閮庢収涓絓",\"sex\":\"濂砛",\"userCode\":\"01509234\",\"phone\":13569532629,\"isOk\":\"鏄痋"},{\"jg\":\"寮�灏佸競绁ョ鍖哄垎鍏徃\",\"bm\":\"绁ョ鍖哄垎鍏徃\",\"name\":\"鍒樻案闈抃",\"sex\":\"鐢穃",\"userCode\":\"01509525\",\"phone\":13903785580,\"isOk\":\"鏄痋"},{\"jg\":\"鍏拌�冨幙鍒嗗叕鍙竆",\"bm\":\"鍏拌�冨幙鍒嗗叕鍙竆",\"name\":\"榛勮繛褰琝",\"sex\":\"鐢穃",\"userCode\":\"03339498\",\"phone\":13663788616,\"isOk\":\"鏄痋"},{\"jg\":\"寮�灏佸競鍒嗗叕鍙竆",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"姊佹枌\",\"sex\":\"鐢穃",\"userCode\":\"03822830\",\"phone\":15093636828,\"isOk\":\"鏄痋"},{\"jg\":\"甯傚満钀ラ攢閮╘",\"bm\":\"甯傚満钀ラ攢閮╘",\"name\":\"鐜嬫槑纾奬",\"sex\":\"鐢穃",\"userCode\":\"01508449\",\"phone\":13603786979,\"isOk\":\"鏄痋"},{\"jg\":\"杩愯惀绠＄悊閮╘",\"bm\":\"杩愯惀绠＄悊閮╘",\"name\":\"鐜嬪摬\",\"sex\":\"鐢穃",\"userCode\":\"03208163\",\"phone\":13183258252,\"isOk\":\"鏄痋"},{\"jg\":\"鍏氬缓宸ヤ綔閮╘",\"bm\":\"鍏氬缓宸ヤ綔閮╘",\"name\":\"姊佷箰姘慭",\"sex\":\"鐢穃",\"userCode\":\"04204505\",\"phone\":13693786373,\"isOk\":\"鍚"},{\"jg\":\"璐㈠姟閮╘",\"bm\":\"璐㈠姟閮╘",\"name\":\"鍒橀湠\",\"sex\":\"濂砛",\"userCode\":\"01508087\",\"phone\":13837818346,\"isOk\":\"鍚"},{\"jg\":\"鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"鏈嶅姟璐ㄩ噺閮╘",\"name\":\"寮犱功鐜瞈",\"sex\":\"濂砛",\"userCode\":\"01504635\",\"phone\":13723239080,\"isOk\":\"鍚"},{\"jg\":\"浜哄姏璧勬簮閮╘",\"bm\":\"浜哄姏璧勬簮閮╘",\"name\":\"鐜嬬憺濂嘰",\"sex\":\"鐢穃",\"userCode\":\"03830615\",\"phone\":13525588969,\"isOk\":\"鍚"},{\"jg\":\"閲戣瀺涓氬姟閮╘",\"bm\":\"閲戣瀺涓氬姟閮╘",\"name\":\"璧靛簡鐝峔",\"sex\":\"鐢穃",\"userCode\":\"01508183\",\"phone\":13837819091,\"isOk\":\"鍚"},{\"jg\":\"娓犻亾骞冲彴閮╘",\"bm\":\"娓犻亾骞冲彴閮╘",\"name\":\"闄堥\",\"sex\":\"濂砛",\"userCode\":\"01508609\",\"phone\":13303786200,\"isOk\":\"鍚"},{\"jg\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"鏉庡浆\",\"sex\":\"濂砛",\"userCode\":\"01508579\",\"phone\":13723251609,\"isOk\":\"鍚"},{\"jg\":\"蹇�掑寘瑁逛笓涓氳矗浠讳腑蹇僜",\"bm\":\"蹇�掑寘瑁逛笓涓氳矗浠讳腑蹇僜",\"name\":\"寰愪腹涓筡",\"sex\":\"濂砛",\"userCode\":\"03283761\",\"phone\":18837868981,\"isOk\":\"鍚"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇僜",\"name\":\"娌欐槺鏄昞",\"sex\":\"濂砛",\"userCode\":\"03964580\",\"phone\":18736998885,\"isOk\":\"鍚"},{\"jg\":\"鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"鏈鸿閫氫俊鍒嗗眬\",\"name\":\"鐜嬩笘鏉癨",\"sex\":\"鐢穃",\"userCode\":\"03534994\",\"phone\":13633783888,\"isOk\":\"鍚"}]";
+ Long dqKf = 100002L;
+ Map<String, Object> dqMapKf = new HashMap<>();
+ dqMapKf.put("dq", dqKf);
+ dqMapKf.put("jsonObj", jsonObjKf);
+ selLi.add(dqMapKf);
+
+ // 楣ゅ
+ String jsonObjHb = "[{\"jg\":\"璐㈠姟閮╘",\"bm\":\"璐㈠姟閮╘",\"name\":\"鑰垮畧鏁廫",\"sex\":\"鐢穃",\"userCode\":\"03250361\",\"phone\":15839278086,\"isOk\":\"鏄痋"},{\"jg\":\"楣ゅ甯傚北鍩庡尯鍒嗗叕鍙竆",\"bm\":\"灞卞煄鍖哄垎鍏徃\",\"name\":\"渚晩骞砛",\"sex\":\"濂砛",\"userCode\":\"01518070\",\"phone\":13839237558,\"isOk\":\"鏄痋"},{\"jg\":\"娣囧幙鍒嗗叕鍙竆",\"bm\":\"娣囧幙鍒嗗叕鍙竆",\"name\":\"鐜嬪崕浼焅",\"sex\":\"濂砛",\"userCode\":\"01518185\",\"phone\":13938007161,\"isOk\":\"鏄痋"},{\"jg\":\"娴氬幙鍒嗗叕鍙竆",\"bm\":\"娴氬幙鍒嗗叕鍙竆",\"name\":\"鑳℃案缈燶",\"sex\":\"濂砛",\"userCode\":\"01518249\",\"phone\":13939225206,\"isOk\":\"鏄痋"},{\"jg\":\"楣ゅ甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"娆ч槼鑿茶彶\",\"sex\":\"濂砛",\"userCode\":\"03345239\",\"phone\":16650981118,\"isOk\":\"鍚"},{\"jg\":\"鏍囧揩涓撲笟璐ｄ换涓績\",\"bm\":\"鏍囧揩涓撲笟璐ｄ换涓績\",\"name\":\"寮犺景\",\"sex\":\"鐢穃",\"userCode\":\"03536206\",\"phone\":13939208755,\"isOk\":\"鍚"},{\"jg\":\"鍏氬缓閮╘",\"bm\":\"鍏氬缓閮╘",\"name\":\"瀛欒壋骞砛",\"sex\":\"濂砛",\"userCode\":\"01517919\",\"phone\":13461901899,\"isOk\":\"鍚"},{\"jg\":\"宸ヤ細\",\"bm\":\"宸ヤ細\",\"name\":\"鐗涢洦绾",\"sex\":\"鐢穃",\"userCode\":\"01517765\",\"phone\":18503923777,\"isOk\":\"鍚"},{\"jg\":\"涓夌骇鐗╂祦寤鸿涓撶彮\",\"bm\":\"涓夌骇鐗╂祦寤鸿涓撶彮\",\"name\":\"杩愬\",\"sex\":\"鐢穃",\"userCode\":\"03384784\",\"phone\":13503920298,\"isOk\":\"鍚"},{\"jg\":\"蹇寘涓撲笟璐ｄ换涓績\",\"bm\":\"蹇寘涓撲笟璐ｄ换涓績\",\"name\":\"鐜嬬濮擻",\"sex\":\"鐢穃",\"userCode\":\"03391904\",\"phone\":15839279495,\"isOk\":\"鍚"},{\"jg\":\"甯傚満钀ラ攢閮╘",\"bm\":\"甯傚満钀ラ攢閮╘",\"name\":\"鍚曚節浼焅",\"sex\":\"濂砛",\"userCode\":\"01518041\",\"phone\":13839229519,\"isOk\":\"鍚"},{\"jg\":\"甯傚満钀ラ攢閮ㄤ俊鎭腑蹇僜",\"bm\":\"甯傚満钀ラ攢閮ㄤ俊鎭腑蹇僜",\"name\":\"鍒樻枃绉慭",\"sex\":\"鐢穃",\"userCode\":\"01517803\",\"phone\":13939227075,\"isOk\":\"鍚"},{\"jg\":\"娓犻亾骞冲彴閮╘",\"bm\":\"娓犻亾骞冲彴閮╘",\"name\":\"寮犲潳\",\"sex\":\"濂砛",\"userCode\":\"03536279\",\"phone\":18539221025,\"isOk\":\"鍚"},{\"jg\":\"杩愯惀绠＄悊閮╘",\"bm\":\"杩愯惀绠＄悊閮╘",\"name\":\"鏉庨潤\",\"sex\":\"濂砛",\"userCode\":\"03316271\",\"phone\":13103920166,\"isOk\":\"鍚"},{\"jg\":\"闆嗛偖鏂囦紶閮╘",\"bm\":\"闆嗛偖鏂囦紶閮╘",\"name\":\"鍒樿姵鑺砛",\"sex\":\"濂砛",\"userCode\":\"01517915\",\"phone\":13803921616,\"isOk\":\"鍚"},{\"jg\":\"鏈鸿閫氫俊鍒嗗眬\",\"bm\":\"鏈鸿閫氫俊鍒嗗眬\",\"name\":\"鏉庡\",\"sex\":\"濂砛",\"userCode\":\"01517818\",\"phone\":15939228101,\"isOk\":\"鍚"},{\"jg\":\"閲戣瀺涓氬姟閮╘",\"bm\":\"閲戣瀺涓氬姟閮╘",\"name\":\"寮犵鑺筡",\"sex\":\"濂砛",\"userCode\":\"01517988\",\"phone\":13503925545,\"isOk\":\"鍚"}]";
+ Long dqHb = 100006L;
+ Map<String, Object> dqMapHb = new HashMap<>();
+ dqMapHb.put("dq", dqHb);
+ dqMapHb.put("jsonObj", jsonObjHb);
+ selLi.add(dqMapHb);
+
+ // 鍗楅槼
+ String jsonObjNy = "[{\"jg\":\"鍐呬埂鍘垮垎鍏徃\",\"bm\":\"鍐呬埂鍘垮垎鍏徃\",\"name\":\"鑳℃鏈圽",\"sex\":\"濂砛",\"userCode\":\"03197169\",\"phone\":13849771844,\"isOk\":\"鏄痋"}]";
+ Long dqNy = 100016L;
+ Map<String, Object> dqMapNy = new HashMap<>();
+ dqMapNy.put("dq", dqNy);
+ dqMapNy.put("jsonObj", jsonObjNy);
+ selLi.add(dqMapNy);
+
+ // 閮戝窞
+ String jsonObjZz = "[{\"jg\":\"閮戝窞甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"灏氱户杈塡",\"sex\":\"鐢穃",\"userCode\":\"01505364\",\"phone\":13290909080,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"璧典繆闇瀄",\"sex\":\"濂砛",\"userCode\":\"03450133\",\"phone\":15093121116,\"isOk\":\"鏄痋"},{\"jg\":\"鐧诲皝甯傚垎鍏徃\",\"bm\":\"鐧诲皝甯傚垎鍏徃\",\"name\":\"寮犲悜娉",\"sex\":\"鐢穃",\"userCode\":\"01507299\",\"phone\":13674996555,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯備簩涓冨尯鍒嗗叕鍙竆",\"bm\":\"浜屼竷鍖哄垎鍏徃\",\"name\":\"鍐粔娉",\"sex\":\"鐢穃",\"userCode\":\"03215147\",\"phone\":18703877216,\"isOk\":\"鏄痋"},{\"jg\":\"鑸┖娓尯鍒嗗叕鍙竆",\"bm\":\"鑸┖娓尯鍒嗗叕鍙竆",\"name\":\"瑁村啲涓絓",\"sex\":\"濂砛",\"userCode\":\"03214857\",\"phone\":15890039721,\"isOk\":\"鏄痋"},{\"jg\":\"鑽ラ槼甯傚垎鍏徃\",\"bm\":\"鑽ラ槼甯傚垎鍏徃\",\"name\":\"寮犲埄鏁廫",\"sex\":\"濂砛",\"userCode\":\"01506479\",\"phone\":13838200289,\"isOk\":\"鏄痋"},{\"jg\":\"楂樻柊鍖哄垎鍏徃\",\"bm\":\"楂樻柊鍖哄垎鍏徃\",\"name\":\"鍛ㄧ弬\",\"sex\":\"鐢穃",\"userCode\":\"01505545\",\"phone\":16696139776,\"isOk\":\"鏄痋"},{\"jg\":\"宸╀箟甯傚垎鍏徃\",\"bm\":\"宸╀箟甯傚垎鍏徃\",\"name\":\"寮犳枃宄癨",\"sex\":\"鐢穃",\"userCode\":\"01507008\",\"phone\":13526492666,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傜鍩庡尯鍒嗗叕鍙竆",\"bm\":\"绠″煄鍖哄垎鍏徃\",\"name\":\"瀛熻懙棣橽",\"sex\":\"濂砛",\"userCode\":\"01505026\",\"phone\":13938449798,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傞噾姘村尯鍒嗗叕鍙竆",\"bm\":\"閲戞按鍖哄垎鍏徃\",\"name\":\"闄堟竻鏅揬",\"sex\":\"鐢穃",\"userCode\":\"03462630\",\"phone\":18638111088,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傞儜涓滄柊鍖哄垎鍏徃\",\"bm\":\"閮戜笢鏂板尯鍒嗗叕鍙竆",\"name\":\"璁哥孩涓絓",\"sex\":\"濂砛",\"userCode\":\"01520886\",\"phone\":18838160016,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傛儬娴庡尯鍒嗗叕鍙竆",\"bm\":\"鎯犳祹鍖哄垎鍏徃\",\"name\":\"楂樹匠鍥璡",\"sex\":\"濂砛",\"userCode\":\"04106414\",\"phone\":18837125186,\"isOk\":\"鏄痋"},{\"jg\":\"鏂板瘑甯傚垎鍏徃\",\"bm\":\"鏂板瘑甯傚垎鍏徃\",\"name\":\"鍚曠孩寤篭",\"sex\":\"鐢穃",\"userCode\":\"01507671\",\"phone\":15903656888,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯傜粡寮�鍖哄垎鍏徃\",\"bm\":\"缁忓紑鍖哄垎鍏徃\",\"name\":\"閭㈢嚉鏂怽",\"sex\":\"濂砛",\"userCode\":\"03602293\",\"phone\":13460306010,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯備笂琛楀尯鍒嗗叕鍙竆",\"bm\":\"涓婅鍖哄垎鍏徃\",\"name\":\"璋开\",\"sex\":\"濂砛",\"userCode\":\"03214836\",\"phone\":13523560390,\"isOk\":\"鏄痋"},{\"jg\":\"鏂伴儜甯傚垎鍏徃\",\"bm\":\"鏂伴儜甯傚垎鍏徃\",\"name\":\"缈熷啝娣瀄",\"sex\":\"鐢穃",\"userCode\":\"04217531\",\"phone\":13073752678,\"isOk\":\"鏄痋"},{\"jg\":\"涓墴鍘垮垎鍏徃\",\"bm\":\"涓墴鍘垮垎鍏徃\",\"name\":\"寮犻搧鏌盶",\"sex\":\"鐢穃",\"userCode\":\"01506613\",\"phone\":13503998993,\"isOk\":\"鏄痋"},{\"jg\":\"閮戝窞甯備腑鍘熷尯鍒嗗叕鍙竆",\"bm\":\"涓師鍖哄垎鍏徃\",\"name\":\"娌堟磥\",\"sex\":\"濂砛",\"userCode\":\"01505480\",\"phone\":13526705533,\"isOk\":\"鏄痋"},{\"jg\":\"涓夌骇鐗╂祦浣撶郴寤鸿涓撶彮\",\"bm\":\"涓夌骇鐗╂祦浣撶郴寤鸿涓撶彮\",\"name\":\"鑳′竴鍑",\"sex\":\"濂砛",\"userCode\":\"04196065\",\"phone\":13838240632,\"isOk\":\"鍚"},{\"jg\":\"璐㈠姟閮╘",\"bm\":\"璐㈠姟閮╘",\"name\":\"鏉庝附\",\"sex\":\"濂砛",\"userCode\":\"01503172\",\"phone\":13676927766,\"isOk\":\"鍚"},{\"jg\":\"鍏氬缓宸ヤ綔閮╘",\"bm\":\"鍏氬缓宸ヤ綔閮╘",\"name\":\"寮犲В濮",\"sex\":\"濂砛",\"userCode\":\"03685389\",\"phone\":15637259837,\"isOk\":\"鍚"},{\"jg\":\"宸ヤ細\",\"bm\":\"宸ヤ細\",\"name\":\"鑼冩槬濞淺",\"sex\":\"濂砛",\"userCode\":\"01506805\",\"phone\":15036068866,\"isOk\":\"鍚"},{\"jg\":\"閲戣瀺涓氬姟閮╘",\"bm\":\"閲戣瀺涓氬姟閮╘",\"name\":\"瀛欐湞杈塡",\"sex\":\"鐢穃",\"userCode\":\"01505263\",\"phone\":13700840185,\"isOk\":\"鍚"},{\"jg\":\"娓犻亾骞冲彴閮╘",\"bm\":\"娓犻亾骞冲彴閮╘",\"name\":\"鐜嬫晱\",\"sex\":\"濂砛",\"userCode\":\"03250707\",\"phone\":13783588184,\"isOk\":\"鍚"},{\"jg\":\"浜哄姏璧勬簮閮╘",\"bm\":\"浜哄姏璧勬簮閮╘",\"name\":\"璐鹃缚\",\"sex\":\"濂砛",\"userCode\":\"03680698\",\"phone\":15837136612,\"isOk\":\"鍚"},{\"jg\":\"甯傚満钀ラ攢閮╘",\"bm\":\"甯傚満钀ラ攢閮╘",\"name\":\"鍒樺崏\",\"sex\":\"濂砛",\"userCode\":\"03231040\",\"phone\":13676970012,\"isOk\":\"鍚"},{\"jg\":\"绾鍔炲叕瀹",\"bm\":\"绾鍔炲叕瀹",\"name\":\"鑼冨厗搴穃",\"sex\":\"鐢穃",\"userCode\":\"03791229\",\"phone\":13643820645,\"isOk\":\"鍚"},{\"jg\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"bm\":\"闆嗛偖涓庢枃鍖栦紶濯掗儴\",\"name\":\"璐捐摀\",\"sex\":\"濂砛",\"userCode\":\"03215066\",\"phone\":13503719775,\"isOk\":\"鍚"},{\"jg\":\"鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"鏈嶅姟璐ㄩ噺閮╘",\"name\":\"濮滃叞\",\"sex\":\"濂砛",\"userCode\":\"01505069\",\"phone\":13523410345,\"isOk\":\"鍚"},{\"jg\":\"鏈嶅姟璐ㄩ噺閮╘",\"bm\":\"鏈嶅姟璐ㄩ噺閮╘",\"name\":\"鑻忔枃鏂嘰",\"sex\":\"濂砛",\"userCode\":\"03964570\",\"phone\":18569922944,\"isOk\":\"鍚"},{\"jg\":\"閮戝窞甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"濮腑鐓淺",\"sex\":\"鐢穃",\"userCode\":\"01503072\",\"phone\":13523711960,\"isOk\":\"鍚"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冩斂鍔¤惀閿�涓績\",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冩斂鍔¤惀閿�涓績\",\"name\":\"寮犳偊\",\"sex\":\"濂砛",\"userCode\":\"03911249\",\"phone\":15713716192,\"isOk\":\"鍚"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冨晢浼佽惀閿�涓績\",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冨晢浼佽惀閿�涓績\",\"name\":\"浠樻枃闈橽",\"sex\":\"濂砛",\"userCode\":\"03687135\",\"phone\":13103861988,\"isOk\":\"鍚"},{\"jg\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冪渷韬唤璇侀」鐩甛",\"bm\":\"鏍囧噯蹇�掍笓涓氳矗浠讳腑蹇冪渷韬唤璇侀」鐩甛",\"name\":\"寰愯█\",\"sex\":\"鐢穃",\"userCode\":\"03897314\",\"phone\":15838172020,\"isOk\":\"鍚"}]";
+ Long dqZz = 100001L;
+ Map<String, Object> dqMapZz = new HashMap<>();
+ dqMapZz.put("dq", dqZz);
+ dqMapZz.put("jsonObj", jsonObjZz);
+ selLi.add(dqMapZz);
+
+ // 淇￠槼
+ String jsonObjXy = "[{\"jg\":\"淇￠槼甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"璁告槬鍏塡",\"sex\":\"鐢穃",\"userCode\":\"01543085\",\"phone\":16637666376,\"isOk\":\"鍚︼紙璇烽绠＄悊浜哄憳锛塡"},{\"jg\":\"淇￠槼甯傚垎鍏徃\",\"bm\":\"缁煎悎鍔炲叕瀹",\"name\":\"鐜嬮箯\",\"sex\":\"鐢穃",\"userCode\":\"03498941\",\"phone\":13937611122,\"isOk\":\"鏄痋"},{\"jg\":\"鎭幙鍒嗗叕鍙竆",\"bm\":\"鎭幙鍒嗗叕鍙竆",\"name\":\"鏉庢槉鐝篭",\"sex\":\"鐢穃",\"userCode\":\"04207355\",\"phone\":13333766366,\"isOk\":\"鏄痋"},{\"jg\":\"娼㈠窛鍘垮垎鍏徃\",\"bm\":\"娼㈠窛鍘垮垎鍏徃\",\"name\":\"璋粊娴‐",\"sex\":\"鐢穃",\"userCode\":\"03680127\",\"phone\":18211700252,\"isOk\":\"鏄痋"},{\"jg\":\"鍏夊北鍘垮垎鍏徃\",\"bm\":\"鍏夊北鍘垮垎鍏徃\",\"name\":\"鏉滅櫥鏂癨",\"sex\":\"鐢穃",\"userCode\":\"01544502\",\"phone\":18697730280,\"isOk\":\"鏄痋"},{\"jg\":\"淇￠槼甯傞儕鍖哄垎鍏徃\",\"bm\":\"淇￠槼甯傞儕鍖哄垎鍏徃\",\"name\":\"鍚存枌\",\"sex\":\"鐢穃",\"userCode\":\"01544712\",\"phone\":13603768697,\"isOk\":\"鏄痋"},{\"jg\":\"閮婂尯鍒嗗叕鍙竆",\"bm\":\"娌冲崡鐪佷俊闃冲競鍟嗗煄鍘垮垎鍏徃\",\"name\":\"鏉ㄩ\",\"sex\":\"鐢穃",\"userCode\":\"01545654\",\"phone\":13837623456,\"isOk\":\"鏄痋"},{\"jg\":\"鍥哄鍘垮垎鍏徃\",\"bm\":\"鍥哄鍘垮垎鍏徃\",\"name\":\"鏈卞\",\"sex\":\"濂砛",\"userCode\":\"03300918\",\"phone\":13723108456,\"isOk\":\"鏄痋"},{\"jg\":\"鏂板幙鍒嗗叕鍙竆",\"bm\":\"鏂板幙鍒嗗叕鍙竆",\"name\":\"涓ヨ悕\",\"sex\":\"濂砛",\"userCode\":\"03473775\",\"phone\":15194491404,\"isOk\":\"鏄痋"},{\"jg\":\"缃楀北鍘垮垎鍏徃\",\"bm\":\"缃楀北鍘垮垎鍏徃\",\"name\":\"鍚曢敗浜甛",\"sex\":\"鐢穃",\"userCode\":\"03184436\",\"phone\":13526075366,\"isOk\":\"鏄痋"}]";
+ Long dqXy = 100017L;
+ Map<String, Object> dqMapXy = new HashMap<>();
+ dqMapXy.put("dq", dqXy);
+ dqMapXy.put("jsonObj", jsonObjXy);
+ selLi.add(dqMapXy);
+
+
+ for (Map<String, Object> map1 : selLi) {
+ String jsonObj = map1.get("jsonObj").toString();
+ Long dq = (Long) map1.get("dq");
+
+ List<Map<String, Object>> list = JSON.parseObject(jsonObj, new TypeReference<ArrayList>() {
+ });
+ int i = 0;
+ for (Map<String, Object> map : list) {
+ Object jgObj = map.get("jg");
+ Object bmObj = map.get("bm");
+ // 鍏堟煡璇㈡満鏋�(name)
+ // FinSysTenant finSysTenant1 = finSysTenantService.selectByName(jgObj.toString());
+ FinSysTenant finSysTenant = finSysTenantService.selectByNameAndPid(dq, jgObj.toString());
+ if (finSysTenant == null) {
+ finSysTenant = finSysTenantService.selectByNameAndPid100(dq, jgObj.toString());
+ }
+ if (finSysTenant == null) {
+ finSysTenant = finSysTenantService.selectByNameAndPid0(dq, jgObj.toString());
+ }
+ if (finSysTenant == null) {
+ continue;
+ }
+ // 鍐嶆煡璇㈤儴闂�(name+鏈烘瀯id)
+ FinSysTenantDepartment sysDept = finSysTenantDepartmentService.getByTenantIdAndName(finSysTenant.getId(), bmObj.toString());
+ if (sysDept == null) {
+ continue;
+ }
+ map.get("bm");
+ Object sexObj = map.get("sex");
+ Object userCodeObj = map.get("userCode");
+ Object nameObj = map.get("name");
+ Object phoneObj = map.get("phone");
+ FinSysTenantUser finSysTenantUser = new FinSysTenantUser();
+ finSysTenantUser.setSeq(1L);
+ if (sexObj != null && sexObj.toString().equals("鐢�")) {
+ finSysTenantUser.setSex(1);
+ } else {
+ finSysTenantUser.setSex(2);
+ }
+ finSysTenantUser.setStatus(1);
+ finSysTenantUser.setSysDeptId(sysDept.getId());
+ finSysTenantUser.setTenantId(finSysTenant.getId().toString());
+ finSysTenantUser.setUserCode(userCodeObj.toString());
+ finSysTenantUser.setUserName(nameObj.toString());
+ finSysTenantUser.setUserPhone(phoneObj.toString());
+ List<Long> roleList = new ArrayList<>();
+ roleList.add(1695901062393L);
+ finSysTenantUser.setRoleList(roleList);
+ // 鍐嶆彃鍏ョ敤鎴�
+ ResponseValue responseValue = add1(finSysTenantUser);
+ i++;
+ log.info("娣诲姞绗�" + i + "鐢ㄦ埛锛�" + finSysTenantUser.toString() + "缁撴灉锛�" + responseValue.toString());
+ }
+ log.info("鎵ц瀹屾瘯....鎵ц" + i + "鏉℃暟鎹�");
+ }
+ // 鍐嶅垎閰嶄粨搴�
+ // 鍐嶅垎閰嶄粨搴撶鐞嗗憳
+ return "鎵ц瀹屾瘯";
+ }
+
+
private void buildTenantUser(FinSysTenantUser tenantUser, FinSysTenantUser sysInfo) {
tenantUser.setId(NumberGenerator.getLongSequenceNumber());
tenantUser.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
@@ -278,7 +488,7 @@
*/
@PostMapping("/import")
public ResponseValue importUser(@RequestParam String tenantId, @RequestParam String tenantCode, MultipartFile file)
- throws IOException {
+ throws IOException {
String originalFilename = file.getOriginalFilename();
if (!originalFilename.endsWith("xls")) {
return ResponseValue.error("鏂囦欢鏍煎紡鏈夎!");
@@ -296,80 +506,80 @@
ArrayList<FinSysTenantUser> finSysTenantUsers = new ArrayList<>();
EasyExcelFactory
- .read(file.getInputStream(), ImportUserParam.class, new AnalysisEventListener<ImportUserParam>() {
- @Override
- public void invoke(ImportUserParam data, AnalysisContext context) {
- if (StringUtils.isEmpty(data.getUserName()) || StringUtils.isEmpty(data.getUserCode())
- || StringUtils.isEmpty(data.getUserPhone()) || null == data.getSex()
- || StringUtils.isEmpty(data.getEmail()) || null == data.getSeq()
- || StringUtils.isEmpty(data.getRoleName())) {
- throw new ImportUserParamVerifyException("鍗曞厓鏍间笉鑳戒负绌�!");
- }
- // 鏍规嵁鍛樺伐缂栧彿鏌ヨ锛屽鏋滃瓨鍦ㄥ垯鎻愮ず
- if (finSysTenantUserService.getByUserCode(data.getUserCode()) != null) {
- throw new ImportUserParamVerifyException("鍛樺伐缂栧彿涓虹┖鎴栧凡瀛樺湪!");
- }
- if (data.getSex() < 1 && data.getSex() > 0) {
- throw new ImportUserParamVerifyException("鎬у埆鐮佸彧鑳戒负 0 鎴� 1");
- }
- FinSysTenantUser user = new FinSysTenantUser();
- user.setUserName(data.getUserName());
- user.setUserCode(data.getUserCode());
- user.setUserPhone(data.getUserPhone());
- user.setSex(data.getSex());
- user.setEmail(data.getEmail());
- user.setSeq(data.getSeq());
- user.setTenantId(tenantId);
- user.setTenantCode(tenantCode);
- // 璁剧疆瑙掕壊
- Optional<S_role> sRole =
- roles.stream().filter(role -> role.getRole_name().equals(data.getRoleName())).findFirst();
- user.setRoleList(Arrays.asList(sRole.orElse(new S_role()).getRole_id()));
-
- user.setId(NumberGenerator.getLongSequenceNumber());
- user.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
- user.setCreateBy(currentUser.getUser_name());
- user.setUpdateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
- user.setUpdateBy(currentUser.getUser_name());
- user.setStatus(1);// 0绂佺敤 1鍚敤
- user.setIsDelete(0);// 鏄惁鍒犻櫎 0鏄� 1鍚�
- user.setSysUserId(NumberGenerator.getLongSequenceNumber());
- user.setRemark("鎵归噺瀵煎叆");
- // 鍔犲瘑鎵嬫満鍙�
- setUserPhone(user, data.getUserPhone());
-
- user.setIsDelete(1);
- // 鎬庝箞鑾峰彇宸︿晶鏈烘瀯鏍戞暟鎹�
- user.setSysDeptId(3L); // 瀵瑰簲骞冲彴鏈烘瀯id 榛樿涓哄钩鍙扮鐞�
- finSysTenantUsers.add(user);
- }
-
- @Override
- public void doAfterAllAnalysed(AnalysisContext context) {
-
- }
-
- @Override
- public void onException(Exception exception, AnalysisContext context) throws Exception {
- if (exception != null) {
- // 濡傛灉鏄煇涓�涓崟鍏冩牸鐨勮浆鎹㈠紓甯� 鑳借幏鍙栧埌鍏蜂綋琛屽彿 灏佽鏃跺紓甯�
- if (exception instanceof ExcelDataConvertException) {
- ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException)exception;
- logger.error("绗瑊}琛岋紝绗瑊}鍒楄В鏋愬紓甯革紝鏁版嵁涓�:{}", excelDataConvertException.getRowIndex(),
- excelDataConvertException.getColumnIndex() + 1,
- excelDataConvertException.getCellData().getStringValue());
- throw new IllegalStateException("绗�" + (excelDataConvertException.getRowIndex() + 1) + "琛岋紝绗�"
- + (excelDataConvertException.getColumnIndex() + 1) + "鍒楄В鏋愬紓甯革紝寮傚父鏁版嵁涓�:[ "
- + excelDataConvertException.getCellData().getStringValue() + " ]");
+ .read(file.getInputStream(), ImportUserParam.class, new AnalysisEventListener<ImportUserParam>() {
+ @Override
+ public void invoke(ImportUserParam data, AnalysisContext context) {
+ if (StringUtils.isEmpty(data.getUserName()) || StringUtils.isEmpty(data.getUserCode())
+ || StringUtils.isEmpty(data.getUserPhone()) || null == data.getSex()
+ || StringUtils.isEmpty(data.getEmail()) || null == data.getSeq()
+ || StringUtils.isEmpty(data.getRoleName())) {
+ throw new ImportUserParamVerifyException("鍗曞厓鏍间笉鑳戒负绌�!");
}
- if (exception instanceof ImportUserParamVerifyException) {
- throw new IllegalStateException("绗�" + context.readSheetHolder().getRowIndex() + "琛�, 瑙ｆ瀽閿欒:[ "
- + exception.getMessage() + " ]");
+ // 鏍规嵁鍛樺伐缂栧彿鏌ヨ锛屽鏋滃瓨鍦ㄥ垯鎻愮ず
+ if (finSysTenantUserService.getByUserCode(data.getUserCode()) != null) {
+ throw new ImportUserParamVerifyException("鍛樺伐缂栧彿涓虹┖鎴栧凡瀛樺湪!");
}
- throw exception;
+ if (data.getSex() < 1 && data.getSex() > 0) {
+ throw new ImportUserParamVerifyException("鎬у埆鐮佸彧鑳戒负 0 鎴� 1");
+ }
+ FinSysTenantUser user = new FinSysTenantUser();
+ user.setUserName(data.getUserName());
+ user.setUserCode(data.getUserCode());
+ user.setUserPhone(data.getUserPhone());
+ user.setSex(data.getSex());
+ user.setEmail(data.getEmail());
+ user.setSeq(data.getSeq());
+ user.setTenantId(tenantId);
+ user.setTenantCode(tenantCode);
+ // 璁剧疆瑙掕壊
+ Optional<S_role> sRole =
+ roles.stream().filter(role -> role.getRole_name().equals(data.getRoleName())).findFirst();
+ user.setRoleList(Arrays.asList(sRole.orElse(new S_role()).getRole_id()));
+
+ user.setId(NumberGenerator.getLongSequenceNumber());
+ user.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
+ user.setCreateBy(currentUser.getUser_name());
+ user.setUpdateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
+ user.setUpdateBy(currentUser.getUser_name());
+ user.setStatus(1);// 0绂佺敤 1鍚敤
+ user.setIsDelete(0);// 鏄惁鍒犻櫎 0鏄� 1鍚�
+ user.setSysUserId(NumberGenerator.getLongSequenceNumber());
+ user.setRemark("鎵归噺瀵煎叆");
+ // 鍔犲瘑鎵嬫満鍙�
+ setUserPhone(user, data.getUserPhone());
+
+ user.setIsDelete(1);
+ // 鎬庝箞鑾峰彇宸︿晶鏈烘瀯鏍戞暟鎹�
+ user.setSysDeptId(3L); // 瀵瑰簲骞冲彴鏈烘瀯id 榛樿涓哄钩鍙扮鐞�
+ finSysTenantUsers.add(user);
}
- }
- }).sheet().doRead();
+
+ @Override
+ public void doAfterAllAnalysed(AnalysisContext context) {
+
+ }
+
+ @Override
+ public void onException(Exception exception, AnalysisContext context) throws Exception {
+ if (exception != null) {
+ // 濡傛灉鏄煇涓�涓崟鍏冩牸鐨勮浆鎹㈠紓甯� 鑳借幏鍙栧埌鍏蜂綋琛屽彿 灏佽鏃跺紓甯�
+ if (exception instanceof ExcelDataConvertException) {
+ ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException) exception;
+ logger.error("绗瑊}琛岋紝绗瑊}鍒楄В鏋愬紓甯革紝鏁版嵁涓�:{}", excelDataConvertException.getRowIndex(),
+ excelDataConvertException.getColumnIndex() + 1,
+ excelDataConvertException.getCellData().getStringValue());
+ throw new IllegalStateException("绗�" + (excelDataConvertException.getRowIndex() + 1) + "琛岋紝绗�"
+ + (excelDataConvertException.getColumnIndex() + 1) + "鍒楄В鏋愬紓甯革紝寮傚父鏁版嵁涓�:[ "
+ + excelDataConvertException.getCellData().getStringValue() + " ]");
+ }
+ if (exception instanceof ImportUserParamVerifyException) {
+ throw new IllegalStateException("绗�" + context.readSheetHolder().getRowIndex() + "琛�, 瑙ｆ瀽閿欒:[ "
+ + exception.getMessage() + " ]");
+ }
+ throw exception;
+ }
+ }
+ }).sheet().doRead();
insertUserAndUserCoreBatch(finSysTenantUsers);
@@ -801,9 +1011,9 @@
@ApiOperation(value = "鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬涓殑鐢ㄦ埛", notes = "鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬涓殑鐢ㄦ埛")
@ApiImplicitParams({
- @ApiImplicitParam(name = "agencyId", value = "鏈烘瀯id", required = true, dataType = "Long", paramType = "query")})
+ @ApiImplicitParam(name = "agencyId", value = "鏈烘瀯id", required = true, dataType = "Long", paramType = "query")})
@GetMapping("/select/department")
- public ResponseValue selectDepartment(Long agencyId) {
+ public ResponseValue selectDepartment(Long agencyId, String isFilter) {
FinSysTenantVO finSysTenantVO = new FinSysTenantVO();
FinSysTenant finSysTenant = new FinSysTenant();
@@ -817,8 +1027,7 @@
finSysTenantDepartment.setTenantId(agencyId);
finSysTenantDepartment.setStatus(StatesType.NORMAL.getValue());
finSysTenantDepartment.setIsDelete(0);
- List<FinSysTenantDepartment> tenantDepartmentList =
- finSysTenantDepartmentService.select(finSysTenantDepartment);
+ List<FinSysTenantDepartment> tenantDepartmentList = finSysTenantDepartmentService.select(finSysTenantDepartment);
List<DepartmentVO> departmentVOList = Lists.newArrayList();
tenantDepartmentList.forEach(department -> {
DepartmentVO departmentVO = new DepartmentVO();
@@ -827,16 +1036,19 @@
departmentVO.setId(id);
departmentVO.setName(department.getName());
departmentVO.setType("department");
-
String sql = "SELECT SYS_USER_ID,USER_NAME FROM fin_sys_tenant_user "
- + "WHERE STATUS =1 and SYS_DEPT_ID =:deptId AND SYS_USER_ID NOT IN(SELECT MANAGER_ID FROM base_warehouse_manager)";
+ + "WHERE STATUS =1 and SYS_DEPT_ID =:deptId ";
Map<String, Object> param = new HashMap<>();
param.put("deptId", id);
+ if ("1".equals(isFilter)) {
+ sql = "SELECT SYS_USER_ID,USER_NAME FROM fin_sys_tenant_user "
+ + "WHERE STATUS =1 and SYS_DEPT_ID =:deptId AND SYS_USER_ID NOT IN(SELECT MANAGER_ID FROM base_warehouse_manager)";
+ }
List<Map<String, Object>> select = finSysTenantUserService.select(sql, param, new MapperUtil());
List<UserVO> userVOList = Lists.newArrayList();
select.forEach(user -> {
UserVO userVO = new UserVO();
- userVO.setId((Long)user.get("sysUserId"));
+ userVO.setId((Long) user.get("sysUserId"));
userVO.setName(user.get("userName").toString());
userVO.setType("user");
userVOList.add(userVO);
@@ -866,7 +1078,7 @@
FinSysTenantUser finSysTenantUser = this.getSysInfo();
Integer dataScope = finSysTenantUser.getLv();
GenericPager<S_role> pager = finSysTenantUserService.queryPageRoleList(orgId, roleParam.getStatus(),
- roleParam.getRoleName(), dataScope,roleParam.getPageNum(), roleParam.getPageSize());
+ roleParam.getRoleName(), dataScope, roleParam.getPageNum(), roleParam.getPageSize());
return ResponseValue.success(pager);
} else {
return ResponseValue.error("鍙傛暟涓嶈兘涓虹┖");
--
Gitblit v1.9.1