From 2f5e395632ed97b8aad1ba0d5c7d3ecff397f7fe Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Thu, 16 Sep 2021 10:32:46 +0800
Subject: [PATCH] 1.统计
---
src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java | 37 ++++++++++++++++++++++++++++++-------
1 files changed, 30 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
index 8f959c8..4464d93 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
@@ -260,7 +260,8 @@
} else {
//格式化
DecimalFormat decimalFormat = new DecimalFormat("00000");
- result = pre + (decimalFormat.format(count++));
+ count++;
+ result = pre + (decimalFormat.format(count));
}
user.setSecuritynumber(result);
//发证日期
@@ -268,16 +269,15 @@
//修改为持证保安
user.setHold("1");
//分配保安角色
- Role role = new Role();
- role.setRoleAlias("保安");
- Role oneRole = roleService.getOne(Condition.getQueryWrapper(role));
- user.setRoleId(oneRole.getId().toString());
+// Role role = new Role();
+// role.setRoleAlias("保安");
+// Role oneRole = roleService.getOne(Condition.getQueryWrapper(role));
+// user.setRoleId(oneRole.getId().toString());
//更新保安数据
userService.updateById(user);
String s1 =
- "update blade_user set role_id = " + "'" + user.getRoleId() + "'" +
- ",hold = " + "'" + user.getHold() + "'" +
+ "update blade_user set hold = " + "'" + user.getHold() + "'" +
",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" +
" " +"where id = " + "'" + user.getId() + "'";
@@ -315,4 +315,27 @@
public List<Map<String, Object>> scoreStatistics(String deptid,String jurisdiction) {
return baseMapper.scoreStatistics(deptid,jurisdiction);
}
+ @Override
+ public List<Map<String, Object>> scoreStatisticssc(String deptid,String jurisdiction) {
+ return baseMapper.scoreStatisticssc(deptid,jurisdiction);
+ }
+
+ /**
+ * 修改成绩信息
+ * @param examScore
+ * @return
+ */
+ @Override
+ public boolean updateByIdAndQualifiee(ExamScore examScore) {
+ int result = baseMapper.updateByIdAndQualifiee(examScore);
+ if (result>0){
+ return true;
+ }
+ return false;
+ }
+
+ @Override
+ public IPage<ExamScoreVO> scorePage(IPage page, String deptid, String jurisdiction) {
+ return page.setRecords(baseMapper.scorePage(page,deptid,jurisdiction));
+ }
}
--
Gitblit v1.9.3