From 02737773121c421314d8c97daf9a320713afb7dd Mon Sep 17 00:00:00 2001
From: wujianwei <wjw@11.com>
Date: 星期三, 24 十二月 2025 11:41:07 +0800
Subject: [PATCH] 应付接口
---
service/src/main/java/com/ruoyi/cwgl/service/impl/ReceivableFeeManagementServiceImpl.java | 82 +++++++++++++++++++++++++++
service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java | 2
service/src/main/java/com/ruoyi/cwgl/service/IReceivableFeeManagementService.java | 17 +++++
service/src/main/java/com/ruoyi/cwgl/controller/ReceivableFeeManagementController.java | 25 ++++++++
4 files changed, 124 insertions(+), 2 deletions(-)
diff --git a/service/src/main/java/com/ruoyi/cwgl/controller/ReceivableFeeManagementController.java b/service/src/main/java/com/ruoyi/cwgl/controller/ReceivableFeeManagementController.java
index 1e53121..52266a9 100644
--- a/service/src/main/java/com/ruoyi/cwgl/controller/ReceivableFeeManagementController.java
+++ b/service/src/main/java/com/ruoyi/cwgl/controller/ReceivableFeeManagementController.java
@@ -11,6 +11,7 @@
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;
@@ -140,4 +141,28 @@
{
return toAjax(receivableFeeManagementService.voidReceivableFeeManagement(id));
}
+
+ /**
+ * 瀵煎叆搴旀敹璐圭敤绠＄悊鏁版嵁
+ */
+ @Log(title = "搴旀敹璐圭敤绠＄悊", businessType = BusinessType.IMPORT)
+ @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagement:import')")
+ @PostMapping("/importData")
+ public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
+ {
+ ExcelUtil<ReceivableFeeManagement> util = new ExcelUtil<ReceivableFeeManagement>(ReceivableFeeManagement.class);
+ List<ReceivableFeeManagement> receivableFeeList = util.importExcel(file.getInputStream());
+ String message = receivableFeeManagementService.importReceivableFee(receivableFeeList, updateSupport, getUsername());
+ return success(message);
+ }
+
+ /**
+ * 涓嬭浇瀵煎叆妯℃澘
+ */
+ @GetMapping("/importTemplate")
+ public AjaxResult importTemplate(String exportKey)
+ {
+ receivableFeeManagementService.importTemplate(exportKey);
+ return AjaxResult.success("瀵煎嚭璇锋眰鎴愬姛锛岃绋嶅悗鐐瑰嚮涓嬭浇...!");
+ }
}
\ No newline at end of file
diff --git a/service/src/main/java/com/ruoyi/cwgl/service/IReceivableFeeManagementService.java b/service/src/main/java/com/ruoyi/cwgl/service/IReceivableFeeManagementService.java
index cebb7a8..083d69a 100644
--- a/service/src/main/java/com/ruoyi/cwgl/service/IReceivableFeeManagementService.java
+++ b/service/src/main/java/com/ruoyi/cwgl/service/IReceivableFeeManagementService.java
@@ -128,5 +128,22 @@
* @return 缁撴灉
*/
public int updateReceivableFeeManagementByRelatedBillNo(String relatedBillNo);
+
+ /**
+ * 瀵煎叆搴旀敹璐圭敤绠＄悊鏁版嵁
+ *
+ * @param receivableFeeList 搴旀敹璐圭敤绠＄悊鏁版嵁鍒楄〃
+ * @param updateSupport 鏄惁鏇存柊鏀寔锛屽鏋滃凡瀛樺湪锛屽垯杩涜鏇存柊鏁版嵁
+ * @param operName 鎿嶄綔鐢ㄦ埛
+ * @return 缁撴灉
+ */
+ public String importReceivableFee(List<ReceivableFeeManagement> receivableFeeList, Boolean updateSupport, String operName);
+
+ /**
+ * 涓嬭浇瀵煎叆妯℃澘
+ *
+ * @param exportKey 瀵煎嚭鍔熻兘鐨勫敮涓�鏍囪瘑
+ */
+ public void importTemplate(String exportKey);
}
diff --git a/service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java b/service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java
index a0d8115..526229b 100644
--- a/service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java
+++ b/service/src/main/java/com/ruoyi/cwgl/service/impl/PayableFeeManagementServiceImpl.java
@@ -217,7 +217,7 @@
// 璁剧疆姣忎釜鏄庣粏鐨勫簲浠樿垂鐢ㄧ鐞咺D
payableFeeManagement.getPayableFeeDetailList().forEach(detail -> {
detail.setPayableFeeId(payableFeeId);
- detail.setUpdateTime(DateUtils.getNowDate()); // 璁剧疆鏇存柊鏃堕棿
+ detail.setCreateTime(DateUtils.getNowDate()); // 璁剧疆鏇存柊鏃堕棿
});
// 璋冪敤鎵归噺鎻掑叆鏂规硶
diff --git a/service/src/main/java/com/ruoyi/cwgl/service/impl/ReceivableFeeManagementServiceImpl.java b/service/src/main/java/com/ruoyi/cwgl/service/impl/ReceivableFeeManagementServiceImpl.java
index 4c26ef3..030053d 100644
--- a/service/src/main/java/com/ruoyi/cwgl/service/impl/ReceivableFeeManagementServiceImpl.java
+++ b/service/src/main/java/com/ruoyi/cwgl/service/impl/ReceivableFeeManagementServiceImpl.java
@@ -215,7 +215,7 @@
// 璁剧疆姣忎釜鏄庣粏鐨勫簲鏀惰垂鐢ㄧ鐞咺D
receivableFeeManagement.getReceivableFeeDetailList().forEach(detail -> {
detail.setReceivableFeeId(receivableFeeId);
- detail.setUpdateTime(DateUtils.getNowDate()); // 璁剧疆鏇存柊鏃堕棿
+ detail.setCreateTime(DateUtils.getNowDate()); // 璁剧疆鏇存柊鏃堕棿
});
// 璋冪敤鎵归噺鎻掑叆鏂规硶
@@ -562,4 +562,84 @@
return sb.toString();
}
+
+ /**
+ * 瀵煎叆搴旀敹璐圭敤绠＄悊鏁版嵁
+ *
+ * @param receivableFeeList 搴旀敹璐圭敤绠＄悊鏁版嵁鍒楄〃
+ * @param updateSupport 鏄惁鏇存柊鏀寔锛屽鏋滃凡瀛樺湪锛屽垯杩涜鏇存柊鏁版嵁
+ * @param operName 鎿嶄綔鐢ㄦ埛
+ * @return 缁撴灉
+ */
+ @Override
+ public String importReceivableFee(List<ReceivableFeeManagement> receivableFeeList, Boolean updateSupport, String operName) {
+ if (receivableFeeList == null || receivableFeeList.isEmpty()) {
+ return "瀵煎叆鐢ㄦ埛鏁版嵁涓嶈兘涓虹┖锛�";
+ }
+ int successNum = 0;
+ int failureNum = 0;
+ StringBuilder successMsg = new StringBuilder();
+ StringBuilder failureMsg = new StringBuilder();
+
+ for (ReceivableFeeManagement receivableFee : receivableFeeList) {
+ try {
+ // 楠岃瘉绯荤粺缂栧彿鏄惁鍞竴
+ ReceivableFeeManagement checkFee = new ReceivableFeeManagement();
+ checkFee.setSystemNo(receivableFee.getSystemNo());
+ List<ReceivableFeeManagement> existingFees = selectReceivableFeeManagementList(checkFee);
+
+ if (!existingFees.isEmpty()) {
+ // 瀛樺湪閲嶅璁板綍
+ if (updateSupport) {
+ // 鏇存柊鏀寔锛岃繘琛屾洿鏂版搷浣�
+ ReceivableFeeManagement existingFee = existingFees.get(0);
+ receivableFee.setId(existingFee.getId());
+ receivableFee.setUpdateTime(DateUtils.getNowDate());
+ receivableFee.setUpdateBy(operName);
+ updateReceivableFeeManagement(receivableFee);
+ successNum++;
+ successMsg.append("<br/>" + successNum + ". 绯荤粺缂栧彿 " + receivableFee.getSystemNo() + " 鏇存柊鎴愬姛");
+ } else {
+ failureNum++;
+ failureMsg.append("<br/>" + failureNum + ". 绯荤粺缂栧彿 " + receivableFee.getSystemNo() + " 宸插瓨鍦�");
+ }
+ } else {
+ // 鏂板璁板綍
+ receivableFee.setCreateTime(DateUtils.getNowDate());
+ receivableFee.setCreateBy(operName);
+ insertReceivableFeeManagement(receivableFee);
+ successNum++;
+ successMsg.append("<br/>" + successNum + ". 绯荤粺缂栧彿 " + receivableFee.getSystemNo() + " 瀵煎叆鎴愬姛");
+ }
+ } catch (Exception e) {
+ failureNum++;
+ String msg = "<br/>" + failureNum + ". 绯荤粺缂栧彿 " + receivableFee.getSystemNo() + " 瀵煎叆澶辫触锛�";
+ failureMsg.append(msg + e.getMessage());
+ logger.error(msg, e);
+ }
+ }
+
+ if (failureNum > 0) {
+ failureMsg.insert(0, "寰堟姳姝夛紝瀵煎叆澶辫触锛佸叡 " + failureNum + " 鏉℃暟鎹牸寮忎笉姝ｇ‘锛岄敊璇涓嬶細");
+ throw new ServiceException(failureMsg.toString());
+ } else {
+ successMsg.insert(0, "鎭枩鎮紝鏁版嵁宸插叏閮ㄥ鍏ユ垚鍔燂紒鍏� " + successNum + " 鏉★紝鏁版嵁濡備笅锛�");
+ }
+ return successMsg.toString();
+ }
+
+ /**
+ * 涓嬭浇瀵煎叆妯℃澘
+ *
+ * @param exportKey 瀵煎嚭鍔熻兘鐨勫敮涓�鏍囪瘑
+ */
+ @DataSource(DataSourceType.SLAVE)
+ @Async
+ @Override
+ public void importTemplate(String exportKey) {
+ super.export(ReceivableFeeManagement.class, exportKey, "receivableFeeManagementTemplate", (pageNum) -> {
+ // 杩斿洖绌哄垪琛紝鍙鍑烘ā鏉跨粨鏋�
+ return new ArrayList<ReceivableFeeManagement>();
+ });
+ }
}
\ No newline at end of file
--
Gitblit v1.8.0