From eb3f32e8a7ee0f736a2808432724cdfc0144d64b Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期三, 31 七月 2024 11:26:23 +0800 Subject: [PATCH] feat:考核结果月度季度 --- ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java | 81 +++++++++++----------------------------- 1 files changed, 22 insertions(+), 59 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java index 8ec391a..4767a29 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java @@ -2,8 +2,6 @@ import annotation.DataScope; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import com.ycl.platform.base.BaseSelect; -import com.ycl.platform.base.CheckIndex; import com.ycl.platform.domain.dto.CheckScoreDTO; import com.ycl.platform.domain.dto.CheckScoreIndexDTO; import com.ycl.platform.domain.dto.ScoreIndexDTO; @@ -17,14 +15,11 @@ import com.ycl.platform.service.ICheckIndexFaceService; import com.ycl.platform.service.ICheckIndexVideoService; import com.ycl.platform.service.ICheckScoreService; -import com.ycl.system.Result; import com.ycl.system.entity.SysRole; import com.ycl.system.service.ISysDeptService; +import com.ycl.utils.DateUtils; import com.ycl.utils.SecurityUtils; import com.ycl.utils.StringUtils; -import com.ycl.utils.poi.ExcelUtil; -import constant.CheckConstants; -import enumeration.general.CheckScoreType; import enumeration.general.PublishType; import jakarta.servlet.http.HttpServletResponse; import lombok.extern.slf4j.Slf4j; @@ -32,20 +27,17 @@ import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import pojo.ExcelExp; -import utils.DateUtils; import utils.poi.ExcelUtilManySheet; import java.io.IOException; import java.text.SimpleDateFormat; -import java.time.LocalDate; -import java.time.format.DateTimeFormatter; +import java.time.LocalDateTime; import java.util.*; import java.util.stream.Collectors; -import java.util.stream.Stream; /** * 鑰冩牳绉垎鏄庣粏Service涓氬姟灞傚鐞� - * + * * @author ruoyi * @date 2024-04-22 */ @@ -71,7 +63,7 @@ private ISysDeptService deptService; /** * 鏌ヨ鑰冩牳绉垎鎸囨爣 - * + * * @param id 鑰冩牳绉垎涓婚敭 * @return 鑰冩牳绉垎 */ @@ -126,7 +118,7 @@ /** * 鏌ヨ鑰冩牳绉垎鍗$墖鍒楄〃 - * + * * @param checkScore 鑰冩牳绉垎 * @return 鑰冩牳绉垎 */ @@ -137,21 +129,24 @@ //鍖哄幙鍙兘鐪嬪凡鍙戝竷 roleControl(checkScore); - //鏌ヨ鎴愮哗 - String date = checkScore.getDate(); - if(StringUtils.isEmpty(date)){ - //濡傛灉涓虹┖鏌ユ湰鏈堢殑鏁版嵁 - Calendar now = Calendar.getInstance(); - //鍙栨槰澶� - now.add(Calendar.DATE, -1); - Date yesterday = now.getTime(); - SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM"); - date = simpleDateFormat.format(yesterday); - checkScore.setDate(date); + // 鑾峰彇鏁版嵁鏃ユ湡鏃堕棿 + Calendar calendar = Calendar.getInstance(); + // 涓�鍙锋煡璇箣鍓嶇殑鏁版嵁 + if (LocalDateTime.now().getDayOfMonth() == 1) { calendar.add(Calendar.DAY_OF_MONTH, -1); } + // 0 鐪佸巺鏈堝害 1 甯傚眬鏈堝害 2 鐪佸巺瀛e害 3 甯傚眬瀛e害 + switch (checkScore.getExamineTag()) { + case 0, 1: + checkScore.setEndDate(calendar.getTime()); + calendar.set(Calendar.DAY_OF_MONTH, 1); + checkScore.setStartDate(calendar.getTime()); + break; + case 2, 3: + checkScore.setStartDate(DateUtils.getQuarterStart(calendar).getTime()); + checkScore.setEndDate(DateUtils.getQuarterEnd(calendar).getTime()); + checkScore.setExamineTag(checkScore.getExamineTag() == 2 ? 0 : 1); + break; } - List<CheckScore> checkScores = scoreMapper.selectCheckScoreList(checkScore); - Map<Long, List<CheckScore>> deptMap = checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId)); - return deptMap; + return scoreMapper.selectCheckScoreMap(checkScore).stream().collect(Collectors.groupingBy(CheckScore::getDeptId)); } @@ -232,38 +227,6 @@ mysheet.add(e3); ExcelUtilManySheet<List<ExcelExp>> util = new ExcelUtilManySheet<>(mysheet); util.exportExcelManySheet(response,mysheet); - - //瀵煎崟sheet鐨勬柟寮� -// switch (CheckScoreType.fromValue(examineCategory)){ -// case CHECK_SCORE_TYPE_CAR: -// //鏌ヨ溅杈� -// List<CheckIndexCar> checkIndexCars = indexCarService.selectCheckIndexCarList(new CheckIndexCar()); -// export(response, depts, checkIndexCars,CheckIndexCar.class); -// break; -// case CHECK_SCORE_TYPE_FACE: -// // 鏌ヤ汉鑴� -// List<CheckIndexFace> checkIndexFaces = indexFaceService.selectCheckIndexFaceList(new CheckIndexFace()); -// export(response, depts, checkIndexFaces,CheckIndexFace.class); -// break; -// case CHECK_SCORE_TYPE_VIDEO: -// // 鏌ヨ棰� -// List<CheckIndexVideo> checkIndexVideos = indexVideoService.selectCheckIndexVideoList(new CheckIndexVideo()); -// export(response, depts, checkIndexVideos,CheckIndexVideo.class); -// break; -// } - } - - private <T extends CheckIndex> void export(HttpServletResponse response, List<BaseSelect> depts, List<T> checkIndexes,Class<T> checkIndexClass) { - //鏆傛椂娌$敤锛屽鏋滄暟鎹繃澶э紝鍦╯erver灞傜炕璇戯紝閬垮厤杩炶〃 - checkIndexes.forEach(checkIndex->{ - Optional<BaseSelect> first = depts.stream().filter(baseSelect -> checkIndex.getDeptId().equals(Long.valueOf(baseSelect.getId()+""))).findFirst(); - if(first.isPresent()){ - checkIndex.setDeptName(first.get().getValue()); - } - }); - - ExcelUtil<T> util = new ExcelUtil<T>(checkIndexClass); - util.exportExcel(response, checkIndexes, "鑰冩牳绉垎鏄庣粏鏁版嵁"); } -- Gitblit v1.8.0