From 08363052cecb30230a2c8b3eba791ca8d1be00a5 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 31 Aug 2021 15:32:38 +0800
Subject: [PATCH] 二维码生成地址修改，保安证编码生成修改
---
src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java | 264 +++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 229 insertions(+), 35 deletions(-)
diff --git a/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java b/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
index fbdcb02..c2ec3d2 100644
--- a/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
+++ b/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
@@ -1,6 +1,7 @@
package org.springblade.modules.apply.service.impl;
+import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
@@ -11,6 +12,9 @@
import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination;
import org.springblade.common.utils.arg;
import org.springblade.core.mp.support.Condition;
+import org.springblade.core.tool.api.R;
+import org.springblade.modules.FTP.FtpUtil;
+import org.springblade.modules.FTP.OutJson;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyExcel;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
@@ -19,17 +23,24 @@
import org.springblade.modules.apply.vo.ApplyPaPerVO;
import org.springblade.modules.apply.vo.ApplyVO;
import org.springblade.modules.exam.entity.ExamPaper;
+import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.service.ExamPaperService;
+import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.training.entity.TrainingRegistration;
+import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileNotFoundException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
-import java.util.Date;
-import java.util.List;
-import java.util.UUID;
+import java.util.*;
+
+import static org.springblade.common.constant.FtpConstant.*;
/**
* 考试报名服务实现类
@@ -43,6 +54,8 @@
private final ExamPaperService examPaperService;
private final IUserService userService;
+
+ private final TrainingRegistrationService trainingRegistrationService;
/**
* 自定义分页数据
@@ -85,26 +98,85 @@
}
+ /**
+ * 导入报名信息
+ * @param data
+ * @param isCovered
+ */
@Override
@Transactional(rollbackFor = Exception.class)
- public void importApply(List<ApplyInfoExcel> data, Boolean isCovered) {
- data.forEach(applyInfoExcel -> {
- //通过准考证号
- if (null!=applyInfoExcel.getCandidateNo() && applyInfoExcel.getIdCardNo()!=""){
- Apply apply = new Apply();
- apply.setCandidateNo(applyInfoExcel.getCandidateNo());
- //查询报名信息
- Apply apply1 = baseMapper.selectOne(Condition.getQueryWrapper(apply));
- apply1.setIsExam(2);
- baseMapper.updateById(apply1);
- //内网新增
- try {
-// arg.test01(arg.url+"/apply/update",apply1);
- } catch (Exception e) {
- e.printStackTrace();
+ public void importApply(List<ApplyExcel> data, Boolean isCovered,Long examId) {
+ data.forEach(applyExcel -> {
+ //查询用户信息
+ User user = new User();
+ user.setCardid(applyExcel.getIdCardNo());
+ User user1 = userService.getOne(Condition.getQueryWrapper(user));
+ if (null!=user1){
+ //未报名的新增，已报名的不做处理
+ if (null==user1.getIsApply()) {
+ Apply apply1 = new Apply();
+ apply1.setApplyStatus(2);
+ //默认为未考试状态
+ apply1.setIsExam(1);
+ apply1.setApplyTime(new Date());
+ apply1.setUserId(user1.getId());
+ if (null!=examId){
+ apply1.setExamId(examId);
+ //生成准考证号
+ apply1.setCandidateNo(getCandidateNo(apply1));
+ }
+
+ this.save(apply1);
+ //修改保安报名状态
+ user1.setIsApply(1);
+ userService.updateById(user1);
+
+ String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
+ Long id = apply1.getId();
+ String s = "insert into sys_apply(id,user_id,candidate_no,apply_time,apply_status,exam_id,is_exam) " +
+ "values(" + "'" + id + "'" + ","
+ + "'" + apply1.getUserId() + "'" + ","
+ + "'" + apply1.getCandidateNo() + "'" + ","
+ + "'" + formatStr +"'" + ","
+ + "'" + apply1.getApplyStatus() + "'" + ","
+ + "'" + examId + "'" + ","
+ +"'" + apply1.getIsExam() + "'" + ");" +
+ "update blade_user set is_apply = " + "'" + user1.getIsApply() + "'" +"where id = " + "'" + user1.getId() + "'";
+ FtpUtil.sqlFileUpload(s);
+ }else {
+ if (user1.getIsApply()!=1) {
+ Apply apply1 = new Apply();
+ apply1.setApplyStatus(2);
+ //默认为未考试状态
+ apply1.setIsExam(1);
+ apply1.setApplyTime(new Date());
+ apply1.setUserId(user1.getId());
+ if (null!=examId){
+ apply1.setExamId(examId);
+ //生成准考证号
+ apply1.setCandidateNo(getCandidateNo(apply1));
+ }
+ this.save(apply1);
+ //修改保安报名状态
+ user1.setIsApply(1);
+ userService.updateById(user1);
+
+ //内网数据同步
+ String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
+ Long id = apply1.getId();
+ String s = "insert into sys_apply(id,user_id,candidate_no,apply_time,apply_status,exam_id,is_exam) " +
+ "values(" + "'" + id + "'" + ","
+ + "'" + apply1.getUserId() + "'" + ","
+ + "'" + apply1.getCandidateNo() + "'" + ","
+ + "'" + formatStr +"'" + ","
+ + "'" + apply1.getApplyStatus() + "'" + ","
+ + "'" + examId + "'" + ","
+ +"'" + apply1.getIsExam() + "'" + ");" +
+ "update blade_user set is_apply = " + "'" + user1.getIsApply() + "'" +"where id = " + "'" + user1.getId() + "'";
+ FtpUtil.sqlFileUpload(s);
+ }
}
}
-
});
}
@@ -121,9 +193,9 @@
String year = format.substring(2,4);
String quarter = null;
String months = null;
- String days = null;
int month = Integer.parseInt(format.substring(5,7));
int day = Integer.parseInt(format.substring(8,10));
+ String days = null;
if (month>0 && month<=3){
quarter = "C";
}
@@ -141,19 +213,34 @@
}
if (day<=9){
days = "0" + day;
+ }else {
+ days = ""+day;
+ }
+ String type = null;
+ if (examPaper.getExamType()==1){
+ type = "z";
+ }
+ if (examPaper.getExamType()==2){
+ type = "m";
}
//获取考试名称前缀,去除数字，字母
String examName
= examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1);
//前缀 = 年的最后两位 + 月份（两位） + 考试名称（中文拼音）首字母（去除数字，字母） + 考试类型 + 季度拼音首字母大写（春季就是 C）
+// String result = year
+// + months
+// + toFirstChar(examName).toUpperCase()
+// + examPaper.getExamType()
+// + quarter;
+
+ //前缀 = 年的最后两位 + 月份（两位） + 日 （两位） + 考试类型 正式考试 z 模拟考试 m
String result = year
+ months
- + toFirstChar(examName).toUpperCase()
- + examPaper.getExamType()
- + quarter;
+ + days
+ + type;
//查询是当前前缀已生成的数量
- int count = getCandidateNoCount(result);
+ int count = this.getCandidateNoCount(result);
if (count==0){
return result + "0000";
}
@@ -253,25 +340,22 @@
//正式考试
if (apply.getApplyExamType()==1){
ApplyPaPerVO applyPaPerVO = baseMapper.getApplyInfo(apply);
- String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[0];
- String startTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[1];
- String endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getEndTime()).split(" ")[1];
- applyPaPerVO.setStringTime(time+" "+startTime.substring(0,startTime.length()-3) +"-"+ endTime.substring(0,endTime.length()-3));
+// String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[0];
+// String startTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[1];
+// String endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getEndTime()).split(" ")[1];
+ applyPaPerVO.setStringTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()));
return applyPaPerVO;
}
//模拟考试
if (apply.getApplyExamType()==2){
ApplyPaPerVO applyPaPerVO = baseMapper.getTrainApplyInfo(apply);
- String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[0];
- String startTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[1];
- String endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getEndTime()).split(" ")[1];
- applyPaPerVO.setStringTime(time+" "+startTime.substring(0,startTime.length()-3) +"-"+ endTime.substring(0,endTime.length()-3));
+// String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[0];
+// String startTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()).split(" ")[1];
+// String endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getEndTime()).split(" ")[1];
+ applyPaPerVO.setStringTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(applyPaPerVO.getStartTime()));
return applyPaPerVO;
}
-
-
-
return null;
}
@@ -294,4 +378,114 @@
public Integer getIsApply(Apply apply) {
return baseMapper.getIsApply(apply);
}
+
+ /**
+ * 查询人员是否已报名
+ * @param apply
+ * @return
+ */
+ @Override
+ public List<Apply> getSecurityApplyInfo(Apply apply) {
+ return baseMapper.getSecurityApplyInfo(apply);
+ }
+
+ /**
+ * 查询报名人员未关联考试的ids集合
+ * @return
+ */
+ @Override
+ public List<Long> getApplyIds() {
+ return baseMapper.getApplyIds();
+ }
+
+ /**
+ * 查询报名清册信息
+ * @param apply 报名信息
+ * @return
+ */
+ @Override
+ public Map<String,Object> getApplyDetailList(ApplyVO apply) {
+ //创建 map 对象
+ Map<String, Object> map = new HashMap<>(3);
+ //查询考试信息
+ ExamPaper paper = examPaperService.getById(apply.getExamId());
+ map.put("examName",paper.getExamName());
+
+ int num = 0;
+ if (paper.getExamType()==1){
+ //查询已报名的总人数
+ num = baseMapper.getApplyDeatailNum(paper.getId());
+ map.put("num",num);
+ //查询已报名的的人信息集合
+ List<ApplyVO> applyVOList = baseMapper.getApplyDetailList(paper.getId());
+ map.put("applyList",applyVOList);
+ }
+
+ //模拟考试
+ if (paper.getExamType()==2){
+ //查询已报名的总人数
+ num = baseMapper.getTrainDeatailNum(paper.getId());
+ map.put("num",num);
+ //查询已报名的的人信息集合
+ List<ApplyVO> applyVOList = baseMapper.getTrainDetailList(paper.getId());
+ map.put("applyList",applyVOList);
+ }
+
+ //返回数据
+ return map;
+ }
+
+ /**
+ * 查询保安员个人报名信息
+ * @param apply 报名信息，包含userId
+ * @return
+ */
+ @Override
+ public ApplyVO getSecurityApplyDetail(ApplyVO apply) {
+ return baseMapper.getSecurityApplyDetail(apply);
+ }
+
+
+ /**
+ * 修改考试状态
+ * @param apply 报名信息，包含userId，applyid
+ * @return
+ */
+ @Override
+ public void updateApplyStatus(ApplyVO apply) {
+ //正式考
+ if (apply.getExamType()==1){
+ Apply apply1 = new Apply();
+ apply1.setId(apply.getId());
+ //考试中
+ apply1.setIsExam(3);
+ baseMapper.updateById(apply1);
+
+// String s1 =
+// "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
+// FtpUtil.sqlFileUpload(s1);
+ }
+ //模拟考
+ if (apply.getExamType()==2){
+ TrainingRegistration trainingRegistration = new TrainingRegistration();
+ trainingRegistration.setId(apply.getId());
+ //考试中
+ trainingRegistration.setIsExam(3);
+ trainingRegistrationService.updateById(trainingRegistration);
+
+// String s1 =
+// "update sys_training_registration set is_exam = " + trainingRegistration.getIsExam() + " " +"where id = " + "'" + trainingRegistration.getId() + "'";
+// FtpUtil.sqlFileUpload(s1);
+ }
+ }
+
+ /**
+ * 查询报名信息，取最新的一条（即当前userId,）applyId最大的一条记录
+ * @param userId
+ * @return
+ */
+ @Override
+ public Apply getMaxApplyIdByUserIdInfo(Long userId) {
+ return baseMapper.getMaxApplyIdByUserIdInfo(userId);
+ }
}
--
Gitblit v1.9.3