fix: 移植长辉已验证的四类接口 500/体验问题（不含物料颜色字段）

xiaoyi

2026-11-03 481d8165f26fc7e37f0e87f6444ac0340bb563a3

 yudao-module-srm/src/main/java/cn/iocoder/yudao/module/srm/dal/mysql/SrmSupplierCertificateMapper.java

@@ -25,6 +25,12 @@
                .eq(SrmSupplierCertificateDO::getSupplierId, supplierId));
    }

    default SrmSupplierCertificateDO selectBySupplierIdAndCertificateName(Long supplierId, String certificateName) {
        return selectOne(new LambdaQueryWrapperX<SrmSupplierCertificateDO>()
                .eq(SrmSupplierCertificateDO::getSupplierId, supplierId)
                .eq(SrmSupplierCertificateDO::getCertificateName, certificateName));
    }

    default List<SrmSupplierCertificateDO> selectExpiringList(LocalDate startDate, LocalDate endDate) {
        return selectList(new LambdaQueryWrapperX<SrmSupplierCertificateDO>()
                .between(SrmSupplierCertificateDO::getValidEndDate, startDate, endDate));