Compare two tables and arrange the values in a new array

Question

I have t things working with this current setup:

Route::get('test', function(){
    $finished = \App\Progress::select('stack_id')->get();
    $unfinished = \App\Stack::select(['id as stack_id'])->get();

    foreach ($unfinished as $key => $value) {
        if(!isset($finished[$key])){
            break;
        }
        if($value->stack_id == $finished[$key]->stack_id){
            unset($unfinished[$key]);
        }
    }
    return response()->json(['finished' => $finished->flatten(), 'unfinished' => $unfinished->flatten()]);
});

Two current values in progresses table and three values in stacks table

Progresses

id user_id stack_id
6   1   1
9   1   2

Stacks

id
1
2
3

The response:

{
"finished": [
{
"stack_id": 1
},
{
"stack_id": 2
}
],
"unfinished": [
{
"stack_id": 3
}
]
}

Can this be done in another, more efficient way?

Answer 1

you can create an array of finished and unfinished which contain stack_id and then use array_diff method in PHP.