成绩统计

zengh

2021-08-27 5c2d7fcc8450e02fd51ea6a20e34567068c7f31f

 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java

@@ -34,6 +34,7 @@
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import java.util.Map;

@@ -262,6 +263,8 @@
                           result = pre + (decimalFormat.format(count++));
                        }
                        user.setSecuritynumber(result);
                        //发证日期
                        user.setPaperTime(new Date());
                        //修改为持证保安
                        user.setHold("1");
                        //分配保安角色
@@ -276,6 +279,7 @@
                           "update blade_user set role_id = " + "'" +  user.getRoleId() + "'" +
                              ",hold = " + "'" + user.getHold() + "'" +
                              ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
                              ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" +
                              " " +"where id = " + "'" + user.getId() + "'";
                        FtpUtil.sqlFileUpload(s1);
                     }
@@ -308,7 +312,7 @@
   }

   @Override
   public List<Map<String, Object>> scoreStatistics() {
      return baseMapper.scoreStatistics();
   public List<Map<String, Object>> scoreStatistics(String deptid,String jurisdiction) {
      return baseMapper.scoreStatistics(deptid,jurisdiction);
   }
}