| fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordDetailInExport.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordDetailOutExport.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordInExport.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordOutExport.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetail.view.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetailPR.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetail.view.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetailPR.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| fzzy-igdss-view/src/main/java/com/fzzy/igds/export/ReportController.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordDetailInExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.fzzy.igds.data; import com.ruoyi.common.annotation.Excel; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * åºåºæç»æ¥è¡¨ãå ¥åºæç»æ¥è¡¨å¯¼åºå®ä½ç±» * * @author sgj * @date 2025/12/30 */ @Data public class InoutRecordDetailInExport implements Serializable { @Excel(name = "æ¶å¨å ¬å¸",sort = 1) private String companyId; //æ¶å¨å ¬å¸ @Excel(name = "åºåºå称",sort = 2) private String deptId; @Excel(name = "åæ®å·",sort = 3) private String id; @Excel(name = "车çå·",sort = 4) private String plateNum; @Excel(name = "ä»åº",sort = 5) private String depotId; @Excel(name = "ç²®é£åç§",sort = 6) private String foodVariety; @Excel(name = "ç»ç®éé",sort = 7) private Double settleWeight = 0.0; @Excel(name = "å ¥åºéé",sort = 8) private Double recordWeight = 0.0; @Excel(name = "离åºæ¶é´",sort = 9,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date completeTime; } fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordDetailOutExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.fzzy.igds.data; import com.ruoyi.common.annotation.Excel; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * åºåºæç»æ¥è¡¨ãå ¥åºæç»æ¥è¡¨å¯¼åºå®ä½ç±» * * @author sgj * @date 2025/12/30 */ @Data public class InoutRecordDetailOutExport implements Serializable { @Excel(name = "æ¶å¨å ¬å¸",sort = 1) private String companyId; //æ¶å¨å ¬å¸ @Excel(name = "åºåºå称",sort = 2) private String deptId; @Excel(name = "åæ®å·",sort = 3) private String id; @Excel(name = "车çå·",sort = 4) private String plateNum; @Excel(name = "ä»åº",sort = 5) private String depotId; @Excel(name = "ç²®é£åç§",sort = 6) private String foodVariety; @Excel(name = "ç»ç®éé",sort = 7) private Double settleWeight = 0.0; @Excel(name = "åºåºéé",sort = 8) private Double recordWeight = 0.0; @Excel(name = "离åºæ¶é´",sort = 9,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date completeTime; } fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordInExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,52 @@ package com.fzzy.igds.data; import com.ruoyi.common.annotation.Excel; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * åºåºæ¥è¡¨ãå ¥åºæ¥è¡¨å¯¼åºå®ä½ç±» * * @author sgj * @date 2025/12/30 */ @Data public class InoutRecordInExport implements Serializable { @Excel(name = "åæ®å·",sort = 1) private String id; @Excel(name = "车çå·",sort = 2) private String plateNum; @Excel(name = "ä»åº",sort = 3) private String depotId; @Excel(name = "ç²®é£åç§",sort = 4) private String foodVariety; @Excel(name = "æ¯é",sort = 5) private Double fullWeight = 0.0; @Excel(name = "ç®é",sort = 6) private Double emptyWeight = 0.0; @Excel(name = "åé",sort = 7) private Double netWeight = 0.0; @Excel(name = "æ£é",sort = 8) private Double deOther = 0.0; @Excel(name = "ç»ç®éé",sort = 9) private Double settleWeight = 0.0; @Excel(name = "å ¥åºéé",sort = 10) private Double recordWeight = 0.0; @Excel(name = "离åºæ¶é´",sort = 11,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date completeTime; } fzzy-igdss-core/src/main/java/com/fzzy/igds/data/InoutRecordOutExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,52 @@ package com.fzzy.igds.data; import com.ruoyi.common.annotation.Excel; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * åºåºæ¥è¡¨ãå ¥åºæ¥è¡¨å¯¼åºå®ä½ç±» * * @author sgj * @date 2025/12/30 */ @Data public class InoutRecordOutExport implements Serializable { @Excel(name = "åæ®å·",sort = 1) private String id; @Excel(name = "车çå·",sort = 2) private String plateNum; @Excel(name = "ä»åº",sort = 3) private String depotId; @Excel(name = "ç²®é£åç§",sort = 4) private String foodVariety; @Excel(name = "æ¯é",sort = 5) private Double fullWeight = 0.0; @Excel(name = "ç®é",sort = 6) private Double emptyWeight = 0.0; @Excel(name = "åé",sort = 7) private Double netWeight = 0.0; @Excel(name = "æ£é",sort = 8) private Double deOther = 0.0; @Excel(name = "ç»ç®éé",sort = 9) private Double settleWeight = 0.0; @Excel(name = "åºåºéé",sort = 10) private Double recordWeight = 0.0; @Excel(name = "离åºæ¶é´",sort = 11,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date completeTime; } fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetail.view.xml
@@ -418,7 +418,25 @@ var data = view.get("#dsQuery.data");
 view.get("#dsQuery").set("parameter",data).flushAsync();
 };
 query();</ClientEvent> query();
 
 
 
 
 //追踪
 showImg = function(){
 
 var select = view.get("#dataGridMain2").get("selection");
 if(select){
 var user = encodeURIComponent(select.get("userName"));
 var plateNum = encodeURIComponent(select.get("plateNum"));
 
 view.get("#iFrameImg").set("path", "./basic/inout/inout-img?id=" + select.get("id")+"&plateNum="+plateNum+"&user="+user);
 view.get("#dialogImg").show();
 }else{
 $notify("请éæ©æ°æ®â¦â¦");
 }
 };</ClientEvent> <Property name="packages">font-awesome,css-common</Property> <DataSet id="dsMain"> <Property name="dataType">[dtMain]</Property> @@ -539,7 +557,7 @@ <Button layoutConstraint="left"> <ClientEvent name="onClick">var data = view.get("#dsQuery.data");
 var param = {
 "type":"IN",
 "type":"IN_DETAIL",
 "deptId":data.get("deptId"),
 "companyId":data.get("companyId"),
 "start":data.get("start"),
 @@ -698,6 +716,7 @@ arg.dom.style.fontWeight = "bold";
 //arg.processDefault = false;
 }</ClientEvent> <ClientEvent name="onDataRowClick">view.get("#dataGridMain2").set("selection",arg.data);</ClientEvent> <Property name="dataSet">dsMain</Property> <Property name="readOnly">true</Property> <Property name="highlightCurrentRow">false</Property> @@ -705,6 +724,8 @@ <Property name="hideMode">display</Property> <Property name="headerRowHeight">30</Property> <Property name="rowHeight">50</Property> <Property name="selectionMode">singleRow</Property> <RowSelectorColumn/> <RowNumColumn> <Property name="caption">åºå·</Property> </RowNumColumn> @@ -764,7 +785,10 @@ <Property name="width">150</Property> </DataColumn> <DataColumn> <ClientEvent name="onRenderCell">//arg.dom.innerHTML = "<a href='javascript:;' onClick='detail()' class='a-btn1'>æ¥ç详æ </a>";</ClientEvent> <ClientEvent name="onRenderCell"> var txt = arg.data.getText("id");
 if(!txt || txt == 'å计') return true;
 
 arg.dom.innerHTML = "<a href='javascript:;' onClick='showImg()' class='a-btn1'>è¿ç¨è¿½æº¯</a>";</ClientEvent> <Property name="width">160</Property> <Property name="caption">æä½</Property> <Property name="align">center</Property> @@ -782,5 +806,18 @@ </DataPilot> </ToolBar> </Container> <Dialog id="dialogImg"> <Property name="width">55%</Property> <Property name="height">95%</Property> <Property name="iconClass">fa fa-tasks</Property> <Property name="caption">æµç¨è¿½æº¯å±ç¤º</Property> <Buttons/> <Children> <IFrame id="iFrameImg"> <Property name="width">100%</Property> </IFrame> </Children> <Tools/> </Dialog> </View> </ViewConfig> fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetailPR.java
@@ -74,6 +74,8 @@ } //æ¥è¯¢å ¥åºæ°æ® param.setType(Constant.TYPE_IN); param.setProgress(Constant.PROGRESS_RECORD); param.setRecordStatus(Constant.RECORD_STATUS_NORMAL); //å¤åæ°å页æ¥è¯¢ com.baomidou.mybatisplus.extension.plugins.pagination.Page<InoutRecord> corePage = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(0, 10000); //æ¶å¨å ¬å¸æ¥è¯¢å¤ç fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetail.view.xml
@@ -185,7 +185,7 @@ <Property></Property> <Property name="label">è£ å¸ä»åº</Property> <Property name="mapping"> <Property name="mapValues">${dorado.getDataProvider("depotPR#getAllCache").getResult()}</Property> <Property name="mapValues">${dorado.getDataProvider("depotPR#getData").getResult()}</Property> <Property name="keyProperty">id</Property> <Property name="valueProperty">name</Property> </Property> @@ -320,7 +320,7 @@ <Property></Property> <Property name="label">è£ å¸ä»åº</Property> <Property name="mapping"> <Property name="mapValues">${dorado.getDataProvider("depotPR#getAllCache").getResult()}</Property> <Property name="mapValues">${dorado.getDataProvider("depotPR#getData").getResult()}</Property> <Property name="keyProperty">id</Property> <Property name="valueProperty">name</Property> </Property> @@ -417,7 +417,21 @@ var data = view.get("#dsQuery.data");
 view.get("#dsQuery").set("parameter",data).flushAsync();
 };
 query();</ClientEvent> query();
 
 showImg = function(){
 
 var select = view.get("#dataGridMain2").get("selection");
 if(select){
 var user = encodeURIComponent(select.get("userName"));
 var plateNum = encodeURIComponent(select.get("plateNum"));
 
 view.get("#iFrameImg").set("path", "./basic/inout/inout-img?id=" + select.get("id")+"&plateNum="+plateNum+"&user="+user);
 view.get("#dialogImg").show();
 }else{
 $notify("请éæ©æ°æ®â¦â¦");
 }
 };</ClientEvent> <Property name="packages">font-awesome,css-common</Property> <DataSet id="dsMain"> <Property name="dataType">[dtMain]</Property> @@ -536,7 +550,7 @@ <Button layoutConstraint="left"> <ClientEvent name="onClick">var data = view.get("#dsQuery.data");
 var param = {
 "type":"OUT",
 "type":"OUT_DETAIL",
 "deptId":data.get("deptId"),
 "companyId":data.get("companyId"),
 "start":data.get("start"),
 @@ -695,6 +709,7 @@ arg.dom.style.fontWeight = "bold";
 //arg.processDefault = false;
 }</ClientEvent> <ClientEvent name="onDataRowClick">view.get("#dataGridMain2").set("selection",arg.data);</ClientEvent> <Property name="dataSet">dsMain</Property> <Property name="readOnly">true</Property> <Property name="highlightCurrentRow">false</Property> @@ -702,6 +717,8 @@ <Property name="hideMode">display</Property> <Property name="headerRowHeight">30</Property> <Property name="rowHeight">50</Property> <Property name="selectionMode">singleRow</Property> <RowSelectorColumn/> <RowNumColumn> <Property name="caption">åºå·</Property> </RowNumColumn> @@ -761,7 +778,9 @@ <Property name="width">150</Property> </DataColumn> <DataColumn> <ClientEvent name="onRenderCell">//arg.dom.innerHTML = "<a href='javascript:;' onClick='detail()' class='a-btn1'>æ¥ç详æ </a>";</ClientEvent> <ClientEvent name="onRenderCell"> var txt = arg.data.getText("id");
 if(!txt || txt == 'å计') return true;
 arg.dom.innerHTML = "<a href='javascript:;' onClick='showImg()' class='a-btn1'>è¿ç¨è¿½æº¯</a>";</ClientEvent> <Property name="width">160</Property> <Property name="caption">æä½</Property> <Property name="align">center</Property> @@ -779,5 +798,18 @@ </DataPilot> </ToolBar> </Container> <Dialog id="dialogImg"> <Property name="width">55%</Property> <Property name="height">95%</Property> <Property name="iconClass">fa fa-tasks</Property> <Property name="caption">æµç¨è¿½æº¯å±ç¤º</Property> <Buttons/> <Children> <IFrame id="iFrameImg"> <Property name="width">100%</Property> </IFrame> </Children> <Tools/> </Dialog> </View> </ViewConfig> fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetailPR.java
@@ -74,6 +74,8 @@ } //æ¥è¯¢åºåºæ°æ® param.setType(Constant.TYPE_OUT); param.setProgress(Constant.PROGRESS_RECORD); param.setRecordStatus(Constant.RECORD_STATUS_NORMAL); //å¤åæ°å页æ¥è¯¢ com.baomidou.mybatisplus.extension.plugins.pagination.Page<InoutRecord> corePage = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(0, 10000); //æ¶å¨å ¬å¸æ¥è¯¢å¤ç fzzy-igdss-view/src/main/java/com/fzzy/igds/export/ReportController.java
@@ -1,12 +1,8 @@ package com.fzzy.igds.export; import com.fzzy.igds.ReportInDetailPR; import com.fzzy.igds.ReportOutDetailPR; import com.fzzy.igds.SuperInventoryReportPR; import com.fzzy.igds.data.InoutParam; import com.fzzy.igds.data.SuperInventoryReportData; import com.fzzy.igds.data.SuperInventoryReportParam; import com.fzzy.igds.*; import com.fzzy.igds.data.*; import com.fzzy.igds.domain.Company; import com.fzzy.igds.domain.Depot; import com.fzzy.igds.domain.Dept; @@ -15,6 +11,7 @@ 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.core.domain.entity.SysDictData; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import org.springframework.beans.factory.annotation.Autowired; @@ -24,9 +21,10 @@ import javax.annotation.Resource; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Optional; import java.util.stream.Collectors; /** @@ -42,35 +40,37 @@ @Resource private InoutRecordService inoutReportService; @Resource private SysDeptService sysDeptService; @Resource private CoreDeptService coreDeptService; @Resource private DepotService depotService; @Resource private CoreCompanyService coreCompanyService; @Autowired private ReportInDetailPR reportInDetailPR; @Autowired private ReportOutDetailPR reportOutDetailPR; @Autowired private SuperInventoryReportPR superInventoryReportPR; @Autowired private CompanyPR companyPR; @Autowired private DeptPR deptPR; @Autowired private DepotPR depotPR; @Autowired private DicPR dicPR; /** * åºå ¥åºæ¥è¡¨å¯¼åº * * @return */ @RequestMapping("/inOutReport-excel") @@ -80,32 +80,152 @@ String sheetName = "æ¥è¡¨æ°æ®"; //æ¥è¯¢æ°æ® List<InoutRecord> list = new ArrayList<>(); if (StringUtils.isNotEmpty(param.getType()) && "IN".equals(param.getType())) { sheetName = "å ¥åºæ¥è¡¨æ°æ®"; list = reportInDetailPR.listRecord(param); } if (StringUtils.isNotEmpty(param.getType()) && "OUT".equals(param.getType())) { sheetName = "åºåºæ¥è¡¨æ°æ®"; list = reportOutDetailPR.listRecord(param); } //è·åååºç¼ç 对åºçååºå称 String deptName = ""; SysDept subDept = sysDeptService.getCacheDept(null, ContextUtil.subDeptId(null)); if (null != subDept) { deptName = subDept.getDeptName(); } //å建æ¶å¨å ¬å¸IDå°å称çæ å° Map<String, String> companyMap = Optional.ofNullable(companyPR.getData()) .orElse(new ArrayList<>()) .stream() .collect(Collectors.toMap(Company::getId, Company::getDwmc, (key1, key2) -> key2)); //å建æå¨åºåºIDå°å称çæ å° Map<String, String> deptMap = Optional.ofNullable(deptPR.getAllData()) .orElse(new ArrayList<>()) .stream() .collect(Collectors.toMap(Dept::getId, Dept::getKqmc, (key1, key2) -> key2)); // å建ä»åºIDå°å称çæ å° Map<String, String> depotMap = Optional.ofNullable(depotPR.getData(null)) .orElse(new ArrayList<>()) .stream() .collect(Collectors.toMap(Depot::getId, Depot::getName, (key1, key2) -> key2)); //å建粮é£åç§IDå°å称çæ å° Map<String, String> foodVarietyMap = Optional.ofNullable(dicPR.sysDictData("FOOD_VARIETY_")) .orElse(new ArrayList<>()) .stream() .collect(Collectors.toMap(SysDictData::getDictValue, SysDictData::getDictLabel, (key1, key2) -> key2)); //å¯¼åº ExcelUtil<InoutRecord> util = new ExcelUtil<InoutRecord>(InoutRecord.class); return util.exportExcel(list, sheetName, deptName); //ç»è£ å®é 导åºæ°æ® if (StringUtils.isNotEmpty(param.getType()) && "IN".equals(param.getType())) { sheetName = "å ¥åºæ¥è¡¨æ°æ®"; list = reportInDetailPR.listRecord(param); List<InoutRecordInExport> exportList = new ArrayList<>(); for (InoutRecord record : list) { InoutRecordInExport export = new InoutRecordInExport(); export.setId(record.getId()); export.setPlateNum(record.getPlateNum()); // å°ä»åºIDæ å°ä¸ºä»åºå称 String depotNameValue = depotMap.get(record.getDepotId()); export.setDepotId(depotNameValue != null ? depotNameValue : ""); //ç²®é£åç§æ å° String foodVarietyNameValue = foodVarietyMap.get(record.getFoodVariety()); export.setFoodVariety(foodVarietyNameValue != null ? foodVarietyNameValue : ""); export.setFullWeight(record.getFullWeight()); export.setEmptyWeight(record.getEmptyWeight()); export.setNetWeight(record.getNetWeight()); export.setSettleWeight(record.getSettleWeight()); export.setRecordWeight(record.getRecordWeight()); export.setCompleteTime(record.getCompleteTime()); export.setDeOther(record.getDeOther()); exportList.add(export); } ExcelUtil<InoutRecordInExport> util = new ExcelUtil<InoutRecordInExport>(InoutRecordInExport.class); return util.exportExcel(exportList, sheetName, deptName); } if (StringUtils.isNotEmpty(param.getType()) && "OUT".equals(param.getType())) { sheetName = "åºåºæ¥è¡¨æ°æ®"; list = reportOutDetailPR.listRecord(param); List<InoutRecordOutExport> exportList = new ArrayList<>(); for (InoutRecord record : list) { InoutRecordOutExport export = new InoutRecordOutExport(); export.setId(record.getId()); export.setPlateNum(record.getPlateNum()); // å°ä»åºIDæ å°ä¸ºä»åºå称 String depotNameValue = depotMap.get(record.getDepotId()); export.setDepotId(depotNameValue != null ? depotNameValue : ""); //ç²®é£åç§æ å° String foodVarietyNameValue = foodVarietyMap.get(record.getFoodVariety()); export.setFoodVariety(foodVarietyNameValue != null ? foodVarietyNameValue : ""); export.setFullWeight(record.getFullWeight()); export.setEmptyWeight(record.getEmptyWeight()); export.setNetWeight(record.getNetWeight()); export.setSettleWeight(record.getSettleWeight()); export.setRecordWeight(record.getRecordWeight()); export.setCompleteTime(record.getCompleteTime()); export.setDeOther(record.getDeOther()); exportList.add(export); } ExcelUtil<InoutRecordOutExport> util = new ExcelUtil<InoutRecordOutExport>(InoutRecordOutExport.class); return util.exportExcel(exportList, sheetName, deptName); } if (StringUtils.isNotEmpty(param.getType()) && "IN_DETAIL".equals(param.getType())) { sheetName = "å ¥åºæç»æ¥è¡¨æ°æ®"; list = reportInDetailPR.listRecord(param); List<InoutRecordDetailInExport> exportList = new ArrayList<>(); for (InoutRecord record : list) { InoutRecordDetailInExport export = new InoutRecordDetailInExport(); //æ¶å¨å ¬å¸æ å° String companyNameValue = companyMap.get(record.getCompanyId()); export.setCompanyId(companyNameValue != null ? companyNameValue : ""); //åºåºæ å° String deptNameValue = deptMap.get(record.getDeptId()); export.setDeptId(deptNameValue != null ? deptNameValue : ""); export.setId(record.getId()); export.setPlateNum(record.getPlateNum()); // å°ä»åºIDæ å°ä¸ºä»åºå称 String depotNameValue = depotMap.get(record.getDepotId()); export.setDepotId(depotNameValue != null ? depotNameValue : ""); //ç²®é£åç§æ å° String foodVarietyNameValue = foodVarietyMap.get(record.getFoodVariety()); export.setFoodVariety(foodVarietyNameValue != null ? foodVarietyNameValue : ""); export.setSettleWeight(record.getSettleWeight()); export.setRecordWeight(record.getRecordWeight()); export.setCompleteTime(record.getCompleteTime()); exportList.add(export); } ExcelUtil<InoutRecordDetailInExport> util = new ExcelUtil<InoutRecordDetailInExport>(InoutRecordDetailInExport.class); return util.exportExcel(exportList, sheetName, deptName); } if (StringUtils.isNotEmpty(param.getType()) && "OUT_DETAIL".equals(param.getType())) { sheetName = "åºåºæç»æ¥è¡¨æ°æ®"; list = reportOutDetailPR.listRecord(param); List<InoutRecordDetailOutExport> exportList = new ArrayList<>(); for (InoutRecord record : list) { InoutRecordDetailOutExport export = new InoutRecordDetailOutExport(); //æ¶å¨å ¬å¸æ å° String companyNameValue = companyMap.get(record.getCompanyId()); export.setCompanyId(companyNameValue != null ? companyNameValue : ""); //åºåºæ å° String deptNameValue = deptMap.get(record.getDeptId()); export.setDeptId(deptNameValue != null ? deptNameValue : ""); export.setId(record.getId()); export.setPlateNum(record.getPlateNum()); // å°ä»åºIDæ å°ä¸ºä»åºå称 String depotNameValue = depotMap.get(record.getDepotId()); export.setDepotId(depotNameValue != null ? depotNameValue : ""); //ç²®é£åç§æ å° String foodVarietyNameValue = foodVarietyMap.get(record.getFoodVariety()); export.setFoodVariety(foodVarietyNameValue != null ? foodVarietyNameValue : ""); export.setSettleWeight(record.getSettleWeight()); export.setRecordWeight(record.getRecordWeight()); export.setCompleteTime(record.getCompleteTime()); exportList.add(export); } ExcelUtil<InoutRecordDetailOutExport> util = new ExcelUtil<InoutRecordDetailOutExport>(InoutRecordDetailOutExport.class); return util.exportExcel(exportList, sheetName, deptName); } return AjaxResult.error("åæ°é误"); } /** * åºåæ¥è¡¨å¯¼åº * * @return */ @RequestMapping("/superInventoryReport-excel")
