feat：首页考核报表

龚焕茏

2024-08-05 638f3b042a0a29e287491e08a7ebe6f460b17532

feat：首页考核报表

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

@@ -1,10 +1,7 @@
package com.ycl.platform.controller;

import com.ycl.platform.domain.query.HomeQuery;
import com.ycl.platform.service.ITMonitorService;
import com.ycl.platform.service.WorkOrderService;
import com.ycl.platform.service.YwPointService;
import com.ycl.platform.service.YwUnitService;
import com.ycl.platform.service.*;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
@@ -25,6 +22,7 @@
    private final ITMonitorService tMonitorService;
    private final WorkOrderService workOrderService;
    private final YwPointService ywPointService;
    private final IContractScoreService contractScoreService;

    @GetMapping("/ywUnitList")
    public AjaxResult ywUnitList() {
@@ -51,4 +49,9 @@
        return AjaxResult.success(ywUnitService.ywUnitCount());
    }

    @GetMapping("/calculate")
    public AjaxResult calculate() {
        return AjaxResult.success(contractScoreService.calculate());
    }

}

 ycl-server/src/main/java/com/ycl/platform/mapper/ContractScoreMapper.java

@@ -1,9 +1,10 @@
package com.ycl.platform.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.platform.domain.entity.ContractScore;

import java.util.List;
import java.util.Map;

/**
 * 合同打分Mapper接口
@@ -60,4 +61,10 @@
     * @return 结果
     */
    public int deleteDefaultScoreByIds(Long[] ids);

    /**
     * 首页核算
     * @return 核算
     */
    List<Map<String, Object>> calculate();
}

 ycl-server/src/main/java/com/ycl/platform/service/IContractScoreService.java

@@ -5,6 +5,7 @@

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

/**
 * 合同打分Service接口
@@ -46,4 +47,10 @@
     * @return 数据
     */
    List<ContractScore> getDateRangeScoreByContractId(Long id, String startTime, String endTime);

    /**
     * 首页核算
     * @return 核算
     */
    List<Map<String, Object>> calculate();
}

 ycl-server/src/main/java/com/ycl/platform/service/impl/ContractScoreServiceImpl.java

@@ -17,6 +17,7 @@
import java.io.Serializable;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

/**
@@ -89,4 +90,8 @@
                .list();
    }

    @Override
    public List<Map<String, Object>> calculate() {
        return contractScoreMapper.calculate();
    }
}

 ycl-server/src/main/resources/mapper/zgyw/ContractScoreMapper.xml

@@ -111,4 +111,15 @@
            #{id}
        </foreach>
    </delete>

    <select id="calculate" resultType="java.util.Map">
        SELECT
            SUBSTRING_INDEX(rule_name, '/', 1) AS name,
            COUNT(*) AS num,
            -SUM(score) AS score
        FROM t_contract_score
        WHERE auditing_status = 'PASS' AND deleted = 0
        GROUP BY SUBSTRING_INDEX(rule_name, '/', 1)
    </select>

</mapper>