Create array from complex array objects & loops in javascript

Question

I currently have a complex orders array (coming from a JSON client) that contains multiple orders like this (contains 2):

       0:  {
"employee": "Nicole"
"total": 13
"lineItems": {
    "elements": [2]
        0:  {
            "name": "Burger"
            "price": 8
        }
        1:  {
            "name": "Lamb"
            "price": 6.50
        }
    }
}
1:  {
"employee": "Dan"
"total": 11
"lineItems": {
"elements": [2]
        0:  {
            "name": "Lamb"
            "price": 4.50
        }
        1:  {
            "name": "Meatballs"
            "price": 6.50
        }
    }
}

What I want to do is create a new array that loops through the above and creates new items array based on the name of the lineItems object above. i.e. final output looks something like this:

var items = {
  "Burger" = {
    "totalSpent" : 8
  },
  "Lamb" = {
    "totalSpent" : 13
    // Note this totalSpent is an iteration or sum of all "price" items where name/id = "Lamb"
  },
  "Meatballs" = {
    "totalSpent" : 4.50
  }
}

I'm more used to PHP and have tried a number of different versions of this but can't seem to get the desired output. Here's what I've got so far:

    var orders = //As above//
    // Initialising new array to hold my final values
    var orderItems = [];
    for (var i = 0, len = orders.length; i < len; i++){
       for(var e = 0, leng = orders[i]['lineItems']['elements'].length; e < leng; e++){
          var totalSpent = 0;
          var id = orders[i]['lineItems']['elements'][e]['name'];
          if (orders[id] in orderItems[id]){
              // overwrite existing array item
              orderItems[id]['totalSpent'] += orders[i]['lineItems']['elements'][e]['price'];
              orderItems[id].push({totalSpent : orderItems[id]['totalSpent']}); 
          }
          else {
              // Create new array item
              orderItems.push(id);
              orderItems[id].push({totalSpent : orders[i]['lineItems']['elements'][e]['price']});
          }
       }
    }

Answer 1

Edit:

• Had to correct your orders syntax, I added it to my answer so you can run the Javascript Snippet;
• Changed the whole dot notation to bracket notation to make it easier to read and understand;
• Corrected the bug about items remaining an empty array (it was in the inner for);

    var orders = [
        {
            "employee": "Nicole",
            "total": 13,
            "lineItems": {
                "elements": [
                    {
                        "name": "Burger",
                        "price": 8
                    },
                    {
                        "name": "Lamb",
                        "price": 6.50
                    }
                ]
            }
        },
        {
            "employee": "Dan",
            "total": 11,
            "lineItems": {
                "elements": [
                    {
                        "name": "Lamb",
                        "price": 4.50
                    },
                    {
                        "name": "Meatballs",
                        "price": 6.50
                    }
                ]
            }
        }
    ];

    var items = {};

    // loop in orders array
    for (var i = 0; i < orders.length; i++) {
        var elements = orders[i]["lineItems"]["elements"];

        // loop in orders[i]["lineItems"]["elements"] object
        for (var eIndex in orders[i]["lineItems"]["elements"]) {
            
            // Add new item if it doesn't already exist
            if (!items.hasOwnProperty(elements[eIndex]["name"])) {
                items[elements[eIndex]["name"]] = {"totalSpent": elements[eIndex]["price"]};

            } else {
                // If it exists, sum totalSpent
                items[elements[eIndex]["name"]]["totalSpent"] += elements[eIndex]["price"];
            }
        }
    }

    console.log(items);

PS: To find out why I'm using bracket notation instead of dot notation, check this question, it's good to know!

Answer 2

First of all, there are some error in your order array, note the difference between {} (for objects) and []. Then it is just simple use of the map function to iterate over the arrays.

See your browser console (F12) for the result of this snippet

var orders = [{
  "employee": "Nicole",
  "total": 13,
  "lineItems": {
    "elements": [{
      "name": "Burger",
      "price": 8
    }, {
      "name": "Lamb",
      "price": 6.50
    }
                ]
  }
}, {
  "employee": "Dan",
  "total": 11,
  "lineItems": {
    "elements": [{
      "name": "Lamb",
      "price": 6.50
    }, {
      "name": "Meatballs",
      "price": 4.50
    }]
  }
}]

var items = {}

orders.map(function(order) {
  order.lineItems.elements.map(function(elem) {
    if (items[elem.name]) {
      items[elem.name].totalSpent += elem.price
    } else {
      items[elem.name] = {"totalSpent": elem.price}
    }
  })
})

console.log(items)