fix(account): 修复入库记录ID查询条件逻辑错误

云

5 天以前 faf296056f9763391399d1a8f81975b34c9a565b

fix(account): 修复入库记录ID查询条件逻辑错误

- 修正了FIND_IN_SET查询条件前缺少AND关键字的问题
- 确保查询条件正确拼接避免SQL语法错误
- 修复可能导致查询结果不准确的逻辑缺陷

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

@@ -91,7 +91,7 @@
        FROM account_payment_application
        WHERE  status != 2
        <foreach collection="stockInRecordIds" item="id" open="(" separator=" OR " close=")">
            FIND_IN_SET(#{id}, stock_in_record_ids)
          and  FIND_IN_SET(#{id}, stock_in_record_ids)
        </foreach>
    </select>