package cn.iocoder.yudao.module.srm.dal.mysql;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.srm.dal.dataobject.SrmInquiryQuoteDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface SrmInquiryQuoteMapper extends BaseMapperX<SrmInquiryQuoteDO> {

    default List<SrmInquiryQuoteDO> selectListByInquiryId(Long inquiryId) {
        return selectList(new LambdaQueryWrapperX<SrmInquiryQuoteDO>()
                .eq(SrmInquiryQuoteDO::getInquiryId, inquiryId)
                .orderByAsc(SrmInquiryQuoteDO::getInquiryItemId)
                .orderByAsc(SrmInquiryQuoteDO::getId));
    }

    default SrmInquiryQuoteDO selectByItemIdAndSupplierId(Long inquiryItemId, Long supplierId) {
        return selectOne(new LambdaQueryWrapperX<SrmInquiryQuoteDO>()
                .eq(SrmInquiryQuoteDO::getInquiryItemId, inquiryItemId)
                .eq(SrmInquiryQuoteDO::getSupplierId, supplierId));
    }

    default void deleteByInquiryId(Long inquiryId) {
        delete(new LambdaQueryWrapperX<SrmInquiryQuoteDO>()
                .eq(SrmInquiryQuoteDO::getInquiryId, inquiryId));
    }

    default long selectCountBySupplierId(Long supplierId) {
        return selectCount(SrmInquiryQuoteDO::getSupplierId, supplierId);
    }

}