| src/main/java/com/ruoyi/sales/dto/SalesLedgerImportDto.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/java/com/ruoyi/sales/dto/SalesLedgerProductImportDto.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/java/com/ruoyi/stock/dto/StockInRecordDto.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/java/com/ruoyi/stock/dto/StockOutRecordDto.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/resources/mapper/stock/StockInRecordMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/resources/mapper/stock/StockOutRecordMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/resources/static/销售台账导入模板.xlsx | 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/ruoyi/sales/dto/SalesLedgerImportDto.java
@@ -43,6 +43,10 @@ @Excel(name = "ç¾è®¢æ¥æ", width = 30, dateFormat = "yyyy-MM-dd") private Date executionDate; @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "äº¤ä»æ¥æ", width = 30, dateFormat = "yyyy-MM-dd") private Date deliveryDate; @Schema(description = "仿¬¾æ¹å¼") @Excel(name = "仿¬¾æ¹å¼") private String paymentMethod; src/main/java/com/ruoyi/sales/dto/SalesLedgerProductImportDto.java
@@ -73,6 +73,9 @@ @Excel(name = "æ¯å¦è´¨æ£", readConverterExp = "0=å¦,1=æ¯") private Boolean isChecked; /** * æ¯å¦ç产 */ @Excel(name = "æ¯å¦ç产", readConverterExp = "0=å¦,1=æ¯") private Integer isProduction; } src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
@@ -285,6 +285,9 @@ * å é¤ç产计å */ public void deleteProductionData(List<Long> productIds) { if (CollectionUtils.isEmpty(productIds)) { return; } List<ProductionPlan> productionPlans = productionPlanMapper.selectList( new LambdaQueryWrapper<ProductionPlan>() .in(ProductionPlan::getSalesLedgerProductId, productIds.stream().map(Long::intValue).collect(Collectors.toList()))); src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
@@ -370,6 +370,7 @@ SalesLedger salesLedger = new SalesLedger(); BeanUtils.copyProperties(salesLedgerImportDto, salesLedger); salesLedger.setExecutionDate(DateUtils.toLocalDate(salesLedgerImportDto.getExecutionDate())); salesLedger.setDeliveryDate(DateUtils.toLocalDate(salesLedgerImportDto.getDeliveryDate())); // éè¿å®¢æ·åç§°æ¥è¯¢å®¢æ·IDï¼å®¢æ·ååå· salesLedger.setCustomerId(customers.stream() .filter(customer -> customer.getCustomerName().equals(salesLedger.getCustomerName())) @@ -411,7 +412,7 @@ salesLedgerProduct.setNoInvoiceNum(salesLedgerProduct.getQuantity()); salesLedgerProduct.setNoInvoiceAmount(salesLedgerProduct.getTaxExclusiveTotalPrice()); list.stream() .filter(map -> map.get("productName").equals(salesLedgerProduct.getProductCategory()) && map.get("model").equals(salesLedgerProduct.getSpecificationModel())) .filter(map -> Objects.equals(map.get("productName"), salesLedgerProduct.getProductCategory()) && Objects.equals(map.get("model"), salesLedgerProduct.getSpecificationModel())) .findFirst() .ifPresent(map -> { salesLedgerProduct.setProductModelId(Long.parseLong(map.get("modelId").toString())); @@ -431,6 +432,7 @@ salesLedgerProduct.setRegisterDate(LocalDateTime.now()); salesLedgerProduct.setApproveStatus(0); salesLedgerProduct.setPendingInvoiceTotal(salesLedgerProductImportDto.getTaxInclusiveTotalPrice()); salesLedgerProduct.setIsProduction(salesLedgerProductImportDto.getIsProduction() == 1); salesLedgerProductMapper.insert(salesLedgerProduct); // æ·»å çäº§æ°æ® salesLedgerProductServiceImpl.addProductionData(salesLedgerProduct); @@ -440,8 +442,8 @@ return AjaxResult.success("å¯¼å ¥æå"); } catch (Exception e) { e.printStackTrace(); return AjaxResult.error("å¯¼å ¥å¤±è´¥ï¼" + e.getMessage()); } return AjaxResult.success("å¯¼å ¥å¤±è´¥"); } @Override src/main/java/com/ruoyi/stock/dto/StockInRecordDto.java
@@ -18,6 +18,11 @@ */ private String model; /** * æ¹æ¬¡å· */ private String batchNo; /** * 产ååä½ */ private String unit; src/main/java/com/ruoyi/stock/dto/StockOutRecordDto.java
@@ -21,6 +21,10 @@ */ private String model; /** * æ¹æ¬¡å· */ private String batchNo; /** * 产ååä½ */ private String unit; src/main/resources/mapper/stock/StockInRecordMapper.xml
@@ -31,6 +31,12 @@ <if test="params.productName != null and params.productName != ''"> and p.product_name like concat('%',#{params.productName},'%') </if> <if test="params.model != null and params.model != ''"> and pm.model like concat('%',#{params.model},'%') </if> <if test="params.batchNo != null and params.batchNo != ''"> and sir.batch_no like concat('%',#{params.batchNo},'%') </if> <if test="params.type != null and params.type != ''"> and sir.type = #{params.type} </if> src/main/resources/mapper/stock/StockOutRecordMapper.xml
@@ -46,6 +46,12 @@ <if test="params.productName != null and params.productName != ''"> and p.product_name like concat('%',#{params.productName},'%') </if> <if test="params.model != null and params.model != ''"> and pm.model like concat('%',#{params.model},'%') </if> <if test="params.batchNo != null and params.batchNo != ''"> and sor.batch_no like concat('%',#{params.batchNo},'%') </if> <if test="params.type != null and params.type != ''"> and sor.type = #{params.type} </if> src/main/resources/static/ÏúÊŲ̂Õ˵¼ÈëÄ£°å.xlsxBinary files differ