From 773093a776d92a6d76023698e7054f6b1f9b6c03 Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期三, 28 十月 2026 17:05:24 +0800
Subject: [PATCH] 官费用表明细
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/SpStatExpenseController.java | 37 ++++++++++++++++++++++++++++++++++---
1 files changed, 34 insertions(+), 3 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/SpStatExpenseController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/SpStatExpenseController.java
index 2098f7c..1addef2 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/SpStatExpenseController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/SpStatExpenseController.java
@@ -1,19 +1,26 @@
package com.ruoyi.web.controller.project;
+import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
+import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
-import com.ruoyi.project.domain.SpStatCaseReq;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.project.domain.SpStatExpense;
import com.ruoyi.project.domain.SpStatExpenseReq;
-import com.ruoyi.project.service.SpstatCaseService;
import com.ruoyi.project.service.SpstatExpenseService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
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.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+
+import java.math.BigDecimal;
+import java.util.List;
/**
* 鎶ラ攢缁熻
@@ -31,7 +38,7 @@
SpstatExpenseService spstatExpenseService;
/**
- * 鏌ヨ妗堜緥缁熻
+ * 鏌ヨ璐圭敤缁熻
*/
@ApiOperation("鏌ヨ鎶ラ攢缁熻")
@PostMapping("/spStatExpenselist")
@@ -40,5 +47,29 @@
return getDataTable(spstatExpenseService.getListBySpstatExpense(spStatExpenseReq));
}
+ /**
+ * 瀵煎嚭璐圭敤缁熻
+ */
+ @ApiOperation("瀵煎嚭璐圭敤缁熻")
+ @Log(title = "璐圭敤缁熻", businessType = BusinessType.EXPORT)
+ @GetMapping("/export")
+ public AjaxResult export(SpStatExpenseReq spStatExpenseReq) {
+ List<SpStatExpense> list = spstatExpenseService.getListBySpstatExpense(spStatExpenseReq);
+ // 閲戦淇濈暀 2 浣嶅皬鏁帮紱0.00 涓嶆樉绀猴紙缃┖锛�
+ for (SpStatExpense row : list) {
+ row.setAmount(blankZero(row.getAmount()));
+ row.setExpertfee(blankZero(row.getExpertfee()));
+ row.setEthicalistfee(blankZero(row.getEthicalistfee()));
+ row.setMedicalcost(blankZero(row.getMedicalcost()));
+ row.setOfficecost(blankZero(row.getOfficecost()));
+ row.setReimcost(blankZero(row.getReimcost()));
+ }
+ ExcelUtil<SpStatExpense> util = new ExcelUtil<SpStatExpense>(SpStatExpense.class);
+ return util.exportExcel(list, "璐圭敤缁熻鏁版嵁");
+ }
+
+ private BigDecimal blankZero(BigDecimal value) {
+ return (value == null || value.compareTo(BigDecimal.ZERO) == 0) ? null : value;
+ }
}
--
Gitblit v1.9.3