CODEWITHSUNDEEP
javascriptangularjs
wilson
wilson

Reputation: 657

AngularJS - Angular Filter Group By sum rows

I need to sum all ages by gender. The result required is as follow:

enter image description here

But I only can get the total of all ages of both genders male and female, please see the following source code to see in more detail what I want to do.

JSFiddle Source Code

var demoApp = angular.module("demoApp", ["angular.filter"]);
demoApp.controller("MainController", function($scope) {
  $scope.users = [{
    id: 1,
    name: "Mike",
    age: 22,
    gender: "Male"
  }, {
    id: 2,
    name: "Joe",
    age: 28,
    gender: "Male"
  }, {
    id: 3,
    name: "David",
    age: 30,
    gender: "Male"
  }, {
    id: 4,
    name: "Susan",
    age: 25,
    gender: "Female"
  }, {
    id: 5,
    name: "Marie",
    age: 27,
    gender: "Female"
  }, {
    id: 6,
    name: "Julie",
    age: 33,
    gender: "Female"
  }];
  $scope.sumByGender = function() {
    var total = 0;
    for (count = 0; count < $scope.users.length; count++) {
      total += $scope.users[count].age;
    }
    return total;
  }
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/angular-filter/0.5.8/angular-filter.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.23/angular.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<div ng-app="demoApp" ng-controller="MainController">
  <div ng-repeat="(key, value) in users | groupBy: 'gender'">
    Gender: {{key}}
    <div>
      <table class="table table-bordered">
        <thead>
          <tr>
            <td>#</td>
            <td>Name</td>
            <td>Age</td>
          </tr>
        </thead>
        <tbody>
          <tr ng-repeat="user in value">
            <td>{{user.id}}</td>
            <td>{{user.name}}</td>
            <td>{{user.age}}</td>
          </tr>
        </tbody>
        <tbody>
          <tr>
            <td colspan="2" class="text-right">Total</td>
            <td>{{sumByGender()}}</td>
          </tr>
        </tbody>
      </table>
    </div>
  </div>
</div>

Upvotes: 2

Views: 1228

Answers (1)

charlietfl
charlietfl

Reputation: 171679

Pass in gender as argument to your sumByGender() Then check each item's gender before including in total

HTML 

{{sumByGender(key)}}

JS

$scope.sumByGender = function(gender) {
    // Here I need to sum by gender
    var total = 0;
    for (var count = 0; count < $scope.users.length; count++) {

      if ($scope.users[count].gender == gender) {
        total += $scope.users[count].age;
      }

    }
    return total;
}

DEMO

Upvotes: 2

Related Questions