inspect-server/pom.xml
@@ -52,17 +52,5 @@ <version>0.0.20131108.vaadin1</version> <scope>compile</scope> </dependency> <dependency> <groupId>com.google.zxing</groupId> <artifactId>core</artifactId> <version>3.4.1</version> </dependency> <dependency> <groupId>com.google.zxing</groupId> <artifactId>javase</artifactId> <version>3.4.1</version> </dependency> </dependencies> </project> inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java
@@ -1,12 +1,9 @@ package com.yuanchu.mom.service.impl; import cn.hutool.extra.qrcode.BufferedImageLuminanceSource; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.google.zxing.*; import com.google.zxing.common.HybridBinarizer; import com.yuanchu.mom.mapper.*; import com.yuanchu.mom.pojo.*; import com.yuanchu.mom.pojo.vo.RawInsProductVo; @@ -15,12 +12,7 @@ import org.springframework.beans.BeanUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import javax.imageio.ImageIO; import java.awt.image.BufferedImage; import java.io.File; import java.io.IOException; import java.util.*; import java.util.stream.Collectors; inventory-server/src/main/java/com/yuanchu/mom/service/impl/OrdersServiceImpl.java
@@ -49,9 +49,6 @@ ManualTechnologyMapper manualTechnologyMapper; @Resource SpecificationsMapper specificationsMapper; @Resource TechnologyMapper technologyMapper; inventory-server/src/main/java/com/yuanchu/mom/service/impl/SaleServiceImpl.java
@@ -2,6 +2,7 @@ import cn.hutool.core.date.DateUtil; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.Task.SyncOrder; @@ -23,6 +24,9 @@ import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.time.LocalDateTime; import java.time.LocalTime; import java.time.format.DateTimeFormatter; import java.util.*; import java.util.stream.Collectors; @@ -194,8 +198,12 @@ @Override @Transactional(rollbackFor = Exception.class) public String synchronization() { //当天时间的凌晨4点开始同步 String pattern = "yyyy-MM-dd HH:mm:ss"; DateTimeFormatter formatter = DateTimeFormatter.ofPattern(pattern); String dateTime = LocalDateTime.now().with(LocalTime.of(4, 0, 0)).format(formatter); //获取主销售数据 List<Map<String, Object>> order = SyncOrder.getMainOrder("2023-08-01 10:00:00 "); List<Map<String, Object>> order = SyncOrder.getMainOrder(dateTime); List<Sale> list = order.stream().map(orde -> { Sale sale = new Sale(); sale.setOrderNumber(orde.get("orderNo").toString());//订单编号 @@ -209,9 +217,11 @@ sale.setNote(String.valueOf(orde.get("comment")));//备注 return sale; }).collect(Collectors.toList()); //去重 list.removeIf(sale -> ObjectUtils.isNotEmpty(saleMapper.selectOne(Wrappers.<Sale>query().eq("order_number", sale.getOrderNumber())))); this.saveBatch(list); for (Sale sale : list) { List<Map<String, Object>> innerOrder = SyncOrder.getInnerOrder("2023-08-01 10:00:00", sale.getOrderNumber()); List<Map<String, Object>> innerOrder = SyncOrder.getInnerOrder(dateTime, sale.getOrderNumber()); List<SaleMaterial> saleMaterials = innerOrder.stream().map(inorder -> { SaleMaterial saleMaterial = new SaleMaterial(); saleMaterial.setName(inorder.get("productName").toString()); //产品名称 inventory-server/src/main/resources/mapper/SaleMapper.xml
@@ -43,6 +43,7 @@ specifications, unit, number, note, DATE_FORMAT(s.create_time, '%Y-%m-%d') '下单日期', DATE_FORMAT(delTime, '%Y-%m-%d') '交货日期', sm.type system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
@@ -62,6 +62,6 @@ String pattern = "yyyy-MM-dd HH:mm:ss"; DateTimeFormatter formatter = DateTimeFormatter.ofPattern(pattern); System.out.println(LocalDateTime.now().minusDays(1).with(LocalTime.of(0,0,0)).format(formatter)); System.out.println(LocalDateTime.now().with(LocalTime.of(4, 0, 0)).format(formatter)); } }