From 10b8730043e823efaf7fdea209e7e63f08b9bc4e Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期六, 20 二月 2021 09:45:14 +0800
Subject: [PATCH] zuul
---
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/user/CommunityUserInfoVO.java | 11 +++
springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/JWTAuthenticationTokenFilter.java | 3
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/FileUtil.java | 36 ++++++++++++
springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/excel/CustomSheetWriteHandler.java | 39 +++++++++++++
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/model/dos/SysUserInputDO.java | 11 +++
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/SysUserInputServiceImpl.java | 11 +++
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java | 11 +++
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/SysUserInputService.java | 11 +++
springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/SercuritFilter.java | 3
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/IdCard.java | 11 +++
10 files changed, 145 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/user/CommunityUserInfoVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/user/CommunityUserInfoVO.java
new file mode 100644
index 0000000..d12ea57
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/user/CommunityUserInfoVO.java
@@ -0,0 +1,11 @@
+package com.panzhihua.common.model.vos.user;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 社区人员详情
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-18 09:43
+**/
+public class CommunityUserInfoVO {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/FileUtil.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/FileUtil.java
new file mode 100644
index 0000000..d4665b4
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/FileUtil.java
@@ -0,0 +1,36 @@
+package com.alibaba.easyexcel.test.util;
+
+import java.io.File;
+import java.io.InputStream;
+
+public class TestFileUtil {
+
+
+ public static InputStream getResourcesFileInputStream(String fileName) {
+ return Thread.currentThread().getContextClassLoader().getResourceAsStream("" + fileName);
+ }
+
+ public static String getPath() {
+ return TestFileUtil.class.getResource("/").getPath();
+ }
+
+ public static File createNewFile(String pathName) {
+ File file = new File(getPath() + pathName);
+ if (file.exists()) {
+ file.delete();
+ } else {
+ if (!file.getParentFile().exists()) {
+ file.getParentFile().mkdirs();
+ }
+ }
+ return file;
+ }
+
+ public static File readFile(String pathName) {
+ return new File(getPath() + pathName);
+ }
+
+ public static File readUserHomeFile(String pathName) {
+ return new File(System.getProperty("user.home") + File.separator + pathName);
+ }
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/IdCard.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/IdCard.java
new file mode 100644
index 0000000..d764584
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/IdCard.java
@@ -0,0 +1,11 @@
+package com.panzhihua.common.utlis;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 年龄
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-06 17:27
+**/
+public class IdCard {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/excel/CustomSheetWriteHandler.java b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/excel/CustomSheetWriteHandler.java
new file mode 100644
index 0000000..fe29045
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/excel/CustomSheetWriteHandler.java
@@ -0,0 +1,39 @@
+package com.alibaba.easyexcel.test.demo.write;
+
+import org.apache.poi.ss.usermodel.DataValidation;
+import org.apache.poi.ss.usermodel.DataValidationConstraint;
+import org.apache.poi.ss.usermodel.DataValidationHelper;
+import org.apache.poi.ss.util.CellRangeAddressList;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import com.alibaba.excel.write.handler.SheetWriteHandler;
+import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
+import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder;
+
+/**
+ * 自定义拦截器.对第一列第一行和第二行的数据新增下拉框，显示 测试1 测试2
+ *
+ * @author Jiaju Zhuang
+ */
+public class CustomSheetWriteHandler implements SheetWriteHandler {
+
+ private static final Logger LOGGER = LoggerFactory.getLogger(CustomSheetWriteHandler.class);
+
+ @Override
+ public void beforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
+
+ }
+
+ @Override
+ public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
+ LOGGER.info("第{}个Sheet写入成功。", writeSheetHolder.getSheetNo());
+
+ // 区间设置 第一列第一行和第二行的数据。由于第一行是头，所以第一、二行的数据实际上是第二三行
+ CellRangeAddressList cellRangeAddressList = new CellRangeAddressList(1, 2, 0, 0);
+ DataValidationHelper helper = writeSheetHolder.getSheet().getDataValidationHelper();
+ DataValidationConstraint constraint = helper.createExplicitListConstraint(new String[] {"测试1", "测试2"});
+ DataValidation dataValidation = helper.createValidation(constraint, cellRangeAddressList);
+ writeSheetHolder.getSheet().addValidationData(dataValidation);
+ }
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
new file mode 100644
index 0000000..de17b36
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
@@ -0,0 +1,11 @@
+package com.panzhihua.service_user.dao;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 居民导入
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-05 17:40
+**/
+public interface SysUserInputDAO {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/model/dos/SysUserInputDO.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/model/dos/SysUserInputDO.java
new file mode 100644
index 0000000..9741653
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/model/dos/SysUserInputDO.java
@@ -0,0 +1,11 @@
+package com.panzhihua.service_user.model.dos;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 居民导入数据
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-05 17:37
+**/
+public class SysUserInputDO {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/SysUserInputService.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/SysUserInputService.java
new file mode 100644
index 0000000..50a0fb4
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/SysUserInputService.java
@@ -0,0 +1,11 @@
+package com.panzhihua.service_user.service;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 居民导入
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-05 17:42
+**/
+public interface SysUserInputService {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/SysUserInputServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/SysUserInputServiceImpl.java
new file mode 100644
index 0000000..a35c520
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/SysUserInputServiceImpl.java
@@ -0,0 +1,11 @@
+package com.panzhihua.service_user.service.impl;/**
+* @program: springcloud_k8s_panzhihuazhihuishequ
+*
+* @description: 居民导入
+*
+* @author: huang.hongfa weixin hhf9596 qq 959656820
+*
+* @create: 2021-02-05 17:42
+**/
+public class SysUserInputServiceImpl {
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/JWTAuthenticationTokenFilter.java b/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/JWTAuthenticationTokenFilter.java
index 990f2c6..3a0a858 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/JWTAuthenticationTokenFilter.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/JWTAuthenticationTokenFilter.java
@@ -73,10 +73,11 @@
boolean ico = requestURI.contains(".ico");
boolean docs = requestURI.contains("-docs");
boolean error = requestURI.contains("error");
+ boolean useragreement = requestURI.contains("useragreement");
boolean refreshToken = requestURI.contains("refreshToken");
boolean logout = requestURI.contains("logout");
SafeboxRequestWrapper safeboxRequestWrapper = new SafeboxRequestWrapper(request);
- if (login||doc||css||js||ui||swagger||ico||docs||error||refreshToken) {
+ if (login||doc||css||js||ui||swagger||ico||docs||error||refreshToken||useragreement) {
//什么也不做
} else {
// 获取请求头中JWT的Token
diff --git a/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/SercuritFilter.java b/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/SercuritFilter.java
index 95cdacf..d84440b 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/SercuritFilter.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/zuul/src/main/java/com/panzhihua/zuul/filters/SercuritFilter.java
@@ -74,7 +74,8 @@
boolean docs = !requestUrl.contains("docs");
boolean login = !requestUrl.contains("login");
boolean refreshToken = !requestUrl.contains("refreshToken");
- if (contains&&docs&&login&&refreshToken) {
+ boolean useragreement = !requestUrl.contains("useragreement");
+ if (contains&&docs&&login&&refreshToken&&useragreement) {
configAttributes.add(new SecurityConfig(SecurityConstants.ROLE_APPLETS));
}
return configAttributes;
--
Gitblit v1.7.1