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<MdcEfficiencyDto> efficiencyList(@Param("vo") MdcEfficiencyReportQueryVo vo);
|
|
/**
|
* 查询开动率数据
|
*
|
* @param vo
|
* @return
|
*/
|
List<MdcEfficiencyDto> efficiencyPOList(@Param("vo") MdcEfficiencyReportQueryVo vo);
|
|
/**
|
* 得到所有班次数据之和
|
*
|
* @param vo
|
* @return
|
*/
|
List<MdcEquipmentStatisticalShiftInfo> efficiencyShiftSumList(@Param("vo") MdcEfficiencyReportShiftQueryVo vo);
|
|
/**
|
* 查询原始数据
|
*
|
* @param vo
|
* @return
|
*/
|
List<MdcComAnaDto> comparativeAnalysis(@Param("vo") ComparativeAnalysisQueryVo vo);
|
|
List<BigDecimal> getEfficiencyRate(@Param("equipmentId") String equipmentId, @Param("date") String date);
|
|
List<EquipmentEfficiencyAnalyzeDto> equipmentEfficiencyAnalyze(@Param("equipmentIdList") List<String> equipmentIdList, @Param("month") String month);
|
|
List<TeamEquEffDto> teamEquipmentEfficiencyAnalyze(@Param("equipmentIdList") List<String> equipmentIdList, @Param("month") String month);
|
|
List<ComRateDto> comprehensiveRateAnalyze(@Param("equipmentIdList") List<String> equipmentIdList, @Param("start") String startStr, @Param("end") String endStr);
|
|
List<ComShiftRateDto> comprehensiveShiftRateAnalyze(@Param("equipmentIdList") List<String> equipmentIdList, @Param("start") String startStr, @Param("end") String endStr, @Param("shiftId") String shiftId);
|
}
|
