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/experience/controller/ExperienceController.java |   59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 57 insertions(+), 2 deletions(-)

diff --git a/src/main/java/org/springblade/modules/experience/controller/ExperienceController.java b/src/main/java/org/springblade/modules/experience/controller/ExperienceController.java
index f00673b..22bf9a8 100644
--- a/src/main/java/org/springblade/modules/experience/controller/ExperienceController.java
+++ b/src/main/java/org/springblade/modules/experience/controller/ExperienceController.java
@@ -28,12 +28,17 @@
 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.experience.entity.Experience;
 import org.springblade.modules.experience.service.IExperienceService;
 import org.springblade.modules.experience.vo.ExperienceVO;
+import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.service.MyAsyncService;
 import org.springframework.web.bind.annotation.*;
 
 import javax.validation.Valid;
+import java.text.SimpleDateFormat;
 import java.util.List;
 import java.util.Map;
 
@@ -50,6 +55,10 @@
 public class ExperienceController extends BladeController {
 
 	private final IExperienceService experienceService;
+
+
+	private final IUserService userService;
+	private final MyAsyncService myAsyncService;
 
 	/**
 	 * 详情
@@ -138,7 +147,53 @@
 	@ApiOperationSupport(order = 6)
 	@ApiOperation(value = "新增或修改", notes = "传入experience")
 	public R submit(@Valid @RequestBody Experience experience) {
-		return R.status(experienceService.saveOrUpdate(experience));
+		boolean status = false;
+		if (null!=experience.getId()){
+			//更新
+			status = experienceService.updateById(experience);
+
+			String s1 =
+				"update sys_experience set name = " + "'" + experience.getName() + "'"
+					+ ",post = " + "'" + experience.getPost() + "'"
+					+ ",department = " + "'" + experience.getDepartment() + "'"
+					+ ",responsibilities = " + "'" + experience.getResponsibilities() + "'"
+					+ ",entryTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(experience.getEntrytime()) + "'"
+					+ ",departureTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(experience.getDeparturetime()) + "'"
+					+ ",leaving = " + "'" + experience.getLeaving() + "'"
+					+ ",cardId = " + "'" + experience.getCardid() + "'"
+					+ ",companyname = " + "'" + experience.getCompanyname() + "'"
+					+ ",securityId = " + "'" + experience.getSecurityid() + "'"
+					+ " " + "where id = " + "'" + experience.getId() + "'";
+			//FtpUtil.sqlFileUpload(s1);
+			myAsyncService.dataSync(s1);
+
+		}else {
+			//新增
+			//查询用户身份证号
+			User user = userService.getById(experience.getSecurityid());
+			experience.setCardid(user.getCardid());
+			experience.setName(user.getRealName());
+			status = experienceService.save(experience);
+
+			//内网同步
+			String s = "insert into sys_experience(id,name,post,department,responsibilities,entryTime,departureTime,leaving," +
+				"cardId,companyname,securityId) " +
+				"values(" + "'" + experience.getId() + "'" +
+				"," + "'" + experience.getName() + "'" +
+				"," + "'" + experience.getPost() + "'" +
+				"," + "'" + experience.getDepartment() + "'" +
+				"," + "'" + experience.getResponsibilities() + "'" +
+				"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(experience.getEntrytime()) + "'" +
+				"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(experience.getDeparturetime()) + "'" +
+				"," + "'" + experience.getLeaving() + "'" +
+				"," + "'" + experience.getCardid() + "'" +
+				"," + "'" + experience.getCompanyname() + "'" +
+				"," + "'" + experience.getSecurityid() + "'"
+				+ ")";
+			//FtpUtil.sqlFileUpload(s);
+			myAsyncService.dataSync(s);
+		}
+		return R.status(status);
 	}
 
 
@@ -154,7 +209,7 @@
 
 	/**
      * 保安就业记录
-	 * @param cardid 身份证
+	 * @param securityid 身份证
 	 * @return
      */
 	@GetMapping("/selectExperienceInfo")

--
Gitblit v1.9.3