Combine json object and javascript object

Question

hello i have json response from MySql in this format

{
    "allResult": [{
        "UkupanBroj": "1",
        "mesec": "Jul"
    }, {
        "UkupanBroj": "3",
        "mesec": "Jun"
    }, {
        "UkupanBroj": "1",
        "mesec": "May"
    }],
    "resultByKurs": null
}

I am trying to create from this response object to pass into chart plugin

var flotDashSales2Data = [{
    data: [
        ["Jan", 240],
        ["Feb", 240],
        ["Mar", 290],
        ["Apr", 540],
        ["May", 480],
        ["Jun", 220],
        ["Jul", 170],
        ["Aug", 190]
    ],
    color: "#850d0d"
}];

Is it possible to create new object from my response??? In this way in would be cool if i dont have in my response some month to set form example ["Jan", 0] in my data wich i pass to plugin?

Can you confirm that you want the value of "UkupanBroj" as the second value in the month pairs.... e.g. {"UkupanBroj":"123","mesec":"Jul"} maps to ["Jul", 123] ? — Adam
– Adam, Commented Jun 22, 2015 at 11:38

pid · Accepted Answer · 2015-06-22 11:48:15Z

You can get the actual data with:

data_result = JSON.parse(result);

It will not have the same format but you'll be able to transform it into what you need.

To aggregate the data you could do something along these lines:

var aggregate = {
    "Jan": 0,
    "Feb": 0,
    "Mar": 0,
    "Apr": 0,
    "May": 0,
    "Jun": 0,
    "Jul": 0,
    "Aug": 0 // fill in all 12 months
};

for (i = 0; i < data_result.allResult.length; i++)
{
    item = data_result.allResult[i];
    aggregate[item.mesec] += parseInt(item.UkupanBroj, 10);
}

Then, fill the array with the aggregate data:

lotDashSales2Data = [{
    data: [
        ["Jan", aggregate.Jan],
        ["Feb", aggregate.Feb],
        ["Mar", aggregate.Mar],
        ["Apr", aggregate.Apr],
        // ... all 12 months
    ],
    color: "#850d0d"
}];

EDIT: because you have the invariant of 12 months (they will never change) you can avoid complex code by simply listing them one by one as shown in my code. If you prefer more complex code, instead, it can be solved that other way, to. It is more a matter of choice and trade-offs (flexibility vs readability). Other factors such as performance should be irrelevant.

Palo · Accepted Answer · 2015-06-22 11:38:09Z

0

var flotDashSales2Data = JSON.parse(response);

use JSON.parse

answered Jun 22, 2015 at 11:38

Palo

3721 silver badge12 bronze badges

Collectives™ on Stack Overflow

Combine json object and javascript object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related