Laravel 根据年份值组合多维数组-PHP中文网问答

文章专题 AI工具学习下载问答源码最近更新

PHP

会员中心讲师中心微信公众号

Laravel 根据年份值组合多维数组

P粉193307465 2024-02-17 21:06:08

[MySQL讨论组]

461

这是我想要根据年份值组合的数组

0 => array:3 [▼
    "year" => 2022
    "total_policies_financed" => 1
    "total_amount_financed" => 280.0
  ]
  1 => array:3 [▼
    "year" => 2022
    "total_policies_financed" => 2
    "total_amount_financed" => 5190.0
  ]
  2 => array:3 [▼
    "year" => 2021
    "total_policies_financed" => 2
    "total_amount_financed" => 5190.0
  ]

需要这样的输出

0 => array:3 [▼
    "year" => 2022,
    "total_count" => 2,
    "total_policies_financed" => 3
    "total_amount_financed" => 5470
  ]
  1 => array:3 [▼
   "year" => 2021,
    "total_count" => 1,
    "total_policies_financed" => 2
    "total_amount_financed" => 5190.0
  ]

P粉193307465

全部回复(1)

P粉6330757252024-02-18 18:25:28 1楼

试试这个：

$arr = collect($array)->groupBy('year')->map(function ($items, $key){
    return [
        'year' => $key,
        'total_count' => $items->count(),
        'total_policies_financed' => $items->sum('total_policies_financed'),
        'total_amount_financed' => $items->sum('total_amount_financed'),
    ];
})->values();

dd($arr);