package cn.stylefeng.guns.modular.cm.passingStationCollection.mapper;

import cn.stylefeng.guns.modular.cm.passingStationCollection.entity.PassingStationCollection;
import cn.stylefeng.guns.modular.cm.passingStationCollection.model.params.PassingStationCollectionParam;
import cn.stylefeng.guns.modular.cm.passingStationCollection.model.result.PassingStationCollectionResult;
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 java.util.List;
import java.util.Map;

/**
 * <p>
 * 产品过站采集 Mapper 接口
 * </p>
 *
 * @author zrm
 * @since 2023-02-11
 */
public interface PassingStationCollectionMapper extends BaseMapper<PassingStationCollection> {

    /**
     * 获取列表
     *
     * @author zrm
     * @Date 2023-02-11
     */
    List<PassingStationCollectionResult> customList(@Param("paramCondition") PassingStationCollectionParam paramCondition);

    /**
     * 获取map列表
     *
     * @author zrm
     * @Date 2023-02-11
     */
    List<Map<String, Object>> customMapList(@Param("paramCondition") PassingStationCollectionParam paramCondition);

    /**
     * 获取分页实体列表
     *
     * @author zrm
     * @Date 2023-02-11
     */
    Page<PassingStationCollectionResult> customPageList(@Param("page") Page page, @Param("paramCondition") PassingStationCollectionParam paramCondition);

    /**
     * 获取分页map列表
     *
     * @author zrm
     * @Date 2023-02-11
     */
    Page<Map<String, Object>> customPageMapList(@Param("page") Page page, @Param("paramCondition") PassingStationCollectionParam paramCondition);

    Integer getRepairQty();

    Integer getRepairQtyWeek();

    /**
     * 根据分总成编码更新为总成编码
     */
    int updateSFC(@Param("sfcCode") String sfcCode, @Param("childSfcCode") String childSfcCode);

    Page<PassingStationCollectionResult> PassRate(@Param("page") Page page, @Param("paramCondition") PassingStationCollectionParam paramCondition);

    int bigCenterRightTable(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("qualifiedFlag") String qualifiedFlag, @Param("workOrderNo") String workOrderNo);

    List<PassingStationCollectionResult> centerLeftData(@Param("workOrderNo") String str);

    int getUnqualifiedQuantity(@Param("workOrderNo") String workOrderNo);
}