build queryString for chart
build queryString for chart
by pj_js15
JavaScript
var json = [
{
"assetID": 1,
"name": "Cash and deposits",
"assetAmount": 18000.0,
"rgbColor": "94,149,198"
},
{
"assetID": 2,
"name": "Aust Fixed Interest",
"assetAmount": 18600.0,
"rgbColor": "242,137,0"
},
{
"assetID": 3,
"name": "International Fixed Interest",
"assetAmount": 18600.0,
"rgbColor": "184,222,16"
},
{
"assetID": 4,
"name": "Australian Share",
"assetAmount": 25968.0,
"rgbColor": "118,191,30"
},
{
"assetID": 5,
"name": "Global Shares and Alternatives",
"assetAmount": 27792.0,
"rgbColor": "1,49,100"
},
{
"assetID": 6,
"name": "Property and Infrastructure Securities",
"assetAmount": 11040.0,
"rgbColor": "142,199,226"
}
];
var qs = "NumAssetAllocations=" + json.length + "&PieLabelColor=1,49,100";
var accountInvest = 120000;
//debugger;
for (var key in json) {
if (json.hasOwnProperty(key)) {
//console.log(json[key].assetID);
//console.log(json[key].name);
var percentage = (json[key].assetAmount / accountInvest) * 100;
var tempKey = key;
qs += "&Name_" + (++tempKey) + "=" + encodeURIComponent(json[key].name.trim());
qs += "&Percentage_" + (tempKey) + "=" + percentage;
qs += "&Color_" + (tempKey) + "=" + json[key].rgbColor;
}
}
console.log(qs);