我已经将数组转换为JSON,如下所示:
[
{
"name": "Sally",
"nick_name": "sal",
"availability": "0",
"is_fav": "0"
},
{
"name": "David",
"nick_name": "dav07",
"availability": "0",
"is_fav": "1"
},
{
"name": "Zen",
"nick_name": "zen",
"availability": "1",
"is_fav": "0"
},
{
"name": "Jackson",
"nick_name": "jack",
"availability": "1",
"is_fav": "1"
},
{
"name": "Rohit",
"nick_name": "rod",
"availability": "0",
"is_fav": "0"
},
]
我想根据 is_fav
、availability
和 nick_name
的值按以下顺序对整个数组进行排序:
[ is_fav:1 availability:1 ]
[ is_fav:1 availability:0 ]
[ is_fav:0 availability:1 ]
[ is_fav:0 availability:0 ]
在每种情况下,元素都使用nick_name
按字母顺序排序
所以上面例子中的最后一个数组看起来像
[
{
"name": "Jackson",
"nick_name": "jack",
"availability": "1",
"is_fav": "1"
},
{
"name": "David",
"nick_name": "dav07",
"availability": "0",
"is_fav": "1"
},
{
"name": "Zen",
"nick_name": "zen",
"availability": "1",
"is_fav": "0"
},
{
"name": "Rohit",
"nick_name": "rod",
"availability": "0",
"is_fav": "0"
},
{
"name": "Sally",
"nick_name": "sal",
"availability": "0",
"is_fav": "0"
},
]
试试这个array_multisort
$arr = json_decode($data, true);
// Obtain a list of columns
foreach ($arr as $key => $row) {
$isFav[$key] = $row['is_fav'];
$avail[$key] = $row['availability'];
$names[$key] = $row['nick_name'];
}
// Sort the data with isFav descending, avail descending
// Add $arr as the last parameter, to sort by the common key
array_multisort($isFav, SORT_DESC, $avail, SORT_DESC, $names, SORT_ASC, $arr);
你可以在这里看到它的实际效果(3v4l.org)
你可以使用 PHP 的usort
函数,如
usort($arr,function($a,$b){
$c = $b['is_fav'] - $a['is_fav'];
$c .= $b['availability'] - $a['availability'];
$c .= strcmp($a['nick_name'],$b['nick_name']);
return $c;
});
print_r($arr);
$arr = json_decode($data, true);
usort($arr, function ($item1, $item2) {
// your condition
if ($item1['is_fav'] && !$item2['is_fav']) return 1;
if (!$item1['is_fav'] && $item2['is_fav']) return -1;
if ($item1['availability'] > $item2['availability']) return 1;
if ($item1['availability'] < $item2['availability']) return -1;
return 0;
});
$data = json_encode($arr);