es6 - javascript 將多個(gè)JSON對(duì)象合并成一個(gè)(帶子父關(guān)系)
問(wèn)題描述
1、目前有一個(gè)很任性的接口API,它提供的數(shù)據(jù)非常不合理2、數(shù)據(jù)如下
var json = [{'mainId': 1, 'title': 'abc', 'createdate': '2017-06-28'},{'mainId': 2, 'title': 'ddddd', 'createdate': '2017-06-25'}];var json1 = [{'childId':1, 'mainId': 1, 'childname': 'cname'},{'childId':2, 'mainId': 1, 'childname': 'cname2'},{'childId':3, 'mainId': 2, 'childname': 'cname3'},{'childId':4, 'mainId': 2, 'childname': 'cname4'}];var json2 = [{'childchildId':1, 'childId': 1, 'childname': 'cname'},{'childchildId':2, 'childId': 1, 'childname': 'cname2'},{'childchildId':3, 'childId': 2, 'childname': 'cname3'},{'childchildId':4, 'childId': 2, 'childname': 'cname4'},{'childchildId':5, 'childId': 3, 'childname': 'cname'},{'childchildId':6, 'childId': 3, 'childname': 'cname2'},{'childchildId':7, 'childId': 4, 'childname': 'cname3'},{'childchildId':8, 'childId': 4, 'childname': 'cname4'}];
3、我想將它們合并成一個(gè)json如下:
var result = [{'mainId':1, 'title': 'abc', 'createdate': '2017-06-28', child:[{'childId':1, 'mainId': 1, 'childname': 'cname', childchild:[{'childchildId':1, 'childId': 1, 'childname': 'cname'},{'childchildId':2, 'childId': 1, 'childname': 'cname2'}]},{'childId':2, 'mainId': 1, 'childname': 'cname2', childchild:[{'childchildId':3, 'childId': 2, 'childname': 'cname3'},{'childchildId':4, 'childId': 2, 'childname': 'cname4'}]}]
是否有好的辦法?
問(wèn)題解答
回答1:額,就是不想寫循環(huán)
let json2Obj = json2.reduce((acc, cur) => { let childId = cur.childId; if (!acc[childId]) {acc[childId] = []; } acc[childId].push(cur); return acc;}, {})json1.forEach(item => { item.childchild = json2Obj[item.childId]})let json1Obj = json1.reduce((acc, cur) => { let mainId = cur.mainId; if (!acc[mainId]) {acc[mainId] = []; } acc[mainId].push(cur); return acc;}, {})json.forEach(item => { item.child = json1Obj[item.mainId];})console.log(JSON.stringify(json));
reduce重構(gòu)下:
const toObj = (json, idStr) => json.reduce((acc, cur) => { let id = cur[idStr]; if (!acc[id]) {acc[id] = []; } acc[id].push(cur); return acc;}, {})const json2Obj = toObj(json2, ’childId’);json1.forEach(item => item.childchild = json2Obj[item.childId])const json1Obj = toObj(json1, ’mainId’);json.forEach(item => item.child = json1Obj[item.mainId])console.log(JSON.stringify(json));回答2:
php的,一步步來(lái)
header(’content-type:application/json;charset=utf8’);$json = ’[{'mainId': 1, 'title': 'abc', 'createdate': '2017-06-28'},{'mainId': 2, 'title': 'ddddd', 'createdate': '2017-06-25'}]’;$json1 = ’[{'childId':1, 'mainId': 1, 'childname': 'cname'},{'childId':2, 'mainId': 1, 'childname': 'cname2'},{'childId':3, 'mainId': 2, 'childname': 'cname3'},{'childId':4, 'mainId': 2, 'childname': 'cname4'}]’;$json2 = ’[{'childchildId':1, 'childId': 1, 'childname': 'cname'},{'childchildId':2, 'childId': 1, 'childname': 'cname2'},{'childchildId':3, 'childId': 2, 'childname': 'cname3'},{'childchildId':4, 'childId': 2, 'childname': 'cname4'},{'childchildId':5, 'childId': 3, 'childname': 'cname'},{'childchildId':6, 'childId': 3, 'childname': 'cname2'},{'childchildId':7, 'childId': 4, 'childname': 'cname3'},{'childchildId':8, 'childId': 4, 'childname': 'cname4'}]’;$arr = array_merge(json_decode($json, true), json_decode($json1, true), json_decode($json2, true));print_r(json_encode(dataFormat($arr)));//整理數(shù)據(jù)格式function dataFormat($arr){ foreach ($arr as $key => &$value) {$value[’id’] = $key; } foreach ($arr as $key => &$value) {if (!empty($value[’mainId’]) && empty($value[’childId’])) { $value[’pid’] = ’100’;}if (!empty($value[’mainId’]) && !empty($value[’childId’])) { foreach ($arr as $k => $v) {if (!empty($v[’mainId’]) && empty($v[’childId’])) { if ($value[’mainId’] == $v[’mainId’]) {$value[’pid’] = $k; }} }}if (!empty($value[’childchildId’])) { foreach ($arr as $k => $v) {if (!empty($v[’mainId’]) && !empty($v[’childId’])) { if ($value[’childId’] == $v[’childId’]) {$value[’pid’] = $k; }} }} } //生成樹(shù) $arr = getTree($arr); //刪除id、pid deleteKey($arr, ’id’, ’pid’); return $arr; //刪除不需要的鍵id、pid}//獲取樹(shù)function getTree($items){ $tree = array(); foreach($items as $item){if(isset($items[$item[’pid’]])){ $items[$item[’pid’]][’child’][] = &$items[$item[’id’]];}else{ $tree[] = &$items[$item[’id’]];} } return $tree;}//刪除不需要的鍵function deleteKey(&$arr, $id, $pid){ foreach ($arr as $key => &$value) {if (!empty($value[’child’]) && is_array($value[’child’])) { deleteKey($value[’child’], $id, $pid);}unset($value[$id], $value[$pid]); }}
正常輸出
[ {'mainId': 1,'title': 'abc','createdate': '2017-06-28','child': [ {'childId': 1,'mainId': 1,'childname': 'cname','child': [ {'childchildId': 1,'childId': 1,'childname': 'cname' }, {'childchildId': 2,'childId': 1,'childname': 'cname2' }] }, {'childId': 2,'mainId': 1,'childname': 'cname2','child': [ {'childchildId': 3,'childId': 2,'childname': 'cname3' }, {'childchildId': 4,'childId': 2,'childname': 'cname4' }] }] }, {'mainId': 2,'title': 'ddddd','createdate': '2017-06-25','child': [ {'childId': 3,'mainId': 2,'childname': 'cname3','child': [ {'childchildId': 5,'childId': 3,'childname': 'cname' }, {'childchildId': 6,'childId': 3,'childname': 'cname2' }] }, {'childId': 4,'mainId': 2,'childname': 'cname4','child': [ {'childchildId': 7,'childId': 4,'childname': 'cname3' }, {'childchildId': 8,'childId': 4,'childname': 'cname4' }] }] }]回答3:
let obj1 = {};let obj={}let obj2 = eval(’(’ + (JSON.stringify(obj) + JSON.stringify(obj1)).replace(/}{/, ’,’) + ’)’);
很好用的,不過(guò)瀏覽器可能會(huì)提示eval是有害的,這個(gè)想要去掉,可以百度有方法,具體我忘了
相關(guān)文章:
1. sql語(yǔ)句 - 如何在mysql中批量添加用戶?2. shell - Update query wrong in MySQL3. 怎么php怎么通過(guò)數(shù)組顯示sql查詢結(jié)果呢,查詢結(jié)果有多條,如圖。4. mysql - PHP定時(shí)通知、按時(shí)發(fā)布怎么做?5. php - 數(shù)據(jù)庫(kù)表如果是null怎么替換為其他字段的值6. 事務(wù) - mysql共享鎖lock in share mode的實(shí)際使用場(chǎng)景7. SQLAlchemy 訪問(wèn)Mysql數(shù)據(jù)庫(kù)彈出Warning,VARIABLE_VALUE,如何解決?8. mysql - JAVA怎么實(shí)現(xiàn)一個(gè)DAO同時(shí)實(shí)現(xiàn)查詢兩個(gè)實(shí)體類的結(jié)果集9. mysql - 數(shù)據(jù)庫(kù)建字段,默認(rèn)值空和empty string有什么區(qū)別 11010. mysql建表報(bào)錯(cuò),查手冊(cè)看不懂,求解?
