Laravel: Fetch all the values and check it against boolean attribute

Question

I need some advice and help on the following topic.

I have a setup of migrations like this.

+--------------------+----------------------+--------------------+
|       plates       |   plates_container   |  container_slots   |
+--------------------+----------------------+--------------------+
| id                 | id                   | id                 |
| plate_container_id | number_of_slots(int) | slot               |
| container_slot_id  |                      | occupied (boolean) |
|                    |                      | plate_container_id |
+--------------------+----------------------+--------------------+

The relations between tables goes like this.

Plate

Plate belongsTo a platecontainer
Plate belongsTo containerslot

PlateContainer

platecontainer hasMany containerSlots
platecontainer hasMany plates

ContainerSlot

ContainerSlot belongsTo plateContainer
ContainerSlot hasOne plate

Question

How can I (specified by id) fetch all the number_of_slots and check which of those slots are already occupied and which are not.

So to clarify a bit more. A list like this or similar is what I am asking for.

slots = [

 1 => false,
 2 => false,
 3 => true, 
 4 => false
//etc

];

If you have any other suggestions regarding the database structure, please let me know in the comments. I am slightly doubtful about updating the occupied attribute every time after the user chooses a slot for the plate.

When you said “how can I (specified by id)…”, which id in particular? — Rubens Mariuzzo
– Rubens Mariuzzo, Commented Dec 2, 2015 at 16:03

Rubens Mariuzzo · Accepted Answer · 2015-12-02 16:10:53Z

1

The Eloquent's collection methods and pluck will help you. Assuming you have defined your models properly for each of the mentioned tables you can do:

PlateContainer::find($id)
              ->container_slots
              ->pluck('occupied', 'id');

This will give you the expected results you are looking for in the following form (which is basically an array):

=> Illuminate\Database\Eloquent\Collection {#1859
     all: [
       1 => true,
       2 => true,
       3 => false,
       4 => true
     ],
   }

answered Dec 2, 2015 at 16:10

Rubens Mariuzzo

29.4k28 gold badges125 silver badges149 bronze badges

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

7 Comments

user3641381 Over a year ago

Gold! Exactly what I have been looking for! You have guessed good! I meant id of a platecontainer. Thanks!

Rubens Mariuzzo Over a year ago

I'm glad that it helped you.

user3641381 Over a year ago

I know this is not the original question, but I was just wondering if it's possible to fetch all three attributes (id, slot, occupied) and having those show just like in your above mentioned answer. I check the docs for it, but could find anything similar .

Rubens Mariuzzo Over a year ago

There's a 'only' method where you could pass an array of property name.

user3641381 Over a year ago

I gave this a try. PlateContainer::find(1)->containerSlots->only('occupied', 'slot', 'id'); only its returning empty array. just like this Collection {#467 #items: [] }

|

Collectives™ on Stack Overflow

Laravel: Fetch all the values and check it against boolean attribute

Question

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Question

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related