From 8853292babb2ad94de4a3207966f1e83b767cd2d Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sun, 17 Sep 2023 16:38:34 +0800
Subject: [PATCH] 新增流程节点进程查询接口
---
src/main/java/org/springblade/modules/equipage/service/impl/EquipageServiceImpl.java | 54 +++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 45 insertions(+), 9 deletions(-)
diff --git a/src/main/java/org/springblade/modules/equipage/service/impl/EquipageServiceImpl.java b/src/main/java/org/springblade/modules/equipage/service/impl/EquipageServiceImpl.java
index 3a849d4..5c0f065 100644
--- a/src/main/java/org/springblade/modules/equipage/service/impl/EquipageServiceImpl.java
+++ b/src/main/java/org/springblade/modules/equipage/service/impl/EquipageServiceImpl.java
@@ -5,6 +5,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.equipage.entity.Equipage;
import org.springblade.modules.equipage.excel.EquipageExcel;
import org.springblade.modules.equipage.mapper.EquipageMapper;
@@ -12,9 +13,12 @@
import org.springblade.modules.equipage.vo.EquipageVo;
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
import java.util.List;
/**
@@ -28,6 +32,7 @@
private final IUserService userService;
private final IUserDeptService userDeptService;
+ private final MyAsyncService myAsyncService;
@Override
public IPage<EquipageVo> selectEquipagePage(IPage<EquipageVo> page, EquipageVo rquipage) {
@@ -55,11 +60,6 @@
//数据导入
data.forEach(equipageExcel -> {
Equipage equipage = new Equipage();
- //使用责任人身份证号匹配userId
- if (null!=equipageExcel.getIdCardNo() && equipageExcel.getIdCardNo()!=""){
- equipage.setUserId(userService.getUserInfoByIdCardNo(equipageExcel.getIdCardNo()).getId());
- equipage.setPersonInCharge(userService.getUserInfoByIdCardNo(equipageExcel.getIdCardNo()).getRealName());
- }
//使用保安公司名称匹配组织机构id
if (null!=equipageExcel.getDeptName() && equipageExcel.getDeptName()!=""){
equipage.setDeptId(Long.parseLong(userDeptService.selectIn(equipageExcel.getDeptName())));
@@ -77,17 +77,53 @@
equipage.setName(equipageExcel.getName());
}
- if (null!=equipageExcel.getNumber() && equipageExcel.getNumber()!="") {
- equipage.setNumber(equipageExcel.getNumber());
+ if (null!=equipageExcel.getNum()) {
+ equipage.setNum(equipageExcel.getNum());
}
- if (null!=equipageExcel.getSpecifications() && equipageExcel.getSpecifications()!="") {
- equipage.setSpecifications(equipageExcel.getSpecifications());
+ if (null!=equipageExcel.getPersonInCharge() && equipageExcel.getPersonInCharge()!="") {
+ equipage.setPersonInCharge(equipageExcel.getPersonInCharge());
+ }
+
+ if (null!=equipageExcel.getDateForProduction() && !equipageExcel.getDateForProduction().equals("")) {
+ try {
+ equipage.setDateForProduction(new SimpleDateFormat("yyyy/MM/dd").parse(equipageExcel.getDateForProduction()));
+ } catch (ParseException e) {
+ e.printStackTrace();
+ }
}
//插入数据
this.save(equipage);
+ if (null!=equipageExcel.getDateForProduction() && !equipageExcel.getDateForProduction().equals("")) {
+ //数据推送
+ String s1 =
+ "insert into sys_equipage(id,name,mode,dept_id,person_in_charge,brand,date_for_production,num) " +
+ "values(" + "'" + equipage.getId() + "'" + "," +
+ "'" + equipage.getName() + "'" + "," +
+ "'" + equipage.getMode() + "'" + "," +
+ "'" + equipage.getDeptId() + "'" + "," +
+ "'" + equipage.getPersonInCharge() + "'" + "," +
+ "'" + equipage.getBrand() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy/MM/dd").format(equipage.getDateForProduction()) + "'" + "," +
+ "'" + equipage.getNum() + "'" + ")";
+ //FtpUtil.sqlFileUpload(s1);
+ myAsyncService.dataSync(s1);
+ }else {
+ //数据推送
+ String s1 =
+ "insert into sys_equipage(id,name,mode,dept_id,person_in_charge,brand,num) " +
+ "values(" + "'" + equipage.getId() + "'" + "," +
+ "'" + equipage.getName() + "'" + "," +
+ "'" + equipage.getMode() + "'" + "," +
+ "'" + equipage.getDeptId() + "'" + "," +
+ "'" + equipage.getPersonInCharge() + "'" + "," +
+ "'" + equipage.getBrand() + "'" + "," +
+ "'" + equipage.getNum() + "'" + ")";
+ //FtpUtil.sqlFileUpload(s1);
+ myAsyncService.dataSync(s1);
+ }
});
}
}
--
Gitblit v1.9.3