jQuery Add Array Values

Question

I have a json given below

0 : {car_rental_id: "6007", sharing_schedule: "9:00 AM", booked_cars: '1', woo_order_id: "6421", woo_status: "on-hold" }
1 : {car_rental_id: "6007", sharing_schedule: "9:00 AM", booked_cars: '3', woo_order_id: "6424", woo_status: "pending" }
2 : {car_rental_id: "6007", sharing_schedule: "10:00 AM", booked_cars: '5', woo_order_id: "6427", woo_status: "pending"}

The goal here is to get the total number of booked_cars on a time. So according to this json. I should get

4 bookings for 9:00 AM and 5 bookings for 10:00 AM.

How do I achieve that?

I think the issue is that you are assigning = the value, so it always replaces, you could try creating the object you need using map — DIEGO CARRASCAL
– DIEGO CARRASCAL, Commented Nov 1, 2017 at 20:27
window.confirmedBookings has a length property, so it's an Array, yes? — Roamer-1888
– Roamer-1888, Commented Nov 1, 2017 at 20:29

Taplar · Accepted Answer · 2017-11-01 20:46:02Z

2

var test = [{
  car_rental_id: "6007",
  sharing_schedule: "9:00 AM",
  woo_order_id: "6421",
  woo_status: "on-hold",
  booked_cars: '1'
}, {
  car_rental_id: "6007",
  sharing_schedule: "9:00 AM",
  woo_order_id: "6424",
  woo_status: "pending",
  booked_cars: '3'
}, {
  car_rental_id: "6007",
  sharing_schedule: "10:00 AM",
  woo_order_id: "6427",
  woo_status: "pending",
  booked_cars: '5'
}];

var carsBookedByTime = test.reduce(function(collection, element){
  var bookedCars = parseInt(element.booked_cars);
  //initialize total in the collection if it does not exist
  if (!collection[element.sharing_schedule]) collection[element.sharing_schedule] = 0;
  
  collection[element.sharing_schedule] += bookedCars;

return collection;
}, {});

console.log(carsBookedByTime);

answered Nov 1, 2017 at 20:46

Taplar

25k4 gold badges24 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michał Kostrzyński · Accepted Answer · 2017-11-01 20:56:59Z

2

You could change it to something like that.

var values = window.confirmedBookings.reduce(function(prev, current) {
    if(!prev[current.sharing_schedule]) prev[current.sharing_schedule] = 0;
    prev[current.sharing_schedule] += Number(current.booked_cars);
    return prev;
}, {})

@edit: updated an answer to fit a question.

edited Nov 1, 2017 at 20:56

answered Nov 1, 2017 at 20:28

Michał Kostrzyński

3721 silver badge10 bronze badges

2 Comments

Zain Sohail Over a year ago

Its not necessary that I use an object, we can use an array too. I just need to make it in the given order

Michał Kostrzyński Over a year ago

Alright, now it makes more sense. I'll update my answer in a minute.

Roamer-1888 · Accepted Answer · 2017-11-01 21:07:53Z

0

You appear to be asking for :

window.totalBooked = {};
$.each(window.confirmedBookings, function(index, value) {
    console.log(value.booked_cars);
window.totalBooked[value.sharing_schedule] = (window.totalBooked[value.sharing_schedule] || 0) + +value.booked_cars;
});

or, slightly simpler :

window.totalBooked = window.confirmedBookings.reduce(function(obj, value) {
    obj[value.sharing_schedule] = (obj[value.sharing_schedule] || 0) + +value.booked_cars;
    return obj;
}, {});

DEMO

edited Nov 1, 2017 at 21:07

answered Nov 1, 2017 at 20:43

Roamer-1888

19.3k5 gold badges35 silver badges45 bronze badges

1 Comment

Zain Sohail Over a year ago

Check the question again mate

Collectives™ on Stack Overflow

jQuery Add Array Values

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related