我有一個(gè)這樣的 PHP 數(shù)組，我想按 created_month 和 seq 對(duì)它們進(jìn)行分組，我嘗試過合并和其他方法，但它不起作用"data": [ { "seq": "1", "created_month": "Aug", "descr": "[YOU] - Not Recieved", "paydescr": "Revenue", "amount": "205.85" }, { "seq": "1", "created_month": "Jul", "descr": "[YOU] - Not Recieved", "paydescr": "Revenue", "amount": "176.82" }, { "seq": "2", "created_month": "Aug", "descr": "[OT] - Not Recieved", "paydescr": "Commission", "amount": "74.19" }, { "seq": "2", "created_month": "Jul", "descr": "[OT] - Not Recieved", "paydescr": "Commission", "amount": "63.71" }]并希望像這樣顯示它，這將按創(chuàng)建的月份和序列分組[{"data":[ { "Aug":[ { "1":[ { "descr": "[YOU] - Not Received", "paydescr": "Revenue", "amount": "0.00" } ], "2":[ {"descr": "[YOU] - Not Received", "paydescr": "Revenue", "amount": "0.00" } ] } ] } ]]]
3 回答
ITMISS
TA貢獻(xiàn)1871條經(jīng)驗(yàn) 獲得超8個(gè)贊
使用 array_reduce 可以解決您的問題。
$data = '{"data": [{
"seq": "1",
"created_month": "Aug",
"descr": "[YOU] - Not Recieved",
"paydescr": "Revenue",
"amount": "205.85"
}, {
"seq": "1",
"created_month": "Jul",
"descr": "[YOU] - Not Recieved",
"paydescr": "Revenue",
"amount": "176.82"
}, {
"seq": "2",
"created_month": "Aug",
"descr": "[OT] - Not Recieved",
"paydescr": "Commission",
"amount": "74.19"
}, {
"seq": "2",
"created_month": "Jul",
"descr": "[OT] - Not Recieved",
"paydescr": "Commission",
"amount": "63.71"
}]}';
$data = json_decode($data, true);
$group = array_reduce($data['data'], function ($old, $new) {
$key = "{$new['created_month']}_{$new['seq']}";
unset($new['created_month'], $new['seq']);
$old[$key][] = $new;
return $old;
}, []);
print '<pre>';
print_r($group); // Ass array
print_r(json_encode($group)); // As JSON
搖曳的薔薇
TA貢獻(xiàn)1793條經(jīng)驗(yàn) 獲得超6個(gè)贊
使用這個(gè) php 代碼：
$data = '{"data": [{
"seq": "1",
"created_month": "Aug",
"descr": "[YOU] - Not Recieved",
"paydescr": "Revenue",
"amount": "205.85"
}, {
"seq": "1",
"created_month": "Jul",
"descr": "[YOU] - Not Recieved",
"paydescr": "Revenue",
"amount": "176.82"
}, {
"seq": "2",
"created_month": "Aug",
"descr": "[OT] - Not Recieved",
"paydescr": "Commission",
"amount": "74.19"
}, {
"seq": "2",
"created_month": "Jul",
"descr": "[OT] - Not Recieved",
"paydescr": "Commission",
"amount": "63.71"
}]}';
$data = json_decode($data, true);
$newArr = array();
foreach($data['data'] as $k=>$v){
$newArr[$v['created_month']][$v['seq']][] = array("descr"=>$v['descr'],"paydescr"=>$v['paydescr'],"amount"=>$v['amount']);
}
echo json_encode($newArr);
- 3 回答
- 0 關(guān)注
- 213 瀏覽
添加回答
舉報(bào)
0/150
提交
取消