基本表和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>