ピボットグリッド:詳細ダイアログ

PivotGridを使用すると、セル一覧にドリルダウンして各集計の計算に使用されたデータ項目を確認することができます。ユーザーは任意の値セルをダブルクリックして詳細ダイアログを呼び出すことができます。グリッドのshowDetailメソッドを呼び出してセルの座標を渡すことで詳細ダイアログを呼び出すこともできます。

import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import * as wjOlap from '@grapecity/wijmo.olap'; import * as wjCore from '@grapecity/wijmo'; import { getData } from './data'; // document.readyState === 'complete' ? init() : window.onload = init; // function init() { // // create a PivotEngine with a custom view var ngFmt = new wjOlap.PivotEngine({ autoGenerateFields: false, itemsSource: getData(10000), showColumnTotals: 'GrandTotals', showRowTotals: 'None', fields: [ { binding: 'product', header: '商品' }, { binding: 'date', header: '日付', format: 'yyyy\"Q\"q' }, { binding: 'sales', header: '売上', format: 'n0' }, { binding: 'sales', header: '差分', format: 'p0', showAs: 'DiffRowPct' } ], rowFields: ['日付'], columnFields: ['商品'], valueFields: ['売上', '差分'] }); // // toggle detail customization var customDetails = document.getElementById('customDetails'); // // show summary var pivotGrid = new wjOlap.PivotGrid('#pivotGrid', { isReadOnly: true, itemsSource: ngFmt, formatItem: formatItem // customize the grid cells }); // // show detail dialog on click document.getElementById('showDetail').addEventListener('click', function () { var sel = pivotGrid.selection; if (sel.isValid) { pivotGrid.showDetail(sel.row, sel.col); } else { alert('最初にピボットグリッドのセルを選択してください。'); } }); // // customize detail dialog var detailDialog = pivotGrid.detailDialog, detailGridHost = detailDialog.hostElement.querySelector('.wj-flexgrid'); var detailGrid = wjCore.Control.getControl(detailGridHost); // // format cells in the detail grid detailGrid.formatItem.addHandler(function (s, e) { if (e.panel == s.cells && customDetails.checked) { var large = false, small = false, val = s.getCellData(e.row, e.col, false); switch (s.columns[e.col].binding) { case 'sales': large = val > 18; small = val < 16; break; case 'downloads': large = val > 80; small = val < 60; break; } wjCore.toggleClass(e.cell, 'large-value', large); wjCore.toggleClass(e.cell, 'small-value', small); } }); // // customize dialog content when showing it detailDialog.showing.addHandler(function (s, e) { if (customDetails.checked) { // // customize summary info above the grid // the default format is this: // Row: <b>{rowHeader}</b></br> // Column: <b>{columnHeader}</b><br> // {cellHeader}: <b>{cellValue}</b> var summary = s.hostElement.querySelector('.wj-summary'), fmt = '<b>{rowHeader}</b>における' + '<b>{columnHeader}</b>の詳細: <b>{cellHeader}</b>は' + '<b>{cellValue}</b>です。'; summary.innerHTML = wjCore.format(fmt, s); // // sort detail grid by date var sds = detailGrid.collectionView.sortDescriptions; sds.push(new wjCore.SortDescription('date', false)); } }); // // item formatter for the grid function formatItem(s, e) { // // we are interested in the cells panel if (e.panel == s.cells) { // // remove color by default var color = ''; // // format diff columns if custom formatting is on if (e.col % 2 == 1) { var value = s.getCellData(e.row, e.col), glyph = 'circle', span = ' <span style="font-size:120%" class="wj-glyph-{glyph}"></span>'; color = '#d8b400'; if (value != null) { if (value < 0) { // negative variation color = '#9f0000'; glyph = 'down'; } else if (value > 0.05) { // positive variation color = '#4c8f00'; glyph = 'up'; } e.cell.innerHTML += span.replace('{glyph}', glyph); } } // // apply cell color e.cell.style.color = color; } } }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Grapecity Wijmo OLAP Pivot Grid Detail Dialog</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div class="container-fluid"> <p> <button id="showDetail" class="btn btn-primary"> 詳細ダイアログを表示 </button> </p> <p> グリッドは、<b>detailDialog</b>プロパティを通じて詳細ダイアログを表示します。このプロパティは、この例に示すようにダイアログをカスタマイズするために使用できます。 </p> <p> <label> カスタム詳細ダイアログ <input id="customDetails" type="checkbox" checked="checked"> </label> </p> <div id="pivotGrid"></div> </div> </body> </html>
// gets a simple data set for basic demos export function getData(cnt) { var year = new Date().getFullYear(), data = []; for (var i = 0; i < cnt; i++) { data.push({ product: randomInt(0, 1) ? 'Wijmo' : 'SpreadJS', country: randomInt(0, 1) ? 'アメリカ' : '日本', active: i % 2 == 0, date: new Date(year - randomInt(0, 2), randomInt(0, 11), randomInt(0, 27) + 1), sales: randomInt(10, 20), downloads: randomInt(10, 200) }); } return data; } // function randomInt(min, max) { return Math.floor(Math.random() * (max - min + 1) + min); }
.wj-pivotgrid { box-shadow: 0 10px 20px rgba(0,0,0,0.19), 0 6px 6px rgba(0,0,0,0.23); } .wj-flexgrid .large-value { color: green; } .wj-flexgrid .small-value { color: red; } body { margin-bottom: 24pt; }
(function (global) { System.config({ transpiler: 'plugin-babel', babelOptions: { es2015: true }, meta: { '*.css': { loader: 'css' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { 'jszip': 'npm:jszip/dist/jszip.js', '@grapecity/wijmo': 'npm:@grapecity/wijmo/index.js', '@grapecity/wijmo.input': 'npm:@grapecity/wijmo.input/index.js', '@grapecity/wijmo.styles': 'npm:@grapecity/wijmo.styles', '@grapecity/wijmo.cultures': 'npm:@grapecity/wijmo.cultures', '@grapecity/wijmo.chart': 'npm:@grapecity/wijmo.chart/index.js', '@grapecity/wijmo.chart.analytics': 'npm:@grapecity/wijmo.chart.analytics/index.js', '@grapecity/wijmo.chart.animation': 'npm:@grapecity/wijmo.chart.animation/index.js', '@grapecity/wijmo.chart.annotation': 'npm:@grapecity/wijmo.chart.annotation/index.js', '@grapecity/wijmo.chart.finance': 'npm:@grapecity/wijmo.chart.finance/index.js', '@grapecity/wijmo.chart.finance.analytics': 'npm:@grapecity/wijmo.chart.finance.analytics/index.js', '@grapecity/wijmo.chart.hierarchical': 'npm:@grapecity/wijmo.chart.hierarchical/index.js', '@grapecity/wijmo.chart.interaction': 'npm:@grapecity/wijmo.chart.interaction/index.js', '@grapecity/wijmo.chart.radar': 'npm:@grapecity/wijmo.chart.radar/index.js', '@grapecity/wijmo.chart.render': 'npm:@grapecity/wijmo.chart.render/index.js', '@grapecity/wijmo.gauge': 'npm:@grapecity/wijmo.gauge/index.js', '@grapecity/wijmo.grid': 'npm:@grapecity/wijmo.grid/index.js', '@grapecity/wijmo.grid.detail': 'npm:@grapecity/wijmo.grid.detail/index.js', '@grapecity/wijmo.grid.filter': 'npm:@grapecity/wijmo.grid.filter/index.js', '@grapecity/wijmo.grid.search': 'npm:@grapecity/wijmo.grid.search/index.js', '@grapecity/wijmo.grid.grouppanel': 'npm:@grapecity/wijmo.grid.grouppanel/index.js', '@grapecity/wijmo.grid.multirow': 'npm:@grapecity/wijmo.grid.multirow/index.js', '@grapecity/wijmo.grid.transposed': 'npm:@grapecity/wijmo.grid.transposed/index.js', '@grapecity/wijmo.grid.pdf': 'npm:@grapecity/wijmo.grid.pdf/index.js', '@grapecity/wijmo.grid.sheet': 'npm:@grapecity/wijmo.grid.sheet/index.js', '@grapecity/wijmo.grid.xlsx': 'npm:@grapecity/wijmo.grid.xlsx/index.js', '@grapecity/wijmo.grid.selector': 'npm:@grapecity/wijmo.grid.selector/index.js', '@grapecity/wijmo.grid.cellmaker': 'npm:@grapecity/wijmo.grid.cellmaker/index.js', '@grapecity/wijmo.nav': 'npm:@grapecity/wijmo.nav/index.js', '@grapecity/wijmo.odata': 'npm:@grapecity/wijmo.odata/index.js', '@grapecity/wijmo.olap': 'npm:@grapecity/wijmo.olap/index.js', '@grapecity/wijmo.pdf': 'npm:@grapecity/wijmo.pdf/index.js', '@grapecity/wijmo.viewer': 'npm:@grapecity/wijmo.viewer/index.js', '@grapecity/wijmo.xlsx': 'npm:@grapecity/wijmo.xlsx/index.js', '@grapecity/wijmo.undo': 'npm:@grapecity/wijmo.undo/index.js', '@grapecity/wijmo.interop.grid': 'npm:@grapecity/wijmo.interop.grid/index.js', 'jszip': 'npm:jszip/dist/jszip.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'css': 'npm:systemjs-plugin-css/css.js', 'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js', 'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js' }, // packages tells the System loader how to load when no filename and/or no extension packages: { src: { defaultExtension: 'js' }, "node_modules": { defaultExtension: 'js' }, } }); })(this);