package org.dromara.eims.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
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接口
 *
 * @author zhuguifei
 * @date 2025-03-14
 */
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);
}