Detail Dialog Customization

The PivotGrid allows you to drill-down into cells to see the data items that were used to calculate each summary. Users can invoke the detail dialog by double-clicking any value cell. You can also invoke the detail dialog by calling the grid's showDetail method and passing the coordinates of the cell.

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: 'Product' }, { binding: 'date', header: 'Date', format: 'yyyy \"Q\"q' }, { binding: 'sales', header: 'Sales', format: 'n0' }, { binding: 'sales', header: 'Diff', format: 'p0', showAs: 'DiffRowPct' } ], rowFields: ['Date'], columnFields: ['Product'], valueFields: ['Sales', 'Diff'] }); // // 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('Please select a cell in the PivotGrid first.'); } }); // // 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 = 'Details for <b>{columnHeader}</b> on ' + '<b>{rowHeader}</b>: <b>{cellHeader}</b> is ' + '<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"> Show Detail Dialog </button> </p> <p> The grid exposes the detail dialog through its <b>detailDialog</b> property, which can be used to customize the dialog as shown in this example. </p> <p> <label> Custom Detail Dialog <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' : 'Aoba', country: randomInt(0, 1) ? 'USA' : 'Japan', 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; } import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import * as wjCore from '@grapecity/wijmo'; import * as wjGrid from '@grapecity/wijmo.grid'; import * as wjOlap from '@grapecity/wijmo.olap'; // import { Component, Inject, enableProdMode, NgModule, ViewChild, AfterViewInit } from '@angular/core'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { BrowserModule } from '@angular/platform-browser'; import { WjOlapModule } from '@grapecity/wijmo.angular2.olap'; import { DataService } from './app.data'; // @Component({ selector: 'app-component', templateUrl: 'src/app.component.html' }) export class AppComponent implements AfterViewInit { @ViewChild('grid') pivotGrid: wjOlap.PivotGrid; ngFmt: wjOlap.PivotEngine; // constructor(@Inject(DataService) private dataService: DataService) { this.ngFmt = new wjOlap.PivotEngine({ autoGenerateFields: false, itemsSource: dataService.getData(10000), showColumnTotals: 'GrandTotals', showRowTotals: 'None', fields: [ { binding: 'product', header: 'Product' }, { binding: 'date', header: 'Date', format: 'yyyy \"Q\"q' }, { binding: 'sales', header: 'Sales', format: 'n0' }, { binding: 'sales', header: 'Diff', format: 'p0', showAs: 'DiffRowPct' } ], rowFields: ['Date'], columnFields: ['Product'], valueFields: ['Sales', 'Diff'] }); } // ngAfterViewInit() { var detailDialog = this.pivotGrid.detailDialog, detailGridHost = detailDialog.hostElement.querySelector('.wj-flexgrid'); var detailGrid: wjCore.Control = wjCore.Control.getControl(detailGridHost); var customDetails = document.getElementById('customDetails') as HTMLInputElement; // format cells in the detail grid (detailGrid as wjGrid.FlexGrid).formatItem.addHandler(function (s, e: wjGrid.FormatItemEventArgs) { 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:wjOlap.DetailDialog) { 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 = 'Details for <b>{columnHeader}</b> on ' + '<b>{rowHeader}</b>: <b>{cellHeader}</b> is ' + '<b>{cellValue}</b>'; summary.innerHTML = wjCore.format(fmt, s); // // sort detail grid by date var sds = (detailGrid as wjGrid.FlexGrid).collectionView.sortDescriptions; sds.push(new wjCore.SortDescription('date', false)); } }); } // // formatItem(e: wjGrid.FormatItemEventArgs) { // we are interested in the cells panel if (e.panel == this.pivotGrid.cells) { // // remove color by default var color = ''; // // format diff columns if custom formatting is on if (e.col % 2 == 1) { var value = this.pivotGrid.getCellData(e.row, e.col, false), 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; } } // onShowDetailClick() { var sel = this.pivotGrid.selection; if (sel.isValid) { this.pivotGrid.showDetail(sel.row, sel.col); } else { alert('Please select a cell in the PivotGrid first.') } } } // @NgModule({ imports: [WjOlapModule, BrowserModule], declarations: [AppComponent], providers: [DataService], bootstrap: [AppComponent] }) export class AppModule { } // enableProdMode(); // Bootstrap application with hash style navigation and global services. platformBrowserDynamic().bootstrapModule(AppModule); <!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"> <!-- Polyfills --> <script src="node_modules/core-js/client/shim.min.js"></script> <script src="node_modules/zone.js/dist/zone.min.js"></script> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.js"></script> <script src="systemjs.config.js"></script> <script> // workaround to load 'rxjs/operators' from the rxjs bundle System.import('rxjs').then(function (m) { System.set(SystemJS.resolveSync('rxjs/operators'), System.newModule(m.operators)); System.import('./src/app.component'); }); </script> </head> <body> <app-component></app-component> </body> </html> <div class="container-fluid"> <p> <button id="showDetail" class="btn btn-primary" (click)="onShowDetailClick()"> Show Detail Dialog </button> </p> <p> The grid exposes the detail dialog through its <b>detailDialog</b> property, which can be used to customize the dialog as shown in this example. </p> <p> <label> Custom Detail Dialog <input id="customDetails" type="checkbox" checked="checked"> </label> </p> <wj-pivot-grid #grid [itemsSource]="ngFmt" [isReadOnly]=true (formatItem)="formatItem($event)"></wj-pivot-grid> </div> import { Injectable } from '@angular/core'; export interface DataItem { product: string; country: string; active: boolean; date: Date; sales: number; downloads: number; } function randomInt(min: number, max: number): number { return Math.floor(Math.random() * (max - min + 1) + min); } @Injectable() export class DataService { getData(cnt: number): DataItem[] { var year = new Date().getFullYear(), data = []; for (var i = 0; i < cnt; i++) { data.push({ product: randomInt(0, 1) ? 'Wijmo' : 'Aoba', country: randomInt(0, 1) ? 'USA' : 'Japan', 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; } } .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; } <template> <div class="container-fluid"> <p> <button id="showDetail" class="btn btn-primary" v-on:click="onShowDetailClick"> Show Detail Dialog </button> </p> <p> The grid exposes the detail dialog through its <b>detailDialog</b> property, which can be used to customize the dialog as shown in this example. </p> <p> <label> Custom Detail Dialog <input id="customDetails" type="checkbox" checked="checked"> </label> </p> <wj-pivot-grid :items-source="ngFmt" :isReadOnly="true" :initialized="initializePivotGrid" :formatItem="formatItem"></wj-pivot-grid> </div> </template> <script> import '@grapecity/wijmo.styles/wijmo.css'; import 'bootstrap.css'; import Vue from 'vue'; import '@grapecity/wijmo.vue2.olap'; import * as wjcCore from '@grapecity/wijmo'; import * as wjcGrid from '@grapecity/wijmo.grid'; import * as wjcOlap from '@grapecity/wijmo.olap'; import { getData } from './data' let App = Vue.extend({ name: "app", data: function() { return { ngFmt: new wjcOlap.PivotEngine({ autoGenerateFields: false, itemsSource: getData(10000), showColumnTotals: 'GrandTotals', showRowTotals: 'None', fields: [ { binding: 'product', header: 'Product' }, { binding: 'date', header: 'Date', format: 'yyyy \"Q\"q' }, { binding: 'sales', header: 'Sales', format: 'n0' }, { binding: 'sales', header: 'Diff', format: 'p0', showAs: 'DiffRowPct' } ], rowFields: ['Date'], columnFields: ['Product'], valueFields: ['Sales', 'Diff'] }) }; }, mounted: function() { let detailDialog = this.pivotGrid.detailDialog, detailGridHost = detailDialog.hostElement.querySelector('.wj-flexgrid'); let detailGrid = wjcCore.Control.getControl(detailGridHost); let customDetails = document.getElementById('customDetails'); // format cells in the detail grid detailGrid.formatItem.addHandler((s, e) => { if (e.panel == s.cells && customDetails.checked) { let 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; } wjcCore.toggleClass(e.cell, 'large-value', large); wjcCore.toggleClass(e.cell, 'small-value', small); } }); // customize dialog content when showing it detailDialog.showing.addHandler((s) => { 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> let summary = s.hostElement.querySelector('.wj-summary'), fmt = 'Details for <b>{columnHeader}</b> on ' + '<b>{rowHeader}</b>: <b>{cellHeader}</b> is ' + '<b>{cellValue}</b>'; summary.innerHTML = wjcCore.format(fmt, s); // sort detail grid by date let sds = detailGrid.collectionView.sortDescriptions; sds.push(new wjcCore.SortDescription('date', false)); } }); }, methods: { initializePivotGrid(pivotGrid) { this.pivotGrid = pivotGrid; }, formatItem(s, e) { // we are interested in the cells panel if (e.panel == this.pivotGrid.cells) { // remove color by default let color = ''; // format diff columns if custom formatting is on if (e.col % 2 == 1) { let value = this.pivotGrid.getCellData(e.row, e.col, false), 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; } }, onShowDetailClick() { let sel = this.pivotGrid.selection; if (sel.isValid) { this.pivotGrid.showDetail(sel.row, sel.col); } else { alert('Please select a cell in the PivotGrid first.'); } } } }); new Vue({ render: h => h(App) }).$mount("#app"); </script> <style> .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; } </style> <!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.vue'); </script> </head> <body> <div id="app"> </div> </body> </html> export function getData(cnt) { var year = new Date().getFullYear(), data = []; for (var i = 0; i < cnt; i++) { data.push({ product: randomInt(0, 1) ? 'Wijmo' : 'Aoba', country: randomInt(0, 1) ? 'USA' : 'Japan', 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); } import './app.css'; import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; // import * as React from 'react'; import * as ReactDOM from 'react-dom'; // import * as Olap from '@grapecity/wijmo.react.olap'; import * as wjcCore from '@grapecity/wijmo'; import * as wjcOlap from '@grapecity/wijmo.olap'; import { getData } from './data'; class App extends React.Component { constructor(props) { super(props); this.state = { ngFmt: new wjcOlap.PivotEngine({ autoGenerateFields: false, itemsSource: getData(10000), showColumnTotals: 'GrandTotals', showRowTotals: 'None', fields: [ { binding: 'product', header: 'Product' }, { binding: 'date', header: 'Date', format: 'yyyy \"Q\"q' }, { binding: 'sales', header: 'Sales', format: 'n0' }, { binding: 'sales', header: 'Diff', format: 'p0', showAs: 'DiffRowPct' } ], rowFields: ['Date'], columnFields: ['Product'], valueFields: ['Sales', 'Diff'] }), customDetails: true }; this.customDetailsRef = React.createRef(); } render() { return (<div className="container-fluid"> <p> <button id="showDetail" className="btn btn-primary" onClick={this.onShowDetailClick.bind(this)}> Show Detail Dialog </button> </p> <p> The grid exposes the detail dialog through its <b>detailDialog</b> property, which can be used to customize the dialog as shown in this example. </p> <p> <label> Custom Detail Dialog <input id="customDetails" ref={this.customDetailsRef} type="checkbox" checked={this.state.customDetails} onChange={this.customDetailsChange.bind(this)}/> </label> </p> <Olap.PivotGrid itemsSource={this.state.ngFmt} isReadOnly={true} initialized={this.initializePivotGrid.bind(this)} formatItem={this.formatItem.bind(this)}></Olap.PivotGrid> </div>); } initializePivotGrid(pivotGrid) { this.pivotGrid = pivotGrid; const detailGridHost = this.pivotGrid.detailDialog.hostElement.querySelector('.wj-flexgrid'); const detailGrid = wjcCore.Control.getControl(detailGridHost); pivotGrid.detailDialog.showing.addHandler((s) => { if (this.customDetailsRef.current.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> const summary = s.hostElement.querySelector('.wj-summary'), fmt = 'Details for <b>{columnHeader}</b> on ' + '<b>{rowHeader}</b>: <b>{cellHeader}</b> is ' + '<b>{cellValue}</b>'; summary.innerHTML = wjcCore.format(fmt, s); // // sort detail grid by date const sds = detailGrid.collectionView.sortDescriptions; sds.push(new wjcCore.SortDescription('date', false)); } }); // format cells in the detail grid detailGrid.formatItem.addHandler((s, e) => { if (e.panel == s.cells && this.customDetailsRef.current.checked) { let 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; } wjcCore.toggleClass(e.cell, 'large-value', large); wjcCore.toggleClass(e.cell, 'small-value', small); } }); } formatItem(s, e) { // we are interested in the cells panel if (e.panel == this.pivotGrid.cells) { // remove color by default let color = ''; // format diff columns if custom formatting is on if (e.col % 2 == 1) { let value = this.pivotGrid.getCellData(e.row, e.col, false), 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; } } onShowDetailClick() { let sel = this.pivotGrid.selection; if (sel.isValid) { this.pivotGrid.showDetail(sel.row, sel.col); } else { alert('Please select a cell in the PivotGrid first.'); } } customDetailsChange() { this.setState({ customDetails: !this.state.customDetails }); } } ReactDOM.render(<App />, document.getElementById('app')); <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>AutoComplete</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 id="app"></div> </body> </html> .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; } export function getData(cnt) { var year = new Date().getFullYear(), data = []; for (var i = 0; i < cnt; i++) { data.push({ product: randomInt(0, 1) ? 'Wijmo' : 'Aoba', country: randomInt(0, 1) ? 'USA' : 'Japan', 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); }