consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java
@@ -229,7 +229,7 @@ throw new RuntimeException("数据为空"); } int countNum = exportList.stream().filter(item -> item.getNum() != null).mapToInt(OutputExcelTemplate::getNum).sum(); int totalAmount = exportList.stream().filter(item -> item.getTotalAmount() != null).mapToInt(OutputExcelTemplate::getTotalAmount).sum(); double totalAmount = exportList.stream().filter(item -> item.getTotalAmount() != null).mapToDouble(OutputExcelTemplate::getAmount).sum(); Optional<OutputExcelTemplate> first = exportList.stream().findFirst(); OutputExcelTemplate templateExcelExport = first.get(); String businessFormCode = templateExcelExport.getBusinessFormCode(); consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java
@@ -440,7 +440,7 @@ } int countNum = exportList.stream().filter(item -> item.getNum() != null).mapToInt(ProcureExcelTemplate::getNum).sum(); int totalAmount = exportList.stream().filter(export -> export.getTotalAmount() != null).mapToInt(ProcureExcelTemplate::getTotalAmount).sum(); double totalAmount = exportList.stream().filter(export -> export.getTotalAmount() != null).mapToDouble(ProcureExcelTemplate::getAmount).sum(); Optional<ProcureExcelTemplate> first = exportList.stream().findFirst(); ProcureExcelTemplate templateExcelExport = first.get(); String businessFormCode = templateExcelExport.getBusinessFormCode(); consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
@@ -321,7 +321,7 @@ List<TransferExcelTemplate> export = this.lWhFormTransferService.export(id, type); int countNum = export.stream().filter(item -> item.getNum() != null).mapToInt(TransferExcelTemplate::getNum).sum(); int totalAmount = export.stream().filter(item -> item.getTotalAmount() != null).mapToInt(TransferExcelTemplate::getTotalAmount).sum(); double totalAmount = export.stream().filter(item -> item.getTotalAmount() != null).mapToDouble(TransferExcelTemplate::getAmount).sum(); Optional<TransferExcelTemplate> first = export.stream().findFirst(); TransferExcelTemplate entity = first.get(); String businessFormCode = entity.getBusinessFormCode(); consum-base/src/main/java/com/consum/base/core/utils/CurrencyUtil.java
@@ -8,20 +8,22 @@ public class CurrencyUtil { public static BigDecimal convertFenToYuan(long price) { return new BigDecimal(price).divide(new BigDecimal(100)); return new BigDecimal(price).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_DOWN); } public static Integer convertFenToYuan(Integer price) { public static double convertFenToYuan(Integer price) { if (price == null) { return null; return 0; } return new BigDecimal(price).divide(new BigDecimal(100)).intValueExact(); return new BigDecimal(price).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_DOWN).doubleValue(); } public static BigDecimal convertFenToYuan(BigDecimal price) { public static double convertFenToYuan(Double price) { if (price == null) { return null; return 0; } return price.divide(new BigDecimal(100)); return new BigDecimal(price).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_DOWN).doubleValue(); } } consum-base/src/main/java/com/consum/base/pojo/excel/OutputExcelTemplate.java
@@ -25,11 +25,12 @@ @Excel(name = "单价") private Integer price; @Excel(name = "金额") private Integer totalAmount; private Double amount; @Excel(name = "备注") private String remark; @ExcelIgnore private Integer totalAmount; @ExcelIgnore private String businessFormCode; @ExcelIgnore consum-base/src/main/java/com/consum/base/pojo/excel/ProcureExcelTemplate.java
@@ -23,15 +23,16 @@ @Excel(name = "数量") private Integer num; @Excel(name = "单价") private Integer price; private Double price; @Excel(name = "金额") private Integer totalAmount; private Double amount; @Excel(name = "存放地点") private String warehouseName; @Excel(name = "备注") private String remark; @ExcelIgnore private Integer totalAmount; @ExcelIgnore private String businessFormCode; @ExcelIgnore consum-base/src/main/java/com/consum/base/pojo/excel/TransferExcelTemplate.java
@@ -23,11 +23,12 @@ @Excel(name = "数量") private Integer num; @Excel(name = "金额") private Integer totalAmount; private double amount; @Excel(name = "备注") private String remark; @ExcelIgnore private Integer totalAmount; @ExcelIgnore private String businessFormCode; @ExcelIgnore consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java
@@ -258,7 +258,7 @@ List<OutputExcelTemplate> list = Lists.newArrayList(); select.forEach(item -> { OutputExcelTemplate templateExcelExport = MapUtils.convertMapToObj(item, OutputExcelTemplate.class); templateExcelExport.setTotalAmount(CurrencyUtil.convertFenToYuan(templateExcelExport.getTotalAmount())); templateExcelExport.setAmount(CurrencyUtil.convertFenToYuan(templateExcelExport.getTotalAmount())); list.add(templateExcelExport); }); return list; consum-base/src/main/java/com/consum/base/service/LWhFormProcureService.java
@@ -149,7 +149,7 @@ List<ProcureExcelTemplate> list = Lists.newArrayList(); select.forEach(item -> { ProcureExcelTemplate templateExcelExport = MapUtils.convertMapToObj(item, ProcureExcelTemplate.class); templateExcelExport.setTotalAmount(CurrencyUtil.convertFenToYuan(templateExcelExport.getTotalAmount())); templateExcelExport.setAmount(CurrencyUtil.convertFenToYuan(templateExcelExport.getTotalAmount())); templateExcelExport.setPrice(CurrencyUtil.convertFenToYuan(templateExcelExport.getPrice())); list.add(templateExcelExport); }); consum-base/src/main/java/com/consum/base/service/impl/LWhFormTransferServiceImpl.java
@@ -443,7 +443,7 @@ } else { templateExcelTransfer.setTenantName(templateExcelTransfer.getInAgencyName()); } templateExcelTransfer.setTotalAmount(CurrencyUtil.convertFenToYuan(templateExcelTransfer.getTotalAmount())); templateExcelTransfer.setAmount(CurrencyUtil.convertFenToYuan(templateExcelTransfer.getTotalAmount())); list.add(templateExcelTransfer); });