权限

lxl

2022-10-27 f6ebd1820968db8521bed86d25b183efe7eb877b

 src/views/datamanage/dictionaryManage.vue

@@ -1,15 +1,23 @@
<template>
  <div class="authorityManagement_box">
    <My-bread :list="['数据管理', '字典管理']"></My-bread>
    <My-bread
      :list="[
        `${$t('dataManage.dataManage')}`,
        `${$t('dataManage.dictionaryManage')}`,
      ]"
    ></My-bread>
    <el-divider />
    <div class="searchComp">
      <el-form ref="ruleForm" :model="ruleForm" :inline="true">
        <el-form-item label="表名称" prop="name">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.tableName')"
          prop="name"
        >
          <el-select
            clearable
            v-model="queryName"
            @change="changeQueryName"
            placeholder="请选择表名称"
            :placeholder="$t('dataManage.dictionaryManageObj.selectTableName')"
          >
            <el-option
              v-for="(item, i) in selectData"
@@ -23,17 +31,19 @@
        <el-form-item>
          <el-button
            @click="InsertFormdialog = true"
            v-if="btnStatus.insert"
            icon="el-icon-edit"
            type="success"
            size="small"
            >新增</el-button
            >{{ $t("dataManage.dictionaryManageObj.add") }}</el-button
          >
          <el-button
            v-if="btnStatus.delete"
            @click="DelFormData"
            icon="el-icon-delete"
            type="danger"
            size="small"
            >删除</el-button
            >{{ $t("dataManage.dictionaryManageObj.del") }}</el-button
          >
        </el-form-item>
      </el-form>
@@ -49,52 +59,86 @@
            height="98%"
          >
            <el-table-column type="selection" width="55" />
            <el-table-column prop="orderNum" label="编号" />
            <el-table-column min-width="100" prop="field" label="字段名称" />
            <el-table-column min-width="90" prop="alias" label="字段显示名称" />
            <el-table-column min-width="100" prop="type" label="字段类型" />
            <el-table-column min-width="60" prop="len" label="字段长度" />
            <el-table-column min-width="60" prop="precision" label="字段精度" />
            <el-table-column min-width="100" prop="tab" label="值域关联表" />
            <el-table-column min-width="100" prop="bak" label="备注" />
            <el-table-column
              prop="orderNum"
              :label="$t('dataManage.dictionaryManageObj.number')"
            />
            <el-table-column
              min-width="100"
              prop="field"
              :label="$t('dataManage.dictionaryManageObj.fieldName')"
            />
            <el-table-column
              min-width="90"
              prop="alias"
              :label="$t('dataManage.dictionaryManageObj.fieldAliasName')"
            />
            <el-table-column
              min-width="100"
              prop="type"
              :label="$t('dataManage.dictionaryManageObj.fieldType')"
            />
            <el-table-column
              min-width="60"
              prop="len"
              :label="$t('dataManage.dictionaryManageObj.fieldLength')"
            />
            <el-table-column
              min-width="60"
              prop="precision"
              :label="$t('dataManage.dictionaryManageObj.FieldPrecision')"
            />
            <el-table-column
              min-width="100"
              prop="tab"
              :label="
                $t('dataManage.dictionaryManageObj.rangeAssociationTable')
              "
            />
            <el-table-column
              min-width="100"
              prop="bak"
              :label="$t('dataManage.dictionaryManageObj.remark')"
            />
            <el-table-column
              min-width="100"
              prop="createTime"
              label="创建时间"
              :label="$t('dataManage.dictionaryManageObj.creationTime')"
              :formatter="formatData"
            />
            <el-table-column
              min-width="100"
              prop="createUser"
              label="创建人员"
              :label="$t('dataManage.dictionaryManageObj.createPersonnel')"
            />
            <el-table-column
              min-width="100"
              prop="updateTime"
              label="更新时间"
              :label="$t('dataManage.dictionaryManageObj.updateTime')"
              :formatter="formatData"
            />
            <el-table-column
              min-width="100"
              prop="updateUser"
              label="更新人员"
              :label="$t('dataManage.dictionaryManageObj.updatePersonnel')"
            />

            <el-table-column min-width="70" label="操作">
            <el-table-column
              min-width="70"
              :label="$t('dataManage.dictionaryManageObj.operation')"
            >
              <template slot-scope="scope">
                <el-link @click="showDetail(scope.$index, scope.row)"
                  >查看</el-link
                <el-link
                  v-if="btnStatus.select"
                  @click="showDetail(scope.$index, scope.row)"
                  >{{ $t("dataManage.dictionaryManageObj.lookOver") }}</el-link
                >
                <el-link
                  v-if="btnStatus.update"
                  @click="handleEdit(scope.$index, scope.row)"
                  style="margin-left: 10px"
                  >修改</el-link
                  >{{ $t("dataManage.dictionaryManageObj.revamp") }}</el-link
                >
                <!-- <el-link
                  @click="handleDelete(scope.$index, scope.row)"
                  style="margin-left: 10px"
                  >删除</el-link
                > -->
              </template>
            </el-table-column>
          </el-table>
@@ -119,56 +163,113 @@
    <div class="infoBox" v-show="showinfoBox">
      <el-card class="box-card">
        <div slot="header" class="clearfix">
          <span>详细信息</span>
          <span>{{ $t("dataManage.dictionaryManageObj.particulars") }}</span>
          <div style="float: right; cursor: pointer" @click="closeDetial">
            <i class="el-icon-close"></i>
          </div>
        </div>
        <div class="contentBox">
          <p>表名称：{{ itemdetail.tab }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.tableName") }}：{{
              itemdetail.tab
            }}
          </p>
          <el-divider></el-divider>
          <p>表显示名称：{{ itemdetail.tabDesc }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.tableAliasName") }}：{{
              itemdetail.tabDesc
            }}
          </p>
          <el-divider></el-divider>
          <!-- <p>表类型：{{ itemdetail.type }}</p>
          <el-divider></el-divider> -->
          <p>字段名称：{{ itemdetail.field }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.fieldName") }}：{{
              itemdetail.field
            }}
          </p>
          <el-divider></el-divider>
          <p>字段显示名称：{{ itemdetail.alias }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.fieldAliasName") }}：{{
              itemdetail.alias
            }}
          </p>
          <el-divider></el-divider>
          <p>字段类型：{{ itemdetail.type }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.fieldType") }}：{{
              itemdetail.type
            }}
          </p>
          <el-divider></el-divider>
          <p>字段长度：{{ itemdetail.len }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.fieldLength") }}：{{
              itemdetail.len
            }}
          </p>
          <el-divider></el-divider>
          <p>字段精度：{{ itemdetail.precision }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.FieldPrecision") }}：{{
              itemdetail.precision
            }}
          </p>
          <el-divider></el-divider>
          <!-- <p>值域关联表：{{ itemdetail.domain_name }}</p>
          <el-divider></el-divider> -->
          <p>备注：{{ itemdetail.bak }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.remark") }}：{{
              itemdetail.bak
            }}
          </p>
          <el-divider></el-divider>
          <p>创建时间：{{ itemdetail.createTime }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.creationTime") }}：{{
              itemdetail.createTime
            }}
          </p>
          <el-divider></el-divider>
          <p>创建人员：{{ itemdetail.createUser }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.createPersonnel") }}：{{
              itemdetail.createUser
            }}
          </p>
          <el-divider></el-divider>
          <p>更新时间：{{ itemdetail.updateTime }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.updateTime") }}：{{
              itemdetail.updateTime
            }}
          </p>
          <el-divider></el-divider>
          <p>更新人员：{{ itemdetail.updateUser }}</p>
          <p>
            {{ $t("dataManage.dictionaryManageObj.updatePersonnel") }}：{{
              itemdetail.updateUser
            }}
          </p>
        </div>
      </el-card>
    </div>
    <el-dialog
      top="3vh"
      style="overflow: hidden"
      title="修改详情"
      :title="$t('dataManage.dictionaryManageObj.revamp')"
      :visible.sync="dialogFormVisible"
    >
      <el-form :model="upform">
        <el-form-item label="编号" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.number')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.orderNum" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表名" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.tableName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.tab" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表别名" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.tableAliasName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.tabDesc" autocomplete="off"></el-input>
        </el-form-item>
        <!-- <el-form-item label="类型" :label-width="formLabelWidth">
@@ -182,56 +283,81 @@
            <el-option label="面几何" value="面几何"></el-option>
          </el-select>
        </el-form-item> -->
        <el-form-item label="字段名称" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.field" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段别名" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldAliasName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.alias" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段类型" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldType')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.type" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="长度" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldLength')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.len" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="精度" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.FieldPrecision')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.precision" autocomplete="off"></el-input>
        </el-form-item>
        <!-- <el-form-item label="值域名称" :label-width="formLabelWidth">
          <el-input v-model="upform.domain_name" autocomplete="off"></el-input>
        </el-form-item> -->
        <el-form-item label="备注" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.remark')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="upform.bak" autocomplete="off"></el-input>
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="dialogFormVisible = false">取 消</el-button>
        <el-button type="primary" @click="updateForm">确 定</el-button>
        <el-button @click="dialogFormVisible = false">{{
          $t("dataManage.dictionaryManageObj.cancel")
        }}</el-button>
        <el-button type="primary" @click="updateForm">{{
          $t("dataManage.dictionaryManageObj.confirm")
        }}</el-button>
      </div>
    </el-dialog>
    <el-dialog
      title="添加数据"
      :title="$t('dataManage.dictionaryManageObj.add')"
      top="3vh"
      style="overflow: hidden"
      :visible.sync="InsertFormdialog"
    >
      <el-form :model="insertform">
        <el-form-item label="编号" :label-width="formLabelWidth">
          <el-input v-model="insertform.oid" autocomplete="off"></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.number')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.orderNum" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表名" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.table_name"
            autocomplete="off"
          ></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.tableName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.tab" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表别名" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.table_alias"
            autocomplete="off"
          ></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.tableAliasName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.tabDesc" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="类型" :label-width="formLabelWidth">
        <!-- <el-form-item label="类型" :label-width="formLabelWidth">
          <el-select
            v-model="insertform.table_type"
            style="width: 100%"
@@ -241,47 +367,60 @@
            <el-option label="线几何" value="线几何"></el-option>
            <el-option label="面几何" value="面几何"></el-option>
          </el-select>
        </el-form-item> -->
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.field" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段名称" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.field_name"
            autocomplete="off"
          ></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldAliasName')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.alias" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段别名" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.field_alias"
            autocomplete="off"
          ></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldType')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.type" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段类型" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.field_type"
            autocomplete="off"
          ></el-input>
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.fieldLength')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.len" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="长度" :label-width="formLabelWidth">
          <el-input v-model="insertform.length" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="精度" :label-width="formLabelWidth">
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.FieldPrecision')"
          :label-width="formLabelWidth"
        >
          <el-input
            v-model="insertform.precision"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item label="值域名称" :label-width="formLabelWidth">
        <!-- <el-form-item label="值域名称" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.domain_name"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item label="备注" :label-width="formLabelWidth">
          <el-input v-model="insertform.remarks" autocomplete="off"></el-input>
        </el-form-item> -->
        <el-form-item
          :label="$t('dataManage.dictionaryManageObj.remark')"
          :label-width="formLabelWidth"
        >
          <el-input v-model="insertform.bak" autocomplete="off"></el-input>
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="InsertFormdialog = false">取 消</el-button>
        <el-button type="primary" @click="insertFromData">确 定</el-button>
        <el-button @click="InsertFormdialog = false">{{
          $t("dataManage.dictionaryManageObj.cancel")
        }}</el-button>
        <el-button type="primary" @click="insertFromData">{{
          $t("dataManage.dictionaryManageObj.confirm")
        }}</el-button>
      </div>
    </el-dialog>
  </div>
@@ -293,6 +432,7 @@
  selectDictTab,
  deleteDicts,
  updateDict,
  insertDict,
} from "../../api/api";
import MyBread from "../../components/MyBread.vue";
export default {
@@ -322,13 +462,29 @@
        pageSize: 10,
      },
      selectData: [],
      btnStatus: {
        select: false,
        delete: false,
        upload: false,
        download: false,
        insert: false,
        update: false,
      },
    };
  },
  created() {
    this.startQueryNameData();
    this.getSelectDictTab();
    this.showPermsBtn();
  },
  methods: {
    showPermsBtn() {
      let currentPerms = this.$store.state.currentPerms;
      let permsEntity = this.$store.state.permsEntity;
      permsEntity
        .filter((item) => item.perms == currentPerms)
        .map((item) => (this.btnStatus[item.tag.substr(1)] = true));
    },
    //下拉选项调用
    async getSelectDictTab() {
      this.selectData = [];
@@ -391,47 +547,35 @@
    },
    //修改详情
    updateForm() {
      this.$confirm("是否确定保存修改内容?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
      this.$confirm(
        `${$t("dataManage.dictionaryManageObj.tipsUp")}`,
        `${$t("dataManage.dictionaryManageObj.tips")}`,
        {
          confirmButtonText: `${$t("dataManage.dictionaryManageObj.confirm")}`,
          cancelButtonText: `${$t("dataManage.dictionaryManageObj.cancel")}`,
          type: "warning",
        }
      )
        .then(async () => {
          const data = await updateDict(this.upform);
          if (data.code != 200) {
            this.$message.error("修改失败");
            this.$message.error(
              `${$t("dataManage.dictionaryManageObj.failModify")}`
            );
          }
          this.dialogFormVisible = false;
          this.startQueryNameData();
          this.$message({
            message: "修改成功",
            message: `${$t(
              "dataManage.dictionaryManageObj.modifySuccessfully"
            )}`,
            type: "success",
          });
        })
        .catch(() => {});
    },
    submitForm(formName) {
      this.$refs[formName].validate((valid) => {
        if (valid) {
          this.searchName = this.ruleForm.name.trim();
          this.count = 0;
          this.selectFromData(10, 1, this.searchName);
          this.countFromData(this.searchName);
        } else {
          console.log("error submit!!");
          return false;
        }
      });
    },
    resetForm(formName) {
      this.count = 0;
      this.pageSize = 1;
      this.pageNum = 10;
      this.selectFromData(10, 1, "");
      this.countFromData("");
      this.searchName = "";
      this.$refs[formName].resetFields();
    },

    //查看详情
    showDetail(index, row) {
      // console.log(index, row);
      this.showinfoBox = true;
@@ -447,21 +591,7 @@
      this.upform = row;
      console.log(this.upform);
    },
    handleDelete(index, row) {
      this.$confirm("确定是否删除所选内容?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(() => {
          this.$message({
            type: "success",
            message: "删除成功!",
          });
          this.startFromData();
        })
        .catch(() => {});
    },

    handleSizeChange(val) {
      console.log(val);
      // console.log(`每页 ${val} 条`);
@@ -472,20 +602,34 @@
      this.listData.pageIndex = val;
      this.startQueryNameData();
    },

    //新增
    insertFromData() {
      this.$confirm("是否确定添加?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(() => {
      this.$confirm(
        `${$t("dataManage.dictionaryManageObj.tipsAdd")}`,
        `${$t("dataManage.dictionaryManageObj.tips")}`,
        {
          confirmButtonText: `${$t("dataManage.dictionaryManageObj.confirm")}`,
          cancelButtonText: `${$t("dataManage.dictionaryManageObj.cancel")}`,
          type: "warning",
        }
      )
        .then(async () => {
          const data = await insertDict(this.insertform);
          if (data.code != 200) {
            this.$message.error(
              `${$t("dataManage.dictionaryManageObj.FailedAdd")}`
            );
          }
          this.InsertFormdialog = false;
          this.startQueryNameData();
          this.$message({
            message: `${$t("dataManage.dictionaryManageObj.NewSuccess")}`,
            type: "success",
          });
        })
        .catch(() => {});
    },
    countFromData(name) {},
    selectFromData(size, index, name) {},

    //列表选择
    handleSelectionChange(val) {
      this.multipleSelection = val;
@@ -497,31 +641,33 @@
      for (var i in this.multipleSelection) {
        std.push(this.multipleSelection[i].id);
      }
      this.$confirm("确定是否删除所选内容?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
      this.$confirm(
        `${$t("dataManage.dictionaryManageObj.tipsDelete")}`,
        `${$t("dataManage.dictionaryManageObj.tips")}`,
        {
          confirmButtonText: `${$t("dataManage.dictionaryManageObj.confirm")}`,
          cancelButtonText: `${$t("dataManage.dictionaryManageObj.cancel")}`,
          type: "warning",
        }
      )
        .then(async () => {
          const data = await deleteDicts({ ids: std.toString() });
          if (data.code != 200) {
            this.$message.error("列表删除失败");
            this.$message.error(
              `${$t("dataManage.dictionaryManageObj.DeleteFailed")}`
            );
          }
          this.$message({
            type: "success",
            message: "删除成功!",
            message: `${$t(
              "dataManage.dictionaryManageObj.deletedSuccessfully"
            )}`,
          });
          this.startFromData();
          this.startQueryNameData();
        })
        .catch(() => {});
    },
    startFromData() {
      this.count = 0;
      this.pageSize = 1;
      this.pageNum = 10;
      this.selectFromData(10, 1, this.searchName);
      this.countFromData(this.searchName);
    },

    //搜索框
    changeQueryName(val) {
      this.listData.tab = val;