package cn.iocoder.yudao.module.erp.dal.mysql.mapping;

import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.erp.controller.admin.mapping.vo.ErpMesWarehouseMappingPageReqVO;
import cn.iocoder.yudao.module.erp.dal.dataobject.mapping.ErpMesWarehouseMappingDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * ERP仓库与MES仓库映射 Mapper
 */
@Mapper
public interface ErpMesWarehouseMappingMapper extends BaseMapperX<ErpMesWarehouseMappingDO> {

    default ErpMesWarehouseMappingDO selectByErpWarehouseId(Long erpWarehouseId) {
        return selectOne(new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
                .eq(ErpMesWarehouseMappingDO::getErpWarehouseId, erpWarehouseId)
                .eq(ErpMesWarehouseMappingDO::getStatus, 1)); // 只查询启用状态
    }

    default ErpMesWarehouseMappingDO selectByMesWarehouseId(Long mesWarehouseId) {
        return selectOne(new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
                .eq(ErpMesWarehouseMappingDO::getMesWarehouseId, mesWarehouseId));
    }

    default PageResult<ErpMesWarehouseMappingDO> selectPage(ErpMesWarehouseMappingPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
                .eqIfPresent(ErpMesWarehouseMappingDO::getErpWarehouseId, reqVO.getErpWarehouseId())
                .eqIfPresent(ErpMesWarehouseMappingDO::getMesWarehouseId, reqVO.getMesWarehouseId())
                .eqIfPresent(ErpMesWarehouseMappingDO::getStatus, reqVO.getStatus())
                .orderByDesc(ErpMesWarehouseMappingDO::getId));
    }

}