CODEWITHSUNDEEP
phparrays
Mr. Jo
Mr. Jo

Reputation: 5261

Move array entries depending on the order of a specific value sorted in another array

I need some help because I'm stuck. I've developed a HTML/JS/PHP sorting where users can move elements around or create child elements by moving an element inside another. As a result, I'm getting this array:

$sorted_ids = [
    '2', // <-- Value = Main element ID
    [
        '4' => [ // <-- Key = Main element ID
            '3' // <-- Value = Child element ID
        ]
    ]
    '1', // <-- Value = Main element ID
];

On the other side, I have my array of elements containing all of these above IDs:

$elements = [
    [
        'id' => '1',
        'name' => 'Test1'
    ],
    [
        'id' => '2',
        'name' => 'Test2'
    ],
    [
        'id' => '3',
        'name' => 'Test3'
    ],
    [
        'id' => '4',
        'name' => 'Test4'
    ]
];

I've used now the following code to loop through the array of sorted IDs:

foreach ( $sorted_ids as $sorted_id ) {
    if ( is_array( $sorted_id ) ) {
        foreach ( $sorted_id as $sorted_parent_id => $sorted_child_id ) {

        }
    } else {

    }
}

In my loop, I can now access all relevant IDs, but I really don't know how to sort the elements by its field ID. I've tried using array_shift() but always went wrong. Maybe there is a better idea?

At the end, my elements array need to look like this:

$elements = [
    [
        'id' => '2'
        'name' => 'Test2'
    ],
    [
        'id' => '4',
        'name' => 'Test4'
    ],
    [
        'id' => '3',
        'name' => 'Test3'
    ],
    [
        'id' => '1,
        'name' => 'Test1'
    ]
];

Update

I forgot to mention that my objects in the elements array can have multiple fields like name, field, place, value... (I just added name as an example), so just flatten the sorted IDs array might be a good idea, but problematic!

Upvotes: 0

Views: 57

Answers (1)

endeavour
endeavour

Reputation: 619

The input array can be understood in a clearer manner if we include the keys in the output. A var_dump of the input array would look like this

array (size=3)
  0 => string '2' (length=1)
  1 => 
    array (size=1)
      4 => 
        array (size=1)
          0 => string '3' (length=1)
  2 => string '1' (length=1)

As per the question there are two inferences

  1. The input array is already sorted, so all we need to do is flatten it.
  2. The nesting levels is finite. If the levels of nesting was not known we would need a recursive function.

Therefore, all we need to do is iterate over the input array and assign the values of interest to the output array.

$elements = [
    [
        'id' => '1',
        'name' => 'Test1'
    ],
    [
        'id' => '2',
        'name' => 'Test2'
    ],
    [
        'id' => '3',
        'name' => 'Test3'
    ],
    [
        'id' => '4',
        'name' => 'Test4'
    ]
];
## Assuming 'id' is unique. We re-index the $elements array with id as key - makes it easier to access its elements.
$elementsArray = array_column($elements, null, 'id');

$sorted_ids = [
    '2', // <-- Value = Main element ID
    [
        '4' => [ // <-- Key = Main element ID
            '3' // <-- Value = Child element ID
        ]
    ],
    '1', // <-- Value = Main element ID
];
$results = [];

foreach ( $sorted_ids as $sorted_id ) {
    if ( is_array( $sorted_id ) ) {
        foreach ($sorted_id as $sorted_parent_id => $sorted_child_id_array) {
            $results[] = $elementsArray[$sorted_parent_id];
            ## IF more than one child we use foreach
            $results[] = $elementsArray[$sorted_child_id_array[0]];
        }
    } else {
        $results[] = $elementsArray[$sorted_id];
    }
}
var_dump($results);

The output for the above will be

array (size=4)
  0 => 
    array (size=2)
      'id' => string '2' (length=1)
      'name' => string 'Test2' (length=5)
  1 => 
    array (size=2)
      'id' => string '4' (length=1)
      'name' => string 'Test4' (length=5)
  2 => 
    array (size=2)
      'id' => string '3' (length=1)
      'name' => string 'Test3' (length=5)
  3 => 
    array (size=2)
      'id' => string '1' (length=1)
      'name' => string 'Test1' (length=5)

And the sandbox link with a working solution Sandbox link after the edit

As a footnote I must mention that you may want to redo the codes to create the nested array. In fact since the output is a flat array why even create a nested one. The input array can be created like this too

$sorted_ids = [
    [
        'id' => '1',
        'order' => 4
    ],
    [
        'id' => '2',
        'order' => 1
    ],
    [
        'id' => '3',
        'order' => 3
    ],
    [
        'id' => '4',
        'order' => 2
    ]
];

This would make it much easier to achieve what you want without the need for a loop. Whether this can be done or not depends on the codes creating the input array. My guess is to relook at the statement can move elements around or create child elements by moving an element inside another. As the output stands there is no parent child relationship maintained (which may be implemented in your codes) and hence we may even rephrase it to can move elements around which leaves us with a JS function to keep a track of the moved sort order. Again these are guesses since you have not shared those codes.

Upvotes: 1

Related Questions