Difficolt Query

Hey @theblack68

Ok so this is at the moment ManyToMany relationship https://laravel.com/docs/5.8/eloquent-relationships#many-to-many

Your information is on pivot intermediate table so your result should look like this:

 $cables = Cable::all();

        foreach($cables as $cable){

            $cable_features = [];

            foreach ($cable->featue as $feature) {
                 array_push($cable_features,  $feature->pivot->name);
            }

            echo $cable->code .implode(' - ', $cable_features);
        }

Given that third column at your pivot table is called name

Hope it helps!

First of all thanks for the help that you give me.

Explanation: I have write in italian (Cavi = Cables | Features = Caratteristiche)

I have resolved with a bit of code but I think is not a good super-solution (but works ;) )

The Maatwebsite/Excel package give you the ability to build $data to export. I have build all so:

$cavi = Cavo::with('famiglia', 'caratteristiche')->get();

        return $cavi->map(function($cavo) {
            foreach ($cavo->caratteristiche as $caratteristica) {
                if($caratteristica->id == 5 || $caratteristica->id == 7) {
                    $caratteristicheCavo[] = $caratteristica->pivot->valore;
                }
            }

            return $datiEplanArray = [
                'ParNumber' => "AGE" . $cavo->codice_articolo,
                'TypeNumber' => $cavo->famiglia->codice_articolo,
                'OrderNumber' => $cavo->codice_articolo,
                'Designation EN' => $cavo->famiglia->nome,
                'Description EN' => $cavo->famiglia->descrizione,
                'Document/Link 1' => '/ita/pdf/' . $cavo->famiglia->codice_articolo . '.pdf',
                'Description Doc. 1 EN' => '/en//pdf/' . $cavo->famiglia->codice_articolo . '.pdf',
                'ExternalDiameter / ND' => $caratteristicheCavo[1],
                'Connections / Number ' => $caratteristicheCavo[0],
                'Cable type' => $cavo->famiglia->nome,   
                'PreviewPicture' => '/immagini/' . $cavo->famiglia->immagine,
                'EDP catalogue structure level 1 EN' => 'Cavo',
            ];
        });

Hey @aurawindsurfing

Maybe you can help me ;(

I have 3 tables in database >>> with a many to many relationship:

• cables

• feature

• cable_feature

I have 2 Model (I have set a public function belongsToMany):

• Cable

• Feature

I have a controller for send data to View

In this view I have a table >>> I get some value from a controller (Cable name >>> cable family and so on).

My problem are the column of the feature >>> I need to have 4 feature:

• Voltage

• ColorType

• Pvc

• Shield

Not all the cables have all 4 features so I need to let Empty if the feature are not set ...you can give me an Help please?

Example:

[cable] [voltage] [ColorType] [Pvc] [Shield]

[cable12] [450 Volt] [red] [empty] [empty]

[cable13] [480 Volt] [empty] [Yes] [Yes]

Thanks a lot ;)

Hey @theblack68

While defining your migrations set fields as ->nullable() this will allow them to be set to null if needed.

HEY @aurawindsurfing

So when I create or update records in the table cable_feature even if they don't have that feature I have to set it to null?

Hey @theblack68

No, if cable_feature is pivot table Many-to-Many then you just set the values you need. If the others are not set then they will not show in your results, which is what you want I think.

Hey @aurawindsurfing

I have resolved so:

• I get with in_array the only features that I want by their ID (5, 6, 7, 8)

• With array_column I have set the Key with the ID of Feature

• And finally I check the Key with the Isset ...so If isset I show the value else I show a "-"

...I don't know if is the right way but works good!

Thanks ;)