feat(report): 新增设备稼动率统计功能

baoshiwei

2025-07-02 2f0009c750de4d47a18cce4a5a403fa83ba0c209

 eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/mapper/EimsInspectStMapper.java

@@ -4,11 +4,15 @@
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.dromara.eims.domain.EimsInspectSt;
import org.dromara.eims.domain.EimsMaintSt;
import org.dromara.eims.domain.vo.EimsInspectStVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;
import org.dromara.eims.domain.vo.EimsMaintStVo;

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

/**
 * 点检汇总Mapper接口
@@ -19,4 +23,17 @@
public interface EimsInspectStMapper extends BaseMapperPlus<EimsInspectSt, EimsInspectStVo> {
    Page<EimsInspectStVo> selectInspStList(@Param("page") Page<EimsInspectStVo> page, @Param(Constants.WRAPPER) Wrapper<EimsInspectSt> queryWrapper);

    @Select({
        "<script>",
        "SELECT",
        "  MONTH(plan_time) AS month,",
        "  SUM(run_times) AS runTimes,",
        "  SUM(fault_times) AS faultTimes",
        "FROM eims_inspect_st",
        "WHERE plan_time BETWEEN #{start} AND #{end}",
        "  AND type = 'Day'",
        "GROUP BY MONTH(plan_time)",
        "</script>"
    })
    List<Map<String, Object>> statEquEfficiency(@Param("start") String start, @Param("end") String end);
}