blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
fuliqi
2024-07-31 f284c5ef6a1aa6e9ba5d4e94e4b2abe83b6ea18c 
 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,13 +118,46 @@




    /**


     * 查询考核积分卡片列表


     * 


     *


     * @param checkScore 考核积分


     * @return 考核积分


     */


    @Override


    @DataScope(deptAlias = "d",userAlias = "u")


    public Map<Long, List<CheckScore>> selectCheckScoreList(CheckScore checkScore)


    {


        //区县只能看已发布


        roleControl(checkScore);




        // 获取数据日期时间


        Calendar calendar = Calendar.getInstance();


        // 一号查询之前的数据


        if (LocalDateTime.now().getDayOfMonth() == 1) { calendar.add(Calendar.DAY_OF_MONTH, -1); }


        // 0 省厅月度 1 市局月度 2 省厅季度 3 市局季度


        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;


        }


        return scoreMapper.selectCheckScoreMap(checkScore).stream().collect(Collectors.groupingBy(CheckScore::getDeptId));


    }




    /**


     * 查询考核积分卡片列表


     *


     * @param checkScore 考核积分


     * @return 考核积分


     */


    @Override


    @DataScope(deptAlias = "d",userAlias = "u")


    public Map<Long, List<CheckScore>> selectCheckScoreChart(CheckScore checkScore)


    {


        //区县只能看已发布


        roleControl(checkScore);


@@ -150,10 +175,8 @@


            checkScore.setDate(date);


        }


        List<CheckScore> checkScores = scoreMapper.selectCheckScoreList(checkScore);


        Map<Long, List<CheckScore>> deptMap = checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId));


        return deptMap;


        return checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId));


    }






    /**


     * 区县详情


@@ -232,38 +255,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) {


        //暂时没用，如果数据过大，在server层翻译，避免连表


        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, "考核积分明细数据");




    }