Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
150179 | Dec 24,2019 04:47 AM UTC | Jan 10,2020 06:32 AM UTC | Angular - EJ 2 | 7 |
![]() |
Tags: PivotView |
this.dataSourceSettings = {
enableSorting: true,
columns: [{ name: 'Date' }],
values: [{ name: 'Qty 1', caption: 'Units Sold' }, { name: 'Qty 2', caption: 'Units Amount' }],
dataSource: this.getPivotData(),
rows: [{ name: 'Product' }],
formatSettings: [{ name: 'Date', format: 'yyyy-MMM', type: 'date' }],
expandAll: false,
filters: [],
};
|
<ejs-pivotview #pivotview id='PivotView' [dataSourceSettings]=dataSourceSettings width='100%' height='300'
(enginePopulated)='enginePopulated($event)' showFieldList='true' >
</ejs-pivotview>
queryCell(args: any): void {
(this.pivotGridObj.renderModule as any).rowCellBoundEvent(args);
// Here we have customize the row headers.
if (args.data[0].valueSort && args.cell.classList.contains('e-rowsheader') && !args.cell.classList.contains('e-gtot')) {
args.data[0].formattedText = args.data[0].valueSort.axis + " : " + args.data[0].formattedText;
args.cell.querySelector('.e-cellvalue').innerText = args.data[0].formattedText;
}
}
enginePopulated(args: any): void {
this.pivotGridObj.grid.queryCellInfo = this.queryCell.bind(this);
}
|
<ejs-pivotview #pivotview id='PivotView' [dataSourceSettings]=dataSourceSettings width='100%' height='300'(enginePopulated)='enginePopulated($event)' showFieldList='true' >
headerCell(args: any): void {
if (args.node.innerText) {
var month = args.node.innerText.split('-')[1];
switch (month) {
case '01':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jan';
break;
case '02':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Feb';
break;
case '03':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Mar';
break;
case '04':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Apr';
break;
case '05':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'May';
break;
case '06':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jun';
break;
case '07':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jul';
break;
case '08':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Aug';
break;
case '09':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Sep';
break;
case '10':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Oct';
break;
case '11':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Nov';
break;
case '12':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Dec';
break;
}
}
}
enginePopulated(args: any): void {
this.pivotGridObj.grid.headerCellInfo = this.headerCell.bind(this);
}
|
headerCell(args: any): void {
(this.pivotGridObj.renderModule as any).columnCellBoundEvent(args);
if (args.node.innerText) {
var month = args.node.innerText.split('-')[1];
switch (month) {
case '01':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jan';
break;
case '02':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Feb';
break;
case '03':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Mar';
break;
case '04':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Apr';
break;
case '05':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'May';
break;
case '06':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jun';
break;
case '07':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jul';
break;
case '08':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Aug';
break;
case '09':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Sep';
break;
case '10':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Oct';
break;
case '11':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Nov';
break;
case '12':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Dec';
break;
}
}
|
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.