From fd95223d9703b9c038ed3c782474c885052dda08 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 22 十二月 2023 17:05:25 +0800
Subject: [PATCH] 代码整理

---
 consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java |  156 +++++++++++++++++++++++++---------------------------
 1 files changed, 75 insertions(+), 81 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 3052027..8dea44c 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
@@ -22,7 +22,7 @@
 import org.springframework.web.bind.annotation.RestController;
 import org.springframework.web.multipart.MultipartFile;
 
-import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.EasyExcelFactory;
 import com.alibaba.excel.context.AnalysisContext;
 import com.alibaba.excel.event.AnalysisEventListener;
 import com.alibaba.excel.exception.ExcelDataConvertException;
@@ -124,13 +124,6 @@
             String tel = finSysTenantUser.getUserPhone() != null
                 ? AESUtils.decryptStrAES(finSysTenantUser.getUserPhone(), PlatformRSAUtils.AES_KEY) : null;
             finSysTenantUser.setUserPhone(StringUtils.isNotEmpty(tel) ? PhoneNumberUtils.maskMobile(tel) : "");
-
-            // 鍒楄〃涓嶉渶瑕佹煡璇㈣鑹诧紝鍙樉绀哄垪琛ㄦ墍闇�瑕佺殑淇℃伅
-            /*List<S_role> list = finSysTenantUserService.getByUserId(finSysTenantUser.getSysUserId());
-            StringBuilder roleStr = new StringBuilder();
-            list.forEach(s_role -> roleStr.append(s_role.getRole_name()).append(" "));
-            finSysTenantUser.setRoleStr(roleStr.toString());
-            finSysTenantUser.setIsSupplier(finSysTenantUser.getSupplierId() != null ? "鏄�" : "鍚�");*/
 
         }
         return ResponseValue.success(pager);
@@ -300,80 +293,81 @@
         List<S_role> roles = this.roleService.select(new S_role());
         ArrayList<FinSysTenantUser> finSysTenantUsers = new ArrayList<>();
 
-        EasyExcel.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() + " ]");
+        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 (exception instanceof ImportUserParamVerifyException) {
-                        throw new IllegalStateException("绗�" + context.readSheetHolder().getRowIndex() + "琛�, 瑙f瀽閿欒:[ "
-                            + 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() + "琛�, 瑙f瀽閿欒:[ "
+                                + exception.getMessage() + " ]");
+                        }
+                        throw exception;
+                    }
+                }
+            }).sheet().doRead();
 
         insertUserAndUserCoreBatch(finSysTenantUsers);
 
@@ -552,7 +546,7 @@
         Long sysUserId = finSysTenantUser.getSysUserId();
         List<S_role> roleList = finSysTenantUserService.getRoleBySysUserId(sysUserId);
         // 杩囨护浠撳簱绠$悊鍛樼殑鏄剧ず
-        roleList.removeIf(role -> role.getRole_name().equals("浠撳簱绠$悊鍛�"));
+        roleList.removeIf(role -> "浠撳簱绠$悊鍛�".equals(role.getRole_name()));
 
         HashMap<String, Object> map = new HashMap<>();
         map.put("list", roleList);
@@ -680,7 +674,7 @@
         return ResponseValue.success(1);
     }
 
-    private Set<String> picFormatArr = new HashSet<String>() {
+    private final Set<String> picFormatArr = new HashSet<String>() {
         {
             add(".pjp");
             add(".svgz");

--
Gitblit v1.9.1