库存更新修改

zyx

2023-09-29 bcd71f6371fa870c7647857a71bf67d21cde47e8

 src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java

@@ -2,26 +2,26 @@

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.core.common.DateUtils;
import com.core.exception.CoolException;
import com.zy.asrs.entity.Order;
import com.zy.asrs.entity.OrderDetl;
import com.zy.asrs.service.ApiLogService;
import com.zy.asrs.service.DocTypeService;
import com.zy.asrs.service.OrderDetlService;
import com.zy.asrs.service.OrderService;
import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
import com.zy.common.constant.MesConstant;
import com.zy.common.model.MesPakinParam;
import com.zy.common.service.erp.ErpService;
import com.zy.common.utils.HttpHandler;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;

import java.util.List;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

/**
 * Created by vincent on 2020/7/7
@@ -38,57 +38,146 @@
    private OrderDetlService orderDetlService;
    @Autowired
    private ApiLogService apiLogService;
    @Autowired
    private DocTypeService docTypeService;
    @Autowired
    private ErpService erpService;

    @Value("${u8.url}")
    private String url;

    @Value("${u8.orderReportPath}")
    private String orderReportPath;

    @Transactional
    public ReturnT<String> start(Order order) {
        List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());

        MesPakinParam pakinParam = new MesPakinParam();
        pakinParam.setPakinTime(DateUtils.convert(order.getUpdateTime()));
        pakinParam.setLgortFrom("5008");
        pakinParam.setLgortTo("5006");
        for (OrderDetl orderDetl : orderDetls) {
            pakinParam.getList().add(new MesPakinParam.Detl(orderDetl.getMatnr(), orderDetl.getAnfme()));
        Map<String, Object> param = new HashMap<>();
        param.put("id",order.getOrderNo());
        param.put("dDate",new Date());
        param.put("cHandler",9527);

        int code = doHttpRequest(param, "单据审核", url, orderReportPath, null, "127.0.0.1");
        if(code == 200){
            order.setSettle(6L);
            orderService.updateById(order);
        }


//        DocType docType = docTypeService.selectById(order.getDocType());
//        if (null == docType) {
//            return SUCCESS;
//        }
//        if (!Cools.isEmpty(docType.getMemo())) {
//            if (docType.getMemo().equals("hand")) {
//                // 修改订单状态 4.完成 ===>> 6.已上报
//                if (!orderService.updateSettle(order.getId(), 6L, null)) {
//                    throw new CoolException("服务器内部错误，请联系管理员");
//                }
//                return SUCCESS;
//            }
//        }

//        List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());
        // 入库完成上报
//        if (docType.getPakin() == 1) {
//            try {
//                // erp 同步
//                int state = 2;
//                if (!erpService.updateStateForVoucher(order.getOrderNo(), state)) {
//                    throw new CoolException(order.getOrderNo() + "订单修改State为"+state+"失败");
//                } else {
//                    erpService.updateTimeForVoucherDetail(order.getOrderNo());
//                }
//
//                // 修改订单状态 4.完成 ===>> 6.已上报
//                if (!orderService.updateSettle(order.getId(), 6L, null)) {
//                    throw new CoolException("服务器内部错误，请联系管理员");
//                }
//
//            } catch (Exception e) {
//                log.error("fail", e);
//                return FAIL.setMsg(e.getMessage());
//            }
//        }
//        // 出库完成上报
//        if (docType.getPakout() == 1) {
//            try {
//                double TotalNum = 0.0;
//                Integer TotalCount = orderDetls.size();
//                // erp 同步
//                int state = 2;
//                if (!erpService.updateStateForVoucher(order.getOrderNo(), state)) {
//                    throw new CoolException(order.getOrderNo() + "订单修改State为"+state+"失败");
//                } else {
//                    Date now = new Date();
//                    for (OrderDetl orderDetl : orderDetls) {
//                        TotalNum = TotalNum + orderDetl.getAnfme();
//                        if (null == erpService.selectVoucherDetail(order.getOrderNo(), orderDetl.getBatch())) {
//                            VoucherDetail voucherDetail = new VoucherDetail();
//                            voucherDetail.setVoucherID(order.getOrderNo());
//                            voucherDetail.setPickID("fepvnn0496");
//                            voucherDetail.setBarcode(orderDetl.getBatch());
//                            voucherDetail.setLastUpdatedDate(DateUtils.convert(now));
//                            if (!erpService.insertVoucherDetail(voucherDetail)) {
//                                throw new CoolException(order.getOrderNo() + "订单添加VoucherDetail"+ JSON.toJSONString(voucherDetail)+"失败");
//                            }
//                        }
//                    }
//                }
//                // 更新重量和数量
//                if (!erpService.updateStateForVoucher(order.getOrderNo(), TotalNum, TotalCount)) {
//                    throw new CoolException(order.getOrderNo() + "订单修改重量和数量失败");
//                }
//
//                // 修改订单状态 4.完成 ===>> 6.已上报
//                if (!orderService.updateSettle(order.getId(), 6L, null)) {
//                    throw new CoolException("服务器内部错误，请联系管理员");
//                }
//
//            } catch (Exception e) {
//                log.error("fail", e);
//                TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
//                return FAIL.setMsg(e.getMessage());
//            }
//        }
        return SUCCESS;
    }

    private int doHttpRequest(Object requestParam, String namespace, String url, String path, String appkey, String ip){
        String response = "";
        boolean success = false;

        try {
            response = new HttpHandler.Builder()
                        .setUri(MesConstant.URL)
                        .setPath(MesConstant.PAKIN_URL)
                        .setJson(JSON.toJSONString(pakinParam))
                        .build()
                        .doPost();
                    .setUri(url)
                    .setPath(path)
                    .setJson(JSONObject.toJSONString(requestParam))
                    .build()
                    .doPost();
            JSONObject jsonObject = JSON.parseObject(response);
            if (jsonObject.getInteger("code").equals(200)) {
                success = true;
                // 修改订单状态 4.完成 ===>> 6.已上报
                if (!orderService.updateSettle(order.getId(), 6L, null)) {
                    throw new CoolException("服务器内部错误，请联系管理员");
                }
            } else {
                log.error("请求接口失败！！！url：{}；request：{}；response：{}", MesConstant.URL+MesConstant.PAKIN_URL, JSON.toJSONString(pakinParam), response);
                throw new CoolException("上报mes系统失败");

            int code = (int) jsonObject.get("code");
            if(code != 200){
                throw new CoolException(jsonObject.get("msg").toString());
            }
        } catch (Exception e) {
            log.error("fail", e);
            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
            return FAIL.setMsg(e.getMessage());
        } finally {
            try {
                // 保存接口日志
//                apiLogService.save(
//                        "成品库入库上报",
//                        MesConstant.URL + MesConstant.PAKIN_URL,
//                        null,
//                        "127.0.0.1",
//                        JSON.toJSONString(pakinParam),
//                        response,
//                        success
//                );
            } catch (Exception e) { log.error("", e); }
            success = true;
            return code;
        }catch (Exception e){
            log.error(e.getMessage());
            throw new CoolException("调用接口响应错误");
        }finally {
            apiLogService.save(
                    namespace,
                    url + path,
                    appkey,
                    ip,
                    JSON.toJSONString(JSONObject.toJSONString(requestParam)),
                    response,
                    success
            );
        }
        return SUCCESS;

    }

}