Laravel pluck an array from nested relationship

Question

I need to get only the roomnumber arrays returned from the following query:

$roomnumbers = Room::with(['floorroomcount' => function($query){
                $query->with('roomnumber')->get();
        }])->where('roomtype_id', $roomtype_id)->get();

Tried: The follow pluck is returning floorroomcount

$roomnumbers->pluck('floorroomcount');

but i need roomnumber array, how can i get?

Did you try $roomnumbers->pluck('floorroomcount.roomnumber');? — Jonas Staudenmeir
– Jonas Staudenmeir, Commented May 9, 2018 at 11:54
But if you dd($roomnumbers);, the roomnumber data does exist? — Jonas Staudenmeir
– Jonas Staudenmeir, Commented May 9, 2018 at 12:19
yes it exist, room and inside it has floorroomcount and inside it has roomnumber — arun
– arun, Commented May 9, 2018 at 12:29

Jonas Staudenmeir · Accepted Answer · 2018-05-09 12:36:37Z

30

This gives you all roomnumber results in one collection:

$roomnumbers->pluck('floorroomcount')->collapse()->pluck('roomnumber')->collapse();

answered May 9, 2018 at 12:36

Jonas Staudenmeir

26k7 gold badges70 silver badges115 bronze badges

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

5 Comments

arun Over a year ago

yup super. it gives roomnumber array

arun Over a year ago

i was searhing for long time to coimbine arrays, and collapse did it in nice way

Steen Schütt Over a year ago

There has to be a prettier solution, currently I have code like this:

Group::with('service_groups.services')->get()->each->service_groups->each->services->pluck('service_groups')->collapse()->pluck('services')->collapse()->pluck('name');

I know it's just a bit much, but it's basically a many to many to many relationship, so what can you do...

Steen Schütt Over a year ago

Update: I found a fix and posted it as an answer :)

Robby Alvian Jaya Mulia Over a year ago

collapse() is the answer, that just saved my whole life to handle nested relationship. Thank you!

Jonas Staudenmeir · Accepted Answer · 2019-07-26 13:28:54Z

8

You may shorten @Jonas Staudenmeir's answer like so:

$roomnumbers->pluck('floorroomcount.*.roomnumber.*')->collapse();

pluck('*') is essentially the same as collapse() in this particular context.

edited Jul 26, 2019 at 13:28

Jonas Staudenmeir

26k7 gold badges70 silver badges115 bronze badges

answered Jul 26, 2019 at 7:15

Steen Schütt

1,5041 gold badge19 silver badges32 bronze badges

2 Comments

Jonas Staudenmeir Over a year ago

Is the trailing .* necessary?

Steen Schütt Over a year ago

@Jonas Staudenmeir I honestly don't know, but actually it probably shouldn't be there at all... Given the collapse(), that is.

arun · Accepted Answer · 2018-05-09 11:35:07Z

1

This is working, but with many loop and echoing directly, if anything can be simplified please let me know :

   $roomnumbers = Room::with(['floorroomcount.roomnumber'])->where('roomtype_id', $roomtype_id)->get();

    $floorroomcounts =  $roomnumbers->pluck('floorroomcount');

    $records =  $floorroomcounts->map(function($floorroomcount, $value){

                    return $floorroomcount->pluck('roomnumber')->flatten();

                })->values()->all();        

    foreach($records as $record){

        foreach($record as $row){
            echo '<option value='.$row->id.'>'.$row->roomnumber.'</option>';
        }

    }

    //return response()->json($roomnumbers);

answered May 9, 2018 at 11:35

arun

4,8135 gold badges24 silver badges43 bronze badges

Comments

Dev · Accepted Answer · 2018-05-10 04:37:36Z

0

Try,

$roomnumbers = Room::with(['floorroomcount' => function($query){
    $query->with('roomnumber')->get();
}])
->where('roomtype_id', $roomtype_id)
->get();

$records = $roomnumbers->map(function($element, $value){
    return $element->map(function($e, $v){
        return $e->roomnumber;
    });
})->values()->all();

map() is a Laravel collection method so you need to import the collection facade on the top of the controller like: use Illuminate\Support\Collection;

edited May 10, 2018 at 4:37

answered May 9, 2018 at 9:14

Dev

6,75013 gold badges71 silver badges112 bronze badges

4 Comments

arun Over a year ago

changed return $element->roomnumber; its not working returning [null,null,null]

Dev Over a year ago

just dd($element) and dd($value) inside map() function, what are you getting?

arun Over a year ago

dd($element) gives while room object. and dd($value) gives 0

Dev Over a year ago

Try my updated answer. You will might get the nested array of room numbers, you need to flatten it. See laravel.com/docs/5.6/collections#method-flatten

Abbas Arif · Accepted Answer · 2021-11-27 20:46:11Z

0

In Laravel 5.1 and + you can use flatten() on collection.

method flattens a multi-dimensional collection into a single dimension:

$roomnumbers->flatten()->pluck('floorroomcount');

answered Nov 27, 2021 at 20:46

Abbas Arif

3985 silver badges18 bronze badges

Collectives™ on Stack Overflow

Laravel pluck an array from nested relationship

5 Answers 5

5 Comments

2 Comments

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

2 Comments

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related