JSON内多个数组相同值合并问题求助

木木头上

原始数据

[JavaScript] 纯文本查看 复制代码

var arr = [
{"id":"1000", "name": "监控", "city": "成都", "value": 9},
{"id":"1001", "name": "手机", "city": "上海", "value": [1,2]},
{"id":"1002", "name": "电脑", "city": "上海", "value": 2},
{"id":"1002", "name": "电脑", "city": "北京", "value": [3,4,8]},
{"id":"1002", "name": "电脑", "city": "杭州", "value": 2}
]

想要得到的json数据

[JavaScript] 纯文本查看 复制代码

var arr = [
[
{"id":"1000", "name": "监控", "city": "成都", "value": 9},
{"id":"1001","name":"手机","data":[{"city":"上海","value":[1,2]}]},
{"id":"1002","name":"电脑","data":[{"city":"上海","value":2},{"city":"北京","value":[3,4,8]},{"city":"杭州","value":2}]}
]

通过js或者php怎么进行转化，有多个相同的值，解析成树感觉好难


新的转换方式：怎么达到下面的效果，形成json树

[JavaScript] 纯文本查看 复制代码

//原始数据
var arr = [
{"id":"1000", "name": "监控", "city": "成都", "value": 9},
{"id":"1001", "name": "手机", "city": "上海", "value": [1,2]},
{"id":"1002", "name": "电脑", "city": "上海", "value": 2},
{"id":"1002", "name": "电脑", "city": "北京", "value": [3,4,8]},
{"id":"1002", "name": "平板", "city": "杭州", "value": 2}
];

//需要转换后结果：
//始终保持唯一id，对name和city等进行分组合并。
[
  {"id": "1000",
    "tree": [
      {"name": "监控","data": [
          {"city": "成都","value": 9}
        ]
      }
    ]
  },
  {"id": "1001",
    "tree": [
      {"name": "手机","data":[
          {"city": "上海","value": [1,2]}
        ]
          }
    ]
  },
  {"id": "1002",
    "tree": [
      {"name": "电脑",
        "data": [
          {"city": "上海","value": 2},
          {"city": "北京","value": [3,4,8]},
                ]
      },
      {"name": "平板",
        "data": [
          {"city": "杭州","value":2}
        ]
      }
    ]
  }
]

zlf2020999

很高大上呀！赶快观看大师们如何解决。也有类似的合并问题，来学习一下解决方法！

kesai

这个还真有点难度呢，要写算法了

木木头上

zlf2020999 发表于 2022-10-13 19:19
很高大上呀！赶快观看大师们如何解决。也有类似的合并问题，来学习一下解决方法！

网络抓包的json数据大多数都要进一步处理，想要合并成容易解析的树，自己循环蒙圈了

大Z.

个人写法：

[JavaScript] 纯文本查看 复制代码

var arr = [
{"id":"1000", "name": "监控", "city": "成都", "value": 9},
{"id":"1001", "name": "手机", "city": "上海", "value": [1,2]},
{"id":"1002", "name": "电脑", "city": "上海", "value": 2},
{"id":"1002", "name": "电脑", "city": "北京", "value": [3,4,8]},
{"id":"1002", "name": "电脑", "city": "杭州", "value": 2}
];
var rs = {};
arr.forEach(e => {
    let item = rs[e.id] || {};
    let data = item.data || [];

    data.push({"city": e["city"], "value": e["value"]});

    item = { "id": e["id"], "name": e["name"], "data": data };
    rs[e.id] = item;
});
Object.values(rs);

Piz.liu

小白的写法

[JavaScript] 纯文本查看 复制代码

var xx = []
var yy = []
for(var i = 0 ;i<arr.length;i++){
    if(yy.indexOf(arr[i].name)>=0){
        var x = yy.indexOf(arr[i].name);
        xx[x].data.push({"city":arr[i].city,"value":arr[i].value})
    }else{
        yy.push(arr[i].name)
        xx.push({"id":arr[i].id,"name":arr[i].name,"data":[{"city":arr[i].city,"value":arr[i].value}]})
    }
}
console.log(xx)

kesai

[JavaScript] 纯文本查看 复制代码

const { groupBy } = require("lodash")

var arr = [
  { "id": "1000", "name": "监控", "city": "成都", "value": 9 },
  { "id": "1001", "name": "手机", "city": "上海", "value": [1, 2] },
  { "id": "1002", "name": "电脑", "city": "上海", "value": 2 },
  { "id": "1002", "name": "电脑", "city": "北京", "value": [3, 4, 8] },
  { "id": "1002", "name": "电脑", "city": "杭州", "value": 2 }
]
let group = groupBy(arr, "id");
let res = Object.entries(group).map(([id, arr]) => {
  let name = arr[0].name;
  let data = arr.map(v => new Object({
    city: v.city, value: v.value
  }))
  return { id, name, data }
})

console.log(JSON.stringify(res))

木木头上

kesai 发表于 2022-10-13 19:34
[mw_shl_code=javascript,true]const { groupBy } = require("lodash")

var arr = [

这个是用了VUE的吧

steven026

不太优雅 凑合用吧

[JavaScript] 纯文本查看 复制代码

var arr = [
    { "id": "1000", "name": "监控", "city": "成都", "value": 9 },
    { "id": "1001", "name": "手机", "city": "上海", "value": [1, 2] },
    { "id": "1002", "name": "电脑", "city": "上海", "value": 2 },
    { "id": "1002", "name": "电脑", "city": "北京", "value": [3, 4, 8] },
    { "id": "1002", "name": "电脑", "city": "杭州", "value": 2 }
]

let temp1 = arr.map(i => {
    let { id, name, ...data } = i
    return { id, name, data }
})

let temp2 = {}
temp1.forEach(i => {
    if (temp2[i.id] == void 0) {
        i.data = [i.data]
        temp2[i.id] = i
    } else {
        temp2[i.id]['data'].push(i.data)
    }
})

let final = Object.values(temp2)

kesai

木木头上 发表于 2022-10-13 19:51
这个是用了VUE的吧

没有，用了lodash啊，nodejs下就能运行