wujianwei
2026-02-02 da6bdcbfbe7c37b643f7bd1f4711e69f050172a8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
package com.ruoyi.cwgl.controller;
 
import java.util.List;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.utils.file.DownloadExportUtil;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import java.math.BigDecimal;
import java.util.List;
import java.util.Objects;
import com.ruoyi.cwgl.domain.InvoiceManage;
import com.ruoyi.cwgl.domain.PayableBillManagement;
import com.ruoyi.cwgl.domain.PayableInvoiceBusiness;
import com.ruoyi.cwgl.service.IInvoiceManageService;
import com.ruoyi.cwgl.service.IPayableBillManagementService;
import com.ruoyi.cwgl.service.IPayableInvoiceBusinessService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;
 
/**
 * 应付账单管理Controller
 *
 * @author ruoyi
 * @date 2025-12-17
 */
@RestController
@RequestMapping("/cwgl/payableBillManagement")
public class PayableBillManagementController extends BaseController
{
    @Autowired
    private IPayableBillManagementService payableBillManagementService;
 
    @Autowired
    private IInvoiceManageService invoiceManageService;
 
    @Autowired
    private IPayableInvoiceBusinessService payableInvoiceBusinessService;
 
 
 
    /**
     * 查询应付账单管理列表
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:list')")
    @GetMapping("/list")
    public TableDataInfo list(PayableBillManagement payableBillManagement)
    {
        startPage();
        List<PayableBillManagement> list = payableBillManagementService.selectPayableBillManagementList(payableBillManagement);
        return getDataTable(list);
    }
 
    /**
     * 导出应付账单管理列表
     * @param payableBillManagement 查询条件对象
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:export')")
    @Log(title = "应付账单管理", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(PayableBillManagement payableBillManagement,String exportKey)
    {
        payableBillManagementService.export(payableBillManagement,exportKey);
        return AjaxResult.success("导出请求成功,请稍后点击下载...!");
    }
 
 
 
    /**
     * 获取应付账单管理详细信息
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Integer id)
    {
        return AjaxResult.success(payableBillManagementService.selectPayableBillManagementById(id));
    }
 
    /**
     * 新增应付账单管理
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:add')")
    @Log(title = "应付账单管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody PayableBillManagement payableBillManagement)
    {
        return toAjax(payableBillManagementService.insertPayableBillManagement(payableBillManagement));
    }
 
    /**
     * 修改应付账单管理
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:edit')")
    @Log(title = "应付账单管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody PayableBillManagement payableBillManagement)
    {
        return toAjax(payableBillManagementService.updatePayableBillManagement(payableBillManagement));
    }
 
    /**
     * 删除应付账单管理
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:remove')")
    @Log(title = "应付账单管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Integer[] ids)
    {
        return toAjax(payableBillManagementService.deletePayableBillManagementByIds(ids));
    }
    
    /**
     * 作废应付账单管理记录
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:void')")
    @Log(title = "应付账单管理", businessType = BusinessType.UPDATE)
    @PutMapping("/void/{id}")
    public AjaxResult voidPayableBill(@PathVariable("id") Integer id)
    {
        return toAjax(payableBillManagementService.voidPayableBillManagement(id));
    }
 
    /**
     * 应付账单申请开票
     * @param invoiceManage 发票管理对象
     * @param id 应付账单ID
     * @return 结果
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:invoice')")
    @Log(title = "应付账单管理", businessType = BusinessType.OTHER)
    @PostMapping("/invoice/{id}")
    public AjaxResult applyPayableInvoice(@RequestBody InvoiceManage invoiceManage, @PathVariable("id") Integer id)
    {
        return invoiceManageService.applyPayableInvoice(invoiceManage, id);
    }
 
    /**
     * 查询应付账单已开票金额
     * @param id 应付账单ID
     * @return 已开票金额
     */
    @PreAuthorize("@ss.hasPermi('cwgl:payableBillManagement:query')")
    @GetMapping("/invoice/amount/{id}")
    public AjaxResult getPayableInvoicedAmount(@PathVariable("id") Integer id)
    {
        // 查询payable_invoice_business表中status为1的记录
        PayableInvoiceBusiness query = new PayableInvoiceBusiness();
        query.setHeadId(id);
        query.setStatus(1);
        List<PayableInvoiceBusiness> invoices = payableInvoiceBusinessService.selectPayableInvoiceBusinessList(query);
        
        // 计算已开票金额
        BigDecimal invoicedAmount = invoices.stream()
                .map(PayableInvoiceBusiness::getInvoicingAmount)
                .filter(Objects::nonNull)
                .reduce(BigDecimal.ZERO, BigDecimal::add);
        
        return AjaxResult.success(invoicedAmount);
    }
}