看板周利用率，日利用率

Lius

2025-03-04 61bd1f27cb0f83890bfcd9aec6257eda13c0fc4d

 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentStatisticalInfoMapper.java

@@ -4,6 +4,8 @@
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.mdc.entity.MdcEquipmentStatisticalInfo;

import java.math.BigDecimal;

/**
 * @Description: 设备单日运行数据表
 * @Author: jeecg-boot
@@ -25,4 +27,14 @@
     * @return
     */
    Integer selectProcessLong(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);

    MdcEquipmentStatisticalInfo findMdcEquipmentStatisticalInfo(@Param("equipmentId") String equipmentId, @Param("data") String data);

    BigDecimal computeUtilizationMonth(@Param("productionId") String productionId, @Param("startDate") String startDate, @Param("endDate") String endDate);

    BigDecimal computeUtilizationMonthTotal(@Param("productionId") String productionId, @Param("startDate") String startDate, @Param("endDate") String endDate);

    BigDecimal computeUtilizationWeek(@Param("productionId") String productionId, @Param("date") String date);

    BigDecimal computeUtilizationWeekTotal(@Param("productionId") String productionId, @Param("date") String date);
}