VTABLE 基本表和透视表的分页功能

基本表和VTable数据分析透视表支持分页,但透视组合图不支持分页。
配置项:

  • pagination.totalCount:数据项的总数。数据透视表中的VTable字段将被自动补充,以帮助用户获取数据项的总数。
  • pagination.perPageCount:显示每页的数据项数。注意!数据透视表中的perPageCount将自动更正为指示器数量的整数倍。
  • pagination.currentPage:当前页码。

方法:Methods.updatePagination,更新页码配置信息,调用后会自动重绘。

 /**
   * Update page number
   * @param pagination The information of the page number to be modified
   */
  updatePagination(pagination: IPagination): void;

IPagination type define:

/**
 *Paging configuration
 */
export interface IPagination {
  /** The total number of data, this data in the pivot table will be automatically added without user input */
  totalCount?: number;
  /** Display number of data items per page */
  perPageCount: number;
  /** Display number of items per page */
  currentPage?: number;
}

使用:

const tableInstance = shallowRef();
tableInstance.value = new ListTable(listTableRef.value, option);
tableInstance.value.updatePagination({
perPageCount: number;
    currentPage: pageNumber
  });

基本表(ListTable)的分页
在这里插入图片描述
基于百万级数据的秒级渲染的demo做的分页, https://visactor.io/vtable/demo/performance/100W
分页html相关代码:

<div style="width: 1580px; height: 50px" class="right-align">
            <button id="first-buttom" > 首页</button>
            <button id="prev-buttom" > 上一页</button>
            <span id="page-namber">第1页</span>
            <input id="cpnr" type="hidden">
            <span>/</span>
            <span id="total-page">共 页</span>
            <input id="mpnr" type="hidden">
            <button id="next-buttom">下一页</button>
            <button id="tail-buttom" > 尾页</button>
            <span id="total-num">共 条</span>
            <input  id="spn" type="number" >
            <button id="skip-buttom"> 跳转</button>
        </div>

分页js相关代码:

  const option = {
    records,
    columns,
    widthMode: "standard",
    pagination:{
        perPageCount:15,
        currentPage:0,
    },
  };
  
  onMounted(() => {
    tableInstance.value = new ListTable(listTableRef.value, option);
    //分页相关代码
    let pageNumber = 0;
    const totalNum = option.records.length;
    const pageSize =option.pagination.perPageCount;
    const pageNumberSpan = document.getElementById("page-namber");
    const totalPageSpan = document.getElementById("total-page");
    const totalNumSpan = document.getElementById("total-num");

    const totalPg = Math.ceil(totalNum/pageSize);//总页数
    totalPageSpan.innerHTML='共'+totalPg+'页';
    totalNumSpan.innerHTML='共'+totalNum+'条';


    document.getElementById("prev-buttom").addEventListener("click", () => {
    if (pageNumber === 0) {
        return;
    }
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("first-buttom").addEventListener("click", () => {
    pageNumber=1;
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });

    document.getElementById("tail-buttom").addEventListener("click", () => {
    pageNumber=totalPg-1;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });


    document.getElementById("next-buttom").addEventListener("click", () => {
    if (pageNumber === (totalPg-1)) {
        return;
    }
    pageNumber++;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("skip-buttom").addEventListener("click", () => {
    debugger
    let specificPageNum = document.getElementById("spn").value;//要跳转的页
    if (specificPageNum > totalPg) {
        pageNumber=totalPg-1;
        document.getElementById("spn").value=totalPg;
    }else{
        pageNumber = specificPageNum-1
    }
    if (specificPageNum <= 0) {
        pageNumber=0;
        document.getElementById("spn").value =1;
    }
    
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    tableInstance.value.on("click_cell", (params) => {
      console.log(params);
    });
  });

整体页面代码:

<template>
    <div>
        <div ref="listTableRef" style="width: 1580px; height: 700px"></div>
        <div style="width: 1580px; height: 50px" class="right-align">
            <button id="first-buttom" > 首页</button>
            <button id="prev-buttom" > 上一页</button>
            <span id="page-namber">1</span>
            <input id="cpnr" type="hidden">
            <span>/</span>
            <span id="total-page">共 页</span>
            <input id="mpnr" type="hidden">
            <button id="next-buttom">下一页</button>
            <button id="tail-buttom" > 尾页</button>
            <span id="total-num">共 条</span>
            <input  id="spn" type="number" >
            <button id="skip-buttom"> 跳转</button>
        </div>
    </div>
  </template>
  
  <script setup>
  import { onMounted, ref, shallowRef } from "vue";
  import { ListTable } from "@visactor/vtable";
  
  const listTableRef = ref();
  const tableInstance = shallowRef();
  
  function generateRandomString(length) {
  let result = '';
  const characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
  for (let i = 0; i < length; i++) {
    result += characters.charAt(Math.floor(Math.random() * characters.length));
  }
  return result;
}
function generateRandomHobbies() {
  const hobbies = [
    'Reading books',
    'Playing video games',
    'Watching movies',
    'Cooking',
    'Hiking',
    'Traveling',
    'Photography',
    'Playing musical instruments',
    'Gardening',
    'Painting',
    'Writing',
    'Swimming'
  ];

  const numHobbies = Math.floor(Math.random() * 3) + 1; // 生成 1-3 之间的随机整数
  const selectedHobbies = [];

  for (let i = 0; i < numHobbies; i++) {
    const randomIndex = Math.floor(Math.random() * hobbies.length);
    const hobby = hobbies[randomIndex];
    selectedHobbies.push(hobby);
    hobbies.splice(randomIndex, 1); // 确保每个爱好只选一次
  }

  return selectedHobbies.join(', ');
}
function generateRandomBirthday() {
  const start = new Date('1970-01-01');
  const end = new Date('2000-12-31');
  const randomDate = new Date(start.getTime() + Math.random() * (end.getTime() - start.getTime()));
  const year = randomDate.getFullYear();
  const month = randomDate.getMonth() + 1;
  const day = randomDate.getDate();
  return `${year}-${month < 10 ? '0' + month : month}-${day < 10 ? '0' + day : day}`;
}

function generateRandomPhoneNumber() {
  const areaCode = ['130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '150', '151', '152', '153', '155', '156', '157', '158', '159', '170', '176', '177', '178', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189'];
  const prefix = areaCode[Math.floor(Math.random() * areaCode.length)];
  const suffix = String(Math.random()).substr(2, 8);
  return prefix + suffix;
}

const generatePersons = (count) => {
  return Array.from(new Array(count)).map((_, i) => {
    const first=generateRandomString(10);
    const last=generateRandomString(4);
    return {
    id: i+1,
    email1: `${first}_${last}@xxx.com`,
    name: first,
    lastName: last,
    hobbies: generateRandomHobbies(),
    birthday: generateRandomBirthday(),
    tel: generateRandomPhoneNumber(),
    sex: i % 2 === 0 ? 'boy' : 'girl',
    work: i % 2 === 0 ? 'back-end engineer' : 'front-end engineer',
    city: 'beijing',
  }});
};


const records = generatePersons(1000000);
const columns = [
  {
    field: 'id',
    title: 'ID',
    width: 80,
    sort: true,
  },
  {
    field: 'email1',
    title: 'email',
    width: 250,
    sort: true,
  },
  {
    field: 'full name',
    title: 'Full name',
    columns: [
      {
        field: 'name',
        title: 'First Name',
        width: 120,
      },
      {
        field: 'lastName',
        title: 'Last Name',
        width: 100,
      },
    ],
  },
  {
    field: 'hobbies',
    title: 'hobbies',
    width: 200,
  },
  {
    field: 'birthday',
    title: 'birthday',
    width: 120,
  },
  {
    field: 'sex',
    title: 'sex',
    width: 100,
  },
  {
    field: 'tel',
    title: 'telephone',
    width: 150,
  },
  {
    field: 'work',
    title: 'job',
    width: 200,
  },
  {
    field: 'city',
    title: 'city',
    width: 150,
  },
];
  
  const option = {
    records,
    columns,
    widthMode: "standard",
    pagination:{
        perPageCount:15,
        currentPage:0,
    },
  };
  
  onMounted(() => {
    tableInstance.value = new ListTable(listTableRef.value, option);
    //分页相关代码
    let pageNumber = 0;
    const totalNum = option.records.length;
    const pageSize =option.pagination.perPageCount;
    const pageNumberSpan = document.getElementById("page-namber");
    const totalPageSpan = document.getElementById("total-page");
    const totalNumSpan = document.getElementById("total-num");

    const totalPg = Math.ceil(totalNum/pageSize);//总页数
    totalPageSpan.innerHTML='共'+totalPg+'页';
    totalNumSpan.innerHTML='共'+totalNum+'条';


    document.getElementById("prev-buttom").addEventListener("click", () => {
    if (pageNumber === 0) {
        return;
    }
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("first-buttom").addEventListener("click", () => {
    pageNumber=1;
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });

    document.getElementById("tail-buttom").addEventListener("click", () => {
    pageNumber=totalPg-1;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });


    document.getElementById("next-buttom").addEventListener("click", () => {
    if (pageNumber === (totalPg-1)) {
        return;
    }
    pageNumber++;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("skip-buttom").addEventListener("click", () => {
    debugger
    let specificPageNum = document.getElementById("spn").value;//要跳转的页
    if (specificPageNum > totalPg) {
        pageNumber=totalPg-1;
        document.getElementById("spn").value=totalPg;
    }else{
        pageNumber = specificPageNum-1
    }
    if (specificPageNum <= 0) {
        pageNumber=0;
        document.getElementById("spn").value =1;
    }
    
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    tableInstance.value.on("click_cell", (params) => {
      console.log(params);
    });
  });
  </script>
  
  <style scoped>
    .right-align {
    float: right; /* 让元素浮动到右边 */
    }
</style>  

透视表分页:
注:.pagination.totalCount数据总条数:透视表中这个字段 VTable 会自动补充,帮助用户获取到总共数据条数
在这里插入图片描述
整体页面代码:

<template>
    <div>
      <div ref="pivotTableRef" style="width: 1580px; height: 800px"></div>
      <div style="width: 1580px; height: 50px" class="right-align">
        <button id="first-buttom" > 首页</button>
        <button id="prev-buttom" > 上一页</button>
        <span id="page-namber">1</span>
        <input id="cpnr" type="hidden">
        <span>/</span>
        <span id="total-page">共 页</span>
        <input id="mpnr" type="hidden">
        <button id="next-buttom">下一页</button>
        <button id="tail-buttom" > 尾页</button>
        <span id="total-num">共 条</span>
        <input  id="spn" type="number" >
        <button id="skip-buttom"> 跳转</button>
    </div>
    </div>
  </template>
  
  <script setup>
  import { onMounted, ref, shallowRef } from "vue";
  import { PivotTable } from "@visactor/vtable";
  
  const pivotTableRef = ref();
  const tableInstance = shallowRef();
  
  const records = [
    {
      sales: 891,
      number: 7789,
      province: "浙江省",
      city: "杭州市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 792,
      number: 2367,
      province: "浙江省",
      city: "绍兴市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 893,
      number: 3877,
      province: "浙江省",
      city: "宁波市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 1094,
      number: 4342,
      province: "浙江省",
      city: "舟山市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 1295,
      number: 5343,
      province: "浙江省",
      city: "杭州市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 496,
      number: 632,
      province: "浙江省",
      city: "绍兴市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 1097,
      number: 7234,
      province: "浙江省",
      city: "宁波市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 998,
      number: 834,
      province: "浙江省",
      city: "舟山市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 766,
      number: 945,
      province: "浙江省",
      city: "杭州市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 990,
      number: 1304,
      province: "浙江省",
      city: "绍兴市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 891,
      number: 1145,
      province: "浙江省",
      city: "宁波市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 792,
      number: 1432,
      province: "浙江省",
      city: "舟山市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 745,
      number: 1343,
      province: "浙江省",
      city: "杭州市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 843,
      number: 1354,
      province: "浙江省",
      city: "绍兴市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 895,
      number: 1523,
      province: "浙江省",
      city: "宁波市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 965,
      number: 1634,
      province: "浙江省",
      city: "舟山市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 776,
      number: 1723,
      province: "四川省",
      city: "成都市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 634,
      number: 1822,
      province: "四川省",
      city: "绵阳市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 909,
      number: 1943,
      province: "四川省",
      city: "南充市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 399,
      number: 2330,
      province: "四川省",
      city: "乐山市",
      category: "家具",
      sub_category: "桌子",
    },
    {
      sales: 700,
      number: 2451,
      province: "四川省",
      city: "成都市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 689,
      number: 2244,
      province: "四川省",
      city: "绵阳市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 500,
      number: 2333,
      province: "四川省",
      city: "南充市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 800,
      number: 2445,
      province: "四川省",
      city: "乐山市",
      category: "家具",
      sub_category: "沙发",
    },
    {
      sales: 1044,
      number: 2335,
      province: "四川省",
      city: "成都市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 689,
      number: 245,
      province: "四川省",
      city: "绵阳市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 794,
      number: 2457,
      province: "四川省",
      city: "南充市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 566,
      number: 2458,
      province: "四川省",
      city: "乐山市",
      category: "办公用品",
      sub_category: "笔",
    },
    {
      sales: 865,
      number: 4004,
      province: "四川省",
      city: "成都市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 999,
      number: 3077,
      province: "四川省",
      city: "绵阳市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 999,
      number: 3551,
      province: "四川省",
      city: "南充市",
      category: "办公用品",
      sub_category: "纸张",
    },
    {
      sales: 999,
      number: 352,
      province: "四川省",
      city: "乐山市",
      category: "办公用品",
      sub_category: "纸张",
    },
  ];
  
  const option = {
    rows: ["province", "city"],//行表头对应各级维度的样式及format配置。
    columns: ["category", "sub_category"],//列表头对应各级维度的样式及format配置。
    indicators: ["sales", "number"],//透视表中各个指标的具体配置。
    enableDataAnalysis: true,
    indicatorTitle: "指标名称",//指标标题,显示在角头位置的标题。
    indicatorsAsCol: false,//指标是否作为列表头展示,指标值以列展示,默认为true。
    hideIndicatorName:false,//是否需要将表头上的指标名称隐藏掉。默认为 false。
    showRowHeader:true,//是否显示行表头,默认为 true。
    showColumnHeader:true,//是否显示列表头,默认为 true。
    corner: { //角表头各项配置及样式自定义。
      titleOnDimension: "row" ,//角头标题显示内容依据:'column' 列维度名称作为角头单元格内容,'row' 行维度名称作为角头单元格内容,'none' 角头单元格内容为空
      headerType:"text",//表头类型,可指为'text'|'image'|'link'。
      headerStyle:{//表头单元格样式
        bgColor:'red'
      }
  },
    records: records,
    widthMode:'autoWidth', // 宽度模式:standard 标准模式; adaptive 自动填满容器
    pagination:{
    perPageCount:10,
    currentPage:0,
     },
  };
  
  onMounted(() => {
    tableInstance.value = new PivotTable(pivotTableRef.value, option);
   //分页相关代码
    let pageNumber = 0;
    // const totalNum = option.records.length;
    const totalNum = option.pagination.totalCount;
    const pageSize =option.pagination.perPageCount;
    const pageNumberSpan = document.getElementById("page-namber");
    const totalPageSpan = document.getElementById("total-page");
    const totalNumSpan = document.getElementById("total-num");

    const totalPg = Math.ceil(totalNum/pageSize);//总页数
    totalPageSpan.innerHTML='共'+totalPg+'页';
    totalNumSpan.innerHTML='共'+totalNum+'条';
    document.getElementById("prev-buttom").addEventListener("click", () => {
    if (pageNumber === 0) {
        return;
    }
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("first-buttom").addEventListener("click", () => {
    pageNumber=1;
    pageNumber--;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });
    document.getElementById("tail-buttom").addEventListener("click", () => {
    pageNumber=totalPg-1;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    document.getElementById("spn").value ='';
    });
    document.getElementById("next-buttom").addEventListener("click", () => {
    if (pageNumber === (totalPg-1)) {
        return;
    }
    pageNumber++;
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    document.getElementById("skip-buttom").addEventListener("click", () => {
    debugger
    let specificPageNum = document.getElementById("spn").value;//要跳转的页
    if (specificPageNum > totalPg) {
        pageNumber=totalPg-1;
        document.getElementById("spn").value=totalPg;
    }else{
        pageNumber = specificPageNum-1
    }
    if (specificPageNum <= 0) {
        pageNumber=0;
        document.getElementById("spn").value =1;
    }
    
    tableInstance.value.updatePagination({
        currentPage: pageNumber
    });
    pageNumberSpan.innerHTML = '第'+(pageNumber+1)+'页';
    });
    tableInstance.value.on("click_cell", (params) => {
      console.log(params);
    });
  });
  </script>
  
  <style scoped>
    .right-align {
    float: right; /* 让元素浮动到右边 */
    }
</style>
  
  • 10
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值