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
package cn.kk.spring_simple_operation;
import cn.kk.spring_simple_operation.mapper.SyncProductAuditMapper;
import cn.kk.spring_simple_operation.mapper.SyncProductPublishMapper;
import cn.kk.spring_simple_operation.mapper.VideoProductMapper;
import cn.kk.spring_simple_operation.model.PlanSkuInfoVO;
import cn.kk.spring_simple_operation.model.SkuVideoVO;
import cn.kk.spring_simple_operation.utils.ExcelUtil;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.util.CollectionUtils;
import javax.annotation.Resource;
import java.util.LinkedList;
import java.util.List;
import java.util.concurrent.atomic.AtomicInteger;
@SpringBootTest
class SimpleAPlusTaskExport {
@Resource
private SyncProductPublishMapper syncProductPublishMapper;
@Resource
private VideoProductMapper videoProductMapper;
@Resource
private SyncProductAuditMapper syncProductAuditMapper;
@Test
void contextLoads() {
}
@Test
void groupSkuSolarTerm_1() {
List<String> motherList = syncProductAuditMapper.planSkuForPublish();
List<String> skuList = new LinkedList<>();
AtomicInteger count = new AtomicInteger(0);
motherList.forEach(sku -> {
if (StringUtils.isEmpty(sku)) {
return;
}
List<SkuVideoVO> skuVideoVOS = syncProductPublishMapper.planSkuForPublishSales(sku);
if (CollectionUtils.isEmpty(skuVideoVOS)) {
return;
}
Integer sum = skuVideoVOS.stream().map(SkuVideoVO::getThirtyDaySales).reduce(Integer::sum).orElse(0);
if (sum >= 100 && sum <= 200) {
//System.out.println(count.incrementAndGet() + "---" + sku + " 销量在100-200之间: " + sum);
skuList.add(sku);
}
});
if (!CollectionUtils.isEmpty(skuList)) {
String originName = "简版A+";
List<PlanSkuInfoVO> list = syncProductAuditMapper.listPlanSkuInfo(skuList);
ExcelUtil<PlanSkuInfoVO> util = new ExcelUtil<>(PlanSkuInfoVO.class);
util.exportExcelFile(list, originName);
}
}
}