javascript - Create JSON with through Excel Hierarchy -

-

i have table tree products. category, group , subgroup.

when export json excel file out without hierarchy: example:

        [   {     "id_cat": 4,     "desc cat": "acessorios para veiculos",     "id_gr": 1,     "desc gr": "acessorios nautica",     "id_sub": 15,     "desc sub": "bombas"   },   {     "id_cat": 4,     "desc cat": "acessorios para veiculos",     "id_gr": 1,     "desc gr": "acessorios nautica",     "id_sub": 16,     "desc sub": "cabos"   },   {     "id_cat": 4,     "desc cat": "acessorios para veiculos",     "id_gr": 1,     "desc gr": "acessorios nautica",     "id_sub": 17,     "desc sub": "helices"   },

must generate file this:

 [   {     "category": {       "id": 4,       "name": "acessorios para veiculos",       "group": [         {           "id": 1,           "name": "acessorios nautica",           "subgroup": [             {               "id": 15,               "name": "bombas"             },             {               "id": 16,               "name": "cabos"             },             {               "id": 17,               "name": "helices"             }           ]         },         {           "id": 2,           "name": "acessorios de carros",           "subgroup": [             {               "id": 26,               "name": "exterior"             },             {               "id": 27,               "name": "interior"             }           ]         }       ]     }   } ]

the excel? know best way can create file through table format?

you can use js object hash table keep track of category id, group id , subgroup id.

i came quick implementation below (assuming items in initial array have id_cat, id_gr , id_sub value), have @ jsfiddle

function grouping(items) {      var cathash = {},          catlist = [],          = 0;                    (i = 0; < items.length; i++) {          var hash = cathash[items[i]["id_cat"]] || {};          hash.grouphash = hash.grouphash || {};                    var grouphash = hash.grouphash[items[i]["id_gr"]] || {};          grouphash.subgrouphash = grouphash.subgrouphash || {};                    var subgrouphash = grouphash.subgrouphash[items[i]["id_sub"]] || {},              cat = hash.category || {},              group = grouphash.group || {},              subgroup = subgrouphash.subgroup || {};                            if (!cat.id) {              cat.id = items[i]["id_cat"];              catlist.push(cat);              hash.category = cat;              cathash[cat.id] = hash;          }          if (!cat.name) {              cat.name = items[i]["desc cat"];          }          if (!cat.group) {              cat.group = [];          }            if (!group.id) {              group.id = items[i]["id_gr"];              cat.group.push(group);                            grouphash.group = group;              hash.grouphash[group.id] = grouphash;          }          if (!group.name) {              group.name = items[i]["desc gr"];          }          if (!group.subgroup) {              group.subgroup = [];          }                    if (!subgroup.id) {              subgroup.id = items[i]["id_sub"];              group.subgroup.push(subgroup);                            subgrouphash.subgroup = subgroup;              grouphash.subgrouphash[subgroup.id] = subgrouphash;          }          if (!subgroup.name) {              subgroup.name = items[i]["desc sub"];          }      }      return catlist;  }


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more