excel导出优化

zhangchao

2024-11-04 59f80df1e377e8775969ca4acadfa2eadd6e37ae

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
package com.zy.asrs.service.impl;
 
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.entity.AgvWaitPakin;
import com.zy.asrs.entity.AgvWrkMast;
import com.zy.asrs.mapper.AgvWaitPakinMapper;
import com.zy.asrs.service.AgvWaitPakinService;
import com.zy.asrs.service.AgvWrkMastService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class AgvWaitPakinServiceImpl extends ServiceImpl<AgvWaitPakinMapper, AgvWaitPakin> implements AgvWaitPakinService {
 
    @Autowired
    AgvWrkMastService agvWrkMastService;
 
    public void updateIoStatus(int wrkNo, String ioStatus) {
        AgvWrkMast agvWrkMast = agvWrkMastService.selectById(wrkNo);
        List<AgvWaitPakin> agvWaitPakinList = this.selectList(new EntityWrapper<AgvWaitPakin>().eq("zpallet", agvWrkMast.getBarcode()));
        agvWaitPakinList.stream().forEach(agvWaitPakin -> {
            agvWaitPakin.setIoStatus("Y");
            this.update(agvWaitPakin,new EntityWrapper<AgvWaitPakin>().eq("supp_code",agvWaitPakin.getZpallet()));
        });
    }
 
    @Override
    public void updateIoStatus(String containerCode, String ioStatus) {
        this.baseMapper.updateIoStatus(containerCode,ioStatus);
    }
 
    @Override
    public List<AgvWaitPakin> selectByContainerCode(String containerCode) {
        return this.selectList(new EntityWrapper<AgvWaitPakin>().eq("supp_code",containerCode).eq("io_status","N"));
    }
 
    @Override
    public List<AgvWaitPakin> selectByContainerCode2(String containerCode) {
        return this.selectList(new EntityWrapper<AgvWaitPakin>().eq("supp_code",containerCode));
    }
}