From 62eb499b0c969f246d3245d1429a97da4de1ce28 Mon Sep 17 00:00:00 2001
From: 钟日健 <arsn163@163.com>
Date: Mon, 01 Jun 2026 20:46:13 +0800
Subject: [PATCH] feat: 成绩查询增加年龄查询返回
---
src/main/java/org/springblade/modules/desk/controller/NoticeController.java | 81 ++++++++++++++++++++++------------------
1 files changed, 45 insertions(+), 36 deletions(-)
diff --git a/src/main/java/org/springblade/modules/desk/controller/NoticeController.java b/src/main/java/org/springblade/modules/desk/controller/NoticeController.java
index 29dcb55..5d89134 100644
--- a/src/main/java/org/springblade/modules/desk/controller/NoticeController.java
+++ b/src/main/java/org/springblade/modules/desk/controller/NoticeController.java
@@ -36,6 +36,7 @@
import org.springblade.modules.desk.wrapper.NoticeWrapper;
import org.springblade.modules.system.entity.Dept;
import org.springblade.modules.system.service.IDeptService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.web.bind.annotation.*;
import springfox.documentation.annotations.ApiIgnore;
@@ -60,6 +61,7 @@
private final INoticeService noticeService;
private final IDeptService iDeptService;
+ private final MyAsyncService myAsyncService;
/**
* 详情
@@ -128,46 +130,52 @@
@PostMapping("/submit")
@ApiOperationSupport(order = 6)
@ApiOperation(value = "新增或修改", notes = "传入notice")
- public R submit(@RequestBody Notice notice){
+ public R submit(@RequestBody Notice notice) {
boolean status = false;
- if (null==notice.getId()) {
+ if (null == notice.getId()) {
//新增
status = noticeService.save(notice);
notice.setIsDeleted(0);
- //数据同步
- String s1 =
- "insert into blade_notice(id,title,category,release_time,content,create_user,create_dept,create_time,is_deleted,dept_id,cover_url,type) " +
- "values(" + "'" + notice.getId() + "'" + "," +
- "'" + notice.getTitle() + "'" + "," +
- "'" + notice.getCategory() + "'" + "," +
- "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getReleaseTime()) + "'" + "," +
- "'" + notice.getContent() + "'" + "," +
- "'" + notice.getCreateUser() + "'" + "," +
- "'" + notice.getCreateDept() + "'" + "," +
- "'" + new SimpleDateFormat("yyyy-MM-dd").format(notice.getCreateTime()) + "'" + "," +
- "'" + notice.getIsDeleted() + "'" + "," +
- "'" + notice.getDeptId() + "'" + "," +
- "'" + notice.getCoverUrl() + "'" + "," +
- "'" +notice.getType() + "'" + ")";
- FtpUtil.sqlFileUpload(s1);
- }else {
+ if (status) {
+ //数据同步
+ String s1 =
+ "insert into blade_notice(id,title,category,release_time,content,create_user,create_dept,create_time,is_deleted,dept_id,cover_url,type) " +
+ "values(" + "'" + notice.getId() + "'" + "," +
+ "'" + notice.getTitle() + "'" + "," +
+ "'" + notice.getCategory() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getReleaseTime()) + "'" + "," +
+ "'" + notice.getContent() + "'" + "," +
+ "'" + notice.getCreateUser() + "'" + "," +
+ "'" + notice.getCreateDept() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd").format(notice.getCreateTime()) + "'" + "," +
+ "'" + notice.getIsDeleted() + "'" + "," +
+ "'" + notice.getDeptId() + "'" + "," +
+ "'" + notice.getCoverUrl() + "'" + "," +
+ "'" + notice.getType() + "'" + ")";
+ //FtpUtil.sqlFileUpload(s1);
+ myAsyncService.dataSync(s1);
+ }
+ } else {
//修改
status = noticeService.updateById(notice);
- //内网同步
- String s1 =
- "update blade_notice set title = " + "'" + notice.getTitle() + "'" +
- ",category = " + "'" + notice.getCategory() + "'" +
- ",release_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getReleaseTime()) + "'" +
- ",content = " + "'" + notice.getContent() + "'" +
- ",create_user = " + "'" + notice.getCreateUser() + "'" +
- ",create_dept = " + "'" + notice.getCreateDept() + "'" +
- ",create_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getCreateTime()) + "'" +
- ",is_deleted = " + "'" + notice.getIsDeleted() + "'" +
- ",dept_id = " + "'" + notice.getDeptId() + "'" +
- ",cover_url = " + "'" + notice.getCoverUrl() + "'" +
- ",type = " + "'" + notice.getType() + "'" +
- " " +"where id = " + "'" + notice.getId() + "'";
- FtpUtil.sqlFileUpload(s1);
+ if (status) {
+ //内网同步
+ String s1 =
+ "update blade_notice set title = " + "'" + notice.getTitle() + "'" +
+ ",category = " + "'" + notice.getCategory() + "'" +
+ ",release_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getReleaseTime()) + "'" +
+ ",content = " + "'" + notice.getContent() + "'" +
+ ",create_user = " + "'" + notice.getCreateUser() + "'" +
+ ",create_dept = " + "'" + notice.getCreateDept() + "'" +
+ ",create_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(notice.getCreateTime()) + "'" +
+ ",is_deleted = " + "'" + notice.getIsDeleted() + "'" +
+ ",dept_id = " + "'" + notice.getDeptId() + "'" +
+ ",cover_url = " + "'" + notice.getCoverUrl() + "'" +
+ ",type = " + "'" + notice.getType() + "'" +
+ " " + "where id = " + "'" + notice.getId() + "'";
+ //FtpUtil.sqlFileUpload(s1);
+ myAsyncService.dataSync(s1);
+ }
}
return R.status(status);
}
@@ -181,10 +189,11 @@
public R remove(@ApiParam(value = "主键集合") @RequestParam String ids) throws Exception {
//内网删除
List<Long> list = Func.toLongList(ids);
- list.forEach(id ->{
+ list.forEach(id -> {
//内网同步
String s1 = "delete from blade_notice where id = " + "'" + id + "'";
- FtpUtil.sqlFileUpload(s1);
+ //FtpUtil.sqlFileUpload(s1);
+ myAsyncService.dataSync(s1);
});
boolean temp = noticeService.deleteLogic(Func.toLongList(ids));
return R.status(temp);
--
Gitblit v1.9.3