UserSyncService.java
2.9 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.system.user.service;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.annotation.Resource;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.huaheng.pc.system.user.domain.User;
import com.huaheng.pc.system.user.domain.UserErp;
import com.huaheng.pc.system.user.mapper.UserSyncMapper;
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.common.utils.StringUtils;
import com.huaheng.pc.config.address.service.AddressService;
/**
* 定时任务同步erp的供应商、客户
*/
@Service
public class UserSyncService extends ServiceImpl<UserSyncMapper, User>{
@Resource
private IUserService userService;
@Resource
private UserErpService userErpService;
@Resource
private AddressService addressService;
/**
* 获取erp物料数据，同步到wms数据库
*/
public void syncUserData(){
List<UserErp> list=userErpService.findUserErpData();
System.out.println("=======用户======="+new Date()+"==========="+list.size());
saveAndUpdateData(list);
}
@Transactional(propagation = Propagation.REQUIRES_NEW)
public void saveAndUpdateData(List<UserErp> list){
if(list==null||list.size()==0){
return ;
}
List<User> lists=new ArrayList<>();
for (int a=0;a<list.size();a++){
UserErp userErp=list.get(a);
String code=userErp.getUsercode();
if(StringUtils.isEmpty(code)){
continue;
}
//查找数据库有无该供应商，有则跳过，无则新增
LambdaQueryWrapper<User> wrapper=new LambdaQueryWrapper<>();
wrapper.eq(User::getLoginName,code);
wrapper.last("limit 1");
User user1=this.getOne(wrapper);
if(user1!=null){
continue;
}
User user=new User();
user.setLoginName(code);
user.setUserName(userErp.getUsername());
if(StringUtils.isEmpty(userErp.getSitecode())){
continue;
}
if(userErp.getSitecode().equals("CS")){
user.setWarehouseCode("CS0001");
}else if(userErp.getSitecode().equals("XZ")){
user.setWarehouseCode("XZ0001");
}else{
user.setWarehouseCode("KS0001");
}
user.setCreateBy("erp");
user.setCreateTime(new Date());
user.setUpdateTime(new Date());
lists.add(user);
}
if(lists!=null&&lists.size()>0){
this.saveBatch(lists);
}
}
}