var DemoApp = angular.module('DemoApp', ['dx']),
MILLISECONDS_IN_DAY = 1000 * 60 * 60 * 24;
DemoApp.controller('DemoController', function DemoController($scope) {
$scope.gridOptions = {
dataSource: {
store: {
type: "odata",
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"
]
},
selection: {
mode: "multiple",
deferred: true
},
filterRow: {
visible: true
},
selectionFilter: ["Task_Status", "=", "Completed"],
showBorders: true,
onInitialized: function(e){
$scope.dataGrid = e.component;
$scope.calculateStatistics();
},
columns: [{
caption: "Subject",
dataField: "Task_Subject"
}, {
caption: "Start Date",
dataField: "Task_Start_Date",
width: "auto",
dataType: "date"
}, {
caption: "Due Date",
dataField: "Task_Due_Date",
width: "auto",
dataType: "date"
}, {
caption: "Assigned To",
dataField: "ResponsibleEmployee.Employee_Full_Name",
width: "auto",
allowSorting: false
}, {
caption: "Status",
width: "auto",
dataField: "Task_Status"
}
]
};
$scope.calculateStatistics = function () {
$scope.dataGrid.getSelectedRowsData().then(function (rowData) {
var commonDuration = 0;
for (var i = 0; i < rowData.length; i++) {
commonDuration += rowData[i].Task_Due_Date
- rowData[i].Task_Start_Date;
}
commonDuration = commonDuration / MILLISECONDS_IN_DAY;
$scope.$apply(function() {
var statistic = $scope.statistic;
statistic.count = rowData.length;
statistic.peopleCount = DevExpress.data.query(rowData)
.groupBy("ResponsibleEmployee.Employee_Full_Name")
.toArray()
.length;
statistic.avgDuration
= Math.round(commonDuration / rowData.length) || 0;
});
});
};
$scope.buttonOptions = {
text: "Get statistics on the selected tasks",
type: "default",
onClick: $scope.calculateStatistics
};
$scope.statistic = {
count: 0,
peopleCount: 0,
avgDuration: 0
};
});
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" >
<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=1.0" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.2.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.2.4/css/dx.light.css" />
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js"></script>
<script>window.angular || document.write(decodeURIComponent('%3Cscript src="js/angular.min.js"%3E%3C\/script%3E'))</script>
<script src="https://cdn3.devexpress.com/jslib/19.2.4/js/dx.all.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="index.js"></script>
</head>
<body class="dx-viewport">
<div class="demo-container" ng-app="DemoApp" ng-controller="DemoController">
<div id="grid-container" dx-data-grid="gridOptions"></div>
<div class="selection-summary center">
<div dx-button="buttonOptions"></div>
<div>
<div class="column">
<span class="text count">Task count:</span>
<span class="value">{{statistic.count}}</span>
</div>
<div class="column">
<span class="text people-count">People assingned:</span>
<span class="value">{{statistic.peopleCount}}</span>
</div>
<div class="column">
<span class="text avg-duration">
Average task duration (days):
</span>
<span class="value">{{statistic.avgDuration}}</span>
</div>
</div>
</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;
}