yys 1.导出接口开发

maven

5 天以前 2ed03e83ce1e513632a188de78190e79a85636b9

yys
1.导出接口开发

 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, "协同审批导出");
    }
}

 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, "知识库管理导出");
    }

}

 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流程自动化导出");
    }

}

 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;

    /**

 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;
    /**
     * æ›´æ–°æ—¶é—´

 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;
    /**
     * åˆ›å»ºæ—¶é—´

 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, "会议草稿导出");
    }

}

 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, "规章制度管理导出");
    }
}

 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, "用印申请管理导出");
    }

}

 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;

    /**

 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;

    /**

 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;
    /**
     * ä¿®æ”¹äºº

 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;
    /**
     * åˆ›å»ºè€…

 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);


 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;

 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, "导出薪资管理列表");
    }


}

 src/main/java/com/ruoyi/compensationperformance/pojo/CompensationPerformance.java

@@ -31,7 +31,6 @@
     * å‘˜å·¥id
     */
    @ApiModelProperty("员工id")
    @Excel(name = "员工id")
    private Long staffId;

    /**

 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(), "导出付款流水列表");
    }

    /**
     * èŽ·å–付款登记详细信息

 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)

 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")

 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;

    // å‘票号

 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")

 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;

    /**

 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)

 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")

 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)

 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;

}

 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)

 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(), "导出人员排班列表");
    }

}

 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;
}