package org.jeecg.modules.mdc.mapper; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.mdc.dto.*; import org.jeecg.modules.mdc.entity.MdcEquipmentStatisticalShiftInfo; import org.jeecg.modules.mdc.vo.ComparativeAnalysisQueryVo; import org.jeecg.modules.mdc.vo.MdcEfficiencyReportQueryVo; import org.jeecg.modules.mdc.vo.MdcEfficiencyReportShiftQueryVo; import java.math.BigDecimal; import java.util.List; /** * @author: LiuS * @create: 2023-06-19 10:40 */ public interface MdcEfficiencyReportMapper { /** * 查询利用率数据 * * @param vo * @return */ List efficiencyList(@Param("vo") MdcEfficiencyReportQueryVo vo); /** * 查询开动率数据 * * @param vo * @return */ List efficiencyPOList(@Param("vo") MdcEfficiencyReportQueryVo vo); /** * 得到所有班次数据之和 * * @param vo * @return */ List efficiencyShiftSumList(@Param("vo") MdcEfficiencyReportShiftQueryVo vo); /** * 查询原始数据 * * @param vo * @return */ List comparativeAnalysis(@Param("vo") ComparativeAnalysisQueryVo vo); List getEfficiencyRate(@Param("equipmentId") String equipmentId, @Param("date") String date); List equipmentEfficiencyAnalyze(@Param("equipmentIdList") List equipmentIdList, @Param("month") String month); List teamEquipmentEfficiencyAnalyze(@Param("equipmentIdList") List equipmentIdList, @Param("month") String month); List comprehensiveRateAnalyze(@Param("equipmentIdList") List equipmentIdList, @Param("start") String startStr, @Param("end") String endStr); List comprehensiveShiftRateAnalyze(@Param("equipmentIdList") List equipmentIdList, @Param("start") String startStr, @Param("end") String endStr, @Param("shiftId") String shiftId); }