From 2ed03e83ce1e513632a188de78190e79a85636b9 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 31 十月 2025 17:51:31 +0800
Subject: [PATCH] yys 1.导出接口开发

---
 src/main/java/com/ruoyi/approve/pojo/KnowledgeBase.java                                            |    8 +
 src/main/java/com/ruoyi/purchase/pojo/PaymentRegistration.java                                     |    5 
 src/main/java/com/ruoyi/approve/controller/KnowledgeBaseController.java                            |   13 +
 src/main/java/com/ruoyi/sales/dto/ReceiptPaymentRecordDto.java                                     |   61 ++++++++
 src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java                 |    3 
 src/main/java/com/ruoyi/collaborativeApproval/service/MeetingService.java                          |    3 
 src/main/java/com/ruoyi/approve/pojo/RpaProcessAutomation.java                                     |    4 
 src/main/java/com/ruoyi/purchase/pojo/TicketRegistration.java                                      |    2 
 src/main/java/com/ruoyi/sales/pojo/SalesLedger.java                                                |    2 
 src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java                  |    1 
 src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java                                |   15 ++
 src/main/java/com/ruoyi/staff/controller/StaffSchedulingController.java                            |   18 ++
 src/main/java/com/ruoyi/purchase/controller/PurchaseLedgerController.java                          |   14 ++
 src/main/java/com/ruoyi/approve/controller/ApproveProcessController.java                           |   64 +++++++++
 src/main/java/com/ruoyi/collaborativeApproval/pojo/RulesRegulationsManagement.java                 |    8 +
 src/main/java/com/ruoyi/collaborativeApproval/controller/MeetingController.java                    |   28 ++++
 src/main/java/com/ruoyi/collaborativeApproval/controller/RulesRegulationsManagementController.java |   13 +
 src/main/java/com/ruoyi/collaborativeApproval/controller/SealApplicationManagementController.java  |   13 +
 src/main/java/com/ruoyi/approve/pojo/ApproveProcess.java                                           |   12 +
 src/main/java/com/ruoyi/purchase/dto/PaymentRegistrationDto.java                                   |    3 
 src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetingRoom.java                                |    7 +
 src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java                                        |   10 +
 src/main/java/com/ruoyi/purchase/controller/TicketRegistrationController.java                      |   12 +
 src/main/java/com/ruoyi/approve/controller/RpaProcessAutomationController.java                     |   15 ++
 src/main/java/com/ruoyi/purchase/controller/PaymentRegistrationController.java                     |   21 +-
 src/main/java/com/ruoyi/sales/controller/ReceiptPaymentController.java                             |   27 +++
 src/main/java/com/ruoyi/collaborativeApproval/pojo/SealApplicationManagement.java                  |    5 
 src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetDraft.java                                  |    4 
 src/main/java/com/ruoyi/compensationperformance/controller/CompensationPerformanceController.java  |   11 +
 src/main/java/com/ruoyi/staff/dto/StaffSchedulingDto.java                                          |   11 +
 30 files changed, 401 insertions(+), 12 deletions(-)

diff --git a/src/main/java/com/ruoyi/approve/controller/ApproveProcessController.java b/src/main/java/com/ruoyi/approve/controller/ApproveProcessController.java
index 131f61e..6fb9986 100644
--- a/src/main/java/com/ruoyi/approve/controller/ApproveProcessController.java
+++ b/src/main/java/com/ruoyi/approve/controller/ApproveProcessController.java
@@ -1,11 +1,14 @@
 package com.ruoyi.approve.controller;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.account.pojo.AccountExpense;
 import com.ruoyi.approve.pojo.ApproveProcess;
 import com.ruoyi.approve.service.IApproveProcessService;
 import com.ruoyi.approve.vo.ApproveGetAndUpdateVo;
 import com.ruoyi.approve.vo.ApproveProcessVO;
 import com.ruoyi.common.utils.SecurityUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.security.LoginUser;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.project.system.domain.SysDept;
@@ -15,6 +18,7 @@
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.io.IOException;
 import java.text.ParseException;
 import java.util.List;
@@ -118,4 +122,64 @@
         approveProcessService.delApprove(ids);
         return AjaxResult.success("鎿嶄綔鎴愬姛");
     }
+
+    @ApiOperation(value = "鍏嚭绠＄悊瀵煎嚭")
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 1));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "鍏嚭绠＄悊瀵煎嚭");
+    }
+
+    @ApiOperation(value = "璇峰亣绠＄悊瀵煎嚭")
+    @PostMapping("/exportTwo")
+    public void exportTwo(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 2));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "璇峰亣绠＄悊瀵煎嚭");
+    }
+
+    @ApiOperation(value = "鍑哄樊绠＄悊瀵煎嚭")
+    @PostMapping("/exportThree")
+    public void exportThree(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 3));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "鍑哄樊绠＄悊瀵煎嚭");
+    }
+
+    @ApiOperation(value = "鎶ラ攢绠＄悊瀵煎嚭")
+    @PostMapping("/exportFour")
+    public void exportFour(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 4));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "鎶ラ攢绠＄悊瀵煎嚭");
+    }
+
+    @ApiOperation(value = "閲囪喘鐢宠瀵煎嚭")
+    @PostMapping("/exportFive")
+    public void exportFive(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 5));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "閲囪喘鐢宠瀵煎嚭");
+    }
+
+    @ApiOperation(value = "鍗忓悓瀹℃壒瀵煎嚭")
+    @PostMapping("/exportZero")
+    public void exportZero(HttpServletResponse response) {
+        List<ApproveProcess> accountExpenses = approveProcessService.list(new LambdaQueryWrapper<ApproveProcess>()
+                        .eq(ApproveProcess::getApproveDelete, 0)
+                .eq(ApproveProcess::getApproveType, 0));
+        ExcelUtil<ApproveProcess> util = new ExcelUtil<ApproveProcess>(ApproveProcess.class);
+        util.exportExcel(response, accountExpenses, "鍗忓悓瀹℃壒瀵煎嚭");
+    }
 }
diff --git a/src/main/java/com/ruoyi/approve/controller/KnowledgeBaseController.java b/src/main/java/com/ruoyi/approve/controller/KnowledgeBaseController.java
index 51141c3..b6ede4a 100644
--- a/src/main/java/com/ruoyi/approve/controller/KnowledgeBaseController.java
+++ b/src/main/java/com/ruoyi/approve/controller/KnowledgeBaseController.java
@@ -6,16 +6,21 @@
 import com.ruoyi.approve.pojo.KnowledgeBase;
 import com.ruoyi.approve.pojo.RpaProcessAutomation;
 import com.ruoyi.approve.service.KnowledgeBaseService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.web.domain.AjaxResult;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
 import lombok.AllArgsConstructor;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 @RestController
 @RequestMapping("/knowledgeBase")
 @AllArgsConstructor
+@Api(tags = "鐭ヨ瘑搴撶鐞�")
 public class KnowledgeBaseController {
     @Autowired
     private KnowledgeBaseService knowledgeBaseService;
@@ -56,4 +61,12 @@
         return AjaxResult.success(knowledgeBaseService.removeByIds(ids));
     }
 
+    @ApiOperation(value = "鐭ヨ瘑搴撶鐞嗗鍑�")
+    @PostMapping("/export")
+    public void export(HttpServletResponse response) {
+        List<KnowledgeBase> accountExpenses = knowledgeBaseService.list();
+        ExcelUtil<KnowledgeBase> util = new ExcelUtil<KnowledgeBase>(KnowledgeBase.class);
+        util.exportExcel(response, accountExpenses, "鐭ヨ瘑搴撶鐞嗗鍑�");
+    }
+
 }
diff --git a/src/main/java/com/ruoyi/approve/controller/RpaProcessAutomationController.java b/src/main/java/com/ruoyi/approve/controller/RpaProcessAutomationController.java
index 301ba74..e8c35f9 100644
--- a/src/main/java/com/ruoyi/approve/controller/RpaProcessAutomationController.java
+++ b/src/main/java/com/ruoyi/approve/controller/RpaProcessAutomationController.java
@@ -1,22 +1,29 @@
 package com.ruoyi.approve.controller;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.approve.pojo.ApproveProcess;
 import com.ruoyi.approve.pojo.RpaProcessAutomation;
 import com.ruoyi.approve.service.RpaProcessAutomationService;
 import com.ruoyi.common.utils.SecurityUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.security.LoginUser;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.project.system.domain.SysDept;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
 import lombok.AllArgsConstructor;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 @RestController
 @RequestMapping("/rpaProcessAutomation")
 @AllArgsConstructor
+@Api(tags = "RPA娴佺▼鑷姩鍖�")
 public class RpaProcessAutomationController {
     @Autowired
     private RpaProcessAutomationService rpaProcessAutomationService;
@@ -56,4 +63,12 @@
         return AjaxResult.success(rpaProcessAutomationService.removeByIds(ids));
     }
 
+    @ApiOperation(value = "RPA娴佺▼鑷姩鍖栧鍑�")
+    @PostMapping("/export")
+    public void export(HttpServletResponse response) {
+        List<RpaProcessAutomation> accountExpenses = rpaProcessAutomationService.list();
+        ExcelUtil<RpaProcessAutomation> util = new ExcelUtil<RpaProcessAutomation>(RpaProcessAutomation.class);
+        util.exportExcel(response, accountExpenses, "RPA娴佺▼鑷姩鍖栧鍑�");
+    }
+
 }
diff --git a/src/main/java/com/ruoyi/approve/pojo/ApproveProcess.java b/src/main/java/com/ruoyi/approve/pojo/ApproveProcess.java
index 18c624c..c1114bd 100644
--- a/src/main/java/com/ruoyi/approve/pojo/ApproveProcess.java
+++ b/src/main/java/com/ruoyi/approve/pojo/ApproveProcess.java
@@ -7,6 +7,7 @@
 
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import com.ruoyi.sales.pojo.CommonFile;
 import io.swagger.annotations.ApiModel;
 import io.swagger.annotations.ApiModelProperty;
@@ -33,6 +34,7 @@
      * 娴佺▼缂栧彿
      */
     @ApiModelProperty(value = "娴佺▼缂栧彿")
+    @Excel(name = "娴佺▼缂栧彿")
     private String approveId;
 
     /**
@@ -43,6 +45,8 @@
     /**
      * 鐢宠浜哄悕绉�
      */
+    @ApiModelProperty(value = "鐢宠浜哄悕绉�")
+    @Excel(name = "鐢宠浜�")
     private String approveUserName;
 
     /**
@@ -54,6 +58,7 @@
      * 鐢宠閮ㄩ棬鍚嶇О
      */
     @ApiModelProperty(value = "鐢宠閮ㄩ棬鍚嶇О")
+    @Excel(name = "鐢宠閮ㄩ棬")
     private String approveDeptName;
 
     /**
@@ -70,6 +75,7 @@
      * 鐢宠鍘熷洜
      */
     @ApiModelProperty(value = "鐢宠鍘熷洜")
+    @Excel(name = "瀹℃壒浜嬬敱")
     private String approveReason;
 
     /**
@@ -80,6 +86,8 @@
     /**
      * 褰撳墠瀹℃壒鐢ㄦ埛鍚嶇О
      */
+    @ApiModelProperty(value = "褰撳墠瀹℃壒浜�")
+    @Excel(name = "褰撳墠瀹℃壒浜�")
     private String approveUserCurrentName;
 
     /**
@@ -87,18 +95,22 @@
      */
     @JsonFormat(pattern = "yyyy-MM-dd")
     @ApiModelProperty(value = "鐢宠鏃ユ湡")
+    @Excel(name = "鐢宠鏃ユ湡" ,dateFormat = "yyyy-MM-dd")
     private Date approveTime;
 
     /**
      * 瀹℃壒瀹屾垚鏃堕棿
      */
     @JsonFormat(pattern = "yyyy-MM-dd")
+    @ApiModelProperty(value = "瀹℃壒瀹屾垚鏃堕棿")
+    @Excel(name = "缁撴潫鏃ユ湡" ,dateFormat = "yyyy-MM-dd")
     private Date approveOverTime;
 
     /**
      * 瀹℃壒鐘舵�侊細0寰呭鏍革紝1瀹℃牳涓紝2瀹℃牳瀹屾垚 3瀹℃牳鏈�氳繃 4宸查噸鏂版彁浜�
      */
     @ApiModelProperty(value = "瀹℃壒鐘舵�侊細0寰呭鏍革紝1瀹℃牳涓紝2瀹℃牳瀹屾垚 3瀹℃牳鏈�氳繃 4宸查噸鏂版彁浜�")
+    @Excel(name = "瀹℃壒鐘舵��", readConverterExp = "0=寰呭鏍�,1=瀹℃牳涓�,2=瀹℃牳瀹屾垚,3=瀹℃牳鏈�氳繃,4=宸查噸鏂版彁浜�")
     private Integer approveStatus;
 
     /**
diff --git a/src/main/java/com/ruoyi/approve/pojo/KnowledgeBase.java b/src/main/java/com/ruoyi/approve/pojo/KnowledgeBase.java
index 6635294..a066e06 100644
--- a/src/main/java/com/ruoyi/approve/pojo/KnowledgeBase.java
+++ b/src/main/java/com/ruoyi/approve/pojo/KnowledgeBase.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
 
@@ -16,18 +17,22 @@
     /**
      * 鐭ヨ瘑鏍囬
      */
+    @Excel(name = "鐭ヨ瘑鏍囬")
     private String title;
     /**
      * 鐭ヨ瘑绫诲瀷
      */
+    @Excel(name = "鐭ヨ瘑绫诲瀷",readConverterExp = "contract=鍚堝悓鐗规壒,approval=瀹℃壒妗堜緥,solution=瑙ｅ喅鏂规,experience=缁忛獙鎬荤粨,guide=鎿嶄綔鎸囧崡")
     private String type;
     /**
      * 閫傜敤鍦烘櫙
      */
+    @Excel(name = "閫傜敤鍦烘櫙")
     private String scenario;
     /**
      * 瑙ｅ喅鏁堢巼
      */
+    @Excel(name = "瑙ｅ喅鏁堢巼",readConverterExp = "low=杞诲井鎻愬崌,medium=涓�鑸彁鍗�,high=鏄捐憲鎻愬崌")
     private String efficiency;
     /**
      * 闂鎻忚堪
@@ -44,10 +49,12 @@
     /**
      * 鍒涘缓浜�
      */
+    @Excel(name = "鍒涘缓浜�")
     private String creator;
     /**
      * 浣跨敤娆℃暟
      */
+    @Excel(name = "浣跨敤娆℃暟")
     private Integer usageCount;
     /**
      * 鍒涘缓鏃堕棿
@@ -55,6 +62,7 @@
     @TableField(fill = FieldFill.INSERT)
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @Excel(name = "鍒涘缓鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
     private LocalDateTime createTime;
     /**
      * 鏇存柊鏃堕棿
diff --git a/src/main/java/com/ruoyi/approve/pojo/RpaProcessAutomation.java b/src/main/java/com/ruoyi/approve/pojo/RpaProcessAutomation.java
index a3ae618..d47f2a0 100644
--- a/src/main/java/com/ruoyi/approve/pojo/RpaProcessAutomation.java
+++ b/src/main/java/com/ruoyi/approve/pojo/RpaProcessAutomation.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
 
@@ -16,14 +17,17 @@
     /**
      * 绋嬪簭鍚�
      */
+    @Excel(name = "绋嬪簭鍚�")
     private String programName;
     /**
      * 绋嬪簭鎻忚堪
      */
+    @Excel(name = "绋嬪簭鎻忚堪")
     private String description;
     /**
      * 鐘舵��
      */
+    @Excel(name = "鐘舵��")
     private String status;
     /**
      * 鍒涘缓鏃堕棿
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/controller/MeetingController.java b/src/main/java/com/ruoyi/collaborativeApproval/controller/MeetingController.java
index dcc42ff..6c53634 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/controller/MeetingController.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/controller/MeetingController.java
@@ -1,5 +1,8 @@
 package com.ruoyi.collaborativeApproval.controller;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.ruoyi.approve.pojo.ApproveProcess;
+import com.ruoyi.collaborativeApproval.mapper.MeetDraftMapper;
 import com.ruoyi.collaborativeApproval.pojo.MeetApplication;
 import com.ruoyi.collaborativeApproval.pojo.MeetDraft;
 import com.ruoyi.collaborativeApproval.pojo.MeetingMinutes;
@@ -9,9 +12,15 @@
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingDraftVo;
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingRoomVo;
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingUseVo;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.web.domain.R;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
 import lombok.RequiredArgsConstructor;
 import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
 
 /**
  * 鍏充簬浼氳controller
@@ -23,6 +32,7 @@
 @RestController
 @RequestMapping("/meeting")
 @RequiredArgsConstructor
+@Api(tags = "浼氳")
 public class MeetingController {
     private final MeetingService meetingService;
 
@@ -117,4 +127,22 @@
         return R.ok(meetingService.getMeetSummaryItems());
     }
 
+    @ApiOperation(value = "浼氳瀹よ缃鍑�")
+    @PostMapping("/export")
+    public void export(HttpServletResponse response) {
+        List<MeetingRoom> accountExpenses = meetingService.list();
+        ExcelUtil<MeetingRoom> util = new ExcelUtil<MeetingRoom>(MeetingRoom.class);
+        util.exportExcel(response, accountExpenses, "浼氳瀹よ缃鍑�");
+    }
+
+    private final MeetDraftMapper meetDraftMapper;
+
+    @ApiOperation(value = "浼氳鑽夌瀵煎嚭")
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response) {
+        List<MeetDraft> accountExpenses = meetDraftMapper.selectList(new LambdaQueryWrapper<MeetDraft>());
+        ExcelUtil<MeetDraft> util = new ExcelUtil<MeetDraft>(MeetDraft.class);
+        util.exportExcel(response, accountExpenses, "浼氳鑽夌瀵煎嚭");
+    }
+
 }
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/controller/RulesRegulationsManagementController.java b/src/main/java/com/ruoyi/collaborativeApproval/controller/RulesRegulationsManagementController.java
index c977781..acfe676 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/controller/RulesRegulationsManagementController.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/controller/RulesRegulationsManagementController.java
@@ -5,19 +5,24 @@
 import com.ruoyi.collaborativeApproval.mapper.ReadingStatusMapper;
 import com.ruoyi.collaborativeApproval.pojo.ReadingStatus;
 import com.ruoyi.collaborativeApproval.pojo.RulesRegulationsManagement;
+import com.ruoyi.collaborativeApproval.pojo.SealApplicationManagement;
 import com.ruoyi.collaborativeApproval.service.RulesRegulationsManagementService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.web.domain.AjaxResult;
+import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import lombok.AllArgsConstructor;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.util.CollectionUtils;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 @RestController
 @RequestMapping("/rulesRegulationsManagement")
 @AllArgsConstructor
+@Api(tags = "鍒跺害绠＄悊")
 public class RulesRegulationsManagementController {
     @Autowired
     private RulesRegulationsManagementService rulesRegulationsManagementService;
@@ -71,4 +76,12 @@
     public AjaxResult getReadingStatusByRuleId(@PathVariable Long ruleId){
         return AjaxResult.success(readingStatusMapper.selectList(new QueryWrapper<ReadingStatus>().eq("rule_id", ruleId)));
     }
+
+    @ApiOperation(value = "瑙勭珷鍒跺害绠＄悊瀵煎嚭")
+    @PostMapping("/export")
+    public void export(HttpServletResponse response) {
+        List<RulesRegulationsManagement> accountExpenses = rulesRegulationsManagementService.list();
+        ExcelUtil<RulesRegulationsManagement> util = new ExcelUtil<RulesRegulationsManagement>(RulesRegulationsManagement.class);
+        util.exportExcel(response, accountExpenses, "瑙勭珷鍒跺害绠＄悊瀵煎嚭");
+    }
 }
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/controller/SealApplicationManagementController.java b/src/main/java/com/ruoyi/collaborativeApproval/controller/SealApplicationManagementController.java
index ef1e7a4..242072e 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/controller/SealApplicationManagementController.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/controller/SealApplicationManagementController.java
@@ -1,21 +1,26 @@
 package com.ruoyi.collaborativeApproval.controller;
 
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.approve.pojo.KnowledgeBase;
 import com.ruoyi.collaborativeApproval.pojo.SealApplicationManagement;
 import com.ruoyi.collaborativeApproval.service.SealApplicationManagementService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
 import com.ruoyi.framework.web.domain.AjaxResult;
+import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import lombok.AllArgsConstructor;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.util.CollectionUtils;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 @AllArgsConstructor
 @RestController
 @RequestMapping("/sealApplicationManagement")
+@Api(tags = "鐢ㄥ嵃鐢宠绠＄悊")
 public class SealApplicationManagementController {
     @Autowired
     private SealApplicationManagementService sealApplicationManagementService;
@@ -47,4 +52,12 @@
         return AjaxResult.success(sealApplicationManagementService.removeBatchByIds(ids));
     }
 
+    @ApiOperation(value = "鐢ㄥ嵃鐢宠绠＄悊瀵煎嚭")
+    @PostMapping("/export")
+    public void export(HttpServletResponse response) {
+        List<SealApplicationManagement> accountExpenses = sealApplicationManagementService.list();
+        ExcelUtil<SealApplicationManagement> util = new ExcelUtil<SealApplicationManagement>(SealApplicationManagement.class);
+        util.exportExcel(response, accountExpenses, "鐢ㄥ嵃鐢宠绠＄悊瀵煎嚭");
+    }
+
 }
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetDraft.java b/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetDraft.java
index 07adca4..7df4b0a 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetDraft.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetDraft.java
@@ -7,6 +7,7 @@
 import java.time.LocalDateTime;
 
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
 
@@ -33,12 +34,14 @@
      * 浼氳涓婚
      */
     @TableField(value = "title")
+    @Excel(name = "浼氳涓婚")
     private String title;
 
     /**
      * 涓绘寔浜�
      */
     @TableField(value = "host")
+    @Excel(name = "涓绘寔浜�")
     private String host;
 
     /**
@@ -69,6 +72,7 @@
      * 鍙備細浜烘暟
      */
     @TableField(value = "participants")
+    @Excel(name = "鍙備細浜烘暟")
     private Integer participants;
 
     /**
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetingRoom.java b/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetingRoom.java
index edf603a..9742071 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetingRoom.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/pojo/MeetingRoom.java
@@ -5,6 +5,8 @@
 import java.io.Serializable;
 import java.time.LocalDateTime;
 import java.util.Date;
+
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 
 /**
@@ -24,30 +26,35 @@
      * 浼氳瀹ゅ悕绉�
      */
     @TableField(value = "name")
+    @Excel(name = "浼氳瀹ゅ悕绉�")
     private String name;
 
     /**
      * 浣嶇疆
      */
     @TableField(value = "location")
+    @Excel(name = "浣嶇疆")
     private String location;
 
     /**
      * 瀹圭撼浜烘暟
      */
     @TableField(value = "capacity")
+    @Excel(name = "瀹圭撼浜烘暟")
     private Integer capacity;
 
     /**
      * 璁惧閰嶇疆锛堥�楀彿鍒嗛殧锛�
      */
     @TableField(value = "equipment")
+    @Excel(name = "璁惧閰嶇疆")
     private String equipment;
 
     /**
      * 鐘舵�侊紙1:鍚敤 0:绂佺敤锛�
      */
     @TableField(value = "status")
+    @Excel(name = "鐘舵��", readConverterExp = "1=鍚敤,0=绂佺敤")
     private Integer status;
 
     /**
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/pojo/RulesRegulationsManagement.java b/src/main/java/com/ruoyi/collaborativeApproval/pojo/RulesRegulationsManagement.java
index 80dc338..cc32e10 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/pojo/RulesRegulationsManagement.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/pojo/RulesRegulationsManagement.java
@@ -3,6 +3,7 @@
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
 import com.ruoyi.approve.utils.ListToStringTypeHandler;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 import org.apache.ibatis.type.JdbcType;
@@ -20,17 +21,20 @@
      * 鍒跺害缂栧彿
      */
     @ApiModelProperty("鍒跺害缂栧彿")
+    @Excel(name = "鍒跺害缂栧彿")
     private String regulationNum;
 
     /**
      * 鏍囬
      */
     @ApiModelProperty("鏍囬")
+    @Excel(name = "鏍囬")
     private String title;
     /**
      * 鍒跺害鍒嗙被
      */
     @ApiModelProperty("鍒跺害鍒嗙被")
+    @Excel(name = "鍒跺害鍒嗙被", readConverterExp = "finance=璐㈠姟鍒跺害,hr=浜轰簨鍒跺害,safety=瀹夊叏鍒跺害,tech=鎶�鏈埗搴�")
     private String category;
     /**
      * 鍒跺害鍐呭
@@ -59,16 +63,19 @@
      * 鐗堟湰
      */
     @ApiModelProperty("鐗堟湰")
+    @Excel(name = "鐗堟湰")
     private String version;
     /**
      * 鐘舵��
      */
     @ApiModelProperty("鐘舵��")
+    @Excel(name = "鐘舵��", readConverterExp = "repealed=宸插簾姝�,active=鐢熸晥涓�")
     private String status;
     /**
      * 宸茶浜烘暟
      */
     @ApiModelProperty("宸茶浜烘暟")
+    @Excel(name = "宸茶浜烘暟")
     private Integer readCount;
     /**
      * 鍒涘缓鑰�
@@ -82,6 +89,7 @@
     @TableField(fill = FieldFill.INSERT)
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @Excel(name = "鍒涘缓鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
     private LocalDateTime createTime;
     /**
      * 淇敼浜�
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/pojo/SealApplicationManagement.java b/src/main/java/com/ruoyi/collaborativeApproval/pojo/SealApplicationManagement.java
index d7a4222..d6d1d81 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/pojo/SealApplicationManagement.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/pojo/SealApplicationManagement.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
@@ -18,17 +19,20 @@
      * 鐢宠缂栧彿
      */
     @ApiModelProperty("鐢宠缂栧彿")
+    @Excel(name = "鐢宠缂栧彿")
     private String applicationNum;
 
     /**
      * 鍏憡鏍囬
      */
     @ApiModelProperty("鍏憡鏍囬")
+    @Excel(name = "鐢宠鏍囬")
     private String title;
     /**
      * 鐢ㄥ嵃绫诲瀷
      */
     @ApiModelProperty("鐢ㄥ嵃绫诲瀷")
+    @Excel(name = "鐢ㄥ嵃绫诲瀷", readConverterExp = "official=鍏珷,contract=鍚堝悓涓撶敤绔�,finance=璐㈠姟涓撶敤绔�,legal=鏈煡")
     private String sealType;
     /**
      * 鐢宠鐢ㄥ嵃鍘熷洜
@@ -45,6 +49,7 @@
      * 鐘舵��
      */
     @ApiModelProperty("鐘舵��")
+    @Excel(name = "鐘舵��", readConverterExp = "pending=寰呭鎵�,approved=宸查�氳繃,rejected=宸叉嫆缁�")
     private String status;
     /**
      * 鍒涘缓鑰�
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/service/MeetingService.java b/src/main/java/com/ruoyi/collaborativeApproval/service/MeetingService.java
index 898ca94..7b3c906 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/service/MeetingService.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/service/MeetingService.java
@@ -2,6 +2,7 @@
 
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.IService;
 import com.ruoyi.collaborativeApproval.dto.MeetSummaryDto;
 import com.ruoyi.collaborativeApproval.dto.MeetUseDto;
 import com.ruoyi.collaborativeApproval.dto.MeetingSimpleDto;
@@ -17,7 +18,7 @@
 
 import java.util.List;
 
-public interface MeetingService{
+public interface MeetingService extends IService<MeetingRoom> {
 //****************浼氳瀹�********************************
     IPage<MeetingRoom> getMeetingRoomList(SearchMeetingRoomVo vo);
 
diff --git a/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java b/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
index ce70e50..c269b1a 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.github.xiaoymin.knife4j.core.util.StrUtil;
 import com.ruoyi.collaborativeApproval.dto.MeetSummaryDto;
 import com.ruoyi.collaborativeApproval.dto.MeetUseDto;
@@ -33,7 +34,7 @@
 
 @Service
 @RequiredArgsConstructor
-public class MeetingServiceImpl implements MeetingService {
+public class MeetingServiceImpl extends ServiceImpl<MeetingRoomMapper, MeetingRoom> implements MeetingService {
     private final MeetingRoomMapper meetingRoomMapper;
 
     private final MeetDraftMapper meetDraftMapper;
diff --git a/src/main/java/com/ruoyi/compensationperformance/controller/CompensationPerformanceController.java b/src/main/java/com/ruoyi/compensationperformance/controller/CompensationPerformanceController.java
index 1844b3e..84fdbe5 100644
--- a/src/main/java/com/ruoyi/compensationperformance/controller/CompensationPerformanceController.java
+++ b/src/main/java/com/ruoyi/compensationperformance/controller/CompensationPerformanceController.java
@@ -2,12 +2,14 @@
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.compensationperformance.pojo.CompensationPerformance;
 import com.ruoyi.compensationperformance.service.CompensationPerformanceService;
 import com.ruoyi.framework.aspectj.lang.annotation.Log;
 import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
 import com.ruoyi.framework.web.controller.BaseController;
 import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.purchase.dto.PaymentRegistrationDto;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -15,6 +17,7 @@
 import org.springframework.util.CollectionUtils;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 /**
@@ -65,5 +68,13 @@
         return delete ? AjaxResult.success("鍒犻櫎鎴愬姛") : AjaxResult.error("鍒犻櫎澶辫触");
     }
 
+    @Log(title = "瀵煎嚭钖祫绠＄悊鍒楄〃", businessType = BusinessType.EXPORT)
+    @PostMapping("/export")
+    public void export(HttpServletResponse response ) {
+        List<CompensationPerformance> list = compensationPerformanceService.list();
+        ExcelUtil<CompensationPerformance> util = new ExcelUtil<CompensationPerformance>(CompensationPerformance.class);
+        util.exportExcel(response, list, "瀵煎嚭钖祫绠＄悊鍒楄〃");
+    }
+
 
 }
diff --git a/src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java b/src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java
index 5fb2c7a..499d75a 100644
--- a/src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java
+++ b/src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java
@@ -31,7 +31,6 @@
      * 鍛樺伐id
      */
     @ApiModelProperty("鍛樺伐id")
-    @Excel(name = "鍛樺伐id")
     private Long staffId;
 
     /**
diff --git a/src/main/java/com/ruoyi/purchase/controller/PaymentRegistrationController.java b/src/main/java/com/ruoyi/purchase/controller/PaymentRegistrationController.java
index 93bca78..71f1b5d 100644
--- a/src/main/java/com/ruoyi/purchase/controller/PaymentRegistrationController.java
+++ b/src/main/java/com/ruoyi/purchase/controller/PaymentRegistrationController.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.aspectj.lang.annotation.Log;
 import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
 import com.ruoyi.framework.web.controller.BaseController;
@@ -15,6 +16,7 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 import java.util.Map;
 
@@ -42,16 +44,17 @@
     }
 
     /**
-     * 瀵煎嚭浠樻鐧昏鍒楄〃
+     * 瀵煎嚭浠樻娴佹按鍒楄〃
      */
-//    @Log(title = "浠樻鐧昏", businessType = BusinessType.EXPORT)
-//    @PostMapping("/export")
-//    public void export(HttpServletResponse response, PaymentRegistrationDto paymentRegistrationDto)
-//    {
-//        List<PaymentRegistrationDto> list = paymentRegistrationService.selectPaymentRegistrationList(paymentRegistrationDto);
-//        ExcelUtil<PaymentRegistration> util = new ExcelUtil<PaymentRegistration>(PaymentRegistration.class);
-//        util.exportExcel(response, list, "浠樻鐧昏鏁版嵁");
-//    }
+    @Log(title = "瀵煎嚭浠樻娴佹按鍒楄〃", businessType = BusinessType.EXPORT)
+    @PostMapping("/export")
+    public void export(HttpServletResponse response, PaymentRegistrationDto paymentRegistrationDto)
+    {
+        Page page = new Page<>(-1,-1);
+        IPage<PaymentRegistrationDto> paymentRegistrationDtoIPage = paymentHistoryListPage(page, paymentRegistrationDto);
+        ExcelUtil<PaymentRegistrationDto> util = new ExcelUtil<PaymentRegistrationDto>(PaymentRegistrationDto.class);
+        util.exportExcel(response, paymentRegistrationDtoIPage.getRecords(), "瀵煎嚭浠樻娴佹按鍒楄〃");
+    }
 
     /**
      * 鑾峰彇浠樻鐧昏璇︾粏淇℃伅
diff --git a/src/main/java/com/ruoyi/purchase/controller/PurchaseLedgerController.java b/src/main/java/com/ruoyi/purchase/controller/PurchaseLedgerController.java
index 21a601e..fca4277 100644
--- a/src/main/java/com/ruoyi/purchase/controller/PurchaseLedgerController.java
+++ b/src/main/java/com/ruoyi/purchase/controller/PurchaseLedgerController.java
@@ -56,6 +56,20 @@
     }
 
     /**
+     * 瀵煎嚭鏉ョエ鐧昏鍒楄〃
+     */
+    @Log(title = "瀵煎嚭鏉ョエ鐧昏鍒楄〃", businessType = BusinessType.EXPORT)
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response, PurchaseLedger purchaseLedger) {
+        Page page = new Page();
+        page.setCurrent(-1);
+        page.setSize(-1);
+        IPage<PurchaseLedgerDto> purchaseLedgerDtoIPage = purchaseLedgerService.selectPurchaseLedgerListPage(page, new PurchaseLedgerDto());
+        ExcelUtil<PurchaseLedgerDto> util = new ExcelUtil<PurchaseLedgerDto>(PurchaseLedgerDto.class);
+        util.exportExcel(response, purchaseLedgerDtoIPage.getRecords(), "瀵煎嚭鏉ョエ鐧昏鍒楄〃");
+    }
+
+    /**
      * 鏂板淇敼閲囪喘鍙拌处
      */
     @Log(title = "閲囪喘鍙拌处", businessType = BusinessType.INSERT)
diff --git a/src/main/java/com/ruoyi/purchase/controller/TicketRegistrationController.java b/src/main/java/com/ruoyi/purchase/controller/TicketRegistrationController.java
index ab38808..d4fd91b 100644
--- a/src/main/java/com/ruoyi/purchase/controller/TicketRegistrationController.java
+++ b/src/main/java/com/ruoyi/purchase/controller/TicketRegistrationController.java
@@ -103,6 +103,18 @@
     }
 
     /**
+     * 浠樻鐧昏瀵煎嚭
+     */
+    @Log(title = "浠樻鐧昏瀵煎嚭", businessType = BusinessType.EXPORT)
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response, TicketRegistration ticketRegistration) {
+        Page page = new Page<>(-1, -1);
+        IPage<TicketRegistration> ticketRegistrationIPage = listPage(page, ticketRegistration);
+        ExcelUtil<TicketRegistration> util = new ExcelUtil<TicketRegistration>(TicketRegistration.class);
+        util.exportExcel(response, ticketRegistrationIPage.getRecords(), "浠樻鐧昏瀵煎嚭");
+    }
+
+    /**
      * 鏌ヨ鏉ョエ鐧昏鍜屼骇鍝佺埗瀛愬垪琛�
      */
     @GetMapping("/getRegistrationById")
diff --git a/src/main/java/com/ruoyi/purchase/dto/PaymentRegistrationDto.java b/src/main/java/com/ruoyi/purchase/dto/PaymentRegistrationDto.java
index 0ba914a..2561c8d 100644
--- a/src/main/java/com/ruoyi/purchase/dto/PaymentRegistrationDto.java
+++ b/src/main/java/com/ruoyi/purchase/dto/PaymentRegistrationDto.java
@@ -1,5 +1,6 @@
 package com.ruoyi.purchase.dto;
 
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import com.ruoyi.purchase.pojo.PaymentRegistration;
 import lombok.Data;
 
@@ -15,9 +16,11 @@
     private String salesContractNo;
 
     // 閲囪喘鍚堝悓鍙�
+    @Excel(name = "閲囪喘鍚堝悓鍙�")
     private String purchaseContractNumber;
 
     // 渚涘簲鍟嗗悕绉�
+    @Excel(name = "渚涘簲鍟嗗悕绉�")
     private String supplierName;
 
     // 鍙戠エ鍙�
diff --git a/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java b/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
index d0d3de6..547861e 100644
--- a/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
+++ b/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import com.ruoyi.sales.pojo.CommonFile;
 import com.ruoyi.sales.pojo.SalesLedgerProduct;
 import io.swagger.annotations.ApiModelProperty;
@@ -23,6 +24,7 @@
     /**
      * 閲囪喘鍚堝悓鍙�
      */
+    @Excel(name = "閲囪喘鍚堝悓鍙�")
     private String purchaseContractNumber;
 
 
@@ -34,6 +36,7 @@
     /**
      * 渚涘簲鍟嗗悕绉�
      */
+    @Excel(name = "渚涘簲鍟嗗悕绉�")
     private String supplierName;
 
     /**
@@ -45,11 +48,13 @@
     /**
      * 褰曞叆浜哄鍚�
      */
+    @Excel(name = "褰曞叆浜哄鍚�")
     private String recorderName;
 
     /**
      * 閿�鍞悎鍚屽彿
      */
+    @Excel(name = "閿�鍞悎鍚屽彿")
     private String salesContractNo;
 
     /**
@@ -60,12 +65,14 @@
     /**
      * 椤圭洰鍚嶇О
      */
+    @Excel(name = "椤圭洰鍚嶇О")
     private String projectName;
 
     /**
      * 褰曞叆鏃ユ湡
      */
     @JsonFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "褰曞叆鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
     private Date entryDate;
 
     /**
@@ -142,15 +149,18 @@
     /**
      * 鍚堝悓閲戦锛堜骇鍝佸惈绋庢�讳环锛�
      */
+    @Excel(name = "鍚堝悓閲戦")
     private BigDecimal contractAmount = BigDecimal.ZERO;
 
 
     @TableField(exist = false)
     @ApiModelProperty("鏉ョエ閲戦")
+    @Excel(name = "宸叉潵绁ㄩ噾棰�(鍏�)")
     private BigDecimal receiptPaymentAmount =  BigDecimal.ZERO;
 
     @ApiModelProperty("鏈潵绁ㄩ噾棰�")
     @TableField(exist = false)
+    @Excel(name = "鏈潵绁ㄩ噾棰�(鍏�)")
     private BigDecimal unReceiptPaymentAmount =BigDecimal.ZERO;
 
     @ApiModelProperty("鏂囦欢绫诲瀷  鍙� 4")
diff --git a/src/main/java/com/ruoyi/purchase/pojo/PaymentRegistration.java b/src/main/java/com/ruoyi/purchase/pojo/PaymentRegistration.java
index d117038..91f0540 100644
--- a/src/main/java/com/ruoyi/purchase/pojo/PaymentRegistration.java
+++ b/src/main/java/com/ruoyi/purchase/pojo/PaymentRegistration.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.annotation.*;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 
 import java.math.BigDecimal;
@@ -48,11 +49,13 @@
     /**
      * 鏈浠樻閲戦
      */
+    @Excel(name = "浠樻閲戦")
     private BigDecimal currentPaymentAmount;
 
     /**
      * 浠樻褰㈠紡
      */
+    @Excel(name = "浠樻褰㈠紡")
     private String paymentMethod;
 
     /**
@@ -72,12 +75,14 @@
      * 浠樻鏃ユ湡
      */
     @JsonFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "浠樻鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
     private Date paymentDate;
 
     /**
      * 鐧昏鏃ユ湡
      */
     @JsonFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "鐧昏鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
     private Date registrationtDate;
 
     /**
diff --git a/src/main/java/com/ruoyi/purchase/pojo/TicketRegistration.java b/src/main/java/com/ruoyi/purchase/pojo/TicketRegistration.java
index 47bb1f9..7428b0b 100644
--- a/src/main/java/com/ruoyi/purchase/pojo/TicketRegistration.java
+++ b/src/main/java/com/ruoyi/purchase/pojo/TicketRegistration.java
@@ -135,10 +135,12 @@
 
     @ApiModelProperty(value = "宸蹭粯娆炬�婚噾棰�")
     @TableField(exist = false)
+    @Excel(name = "宸蹭粯娆炬�婚噾棰�")
     private BigDecimal paymentAmountTotal;
 
     @ApiModelProperty(value = "鏈粯娆炬�婚噾棰�")
     @TableField(exist = false)
+    @Excel(name = "鏈粯娆炬�婚噾棰�")
     private BigDecimal unPaymentAmountTotal;
 
     @TableField(exist = false)
diff --git a/src/main/java/com/ruoyi/sales/controller/ReceiptPaymentController.java b/src/main/java/com/ruoyi/sales/controller/ReceiptPaymentController.java
index 98b1105..0801107 100644
--- a/src/main/java/com/ruoyi/sales/controller/ReceiptPaymentController.java
+++ b/src/main/java/com/ruoyi/sales/controller/ReceiptPaymentController.java
@@ -2,12 +2,19 @@
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.common.utils.bean.BeanUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.framework.aspectj.lang.annotation.Log;
+import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
 import com.ruoyi.framework.web.controller.BaseController;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.framework.web.page.TableDataInfo;
 import com.ruoyi.purchase.dto.InvoicePurchaseDto;
 import com.ruoyi.sales.dto.ReceiptPaymentDto;
+import com.ruoyi.sales.dto.ReceiptPaymentRecordDto;
+import com.ruoyi.sales.dto.SalesLedgerDto;
 import com.ruoyi.sales.pojo.ReceiptPayment;
+import com.ruoyi.sales.pojo.SalesLedger;
 import com.ruoyi.sales.service.ReceiptPaymentService;
 import io.swagger.annotations.ApiModelProperty;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -154,6 +161,26 @@
     }
 
     /**
+     * 瀵煎嚭鍥炴娴佹按鍒楄〃
+     */
+    @Log(title = "瀵煎嚭鍥炴娴佹按鍒楄〃", businessType = BusinessType.EXPORT)
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response, ReceiptPaymentDto salesLedgerDto) {
+        Page page = new Page();
+        page.setCurrent(-1);
+        page.setSize(-1);
+        IPage<ReceiptPaymentDto> salesLedgerIPage = receiptPaymentHistoryListPage(page, salesLedgerDto);
+        ExcelUtil<ReceiptPaymentRecordDto> util = new ExcelUtil<ReceiptPaymentRecordDto>(ReceiptPaymentRecordDto.class);
+        List<ReceiptPaymentRecordDto> receiptPaymentRecordDtos = new ArrayList<>();
+        salesLedgerIPage.getRecords().forEach(receiptPaymentRecordDto -> {
+            ReceiptPaymentRecordDto receiptPaymentRecordDto1 = new ReceiptPaymentRecordDto();
+            BeanUtils.copyBeanProp(receiptPaymentRecordDto, receiptPaymentRecordDto1);
+            receiptPaymentRecordDtos.add(receiptPaymentRecordDto1);
+        });
+        util.exportExcel(response, receiptPaymentRecordDtos, "瀵煎嚭寮�绁ㄧ櫥璁板垪琛�");
+    }
+
+    /**
      * 鏌ヨ鍥炴璁板綍涓嶅垎椤�
      */
     @GetMapping("/receiptPaymentHistoryListNoPage")
diff --git a/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java b/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
index e968530..c384520 100644
--- a/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
+++ b/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
@@ -29,6 +29,7 @@
 import javax.servlet.http.HttpServletResponse;
 import java.math.BigDecimal;
 import java.util.ArrayList;
+import java.util.Collection;
 import java.util.List;
 import java.util.Objects;
 import java.util.stream.Collectors;
@@ -105,6 +106,20 @@
     }
 
     /**
+     * 瀵煎嚭寮�绁ㄧ櫥璁板垪琛�
+     */
+    @Log(title = "瀵煎嚭寮�绁ㄧ櫥璁板垪琛�", businessType = BusinessType.EXPORT)
+    @PostMapping("/exportOne")
+    public void exportOne(HttpServletResponse response, SalesLedgerDto salesLedgerDto) {
+        Page page = new Page();
+        page.setCurrent(-1);
+        page.setSize(-1);
+        IPage<SalesLedger> salesLedgerIPage = listPage(page, salesLedgerDto);
+        ExcelUtil<SalesLedger> util = new ExcelUtil<SalesLedger>(SalesLedger.class);
+        util.exportExcel(response, salesLedgerIPage == null ? new ArrayList<>() : salesLedgerIPage.getRecords(), "瀵煎嚭寮�绁ㄧ櫥璁板垪琛�");
+    }
+
+    /**
      * 鏂板淇敼閿�鍞彴璐�
      */
     @Log(title = "閿�鍞彴璐�", businessType = BusinessType.INSERT)
diff --git a/src/main/java/com/ruoyi/sales/dto/ReceiptPaymentRecordDto.java b/src/main/java/com/ruoyi/sales/dto/ReceiptPaymentRecordDto.java
new file mode 100644
index 0000000..8e9bd4b
--- /dev/null
+++ b/src/main/java/com/ruoyi/sales/dto/ReceiptPaymentRecordDto.java
@@ -0,0 +1,61 @@
+package com.ruoyi.sales.dto;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.util.Date;
+
+/**
+ * @author :yys
+ * @date : 2025/10/31 10:17
+ */
+@Data
+public class ReceiptPaymentRecordDto {
+
+    @ApiModelProperty(value = "瀹㈡埛鍚堝悓鍙�")
+    @Excel(name = "瀹㈡埛鍚堝悓鍙�")
+    private String customerContractNo;
+
+    @ApiModelProperty(value = "瀹㈡埛鍚嶇О")
+    @Excel(name = "瀹㈡埛鍚嶇О")
+    private String customerName;
+
+    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "鐧昏鏃ユ湡",width = 30,dateFormat = "yyyy-MM-dd")
+    @ApiModelProperty(value = "鐧昏鏃ユ湡")
+    private Date invoiceDate;
+
+    @ApiModelProperty(value = "閿�鍞悎鍚屽彿")
+    @Excel(name = "閿�鍞悎鍚屽彿")
+    private String salesContractNo;
+
+    @ApiModelProperty(value = "鍥炴閲戦")
+    @Excel(name = "鍥炴閲戦")
+    private BigDecimal receiptPaymentAmountTotal;
+
+    @ApiModelProperty(value = "椤圭洰鍚嶇О")
+    @Excel(name = "椤圭洰鍚嶇О")
+    private String projectName;
+
+    @ApiModelProperty(value = "鍥炴褰㈠紡 0鐢垫眹1鎵垮厬")
+    @Excel(name = "鍥炴褰㈠紡",readConverterExp = "0=鐢垫眹,1=鎵垮厬")
+    private String receiptPaymentType;
+
+    @ApiModelProperty(value = "鐧昏浜�")
+    @Excel(name = "鐧昏浜�")
+    private String registrant;
+
+    @ApiModelProperty(value = "鏉ユ鏃ユ湡")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "鏉ユ鏃ユ湡",width = 30,dateFormat = "yyyy-MM-dd")
+    private LocalDate receiptPaymentDate;
+
+}
diff --git a/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java b/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
index 61a4c36..4ffdb03 100644
--- a/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
+++ b/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
@@ -104,6 +104,7 @@
 
     @TableField(exist = false)
     @ApiModelProperty(value = "鏈紑绁ㄩ噾棰�(鍏�)")
+    @Excel(name = "鏈紑绁ㄩ噾棰�")
     private BigDecimal noInvoiceAmountTotal = BigDecimal.ZERO;
 
     @ApiModelProperty(value = "绛捐鏃ユ湡")
@@ -111,6 +112,7 @@
 
     @TableField(exist = false)
     @ApiModelProperty(value = "宸插紑绁ㄩ噾棰�(鍏�)")
+    @Excel(name = "宸插紑绁ㄩ噾棰�")
     private BigDecimal invoiceTotal = BigDecimal.ZERO;
 
     @TableField(exist = false)
diff --git a/src/main/java/com/ruoyi/staff/controller/StaffSchedulingController.java b/src/main/java/com/ruoyi/staff/controller/StaffSchedulingController.java
index e7c4c40..9f5d82c 100644
--- a/src/main/java/com/ruoyi/staff/controller/StaffSchedulingController.java
+++ b/src/main/java/com/ruoyi/staff/controller/StaffSchedulingController.java
@@ -1,13 +1,20 @@
 package com.ruoyi.staff.controller;
 
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.compensationperformance.pojo.CompensationPerformance;
+import com.ruoyi.framework.aspectj.lang.annotation.Log;
+import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.staff.dto.SaveStaffSchedulingDto;
+import com.ruoyi.staff.dto.StaffSchedulingDto;
 import com.ruoyi.staff.service.StaffSchedulingService;
 import com.ruoyi.staff.vo.SearchSchedulingVo;
 import lombok.RequiredArgsConstructor;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 /**
@@ -46,4 +53,15 @@
         return AjaxResult.success();
     }
 
+    @Log(title = "瀵煎嚭浜哄憳鎺掔彮鍒楄〃", businessType = BusinessType.EXPORT)
+    @PostMapping("/export")
+    public void export(HttpServletResponse response ) {
+        SearchSchedulingVo vo = new SearchSchedulingVo();
+        vo.setCurrent(-1);
+        vo.setSize(-1);
+        IPage<StaffSchedulingDto> list = staffSchedulingService.listPage(vo);
+        ExcelUtil<StaffSchedulingDto> util = new ExcelUtil<StaffSchedulingDto>(StaffSchedulingDto.class);
+        util.exportExcel(response, list.getRecords(), "瀵煎嚭浜哄憳鎺掔彮鍒楄〃");
+    }
+
 }
diff --git a/src/main/java/com/ruoyi/staff/dto/StaffSchedulingDto.java b/src/main/java/com/ruoyi/staff/dto/StaffSchedulingDto.java
index 6643a38..ad8b812 100644
--- a/src/main/java/com/ruoyi/staff/dto/StaffSchedulingDto.java
+++ b/src/main/java/com/ruoyi/staff/dto/StaffSchedulingDto.java
@@ -3,6 +3,7 @@
 import com.baomidou.mybatisplus.annotation.IdType;
 import com.baomidou.mybatisplus.annotation.TableId;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import lombok.Data;
 
 import java.io.Serializable;
@@ -25,50 +26,60 @@
      */
     private Integer staffId;
 
+    @Excel(name = "鍛樺伐鍚嶇О")
     private String staffName;
 
+    @Excel(name = "鍛樺伐缂栧彿")
     private String staffNo;
 
     /**
      * 閮ㄩ棬
      */
+    @Excel(name = "閮ㄩ棬鍚嶇О")
     private String department;
 
     /**
      * 鎺掔彮绫诲瀷
      */
+    @Excel(name = "鐝鍚嶇О", readConverterExp = "1=鏃╃彮,2=涓彮,3=鏅氱彮,4=澶滅彮鐝�")
     private String shiftType;
 
     /**
      * 宸ヤ綔鏃ユ湡
      */
     @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+    @Excel(name = "宸ヤ綔鏃ユ湡", dateFormat = "yyyy-MM-dd", width = 20)
     private Date workDate;
 
     /**
      * 寮�濮嬪伐浣滄椂闂�
      */
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+    @Excel(name = "寮�濮嬪伐浣滄椂闂�", dateFormat = "mm:ss", width = 20)
     private LocalDateTime workStartTime;
 
     /**
      * 缁撴潫宸ヤ綔鏃堕棿
      */
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+    @Excel(name = "缁撴潫宸ヤ綔鏃堕棿", dateFormat = "mm:ss", width = 20)
     private LocalDateTime workEndTime;
 
     /**
      * 宸ヤ綔鏃堕暱
      */
+    @Excel(name = "宸ヤ綔鏃堕暱", width = 20)
     private BigDecimal workHours;
 
     /**
      * 鐘舵��
      */
+    @Excel(name = "鐘舵��", readConverterExp = "1=宸插畨鎺�,2=宸茬‘璁�,3=宸插畬鎴�,4=宸插彇娑�")
     private String status;
 
     /**
      * 澶囨敞
      */
+    @Excel(name = "澶囨敞")
     private String remark;
 }

--
Gitblit v1.9.3