证书打印信息导出修改

Administrator

2021-11-17 7293f04d18fb2e882e152f962c3aa1d8fcb1f93e

 src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java

@@ -12,6 +12,7 @@
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.exam.entity.ExamPaper;
@@ -156,11 +157,13 @@
         if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
            //合格
            examScore.setQualified(0);
            //设置为未制证的状态
            user1.setUserType(7);
            //正式考试通过生成保安证编号
            ExamPaper paper = examPaperService.getById(examScore.getExamId());
//            if (paper.getExamType() == 1) {
            //如果已有保安证编号，不更新用户信息
            if (null==user1.getSecuritynumber() || user1.getSecuritynumber()=="") {
            if (null==user1.getSecuritynumber() || user1.getSecuritynumber().equals("")) {
               //去生成保安证编号
               String pre = SecurityPaperUtil.getSecurityPaper();
               //查询当前年份已有的保安证编号
@@ -176,7 +179,7 @@
               }
               user1.setSecuritynumber(result);
               //发证日期
               user1.setPaperTime(new Date());
//               user1.setPaperTime(new Date());
               //修改为持证保安
               user1.setHold("1");
               //分配保安角色
@@ -190,7 +193,7 @@
               String s1 =
                  "update blade_user set hold = " + "'" + user1.getHold() + "'" +
                     ",securitynumber = " + "'" + user1.getSecuritynumber() + "'" +
                     ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user1.getPaperTime()) + "'" +
                     ",user_type = " + "'" + user1.getUserType() + "'" +
                     " " + "where id = " + "'" + user1.getId() + "'";
               FtpUtil.sqlFileUpload(s1);
            }
@@ -324,7 +327,7 @@
      try {
         response.setContentType("application/vnd.ms-excel");
         response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name());
         fileName = URLEncoder.encode("实操成绩数据模板", Charsets.UTF_8.name());
         fileName = URLEncoder.encode("实操成绩数据模板"+ DateUtil.time(), Charsets.UTF_8.name());
         response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
         //修改单元格格式为文本格式
         EasyExcel.write(response.getOutputStream(), ExamScoreExcel.class).sheet("实操成绩数据表").registerWriteHandler(new RowWriteHandler()).doWrite(list);