MaterialSyncService.java
3.47 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
package com.huaheng.pc.config.material.service;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.annotation.Resource;
import com.huaheng.common.constant.QuantityConstant;
import com.huaheng.common.utils.StringUtils;
import com.huaheng.pc.config.address.domain.Address;
import com.huaheng.pc.config.address.service.AddressService;
import com.huaheng.pc.config.material.domain.Material;
import com.huaheng.pc.config.material.domain.MaterialErp;
import com.huaheng.pc.config.material.mapper.MaterialMapper;
import com.huaheng.pc.config.supplier.service.SupplierSyncService;
import com.huaheng.pc.config.syncTime.domain.SyncTime;
import com.huaheng.pc.config.syncTime.service.SyncTimeService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.huaheng.pc.config.customer.domain.Customer;
import com.huaheng.pc.config.supplier.domain.Supplier;
import com.huaheng.pc.config.supplier.domain.SupplierErp;
/**
* 定时任务同步erp的供应商、客户
*/
@Service
public class MaterialSyncService extends ServiceImpl<MaterialMapper, Material>{
@Resource
private MaterialService materialService;
@Resource
private MaterialErpService materialErpService;
@Resource
private SyncTimeService syncTimeService;
@Resource
private AddressService addressService;
@Resource
private SupplierSyncService supplierSyncService;
/**
* 获取erp物料数据，同步到wms数据库
*/
public void syncMaterialData(Integer materialTime){
String syncName="material";
Date date=new Date();
Boolean tag=syncTimeService.isSync(syncName,materialTime);
if(!tag){
return;
}
SyncTime syncTime=supplierSyncService.getTimeByName(syncName);
Address address=addressService.selectAddressByParam("ERP", QuantityConstant.WAREHOUSE_CS);
List<MaterialErp> list=materialErpService.findMaterialData(materialTime,address,syncTime.getSyncTimes());
System.out.println("=======物料======="+new Date()+"==========="+list.size());
saveAndUpdateData(list);
syncTimeService.updateStatus("material",1,date);
}
@Transactional(propagation = Propagation.REQUIRES_NEW)
public void saveAndUpdateData(List<MaterialErp> list){
if(list==null||list.size()==0){
return ;
}
List<Material> lists=new ArrayList<>();
for (int a=0;a<list.size();a++){
MaterialErp materialErp=list.get(a);
Material material=new Material();
String code=materialErp.getImaa001();
//查找数据库有无该供应商，有则跳过，无则新增
Material material1 = materialService.getMaterialByCode(code);
if(material1!=null){
continue;
}
material.setCode(code);
material.setName(materialErp.getImaal003());
if(StringUtils.isEmpty(materialErp.getImaal003())){
material.setName(code);
}
material.setSpec(materialErp.getImaal004());
material.setUnit(materialErp.getImaa006());
material.setType(materialErp.getImaa004());
lists.add(material);
}
if(lists!=null&&lists.size()>0){
materialService.saveBatch(lists);
}
}
}