From 6f201b8d3743e246a71f00a9ba98d10b128fae38 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 16 Jan 2024 08:59:52 +0800
Subject: [PATCH] 派遣记录导入
---
src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java | 132 +++++++++++++++++++++++++++++---------------
1 files changed, 87 insertions(+), 45 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 6193435..a52e4e0 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
@@ -29,7 +29,9 @@
import org.springblade.modules.dispatcher.service.IDispatcherUnitService;
import org.springblade.modules.dispatcher.vo.DispatcherUnitVO;
import org.springblade.modules.dispatcher.vo.DispatcherVO;
+import org.springblade.modules.jurisdiction.service.JurisdictionService;
import org.springblade.modules.system.service.IUserDeptService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.stereotype.Service;
import java.text.ParseException;
@@ -40,7 +42,7 @@
import java.util.regex.Pattern;
/**
- * 服务实现类
+ * 服务实现类
*
* @author BladeX
* @since 2021-07-07
@@ -53,19 +55,31 @@
private final IDispatcherService dispatcherService;
private final IUserDeptService userDeptService;
+ private final JurisdictionService jurisdictionService;
@Override
public IPage<DispatcherUnitVO> selectDispatcherUnitPage(IPage<DispatcherUnitVO> page, DispatcherUnitVO dispatcherUnitVO) {
List<DispatcherUnitVO> dispatcherUnitVOS = baseMapper.selectDispatcherUnitPage(page, dispatcherUnitVO);
dispatcherUnitVOS.forEach(dispatcherUnitVO1 -> {
//查询派遣记录条数
- dispatcherUnitVO1.setNum(dispatcherService.getDispatcherCount(dispatcherUnitVO1));
+ dispatcherUnitVO1.setSnum(dispatcherService.getDispatcherCount(dispatcherUnitVO1));
});
return page.setRecords(dispatcherUnitVOS);
}
+ @Override
+ public List<DispatcherUnitVO> getAll(DispatcherUnit dispatcherUnit) {
+ List<DispatcherUnitVO> dispatcherUnitVOS = baseMapper.getAll(dispatcherUnit);
+ dispatcherUnitVOS.forEach(dispatcherUnitVO1 -> {
+ //查询派遣记录条数
+ dispatcherUnitVO1.setSnum(dispatcherService.getDispatcherCount(dispatcherUnitVO1));
+ });
+ return dispatcherUnitVOS;
+ }
+
/**
* 派遣公司信息详情
+ *
* @param dispatcherUnit 派遣信息对象
* @return
*/
@@ -76,6 +90,7 @@
/**
* 自定义树
+ *
* @param dispatcher
* @return
*/
@@ -86,6 +101,7 @@
/**
* 派遣导入
+ *
* @param data
* @param isCovered
*/
@@ -96,67 +112,93 @@
//派遣单位
DispatcherUnit dispatcherUnit = new DispatcherUnit();
//数据获取
- if (dispatcherUnitExcel.getDeptName()!=null && dispatcherUnitExcel.getDeptName()!=""){
+ if (dispatcherUnitExcel.getDeptName() != null && dispatcherUnitExcel.getDeptName() != "") {
String deptId = userDeptService.selectIn(dispatcherUnitExcel.getDeptName());
dispatcherUnit.setDeptId(Long.parseLong(deptId));
}
- 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(name);
+ if (dispatcherUnitExcel.getJurisdiction() != null && dispatcherUnitExcel.getJurisdiction() != ""){
+ String jurisdiction = jurisdictionService.selectIn(dispatcherUnitExcel.getJurisdiction());
+ dispatcherUnit.setJurisdiction(jurisdiction);
}
- if (dispatcherUnitExcel.getLinkman()!=null && dispatcherUnitExcel.getLinkman()!=""){
+ 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());
+ }
+
+ if (dispatcherUnitExcel.getLinkman() != null && dispatcherUnitExcel.getLinkman() != "") {
dispatcherUnit.setLinkman(dispatcherUnitExcel.getLinkman());
}
- if (dispatcherUnitExcel.getPhone()!=null && dispatcherUnitExcel.getPhone()!=""){
+ if (dispatcherUnitExcel.getPhone() != null && dispatcherUnitExcel.getPhone() != "") {
dispatcherUnit.setPhone(dispatcherUnitExcel.getPhone());
}
- if (dispatcherUnitExcel.getStartTime()!=null){
- String year = dispatcherUnitExcel.getStartTime().substring(0, 4);
- String month = dispatcherUnitExcel.getStartTime().substring(4, 6);
- String day = dispatcherUnitExcel.getStartTime().substring(6, 8);
- String dateFormat = year + "-" +month+"-" +day;
- try {
- Date date = new SimpleDateFormat("yyyy-MM-dd").parse(dateFormat);
- dispatcherUnit.setStartTime(date);
- } catch (ParseException e) {
- e.printStackTrace();
- }
+ if (dispatcherUnitExcel.getSecurityLinkman() != null && dispatcherUnitExcel.getSecurityLinkman() != "") {
+ dispatcherUnit.setSecurityLinkman(dispatcherUnitExcel.getSecurityLinkman());
}
- if (dispatcherUnitExcel.getEndTime()!=null){
- String year = dispatcherUnitExcel.getEndTime().substring(0, 4);
- String month = dispatcherUnitExcel.getEndTime().substring(4, 6);
- String day = dispatcherUnitExcel.getEndTime().substring(6, 8);
- String dateFormat = year + "-" +month+"-" +day;
- try {
- Date date = new SimpleDateFormat("yyyy-MM-dd").parse(dateFormat);
- dispatcherUnit.setEndTime(date);
- } catch (ParseException e) {
- e.printStackTrace();
- }
+ if (dispatcherUnitExcel.getCell() != null && dispatcherUnitExcel.getCell() != "") {
+ dispatcherUnit.setCell(dispatcherUnitExcel.getCell());
}
+
+ if (dispatcherUnitExcel.getServeType() != null && dispatcherUnitExcel.getServeType() != "") {
+ dispatcherUnit.setServeType(dispatcherUnitExcel.getServeType());
+ }
+
+ if (dispatcherUnitExcel.getNum() != null) {
+ dispatcherUnit.setNum(dispatcherUnitExcel.getNum());
+ }
+
+ if (dispatcherUnitExcel.getProfession() != null && dispatcherUnitExcel.getProfession() != ""){
+ dispatcherUnit.setProfession(dispatcherUnitExcel.getProfession());
+ }
+
+ if (dispatcherUnitExcel.getDistrict() != null && dispatcherUnitExcel.getDistrict() != ""){
+ dispatcherUnit.setDistrict(dispatcherUnitExcel.getDistrict());
+ }
+
+ dispatcherUnit.setLongitude(dispatcherUnitExcel.getLongitude());
+ dispatcherUnit.setLatitude(dispatcherUnitExcel.getLatitude());
+ dispatcherUnit.setAddress(dispatcherUnitExcel.getAddress());
+
+ dispatcherUnit.setStartTime(dispatcherUnitExcel.getStartTime());
+ dispatcherUnit.setEndTime(dispatcherUnitExcel.getEndTime());
+
+// if (dispatcherUnitExcel.getStartTime()!=null){
+// String year = dispatcherUnitExcel.getStartTime().substring(0, 4);
+// String month = dispatcherUnitExcel.getStartTime().substring(4, 6);
+// String day = dispatcherUnitExcel.getStartTime().substring(6, 8);
+// String dateFormat = year + "-" +month+"-" +day;
+// try {
+// Date date = new SimpleDateFormat("yyyy-MM-dd").parse(dateFormat);
+// dispatcherUnit.setStartTime(date);
+// } catch (ParseException e) {
+// e.printStackTrace();
+// }
+// }
+//
+// if (dispatcherUnitExcel.getEndTime()!=null){
+// String year = dispatcherUnitExcel.getEndTime().substring(0, 4);
+// String month = dispatcherUnitExcel.getEndTime().substring(4, 6);
+// String day = dispatcherUnitExcel.getEndTime().substring(6, 8);
+// String dateFormat = year + "-" +month+"-" +day;
+// try {
+// Date date = new SimpleDateFormat("yyyy-MM-dd").parse(dateFormat);
+// dispatcherUnit.setEndTime(date);
+// } catch (ParseException e) {
+// e.printStackTrace();
+// }
+// }
+
+ dispatcherUnit.setCreateTime(new Date());
//新增
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