SupplierErpService.java
3.18 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
package com.huaheng.pc.config.supplier.service;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.huaheng.common.utils.DateUtils;
import com.huaheng.pc.inventory.inventoryDetail.domain.InventoryDetail;
import com.huaheng.pc.srm.domain.SrmDetail;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.huaheng.framework.aspectj.lang.annotation.Ds;
import com.huaheng.framework.aspectj.lang.constant.DataSourceName;
import com.huaheng.pc.config.supplier.domain.SupplierErp;
import com.huaheng.pc.config.supplier.mapper.SupplierErpMapper;
@Service
public class SupplierErpService extends ServiceImpl<SupplierErpMapper, SupplierErp>{
@Resource
private SupplierErpMapper supplierErpMapper;
SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
/**
* 查找erp数据库的供应商数据
* @return
*/
@Ds(name= DataSourceName.SLAVE)
public List<SupplierErp> findSupplierData(Integer supplierTime){
// LambdaQueryWrapper<SupplierErp> wrapper=new LambdaQueryWrapper<>();
// wrapper.eq(SupplierErp::getPmaa002, 1);
// wrapper.last(" and rownum<20");
// String startTime= DateUtils.getNowPreMin("yyyy-MM-dd HH:mm:ss", 10);
// wrapper.ge(SupplierErp::getPmaamodd,date);
// String startTime= DateUtils.getNowPreDays("yyyy-MM-dd HH:mm:ss", 30);
String startTime= DateUtils.getNowPreMin("yyyy-MM-dd HH:mm:ss", supplierTime);
Date date=null;
try{
date=sf.parse(startTime);
}catch (Exception e){
}
QueryWrapper<SupplierErp> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("交易对象类型", 1);
queryWrapper.ge("最近更改日", date);
queryWrapper.select(" DISTINCT 交易对象编号 as pmaa001, 交易对象类型 AS pmaa002,交易对象简称 AS pmaal, \n" +
"最近更改日 AS pmaamodd");
// queryWrapper.last(" and rownum<20");
List<SupplierErp> lists = this.list(queryWrapper);
return lists;
}
/**
* 查找erp数据库的客户数据
* @return
*/
@Ds(name= DataSourceName.SLAVE)
public List<SupplierErp> findCustomerData(Integer time){
// String startTime= DateUtils.getNowPreDays("yyyy-MM-dd HH:mm:ss", 30);
// time=time*24*14;
String startTime= DateUtils.getNowPreMin("yyyy-MM-dd HH:mm:ss", time);
Date date=null;
try{
date=sf.parse(startTime);
}catch (Exception e){
}
QueryWrapper<SupplierErp> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("交易对象类型", 2);
queryWrapper.ge("最近更改日", date);
queryWrapper.select(" DISTINCT 交易对象编号 as pmaa001, 交易对象类型 AS pmaa002,交易对象简称 AS pmaal, \n" +
"最近更改日 AS pmaamodd");
List<SupplierErp> lists = this.list(queryWrapper);
return lists;
}
}