array(4) {
[0] => array(3) {
["total_count"] => string(2) "17"
["device"] => string(2) "pc"
["date"] => string(10) "2021-12-27"
}
[1] => array(3) {
["total_count"] => string(1) "2"
["device"] => string(2) "pc"
["date"] => string(10) "2021-12-28"
}
[2] => array(3) {
["total_count"] => string(1) "1"
["device"] => string(7) "android"
["date"] => string(10) "2021-12-28"
}
[3] => array(3) {
["total_count"] => string(1) "1"
["device"] => string(3) "ios"
["date"] => string(10) "2021-12-28"
}
}
array(2) {
["2021-12-27"] => array(4) {
["date"] => string(10) "2021-12-27"
["ios"] => int(0)
["android"] => int(0)
["pc"] => int(17)
}
["2021-12-28"] => array(4) {
["date"] => string(10) "2021-12-28"
["ios"] => int(1)
["android"] => int(1)
["pc"] => int(2)
}
}
$arr = [];
foreach ($data as $key=>$value){
$_date = $value['date'];
$_device = $value['device'];
$_totalAmount = $value['total_count'];
if (!isset($arr[$_date])) {
$arr[$_date]['date'] = $_date;
$arr[$_date]['ios'] = 0;
$arr[$_date]['android'] = 0;
$arr[$_date]['pc'] = 0;
}
if ($_device == 'ios') {
$arr[$_date]['ios'] += $_totalAmount;
}elseif ($_device == 'android'){
$arr[$_date]['android'] += $_totalAmount;
}elseif ($_device == 'pc'){
$arr[$_date]['pc'] += $_totalAmount;
}
}
php二维数组相同日期分类处理
于 2021-12-28 17:49:44 首次发布