import React, { useCallback, useState } from 'react';
import DataGrid, {
Column, DataGridTypes, FilterRow, Selection,
} from 'devextreme-react/data-grid';
import Button from 'devextreme-react/button';
import query from 'devextreme/data/query';
import 'devextreme/data/odata/store';
const MILLISECONDS_IN_DAY = 1000 * 60 * 60 * 24;
const dataSource = {
store: {
type: 'odata' as const,
version: 2,
url: 'https://js.devexpress.com/Demos/DevAV/odata/Tasks',
key: 'Task_ID',
},
expand: 'ResponsibleEmployee',
select: [
'Task_ID',
'Task_Subject',
'Task_Start_Date',
'Task_Due_Date',
'Task_Status',
'ResponsibleEmployee/Employee_Full_Name',
],
};
const selectionFilter = ['Task_Status', '=', 'Completed'];
let dataGrid;
const App = () => {
const [taskCount, setTaskCount] = useState(0);
const [peopleCount, setPeopleCount] = useState(0);
const [avgDuration, setAvgDuration] = useState(0);
// eslint-disable-next-line space-before-function-paren
const calculateStatistics = useCallback(async () => {
const selectedItems = await dataGrid.getSelectedRowsData();
const totalDuration = selectedItems.reduce((currentValue: number, item: { Task_Due_Date: number; Task_Start_Date: number; }) => {
const duration = item.Task_Due_Date - item.Task_Start_Date;
return currentValue + duration;
}, 0);
const averageDurationInDays = totalDuration / MILLISECONDS_IN_DAY / selectedItems.length;
setTaskCount(selectedItems.length);
setPeopleCount(
query(selectedItems)
.groupBy('ResponsibleEmployee.Employee_Full_Name')
.toArray().length,
);
setAvgDuration(Math.round(averageDurationInDays) || 0);
}, []);
const onInitialized = useCallback((e: DataGridTypes.InitializedEvent) => {
dataGrid = e.component;
calculateStatistics();
}, [calculateStatistics]);
return (
<div>
<DataGrid
id="grid-container"
dataSource={dataSource}
showBorders={true}
defaultSelectionFilter={selectionFilter}
onInitialized={onInitialized}
>
<Selection mode="multiple" deferred={true} />
<FilterRow visible={true} />
<Column caption="Subject" dataField="Task_Subject" />
<Column
caption="Start Date"
dataField="Task_Start_Date"
width="auto"
dataType="date"
/>
<Column
caption="Due Date"
dataField="Task_Due_Date"
width="auto"
dataType="date"
/>
<Column
caption="Assigned To"
dataField="ResponsibleEmployee.Employee_Full_Name"
width="auto"
allowSorting={false}
/>
<Column caption="Status" width="auto" dataField="Task_Status" />
</DataGrid>
<div className="selection-summary center">
<Button
id="calculateButton"
text="Get statistics on the selected tasks"
type="default"
onClick={calculateStatistics}
/>
<div>
<div className="column">
<span className="text count">Task count:</span>
<span className="value">{taskCount}</span>
</div>
<div className="column">
<span className="text people-count">People assigned:</span>
<span className="value">{peopleCount}</span>
</div>
<div className="column">
<span className="text avg-duration">Average task duration (days):</span>
<span className="value">{avgDuration}</span>
</div>
</div>
</div>
</div>
);
};
export default App;
import React, { useCallback, useState } from 'react';
import DataGrid, { Column, FilterRow, Selection } from 'devextreme-react/data-grid';
import Button from 'devextreme-react/button';
import query from 'devextreme/data/query';
import 'devextreme/data/odata/store';
const MILLISECONDS_IN_DAY = 1000 * 60 * 60 * 24;
const dataSource = {
store: {
type: 'odata',
version: 2,
url: 'https://js.devexpress.com/Demos/DevAV/odata/Tasks',
key: 'Task_ID',
},
expand: 'ResponsibleEmployee',
select: [
'Task_ID',
'Task_Subject',
'Task_Start_Date',
'Task_Due_Date',
'Task_Status',
'ResponsibleEmployee/Employee_Full_Name',
],
};
const selectionFilter = ['Task_Status', '=', 'Completed'];
let dataGrid;
const App = () => {
const [taskCount, setTaskCount] = useState(0);
const [peopleCount, setPeopleCount] = useState(0);
const [avgDuration, setAvgDuration] = useState(0);
// eslint-disable-next-line space-before-function-paren
const calculateStatistics = useCallback(async () => {
const selectedItems = await dataGrid.getSelectedRowsData();
const totalDuration = selectedItems.reduce((currentValue, item) => {
const duration = item.Task_Due_Date - item.Task_Start_Date;
return currentValue + duration;
}, 0);
const averageDurationInDays = totalDuration / MILLISECONDS_IN_DAY / selectedItems.length;
setTaskCount(selectedItems.length);
setPeopleCount(
query(selectedItems).groupBy('ResponsibleEmployee.Employee_Full_Name').toArray().length,
);
setAvgDuration(Math.round(averageDurationInDays) || 0);
}, []);
const onInitialized = useCallback(
(e) => {
dataGrid = e.component;
calculateStatistics();
},
[calculateStatistics],
);
return (
<div>
<DataGrid
id="grid-container"
dataSource={dataSource}
showBorders={true}
defaultSelectionFilter={selectionFilter}
onInitialized={onInitialized}
>
<Selection
mode="multiple"
deferred={true}
/>
<FilterRow visible={true} />
<Column
caption="Subject"
dataField="Task_Subject"
/>
<Column
caption="Start Date"
dataField="Task_Start_Date"
width="auto"
dataType="date"
/>
<Column
caption="Due Date"
dataField="Task_Due_Date"
width="auto"
dataType="date"
/>
<Column
caption="Assigned To"
dataField="ResponsibleEmployee.Employee_Full_Name"
width="auto"
allowSorting={false}
/>
<Column
caption="Status"
width="auto"
dataField="Task_Status"
/>
</DataGrid>
<div className="selection-summary center">
<Button
id="calculateButton"
text="Get statistics on the selected tasks"
type="default"
onClick={calculateStatistics}
/>
<div>
<div className="column">
<span className="text count">Task count:</span>
<span className="value">{taskCount}</span>
</div>
<div className="column">
<span className="text people-count">People assigned:</span>
<span className="value">{peopleCount}</span>
</div>
<div className="column">
<span className="text avg-duration">Average task duration (days):</span>
<span className="value">{avgDuration}</span>
</div>
</div>
</div>
</div>
);
};
export default App;
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.tsx';
ReactDOM.render(
<App />,
document.getElementById('app'),
);
window.exports = window.exports || {};
window.config = {
transpiler: 'ts',
typescriptOptions: {
module: 'system',
emitDecoratorMetadata: true,
experimentalDecorators: true,
jsx: 'react',
},
meta: {
'react': {
'esModule': true,
},
'typescript': {
'exports': 'ts',
},
'devextreme/time_zone_utils.js': {
'esModule': true,
},
'devextreme/localization.js': {
'esModule': true,
},
'devextreme/viz/palette.js': {
'esModule': true,
},
},
paths: {
'npm:': 'https://unpkg.com/',
},
defaultExtension: 'js',
map: {
'ts': 'npm:plugin-typescript@4.2.4/lib/plugin.js',
'typescript': 'npm:typescript@4.2.4/lib/typescript.js',
'react': 'npm:react@17.0.2/umd/react.development.js',
'react-dom': 'npm:react-dom@17.0.2/umd/react-dom.development.js',
'prop-types': 'npm:prop-types@15.8.1/prop-types.js',
'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.28.1/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@24.1.6/cjs',
'devextreme-react': 'npm:devextreme-react@24.1.6/cjs',
'jszip': 'npm:jszip@3.10.1/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@1.7.1/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.2.11/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@4.1.56/dist/dx-gantt.js',
'@devextreme/runtime': 'npm:@devextreme/runtime@3.0.13',
'inferno': 'npm:inferno@7.4.11/dist/inferno.min.js',
'inferno-compat': 'npm:inferno-compat/dist/inferno-compat.min.js',
'inferno-create-element': 'npm:inferno-create-element@7.4.11/dist/inferno-create-element.min.js',
'inferno-dom': 'npm:inferno-dom/dist/inferno-dom.min.js',
'inferno-hydrate': 'npm:inferno-hydrate@7.4.11/dist/inferno-hydrate.min.js',
'inferno-clone-vnode': 'npm:inferno-clone-vnode/dist/inferno-clone-vnode.min.js',
'inferno-create-class': 'npm:inferno-create-class/dist/inferno-create-class.min.js',
'inferno-extras': 'npm:inferno-extras/dist/inferno-extras.min.js',
'devextreme-cldr-data': 'npm:devextreme-cldr-data@1.0.3',
// SystemJS plugins
'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js',
'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js',
// Prettier
'prettier/standalone': 'npm:prettier@2.8.8/standalone.js',
'prettier/parser-html': 'npm:prettier@2.8.8/parser-html.js',
},
packages: {
'devextreme': {
defaultExtension: 'js',
},
'devextreme-react': {
main: 'index.js',
},
'devextreme/events/utils': {
main: 'index',
},
'devextreme/localization/messages': {
format: 'json',
defaultExtension: 'json',
},
'devextreme/events': {
main: 'index',
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js',
},
},
packageConfigPaths: [
'npm:@devextreme/*/package.json',
'npm:@devextreme/runtime@3.0.13/inferno/package.json',
],
babelOptions: {
sourceMaps: false,
stage0: true,
react: true,
},
};
System.config(window.config);
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.js';
ReactDOM.render(<App />, document.getElementById('app'));
<!DOCTYPE html>
<html lang="en">
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=5.0" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/24.1.6/css/dx.light.css" />
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="https://unpkg.com/core-js@2.6.12/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import("./index.tsx");
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app"></div>
</div>
</body>
</html>
#grid-container {
height: 400px;
}
.center {
text-align: center;
}
.selection-summary {
border: 1px solid rgba(161, 161, 161, 0.2);
padding: 25px;
}
.column {
margin: 20px 30px 0 0;
display: inline-block;
white-space: nowrap;
text-align: right;
}
.value {
font-size: 40px;
display: inline-block;
vertical-align: middle;
}
.text {
text-align: left;
white-space: normal;
display: inline-block;
vertical-align: middle;
}
.avg-duration {
width: 100px;
}
.count {
width: 40px;
}
.people-count {
width: 65px;
}