| | |
| | | package com.yuanchu.mom; |
| | | |
| | | import com.yuanchu.mom.mapper.ManualTechnologyMapper; |
| | | import com.yuanchu.mom.pojo.ManualTechnology; |
| | | import cn.hutool.core.date.DateTime; |
| | | import cn.hutool.core.date.DateUtil; |
| | | import com.yuanchu.mom.Task.SyncOrder; |
| | | import com.yuanchu.mom.pojo.RawInspect; |
| | | import com.yuanchu.mom.pojo.Sale; |
| | | import com.yuanchu.mom.pojo.SaleMaterial; |
| | | import org.junit.jupiter.api.Test; |
| | | import org.springframework.boot.test.context.SpringBootTest; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | @SpringBootTest |
| | | class SystemRunApplicationTest { |
| | | |
| | | @Resource |
| | | private ManualTechnologyMapper manualTechnologyMapper; |
| | | @Test |
| | | void contextLoads() { |
| | | ManualTechnology manualTechnology = new ManualTechnology() |
| | | .setTechname("tets") |
| | | .setTechfather("test") |
| | | .setDeviceGroup("grop") |
| | | .setDeviceId(1) |
| | | .setTechnologyId(2) |
| | | .setManufactureOrderId(1) |
| | | .setSchedulingNumber(12); |
| | | manualTechnologyMapper.insert(manualTechnology); |
| | | List<Map<String, Object>> order = SyncOrder.getMainOrder("2023-08-01 10:00:00 "); |
| | | List<Sale> list = order.stream().map(orde -> { |
| | | Sale sale = new Sale(); |
| | | sale.setOrderNumber(orde.get("orderNo").toString());//订单编号 |
| | | sale.setCode(String.valueOf(orde.get("customerContractNumber")));//客户合同编号 |
| | | sale.setName(orde.get("projectName").toString());//工程名称 |
| | | sale.setProname(orde.get("customerName").toString());//客户名称 |
| | | sale.setOrderName(orde.get("createdName").toString());//下单人 |
| | | sale.setSaleman(orde.get("salesmanName").toString());//业务员 |
| | | sale.setDelTime(DateUtil.parseDate(orde.get("wantedDeliveryDate").toString()));//交货日期 |
| | | sale.setCreateTime(DateUtil.parseDate(orde.get("orderDate").toString()));//下单日期 |
| | | sale.setNote(String.valueOf(orde.get("comment")));//备注 |
| | | return sale; |
| | | }).collect(Collectors.toList()); |
| | | //System.out.println(list); |
| | | for (Sale sale : list) { |
| | | List<Map<String, Object>> innerOrder = SyncOrder.getInnerOrder("2023-08-01 10:00:00", sale.getOrderNumber()); |
| | | List<SaleMaterial> saleMaterials = innerOrder.stream().map(inorder -> { |
| | | SaleMaterial saleMaterial = new SaleMaterial(); |
| | | saleMaterial.setName(inorder.get("productName").toString()); //产品名称 |
| | | saleMaterial.setSpecifications(inorder.get("specificationModel").toString()); //产品规格型号 |
| | | saleMaterial.setUnit(inorder.get("unit").toString()); //单位 |
| | | saleMaterial.setNumber((int) Double.parseDouble(inorder.get("quantity").toString())); //数量 |
| | | saleMaterial.setPrice(inorder.get("unitPriceInclTax").toString()); //单价 |
| | | saleMaterial.setSaleId(sale.getId()); //关联 销售单id |
| | | saleMaterial.setAdress(String.valueOf(inorder.get("shippingAddress"))); //收货地址 |
| | | saleMaterial.setUsername(String.valueOf(inorder.get("receivingContact"))); //联系人 |
| | | saleMaterial.setPhone(String.valueOf(inorder.get("receivingContactPhone"))); //手机号 |
| | | return saleMaterial; |
| | | }).collect(Collectors.toList()); |
| | | System.out.println(saleMaterials); |
| | | } |
| | | } |
| | | |
| | | @Test |
| | | void aaa() { |
| | | int orderId = 773699; |
| | | List<Map<String, Object>> attachment = SyncOrder.getAttachmentByOrderId(orderId); |
| | | List<String> list = new ArrayList<>(); |
| | | for (Map<String, Object> attch : attachment) { |
| | | String path = attch.get("path").toString(); |
| | | list.add(path); |
| | | } |
| | | System.out.println(list); |
| | | } |
| | | |
| | | @Test |
| | | void bb() { |
| | | List<Map<String, Object>> mapList = SyncOrder.ifsInterfaces(); |
| | | List<RawInspect> rawInspectList = mapList.stream().map(map -> { |
| | | RawInspect rawInspect = new RawInspect(); |
| | | if (map.get("PART_NO").toString().equals("A0410008010700")) { |
| | | rawInspect.setCode(map.get("PART_NO").toString()); //原材料编码 |
| | | String[] split = map.get("PART_DESC").toString().split(","); |
| | | rawInspect.setName(split[0]); //原材料名称 |
| | | rawInspect.setSpecifications(split[1]); //型号规格 |
| | | rawInspect.setUnit(map.get("BUY_UNIT_MEAS").toString()); //单位 |
| | | rawInspect.setNumber(Integer.parseInt(String.valueOf(map.get("QTY_TO_INSPECT")))); //数量 |
| | | rawInspect.setInsState(0); //未检验 |
| | | rawInspect.setFormTime(DateUtil.parse(map.get("APPROVED_DATE").toString())); //来料日期 |
| | | rawInspect.setSupplier(map.get("SUPPLIER_NAME").toString()); //供应商 |
| | | } |
| | | return rawInspect; |
| | | }).collect(Collectors.toList()); |
| | | System.out.println(rawInspectList); |
| | | } |
| | | |
| | | } |