Sort an array based on related data in a 2d array

Question

So I've searched for hours but no thread seems to get me to a working solution.

My problem; I've got 2 arrays. 1 array with the user's roles. And one array with all roles with an specific order.

$roles = [
    [
        'id' => 22465,
        'name' => 'Rank 1',
        'position' => 24,
        'color' => 16711680,
    ],
    [
        'id' => 59454,
        'name' => 'Rank 2',
        'position' => 15,
        'color' => 15844367,
    ],
    [
        'id' => 62280,
        'name' => 'Rank 3',
        'position' => 2,
        'color' => 65494,
    ],
    [
        'id' => 67139,
        'name' => 'Rank 4',
        'position' => 10,
        'color' => 1146986,
    ],
    [
        'id' => 75372,
        'name' => 'Rank 5',
        'position' => 25,
        'color' => 1146986,
    ],
    [
        'id' => 75373,
        'name' => 'Rank 6',
        'position' => 18,
        'color' => 1146986,
    ],
];

And I have the user roles array:

$userdata = [
    'roles' => [22465, 59454, 62280, 67139, 75372, 75373],
    'data' => ['irrelevant']
];

I want the user roles array to be sorted to the roles 'position' in the other array. I think the bottleneck is in the part that the array has to be called with the subarray [roles][position] to get the order to work.

The result in the roles subarray should be:

[0] => 75372
[1] => 22465
[2] => 75373
[3] => 59454
[4] => 67139
[5] => 62280

Tangentially Perpendicular · Accepted Answer · 2021-03-14 02:21:10Z

1

// First, build a lookup table relating id directly to position
$ranks = [];
foreach($roles as $role) {
    $ranks[$role['id']] = $role['position'];
}

var_dump($ranks);

// Now sort the table using the lookup table we just produced
//
 usort($userdata['roles'], function($a, $b) use ($ranks){
        return $ranks[$b] <=> $ranks[$a];
 });

var_dump($userdata);

Content of userdata array after sorting

array (size=2)
  'roles' => 
    array (size=6)
      0 => int 75372
      1 => int 22465
      2 => int 75373
      3 => int 59454
      4 => int 67139
      5 => int 62280
  'data' => 
    array (size=1)
      0 => string 'irrelevant' (length=10)

answered Mar 14, 2021 at 2:21

Tangentially Perpendicular

5,4364 gold badges15 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mickmackusa · Accepted Answer · 2025-02-02 09:48:16Z

0

A more concise alternative script for effectively the same code as @TangientiallyPerpendicular uses array_column() to create the lookup array and arrow function syntax to avoid having to write use() and return. Demo

$map = array_column($roles, 'position', 'id');
usort($userdata['roles'], fn($a, $b) => $map[$b] <=> $map[$a]);
var_export($userdata);

answered Feb 2 at 9:48

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Sort an array based on related data in a 2d array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related