From c9424db1c23fcddd6f4eabdb5e3ef51d2c208613 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 24 Aug 2021 16:09:49 +0800
Subject: [PATCH] 派遣记录，单位数据内网推送
---
src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java | 78 +++++++++++++++++++++++++++------------
1 files changed, 54 insertions(+), 24 deletions(-)
diff --git a/src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java b/src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java
index 4ecca78..35d5456 100644
--- a/src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java
+++ b/src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java
@@ -28,6 +28,7 @@
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
+import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.dispatcher.service.IDispatcherUnitService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
@@ -38,6 +39,7 @@
import org.springblade.modules.dispatcher.service.IDispatcherService;
import org.springblade.core.boot.ctrl.BladeController;
+import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.List;
@@ -103,7 +105,6 @@
//计算派遣人数
// dispatcher.setNum(Arrays.asList(dispatcher.getUserIds().split(",")).size());
//查询派遣单位的信息,设置行政区
- dispatcher.setJurisdiction(dispatcherUnitService.getById(dispatcher.getDispatcherUnitId()).getJurisdiction().toString());
}
return R.status(dispatcherService.save(dispatcher));
}
@@ -125,25 +126,33 @@
@ApiOperationSupport(order = 6)
@ApiOperation(value = "新增或修改", notes = "传入dispatcher")
public R submit(@Valid @RequestBody Dispatcher dispatcher) {
+ //List<String> list = Arrays.asList(dispatcher.getUserIds().split(","));
+ //计算派遣人数
+ //dispatcher.setNum(list.size());
+ boolean status = false;
if (dispatcher.getId()==null){
- if (null!=dispatcher.getUserIds() && dispatcher.getUserIds()!=""){
-// List<String> list = Arrays.asList(dispatcher.getUserIds().split(","));
-// //计算派遣人数
-// dispatcher.setNum(list.size());
- //修改保安人员的派遣状态
- User user = new User();
- user.setId(Long.parseLong(dispatcher.getUserIds()));
- user.setDispatch("0");
- userService.updateById(user);
- //查询派遣单位的信息,设置行政区
- dispatcher.setJurisdiction(dispatcherUnitService.getById(dispatcher.getDispatcherUnitId()).getJurisdiction().toString());
- }
- }
- else {
- if (null != dispatcher.getUserIds() && dispatcher.getUserIds() != "") {
-// List<String> list = Arrays.asList(dispatcher.getUserIds().split(","));
- //计算派遣人数
-// dispatcher.setNum(list.size());
+ User user = new User();
+ user.setId(Long.parseLong(dispatcher.getUserIds()));
+ user.setDispatch("0");
+ userService.updateById(user);
+
+ //新增派遣记录
+ status = dispatcherService.save(dispatcher);
+
+ //数据同步
+ String s1 =
+ "insert into sys_dispatcher(id,dispatcherTime,dispatcher_unit_id,user_ids,end_time,dept_id,jurisdiction) " +
+ "values(" + "'" + dispatcher.getId() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getDispatchertime()) + "'" + "," +
+ "'" + dispatcher.getDispatcherUnitId() + "'" + "," +
+ "'" + dispatcher.getUserIds() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getEndTime()) + "'" + "," +
+ "'" + dispatcher.getDeptId() + "'" + "," +
+ "'" +dispatcher.getJurisdiction() + "'" + ");" +
+ "update blade_user set dispatch = " + "'" + user.getDispatch() + "'" +
+ " " +"where id = " + "'" + user.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
+ }else {
//查询当前派遣记录
Dispatcher dispatcher1 = dispatcherService.getById(dispatcher.getId());
if (!dispatcher1.getUserIds().equals(dispatcher.getUserIds())){
@@ -158,12 +167,28 @@
user1.setId(Long.parseLong(dispatcher.getUserIds()));
user1.setDispatch("0");
userService.updateById(user1);
+
+ //修改
+ status = dispatcherService.updateById(dispatcher);
+
+ //内网同步
+ String s1 =
+ "update blade_user set dispatch = " + "'" + user.getDispatch() + "'" +
+ " " +"where id = " + "'" + user.getId() + "';"+
+ "update sys_dispatcher set dispatcherTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getDispatchertime()) + "'" +
+ ",dispatcher_unit_id = " + "'" + dispatcher.getDispatcherUnitId() + "'" +
+ ",user_ids = " + "'" + dispatcher.getUserIds() + "'" +
+ ",end_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getEndTime()) + "'" +
+ ",dept_id = " + "'" + dispatcher.getDeptId() + "'" +
+ ",jurisdiction = " + "'" + dispatcher.getJurisdiction() + "'" +
+ " " +"where id = " + "'" + user.getId() + "';"+
+ "update blade_user set dispatch = " + "'" + user1.getDispatch() + "'" +
+ " " +"where id = " + "'" + user1.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
}
- //查询派遣单位的信息,设置行政区
- dispatcher.setJurisdiction(dispatcherUnitService.getById(dispatcher.getDispatcherUnitId()).getJurisdiction().toString());
- }
+
}
- return R.status(dispatcherService.saveOrUpdate(dispatcher));
+ return R.status(status);
}
@@ -175,7 +200,12 @@
@ApiOperation(value = "删除", notes = "传入ids")
public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
//内网删除
- //arg.sendPostRemoveByIds(arg.url+"/dispatcher/remove",ids);
+ List<Long> list = Func.toLongList(ids);
+ list.forEach(id ->{
+ //内网同步
+ String s1 = "delete from sys_dispatcher where id = " + "'" + id + "'";
+ FtpUtil.sqlFileUpload(s1);
+ });
return R.status(dispatcherService.removeByIds(Func.toLongList(ids)));
}
--
Gitblit v1.9.3