fix(account): 修正付款申请与开票申请存在性校验的SQL语法

zhang_nuo

22 小时以前 5187507c8666e42b984c4dc539664a907070dc5a

fix(account): 修正付款申请与开票申请存在性校验的SQL语法

- 修复 AccountPaymentApplicationMapper.xml 中
  existsByStockInRecordId 方法SQL缺少AND连接条件的问题
- 修复 AccountInvoiceApplicationMapper.xml 中
  existsByStockOutRecordId 方法SQL缺少AND连接条件的问题
- 统一 status 条件判断的空格格式，提升SQL可读性

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

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

 src/main/resources/mapper/account/sales/AccountInvoiceApplicationMapper.xml

@@ -64,7 +64,8 @@
    <select id="existsByStockOutRecordId" resultType="java.lang.Boolean">
        SELECT COUNT(*) > 0
        FROM account_invoice_application
        WHERE status!=2
        WHERE status != 2
        AND
        <foreach collection="stockOutRecordIds" item="id" open="(" separator=" OR " close=")">
            FIND_IN_SET(#{id}, stock_out_record_ids)
        </foreach>