Javascript/Jquery OOP Array inside of an Array

Question

In a nutshell I am making a REST call to my database and getting a list of ingredients back. The JSON looks like:

[{"SubItemID":1,"MainItemID":1,"SubName":"2%","MainName":"Milk"},
{"SubItemID":2,"MainItemID":1,"SubName":"Skim/Fat Free","MainName":"Milk"},
{"SubItemID":3,"MainItemID":2,"SubName":"Chedder","MainName":"Cheese"}]

What I want to do is transform this into a useful array that is organized as:

Milk
1. 2%
2. Skim/Fat Free
Cheese
1. chedder

In addition to it being ordered like that, I want to maintain the ID associated with each item. So cheese would have "2" and chedder would have "3".

I have been able to feed the unique values of Milk and Cheese into an array but I am not sure how to proceed. Advise would be appreciated!

Here's what I have so far:

        $.ajax({
            url: "../api/IngredientChoices",
            contentType: "json",
            success: function (data) {
                var _subCategories = {};
                var _mainCategories = [];
                $.each(data, function (index, item) {
                    if ($.inArray(item.MainName, _mainCategories) === -1) {
                        _mainCategories.push(item.MainName);
                    }
                });
                $.each(_mainCategories, function () {
                    alert(this);
                });
            }
        });

Are you using JSON parse()?

ATOzTOA
– ATOzTOA

2013-01-14 05:44:57 +00:00
Commented Jan 14, 2013 at 5:44 — ATOzTOA
– ATOzTOA, Commented Jan 14, 2013 at 5:44
@ATOzTOA I added my current Ajax code

Yecats
– Yecats

2013-01-14 05:48:31 +00:00
Commented Jan 14, 2013 at 5:48 — Yecats
– Yecats, Commented Jan 14, 2013 at 5:48

ATOzTOA · Accepted Answer · 2013-01-14 05:57:10Z

1

Detailed working answer. The data is added to an associative array.

obj = JSON.parse(data);

console.log(obj);

d = {}

$.each(obj, function (index, item) {
    if (!(item.MainItemID in d)) {
        d[item.MainItemID] = [];
        d[item.MainItemID][0] = item.MainName;
        d[item.MainItemID][1] = {}
    }

    d[item.MainItemID][1][item.SubItemID] = item.SubName;
});

console.log(d);

Output:

Object {1: Array[2], 2: Array[2]}
1: Array[2]
    0: "Milk"
        1: "2%"
        2: "Skim/Fat Free"
2: Array[2]
    0: "Cheese"
        3: "Chedder"

edited Jan 14, 2013 at 5:57

answered Jan 14, 2013 at 5:51

ATOzTOA

36.1k23 gold badges101 silver badges119 bronze badges

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

1 Comment

Matthew Blancarte Over a year ago

I think OP is asking how to refactor the JSON, not how to parse it.

user813182 · Accepted Answer · 2013-01-14 05:54:52Z

1

You might want to edit your question. The 'useful' array you want is actually not an array. You might want this :
[
{
name : 'Milk',
subTypes : [ '2%', 'Fat Free'],
},
{
name : 'Cheese',
subTypes : [ 'Cheddar' ],
}
]

answered Jan 14, 2013 at 5:54

user813182

Comments

Gabriel Gartz · Accepted Answer · 2013-01-14 06:14:33Z

1

jsfiddle example

var data = [{"SubItemID":1,"MainItemID":1,"SubName":"2%","MainName":"Milk"},
{"SubItemID":2,"MainItemID":1,"SubName":"Skim/Fat Free","MainName":"Milk"},
{"SubItemID":3,"MainItemID":2,"SubName":"Chedder","MainName":"Cheese"}];

var ordered = {};

for(var i = data.length; i--;) {
  var mainItemID = data[i].MainItemID;
  if(!ordered[mainItemID]) {
    ordered[mainItemID] = {};
    ordered[mainItemID].MainName = data[i].MainName;
    ordered[mainItemID].MainItemID = mainItemID;
  }
  ordered[mainItemID][data[i].SubItemID] = data[i];
}

console.log(ordered);

And you can have a array with your object collection, that way you will be able to sort it:

var dataArray = [];

for(var k in ordered) {
  dataArray.push(ordered[k]);
}

console.log(dataArray);

If you plan more complex data parsing, or manipulation, I would recommend some model/collection framework, like: Backbonejs, SpineJS, or even use webSQL or IndexedDB.

edited Jan 14, 2013 at 6:14

answered Jan 14, 2013 at 5:58

Gabriel Gartz

2,87024 silver badges24 bronze badges

1 Comment

ATOzTOA Over a year ago

You are not getting MainName.

Collectives™ on Stack Overflow

Javascript/Jquery OOP Array inside of an Array

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related