From 345d17cf82e1bbc1fbfbeec10193c2bed59cd674 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 27 Sep 2021 22:21:21 +0800
Subject: [PATCH] 注册登录,车辆,装备,枪支,招聘,培训考试修改

---
 src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java |   18 ++++++++++++++++++
 1 files changed, 18 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java b/src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java
index 3c30b56..87a456d 100644
--- a/src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java
+++ b/src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java
@@ -19,6 +19,7 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import lombok.AllArgsConstructor;
+import org.springblade.modules.FTP.FtpUtil;
 import org.springblade.modules.dispatcher.entity.Dispatcher;
 import org.springblade.modules.dispatcher.entity.DispatcherUnit;
 import org.springblade.modules.dispatcher.excel.DispatcherUnitExcel;
@@ -35,6 +36,8 @@
 import java.text.SimpleDateFormat;
 import java.util.Date;
 import java.util.List;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
 
 /**
  *  服务实现类
@@ -99,6 +102,10 @@
 			}
 
 			if (dispatcherUnitExcel.getName()!=null && dispatcherUnitExcel.getName()!=""){
+				//仅中文
+//				String chinese = "^[\\u4E00-\\u9FA5\\uF900-\\uFA2D]+$";
+//				Pattern compile = Pattern.compile(chinese);
+//				String name = compile.matcher(dispatcherUnitExcel.getName()).replaceAll("");
 				dispatcherUnit.setName(dispatcherUnitExcel.getName());
 			}
 
@@ -139,6 +146,17 @@
 			//新增
 			this.save(dispatcherUnit);
 
+			//数据同步
+			String s1 =
+				"insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,start_time,end_time) " +
+					"values(" + "'" + dispatcherUnit.getId() + "'" + "," +
+					"'" + dispatcherUnit.getName() + "'" + "," +
+					"'" + dispatcherUnit.getDeptId() + "'" + "," +
+					"'" + dispatcherUnit.getLinkman() + "'" + "," +
+					"'" + dispatcherUnit.getPhone() + "'" + "," +
+					"'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcherUnit.getStartTime()) + "'" + "," +
+					"'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcherUnit.getEndTime()) + "'" + ")";
+			FtpUtil.sqlFileUpload(s1);
 		});
 	}
 }

--
Gitblit v1.9.3