考核成绩导出优化

fuliqi

2024-09-20 9ca86187d65db0180f6d23b8efd13136b6db394c

 ycl-server/src/main/java/com/ycl/platform/controller/CheckScoreController.java

@@ -1,25 +1,30 @@
package com.ycl.platform.controller;

import annotation.Log;
import com.ycl.platform.domain.dto.CheckResultExportDTO;
import com.ycl.platform.domain.dto.CheckScoreDTO;
import com.ycl.platform.domain.dto.CheckScoreIndexDTO;
import com.ycl.platform.domain.entity.CheckScore;
import com.ycl.platform.service.ICheckScoreService;
import com.ycl.system.AjaxResult;
import com.ycl.system.controller.BaseController;
import com.ycl.system.page.TableDataInfo;
import com.ycl.utils.poi.ExcelUtil;
import com.ycl.utils.SecurityUtils;
import enumeration.BusinessType;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.util.List;
import java.util.Map;

/**
 * 考核积分明细Controller
 * 考核积分Controller
 *
 * @author ruoyi
 * @date 2024-04-01
 * @date 2024-04-22
 */
@RestController
@RequestMapping("/check/score")
@@ -29,70 +34,105 @@
    private ICheckScoreService checkScoreService;

    /**
     * 查询考核积分明细列表
     * 查询考核积分卡片列表
     */
    @PreAuthorize("@ss.hasPermi('system:score:list')")
    @GetMapping("/list")
    public TableDataInfo list(CheckScore checkScore)
    @PreAuthorize("@ss.hasPermi('check:score:query')")
    @PostMapping("/list")
    public AjaxResult list(@RequestBody CheckScore checkScore)
    {
        Map<Long, List<CheckScore>> deptMap = checkScoreService.selectCheckScoreList(checkScore);
        return success(deptMap);
    }

    /**
     * 查询考核积分折线图
     */
    @PreAuthorize("@ss.hasPermi('check:score:chart')")
    @GetMapping("/chart")
    public AjaxResult selectCheckScoreChart(CheckScore checkScore)
    {
        Map<Long, List<CheckScore>> deptMap = checkScoreService.selectCheckScoreChart(checkScore);
        return success(deptMap);
    }

    /**
     * 区县详情列表
     */
    @PreAuthorize("@ss.hasPermi('check:score:list')")
    @GetMapping("/detail")
    public TableDataInfo detail(CheckScore checkScore)
    {
        startPage();
        List<CheckScore> list = checkScoreService.selectCheckScoreList(checkScore);
        return getDataTable(list);
        List<CheckScore> page = checkScoreService.page(checkScore);
        return getDataTable(page);
    }


    /**
     * 获取考核指标详细信息
     */
    @PreAuthorize("@ss.hasPermi('check:score:detail')")
    @GetMapping(value = "/detail/index")
    public AjaxResult getIndex(CheckScoreIndexDTO checkScoreIndexDTO)
    {
        return success(checkScoreService.selectCheckScoreById(checkScoreIndexDTO));
    }

    /**
     * 导出考核积分明细列表
     * 发布考核积分
     */
    @PreAuthorize("@ss.hasPermi('system:score:export')")
    @Log(title = "考核积分明细", businessType = BusinessType.EXPORT)
    @PreAuthorize("@ss.hasPermi('check:score:publish')")
    @Log(title = "发布考核积分", businessType = BusinessType.UPDATE)
    @PutMapping("/publish")
    public AjaxResult edit(@RequestBody CheckScoreDTO checkScoreDTO)
    {
        return toAjax(checkScoreService.publishCheckScore(checkScoreDTO));
    }

    /**
     * 详情页导出考核积分列表
     */
    @Log(title = "详情页导出考核积分", businessType = BusinessType.EXPORT)
    @PostMapping("/detailExport")
    @PreAuthorize("@ss.hasPermi('check:result:detail:export')")
    public void detailExport(HttpServletResponse response, CheckScore checkScore) throws IOException {
        CheckResultExportDTO exportDTO = new CheckResultExportDTO();
        exportDTO.setDate(checkScore.getDate());
        exportDTO.setQuarter(checkScore.getQuarter());
        exportDTO.setDeptId(checkScore.getDeptId());
        exportDTO.setId(checkScore.getId());
        checkScoreService.exportIndex(response,exportDTO);
    }
    /**
     * 卡片页导出考核积分列表
     */
    @PreAuthorize("@ss.hasPermi('check:result:export')")
    @Log(title = "卡片页导出考核积分", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, CheckScore checkScore)
    {
        List<CheckScore> list = checkScoreService.selectCheckScoreList(checkScore);
        ExcelUtil<CheckScore> util = new ExcelUtil<CheckScore>(CheckScore.class);
        util.exportExcel(response, list, "考核积分明细数据");
    public void export(HttpServletResponse response, CheckResultExportDTO exportDTO) throws IOException {
        checkScoreService.exportIndex(response,exportDTO);
    }
//    /**
//     * 新增考核积分
//     */
//    @PreAuthorize("@ss.hasPermi('check:score:add')")
//    @Log(title = "考核积分", businessType = BusinessType.INSERT)
//    @PostMapping
//    public AjaxResult add(@RequestBody CheckScore checkScore)
//    {
//        return toAjax(checkScoreService.insertCheckScore(checkScore));
//    }

    /**
     * 获取考核积分明细详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:score:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(checkScoreService.selectCheckScoreById(id));
    }
//    /**
//     * 删除考核积分
//     */
//    @PreAuthorize("@ss.hasPermi('check:score:remove')")
//    @Log(title = "考核积分", businessType = BusinessType.DELETE)
//   @DeleteMapping("/{ids}")
//    public AjaxResult remove(@PathVariable Long[] ids)
//    {
//        return toAjax(checkScoreService.deleteCheckScoreByIds(ids));
//    }

    /**
     * 新增考核积分明细
     */
    @PreAuthorize("@ss.hasPermi('system:score:add')")
    @Log(title = "考核积分明细", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody CheckScore checkScore)
    {
        return toAjax(checkScoreService.insertCheckScore(checkScore));
    }

    /**
     * 修改考核积分明细
     */
    @PreAuthorize("@ss.hasPermi('system:score:edit')")
    @Log(title = "考核积分明细", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody CheckScore checkScore)
    {
        return toAjax(checkScoreService.updateCheckScore(checkScore));
    }

    /**
     * 删除考核积分明细
     */
    @PreAuthorize("@ss.hasPermi('system:score:remove')")
    @Log(title = "考核积分明细", businessType = BusinessType.DELETE)
   @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(checkScoreService.deleteCheckScoreByIds(ids));
    }
}