lodash - merge object & sum a single property javascript

i have an array like this

[
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:3
  },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:3
  },
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:3
   },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:3
  }
]

What i want from this to merge similar item_guid into one object and quantity get summed up like this

[
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:6
   },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:6
  }
]

I know this can be achieved some loop, instead I'm looking for solutions that uses lodash or EcmaScript2015 code to make our life easier

i have an array like this

[
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:3
  },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:3
  },
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:3
   },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:3
  }
]

What i want from this to merge similar item_guid into one object and quantity get summed up like this

[
  {
    item_guid: "57e7a1cd6a3f3669dc03db58"
    quantity:6
   },
  {
    item_guid: "57e77b06e0566d496b51fed5"
    quantity:6
  }
]

I know this can be achieved some loop, instead I'm looking for solutions that uses lodash or EcmaScript2015 code to make our life easier

Share Improve this question edited Oct 26, 2016 at 12:42 asked Oct 26, 2016 at 12:33 Faysal Ahmed 1,54213 silver badges28 bronze badges

my suggestion is use Linq.js rather than writing custom method for achieve this linqjs.codeplex. – Shobhit Walia Commented Oct 26, 2016 at 12:35
Any ideas on how to do this with lodash? – sudocity Commented Oct 12, 2022 at 14:14

Add a ment |

4 Answers 4

Sorted by: Reset to default 5

A simple approach:

Loop over data and create an object where key will be unique id and its value will be quantity. Then loop back over object's keys and create objects.

var data = [{ item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }, { item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }]

var r = {};
data.forEach(function(o){
  r[o.item_guid] = (r[o.item_guid] || 0) + o.quantity;
})

var result = Object.keys(r).map(function(k){
  return { item_guid: k, quantity: r[k] }
});
console.log(result)

A solution in plain Javascript with a hash table for item_guid.

var data = [{ item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }, { item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }],
    grouped = data.reduce(function (hash) {
        return function (r, a) {
            (hash[a.item_guid] = hash[a.item_guid] || r[r.push({ item_guid: a.item_guid, quantity: 0 }) - 1]).quantity += a.quantity;
            return r;
        };
    }(Object.create(null)), []);

console.log(grouped);

ES6

var data = [{ item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }, { item_guid: "57e7a1cd6a3f3669dc03db58", quantity: 3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity: 3 }],
    grouped = data.reduce((map => (r, a) => {
        map.set(a.item_guid, map.get(a.item_guid) || r[r.push({ item_guid: a.item_guid, quantity: 0 }) - 1]);
        map.get(a.item_guid).quantity += a.quantity;
        return r;
    })(new Map), []);

console.log(grouped);

You can

group your objects by item_guid
sum the objects in the resulting groups
transform these groups in the format you want

Something like this:

var result = _.chain(data)
    .groupBy('item_guid')
    .map(function(objects, guid) {
        return {
            item_guid: guid, 
            quantity: _.sumBy(objects, 'quantity')
        };
    })
    .value();

And a demo

var data = [
  {
    item_guid: "57e7a1cd6a3f3669dc03db58",
    quantity:3
  },
  {
    item_guid: "57e77b06e0566d496b51fed5",
    quantity:3
  },
  {
    item_guid: "57e7a1cd6a3f3669dc03db58",
    quantity:3
   },
  {
    item_guid: "57e77b06e0566d496b51fed5",
    quantity:3
  }
];


var result = _.chain(data)
    .groupBy('item_guid')
    .map(function(objects, guid) {
        return {
            item_guid: guid, 
            quantity: _.sumBy(objects, 'quantity')
        };
    })
    .value();
  
  console.log(result);

<script src="https://cdnjs.cloudflare./ajax/libs/lodash.js/4.16.4/lodash.min.js"></script>

var groupedItems = [];

var totalItems = [{item_guid: "57e7a1cd6a3f3669dc03db58", quantity:3},{item_guid: "57e77b06e0566d496b51fed5",quantity:3}, { item_guid: "57e7a1cd6a3f3669dc03db58", quantity:3 }, { item_guid: "57e77b06e0566d496b51fed5", quantity:3}];

totalItems.forEach((e) => {
  if (groupedItems.findIndex(x => x.item_guid === e.item_guid) < 0) {
    let totalQuantity = totalItems
                       .filter(x => x.item_guid === e.item_guid)
                       .map(x => x.quantity)
                       .reduce(function(a, b) { return a + b;});

    groupedItems.push({item_guid: e.item_guid, quantity: totalQuantity})
  }
})

console.log(groupedItems);

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

lodash - merge object & sum a single property javascript - Stack Overflow

4 Answers 4

与本文相关的文章

评论列表(0)