From a0fcede67eeccaacf46f025f655f3c0dc3f5cb8e Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Thu, 23 Sep 2021 09:30:39 +0800
Subject: [PATCH] 1.自招审批
---
src/main/java/org/springblade/modules/apply/controller/ApplyController.java | 20 +++++++++++++-------
1 files changed, 13 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/apply/controller/ApplyController.java b/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
index 24f8b40..a07edc1 100644
--- a/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
+++ b/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
@@ -370,6 +370,12 @@
*/
@PostMapping("/remove")
public R remove(@ApiParam(value = "主键集合") @RequestParam String ids) {
+ List<String> list = Arrays.asList(ids.split(","));
+ list.forEach(id -> {
+ //内网同步
+ String s1 = "delete from sys_apply where id = " + "'" + id + "'";
+ FtpUtil.sqlFileUpload(s1);
+ });
return R.status(applyService.removeByIds(Func.toLongList(ids)));
}
@@ -698,13 +704,13 @@
//内网同步
Long sid = examScore.getId();
String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime());
-// String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " +
-// "values(" + "'" + sid + "'" + "," + "'" +
-// format + "'" + "," + "'" +
-// examScore.getUserId() +"'" + "," +"'" +
-// examScore.getExamId() +"'" + "," +"'" +
-// examScore.getApplyId() + "'" + ")";
-// FtpUtil.sqlFileUpload(s);
+ String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " +
+ "values(" + "'" + sid + "'" + "," + "'" +
+ format + "'" + "," + "'" +
+ examScore.getUserId() +"'" + "," +"'" +
+ examScore.getExamId() +"'" + "," +"'" +
+ examScore.getApplyId() + "'" + ")";
+ FtpUtil.sqlFileUpload(s);
return examScore;
}
--
Gitblit v1.9.3