#erp上报开发

lty

9 小时以前 c5dc49d6941da939bcd909ec39197e0128b13fb3

#erp上报开发

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

@@ -3,7 +3,6 @@
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.exception.CoolException;
import com.zy.asrs.entity.DocType;
import com.zy.asrs.entity.Order;
@@ -14,9 +13,6 @@
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.model.MesPakoutParam;
import com.zy.common.utils.HttpHandler;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -24,7 +20,12 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Created by vincent on 2020/7/7
@@ -32,6 +33,15 @@
@Slf4j
@Service
public class OrderSyncHandler extends AbstractHandler<String> {

    private static final String LK_TEST_URI = "192.168.0.41";
    private static final String LK_PROD_URI = "192.168.0.42";

    private static final String LK_ENT_CODE = "lfd";
    private static final String LK_USERNAME = "TL002";
    private static final String LK_PASSWORD_MD5 = "e10adc3949ba59abbe56e057f20f883e";

    private volatile String lkToken;

    @Autowired
    private JdbcTemplate jdbcTemplate;
@@ -51,110 +61,267 @@
            return SUCCESS;
        }
        List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());
        // 入库完成上报

        String docName = docType.getDocName();
        if (!Cools.isEmpty(docName) && docName.contains("退")) {
            ReturnT<String> returnT = reportProductReturn(order, orderDetls);
            if (!returnT.isSuccess()) {
                return returnT;
            }
            return SUCCESS;
        }

        if (docType.getPakin() == 1) {
            MesPakinParam pakinParam = new MesPakinParam();
            pakinParam.setPakinTime(DateUtils.convert(order.getUpdateTime()));
            pakinParam.setLgortFrom("5008");
            pakinParam.setLgortTo("5006");
            for (OrderDetl orderDetl : orderDetls) {
                String serial = Cools.isEmpty(orderDetl.getBatch()) ? "" : orderDetl.getBatch();
                pakinParam.getList().add(new MesPakinParam.Detl(orderDetl.getMatnr() + (Cools.isEmpty(serial) ? "" : "-" + serial), orderDetl.getAnfme()));
            ReturnT<String> returnT = reportPurchaseInStock(order, orderDetls);
            if (!returnT.isSuccess()) {
                return returnT;
            }
            String response = "";
            boolean success = false;
            try {
                response = new HttpHandler.Builder()
                        .setUri(MesConstant.URL)
                        .setPath(MesConstant.PAKIN_URL)
                        .setJson(JSON.toJSONString(pakinParam))
                        .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系统失败");
                }
            } 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); }
            }
        }
        // 出库完成上报
        if (docType.getPakout() == 1) {
            MesPakoutParam pakoutParam = new MesPakoutParam();
            pakoutParam.setTag(!order.getDocType$().equalsIgnoreCase("手动出库单"));
            pakoutParam.setPakoutTime(DateUtils.convert(order.getUpdateTime()));
            pakoutParam.setLgortFrom("5006");
            pakoutParam.setLgortTo("1111");
            if (!pakoutParam.isTag()) {
                pakoutParam.setKunnr("C1000");
            }
            pakoutParam.setOrderNo(order.getOrderNo());
            for (OrderDetl orderDetl : orderDetls) {
                String serial = Cools.isEmpty(orderDetl.getBatch()) ? "" : orderDetl.getBatch();
                pakoutParam.getList().add(new MesPakoutParam.Detl(orderDetl.getMatnr() + (Cools.isEmpty(serial) ? "" : "-" + serial), orderDetl.getAnfme()));
            }
            String response = "";
            boolean success = false;
            try {
                response = new HttpHandler.Builder()
                        .setUri(MesConstant.URL)
                        .setPath(MesConstant.PAKOUT_URL)
                        .setJson(JSON.toJSONString(pakoutParam))
                        .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.PAKOUT_URL, JSON.toJSONString(pakoutParam), response);
                    throw new CoolException("上报mes系统失败");
                }
            } catch (Exception e) {
                log.error("fail", e);
//            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                return FAIL.setMsg(e.getMessage());
            } finally {
                try {
                    // 保存接口日志
                    apiLogService.save(
                            "成品库出库上报",
                            MesConstant.URL + MesConstant.PAKOUT_URL,
                            null,
                            "127.0.0.1",
                            JSON.toJSONString(pakoutParam),
                            response,
                            success
                    );
                } catch (Exception e) { log.error("", e); }
        } else if (docType.getPakout() == 1) {
            ReturnT<String> returnT = reportIssueOrFeed(order, docType, orderDetls);
            if (!returnT.isSuccess()) {
                return returnT;
            }
        }
        return SUCCESS;
    }

    private ReturnT<String> reportPurchaseInStock(Order order, List<OrderDetl> orderDetls) {
        String path = "/purchaseInStock/lkPurchaseInStockAdd";
        String memo = "立库采购入库";
        JSONObject request = new JSONObject();
        request.put("purchaseInStockDtls", buildBatchQtyList(orderDetls));

        String response = "";
        boolean success = false;
        try {
            JSONObject res = postLk(path, request);
            response = res.toJSONString();
            if (lkSuccess(res)) {
                success = true;
                if (!orderService.updateSettle(order.getId(), 6L, null)) {
                    throw new CoolException("服务器内部错误，请联系管理员");
                }
            } else {
                throw new CoolException("上报接口失败");
            }
        } catch (Exception e) {
            log.error("fail", e);
            return FAIL.setMsg(e.getMessage());
        } finally {
            try {
                apiLogService.save(
                        memo,
                        lkUri() + path,
                        null,
                        "127.0.0.1",
                        request.toJSONString(),
                        response,
                        success
                );
            } catch (Exception e) { log.error("", e); }
        }
        return SUCCESS;
    }

    private ReturnT<String> reportIssueOrFeed(Order order, DocType docType, List<OrderDetl> orderDetls) {
        String docName = docType.getDocName();
        String path;
        String memo;
        if (!Cools.isEmpty(docName) && docName.contains("补")) {
            path = "/productFeed/lkProductFeedAdd";
            memo = "立库生产补料";
        } else {
            path = "/productIssue/lkProductIssueAdd";
            memo = "立库生产发料";
        }

        JSONObject dtl = new JSONObject();
        dtl.put("planSpNo", order.getOrderNo());
        List<JSONObject> boms = buildBatchQtyList(orderDetls);
        String bomsKey;
        if (path.contains("productFeed")) {
            bomsKey = "productFeedBoms";
        } else if (path.contains("productReturn")) {
            bomsKey = "productReturnBoms";
        } else {
            bomsKey = "productIssueBoms";
        }
        dtl.put(bomsKey, boms);

        String dtlsKey;
        if (path.contains("productFeed")) {
            dtlsKey = "productFeedDtls";
        } else if (path.contains("productReturn")) {
            dtlsKey = "productReturnDtls";
        } else {
            dtlsKey = "productIssueDtls";
        }
        JSONObject request = new JSONObject();
        request.put(dtlsKey, Collections.singletonList(dtl));

        String response = "";
        boolean success = false;
        try {
            JSONObject res = postLk(path, request);
            response = res.toJSONString();
            if (lkSuccess(res)) {
                success = true;
                if (!orderService.updateSettle(order.getId(), 6L, null)) {
                    throw new CoolException("服务器内部错误，请联系管理员");
                }
            } else {
                throw new CoolException("上报接口失败");
            }
        } catch (Exception e) {
            log.error("fail", e);
            return FAIL.setMsg(e.getMessage());
        } finally {
            try {
                apiLogService.save(
                        memo,
                        lkUri() + path,
                        null,
                        "127.0.0.1",
                        request.toJSONString(),
                        response,
                        success
                );
            } catch (Exception e) { log.error("", e); }
        }
        return SUCCESS;
    }

    private ReturnT<String> reportProductReturn(Order order, List<OrderDetl> orderDetls) {
        String path = "/productReturn/lkProductReturnAdd";
        String memo = "立库生产退料";

        JSONObject dtl = new JSONObject();
        dtl.put("planSpNo", order.getOrderNo());
        dtl.put("productReturnBoms", buildBatchQtyList(orderDetls));

        JSONObject request = new JSONObject();
        request.put("productReturnDtls", Collections.singletonList(dtl));

        String response = "";
        boolean success = false;
        try {
            JSONObject res = postLk(path, request);
            response = res.toJSONString();
            if (lkSuccess(res)) {
                success = true;
                if (!orderService.updateSettle(order.getId(), 6L, null)) {
                    throw new CoolException("服务器内部错误，请联系管理员");
                }
            } else {
                throw new CoolException("上报接口失败");
            }
        } catch (Exception e) {
            log.error("fail", e);
            return FAIL.setMsg(e.getMessage());
        } finally {
            try {
                apiLogService.save(
                        memo,
                        lkUri() + path,
                        null,
                        "127.0.0.1",
                        request.toJSONString(),
                        response,
                        success
                );
            } catch (Exception e) { log.error("", e); }
        }
        return SUCCESS;
    }

    private List<JSONObject> buildBatchQtyList(List<OrderDetl> orderDetls) {
        List<JSONObject> list = new ArrayList<>();
        for (OrderDetl detl : orderDetls) {
            if (Cools.isEmpty(detl.getBatch())) {
                throw new CoolException("批次号不能为空");
            }
            JSONObject one = new JSONObject();
            one.put("batchNum", detl.getBatch());
            one.put("quantity", detl.getAnfme());
            list.add(one);
        }
        return list;
    }

    private JSONObject postLk(String path, JSONObject request) throws IOException {
        try {
            return doPostLk(path, request, ensureLkToken(false));
        } catch (Exception e) {
            return doPostLk(path, request, ensureLkToken(true));
        }
    }

    private JSONObject doPostLk(String path, JSONObject request, String token) throws IOException {
        Map<String, Object> headers = new HashMap<>();
        if (!Cools.isEmpty(token)) {
            headers.put("Authorization", token);
        }
        String response = new HttpHandler.Builder()
                .setUri(lkUri())
                .setPath(path)
                .setHeaders(headers)
                .setJson(request.toJSONString())
                .build()
                .doPost();
        return JSON.parseObject(response);
    }

    private boolean lkSuccess(JSONObject response) {
        if (response == null) {
            return false;
        }
        Integer code = response.getInteger("code");
        String error = response.getString("error");
        return code != null && code == 200 && "SUCCESS".equalsIgnoreCase(error);
    }

    private String ensureLkToken(boolean force) throws IOException {
        if (!force && !Cools.isEmpty(lkToken)) {
            return lkToken;
        }
        synchronized (this) {
            if (!force && !Cools.isEmpty(lkToken)) {
                return lkToken;
            }
            JSONObject req = new JSONObject();
            req.put("entCode", LK_ENT_CODE);
            req.put("username", LK_USERNAME);
            req.put("password", LK_PASSWORD_MD5);
            String resp = new HttpHandler.Builder()
                    .setUri(lkUri())
                    .setPath("/acco/login")
                    .setJson(req.toJSONString())
                    .build()
                    .doPost();
            JSONObject json = JSON.parseObject(resp);
            Integer code = json.getInteger("code");
            if (code == null || code != 200) {
                throw new CoolException("登录失败");
            }
            String token = json.getString("data");
            if (Cools.isEmpty(token)) {
                throw new CoolException("登录失败");
            }
            lkToken = token;
            return lkToken;
        }
    }

    private String lkUri() {
        String override = System.getProperty("lk.uri");
        if (!Cools.isEmpty(override)) {
            return override;
        }
        String env = System.getProperty("lk.env");
        if (!Cools.isEmpty(env) && "prod".equalsIgnoreCase(env)) {
            return LK_PROD_URI;
        }
        return LK_TEST_URI;
    }

}