应付接口

wujianwei

2025-12-24 aa3757e8e1d986a65436c2dccec82f486ee690b5

应付接口

 service/src/main/java/com/ruoyi/cwgl/mapper/PayableFeeManagementMapper.java

@@ -92,4 +92,13 @@
     * @return 应付费用管理集合
     */
    public List<PayableFeeManagement> selectPayableFeeManagementByIds(Integer[] ids);
    
    /**
     * 根据关联账单编号批量更新应付费用管理记录
     * 清除关联账单编号并将状态改为0（待生成账单）
     * 
     * @param relatedBillNo 关联账单编号
     * @return 结果
     */
    public int updatePayableFeeManagementByRelatedBillNo(String relatedBillNo);
}

 service/src/main/java/com/ruoyi/cwgl/service/IPayableFeeManagementService.java

@@ -125,4 +125,13 @@
     * @return 结果
     */
    public int voidPayableFeeManagement(Integer id);
    
    /**
     * 根据关联账单编号批量更新应付费用管理记录
     * 清除关联账单编号并将状态改为0（待生成账单）
     * 
     * @param relatedBillNo 关联账单编号
     * @return 结果
     */
    public int updatePayableFeeManagementByRelatedBillNo(String relatedBillNo);
}

 service/src/main/java/com/ruoyi/cwgl/service/impl/PayableBillManagementServiceImpl.java

@@ -5,7 +5,9 @@
import com.ruoyi.common.utils.DateUtils;
import javax.annotation.Resource;

import com.ruoyi.cwgl.mapper.PayableFeeManagementMapper;
import com.ruoyi.cwgl.service.IPayableBillManagementLogService;
import com.ruoyi.cwgl.service.IPayableFeeManagementService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.stereotype.Service;
@@ -38,6 +40,8 @@
    private PayableBillManagementMapper payableBillManagementMapper;
    @Autowired
    private IPayableBillManagementLogService logService;
    @Resource
    private PayableFeeManagementMapper payableFeeManagementMapper;

    /**
     * 查询应付账单管理
@@ -208,6 +212,16 @@
        bill.setStatus("2");
        bill.setUpdateTime(DateUtils.getNowDate());
        
        return updatePayableBillManagement(bill);
        int result = updatePayableBillManagement(bill);
        
        if (result > 0) {
            // 作废应付账单后，需要将关联的应付费用记录恢复为待生成账单状态
            String relatedBillNo = bill.getSystemNo();
            if (relatedBillNo != null && !relatedBillNo.isEmpty()) {
                payableFeeManagementMapper.updatePayableFeeManagementByRelatedBillNo(relatedBillNo);
            }
        }
        
        return result;
    }
}

 service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java

@@ -434,7 +434,22 @@
        
        return result;
    }
    /**
     * 根据关联账单编号批量更新应付费用管理记录
     * 清除关联账单编号并将状态改为0（待生成账单）
     * 使用场景：当应付账单被删除或作废时，需要将关联的应付费用记录恢复为待生成账单状态
     *
     * @param relatedBillNo 关联账单编号
     * @return 影响的行数
     */
    @Override
    public int updatePayableFeeManagementByRelatedBillNo(String relatedBillNo)
    {
        // 调用Mapper层方法执行批量更新
        int result = payableFeeManagementMapper.updatePayableFeeManagementByRelatedBillNo(relatedBillNo);

        return result;
    }
    /**
     * 作废应付费用管理记录
     *
@@ -509,7 +524,7 @@
            
            // 根据币种显示对应的货币名称
            String currency = entry.getKey();
            if ("CNY".equals(currency)) {
            if ("RMB".equals(currency)) {
                sb.append("人民币");
            } else if ("HKD".equals(currency)) {
                sb.append("港币");

 service/src/main/resources/mapper/cwgl/PayableFeeManagementMapper.xml

@@ -208,6 +208,13 @@
        </foreach>
    </delete>

    <!--根据关联账单编号批量更新应付费用管理记录，清除关联账单编号并将状态改为0（待生成账单）-->
    <update id="updatePayableFeeManagementByRelatedBillNo" parameterType="String">
        update payable_fee_management 
        set related_bill_no = null, status = '0', update_time = now() 
        where related_bill_no = #{relatedBillNo}
    </update>

    <!--根据应付费用ID数组查询应付费用管理列表-->
    <select id="selectPayableFeeManagementByIds" parameterType="Integer" resultMap="PayableFeeManagementResult">
        <include refid="selectPayableFeeManagementVo"/>