自动化立体仓库 - WMS系统
1
zhang
3 天以前 5dff87c18f48e0a14440d1225924d35f8de7b00e
src/main/java/com/zy/asrs/controller/OrderDetlController.java
@@ -17,6 +17,7 @@
import com.zy.asrs.mapper.AgvWrkDetlMapper;
import com.zy.asrs.service.*;
import com.zy.common.web.BaseController;
import com.zy.system.service.ConfigService;
import lombok.Synchronized;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@@ -44,6 +45,8 @@
    @Autowired
    private AgvWrkDetlMapper agvWrkDetlMapper;
    @Autowired
    private ConfigService configService;
    @RequestMapping(value = "/orderDetl/{id}/auth")
    @ManagerAuth
@@ -216,13 +219,24 @@
                        docIds.add(pakin.getDocId());
                    }
                }
                wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", docIds);
                wrapper.in("source", docIds);
                List<String> m = configService.getMatCode();
                if (!Cools.isEmpty(m)) {
                    for (int i = 0; i < m.size(); i++) {
                        if (i == 0) {
                            wrapper.andNew().like("matnr", m.get(i), SqlLike.RIGHT);
                        } else {
                            wrapper.or().like("matnr", m.get(i), SqlLike.RIGHT);
                        }
                    }
                }
                flag = true;
            } else {
                wrapper.in("source", split);
            }
            param.remove("orderType");
        }
        wrapper.andNew();
        convertLike(param, wrapper);
        if (!Cools.isEmpty(orderByField)) {
            wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));
@@ -359,6 +373,41 @@
        return R.ok(page);
    }
    @RequestMapping(value = "/orderDetl/pakout/list/authV9")
    @ManagerAuth
    public R pakoutList9(@RequestParam(defaultValue = "1") Integer curr,
                         @RequestParam(defaultValue = "10") Integer limit,
                         @RequestParam(required = false) String orderByField,
                         @RequestParam(required = false) String orderByType,
                         @RequestParam Map<String, Object> param) {
        EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
        excludeTrash(param);
        convertLike(param, wrapper);
        if (!Cools.isEmpty(orderByField)) {
            wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));
        } else {
            wrapper.orderBy("create_time", false);
        }
        List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1));
        List<Long> docIds = new ArrayList<>();
        for (DocType pakin : pakins) {
            if (pakin.getDocId() == 48) {
                docIds.add(pakin.getDocId());
            }
        }
        wrapper.in("source", docIds);
        Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper);
        for (OrderDetl record : page.getRecords()) {
            Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed2(record.getMatnr(), record.getThreeCode());
            record.setStock(sumAnfme == null ? 0 : sumAnfme);
            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
            //record.setWorkNum(workNum == null ? 0 : workNum);
        }
        return R.ok(page);
    }
    @RequestMapping(value = "/orderDetl/pakout/list/authV6")
    @ManagerAuth
    public R pakoutList6(@RequestParam(defaultValue = "1") Integer curr,
@@ -396,13 +445,8 @@
    @RequestMapping(value = "/orderDetl/pakout/workNum")
    @ManagerAuth
    public R listWorkDetl(@RequestParam OrderDetl param) {
        List<AgvWrkDetl> agvWrkDetls = agvWrkDetlMapper.listAnfmeByMatnr(param.getMatnr(), param.getThreeCode(), param.getOrderNo());
        if (agvWrkDetls != null) {
            for (AgvWrkDetl agvWrkDetl : agvWrkDetls) {
            }
        }
    public R listWorkDetl() {
        List<AgvWrkDetl> agvWrkDetls = agvWrkDetlMapper.listAnfmeByMatnr();
        return R.ok(agvWrkDetls);
    }