package com.ruoyi.cwgl.controller;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.ruoyi.cwgl.domain.ReceivableFeeDetail;
|
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 org.springframework.web.multipart.MultipartFile;
|
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 com.ruoyi.cwgl.domain.ReceivableFeeManagement;
|
import com.ruoyi.cwgl.domain.vo.ReceivableBillCreateVo;
|
import com.ruoyi.cwgl.service.IReceivableFeeManagementService;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.common.core.page.TableDataInfo;
|
|
/**
|
* 应收费用管理Controller
|
*
|
* @author ruoyi
|
* @date 2025-12-17
|
*/
|
@RestController
|
@RequestMapping("/cwgl/receivableFeeManagement")
|
public class ReceivableFeeManagementController extends BaseController
|
{
|
@Autowired
|
private IReceivableFeeManagementService receivableFeeManagementService;
|
|
|
|
/**
|
* 查询应收费用管理列表
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:list')")
|
@GetMapping("/list")
|
public TableDataInfo list(ReceivableFeeManagement receivableFeeManagement)
|
{
|
startPage();
|
List<ReceivableFeeManagement> list = receivableFeeManagementService.selectReceivableFeeManagementList(receivableFeeManagement);
|
return getDataTable(list);
|
}
|
|
/**
|
* 导出应收费用管理列表
|
* @param receivableFeeManagement 查询条件对象
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:export')")
|
@Log(title = "应收费用管理", businessType = BusinessType.EXPORT)
|
@GetMapping("/export")
|
public AjaxResult export(ReceivableFeeManagement receivableFeeManagement,String exportKey)
|
{
|
receivableFeeManagementService.export(receivableFeeManagement,exportKey);
|
return AjaxResult.success("导出请求成功，请稍后点击下载...!");
|
}
|
|
|
|
/**
|
* 获取应收费用管理详细信息
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:query')")
|
@GetMapping(value = "/{id}")
|
public AjaxResult getInfo(@PathVariable("id") Integer id)
|
{
|
return AjaxResult.success(receivableFeeManagementService.selectReceivableFeeManagementById(id));
|
}
|
|
/**
|
* 新增应收费用管理
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:add')")
|
@Log(title = "应收费用管理", businessType = BusinessType.INSERT)
|
@PostMapping
|
public AjaxResult add(@RequestBody ReceivableFeeManagement receivableFeeManagement)
|
{
|
return toAjax(receivableFeeManagementService.insertReceivableFeeManagement(receivableFeeManagement));
|
}
|
|
/**
|
* 修改应收费用管理
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:edit')")
|
@Log(title = "应收费用管理", businessType = BusinessType.UPDATE)
|
@PutMapping
|
public AjaxResult edit(@RequestBody ReceivableFeeManagement receivableFeeManagement)
|
{
|
return toAjax(receivableFeeManagementService.updateReceivableFeeManagement(receivableFeeManagement));
|
}
|
|
/**
|
* 删除应收费用管理
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:remove')")
|
@Log(title = "应收费用管理", businessType = BusinessType.DELETE)
|
@DeleteMapping("/{ids}")
|
public AjaxResult remove(@PathVariable Integer[] ids)
|
{
|
return toAjax(receivableFeeManagementService.deleteReceivableFeeManagementByIds(ids));
|
}
|
|
|
/**
|
* 查询应收费用统计信息
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:statistics')")
|
@GetMapping("/statistics/{ids}")
|
public AjaxResult getStatistics(@PathVariable Integer[] ids)
|
{
|
return AjaxResult.success(receivableFeeManagementService.getReceivableFeeStatistics(ids));
|
}
|
|
/**
|
* 创建应收账单
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:createBill')")
|
@Log(title = "应收账单管理", businessType = BusinessType.INSERT)
|
@PostMapping("/createBill")
|
public AjaxResult createBill(@RequestBody ReceivableBillCreateVo billCreateVo)
|
{
|
|
return toAjax(receivableFeeManagementService.createReceivableBill(billCreateVo));
|
}
|
|
/**
|
* 作废应收费用管理记录
|
*/
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:void')")
|
@Log(title = "应收费用管理", businessType = BusinessType.UPDATE)
|
@PutMapping("/void/{id}")
|
public AjaxResult voidReceivableFee(@PathVariable Integer id)
|
{
|
return toAjax(receivableFeeManagementService.voidReceivableFeeManagement(id));
|
}
|
|
/**
|
* 导入应收费用管理数据（支持多Sheet：Sheet1主表，Sheet2明细表）
|
*/
|
@Log(title = "应收费用管理", businessType = BusinessType.IMPORT)
|
@PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:import')")
|
@PostMapping("/importData")
|
public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
|
{
|
// 导入主表数据（Sheet1）
|
ExcelUtil<ReceivableFeeManagement> mainUtil = new ExcelUtil<ReceivableFeeManagement>(ReceivableFeeManagement.class);
|
List<ReceivableFeeManagement> receivableFeeList = mainUtil.importExcel("应收费用主表", file.getInputStream(),10000);
|
|
// 导入明细表数据（Sheet2）并关联到主表
|
ExcelUtil<ReceivableFeeDetail> detailUtil = new ExcelUtil<ReceivableFeeDetail>(ReceivableFeeDetail.class);
|
List<ReceivableFeeDetail> detailList = detailUtil.importExcel("应收费用明细", file.getInputStream(),10000);
|
|
// 将明细数据关联到对应的主表记录
|
if (detailList != null && !detailList.isEmpty()) {
|
for (ReceivableFeeDetail detail : detailList) {
|
// 根据序号字段找到对应的主表记录
|
for (ReceivableFeeManagement mainRecord : receivableFeeList) {
|
if (mainRecord.getSerialNumber() != null &&
|
mainRecord.getSerialNumber().equals(detail.getSerialNumber())) {
|
if (mainRecord.getReceivableFeeDetailList() == null) {
|
mainRecord.setReceivableFeeDetailList(new ArrayList<>());
|
}
|
mainRecord.getReceivableFeeDetailList().add(detail);
|
break;
|
}
|
}
|
}
|
}
|
|
String message = receivableFeeManagementService.importReceivableFee(receivableFeeList, getUsername());
|
return success(message);
|
}
|
|
/**
|
* 下载导入模板
|
*/
|
@GetMapping("/importTemplate")
|
public AjaxResult importTemplate(String exportKey)
|
{
|
receivableFeeManagementService.importTemplate(exportKey);
|
return AjaxResult.success("导出请求成功，请稍后点击下载...!");
|
}
|
}
|
