我有一個看起來像這樣的數組：[{ "id": "1", "country_id": "1", "spec_id": "1", "spec_children_name": "SUPER REDUCES RATE", "spec_children_first_col": "", "spec_children_second_col": "", "spec_children_third_col": ""},{ "id": "2", "country_id": "1", "spec_id": "1", "spec_children_name": "REDUCED RATE", "spec_children_first_col": "10% and 13%", "spec_children_second_col": "food, passenger transport, accommodotion, newspaper, pharmaceutical products,\u2026.(10%); plants, antiques, firewood, cinema, theatre,\u2026(13%)", "spec_children_third_col": ""},{ "id": "3", "country_id": "1", "spec_id": "1", "spec_children_name": "MEDIUM RATE", "spec_children_first_col": "", "spec_children_second_col": "", "spec_children_third_col": ""},{ "id": "4", "country_id": "1", "spec_id": "1", "spec_children_name": "STANDARD RATE", "spec_children_first_col": "20%", "spec_children_second_col": "other", "spec_children_third_col": ""},{ "id": "5", "country_id": "1", "spec_id": "1", "spec_children_name": "ZERO RATE", "spec_children_first_col": "", "spec_children_second_col": "", "spec_children_third_col": ""}, { "id": "104", "country_id": "2", "spec_id": "1", "spec_children_name": "REDUCED RATE", "spec_children_first_col": "TEXT 547", "spec_children_second_col": "TEXT 1000", "spec_children_third_col": "" }]我想要什么：我想按2個對象鍵比較對此數組進行排序，如果和.最后，它應該看起來像這樣：spec_children_namespec_id [ [ { "id": "1", "country_id": "1", "spec_id": "1", "spec_children_name": "SUPER REDUCES RATE", "spec_children_first_col": "", "spec_children_second_col": "", "spec_children_third_col": "" },
3 回答
小唯快跑啊
TA貢獻1863條經驗 獲得超2個贊
您的問題基本上是如何根據兩個鍵對數組進行排序。在許多編程語言中，包括PHP，答案是創建一個比較函數（有時稱為比較器），該函數根據其參數所需的相對順序返回值（通常為-1，0，1）。如果兩個鍵中的第一個參數不同，則根據第一個鍵的順序返回 -1 或 1。它們在第一個鍵上相等，檢查第二個鍵 - 并根據第二個鍵的順序返回-1，0，1。此邏輯自然可以擴展到任意數量的密鑰。PHP Spaceship 運算符 <=> 為許多內置類型實現了此邏輯。
下面的代碼演示了使用 PHP 的方案的這一點。它是從這個問題改編而來的。在這里，我假設您要按速率（零<超減<減<中等<標準）進行排序，然后按（數字）進行排序。我也糾正了.spec_idSUPER REDUCES RATESUPER REDUCED RATE
$RATE_ORDERING = array(
'ZERO RATE' => 1,
'SUPER REDUCED RATE' => 2,
'REDUCED RATE' => 3,
'MEDIUM RATE' => 4,
'STANDARD RATE' => 5
);
$arr = array(
array('spec_id' => 2, 'spec_children_name' => 'STANDARD RATE'),
array('spec_id' => 1, 'spec_children_name' => 'STANDARD RATE'),
array('spec_id' => 2, 'spec_children_name' => 'ZERO RATE'),
array('spec_id' => 1, 'spec_children_name' => 'MEDIUM RATE'),
array('spec_id' => 2, 'spec_children_name' => 'REDUCED RATE'),
array('spec_id' => 2, 'spec_children_name' => 'MEDIUM RATE'),
array('spec_id' => 1, 'spec_children_name' => 'SUPER REDUCED RATE'),
array('spec_id' => 2, 'spec_children_name' => 'SUPER REDUCED RATE'),
array('spec_id' => 1, 'spec_children_name' => 'REDUCED RATE'),
array('spec_id' => 1, 'spec_children_name' => 'ZERO RATE')
);
usort($arr, function ($a, $b) use ($RATE_ORDERING) {
$result = $RATE_ORDERING[$a['spec_children_name']] - $RATE_ORDERING[$b['spec_children_name']];
if ($result != 0) {
return $result;
}
return $a['spec_id'] - $b['spec_id'];
});
var_dump($arr);
輸出：
array(10) {
[0]=>
array(2) {
["spec_id"]=>
int(1)
["spec_children_name"]=>
string(9) "ZERO RATE"
}
[1]=>
array(2) {
["spec_id"]=>
int(2)
["spec_children_name"]=>
string(9) "ZERO RATE"
}
[2]=>
array(2) {
["spec_id"]=>
int(1)
["spec_children_name"]=>
string(18) "SUPER REDUCED RATE"
}
[3]=>
array(2) {
["spec_id"]=>
int(2)
["spec_children_name"]=> [17/133]
string(18) "SUPER REDUCED RATE"
}
[4]=>
array(2) {
["spec_id"]=>
int(1)
["spec_children_name"]=>
string(12) "REDUCED RATE"
}
[5]=>
array(2) {
["spec_id"]=>
int(2)
["spec_children_name"]=>
string(12) "REDUCED RATE"
}
[6]=>
array(2) {
["spec_id"]=>
int(1)
["spec_children_name"]=>
string(11) "MEDIUM RATE"
}
[7]=>
array(2) {
["spec_id"]=>
int(2)
["spec_children_name"]=>
string(11) "MEDIUM RATE"
}
[8]=>
array(2) {
["spec_id"]=>
int(1)
["spec_children_name"]=>
string(13) "STANDARD RATE"
}
[9]=>
array(2) {
["spec_id"]=>
int(2)
["spec_children_name"]=>
string(13) "STANDARD RATE"
}
}
拉風的咖菲貓
TA貢獻1995條經驗 獲得超2個贊
宇宙飛船操作員將自動處理所有數據類型。將動態列名和排序方向“factor”傳遞到自定義函數作用域中。use()
代碼：
$objects = json_decode($json);
$column = 'spec_children_name';
$direction = 'asc';
$reverser = $direction === 'asc' ? 1 : -1;
uasort($objects, function($a, $b) use ($column, $reverser) {
return $reverser * ($a->$column <=> $b->$column);
});
var_export($objects);
或者也許...
$objects = json_decode($json);
$rules = ['spec_id' => 'ASC', 'spec_children_name' => 'DESC'];
uasort($objects, function($a, $b) use ($rules) {
foreach ($rules as $column => $order) {
$left[] = $order === 'ASC' ? $a->$column : $b->$column;
$right[] = $order === 'ASC' ? $b->$column : $a->$column;
}
return $left <=> $right;
});
var_export($objects);
慕村9548890
TA貢獻1884條經驗 獲得超4個贊
幾乎沒有理由像array_multisort和array_column那樣重新發明一個功能。
$data =
[
[
'name' => 'John',
'age' => 34
],
[
'name' => 'Jack',
'age' => 55,
],
[
'name' => 'Adam',
'age' => 42
],
[
'name' => 'Jack',
'age' => 78
],
[
'name' => 'Adam',
'age' => 80
]
];
array_multisort(array_column($data, 'name'), SORT_ASC, array_column($data, 'age'), SORT_DESC, $data);
var_export($data);
輸出：
array (
0 =>
array (
'name' => 'Adam',
'age' => 80,
),
1 =>
array (
'name' => 'Adam',
'age' => 42,
),
2 =>
array (
'name' => 'Jack',
'age' => 78,
),
3 =>
array (
'name' => 'Jack',
'age' => 55,
),
4 =>
array (
'name' => 'John',
'age' => 34,
),
)
- 3 回答
- 0 關注
- 153 瀏覽
添加回答
舉報
0/150
提交
取消