物料业务数据分发功能实现

倪影Alone

2024-09-03 507d193d16bc32a7cacfd2bf2c19e1db24390414

物料业务数据分发功能实现

 src/main/java/com/itstyle/mdm/entity/MdmData.java

@@ -28,4 +28,16 @@
    public String getId() {
        return id;
    }

    @Override
    public String toString() {
        return "MdmData{" +
                "uuid='" + uuid + '\'' +
                ", id='" + id + '\'' +
                ", tgcoriginalCode='" + tgcoriginalCode + '\'' +
                ", updatedat='" + updatedat + '\'' +
                ", updatetime='" + updatetime + '\'' +
                ", type='" + type + '\'' +
                '}';
    }
}

 src/main/java/com/itstyle/mdm/enumwrap/MdmEnum.java

@@ -12,6 +12,16 @@
     */
    MDM_LADGPS_MATERIAL_NAME("局域物料名称编码数据获取","/api/V1/zone/getWLCodes"),

    /**
     * 局域物料词典编码
     */
    MDM_LADGPS_MATERIAL_DICTIONARY("局域物料词典编码数据获取","/api/V1/ztwo/getWLCDCodes"),

    /**
     * 局域物料词典编码
     */
    MDM_MATERIAL_DICTIONARY("物料业务编码数据获取","/api/V1/zbusiness/getWLYWCodes"),


    /**
     * 业务基础数据编码获取(计量单位)

 src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java

@@ -38,7 +38,7 @@
            for (int i = 0; i < size; i++) {
                String json = recordArray.get(i).toString();
                JSONObject jsonObj = JSON.parseObject(json);
                String id = jsonObj.getString("id");
                String id = jsonObj.getString("tgctwoclasscode");
                String tgcoriginalcode = jsonObj.getString("tgcoriginalcode");
                String updatedat = jsonObj.getString("updatedat");
                String updatetime = jsonObj.getString("updatetime");
@@ -68,6 +68,7 @@
                    newJsonArray.add(jsonObj);
                    //说明该数据为新数据
                    mdmData.setUuid(UUID.randomUUID().toString());
                    System.out.println(mdmData.toString());
                    dynamicQuery.save(mdmData);
                }
            }

 src/main/java/com/itstyle/mdm/utils/MdmUtils.java

@@ -51,21 +51,26 @@
                records = records.replaceAll("\\p{Z}", "");
                JSONObject jsonObj = JSON.parseObject(records);
                records = jsonObj.getString("records");
                records = records.replaceAll("unit","unitName");
                records = records.replaceAll("jzgg","specification");
                records = records.replaceAll("model","specificationDisplayName");
                records = records.replaceAll("namecn","code");
                records = records.replaceAll("hyflmc","typeCode");
                JSONArray recordArray = JSON.parseArray(records);//物料数据信息
                //将数据保存至数据库
                JSONArray newJson = mdmService.saveMdmData(recordArray,name);
                if(newJson.size()!=0){
                    //定义返回json格式
                    returnJson.append("{\n" +
                    /*returnJson.append("{\n" +
                            "    \"current\": 1,\n" +
                            "    \"orders\": [],\n" +
                            "    \"pages\": 303,");
                    returnJson.append("\"records\": "+newJson.toJSONString());
                    returnJson.append(",\n" +
                            "    \"pages\": 303,");*/
                    returnJson.append("{\"records\": "+newJson.toJSONString()+"}");
                    /*returnJson.append(",\n" +
                            "    \"searchCount\": true,\n" +
                            "    \"size\": 1,\n" +
                            "    \"total\": 303\n" +
                            "}");
                            "}");*/
                    //返回json格式参数
                    String toString = returnJson.toString();
                    System.out.println(toString);

 src/main/resources/application.properties

@@ -28,10 +28,10 @@


#注意中文乱码
spring.datasource.url=jdbc:mysql://localhost:3306/quartz?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://10.240.10.41:3306/quartz?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.username=quartz
spring.datasource.password=tianheng.mysql
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# Specify the DBMS
spring.jpa.database = MYSQL
# Show or not log for each sql query

 src/main/resources/templates/log/listlog.html

@@ -54,10 +54,10 @@
            }, {
                key : "createTime",
                title : "发送时间"
            }, {
            }/*, {
                key : "prams",
                title : "请求参数"
            }, {
            }*/, {
                key : "result",
                title : "响应结果"
            },{

 src/main/resources/templates/sysConfig/distribute.html

@@ -198,6 +198,7 @@
                        top.frames[iframeId].vm.formQuartz.address = address;
                        top.frames[iframeId].vm.formQuartz.description = description;
                        top.frames[iframeId].vm.formQuartz.association = association;
                        console.log(top.frames[iframeId].vm.formQuartz.association);
                        top.frames[iframeId].vm.formQuartz.isEnable = isEnable;
                        top.frames[iframeId].vm.formQuartz.cronExpression = cronExpression;
                    },