From df054296327ebca617a9c19bb01139b9c40bf232 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 07 Jun 2022 11:25:44 +0800
Subject: [PATCH] 培训报名,保安员头像导入新增修改

---
 src/main/java/org/springblade/modules/FTP/Monitor.java |  306 ++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 290 insertions(+), 16 deletions(-)

diff --git a/src/main/java/org/springblade/modules/FTP/Monitor.java b/src/main/java/org/springblade/modules/FTP/Monitor.java
index 52c6e41..16fd859 100644
--- a/src/main/java/org/springblade/modules/FTP/Monitor.java
+++ b/src/main/java/org/springblade/modules/FTP/Monitor.java
@@ -10,31 +10,37 @@
 
 import java.io.IOException;
 import java.io.InputStream;
+import java.io.UnsupportedEncodingException;
+import java.net.SocketException;
+import java.util.List;
 
 import static org.springblade.common.config.FtpConfig.*;
 
 /**
- * FTP读取文件
+ * FTP 监听器,监听文件
  * @author
  * @since 2021-04-26 修改
  */
 @Component
 public class Monitor {
 
+
 	/**
-	 * 读取文件(对象)
+	 * 读取文件(用户对象)单用户新增
 	 * @param uuid 随机数
 	 * @return
 	 */
 	public static Result isFTPFileExist(String uuid) {
+//		System.out.println("uuid = " + uuid);
 		//创建 ftp 对象
 		FTPClient ftp = new FTPClient();
 		boolean flag = false;
 		try {
 			//连接
 			ftp.connect(ftpHost, ftpPort);
+
 			// 登陆
-			ftp.login(ftpUserName, ftpPassword);
+			ftp.login(ftpUserNameIn, ftpPasswordIn);
 			// 检验登陆操作的返回码是否正确
 			if (!FTPReply.isPositiveCompletion(ftp.getReplyCode())) {
 				ftp.disconnect();
@@ -43,32 +49,44 @@
 
 			ftp.enterLocalActiveMode();
 
+
 			// 设置文件类型为二进制,与ASCII有区别
 			ftp.setFileType(FTP.BINARY_FILE_TYPE);
 
 			// 设置编码格式
 			ftp.setControlEncoding("GBK");
-
 			// 检验文件是否存在
-			ftp.changeWorkingDirectory(ftpPath);
+			boolean ftpFile = ftp.changeWorkingDirectory(ftpPath);
+//			System.out.println("检验文件是否存在 = " + ftpFile);
+			// Use passive mode as default
+			ftp.enterLocalPassiveMode();
+
 			FTPFile[] files = ftp.listFiles();
+//			System.out.println("files = " + files);
+//			System.out.println("开始读取内网回传消息");
 			if (files.length==0){
+//				System.out.println("未读取到文件");
 				return new Result(400,null,"未读取到文件",null);
 			} else {
+//				System.out.println("-----有读取到文件--------");
 				for (FTPFile file : files){
 					String fileName = file.getName();
+//					System.out.println("fileName = " + fileName);
 					InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING));
-					String substring1 = fileName.substring(0, 1);
-					if (substring1.equals("n")){
-						//把文件下载到本地
-						FtpUtil.downloadFtpFile(ftpHost, ftpUserName, ftpPassword, ftpPort, ftpPath, localPath, fileName);
+					String substring1 = fileName.substring(0, 2);
+//					System.out.println("substring1 = " + substring1);
+					if (substring1.equals("ni")){
+						System.out.println("-------接收到内网回传的文件: " + fileName);
+					    //把文件下载到本地
+						FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName);
 						// 解析数据
 						String s = OutJson.TestJson(fileName);
 						//数据处理
 						Result result = DataHandler.handler(s,uuid);
 						//删除本地文件
 						MysqlCenlint.deletess(fileName);
-						FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, fileName);
+						ftp.dele(fileName);
+//						FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName);
 						is.close();
 						ftp.completePendingCommand();
 						if (result.getCode()==200) {
@@ -87,6 +105,171 @@
 							//返回
 							return new Result(203,null,result.getMsg(),null);
 						}
+						if (result.getCode()==205){
+							//返回
+							return new Result(202,null,"新增失败,找不到该用户",null);
+						}
+					}
+				}
+				System.out.println("未读取到对应的文件");
+				return new Result(400,null,"未读取到对应的文件",null);
+			}
+		} catch (Exception e) {
+			System.out.println("ftp连接失败");
+			e.printStackTrace();
+		} finally {
+			if (ftp != null) {
+				try {
+					ftp.disconnect();
+				} catch (IOException e) {
+					e.printStackTrace();
+				}
+			}
+		}
+		return new Result(400,null,"失败",null);
+	}
+
+	/**
+	 * 读取文件(对象)用户批量操作返回
+	 * @param uuid 随机数
+	 * @return
+	 */
+	public static Result getFtpDataByUuidList(String uuid) {
+		//创建 ftp 对象
+		FTPClient ftp = new FTPClient();
+		boolean flag = false;
+		try {
+			//连接
+			ftp.connect(ftpHost, ftpPort);
+			// 登陆
+			ftp.login(ftpUserNameIn, ftpPasswordIn);
+			// 检验登陆操作的返回码是否正确
+			if (!FTPReply.isPositiveCompletion(ftp.getReplyCode())) {
+				ftp.disconnect();
+				return new Result(400,null,"ftp 连接失败",null);
+			}
+
+			ftp.enterLocalActiveMode();
+
+			// 设置文件类型为二进制,与ASCII有区别
+			ftp.setFileType(FTP.BINARY_FILE_TYPE);
+
+			// 设置编码格式
+			ftp.setControlEncoding("GBK");
+
+			// 检验文件是否存在
+			ftp.changeWorkingDirectory(ftpPath);
+
+			// Use passive mode as default
+			ftp.enterLocalPassiveMode();
+
+			FTPFile[] files = ftp.listFiles();
+			if (files.length==0){
+				return new Result(400,null,"未读取到文件",null);
+			} else {
+				for (FTPFile file : files){
+					String fileName = file.getName();
+					InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING));
+					String substring1 = fileName.substring(0, 2);
+					if (substring1.equals("nl")){
+						//把文件下载到本地
+						FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName);
+						// 解析数据
+						String s = OutJson.TestJson(fileName);
+						//数据处理
+						Result result = DataHandler.handlerList(s,uuid);
+						//匹配上了删除文件
+						if (result.getCode()==200) {
+							//删除本地文件
+							MysqlCenlint.deletess(fileName);
+							//删除 ftp 文件
+//							FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName);
+							ftp.dele(fileName);
+							//返回
+							return result;
+						}
+						is.close();
+						ftp.completePendingCommand();
+					}
+				}
+				return new Result(400,null,"未读取到对应的文件",null);
+			}
+		} catch (Exception e) {
+			System.out.println("ftp连接失败");
+			e.printStackTrace();
+		} finally {
+			if (ftp != null) {
+				try {
+					ftp.disconnect();
+				} catch (IOException e) {
+					e.printStackTrace();
+				}
+			}
+		}
+		return new Result(400,null,"失败",null);
+	}
+
+	/**
+	 * 读取文件(对象)报名返回
+	 * @param uuid 随机数
+	 * @return
+	 */
+	public static Result getFtpDataByUuidListTrain(String uuid) {
+		//创建 ftp 对象
+		FTPClient ftp = new FTPClient();
+		boolean flag = false;
+		try {
+			//连接
+			ftp.connect(ftpHost, ftpPort);
+			// 登陆
+			ftp.login(ftpUserNameIn, ftpPasswordIn);
+			// 检验登陆操作的返回码是否正确
+			if (!FTPReply.isPositiveCompletion(ftp.getReplyCode())) {
+				ftp.disconnect();
+				return new Result(400,null,"ftp 连接失败",null);
+			}
+
+			ftp.enterLocalActiveMode();
+
+			// 设置文件类型为二进制,与ASCII有区别
+			ftp.setFileType(FTP.BINARY_FILE_TYPE);
+
+			// 设置编码格式
+			ftp.setControlEncoding("GBK");
+
+			// 检验文件是否存在
+			ftp.changeWorkingDirectory(ftpPath);
+
+			// Use passive mode as default
+			ftp.enterLocalPassiveMode();
+
+			FTPFile[] files = ftp.listFiles();
+			if (files.length==0){
+				return new Result(400,null,"未读取到文件",null);
+			} else {
+				for (FTPFile file : files){
+					String fileName = file.getName();
+					InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING));
+					String substring1 = fileName.substring(0, 2);
+					if (substring1.equals("nt")){
+						//把文件下载到本地
+						FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName);
+						// 解析数据
+						String s = OutJson.TestJson(fileName);
+						//数据处理
+						Result result = DataHandler.handlerList(s,uuid);
+						//匹配上了删除文件
+						if (result.getCode()==200) {
+							//删除本地文件
+							MysqlCenlint.deletess(fileName);
+							//删除 ftp 文件
+							ftp.dele(fileName);
+//							FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName);
+							//返回
+							return result;
+						}
+						is.close();
+						ftp.completePendingCommand();
 					}
 				}
 				return new Result(400,null,"未读取到对应的文件",null);
@@ -110,14 +293,16 @@
 	 * 读取内外推送的文件,每30秒读取一次
 	 * @return
 	 */
-	@Scheduled(cron = "*/30 * * * * ?")
+//	@Scheduled(cron = "*/30 * * * * ?")
 	public static boolean isFTPFileExist() {
 		FTPClient ftp = new FTPClient();
 		try {
+			//设置超时时间
+			ftp.setConnectTimeout(2000);
 			//连接
 			ftp.connect(ftpHost, ftpPort);
 			// 登陆
-			ftp.login(ftpUserName, ftpPassword);
+			ftp.login(ftpUserNameIn, ftpPasswordIn);
 			// 检验登陆操作的返回码是否正确
 			if (!FTPReply.isPositiveCompletion(ftp.getReplyCode())) {
 				ftp.disconnect();
@@ -134,6 +319,10 @@
 
 			// 检验文件是否存在
 			ftp.changeWorkingDirectory(ftpPath);
+
+			// Use passive mode as default
+			ftp.enterLocalPassiveMode();
+
 			FTPFile[] files = ftp.listFiles();
 			if (files.length==0){
 				return false;
@@ -145,10 +334,10 @@
 					if (null == is) {
 						return false;
 					} else {
-						String substring1 = fileName.substring(0, 4);
-						if (substring1.equals("nsql")) {
+						String substring1 = fileName.substring(0, 2);
+						if (substring1.equals("nq")) {
 							//把文件下载到本地
-							FtpUtil.downloadFtpFile(ftpHost, ftpUserName, ftpPassword, ftpPort, ftpPath, localPath, fileName);
+							FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName);
 							//
 							String s = OutJson.TestJson(fileName);
 							//sql语句
@@ -174,7 +363,8 @@
 							//删除本地服务器文件
 							MysqlCenlint.deletess(fileName);
 							//删除 ftp 服务器文件
-							FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, fileName);
+							ftp.dele(fileName);
+//							FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName);
 						}
 						//关闭流
 						is.close();
@@ -197,4 +387,88 @@
 		}
 		return false;
 	}
+
+	/**
+	 * 获取保安证编号位数
+	 * @param uuid 随机数
+	 * @return
+	 */
+	public static Result getSecurityNumberBit(String uuid) {
+		//创建 ftp 对象
+		FTPClient ftp = new FTPClient();
+		boolean flag = false;
+		try {
+			//设置超时时间
+			ftp.setDataTimeout(60000);
+			//连接超时为60秒
+			ftp.setConnectTimeout(60000);
+			//连接
+			ftp.connect(ftpHost, ftpPort);
+			// 登陆
+			ftp.login(ftpUserNameIn, ftpPasswordIn);
+			// 检验登陆操作的返回码是否正确
+			if (!FTPReply.isPositiveCompletion(ftp.getReplyCode())) {
+				ftp.disconnect();
+				return new Result(400,null,"ftp 连接失败",null);
+			}
+
+			ftp.enterLocalActiveMode();
+
+			// 设置文件类型为二进制,与ASCII有区别
+			ftp.setFileType(FTP.BINARY_FILE_TYPE);
+
+			// 设置编码格式
+			ftp.setControlEncoding("GBK");
+
+			// 检验文件是否存在
+			ftp.changeWorkingDirectory(ftpPath);
+
+			// Use passive mode as default
+			ftp.enterLocalPassiveMode();
+
+			FTPFile[] files = ftp.listFiles();
+			if (files.length==0){
+				return new Result(400,null,"未读取到文件",null);
+			} else {
+				for (FTPFile file : files){
+					String fileName = file.getName();
+					InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING));
+					String substring1 = fileName.substring(0, 2);
+					if (substring1.equals("ns")){
+						//把文件下载到本地
+						FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName);
+						// 解析数据
+						String s = OutJson.TestJson(fileName);
+						//数据处理
+						Result result = DataHandler.handlerSecurityNumberBit(s,uuid);
+						//匹配上了删除文件
+						if (result.getCode()==200) {
+							//删除本地文件
+							MysqlCenlint.deletess(fileName);
+							//删除 ftp 文件
+							ftp.dele(fileName);
+//							FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName);
+							//返回
+							return result;
+						}
+						is.close();
+						ftp.completePendingCommand();
+					}
+				}
+				return new Result(400,null,"未读取到对应的文件",null);
+			}
+		} catch (Exception e) {
+			System.out.println("ftp连接失败");
+			e.printStackTrace();
+		} finally {
+			if (ftp.isConnected()) {
+				try {
+					ftp.disconnect();
+				} catch (IOException e) {
+					e.printStackTrace();
+				}
+			}
+		}
+		return new Result(400,null,"失败",null);
+	}
 }

--
Gitblit v1.9.3