新增导出功能

mrzhssss

2022-05-06 e67503fd8cc820ff14fa3398a9a7e072d4964444

 src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java

@@ -13,9 +13,11 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import zy.cloud.wms.common.entity.Parameter;
import zy.cloud.wms.common.service.erp.entity.*;
import zy.cloud.wms.common.utils.VersionUtils;
import zy.cloud.wms.manager.entity.*;
import zy.cloud.wms.manager.mapper.MatCodeMapper;
import zy.cloud.wms.manager.mapper.TagMapper;
import zy.cloud.wms.manager.service.*;
import zy.cloud.wms.manager.utils.HttpHandler;
@@ -34,11 +36,12 @@
@RestController
public class ErpScheduler {

    public static final String URI = "http://8.133.182.21:6220/api";
    public static final String URI = "http://123.60.34.127:6220/api";
    public static final String GET_ORDERS = "cM/basis/getOrders";
    public static final String GET_BASIS = "cM/basis/getBasis";
    public static final String UPLOAD_BILL = "cM/basis/uploadBill";
    public static final String UPLOAD_STOCK = "cM/basis/uploadStock";
    public static final String GET_STOCK = "cM/ptype/GetStock";
    public static final String OVER_BILL = "cM/basis/OverBill";
    public static final String UPLOAD_CANCEL_RESULT = "cM/basis/cancelOrders";

@@ -58,6 +61,17 @@
    private OrderDetlService orderDetlService;
    @Autowired
    private SnowflakeIdWorker snowflakeIdWorker;
    @Autowired
    private PakoutService pakoutService;
    @Autowired
    private NodeService nodeService;
    @Autowired
    private DocLogService docLogService;
    @Autowired
    private RequestLogService requestLogService;
    @Autowired
    private MatCodeMapper matCodeMapper;


    /**
     * 商品下载
@@ -161,6 +175,7 @@
                    }

                    if (null == mat) {
                        // 平仓
                        mat = new Mat(
                                String.valueOf(data.getRec()),    // 编号
                                null,    // 所属区域
@@ -186,8 +201,12 @@
                                updateTime,    // 修改时间
                                null    // 备注
                        );

                        matService.insert(mat);
                        // 立库

                    } else {
                        // 平仓
                        mat.setUuid(String.valueOf(data.getRec()));
                        mat.setMatnr(data.getUserCode());
                        mat.setMaktx(data.getFullName());
@@ -196,6 +215,8 @@
                        mat.setBarcode(data.getBarcode());
                        mat.setUnit(data.getUnit3());
                        matService.updateById(mat);
                        // 立库

                    }
                    log.info("====>> 更新物料：{}", data.getUserCode());
                }
@@ -210,7 +231,7 @@
    /**
     * 商品下载
     */
    @Scheduled(cron = "0/5 * * * * ? ")
    @Scheduled(cron = "0 */2 * * * ? ")
    public void updateMatExecute(){
        try {
            Map<String, Object> param = new HashMap<>();
@@ -222,7 +243,8 @@
                    .build()
                    .doPost();
            if (!Cools.isEmpty(response)) {
//                log.info(response);
                log.info("商品数据更新：");
                log.info(response);
                Date now = new Date();
                Result result = JSON.parseObject(response, Result.class);
                if (result.getCode() != 1) {
@@ -331,7 +353,11 @@
                                updateTime,    // 修改时间
                                null    // 备注
                        );
                        matService.insert(mat);
                        if (matService.insert(mat)) {
                            MatCode matCode = mat.beMatCode();
                            matCodeMapper.insert(matCode);
                        }

                    } else {
                        mat.setUuid(String.valueOf(data.getRec()));
                        mat.setMatnr(data.getUserCode());
@@ -340,7 +366,10 @@
                        mat.setUpdateTime(updateTime);
                        mat.setBarcode(data.getBarcode());
                        mat.setUnit(data.getUnit3());
                        matService.updateById(mat);
                        if (matService.updateById(mat)) {
                            MatCode matCode = mat.beMatCode();
                            matCodeMapper.updateById(matCode);
                        }
                    }
                    log.info("====>> 更新物料：{}", data.getUserCode());
                }
@@ -418,7 +447,7 @@
    /**
     * 持久化销售订单
     */
    @Scheduled(cron = "0/5 * * * * ? ")
    @Scheduled(cron = "0 */1 * * * ?")
    @Transactional
//    @PostConstruct
    public void getOrdersExecute(){
@@ -539,6 +568,7 @@
//    @PostConstruct
    public void finishOrdersExecute(){
        try {
            Date now = new Date();
            List<Order> orders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 4).isNotNull("number"));
            if (!Cools.isEmpty(orders)) {
                List<String> orderNos = orders.stream().map(Order::getOrderNo).distinct().collect(Collectors.toList());
@@ -547,10 +577,12 @@
                    List<GetOrderResultDetl0> list = new ArrayList<>();
                    getOrderResult0.setDetail(list);

                    // 日志
                    List<DocLog> docLogs = new ArrayList<>();

                    // 头
                    getOrderResult0.setNumber(order.getOrderNo());
                    getOrderResult0.setVchType(11); // todo:luxiaotao
                    getOrderResult0.setVchType(11);
                    getOrderResult0.setBillDate(order.getOrderTime());
                    getOrderResult0.setBTypeID(order.getTel());
                    getOrderResult0.setKTypeID("宏挺仓库");
@@ -568,10 +600,21 @@
                        detl0.setUnit(orderDetl.getUnit());
                        detl0.setRowNo(Integer.parseInt(orderDetl.getName()));
                        list.add(detl0);

                        // 日志
                        docLogs.add(new DocLog(
                                order.getOrderNo(),    // 单据编号
                                11L,    // 单据类型
                                "销售订单",    // 单据名称
                                orderDetl.getMatnr(),    // 商品编号
                                orderDetl.getCount(),    // 上报数量
                                1,    // 结果
                                now,    // 上报时间
                                null    // 备注
                        ));
                    }

                    System.out.println(JSON.toJSONString(getOrderResult0));

                    log.warn(JSON.toJSONString(getOrderResult0));

                    String response = new HttpHandler.Builder()
                            .setUri(URI)
@@ -579,23 +622,33 @@
                            .setJson(JSON.toJSONString(getOrderResult0))
                            .build()
                            .doPost();

                    try {
                        for (DocLog docLog : docLogs) {
                            docLogService.insert(docLog);
                        }

                        RequestLog logInfo = new RequestLog();
                        logInfo.setName("单据上传，单据类型" + 11);
                        logInfo.setRequest(JSON.toJSONString(getOrderResult0)); // 入参
                        logInfo.setResponse(response); // 出参
                        logInfo.setCreateTime(new Date());
                        requestLogService.insert(logInfo);

                    } catch (Exception e) {
                        log.error(e.getMessage());
                    }

                    if (!Cools.isEmpty(response)) {
                        log.warn(response);
                        Result result = JSON.parseObject(response, Result.class);
                        if (result.getCode() != 1) {
                        if (result.getCode() != 1 && !result.getMsg().equals("单据已经审核完成或删除，不能审核。")) {
                            continue;
                        }
                        if (!orderService.updateSettle(order.getOrderNo(), 6L)) {
                            throw new CoolException("修改订单状态失败");
                        }
//                        // 转历史档
//                        int save = custOrderMapper.saveLog(getOrderResult0.getNumber());
//                        if (save > 0) {
//                            if (custOrderMapper.delete(new EntityWrapper<CustOrder>().eq("number", getOrderResult0.getNumber())) == 0) {
//                                throw new CoolException("删除销售订单失败");
//                            }
//                            log.info("{}销售订单拣货结束", getOrderResult0.getNumber());
//                        }

                    }

                }
@@ -617,6 +670,7 @@
//    @PostConstruct
    public void finishOrders0Execute(){
        try {
            Date now = new Date();
            List<Order> orders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 4).eq("doc_type", 6));
            if (!Cools.isEmpty(orders)) {
                List<String> orderNos = orders.stream().map(Order::getOrderNo).distinct().collect(Collectors.toList());
@@ -625,10 +679,12 @@
                    List<GetOrderResultDetl0> list = new ArrayList<>();
                    getOrderResult0.setDetail(list);

                    // 日志
                    List<DocLog> docLogs = new ArrayList<>();

                    // 头
                    getOrderResult0.setNumber(order.getOrderNo());
                    getOrderResult0.setVchType(6); // todo:luxiaotao
                    getOrderResult0.setVchType(6);
                    getOrderResult0.setBillDate(order.getOrderTime());
                    getOrderResult0.setBTypeID(order.getTel());
                    getOrderResult0.setKTypeID("宏挺仓库");
@@ -647,10 +703,21 @@
                        detl0.setUnit(orderDetl.getUnit());
                        detl0.setComment(orderDetl.getMemo());
                        list.add(detl0);

                        // 日志
                        docLogs.add(new DocLog(
                                order.getOrderNo(),    // 单据编号
                                6L,    // 单据类型
                                "采购退货订单",    // 单据名称
                                orderDetl.getMatnr(),    // 商品编号
                                orderDetl.getCount(),    // 上报数量
                                1,    // 结果
                                now,    // 上报时间
                                null    // 备注
                        ));
                    }

                    System.out.println(JSON.toJSONString(getOrderResult0));


                    String response = new HttpHandler.Builder()
                            .setUri(URI)
@@ -658,6 +725,22 @@
                            .setJson(JSON.toJSONString(getOrderResult0))
                            .build()
                            .doPost();

                    try {
                        for (DocLog docLog : docLogs) {
                            docLogService.insert(docLog);
                        }

                        RequestLog logInfo = new RequestLog();
                        logInfo.setName("单据上传，单据类型" + 6);
                        logInfo.setRequest(JSON.toJSONString(getOrderResult0)); // 入参
                        logInfo.setResponse(response); // 出参
                        logInfo.setCreateTime(new Date());
                        requestLogService.insert(logInfo);
                    } catch (Exception e) {
                        log.error(e.getMessage());
                    }

                    if (!Cools.isEmpty(response)) {
                        log.warn(response);
                        Result result = JSON.parseObject(response, Result.class);
@@ -772,8 +855,42 @@
                        Order order = orderService.selectByOrderNo(number);
                        if (order != null) {
                            if (order.getSettle() != 3L && order.getSettle() != 5L) {
                                if (!orderService.updateSettle(number, 5L)) {
//                            throw new CoolException("修改订单状态失败");
                                if (orderService.updateSettle(number, 5L)) {
                                    // 立库出库货位转至A99
                                    List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>()
                                            .eq("node_id", -1).eq("doc_num", number).ne("memo", "1"));
                                    Node node = nodeService.selectByUuid(Parameter.get().getUniNode());
                                    for (Pakout pakout : pakouts) {
                                        // 立库出库货位
                                        if (pakout.getLocNo().length() == 7) {
                                            LocDetl locDetl = locDetlService.getLocDetl(node.getId(), pakout.getMatnr());
                                            if (locDetl == null) {
                                                locDetl = new LocDetl();
                                                locDetl.setLocNo(node.getName());
                                                locDetl.setNodeId(node.getId());
                                                locDetl.setAnfme(pakout.getAnfme());
                                                VersionUtils.setLocDetl(locDetl, pakout);
                                                locDetl.setStatus(1);
                                                locDetl.setCreateBy(9527L);
                                                locDetl.setCreateTime(now);
                                                locDetl.setUpdateBy(9527L);
                                                locDetl.setUpdateTime(now);
                                                boolean insert = locDetlService.insert(locDetl);
                                                if (!insert) {
                                                    throw new CoolException("新增库存明细档失败");
                                                }
                                            } else {
                                                if (!locDetlService.incrementStock(node.getId(), pakout.getMatnr(), pakout.getAnfme())) {
                                                    throw new CoolException("新增库存明细档失败");
                                                }
                                            }
                                            if (!pakoutService.updateStep(pakout.getWrkNo(), pakout.getDocNum())) {
                                                throw new CoolException("取消订单后回滚立库拣货单失败");
                                            }
                                        }
                                    }
                                } else {
//                                    throw new CoolException("修改订单状态失败");
                                }
                            }
                        }