WebDataRocks实现table电子表格透视网格筛选器代码
代码语言：html
所属分类：表格
代码描述：WebDataRocks实现table电子表格透视网格筛选器代码
代码标签： WebDataRocks table 电子 表格 透视 网格 筛选器 代码
下面为部分代码预览，完整代码请点击下载或在bfwstudio webide中打开
<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="UTF-8">
<style>
@import url("https://fonts.googleapis.com/css?family=Poppins");
body {
font-family: "Poppins", Roboto;
font-size: 18px;
background: #ededed;
}
main {
width: 1000px;
margin: 10px auto;
padding: 30px;
background: #fff;
box-shadow: 0 3px 5px rgba(0, 0, 0, 0.2);
}
h1 {
text-align: center;
margin-top: 0px;
color: #009688;
}
span {
color: #009688;
}
h4 {
font-size: 17px;
margin-bottom: 10px;
}
p {
font-size: 15px;
margin-bottom: 10px;
}
p.details {
color: #888888;
}
.content {
position: relative;
display: flex;
align-items: center;
gap: 40px;
}
ul {
list-style: none;
margin-left: 0;
padding-left: 0;
}
li h4:before {
font-family: webdatarocks-icons;
content: "\e90e";
color: #009688;
padding-right: 5px;
}
</style>
</head>
<body translate="no">
<link type="text/css" rel="stylesheet" href="//repo.bfw.wiki/bfwrepo/css/webdatarocks.1.4.15.css">
<script type="text/javascript" src="//repo.bfw.wiki/bfwrepo/js/webdatarocks.toolbar.1.4.15.js"></script>
<script type="text/javascript" src="//repo.bfw.wiki/bfwrepo/js/webdatarocks.1.4.15.js"></script>
<main>
<h1>WebDataRocks Pivot Grid Filters</h1>
<div id="wdr-component"></div>
<div class="content">
<div class="note">
<h3> WebDataRocks supports <span>three</span> types of filters: </h3>
<ul>
<li>
<h4>Filtering by member names.</h4>
<p>Use it to show the values of the specific members.</p>
<p class="details"><span>Date.Month</span> field is filtered by Spring months.</p>
</li>
<li>
<h4>Filtering by values.</h4>
<p>Also known as the Top/Bottom X filter.
Use it to keep records within a specified range (with values higher or lower than a specified number).</p>
<p class="details"><span>Date.Year</span> field shows Top 5 sum of Sales.</p>
</li>
<li>
<h4>A report filter.</h4>
<p>Use it to apply filtering to the entire report.</p>
<p class="details">Aircraft and Bikes are excluded from <span>Category</span> field.</p>
</li>
</ul>
</div>
</div>
</main>
<script >
var pivot = new WebDataRocks({
container: "#wdr-component",
//toolbar: true,
width: 980,
height: 480,
report: {
dataSource: {
dataSourceType: "json",
data: getSalesData() },
slice: {
reportFilters: [
{
uniqueName: "Category",
filter: {
members: ["Category.Aircraft", "Category.Bikes"],
negation: true } }],
rows: [
{
uniqueName: "Date.Year",
filter: {
type: "top",
quantity: 5,
measure: "Sales" },
sort: "unsorted" },
{
uniqueName: "Date.Month",
filter: {
members: ["Date.Month.February", "Date.Month.January"],
negation: true } }],
columns: [
{
uniqueName: "Country" },
{
uniqueName: "Measures" }],
measures: [
{
uniqueName: "Sales",
aggregation: "sum",
format: "currency" }],
sorting: {
column: {
type: "desc",
tuple: [],
measure: "Sales" } },
expands: {
rows: [
{
tuple: ["Date.Year.2018"] },
{
tuple: ["Date.Year.2014"] }] } },
formats: [
{
name: "",
maxDecimalPlaces: 2 },
{
name: "currency",
thousandsSeparator: " ",
decimalSeparator: ".",
currencySymbol: "$",
currencySymbolAlign: "left",
nullValue: "",
textAlign: "right",
isPercent: false }] } });
function getSalesData() {
return [
{
Country: "Canada",
Category: "Aircraft",
Sales: 204,
Date: "2018-01-02",
Profit: 216 },
{
Country: "Germany",
Category: "Clothing",
Sales: 292,
Date: "2018-01-02",
Profit: 644 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-01-02",
Sales: 901,
Profit: 237 },
{
Country: "Canada",
Category: "Wood",
Date: "2018-01-02",
Sales: 348 },
{
Country: "Canada",
Category: "Clothing",
Date: "2018-01-02",
Sales: 725,
Profit: 335 },
{
Country: "Canada",
Category: "Clothing",
Date: "2018-02-02",
Sales: 780,
Profit: 687 },
{
Country: "Germany",
Category: "Wood",
Date: "2018-02-02",
Sales: 62,
Profit: 378 },
{
Country: "Germany",
Category: "Bikes",
Date: "2018-02-02",
Sales: 125,
Profit: 340 },
{
Country: "Germany",
Category: "Clothing",
Date: "2018-02-02",
Sales: 190,
Profit: 980 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-02-02",
Sales: 140,
Profit: 255 },
{
Country: "Canada",
Category: "Bikes",
Date: "2018-02-02",
Sales: 140,
Profit: 236 },
{
Country: "Canada",
Category: "Cars",
Date: "2018-03-02",
Sales: 588,
Profit: 770 },
{
Country: "Canada",
Category: "Clothing",
Date: "2018-03-02",
Sales: 470,
Profit: 255 },
{
Country: "Germany",
Category: "Cars",
Date: "2018-03-02",
Sales: 365,
Profit: 1400 },
{
Country: "Canada",
Category: "Bikes",
Date: "2018-03-02",
Sales: 320,
Profit: 1032 },
{
Country: "Germany",
Category: "Clothing",
Date: "2018-03-02",
Sales: 900,
Profit: 800 },
{
Country: "Germany",
Category: "Cars",
Date: "2018-03-02",
Sales: 700,
Profit: 800 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-03-02",
Sales: 320,
Profit: 500 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-03-02",
Sales: 365,
Profit: 240 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-04-02",
Sales: 522,
Profit: 200 },
{
Country: "Germany",
Category: "Clothing",
Date: "2018-04-02",
Sales: 292,
Profit: 644 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2018-04-02",
Sales: 260,
Profit: 700 },
{
Country: "Canada",
Category: "Wood",
Date: "2018-04-02",
Sales: 348,
Profit: 500 },
{
Country: "Canada",
Category: "Clothing",
Date: "2017-05-02",
Sales: 566,
Profit: 870 },
{
Country: "Canada",
Category: "Clothing",
Date: "2017-05-02",
Sales: 350,
Profit: 400 },
{
Country: "Germany",
Category: "Wood",
Date: "2017-05-02",
Sales: 900,
Profit: 1200 },
{
Country: "Germany",
Category: "Wood",
Date: "2017-02-02",
Sales: 62,
Profit: 378 },
{
Country: "Germany",
Category: "Bikes",
Date: "2017-02-02",
Sales: 125,
Profit: 340 },
{
Country: "Germany",
Category: "Clothing",
Date: "2017-02-02",
Sales: 190,
Profit: 980 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2017-02-02",
Sales: 140,
Profit: 255 },
{
Country: "Canada",
Category: "Bikes",
Date: "2017-02-02",
Sales: 140,
Profit: 236 },
{
Country: "Canada",
Category: "Cars",
Date: "2017-03-02",
Sales: 588,
Profit: 770 },
{
Country: "Canada",
Category: "Clothing",
Date: "2017-03-02",
Sales: 470,
Profit: 255 },
{
Country: "Germany",
Category: "Cars",
Date: "2017-03-02",
Sales: 365,
Profit: 1400 },
{
Country: "Canada",
Category: "Bikes",
Date: "2017-03-02",
Sales: 320,
Profit: 1032 },
{
Country: "Germany",
Category: "Clothing",
Date: "2015-03-02",
Sales: 900,
Profit: 800 },
{
Country: "Germany",
Category: "Cars",
Date: "2015-03-02",
Sales: 700,
Profit: 800 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2015-03-02",
Sales: 320,
Profit: 500 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2015-03-02",
Sales: 365,
Profit: 240 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2015-04-02",
Sales: 522,
Profit: 200 },
{
Country: "Germany",
Category: "Clothing",
Date: "2015-04-02",
Sales: 292,
Profit: 644 },
{
Country: "Canada",
Category: "Aircraft",
Date: "2015-04-02",
Sales: 260,
Profit: 700 },
{
Country: "Canada",
Category: "Wood",
Date: "2015-04-02",
Sales: 348,
Profit: 500 },
{
Country: "Canada",
Category: "Clothing",
Date: "2015-05-02",
Sales: 566,
Profit: 870 },
{
Country: "Canada",
Categor.........完整代码请登录后点击上方下载按钮下载查看
热门代码搜索
其他语言代码库
Html代码库
Python代码库
Java代码库
Php代码库
Phpcli代码库
Golang代码库
C#代码库
Nodejs代码库
C代码库
C++代码库
Sql代码库
R代码库
Rust代码库
Ruby代码库
Dart代码库
Vb代码库
D代码库
F#代码库
Typescript代码库
Coffeescript代码库
Julia代码库
Kotlin代码库
Perl代码库
Groovy代码库
Lua代码库
Vala代码库
Ocaml代码库
Assembly代码库
Objectc代码库
Scala代码库
Erlang代码库
Pascal代码库
Swift代码库
Fortran代码库
Bash代码库
Clojure代码库
Ada代码库
Elixir代码库
Cobol代码库
Haskell代码库
Nim代码库
Racket代码库
Lisp代码库
网友评论0