//script to extract woocommerce currency options and apply to the widgets
var cols=glb["_odata"].length;
var rows=glb["_odata"][0].length;
var currency="$";
var thousand_sep="."; //thousand separator
var decimal_sep=","; //decimal separator

for (var i=0; i < rows; i++)
{
  console.log(glb["_odata"][0][i]);
  console.log(glb["_odata"][1][i]);
  glb_api["add_channel_value"]("x_"+glb["_odata"][0][i],glb["_odata"][1][i]);
  if (glb["_odata"][0][i]=="woocommerce_currency")
  {
     if ( glb["_odata"][1][i]=="USD")   
     {
       glb_api["add_channel_value"]("x_currency","$");
       currency="$";
     }
     else currency=glb["_odata"][1][i];
   
  }
  else  if (glb["_odata"][0][i]=="woocommerce_price_thousand_sep")
  {
     thousand_sep=glb["_odata"][1][i];
  }
  else  if (glb["_odata"][0][i]=="woocommerce_price_decimal_sep")
  {
     decimal_sep=glb["_odata"][1][i];
  }

}

var pageObj=glb_api.get_page();
var objList=pageObj.objArray;
var objName,partName;

for (var i in objList)
{
  objName=objList[i].name;
  partName=objName.slice(-5);
  if (partName=="value")
  {

      objList[i]["numberPrefix"]=[currency];
      objList[i]["numberFormat"]=["###"+thousand_sep+"###"+decimal_sep+"##"];
  }
  else if (partName=="count")
  {
       objList[i]["numberFormat"]=["###"+thousand_sep+"###"+decimal_sep+"##"];
  }
  else if (partName=="stats")
  {

      objList[i]["numberPrefix"]=["",currency];
      objList[i]["numberFormat"]=["###"+thousand_sep+"###"+decimal_sep+"##"];
  }
}

var obj=glb_api.get_page_obj("html_grid_table_d19");
if (obj!="none")
{
  obj["numberPrefix"]=["",currency];
  obj["numberFormat"]=["###"+thousand_sep+"###"+decimal_sep+"##","###"+thousand_sep+"###"+decimal_sep+"#0"];
}