package org.jeecg.modules.mdc.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.mdc.entity.MdcPassRate;

/**
 * @Description: 合格率表
 * @Author: lius
 * @Date: 2023-07-18
 * @Version: V1.0
 */
public interface MdcPassRateMapper extends BaseMapper<MdcPassRate> {

    /**
     * 分页查询
     *
     * @param page
     * @param mdcPassRate
     * @return
     */
    IPage<MdcPassRate> pageList(Page<MdcPassRate> page, @Param("mdcPassRate") MdcPassRate mdcPassRate);

    /**
     * 计算加工数量
     *
     * @param equipmentId
     * @param startTime
     * @param endTime
     * @return
     */
    Integer findProcessQuantity(@Param("equipmentId") String equipmentId, @Param("startTime") String startTime, @Param("endTime") String endTime);

    /**
     * 计算废品数量
     *
     * @param equipmentId
     * @param startTime
     * @param endTime
     * @return
     */
    Integer findUnqualifiedQuantity(@Param("equipmentId") String equipmentId, @Param("startTime") String startTime, @Param("endTime") String endTime);
}