package com.xjrsoft.module.student.service.impl; import cn.dev33.satoken.stp.StpUtil; import cn.hutool.core.util.IdUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.support.ExcelTypeEnum; import com.alibaba.excel.write.metadata.WriteSheet; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.yulichang.base.MPJBaseServiceImpl; import com.github.yulichang.toolkit.MPJWrappers; import com.github.yulichang.wrapper.MPJLambdaWrapper; import com.xjrsoft.common.enums.AssessmentTypeEnum; import com.xjrsoft.common.enums.DeleteMark; import com.xjrsoft.common.enums.EnabledMark; import com.xjrsoft.common.enums.EvaluateTypeEnum; import com.xjrsoft.common.enums.ScoreTypeEnum; import com.xjrsoft.common.model.result.RT; import com.xjrsoft.common.utils.VoToColumnUtil; import com.xjrsoft.common.utils.excel.ExcelMergeUtil; import com.xjrsoft.module.base.entity.BaseClass; import com.xjrsoft.module.base.mapper.BaseClassMapper; import com.xjrsoft.module.evaluate.dto.TeaEvaluateClassDto; import com.xjrsoft.module.evaluate.mapper.EvaluateResultMapper; import com.xjrsoft.module.evaluate.vo.TeaEvaluateClassListVo; import com.xjrsoft.module.organization.dto.WeChatSendMessageDto; import com.xjrsoft.module.organization.entity.User; import com.xjrsoft.module.organization.service.IUserService; import com.xjrsoft.module.organization.service.IWeChatService; import com.xjrsoft.module.student.dto.BaseStudentAssessmentInspectionMobilePageDto; import com.xjrsoft.module.student.dto.BaseStudentAssessmentInspectionPageDto; import com.xjrsoft.module.student.dto.CalssQuantitativeAssessmentPageDto; import com.xjrsoft.module.student.dto.QuantitativeAssessmentExcelDto; import com.xjrsoft.module.student.dto.QuantitativeAssessmentSingleScoreDto; import com.xjrsoft.module.student.entity.BaseClassMajorSet; import com.xjrsoft.module.student.entity.BaseStudentAssessmentCategory; import com.xjrsoft.module.student.entity.BaseStudentAssessmentClassRelation; import com.xjrsoft.module.student.entity.BaseStudentAssessmentInspection; import com.xjrsoft.module.student.entity.BaseStudentAssessmentProject; import com.xjrsoft.module.student.entity.BaseStudentAssessmentStudentRelation; import com.xjrsoft.module.student.entity.BaseStudentSchoolRoll; import com.xjrsoft.module.student.mapper.BaseStudentAssessmentCategoryMapper; import com.xjrsoft.module.student.mapper.BaseStudentAssessmentClassRelationMapper; import com.xjrsoft.module.student.mapper.BaseStudentAssessmentInspectionMapper; import com.xjrsoft.module.student.mapper.BaseStudentAssessmentProjectMapper; import com.xjrsoft.module.student.mapper.BaseStudentAssessmentStudentRelationMapper; import com.xjrsoft.module.student.mapper.BaseStudentSchoolRollMapper; import com.xjrsoft.module.student.service.IBaseStudentAssessmentInspectionService; import com.xjrsoft.module.student.service.IQuotaFormulaRuleService; import com.xjrsoft.module.student.vo.BaseStudentAssessmentClassListVo; import com.xjrsoft.module.student.vo.BaseStudentAssessmentInspectionMobilePageVo; import com.xjrsoft.module.student.vo.BaseStudentAssessmentInspectionMobileVo; import com.xjrsoft.module.student.vo.BaseStudentAssessmentInspectionPageVo; import com.xjrsoft.module.student.vo.BaseStudentAssessmentInspectionVo; import com.xjrsoft.module.student.vo.CalssQuantitativeAssessmentPageVo; import com.xjrsoft.module.student.vo.QuantitativeAssessmentSingleScoreVo; import com.xjrsoft.module.student.vo.QuantitativeAssessmentSubTableExcelVo; import com.xjrsoft.module.system.entity.File; import com.xjrsoft.module.system.service.IFileService; import com.xjrsoft.module.teacher.entity.XjrUser; import lombok.AllArgsConstructor; import me.zhyd.oauth.log.Log; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.Font; import org.apache.poi.ss.usermodel.HorizontalAlignment; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.VerticalAlignment; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.BeanUtils; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.script.ScriptEngine; import javax.script.ScriptEngineManager; import javax.script.ScriptException; import java.io.ByteArrayOutputStream; import java.io.IOException; import java.math.BigDecimal; import java.math.RoundingMode; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.temporal.TemporalAdjusters; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; /** * @title: 学生班级巡查考核 * @Author dzx * @Date: 2023-11-16 * @Version 1.0 */ @Service @AllArgsConstructor public class BaseStudentAssessmentInspectionServiceImpl extends MPJBaseServiceImpl implements IBaseStudentAssessmentInspectionService { private final BaseStudentAssessmentInspectionMapper assessmentInspectionMapper; private final BaseStudentAssessmentCategoryMapper categoryMapper; private final BaseStudentAssessmentProjectMapper projectMapper; private final BaseStudentAssessmentStudentRelationMapper assessmentStudentRelationMapper; private final BaseStudentAssessmentClassRelationMapper assessmentClassRelationMapper; private final BaseClassMapper baseClassMapper; private final BaseStudentSchoolRollMapper baseStudentSchoolRollMapper; private final IFileService fileService; private final IUserService userService; private final IWeChatService weChatService; private final EvaluateResultMapper evaluateResultMapper; private final IQuotaFormulaRuleService quotaFormulaRuleService; @Override public Page getPage(Page page, BaseStudentAssessmentInspectionPageDto dto) { Page result = assessmentInspectionMapper.getPage(page, dto); // 处理加减分 result.getRecords().forEach((node) -> { if (node.getScoreType().equals(ScoreTypeEnum.ScoreMinus.getCode())) { node.setScore(node.getScore() * -1); } }); return result; } @Override public BaseStudentAssessmentInspectionVo getInfo(Long id) { BaseStudentAssessmentInspectionVo result = assessmentInspectionMapper.getInfo(id); // 获取班级信息 List baseStudentAssessmentClassListVos = assessmentClassRelationMapper.selectJoinList(BaseStudentAssessmentClassListVo.class, MPJWrappers.lambdaJoin() .leftJoin(BaseClass.class, BaseClass::getId, BaseStudentAssessmentClassRelation::getClassId) .leftJoin(XjrUser.class, XjrUser::getId, BaseClass::getTeacherId) .eq(BaseStudentAssessmentClassRelation::getBaseStudentAssessmentInspectionId, id) .select(BaseStudentAssessmentClassRelation::getId) .selectAs(BaseClass::getName, BaseStudentAssessmentClassListVo::getClassName) .selectAs(XjrUser::getName, BaseStudentAssessmentClassListVo::getTeacherName) .selectAs(XjrUser::getMobile, BaseStudentAssessmentClassListVo::getMobile) .select(BaseStudentAssessmentClassRelation.class, x -> VoToColumnUtil.fieldsToColumns(BaseStudentAssessmentClassRelation.class).contains(x.getProperty())) ); result.setClassList(baseStudentAssessmentClassListVos); // 获取学生信息 result.setStudentList(assessmentInspectionMapper.getStudentListByInspectionId(id)); // 获取文件列表 result.setFileInfos(fileService.list(Wrappers.query().lambda().eq(File::getFolderId, result.getFileId()))); return result; } @Override public Page getMobilePage(Page page, BaseStudentAssessmentInspectionMobilePageDto dto) { if (dto.getClassIds() == null || dto.getClassIds().isEmpty()) { // 获取当前用户所管班级 List classIds = baseClassMapper.selectList( Wrappers.query().lambda() .eq(BaseClass::getTeacherId, StpUtil.getLoginIdAsLong()) .select(BaseClass::getId) ).stream().map(BaseClass::getId).collect(Collectors.toList()); dto.setClassIds(classIds); } if (dto.getClassIds() == null || dto.getClassIds().isEmpty()) { return null; } return assessmentInspectionMapper.getMobilePage(page, dto); } @Override public BaseStudentAssessmentInspectionMobileVo getMobileInfo(Long id) { BaseStudentAssessmentInspectionMobileVo result = assessmentInspectionMapper.getMobileInfo(id); // 处理加减分 if (result.getScoreType().equals(ScoreTypeEnum.ScoreMinus.getCode())) { result.setScore(result.getScore() * -1); } MPJLambdaWrapper baseStudentAssessmentStudentRelationWrapper = new MPJLambdaWrapper<>(); baseStudentAssessmentStudentRelationWrapper .select(BaseStudentAssessmentStudentRelation::getId) .selectAs(XjrUser::getName,BaseStudentAssessmentStudentRelation::getName) .selectAs(XjrUser::getCredentialNumber,BaseStudentAssessmentStudentRelation::getStudentId) .eq(BaseStudentAssessmentStudentRelation::getBaseStudentAssessmentInspectionId, result.getBaseStudentAssessmentInspectionId()) .eq(BaseStudentAssessmentStudentRelation::getClassId, result.getClassId()) .leftJoin(XjrUser.class, XjrUser::getId, BaseStudentAssessmentStudentRelation::getUserId) .eq(BaseStudentAssessmentStudentRelation::getDeleteMark, DeleteMark.NODELETE.getCode()) .eq(BaseStudentAssessmentStudentRelation::getEnabledMark, EnabledMark.ENABLED.getCode()) ; // 获取学生信息 List baseStudentAssessmentStudentRelations = assessmentStudentRelationMapper.selectList(baseStudentAssessmentStudentRelationWrapper); result.setStudentList(baseStudentAssessmentStudentRelations); result.setStudentCount(baseStudentAssessmentStudentRelations.size()); // 获取文件列表 result.setFileInfos(fileService.list(Wrappers.query().lambda().eq(File::getFolderId, result.getFileId()))); return result; } @Override public ResponseEntity getQuantitativeAssessmentExcelByte(QuantitativeAssessmentExcelDto dto) { //导出的文件名，字节流 String fileName = "StudentAssessmentInspection" + ExcelTypeEnum.XLSX.getValue(); ByteArrayOutputStream bot = new ByteArrayOutputStream(); //获取需要导出的子表 List baseStudentAssessmentCategoryIdList = new ArrayList<>(); baseStudentAssessmentCategoryIdList.add(1768178717588197377L); baseStudentAssessmentCategoryIdList.add(1768179375900987394L); baseStudentAssessmentCategoryIdList.add(1769927649167151105L); LambdaQueryWrapper baseStudentAssessmentCategoryLambdaQueryWrapper = new LambdaQueryWrapper<>(); baseStudentAssessmentCategoryLambdaQueryWrapper .in(BaseStudentAssessmentCategory::getId, baseStudentAssessmentCategoryIdList); List baseStudentAssessmentCategorieList = categoryMapper.selectList(baseStudentAssessmentCategoryLambdaQueryWrapper); //导出子表 if(!baseStudentAssessmentCategorieList.isEmpty()){ //需要合并的列 int[] mergeColumeIndex = {0, 1, 2, 3, 4}; ExcelMergeUtil excelFillCellMergeStrategy = new ExcelMergeUtil(1, mergeColumeIndex); //开始处理写入 try (ExcelWriter excelWriter = EasyExcel.write(bot, QuantitativeAssessmentSubTableExcelVo.class).registerWriteHandler(excelFillCellMergeStrategy).build()) { int no = 1; for (BaseStudentAssessmentCategory bsac : baseStudentAssessmentCategorieList) { dto.setBaseStudentAssessmentCategoryId(bsac.getId()); //sheet名 String sheetName = bsac.getName(); WriteSheet writeSheet = EasyExcel.writerSheet(no++, sheetName ).build(); //求所有的个人行为集合 List quantitativeAssessmentSubTableExcelVoList = assessmentInspectionMapper.getQuantitativeAssessmentSubTableExcelVoList(dto); excelWriter.write(quantitativeAssessmentSubTableExcelVoList, writeSheet); } //TODO 班级量化考核统计表总 //以班级为数据的基础进行数据的填充 MPJLambdaWrapper baseClassMPJLambdaWrapper = new MPJLambdaWrapper<>(); baseClassMPJLambdaWrapper .selectAs(BaseClass::getTeacherId, CalssQuantitativeAssessmentPageVo::getHeadTeacherId) .selectAs(XjrUser::getUserName, CalssQuantitativeAssessmentPageVo::getOa) .selectAs(XjrUser::getName, CalssQuantitativeAssessmentPageVo::getHeadTeacherName) .selectAs(BaseClass::getId, CalssQuantitativeAssessmentPageVo::getClassId) .selectAs(BaseClass::getName, CalssQuantitativeAssessmentPageVo::getClassName) .selectAs(BaseClassMajorSet::getTotalStudent, CalssQuantitativeAssessmentPageVo::getStudentNum) .selectAs(BaseClass::getIsGraduate, CalssQuantitativeAssessmentPageVo::getClassStatus) .leftJoin(XjrUser.class, XjrUser::getId, BaseClass::getTeacherId) .leftJoin(BaseClassMajorSet.class, BaseClassMajorSet::getClassId, BaseClass::getId) .eq(dto.getGradeId() != null, BaseClass::getGradeId, dto.getGradeId()) .eq(dto.getClassId() != null, BaseClass::getId, dto.getClassId()) .eq(dto.getClassStatus() != null, BaseClass::getIsGraduate, dto.getClassStatus()) .like(dto.getName() != null && !dto.getName().isEmpty(), XjrUser::getName, dto.getName()); List resultList = baseClassMapper.selectJoinList(CalssQuantitativeAssessmentPageVo.class, baseClassMPJLambdaWrapper); //当前数据记录班级id List classIdList = new ArrayList<>(); for(CalssQuantitativeAssessmentPageVo c: resultList){ classIdList.add(Long.parseLong(c.getClassId())); } dto.setClassIdList(classIdList); if(dto.getStartTime() != null){ // 获取上个月的最后一秒 LocalDateTime lastMonthEnd = dto.getStartTime().minusMonths(1).with(TemporalAdjusters.lastDayOfMonth()).withHour(23).withMinute(59).withSecond(59); // 获取下个月的第一秒 LocalDateTime nextMonthStart = dto.getStartTime().plusMonths(1).with(TemporalAdjusters.firstDayOfMonth()).withHour(0).withMinute(0).withSecond(0); dto.setStartTime(lastMonthEnd); dto.setEndTime(nextMonthStart); } if(!classIdList.isEmpty()){ CalssQuantitativeAssessmentPageDto calssQuantitativeAssessmentPageDto = new CalssQuantitativeAssessmentPageDto(); BeanUtils.copyProperties(dto, calssQuantitativeAssessmentPageDto); //学生个人行为 dto.setBaseStudentAssessmentCategoryId(1782327704603373570L); Map individualBehaviorMap = getQuantitativeAssessmentSingleScoreMap(calssQuantitativeAssessmentPageDto); //常规管理 dto.setBaseStudentAssessmentCategoryId(1782329720935329794L); Map conventionalManagementMap = getQuantitativeAssessmentSingleScoreMap(calssQuantitativeAssessmentPageDto); //获奖及荣誉奖彰 dto.setBaseStudentAssessmentCategoryId(1787316203484131329L); Map awardsAndHonorableMap = getQuantitativeAssessmentSingleScoreMap(calssQuantitativeAssessmentPageDto); //准军事化考核 dto.setBaseStudentAssessmentCategoryId(1868835208799236098L); Map paramilitaryMap = getQuantitativeAssessmentSingleScoreMap(calssQuantitativeAssessmentPageDto); //查询任课教师查询班级的数据 TeaEvaluateClassDto evaluateClassDto = new TeaEvaluateClassDto(); evaluateClassDto.setEvaluateType(EvaluateTypeEnum.TEACHER_EVALUATE_CLASS.getCode()); evaluateClassDto.setYear(dto.getYear()); LocalDate now = LocalDate.now(); if(dto.getYear() == null){ evaluateClassDto.setYear(now.getYear()); } evaluateClassDto.setMonth(dto.getMonth()); if(dto.getMonth() == null){ evaluateClassDto.setMonth(now.getMonthValue()); } List teaEvaluateClassList = evaluateResultMapper.getTeaEvaluateClassList(evaluateClassDto); Map> classEvaluateMap = teaEvaluateClassList.stream().collect(Collectors.groupingBy(TeaEvaluateClassListVo::getEvaluatedObjectId)); String jskhFormula = quotaFormulaRuleService.getFormulaByQuota("teacher_assessment"); //将结果写进对应的班级里 for(CalssQuantitativeAssessmentPageVo c: resultList){ if(c.getOa() == null){ c.setOa(" "); } if(c.getHeadTeacherName() == null){ c.setHeadTeacherName(" "); } Long classId = Long.parseLong(c.getClassId()); c.setStuPersonalBehaviorSubScore(" "); c.setStuPersonalBehaviorScore(" "); if(individualBehaviorMap.get(classId) != null){ Double sumScore = individualBehaviorMap.get(classId).getSumScore(); if(sumScore != null){ c.setStuPersonalBehaviorSubScore(sumScore.toString()); double v = (100 + sumScore) / 100 * 25; c.setStuPersonalBehaviorScore(v + ""); } } c.setClassConventionalManageSubScore(" "); c.setClassConventionalManageScore(" "); if(conventionalManagementMap.get(classId) != null){ Double sumScore = conventionalManagementMap.get(classId).getSumScore(); if(sumScore != null){ c.setClassConventionalManageSubScore(sumScore.toString()); double v = (100 + sumScore) / 100 * 25; c.setClassConventionalManageScore(v + ""); } } c.setHonorSumScore(" "); c.setHonorScore(" "); if(awardsAndHonorableMap.get(classId) != null){ Double sumScore = awardsAndHonorableMap.get(classId).getSumScore(); if(sumScore != null){ c.setHonorSumScore(sumScore.toString()); if(sumScore < 10){ c.setHonorScore(sumScore.toString()); }else { c.setHonorScore("10"); } } } if(c.getClassStatus() != null){ if(c.getClassStatus() == 1){ c.setClassStatusCn("在读"); } if(c.getClassStatus() == 2){ c.setClassStatusCn("毕业"); } } c.setTeacherAssessComprehensiveIndex(" "); c.setTeacherAssessScore(" "); if(classEvaluateMap.containsKey(classId)){ Map> evaluateCategoryMap = classEvaluateMap.get(classId).stream().collect(Collectors.groupingBy(TeaEvaluateClassListVo::getId)); int size = evaluateCategoryMap.size(); List evaluateSocreList = new ArrayList<>();//存每个项的平均分 for (Long id : evaluateCategoryMap.keySet()) { List evaluateList = evaluateCategoryMap.get(id); int allSorce = evaluateList.stream().mapToInt(TeaEvaluateClassListVo::getScore).sum(); double avgScore = BigDecimal.valueOf(allSorce).divide(BigDecimal.valueOf(resultList.size()),2, RoundingMode.HALF_UP).doubleValue(); evaluateSocreList.add(avgScore); } double sum = evaluateSocreList.stream().mapToDouble(Double::doubleValue).sum(); double jskhValue = BigDecimal.valueOf(sum).divide(BigDecimal.valueOf(size),2, RoundingMode.HALF_UP).doubleValue(); c.setTeacherAssessComprehensiveIndex(jskhValue + ""); String replacedExpression = jskhFormula.replace("JSKH", Double.toString(jskhValue)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setTeacherAssessScore(result + " "); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } if(paramilitaryMap.get(classId) != null){ Double sumScore = awardsAndHonorableMap.get(classId).getSumScore(); if(sumScore != null){ c.setMilitaryManageScore(sumScore.toString()); if(sumScore < 10){ c.setHonorScore(sumScore.toString()); }else { c.setHonorScore("10"); } double v = (100 + sumScore) / 100 * 25; c.setMilitaryManageComprehensiveIndex(v + ""); } } c.setAssessMoney(" "); c.setAssessSumScore(" "); } } //sheet名 String sheetName = "量化考核总表"; WriteSheet writeSheet = EasyExcel.writerSheet(0, sheetName ).build(); // excelWriter.write(resultList, writeSheet); } /*for (BaseStudentAssessmentCategory bsac : baseStudentAssessmentCategorieList) { dto.setBaseStudentAssessmentCategoryId(bsac.getId()); //sheet名 String sheetName = bsac.getName(); //求所有的个人行为集合 List quantitativeAssessmentSubTableExcelVoList = assessmentInspectionMapper.getQuantitativeAssessmentSubTableExcelVoList(dto); //需要合并的列 int[] mergeColumeIndex = {0, 1, 2, 3, 4}; //写字节流 ExcelMergeUtil excelFillCellMergeStrategy = new ExcelMergeUtil(1, mergeColumeIndex); EasyExcel.write(bot, QuantitativeAssessmentSubTableExcelVo.class) .registerWriteHandler(excelFillCellMergeStrategy) .sheet(sheetName) .doWrite(quantitativeAssessmentSubTableExcelVoList); }*/ } return RT.fileStream(bot.toByteArray(), fileName); } @Override public IPage getCalssQuantitativeAssessmentPage(Page page, CalssQuantitativeAssessmentPageDto dto) { //以班级为数据的基础进行数据的填充 MPJLambdaWrapper baseClassMPJLambdaWrapper = new MPJLambdaWrapper<>(); baseClassMPJLambdaWrapper .selectAs(BaseClass::getTeacherId, CalssQuantitativeAssessmentPageVo::getHeadTeacherId) .selectAs(XjrUser::getUserName, CalssQuantitativeAssessmentPageVo::getOa) .selectAs(XjrUser::getName, CalssQuantitativeAssessmentPageVo::getHeadTeacherName) .selectAs(BaseClass::getId, CalssQuantitativeAssessmentPageVo::getClassId) .selectAs(BaseClass::getName, CalssQuantitativeAssessmentPageVo::getClassName) .selectAs(BaseClassMajorSet::getTotalStudent, CalssQuantitativeAssessmentPageVo::getStudentNum) .selectAs(BaseClass::getIsGraduate, CalssQuantitativeAssessmentPageVo::getClassStatus) .leftJoin(XjrUser.class, XjrUser::getId, BaseClass::getTeacherId) .leftJoin(BaseClassMajorSet.class, BaseClassMajorSet::getClassId, BaseClass::getId) .eq(dto.getGradeId() != null, BaseClass::getGradeId, dto.getGradeId()) .eq(dto.getClassId() != null, BaseClass::getId, dto.getClassId()) .eq(dto.getClassStatus() != null, BaseClass::getIsGraduate, dto.getClassStatus()) .like(dto.getName() != null && !dto.getName().isEmpty(), XjrUser::getName, dto.getName()); IPage resultPage = baseClassMapper.selectJoinPage(page, CalssQuantitativeAssessmentPageVo.class, baseClassMPJLambdaWrapper); //当前数据记录班级id List classIdList = new ArrayList<>(); for(CalssQuantitativeAssessmentPageVo c: resultPage.getRecords()){ classIdList.add(Long.parseLong(c.getClassId())); } dto.setClassIdList(classIdList); if(dto.getStartTime() != null){ // 获取上个月的最后一秒 LocalDateTime lastMonthEnd = dto.getStartTime().minusMonths(1).with(TemporalAdjusters.lastDayOfMonth()).withHour(23).withMinute(59).withSecond(59); // 获取下个月的第一秒 LocalDateTime nextMonthStart = dto.getStartTime().plusMonths(1).with(TemporalAdjusters.firstDayOfMonth()).withHour(0).withMinute(0).withSecond(0); dto.setStartTime(lastMonthEnd); dto.setEndTime(nextMonthStart); } if(!classIdList.isEmpty()){ //学生个人行为 dto.setCategoryCode("student_behavior"); Map individualBehaviorMap = getQuantitativeAssessmentSingleScoreMap(dto); //常规管理 dto.setCategoryCode("convention_manage"); Map conventionalManagementMap = getQuantitativeAssessmentSingleScoreMap(dto); //获奖及荣誉奖彰 dto.setCategoryCode("awards_and_honors"); Map awardsAndHonorableMap = getQuantitativeAssessmentSingleScoreMap(dto); //准军事化考核 dto.setCategoryCode("militarize_manage"); Map paramilitaryMap = getQuantitativeAssessmentSingleScoreMap(dto); //班级文化建设 dto.setCategoryCode("classe_culture"); Map classCultureMap = getQuantitativeAssessmentSingleScoreMap(dto); //查询任课教师查询班级的数据 TeaEvaluateClassDto evaluateClassDto = new TeaEvaluateClassDto(); evaluateClassDto.setEvaluateType(EvaluateTypeEnum.TEACHER_EVALUATE_CLASS.getCode()); evaluateClassDto.setYear(dto.getYear()); LocalDate now = LocalDate.now(); if(dto.getYear() == null){ evaluateClassDto.setYear(now.getYear()); } evaluateClassDto.setMonth(dto.getMonth()); if(dto.getMonth() == null){ evaluateClassDto.setMonth(now.getMonthValue()); } List teaEvaluateClassList = evaluateResultMapper.getTeaEvaluateClassList(evaluateClassDto); Map> classEvaluateMap = teaEvaluateClassList.stream().collect(Collectors.groupingBy(TeaEvaluateClassListVo::getEvaluatedObjectId)); String jskhFormula = quotaFormulaRuleService.getFormulaByQuota("teacher_assessment"); String gfjyFormula = quotaFormulaRuleService.getFormulaByQuota("militarize_manage"); String xsgrFormula = quotaFormulaRuleService.getFormulaByQuota("student_behavior"); String cgglFormula = quotaFormulaRuleService.getFormulaByQuota("convention_manage"); String huojiangFormula = quotaFormulaRuleService.getFormulaByQuota("awards_and_honors"); String classCultureFormula = quotaFormulaRuleService.getFormulaByQuota("classe_culture"); //将结果写进对应的班级里 for(CalssQuantitativeAssessmentPageVo c: resultPage.getRecords()){ Long classId = Long.parseLong(c.getClassId()); //学生个人行为 if(individualBehaviorMap.get(classId) != null && individualBehaviorMap.get(classId) != null){ Double sumScore = individualBehaviorMap.get(classId).getSumScore(); c.setStuPersonalBehaviorSubScore(sumScore==null?"":sumScore.toString()); String replacedExpression = xsgrFormula.replace("xsgrKouFen", Double.toString(sumScore)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setStuPersonalBehaviorScore(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } //常规管理 if(conventionalManagementMap.get(classId) != null && conventionalManagementMap.get(classId) != null){ Double sumScore = conventionalManagementMap.get(classId).getSumScore(); if(sumScore != null){ String scoreStr = sumScore.toString(); c.setClassConventionalManageSubScore(scoreStr); String replacedExpression = cgglFormula.replace("cgglKouFen", Double.toString(sumScore)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setClassConventionalManageScore(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } } //获奖和荣誉 if(awardsAndHonorableMap.get(classId) != null && awardsAndHonorableMap.get(classId) != null){ Double sumScore = awardsAndHonorableMap.get(classId).getSumScore(); if(sumScore != null){ c.setHonorSumScore(sumScore.toString()); String replacedExpression = huojiangFormula.replace("HuoJiang", Double.toString(sumScore)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setHonorScore(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } } //军事化 if(paramilitaryMap.get(classId) != null && paramilitaryMap.get(classId) != null){ Double sumScore = paramilitaryMap.get(classId).getSumScore(); if(sumScore != null){ c.setMilitaryManageComprehensiveIndex(sumScore.toString()); //此项得分 String replacedExpression = gfjyFormula.replace("gfjyKouFen", Double.toString(sumScore)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setMilitaryManageScore(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } } //任课教师考核 if(classEvaluateMap.containsKey(classId)){ Map> evaluateCategoryMap = classEvaluateMap.get(classId).stream().collect(Collectors.groupingBy(TeaEvaluateClassListVo::getId)); int size = evaluateCategoryMap.size(); List evaluateSocreList = new ArrayList<>();//存每个项的平均分 for (Long id : evaluateCategoryMap.keySet()) { List resultList = evaluateCategoryMap.get(id); int allSorce = resultList.stream().mapToInt(TeaEvaluateClassListVo::getScore).sum(); double avgScore = BigDecimal.valueOf(allSorce).divide(BigDecimal.valueOf(resultList.size()), 2, RoundingMode.HALF_UP).doubleValue(); evaluateSocreList.add(avgScore); } double sum = evaluateSocreList.stream().mapToDouble(Double::doubleValue).sum(); double jskhValue = BigDecimal.valueOf(sum).divide(BigDecimal.valueOf(size),2, RoundingMode.HALF_UP).doubleValue(); c.setTeacherAssessComprehensiveIndex(jskhValue + ""); String replacedExpression = jskhFormula.replace("JSKH", Double.toString(jskhValue)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setTeacherAssessScore(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } //班级文化建设 if(classCultureMap.containsKey(classId) && classCultureMap.get(classId) != null){ Double sumScore = classCultureMap.get(classId).getSumScore(); if(sumScore != null){ c.setClassCultureScore(sumScore.toString()); String replacedExpression = classCultureFormula.replace("bjwhKouFen", Double.toString(sumScore)); ScriptEngineManager manager = new ScriptEngineManager(); ScriptEngine engine = manager.getEngineByName("JavaScript"); try { double result = ((Number) engine.eval(replacedExpression)).doubleValue(); c.setClassCultureIndex(BigDecimal.valueOf(result).setScale(2, RoundingMode.HALF_UP).doubleValue() + ""); } catch (ScriptException e) { Log.error(e.getMessage(), e); } } } } } return resultPage; } private Map getQuantitativeAssessmentSingleScoreMap(CalssQuantitativeAssessmentPageDto dto){ List individualBehaviorList = assessmentInspectionMapper.getAssessmentInspectionByClassIdList(new QuantitativeAssessmentSingleScoreDto(){{ setClassIdList(dto.getClassIdList()); setBaseStudentAssessmentCategoryId(dto.getBaseStudentAssessmentCategoryId()); setCategoryCode(dto.getCategoryCode()); if(dto.getBaseSemesterId() != null){ setBaseSemesterId(dto.getBaseSemesterId()); } if(dto.getStartTime() != null){ setStartTime(dto.getStartTime()); } if(dto.getEndTime() != null){ setStartTime(dto.getEndTime()); } setYear(dto.getYear()); setMonth(dto.getMonth()); }}); Map individualBehaviorMap = new HashMap<>(); for (QuantitativeAssessmentSingleScoreVo q : individualBehaviorList) { if(q.getClassId() != null){ individualBehaviorMap.put(q.getClassId(), q); } } return individualBehaviorMap; } @Override @Transactional public Boolean dataHandle(Long id) { //获取考核记录 BaseStudentAssessmentInspection baseStudentAssessmentInspection = this.getById(id); if(baseStudentAssessmentInspection != null){ double totalScore = 0d; if(StrUtil.isNotEmpty(baseStudentAssessmentInspection.getClassIds())) { //同步数据到考核关联班级表 String[] classIds = baseStudentAssessmentInspection.getClassIds().split(","); for (String classId : classIds) { assessmentClassRelationMapper.insert(new BaseStudentAssessmentClassRelation() {{ setClassId(Long.parseLong(classId)); setBaseStudentAssessmentInspectionId(baseStudentAssessmentInspection.getId()); QueryWrapper queryWrapperSortcode = new QueryWrapper<>(); queryWrapperSortcode.select("IFNULL(MAX(sort_code),0) as sortCode"); BaseStudentAssessmentClassRelation b = assessmentClassRelationMapper.selectOne(queryWrapperSortcode); setSortCode(b.getSortCode() + 1); }}); } totalScore = baseStudentAssessmentInspection.getScore(); } //同步数据到考核关联学生表 if(StrUtil.isNotEmpty(baseStudentAssessmentInspection.getPersonalStudentUserIds())){ String[] studentIds = baseStudentAssessmentInspection.getPersonalStudentUserIds().split(","); for (String studentId: studentIds) { assessmentStudentRelationMapper.insert(new BaseStudentAssessmentStudentRelation(){{ MPJLambdaWrapper baseStudentSchoolRollMPJLambdaWrapper = new MPJLambdaWrapper<>(); baseStudentSchoolRollMPJLambdaWrapper .select(BaseStudentSchoolRoll::getId) .select(BaseStudentSchoolRoll.class, x -> VoToColumnUtil.fieldsToColumns(BaseStudentSchoolRoll.class).contains(x.getProperty())) .eq(BaseStudentSchoolRoll::getUserId, studentId); BaseStudentSchoolRoll baseStudentSchoolRoll = baseStudentSchoolRollMapper.selectOne(baseStudentSchoolRollMPJLambdaWrapper); if(baseStudentSchoolRoll != null){ setClassId(baseStudentSchoolRoll.getClassId()); } setUserId(Long.parseLong(studentId)); setBaseStudentAssessmentInspectionId(baseStudentAssessmentInspection.getId()); QueryWrapper queryWrapperSortcode = new QueryWrapper<>(); queryWrapperSortcode.select("IFNULL(MAX(sort_code),0) as sortCode"); BaseStudentAssessmentStudentRelation b = assessmentStudentRelationMapper.selectOne(queryWrapperSortcode); setSortCode(b.getSortCode() + 1); setScore(baseStudentAssessmentInspection.getScore()); }}); } totalScore = studentIds.length * baseStudentAssessmentInspection.getScore(); } baseStudentAssessmentInspection.setTotalScore(totalScore); this.updateById(baseStudentAssessmentInspection); } return true; } @Override public Boolean noticeTeacher(Long id) { try { BaseStudentAssessmentInspection inspection = this.getById(id); String classIds = inspection.getClassIds(); BaseClass baseClass = baseClassMapper.selectById(classIds); User user = userService.getById(baseClass.getTeacherId()); String wechatTemplate = "Xb21V8au0Ur9puQs4hIDJTl8LP6GTgVOHQtOeie1Oco"; WeChatSendMessageDto weChatSendMessageDto = new WeChatSendMessageDto(); weChatSendMessageDto.setUserId(user.getOpenId()); weChatSendMessageDto.setTemplateId(wechatTemplate); weChatSendMessageDto.setMsgId(IdUtil.getSnowflakeNextId() + ""); JSONObject data = new JSONObject(); String thing4 = ""; String thing1 = ""; if(AssessmentTypeEnum.CLASS.getCode().equals(inspection.getAssessmentType())){ data.put("const3", new JSONObject() {{ put("value", AssessmentTypeEnum.CLASS.getValue()); }}); BaseStudentAssessmentProject project = projectMapper.selectById(inspection.getBaseStudentAssessmentProjectId()); thing4 = project.getName(); }else if(AssessmentTypeEnum.PERSONAL.getCode().equals(inspection.getAssessmentType())){ data.put("const3", new JSONObject() {{ put("value", AssessmentTypeEnum.PERSONAL.getValue()); }}); String[] studentUsers = inspection.getPersonalStudentUserIds().split(","); List studentIds = new ArrayList<>(); for (String studentUser : studentUsers) { studentIds.add(studentUser.trim()); } List userList = userService.listByIds(studentIds); for (int i = 0; i < userList.size(); i ++){ if(i > 0){ thing1 += ","; } thing1 += userList.get(i).getName(); } if(thing1.length() > 20){ thing1 = thing1.substring(0, 16) + "..."; } BaseStudentAssessmentCategory category = categoryMapper.selectById(inspection.getBaseStudentAssessmentCategoryId()); thing4 = category.getName(); } //得分 JSONObject thing4Json = new JSONObject(); thing4Json.put("value", thing4); data.put("thing4", thing4Json); //学生 JSONObject thing1Json = new JSONObject(); thing1Json.put("value", thing1); data.put("thing1", thing1Json); //得分 data.put("character_string5", new JSONObject() {{ put("value", inspection.getScore()); }}); //考核时间 SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日"); data.put("time2", new JSONObject() {{ put("value", sdf.format(inspection.getAssessmentDate())); }}); weChatSendMessageDto.setContent(data); weChatService.sendTemplateMessage(weChatSendMessageDto); return true; }catch (Exception e){ Log.error(e.getMessage(), e); return false; } } @Override public byte[] getExcelByte(CalssQuantitativeAssessmentPageDto dto) throws IOException { IPage page = this.getCalssQuantitativeAssessmentPage(new Page<>(1, 10000), dto); Workbook workbook = new XSSFWorkbook(); // 创建一个工作表(sheet) String sheetName = "数据"; Sheet sheet = workbook.createSheet(sheetName); createFirstTitle(workbook, sheet); createSecondTitle(workbook, sheet, 6); Font font = workbook.createFont(); font.setBold(false);// 设置为粗体 font.setFontName("宋体"); CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFont(font); // 将字体应用到样式 cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); int sortCode = 1; for (CalssQuantitativeAssessmentPageVo pageVo : page.getRecords()) { Row dataRow = sheet.createRow(sortCode + 1); int columnNumber = 0; Cell cell = dataRow.createCell(columnNumber); cell.setCellValue(sortCode + ""); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getOa()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassName()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getHeadTeacherName()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getStudentNum().toString()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassStatusCn()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getStuPersonalBehaviorSubScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getStuPersonalBehaviorScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassConventionalManageSubScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassConventionalManageScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getHonorSumScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getHonorScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getMilitaryManageComprehensiveIndex()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getMilitaryManageScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getTeacherAssessComprehensiveIndex()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getTeacherAssessScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassCultureScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getClassCultureIndex()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getAssessSumScore()); cell.setCellStyle(cellStyle); columnNumber ++; cell = dataRow.createCell(columnNumber); cell.setCellValue(pageVo.getAssessMoney()); cell.setCellStyle(cellStyle); sortCode ++; } ByteArrayOutputStream bot = new ByteArrayOutputStream(); workbook.write(bot); return bot.toByteArray(); } void createFirstTitle(Workbook workbook, Sheet sheet) { int rowNumber = 0; Font font = workbook.createFont(); font.setFontName("宋体"); //font.setColor(IndexedColors.RED.getIndex()); // 设置字体颜色为红色 font.setFontHeightInPoints((short)12); CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFont(font); // 将字体应用到样式 cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); cellStyle.setAlignment(HorizontalAlignment.CENTER); Row row = sheet.createRow(rowNumber); //3、处理表头 int columnNumber = 0; Cell cell = row.createCell(columnNumber); cell.setCellValue("序号"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("工号"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("班级"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("班主任"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("人数"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("状态"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("学生个人行为"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("常规管理"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("获奖及荣誉奖章"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("准军事化管理效果"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("任课教师考核"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("班级文化建设"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 0, columnNumber, columnNumber + 1)); columnNumber ++; columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("月份总得分"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("月考核金额"); cell.setCellStyle(cellStyle); sheet.addMergedRegion(new CellRangeAddress(0, 1, columnNumber, columnNumber)); } void createSecondTitle(Workbook workbook, Sheet sheet, int startColunm) { int rowNumber = 1; Font font = workbook.createFont(); font.setFontName("宋体"); font.setFontHeightInPoints((short)12); CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFont(font); // 将字体应用到样式 cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); cellStyle.setAlignment(HorizontalAlignment.CENTER); Row row = sheet.createRow(rowNumber); int columnNumber = startColunm; Cell cell = row.createCell(columnNumber); cell.setCellValue("扣分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("扣分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("汇总"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("指数"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("指数"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); cell = row.createCell(columnNumber); cell.setCellValue("扣分"); cell.setCellStyle(cellStyle); columnNumber ++; cell = row.createCell(columnNumber); cell.setCellValue("此项得分"); cell.setCellStyle(cellStyle); } }