php数组多字段排序

1、函数说明

  • array_multisort():对多个数组或多维数组进行排序。
  • 参数默认:升序,SORT_ASC=升序,SORT_DESC=降序

2、例子

  • 需求:货位号 A-01-02-03(区域-通道-货架层-货位),现在要数据进行按【区域、通道、货位】升序排序
$arr = [
    ['sku' => 'xx', 'container_no' => 'A-01-02-03'],
    ['sku' => 'xx2', 'container_no' => 'B-01-02-03'],
    ['sku' => 'xx3', 'container_no' => 'A-22-02-01'],
    ['sku' => 'xx3', 'container_no' => 'A-02-05-06'],
];

$sort1 = $sort2 = $sort3 = [];
foreach ($arr as $key => $item) {
    $container = explode('-', $item['container_no']);
    $sort1[$key] = $container[0];
    $sort2[$key] = $container[1];
    $sort3[$key] = $container[3];
}
array_multisort($sort1, SORT_ASC, $sort2, SORT_ASC, $sort3, SORT_ASC, $arr);
dd($arr);
  • 结果

array:4 [
0 => array:2 [
"sku" => "xx"
"container_no" => "A-01-02-03"
]
1 => array:2 [
"sku" => "xx3"
"container_no" => "A-02-05-06"
]
2 => array:2 [
"sku" => "xx3"
"container_no" => "A-22-02-01"
]
3 => array:2 [
"sku" => "xx2"
"container_no" => "B-01-02-03"
]
]

posted @ 2022-08-19 16:14  pine007  阅读(57)  评论(0编辑  收藏  举报