fix(account): 修复库存记录ID查询条件语法错误

云

2026-06-04 edcf6923186682c678969c68ceda27257e8c8978

fix(account): 修复库存记录ID查询条件语法错误

- 修正了FIND_IN_SET函数的使用方式，添加了> 0比较
- 调整了WHERE子句的括号结构以确保逻辑正确性
- 修复了SQL查询中的语法错误，提高查询准确性

 src/main/resources/mapper/account/purchase/AccountPaymentApplicationMapper.xml

@@ -87,12 +87,14 @@
    </select>

    <select id="existsByStockInRecordId" resultType="java.lang.Boolean">
         SELECT COUNT(*) > 0
        SELECT COUNT(*) > 0
        FROM account_payment_application
        WHERE  status != 2
        <foreach collection="stockInRecordIds" item="id" open="(" separator=" OR " close=")">
          and  FIND_IN_SET(#{id}, stock_in_record_ids)
        WHERE status != 2
        AND (
        <foreach collection="stockInRecordIds" item="id" separator=" OR ">
            FIND_IN_SET(#{id}, stock_in_record_ids) > 0
        </foreach>
        )
    </select>

</mapper>