| | |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.*; |
| | | |
| | | /** |
| | |
| | | private ProductMapper productMapper; |
| | | @Autowired |
| | | private ProductModelMapper productModelMapper; |
| | | private static final DateTimeFormatter YYYYMMDD_FORMAT = DateTimeFormatter.ofPattern("yyyyMMdd"); |
| | | |
| | | |
| | | @Override |
| | |
| | | newStockInventory.setWarnNum(stockInventoryDto.getWarnNum()); |
| | | newStockInventory.setBatchNo(stockInventoryDto.getBatchNo()); |
| | | newStockInventory.setCustomer(stockInventoryDto.getCustomer()); |
| | | newStockInventory.setProductionDate(stockInventoryDto.getProductionDate()); |
| | | stockInventoryMapper.insert(newStockInventory); |
| | | }else { |
| | | stockInventoryMapper.updateAddStockInventory(stockInventoryDto); |
| | |
| | | // 查询所有的产品 |
| | | List<SalesLedgerProduct> salesLedgerProducts = salesLedgerProductMapper.selectProduct(); |
| | | |
| | | ExcelUtil<StockInventoryExportData> util = new ExcelUtil<StockInventoryExportData>(StockInventoryExportData.class); |
| | | ExcelUtil<StockInventoryExportData> util = new ExcelUtil<>(StockInventoryExportData.class); |
| | | List<StockInventoryExportData> list = util.importExcel(file.getInputStream()); |
| | | |
| | | // 记录未找到匹配项的数据 |
| | |
| | | boolean matched = false; |
| | | for (SalesLedgerProduct item : salesLedgerProducts) { |
| | | if (item.getProductCategory().equals(dto.getProductName()) && |
| | | item.getSpecificationModel().equals(dto.getModel())) { |
| | | item.getSpecificationModel().equals(dto.getModel()) && |
| | | item.getUidNo().equals(dto.getUidNo())) { |
| | | StockInventoryDto stockInventoryDto = new StockInventoryDto(); |
| | | stockInventoryDto.setRecordId(0L); |
| | | stockInventoryDto.setRecordType(StockInQualifiedRecordTypeEnum.CUSTOMIZATION_STOCK_IN.getCode()); |
| | |
| | | } |
| | | stockInventoryDto.setLockedQuantity(dto.getLockedQuantity()); |
| | | stockInventoryDto.setProductModelId(item.getProductModelId()); |
| | | stockInventoryDto.setBatchNo(dto.getBatchNo()); |
| | | stockInventoryDto.setCustomer(dto.getCustomer()); |
| | | String productionDate = dto.getProductionDate(); |
| | | if (productionDate != null && productionDate.length() == 8) { |
| | | stockInventoryDto.setProductionDate(LocalDate.parse(productionDate, YYYYMMDD_FORMAT)); |
| | | } else { |
| | | stockInventoryDto.setProductionDate(null); |
| | | } |
| | | this.addstockInventory(stockInventoryDto); |
| | | matched = true; |
| | | break; // 找到匹配项后跳出循环 |
| | |
| | | } |
| | | if (!matched) { |
| | | // 记录未匹配的数据 |
| | | String unmatchedInfo = String.format("产品名称:%s,规格型号:%s", |
| | | dto.getProductName(), dto.getModel()); |
| | | String unmatchedInfo = String.format("产品名称:%s,规格型号:%s,UID码:%s", |
| | | dto.getProductName(), dto.getModel(),dto.getUidNo()); |
| | | unmatchedRecords.add(unmatchedInfo); |
| | | } |
| | | }); |