Source/UBCS-WEB/src/views/integration/integrationIndex.vue

@@ -50,17 +50,26 @@
                       @row-click="handleMapingClick" @row-dblclick="handleMapingRowClick"
                       @selection-change="selectionChange"
                       @select-all="handleSelectAll">
              <template slot="radio"
                        slot-scope="{row}">

                <el-radio v-model="selectRow" :label="row.$index">-</el-radio>
              </template>
              <template slot="menuLeft">
                <el-button :disabled="disabledPush" icon="el-icon-plus" size="small" type="primary"
                           @click="dialogPush = true">新 增
                <!--                <el-button :disabled="disabledPush" icon="el-icon-plus" size="small" type="primary"-->
                <!--                           @click="dialogPush = true">新 增-->
                <!--                </el-button>-->
                <el-button v-if="permissionList.saveBtn" icon="el-icon-check" size="small" type="primary"
                           @click="handleSave">保 存
                </el-button>
                <el-button icon="el-icon-check" size="small" type="primary" @click="handleSave">保 存
                <el-button v-if="permissionList.allSyncBtn" icon="el-icon-connection" size="small"
                           type="primary" @click="handleSync('all')">同步主模型
                </el-button>
                <el-button icon="el-icon-connection" size="small" type="primary"
                           @click="handleSync('all')">同步主模型
                <el-button v-if="permissionList.oneSyncBtn" icon="el-icon-connection" size="small"
                           type="primary" @click="handleSync('one')">同步详细模型
                </el-button>
                <el-button icon="el-icon-connection" size="small" type="primary"
                           @click="handleSync('one')">同步详细模型
                <el-button v-if="permissionList.autoBtn" icon="el-icon-coordinate" size="small"
                           type="primary" @click="handlerAuto">自动填充
                </el-button>
              </template>
            </avue-crud>
@@ -69,6 +78,11 @@
            <avue-crud ref="crudRange" :data="rangeData" :option="optinoRange" :style="{ marginTop: '-20px'}"
                       @row-update="handleUpdate"
                       @row-dblclick="handleRowClick">
              <template slot="menuLeft">
                <el-button v-if="permissionList.bottomAutoBtn" icon="el-icon-coordinate" size="small"
                           type="primary" @click="handlerBottomAuto">自动填充
                </el-button>
              </template>
            </avue-crud>
          </el-card>
        </el-card>
@@ -81,6 +95,7 @@
<script>
import integrationTransfer from './integrationTransfer.vue'
import pinyin from 'js-pinyin'
import {mapGetters} from "vuex";
import {
  referCodeClassifyTree,
  referTree,
@@ -90,6 +105,7 @@
  listCodeAttributeByClassId,
  syncClassifyModel
} from '@/api/integration/integration.js'
import {getByGroupAttrMapping, getEnumAttrByClsOidAndAttrId} from "@/api/vciAttrbute";

export default {
  components: {
@@ -113,6 +129,8 @@
      highlightCurrentRow: true,
    }
    return {
      selectRow: "",
      targetNameList: [], // 元数据返回名称
      defaultCheckedKeys: [],
      isNodeDisabled: true,
      // 表单值
@@ -138,8 +156,8 @@
      optinoRange: {
        title: '属性映射取值范围',
        maxHeight: '280px',
        header: false,
        rowKey: 'oid',
        refreshBtn: false,
        column: [
          {label: '属性集团枚举值', prop: 'numTextValue', minWidth: 80},
          {label: '集团属性枚举显示名称', prop: 'numText', minWidth: 80},
@@ -166,8 +184,21 @@
        header: true,
        rowKey: 'oid',
        selection: false,
        refreshBtn:false,
        refreshBtn: false,
        delBtn: false,
        addBtn: false,
        columnBtn: false,
        searchShow: true,
        emptyBtn: false,
        searchBtn: false,
        searchShowBtn: false,
        cellBtn: true,
        border: true,
        searchMenuSpan: 8,
        highlightCurrentRow: true,
        $cellEdit: true,
        column: [
          {label: '', prop: 'radio', width: 60, hide: false},
          {label: '集团分类', prop: 'sourceClassifyName', minWidth: 80},
          {label: '所属视图', prop: 'viewName', minWidth: 80},
          {label: '集团属性', prop: 'sourceAttrName', minWidth: 80},
@@ -175,17 +206,24 @@
          {
            label: '属性名称',
            prop: 'targetAttrName',
            minWidth: 80,
          },
          {
            label: '默认值',
            prop: 'defaultValue',
            minWidth: 140,
            type: 'select',
            cell: true,
            blur: (value) => window.handleBlur(value, 'mapping')
            filterable: true,
            minWidth: 80,
            props: {
              label: 'targetAttrName',
              value: 'targetAttrName'
            },
            dicData: [],
          },
          // {
          //   label: '默认值',
          //   prop: 'defaultValue',
          //   minWidth: 140,
          //   cell: true,
          //   blur: (value) => window.handleBlur(value, 'mapping')
          // },
        ],
        ...options
      },
      // 主数据分类树
      treeData: [],
@@ -215,7 +253,8 @@
      mappingForm: {},
      // 定时器
      times: null,
      TreeSelectOid: ""
      TreeOid: "",
      tableSelectId: ''

    }
  },
@@ -231,7 +270,6 @@
  mounted() {
    let that = this
    window.handleBlur = that.handleBlur

  },
  computed: {
    filtermapping() {
@@ -242,9 +280,129 @@
        return obj.targetAttrName
      })
      return transfer
    }
    },
    targetColumn() {
      return this.optionMapping.column.find(column => column.prop === 'targetAttrName');
    },
    ...mapGetters(["permission"]),
    permissionList() {
      return {
        allSyncBtn: this.vaildData(this.permission.integration.integration_allSync, false),
        autoBtn: this.vaildData(this.permission.integration.integration_auto, false),
        bottomAutoBtn: this.vaildData(this.permission.integration.integration_bottomAuto, false),
        oneSyncBtn: this.vaildData(this.permission.integration.integration_oneSync, false),
        saveBtn: this.vaildData(this.permission.integration.integration_save, false),
      }
    },
  },
  methods: {
    handlerAuto() {
      if (!this.TreeOid || this.TreeOid === "") {
        return;
      }
      // 过滤出集团属性的key值
      const groupArray = this.mappingData ? this.mappingData.map(obj => obj.sourceAttrKey) : [];
      // 获取到需要自动填充的值
      getByGroupAttrMapping({classifyId: this.TreeOid, groupAttrKeyList: groupArray})
        .then(res => {
          //  单独把返回值的groupAttrKey放一个数组，然后过滤出返回值的groupAttrKey是否等于表格数据中的sourceAttrKey
          // const groupReturnData = res.data && res.data.data ? res.data.data.map(item => item.groupAttrKey) : [];
          const groupReturnData = res.data.data;
          // 过滤匹配
          // console.log(groupReturnData)
          this.mappingData.forEach(mappingItem => {
            groupReturnData.forEach(groupItem => {
              if (mappingItem.sourceAttrKey === groupItem.groupAttrKey) {
                const result = this.transferData.find(obj => obj.id.toLowerCase() === groupItem.codeMetaAttrKey.toLowerCase());
                if (result) {
                  mappingItem.targetAttrId = groupItem.codeMetaAttrOid.toLowerCase();
                  mappingItem.targetAttrName = groupItem.codeMetaAttrName.toLowerCase();
                  mappingItem.targetAttrKey = groupItem.codeMetaAttrKey.toLowerCase();
                } else {
                  mappingItem.targetAttrId = '';
                  mappingItem.targetAttrName = '';
                  mappingItem.targetAttrKey = '';
                }
              }
            })
          })
          this.$message.success('自动填充成功，请确认属性后点击保存！');
        })
        .catch(error => {
          console.log(error)
          this.$message.error('填充失败，请稍后再试！');
        });
    },
    handlerBottomAuto() {
      if (this.rangeData.length <= 0) {
        this.$message.warning('请选择一条枚举类型属性!')
        return
      }
      getEnumAttrByClsOidAndAttrId({classifyId: this.TreeOid, codeMetaAttrKey: this.tableSelectId}).then(res => {
        const data = res.data.data;
        this.rangeData.forEach(rangeItem => {
          data.forEach(dataItem => {
            const similarity = this.calculateSimilarity(rangeItem.numText, dataItem.itemName);
            if (similarity > 70) {
              rangeItem.targetNumTextValue = rangeItem.numTextValue;
              rangeItem.targetNumText = dataItem.itemName;
            }
          })
        })
        this.$message.success('自动填充成功，请确认属性后点击保存！')
      })
    },
    calculateSimilarity(str1, str2) {
      // 计算编辑距离
      function editDistance(s1, s2) {
        s1 = s1.toLowerCase();
        s2 = s2.toLowerCase();

        const costs = [];
        for (let i = 0; i <= s1.length; i++) {
          let lastValue = i;
          for (let j = 0; j <= s2.length; j++) {
            if (i === 0)
              costs[j] = j;
            else {
              if (j > 0) {
                let newValue = costs[j - 1];
                if (s1.charAt(i - 1) !== s2.charAt(j - 1))
                  newValue = Math.min(Math.min(newValue, lastValue),
                    costs[j]) + 1;
                costs[j - 1] = lastValue;
                lastValue = newValue;
              }
            }
          }
          if (i > 0)
            costs[s2.length] = lastValue;
        }
        return costs[s2.length];
      }

      // 计算相似度百分比
      function similarityPercent(s1, s2) {
        let maxLength = Math.max(s1.length, s2.length);
        let distance = editDistance(s1, s2);
        return ((maxLength - distance) / maxLength) * 100;
      }

      // 调用相似度计算函数并返回百分比形式的相似度
      const similarity = similarityPercent(str1, str2);
      return similarity;
    },
    getTargetName(data) {
      this.targetColumn.dicData = data.filter(item => item.name && item.name.trim() !== "") // 过滤掉name为空的属性
        .map(item => {
          return {
            targetAttrId: item.oid,
            targetAttrKey: item.id,
            targetAttrName: item.name,
            // disabled: false
          }
        });
    },
    // 接口左侧树
    async getReferCodeClassifyTree() {
      this.treeData = []
@@ -268,7 +426,13 @@
      if (response.status === 200) {
        this.loading = false
        this.mappingData = response.data.data
        // console.log(this.filtermapping)

        // for (const item of this.mappingData) {
        //   if (item.targetAttrName && item.targetAttrId && item.targetAttrKey) {
        //     const targetObject = this.targetColumn.dicData.find(obj => obj.targetAttrName === item.targetAttrName);
        //     targetObject.disabled = true;
        //   }
        // }
      }
    },
    // 接口获取属性映射取值范围
@@ -288,6 +452,7 @@
      if (response.status === 200) {
        const data = response.data.data
        this.transferData = data;
        this.getTargetName(data)
        // console.log(data)
      }
    },
@@ -374,6 +539,17 @@
    },
    // 保存按钮
    async handleSave() {
      const getTargetCorresponding = (row) => {
        return this.targetColumn.dicData.find(column => column.targetAttrName === row.targetAttrName);
      }
      for (const item of this.mappingData) {
        item.$cellEdit = false;
        if (item.targetAttrName && !item.targetAttrId && !item.targetAttrKey) {
          const {targetAttrId, targetAttrKey, targetAttrName} = await getTargetCorresponding(item);
          Object.assign(item, {targetAttrId, targetAttrKey, targetAttrName});
        }
      }
      this.mappingData[this.selectRow].dockingPreAttrRangeVoList = (this.rangeData)
      const response = await batchAddSave({dockingPreAttrMappingVOList: this.mappingData})
      if (response.status === 200) {
        this.$message({
@@ -394,9 +570,13 @@
          message: "请选择一条集团分类"
        });
      } else {
        const response = await syncClassifyModel(param)
        if (response.status === 200) {
          console.log(response)
        try {
          const response = await syncClassifyModel(param);
          if (response.status === 200) {
            this.$message.success(response.data.msg)
          }
        } catch (error) {
          console.error(error);
        }
      }
    },
@@ -420,6 +600,7 @@
    },
    // 左侧树点击
    handelTreeCell(event) {
      this.TreeOid = event.oid;
      this.treeParam.codeClassifyId = event.oid
      this.form.groupValue = ''
      this.groupVal = ''
@@ -453,6 +634,9 @@
    },
    // 集团映射属性行选择（单击）
    handleMapingClick(row) {
      // console.log(row)
      this.tableSelectId = row.targetAttrKey || "";
      this.selectRow = row.$index;
      clearTimeout(this.times)
      this.mappingForm = row
      this.times = setTimeout(() => {
@@ -477,13 +661,42 @@
      done();
    },
    // 属性取值范围单元格编辑后
    handleMapingUpdate(row, index, done) {
      this.$message({
        showClose: true,
        message: "修改成功",
        type: "success",
      });
      done();
    async handleMapingUpdate(row, index, done) {
      const getTargetCorresponding = async (row) => {
        return this.targetColumn.dicData.find(column => column.targetAttrName === row.targetAttrName);
      };

      try {
        if (!row.targetAttrName) {
          this.$message.warning('请选择要保存的属性名称！');
          done();
          return;
        }

        // 获取目标属性信息
        const {targetAttrId, targetAttrKey, targetAttrName} = await getTargetCorresponding(row);


        // 更新行数据
        Object.assign(row, {
          targetAttrId: targetAttrId.toLowerCase(),
          targetAttrKey: targetAttrKey.toLowerCase(),
          targetAttrName: targetAttrName.toLowerCase()
        });

        const response = await batchAddSave({dockingPreAttrMappingVOList: [row]});

        if (response.status === 200) {
          this.$message({
            type: "success",
            message: "修改成功!"
          });
        }
      } catch (error) {
        console.error('处理映射更新时出错：', error);
      } finally {
        done();
      }
    },
    // 集团映射属性选择（单选）
    selectionChange(selection) {
@@ -497,12 +710,14 @@
      }
    },
    setCurrentRow(selection, row) {
      console.log(selection, row)
      this.mappingForm = row
      this.disabledPush = false
    },
    handleSelectAll(selection) {
      this.$refs.crudMapping.toggleSelection()
    }
    },

  }
}
</script>
@@ -532,5 +747,10 @@
  .el-transfer-panel {
    width: 270px;
  }

  .el-scrollbar__view {
    height: 100px;
  }
}

</style>