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);
|
}
|
