package com.fzzy.igds.export; import com.fzzy.igds.ReportInDetailPR; import com.fzzy.igds.data.InoutParam; import com.fzzy.igds.domain.Dept; import com.fzzy.igds.domain.InoutRecord; import com.fzzy.igds.service.InoutRecordService; import com.fzzy.igds.service.SysDeptService; import com.fzzy.igds.utils.ContextUtil; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.core.domain.entity.SysDept; import com.ruoyi.common.utils.poi.ExcelUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import javax.annotation.Resource; import java.util.List; /** * 数据导出EXCEL入口 * * @author sgj * @date 2025/12/24 */ @Controller @RequestMapping("export") public class ReportController { @Resource private InoutRecordService inoutReportService; @Resource private SysDeptService sysDeptService; @Autowired private ReportInDetailPR reportInDetailPR; /** * 出入库报表导出 * @return */ @RequestMapping("/inReport-excel") @ResponseBody public AjaxResult inReportExcel(InoutParam param) { //查询数据 List list = reportInDetailPR.listRecord(param); //设置标题 String sheetName = "入库报表数据"; //获取分库编码对应的分库名称 String deptName = ""; SysDept subDept = sysDeptService.getCacheDept(null, ContextUtil.subDeptId(null)); if (null != subDept) { deptName = subDept.getDeptName(); } //导出 ExcelUtil util = new ExcelUtil(InoutRecord.class); return util.exportExcel(list, sheetName, deptName); } }