Source/UBCS-WEB/src/components/BatchImport/ShowImportData.vue

@@ -6,8 +6,23 @@
    append-to-body

    top="5vh"

  >

    <!-- <div>

      <FormTemplate

        v-if="type === 'batchApplyCode'"

        type="add"

        :selfColumnType="selfColumnType"

        :selfColumnConfig="selfColumnConfig"

        ref="CodeApply"

        @getFormData="getCodeApplyFormData"

        @referConfigDataUpdate="referConfigDataUpdate"

      ></FormTemplate>

    </div> -->

    <div class="flex_box">

      <div class="left" :style="{ width: leftWidth }">

      <div

        class="left"

        :style="{ width: leftWidth + 'px' }"

        v-show="type !== 'batchImportApply'"

      >

        <div class="isExpand_box">

          <el-link type="primary" @click="hideTree">

            <i

@@ -27,6 +42,7 @@
          v-show="isExpand"

          class="filter_tree"

          :data="leftTree"

          node-key="codeClassifyOid"

          default-expand-all

          highlight-current

          :filter-node-method="filterNode"

@@ -38,85 +54,108 @@
        >

        </el-tree>

      </div>

      <div class="right">

        <div class="tab_box">

      <div class="right" :style="{ width: 1280 - leftWidth - 60 + 'px' }">

        <div class="tab_box" style="width: 100%">

          <el-tabs

            style="width: 100%"

            v-model="activeTab"

            type="card"

            @tab-click="handleClick"

            size="small"

          >

            <el-tab-pane label="有相似项" name="resemble">

            <el-tab-pane :label="tab1Name" name="tab1">

              <el-table

                border

                :data="resembleData"

                :data="tab1Table"

                style="width: 100%"

                height="400px"

                highlight-current-row

                @current-change="resembleRowChange"

                @selection-change="tab1TableSelectChange"

                v-if="cloNamesList.length > 1"

              >

                <el-table-column

                  type="selection"

                  width="100px"

                  align="center"

                ></el-table-column>

                <el-table-column

                  type="index"

                  label="序号"

                  width="100px"

                  align="center"

                ></el-table-column>

                <el-table-column

                  v-for="item in cloNamesList"

                  :key="item.field"

                  :prop="item.field"

                  :label="item.title"

                  :width="item.width"

                  align="center"

                >

                </el-table-column>

              </el-table>

              <div v-else style="height: 400px"></div>

              <div>

                <el-table

                  border

                  :data="currentSelectedResemble"

                  style="width: 100%"

                  height="200px"

                >

                  <el-table-column

                    v-for="item in resembleColumList"

                    :key="item.field"

                    :prop="item.field"

                    :label="item.title"

                    :minWidth="item.minWidth"

                    align="center"

                  >

                    <template #default="{ row }">

                      <span v-if="item.field === 'id'">

                        <el-link

                          type="primary"

                          @click="openFormTemlpate(row)"

                          >{{ row[item.field] }}</el-link

                        >

                      </span>

                      <span v-else>

                        {{ row[item.field] }}

                      </span>

                    </template>

                  </el-table-column>

                  <el-table-column

                    v-show="resembleColumList.length > 0"

                    prop="rowIndex"

                    label="excel行数"

                    align="center"

                  ></el-table-column>

                </el-table>

              </div>

            </el-tab-pane>

            <el-tab-pane label="正确数据" name="success">

              <el-table border :data="successData" height="400px">

            <el-tab-pane :label="tab2Name" name="tab2">

              <el-table border :data="tab2Table" height="600px">

                <el-table-column

                  v-for="item in cloNamesList"

                  :key="item.field"

                  :prop="item.field"

                  :label="item.title"

                  :width="item.width"

                  align="center"

                >

                </el-table-column>

              </el-table>

            </el-tab-pane>

          </el-tabs>

        </div>

        <div>

          <el-table

            border

            :data="currentSelectedResemble"

            style="width: 100%"

            height="200px"

          >

            <el-table-column

              v-for="item in resembleColumList"

              :key="item.field"

              :prop="item.field"

              :label="item.title"

              :minWidth="item.minWidth"

            >

              <template #default="{ row }">

                <span v-if="item.field === 'id'">

                  <el-link type="primary" @click="openFormTemlpate(row)">{{

                    row[item.field]

                  }}</el-link>

                </span>

                <span v-else>

                  {{ row[item.field] }}

                </span>

              </template>

            </el-table-column>

            <el-table-column

              v-show="resembleColumList.length > 0"

              prop="rowIndex"

              label="excel行数"

            ></el-table-column>

          </el-table>

        </div>

      </div>

    </div>

    <template #footer>

      <div>

        <el-button size="small" type="primary">确定导入</el-button>

        <el-button size="small">取消</el-button>

        <el-button size="small" type="primary" @click="submit"

          >确定导入</el-button

        >

        <el-button size="small" @click="dialogVisible = false">取消</el-button>

      </div>

    </template>

    <FormTemplateDialog

@@ -131,15 +170,20 @@


<script>

import {

  getHistorySuccessTable,

  getHistoryResembleTable,

  getSuccessTable,

  getResembleTable,

  getFormTemplate,

  getCurretnSelectedRowResemble,

  submitHistoryimport,

} from "../../api/batchImport/index";

import ResembleQuery from "../FormTemplate/ResembleQuery.vue";

import FormTemplate from "../FormTemplate/FormTemplate.vue";

import codeApply from "@/mixins/codeApply.js";



export default {

  name: "ShowImportData",

  components: { ResembleQuery },

  components: { ResembleQuery, FormTemplate },

  // mixins: [codeApply],

  props: {

    title: {

      type: String,

@@ -153,6 +197,19 @@
    redisOid: {

      type: String,

      default: "",

    },

    classifyAttr: {

      type: String,

      default: "id",

    },

    codeClassifyOid: {

      type: String,

      default: "",

    },

    type: String,

    secDTOList: {

      type: Array,

      default: () => ({}),

    },

  },

  computed: {

@@ -169,127 +226,17 @@
    return {

      isExpand: true,

      filterText: "",

      leftWidth: "200px",

      data: [

        {

          id: 1,

          label: "一级 1",

          children: [

            {

              id: 4,

              label: "二级 1-1",

              children: [

                {

                  id: 9,

                  label: "三级 1-1-1",

                },

                {

                  id: 10,

                  label: "三级 1-1-2",

                },

              ],

            },

          ],

        },

        {

          id: 2,

          label: "一级 2",

          children: [

            {

              id: 5,

              label: "二级 2-1",

            },

            {

              id: 6,

              label: "二级 2-2",

            },

          ],

        },

        {

          id: 3,

          label: "一级 3",

          children: [

            {

              id: 7,

              label: "二级 3-1",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

            {

              id: 8,

              label: "二级 3-2",

            },

          ],

        },

      ],

      resembleData: [],

      successData: [],

      activeTab: "resemble",

      cloNamesList: [],

      codeClassifyOid: "",

      resembleColumList: [],

      leftWidth: 200,

      templateOid: null,

      tab1Name: "相似项",

      tab2Name: "正确数据",

      tab1Table: [],

      selectedTab1Table: [],

      tab2Table: [],

      activeTab: "tab1",

      cloNamesList: [], //列表头部字段

      localCodeClassifyOid: "",

      resembleColumList: [], //相似项查出来的列表字段

      currentSelectedResemble: [],

      currentSelectedResembleRow: {

        templateOid: "",

@@ -297,6 +244,7 @@
        rowOid: "",

        formTemplateVisible: false,

      },

      secVOList: [],

    };

  },



@@ -307,286 +255,105 @@
    },

    hideTree() {

      if (this.isExpand) {

        this.leftWidth = "50px";

        this.leftWidth = 50;

      } else {

        this.leftWidth = "200px";

        this.leftWidth = 200;

      }

      this.isExpand = !this.isExpand;

    },

    treeNodeClick(data) {

      this.codeClassifyOid = data.codeclassifyoid;

      console.log(data);

      this.localCodeClassifyOid = data.codeClassifyOid;

      this.cloNamesList = data.cloNamesList;

      getHistorySuccessTable(this.redisOid).then((res) => {

        this.successData = res.data

        // this.successData = [

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH007",

        //     caigouwl: "是",

        //     oid: "433DFA8E-4445-18F4-AC95-85E7EE1C92CF",

        //     kucunwl: "是",

        //     tuhao: "TH006",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试4",

        //     jiliangdw: "个",

        //     oldcode: "z0004",

        //     id: "0201020013",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH006",

        //     caigouwl: "是",

        //     oid: "E94E3320-841F-AE87-1D56-D6B3398D0FFC",

        //     kucunwl: "是",

        //     tuhao: "TH005",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试3",

        //     jiliangdw: "个",

        //     oldcode: "z0003",

        //     id: "0201020012",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH003",

        //     caigouwl: "是",

        //     oid: "D2E0A166-A774-BE6F-A9C7-3277467CE8EC",

        //     kucunwl: "是",

        //     tuhao: "TH003",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试2",

        //     jiliangdw: "个",

        //     oldcode: "z0002",

        //     id: "0201020011",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH002",

        //     caigouwl: "是",

        //     oid: "291CD01A-F18D-2D95-5291-D2C80ED57CC8",

        //     kucunwl: "是",

        //     tuhao: "TH002",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试1",

        //     jiliangdw: "个",

        //     oldcode: "z0001",

        //     id: "0201020010",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH001",

        //     caigouwl: "是",

        //     oid: "FED83315-F2B4-C603-2AC2-11B0DF3029A6",

        //     kucunwl: "是",

        //     tuhao: "TH001",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺栓",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试6",

        //     jiliangdw: "个",

        //     oldcode: "z0006",

        //     id: "0201010019",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH005",

        //     caigouwl: "是",

        //     oid: "3E120284-8EC2-9BF4-D1AB-579380DFA085",

        //     kucunwl: "是",

        //     tuhao: "TH005",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺栓",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试5",

        //     jiliangdw: "个",

        //     oldcode: "z0005",

        //     id: "0201010018",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH004",

        //     caigouwl: "是",

        //     oid: "2EB3B122-2FE4-A236-53F2-9B67E40332AC",

        //     kucunwl: "是",

        //     tuhao: "TH004",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺栓",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试4",

        //     jiliangdw: "个",

        //     oldcode: "z0004",

        //     id: "0201010017",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH009",

        //     caigouwl: "是",

        //     oid: "8940A341-8041-E031-6FE1-A18526C62DE9",

        //     kucunwl: "是",

        //     tuhao: "TH008",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试6",

        //     jiliangdw: "个",

        //     oldcode: "z0006",

        //     id: "0201020015",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH008",

        //     caigouwl: "是",

        //     oid: "936CBC1E-2FD0-5CD7-C331-64B86204FD78",

        //     kucunwl: "是",

        //     tuhao: "TH007",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试5",

        //     jiliangdw: "个",

        //     oldcode: "z0005",

        //     id: "0201020014",

        //   },

        // ];

      });

      getHistoryResembleTable({

        codeClassifyOid: data.codeClassifyOid,

      this.templateOid = data.oid;

      getResembleTable({

        codeClassifyOid: this.templateOid,

        redisOid: this.redisOid + "-resemble",

      }).then((res) => {

        console.log(res);

        this.resembleData = res.data

        // this.resembleData = [

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH007",

        //     caigouwl: "是",

        //     oid: "FC2F0D9F-8B2E-5A19-3BDE-22107F373EB3",

        //     kucunwl: "是",

        //     tuhao: "TH006",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试4",

        //     jiliangdw: "个",

        //     oldcode: "z0004",

        //     id: "0201020013",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH007",

        //     caigouwl: "是",

        //     oid: "B92CFF46-1D46-E680-66C4-33A3ABE77A6C",

        //     kucunwl: "是",

        //     tuhao: "TH005",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试3",

        //     jiliangdw: "个",

        //     oldcode: "z0003",

        //     id: "0201020012",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH15",

        //     caigouwl: "是",

        //     oid: "B383C30E-D201-01F2-89EE-6F751EFA0AA1",

        //     kucunwl: "是",

        //     tuhao: "TH008",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试6",

        //     jiliangdw: "个",

        //     oldcode: "z0006",

        //     id: "0201020015",

        //   },

        //   {

        //     xiaoshouwl: "是",

        //     xinghaoguige: "XH17",

        //     caigouwl: "是",

        //     oid: "1C379116-F27B-3F20-DFC3-74A39B87E505",

        //     kucunwl: "是",

        //     tuhao: "TH007",

        //     codeSecLengthField: "6#4",

        //     codeclsfid: "紧固件#螺母",

        //     materialtype: "材料",

        //     chukufangshi: "先进先出",

        //     hesuanfenlei: "原材料",

        //     name: "测试5",

        //     jiliangdw: "个",

        //     oldcode: "z0005",

        //     id: "0201020014",

        //   },

        // ];

        this.tab1Table = res.data.data;

      });

      // 获取正确数据

      getSuccessTable({

        codeClassifyOid: this.templateOid,

        redisOid: this.redisOid + "-ok",

      }).then((res) => {

        this.tab2Table = res.data.data;

      });

      getFormTemplate({

        templateOid: data.oid,

        codeClassifyOid: data.codeClassifyOid,

        codeClassifyOid: this.localCodeClassifyOid,

      }).then((res) => {

        this.resembleColumList = res.data.resembleTableVO.cols[0];

      });

    },

    tab1TableSelectChange(selection) {

      this.selectedTab1Table = selection;

    },

    resembleRowChange(row) {

      getCurretnSelectedRowResemble({

        redisOid: this.redisOid + "-resemble-data",

        dataOid: row.oid,

      }).then((res) => {

        this.currentSelectedResemble = res.data

        // this.currentSelectedResemble = [

        //   {

        //     xinghaoguige: "XH007",

        //     codetemplateoid: "f441b131-5ea0-4672-ab74-735b11161928",

        //     rowIndex: "9",

        //     id: "0201020012",

        //     oid: "B92CFF46-1D46-E680-66C4-33A3ABE77A6C",

        //   },

        // ];

        this.currentSelectedResemble = res.data.data;

      });

    },

    openFormTemlpate(row) {

      this.currentSelectedResembleRow = {

        visible: true,

        templateOid: row.codetemplateoid,

        codeClassifyOid: this.codeClassifyOid,

        codeClassifyOid: this.localCodeClassifyOid,

        rowOid: row.rowOid,

      }

      };

    },

    submit() {

      const params = {

        classifyAttr:

          this.type === "historyImport" ? this.classifyAttr : undefined,

        improt: this.type === "historyImport" ? true : false,

        codeImprotSaveDatVOList: [

          {

            Clos: this.cloNamesList.map((item) => item.title),

            dataList: this.tab2Table.concat(this.selectedTab1Table),

            orderDTO: {

              codeClassifyOid: this.codeClassifyOid,

              templateOid: this.templateOid,

              secDTOList: this.secDTOList,

            },

          },

        ],

      };

      submitHistoryimport(params).then((res) => {

        console.log(res);

        if (res.data.code === 200) {

          this.$message.success(res.data.msg);

        } else {

          this.$message.error(res.data.msg);

        }

      });

    },

  },

  watch: {

    filterText(val) {

      this.$refs.tree.filter(val);

    },

    leftTree: {

      immediate: true,

      deep: true,

      handler(arr) {

        if (arr.length > 0) {

          this.treeNodeClick(arr[0]);

          this.$nextTick(() => {

            this.$refs.tree.setCurrentKey(arr[0]["codeClassifyOid"]);

          });

          if (this.type === "batchImportApply") {

            this.leftWidth = 0;

          } else if (this.type === "batchApplyCode") {

            this.tab1Name = "有相似项或错误数据";

            this.tab2Name = "正确数据";

            this.leftWidth = 200;

          }

        }

      },

    },

  },

};

@@ -595,13 +362,15 @@
<style lang="scss" scoped>

.flex_box {

  display: flex;

  width: 1280px;

  .left {

    transition: all 0.3s;

    transition: all 0.5s;

    .isExpand_box {

      margin-bottom: 10px;

      text-align: right;

    }

    .filter_tree {

      margin-top: 15px;

      max-height: 400px;

      overflow-y: scroll;

    }

@@ -609,7 +378,6 @@
  .right {

    margin-left: 20px;

    margin-top: 30px;

    width: 1000px;

  }

}

</style>