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.MdcPartProcessInfo;
import org.jeecg.modules.mdc.vo.MdcPartProcessInfoVo;

/**
 * @Description: 零件加工数据表
 * @Author: lius
 * @Date: 2024-12-11
 */
public interface MdcPartProcessInfoMapper extends BaseMapper<MdcPartProcessInfo> {

    /**
     * 分页列表
     *
     * @param page
     * @param mdcPartProcessInfo
     * @return
     */
    IPage<MdcPartProcessInfo> pageList(Page<MdcPartProcessInfo> page, @Param("mdcPartProcessInfo") MdcPartProcessInfoVo mdcPartProcessInfo);

    /**
     * 查询设备某天总加工时间
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    Integer selectTotalProcessLong(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);

    /**
     * 查询设备某天总加工数量
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    Integer selectTotalProcessCount(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);

    /**
     * 查询设备某天总加工合格数量
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    Integer selectTotalPassCount(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);
}