el-table合计行在滚动条下方的问题

1,633 阅读1分钟

el-table中设置了show-summary会出现合计栏,因为表格列比较多,会导致滚动条在合计栏的上面,需要对css进行调整。

微信截图_20230805110806.png

微信截图_20230805111340.png

解决方法:
要将整个table滚动,不是只对表格内容区域滚动,所以将表头、表内容、表尾的滚动条设为visible。因此需要在el-table外面再套一个盒子,让整个table有滚动条。 需要另外写一个<style></style>标签,不要加scoped属性,否则不生效。

 <div class="container">
    <el-table :data="tableData" border :summary-method="getSummaries" show-summary>
    <!-- ... -->
    </el-table>
  </div>
<style>
.container .el-table {
  overflow: auto;
}
.container .el-table--scrollable-x .el-table__body-wrapper,
.container .el-table__header-wrapper,
.container .el-table__footer-wrapper {
  overflow: visible;
}
.container .el-table::after {
  position: relative !important;
}
</style>

实现效果如下,但是整个表格进行拖动的时候,会导致表格列el-table-columnfixed属性失效。

微信截图_20230805115936.png

如果要实现滚动条在合计行下方,同时兼容fixed属性,经过多番查找,终于找到了一篇博客确实可以实现需求,整合了一下代码如下:

<template>
  <div class="container">
    <el-table
      :data="tableData"
      ref="elTable"
      border
      :summary-method="getSummaries"
      show-summary
    >
      <el-table-column
        label="班级/科目"
        align="center"
        prop="grade"
        width="150"
      />
      <el-table-column
        v-for="(item, index) in headerList"
        :key="index"
        :label="item.label"
        align="center"
        width="120"
      >
        <template slot-scope="scope">
          <span>{{ scope.row.options[index].num }}</span>
        </template>
      </el-table-column>
      <el-table-column
        label="班级人数汇总"
        align="center"
        prop="sum"
        width="180"
      />
    </el-table>
  </div>
</template>

<script>
import { throttle } from "throttle-debounce";
export default {
  data() {
    return {
      tableData: [],
      headerList: [],
    };
  },
  computed: {
    bodyWrapper() {
      return this.$refs.elTable.$refs.bodyWrapper;
    },
    footerWrapper() {
      return this.$refs.elTable.$refs.footerWrapper;
    },
    fixedWrapper() {
      return this.$refs.elTable.$refs.fixedWrapper;
    },
    elTableRefs() {
      return this.$refs.elTable.$refs;
    },
  },
  destroyed() {
    // 退出时去除自定义scroll事件
    this.unbindEvents();
  },
  mounted() {
    this.getList();
    this.$nextTick(() => {
      // 样式调整,fixed布局下fixed列的高度会有偏差
      let fixedWrapper = this.$refs.elTable.$refs.fixedWrapper
        ? this.$refs.elTable.$refs.fixedWrapper
        : "";
      let rightFixedWrapper = this.$refs.elTable.$refs.rightFixedWrapper
        ? this.$refs.elTable.$refs.rightFixedWrapper
        : "";
      fixedWrapper &&
        (fixedWrapper.style.maxHeight = this.$refs.elTable.layout.viewportHeight
          ? this.$refs.elTable.layout.viewportHeight + "px"
          : "");
      rightFixedWrapper &&
        (rightFixedWrapper.style.maxHeight = this.$refs.elTable.layout
          .viewportHeight
          ? this.$refs.elTable.layout.viewportHeight + "px"
          : "");
    });
    // 自定义scroll事件
    this.bindEvents();
    // 去除原本的scroll事件
    this.$refs.elTable.unbindEvents();
  },
  methods: {
    getSummaries(param) {
      const { columns, data } = param;
      const sums = [];
      columns.forEach((column, index) => {
        if (index === 0) {
          sums[index] = "科目人数汇总";
          return;
        }
        const values = data.map((item) => {
          const sameObj = item.options.find(
            (val) => val.label === columns[index].label
          );
          return sameObj ? Number(sameObj.num) : 0;
        });
        if (
          !values.every((value) => isNaN(value)) &&
          column.property !== "sum"
        ) {
          sums[index] = values.reduce((prev, curr) => {
            const value = Number(curr);
            if (!isNaN(value)) {
              return prev + curr;
            } else {
              return prev;
            }
          }, 0);
        } else {
          sums[index] = "";
        }
      });
      return sums;
    },
    getList() {
      this.tableData = [
        {
          id: 1,
          grade: "高一(1)",
          options: [
            { label: "语文", num: 200 },
            { label: "数学", num: 200 },
            { label: "英语", num: 200 },
            { label: "物理", num: 150 },
            { label: "历史", num: 80 },
            { label: "历史2", num: 80 },
            { label: "历史3", num: 80 },
            { label: "历史4", num: 80 },
            { label: "历史5", num: 80 },
            { label: "历史6", num: 80 },
            { label: "历史7", num: 80 },
            { label: "历史8", num: 80 },
          ],
        },
        {
          id: 1,
          grade: "高一(2)",
          options: [
            { label: "语文", num: 150 },
            { label: "数学", num: 150 },
            { label: "英语", num: 150 },
            { label: "物理", num: 70 },
            { label: "历史", num: 50 },
            { label: "历史2", num: 80 },
            { label: "历史3", num: 80 },
            { label: "历史4", num: 80 },
            { label: "历史5", num: 80 },
            { label: "历史6", num: 80 },
            { label: "历史7", num: 80 },
            { label: "历史8", num: 80 },
          ],
        },
      ];
      this.headerList = this.tableData[0].options.map((item) => {
        return { label: item.label };
      });
      this.tableData = this.tableData.map((item) => {
        const sum = item.options.reduce((prev, curr) => {
          return prev + curr.num;
        }, 0);
        return {
          ...item,
          sum,
        };
      });
    },

    // TODO 使用 CSS transform
    // throttle    节流函数,组件自带的
    syncPostion: throttle(20, function () {
      const { scrollLeft, scrollTop, offsetWidth, scrollWidth } =
        this.footerWrapper;
      const {
        headerWrapper,
        bodyWrapper,
        footerWrapper,
        fixedBodyWrapper,
        rightFixedBodyWrapper,
      } = this.elTableRefs;
      console.log(footerWrapper, "footerWrapper");
      if (bodyWrapper) bodyWrapper.scrollLeft = scrollLeft;
      if (headerWrapper) headerWrapper.scrollLeft = scrollLeft;
      if (fixedBodyWrapper) fixedBodyWrapper.scrollTop = scrollTop;
      if (rightFixedBodyWrapper) rightFixedBodyWrapper.scrollTop = scrollTop;
      const maxScrollLeftPosition = scrollWidth - offsetWidth - 1;
      if (scrollLeft >= maxScrollLeftPosition) {
        this.scrollPosition = "right";
      } else if (scrollLeft === 0) {
        this.scrollPosition = "left";
      } else {
        this.scrollPosition = "middle";
      }
    }),
    // 绑定scroll事件
    bindEvents() {
      this.footerWrapper.addEventListener("scroll", this.syncPostion, {
        passive: true,
      });
    },
    // 解绑scroll事件
    unbindEvents() {
      this.footerWrapper.removeEventListener("scroll", this.syncPostion, {
        passive: true,
      });
    },
  },
};
</script>

<style scoped>
::v-deep .el-table__fixed-footer-wrapper tbody td.el-table__cell{
  border-top: none;
}
</style>
<style lang="less">
// 去除原本的进度条
.el-table__body-wrapper {
  overflow-x: hidden !important;
}

// 添加新的的进度条
.el-table__footer-wrapper {
  overflow-x: auto !important;

}
</style>

微信截图_20230805123303.png