fix: 修复删除发货记录判断该出库记录是否有开票申请报错问题。

yuan

4 天以前 51a44136f56640a3d58f761b417e3542834348ae

fix: 修复删除发货记录判断该出库记录是否有开票申请报错问题。

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

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

</mapper>