1

Surpriseplus

2023-02-01 dda0e6f581e8c2b116f2eae53756d80215d6e5e0

 src/views/datamanage/metadataManage.vue

@@ -1,15 +1,47 @@
<template>
  <div class="authorityManagement_box">
    <My-bread
      :list="[
    <My-bread :list="[
        `${$t('dataManage.dataManage')}`,
        `${$t('dataManage.metadataManage')}`,
      ]"
    ></My-bread>
      ]"></My-bread>
    <el-divider />
    <div class="inquire">
      <el-form ref="queryForm" :model="queryForm" :inline="true">
        <el-form-item :label="$t('dataManage.vmobj.keyword')" prop="name">
      <el-form
        ref="queryForm"
        :model="queryForm"
        :inline="true"
      >
        <el-form-item>
          <el-cascader
            v-model="queryForm.dirid"
            :show-all-levels="false"
            :options="companyOption"
            @change="handleChange"
            :props="{
              label: 'name',
              value: 'id',
              children: 'children',
              checkStrictly: true,
              emitPath: false,
            }"
          ></el-cascader>
        </el-form-item>
        <el-form-item>
          <el-cascader
            v-model="queryForm.depid"
            :show-all-levels="false"
            :options="companyOption1"
            @change="handleChange1"
            :props="{
              label: 'name',
              value: 'id',
              children: 'children',
              checkStrictly: true,
              emitPath: false,
            }"
          ></el-cascader>
        </el-form-item>
        <el-form-item prop="name">
          <el-input
            v-model="queryForm.name"
            :placeholder="$t('common.pleaseInput')"
@@ -21,8 +53,7 @@
            icon="el-icon-search"
            class="primary"
            size="small"
            >{{ $t('common.iquery') }}</el-button
          >
          >{{ $t('common.iquery') }}</el-button>
        </el-form-item>
        <el-form-item>
          <el-button
@@ -30,8 +61,7 @@
            icon="el-icon-refresh"
            type="info"
            size="small"
            >{{ $t('common.reset') }}</el-button
          >
          >{{ $t('common.reset') }}</el-button>
        </el-form-item>

        <!-- <el-form-item v-if="btnStatus.insert">
@@ -49,22 +79,20 @@
            size="small"
            @click="deleteMetaInfo"
            icon="el-icon-delete"
            >{{ $t('common.delete') }}</el-button
          >
          >{{ $t('common.delete') }}</el-button>
        </el-form-item>
        <!-- <el-form-item v-if="btnStatus.download">
        <el-form-item v-if="btnStatus.download">
          <el-button
            @click="downFormData"
            icon="el-icon-download"
            type="success"
            size="small"
            >{{ $t('common.download') }}</el-button
          >
        </el-form-item> -->
          >{{ $t('common.download') }}</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="bottom">
      <div class="leftTree">
      <!-- <div class="leftTree">
           <el-tree
          ref="tree"
          :props="defaultProps"
@@ -80,26 +108,30 @@

          </span>
        </el-tree>
        <!-- <ul>
          <li
            @click="getTableDesc(item)"
            v-for="item in optionCount"
            :class="{ active: activeName == item.tab }"
          >
            {{ item.tabDesc }}({{ item.tab }})
          </li>
        </ul> -->
      </div>
      
      </div> -->
      <div class="rightTable">
        <div class="table_box">
          <el-table
            :data="tableData"
            style="width: 100%"
            @selection-change="handleSelectionChange"
            height="99%"
            height="95%"
          >
            <el-table-column type="selection" width="55" />
            <el-table-column prop="name" :label="$t('dataManage.vmobj.name')" />
            <el-table-column
              type="selection"
              width="55"
            />
            <el-table-column
              :label="$t('dataManage.dictionaryManageObj.number')"
              type="index"
              width="50"
            >
            </el-table-column>
            <el-table-column
              prop="name"
              :label="$t('dataManage.vmobj.name')"
            />
            <el-table-column
              prop="type"
              :label="$t('dataManage.vmobj.format')"
@@ -113,18 +145,31 @@
              prop="depName"
              :label="$t('dataManage.vmobj.depName')"
            />
             <el-table-column
            <el-table-column
              prop="dirName"
              :label="$t('dataManage.vmobj.dirName')"
              width="200"
            />
            <el-table-column
              prop="gather"
              :label="$t('dataManage.vmobj.gather')"
              prop="verName"
              :label="$t('dataManage.vmobj.versionNumber')"
            />
            <el-table-column :label="$t('dataManage.dataUpObj.tableName')">
              <template slot-scope="scope">
                <a @click="detail(scope.row)">{{
          scope.row.tab
        }}</a>
              </template>
            </el-table-column>

            <!-- <el-table-column
              prop="tab"
              :label="$t('dataManage.vmobj.tab')"
              :formatter="formatData"
            />
            /> -->
            <el-table-column
              prop="describe"
              :label="$t('dataManage.vmobj.describe')"
              prop="rows"
              :label="$t('dataManage.vmobj.row')"
            />
            <el-table-column
              prop="uname"
@@ -135,22 +180,29 @@
              :label="$t('dataManage.vmobj.createontime')"
              :formatter="formatData"
            />

            <el-table-column min-width="100" :label="$t('common.operate')">
            <el-table-column
              min-width="100"
              :label="$t('common.operate')"
            >
              <template slot-scope="scope">
                <el-link style="color: white" @click="showDetail(scope.row)">{{
                <el-link
                  style="color: white"
                  @click="showDetail(scope.row)"
                >{{
                  $t('common.details')
                }}</el-link>
                <el-link
                <el-link  v-if="btnStatus.update"
                  @click="editInfo(scope.row)"
                  style="margin-left: 10px; color: white"
                  >{{ $t('common.edit') }}</el-link
                >
                >{{ $t('common.edit') }}</el-link>
              </template>
            </el-table-column>
          </el-table>
        </div>
        <div style="margin-top: 10px" class="pagination_box">
        <div
          style="margin-top: 0px"
          class="pagination_box"
        >
          <el-pagination
            @size-change="handleSizeChange"
            @current-change="handleCurrentChange"
@@ -164,15 +216,27 @@
        </div>
      </div>
    </div>
    <div class="infoBox" v-show="showinfoBox">
    <div
      class="infoBox"
      v-show="showinfoBox"
    >
      <el-card class="box-card">
        <div slot="header" class="clearfix">
        <div
          slot="header"
          class="clearfix"
        >
          <span>{{ $t('common.details') }}</span>
          <div style="float: right; cursor: pointer" @click="closeDetial">
          <div
            style="float: right; cursor: pointer"
            @click="closeDetial"
          >
            <i class="el-icon-close"></i>
          </div>
        </div>
        <div class="contentBox">
        <div
          class="contentBox"
          style="padding:1%"
        >
          <p>{{ $t('dataManage.vmobj.name') }}：{{ itemdetail.name }}</p>
          <el-divider></el-divider>
          <p>{{ $t('dataManage.vmobj.format') }}：{{ itemdetail.type }}</p>
@@ -182,13 +246,21 @@
          <p>{{ $t('dataManage.vmobj.depName') }}：{{ itemdetail.depName }}</p>
          <el-divider></el-divider>
          <p>
            {{ $t('dataManage.vmobj.gather') }}：{{
              setInfoBoxTime(itemdetail.gather)
            {{ $t('dataManage.vmobj.dirName') }}：{{
              itemdetail.dirName
            }}
          </p>
          <el-divider></el-divider>
          <p>
            {{ $t('dataManage.vmobj.describe') }}：{{ itemdetail.describe }}
            {{ $t('dataManage.vmobj.versionNumber') }}：{{ itemdetail.verName }}
          </p>
          <el-divider></el-divider>
          <p>
            {{ $t('dataManage.vmobj.tab') }}：{{ itemdetail.tab }}
          </p>
          <el-divider></el-divider>
          <p>
            {{ $t('dataManage.vmobj.row') }}：{{ itemdetail.row }}
          </p>
          <el-divider></el-divider>
          <p>
@@ -226,24 +298,36 @@
      :visible.sync="dialogFormVisible"
      :before-close="handleClose"
    >
      <el-form :model="editForm" ref="editForm">
      <el-form
        :model="editForm"
        ref="editForm"
      >
        <el-form-item
          :label="$t('dataManage.vmobj.name')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="editForm.name" autocomplete="off"></el-input>
          <el-input
            v-model="editForm.name"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item
          :label="$t('dataManage.vmobj.format')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="editForm.type" autocomplete="off"></el-input>
          <el-input
            v-model="editForm.type"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item
          :label="$t('dataManage.vmobj.size')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="editForm.sizes" autocomplete="off"></el-input>
          <el-input
            v-model="editForm.sizes"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item
          :label="$t('dataManage.vmobj.depName')"
@@ -254,10 +338,10 @@
            v-model="editForm.depid"
            :options="companyOption"
            :props="cascader"
                 style="width:350px"
            style="width:350px"
          ></el-cascader>
        </el-form-item>
          <el-form-item
        <el-form-item
          :label="$t('dataManage.vmobj.dirName')"
          :label-width="formLabelWidth"
        >
@@ -273,7 +357,10 @@
          :label="$t('dataManage.vmobj.describe')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="editForm.describe" autocomplete="off"></el-input>
          <el-input
            v-model="editForm.describe"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <!-- <el-form-item
          :label="$t('dataManage.vmobj.gather')"
@@ -282,33 +369,94 @@
          <el-input v-model="editForm.gather" autocomplete="off"></el-input>
        </el-form-item> -->
      </el-form>
      <div v-if="behavior == '修改信息'" slot="footer" class="dialog-footer">
        <el-button size="medium" @click="cancelEdit()">{{
      <div
        v-if="behavior == '修改信息'"
        slot="footer"
        class="dialog-footer"
      >
        <el-button
             size="small"
          @click="cancelEdit()"
        >{{
          $t('common.reset')
        }}</el-button>
        <el-button
          size="medium"
              size="small"
          type="primary"
          @click="sendEdit('editForm')"
          v-loading.fullscreen.lock="fullscreenLoading"
          >{{ $t('common.submit') }}</el-button
        >
        >{{ $t('common.submit') }}</el-button>
      </div>
      <div v-else slot="footer" class="dialog-footer">
        <el-button size="medium" @click="cancelAdd('editForm')">{{
      <div
        v-else
        slot="footer"
        class="dialog-footer"
      >
        <el-button
              size="small"
          @click="cancelAdd('editForm')"
        >{{
          $t('common.reset')
        }}</el-button>
        <el-button
          size="medium"
              size="small"
          type="primary"
          @click="sendAdd('editForm')"
          v-loading.fullscreen.lock="fullscreenLoading"
          >{{ $t('common.submit') }}</el-button
        >
        >{{ $t('common.submit') }}</el-button>
      </div>
    </el-dialog>
    <div class="downloadBox" v-if="showCodeBox">
      <h4 style="padding: 20px">请输入下载包密码</h4>
    <el-dialog
      :title="$t('common.details')"
      :visible.sync="dialogVisible"
      width="70%"
    >
      <div style="height:600px">
        <el-table
          ref="filterTable"
          :data="dbTableData"
          height="90%"
          border
          style="width: 100%"
        >
          <el-table-column
            width="60"
            align="center"
            type="index"
            :label="$t('common.index')"
          />
          <el-table-column
            v-for="(item, index) in attributeData"
            :key="index"
            :label="item.alias"
            :prop="item.field"
            show-overflow-tooltip
            align="center"
          ></el-table-column>
        </el-table>
        <div
          style="margin-top: 10px"
          class="pagination_box"
        >
          <el-pagination
            @size-change="handleLoaderSizeChange"
            @current-change="handleLoaderCurrentChange"
            :current-page="listLoader.pageIndex"
            :page-sizes="[10, 20, 30, 40]"
            :page-size="listLoader.pageSize"
            layout="total, sizes, prev, pager, next, jumper"
            :total="count1"
          >
          </el-pagination>
        </div>
      </div>

    </el-dialog>
    <div
      class="downloadBox"
      v-if="showCodeBox"
    >
      <h4 style="padding: 20px">{{$t('common.passworld')}}</h4>
      <el-form
        :model="codeForm"
        :rules="rules"
@@ -316,26 +464,51 @@
        label-width="100px"
        class="codeForm"
      >
        <el-form-item label="密码" prop="password">
          <el-input type="password" v-model="codeForm.password"></el-input>
        <el-form-item
          :label="$t('common.passworld')"
          prop="password"
        >
          <el-input
            type="password"
            v-model="codeForm.password"
            show-password
          ></el-input>
        </el-form-item>
        <el-form-item label="确认密码" prop="repassword">
          <el-input type="password" v-model="codeForm.repassword"></el-input>
        <el-form-item
          :label="$t('common.SPassword')"
          prop="repassword"
        >
          <el-input
            type="password"
            v-model="codeForm.repassword"
            show-password
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-button type="primary" size="small" @click="download('codeForm')"
            >确定</el-button
          >
          <el-button type="info" size="small" @click="closeDown('codeForm')"
            >取消</el-button
          >
          <el-button
            class="primary"
            size="small"
            @click="download('codeForm')"
          >{{$t('common.confirm')}}</el-button>
          <el-button
            type="info"
            size="small"
            @click="closeDown('codeForm')"
          >{{$t('common.cancel')}}</el-button>
        </el-form-item>
      </el-form>
    </div>
    <iframe
      id="downFrame"
      src=""
      style="display: none; border: 0; padding: 0; height: 0; width: 0"
    ></iframe>
  </div>
</template>

<script>
import $ from 'jquery'
import { getToken } from '@/utils/auth';
import {
  select_meta_ByPageAndCount,
  // queryDataCount,
@@ -344,9 +517,14 @@
  insertMeta,
  selectDictTab,
  selectdirTab,
  queryDepTree,

  selectdepTab,
  meta_downloadReq,
  sign_getPublicKey,
  meta_selectDownloadFile,
  meta_selectFields,
  meta_selectByPageForUpload
} from '../../api/api';

import MyBread from '../../components/MyBread.vue';
export default {
  name: 'metadataManage',
@@ -361,13 +539,25 @@
        callback();
      }
    };
    var passwordValidator = (rule, value, callback) => {
      var passwordreg =
        /^(?![a-zA-Z]+$)(?![A-Z0-9]+$)(?![A-Z\W!@#$%^&*`~()\\-_+=,.?;<>]+$)(?![a-z0-9]+$)(?![a-z\W!@#$%^&*`~()\\-_+=,.?;<>]+$)(?![0-9\W!@#$%^&*`~()\\-_+=,.?;<>]+$)[a-zA-Z0-9\W!@#$%^&*`~()\\-_+=,.?;<>]{12,20}$/;
      if (!passwordreg.test(value)) {
        callback(
          new Error('密码必须由数字、字母、特殊字符组合,请输入13-20位')
        );
      } else {
        callback();
      }
    };
    return {
       defaultProps: {
      defaultProps: {
        children: 'children',
        label: 'name',
      },
dirComPanyOption:[],
      dirComPanyOption: [],
      companyOption: [],
      companyOption1: [],
      activeName: '',
      optionCount: [],
      showCodeBox: false,
@@ -381,6 +571,8 @@
      itemdetail: {},
      queryForm: {
        name: '',
        dirid: '',
        depid: ''
      },
      behavior: '',
      initialForm: '',
@@ -389,13 +581,14 @@
        repassword: '',
      },
      rules: {
        password: [{ required: true, message: '请输入密码', trigger: 'blur' }],
        password: [{ required: true, message: '请输入密码', trigger: 'blur' }, { validator: passwordValidator, trigger: 'blur' }],
        repassword: [
          { required: true, message: '请输入确认密码', trigger: 'blur' },
          { validator: repasswordValidator, trigger: 'blur' },
        ],
      },
      tableData: [],
      dbTableData: [],
      count: 0,
      currentPage: 1,
      pageSize: 10,
@@ -412,7 +605,8 @@
        pageSize: 10,
        pageIndex: 1,
        name: null,
        dirid:null,
        dirid: null,
        depid: null
      },
      cascader: {
        label: 'name',
@@ -421,24 +615,127 @@
        checkStrictly: true,
        emitPath: false,
      },
      dialogVisible: false,
      listLoader: {
        id: null,
        pageSize: 1,
        pageSize: 10,
      },
      count1: 0,
      attributeData: [],
    };
  },
  created() {

    this.getSelectDictTab();
    // this.getSelectDictTab();
    this.showPermsBtn();
    this.getQueryDepTree();

    this.signGetPublicKey();

  },

  methods: {
    async detail(res) {
      var val = res.tab.split(".");
      const data = await meta_selectFields({
        ns: val[0],
        tab: val[1]
      })

      if (data.code != 200) {
        this.$message.error('字段列表调用失败');
        return
      }

      this.dialogVisible = true;


      this.attributeData = data.result;

      this.listLoader = {
        id: res.id,
        pageIndex: 1,
        pageSize: 10,
      }
      this.getDataLoaderSelectDbData();
    },

    async getDataLoaderSelectDbData() {
      const data1 = await meta_selectByPageForUpload(this.listLoader);
      if (data1.code != 200) {
        this.$message.error('字段列表调用失败');
        return
      }

      var option = data1.result;
      for (var i in option) {
        option[i].dirid = option[i].dirName;
        option[i].depid = option[i].depName;
        option[i].createuser = option[i].createName;
        option[i].updateuser = option[i].updateName;
        option[i].verid = option[i].verName;
        if (option[i].createtime != null) {
          option[i].createtime = this.setInfoBoxTime(option[i].createtime)
        }
        if (option[i].updatetime != null) {
          option[i].updatetime = this.setInfoBoxTime(option[i].updatetime)
        }

      }
      this.dbTableData = data1.result;
      this.count1 = data1.count;
    },
    handleLoaderSizeChange(val) {
      this.listLoader.pageIndex = 1;
      this.listLoader.pageSize = val;
      this.getDataLoaderSelectDbData();
    },
    handleLoaderCurrentChange(val) {
      this.listLoader.pageIndex = val;
      this.getDataLoaderSelectDbData();
    },

    async signGetPublicKey() {
      const res = await sign_getPublicKey();
      if (res && res.code == 200) {
        window.encrypt = new JSEncrypt();
        encrypt.setPublicKey(res.result);
      }
    },
    //单位列表获取
    async getQueryDepTree() {
      const res = await queryDepTree();
      const res = await selectdepTab();
      if (res.code != 200) {
        this.$message.error('单位列表获取失败');
        return;
      }
      // this.formInline.depid = 1;
      this.companyOption1 = this.treeData(res.result);
      this.queryForm.depid = this.companyOption1[0].id
          this.getQueryDirTree();
        
    },
    async getQueryDirTree() {
      const res = await selectdirTab();
      if (res.code != 200) {
        this.$message.error('单位列表获取失败');
        return;
      }
      this.companyOption = this.treeData(res.result);
      this.queryForm.dirid = this.companyOption[0].id
         this.getMetaData();
    },
    handleChange(value) {
      this.listData.pageSize = 10;
      this.listData.pageIndex = 1;
      this.queryForm.dirid = value;
      this.getMetaData();
    },
    handleChange1(value) {
      this.listData.pageSize = 10;
      this.listData.pageIndex = 1;
      this.queryForm.depid = value;
      this.getMetaData();
    },
    //格式化列表
    formatData(row, column) {
@@ -504,16 +801,16 @@
      if (res.code != 200) {
        this.$message.error('列表调用失败');
      }
      this.optionCount =this.treeData(res.result);
      this.dirComPanyOption= this.treeData(res.result);
      this.listData.dirid=this.optionCount[0].id;
       this.getMetaData();
      this.optionCount = this.treeData(res.result);
      this.dirComPanyOption = this.treeData(res.result);
      this.listData.dirid = this.optionCount[0].id;
   
    },
    handleNodeClick(data) {
      this.listData.pageSize=10;
      this.listData.pageSize = 10;
      this.listData.pageIndex = 1;
      this.listData.dirid = data.id;
        this.getMetaData();
      this.getMetaData();
    },
    getTableDesc(res) {
      this.activeName = res.tab;
@@ -560,8 +857,12 @@
    // },
    // 请求数据内容
    getMetaData() {
      this.listData.depid = this.queryForm.depid;
      this.listData.dirid = this.queryForm.dirid;
      // this.listData.dirid = 57
 
      select_meta_ByPageAndCount(this.listData).then((res) => {

  
        this.tableData = res.result;
        this.count = res.count;
      });
@@ -579,6 +880,8 @@
      this.listData.pageSize = 10;
      this.listData.pageIndex = 1;
      this.listData.name = null;
      this.queryForm.dirid = this.companyOption[0].id;
      this.queryForm.depid = this.companyOption1[0].id
      this.getMetaData();
    },
    //新增按钮
@@ -689,7 +992,7 @@
          this.editForm = {};
          done();
        })
        .catch((_) => {});
        .catch((_) => { });
    },

    // 提交修改
@@ -728,7 +1031,38 @@
        this.editForm = JSON.parse(this.initialForm);
      });
    },
    download() {},
    async download() {
      var std = [];
      for (var i in this.multipleSelection) {
        std.push(this.multipleSelection[i].id)
      }
      var obj = {
        pwd: encrypt.encrypt(this.codeForm.repassword),
        ids: std
      };
      const res = await meta_downloadReq(JSON.stringify(obj))

      if (res.code != 200) {
        this.$message.error('下载请求失败');
        return
      }

      var downObj = {
        guid: res.result,
        pwd: encodeURIComponent(encrypt.encrypt(this.codeForm.repassword))
      }
      const data = await meta_selectDownloadFile(downObj)

      if (data.code != 200) {
        this.$message.error('下载请求失败');
        return
      }
      var token = getToken()
      var url = BASE_URL + "/meta/downloadFile?token=" + token + "&guid=" + res.result + "&pwd=" + encodeURIComponent(encrypt.encrypt(this.codeForm.repassword));

      $("#downFrame").attr("src", url).click();
      this.closeDown();
    },
    closeDown() {
      this.showCodeBox = false;
      this.codeForm.password = '';
@@ -767,10 +1101,9 @@
<style lang="less" scoped>
//@import url(); 引入公共css类
.authorityManagement_box {
  height: 81%;
  width: 97%;
  position: absolute;
  box-sizing: border-box;
  height: 98%;
  width: 98%;
  padding: 1%;

  .inquire {
    position: relative;
@@ -811,8 +1144,8 @@
      }
    }
    .rightTable {
      width: 80%;
      height: 100%;
      width: 98%;
      height: 92%;
      border: 1px solid white;

      border-radius: 5px;
@@ -864,12 +1197,13 @@
  .downloadBox {
    position: absolute;
    top: 20%;
    left: 50%;
    left: 40%;
    padding: 20px;

    width: 20%;
    border: 1px solid #000;
    background: #303030;
    width: 30%;
    border: 1px solid gray;
    border-radius: 10px;
    color: white;
  }
  /*修改table 表体的背景颜色和文字颜色*/
  /deep/ .el-table {
@@ -994,4 +1328,12 @@
    color: white;
  }
}
/deep/ .el-select .el-input__inner {
  border-color: #fff !important;
}
/deep/.el-input__inner {
  background-color: transparent !important ;
  color: #fff;
  border: 1px solid white !important;
}
</style>