Home / Questions / 352330
Accepted
DAD
Asked: 2020-05-05 18:37:10 +0800 CST 2020-05-05 18:37:10 +0800 CST

send data from controller with conditions to .blade with laravel

  • 772

Ok, I have 2 tables; PROFORMA- EQUIPOS(a third one that is a project, but that relationship is not the problem)

enter image description here

Well in programming what I need to do is something like this:
enter image description here

What I had to do is already solved, the issue is that I would like this to be done in the controller and not in the blade.

Well now the issue is that, I have made a condition proformas.bladewhere it verifies that fk_equipos_proformait is equal to the one idin the proforma so that when I do @foreachit it shows me the equipment corresponding to that proforma, because they are nproformas that are shown no 1.

and I want to see if someone can help me with the condition that I have in the blade, I can do it in the controller:

Blade condition:

    <tbody class="t-equipos-body">
      @foreach ($filas as $item2)
           <tr>
               @if ($item->id_proforma == $item2->fk_equipos_proforma)
                 <td>{{$item2->descripcion}}</td>
                 <td>{{$item2->cantidad}}</td>
                 <td>$ {{$item2->precio_unidad}}</td>
                 <td>$ {{$item2->total_fila}}</td>
              @endif  
           </tr>
       @endforeach                
    </tbody>

So my question is how to make the query in the controller that can make me that same condition.

 @if ($item->id_proforma == $item2->fk_equipos_proforma)

$item (PROFORMA) $item2 (EQUIPOS)

For now I only have these queries:

 $proformas = DB::table('proforma')->where('fk_proforma_proy', $datos)->get();

    $filas = DB::table('equipos')->where('fk_equipos_proy',$datos)->get();
laravel

1 Answers

  1. Best Answer

    For your scenario we require 2 models, which are:

    • Pro forma
    • Equipment

    The syntax is simple:

    php artisan make:model NombreModelo

    Each of these models will have a declared relationship that links them to their counterpart model, as follows:

    The Proforma model has many teams so use the method hasMany()like this:

    class Proforma extends Model 
{
    protected $table = "proforma";
    public function equipos()
    {
        return $this->hasMany(Equipo::class, 'Fk_equipos_proforma');
    }
}

    On the other hand Team belongs to... and then use the method belongsTo()like this:

    class Equipo extends Model 
{
    protected $table = "equipos";
    public function proforma()
    {
        return $this->belongsTo(Proforma::class);
    }
}

    Now we build the query where:

    • We invoke the Proforma model
    • We make a ambitious load of its relations with eager loadingpassing as argument the name of the relation
    • We filter the proformas through your idto only obtain the equipment related to it

    Thus:

    $equiposProforma = Proforma::with('equipos')->findOrFail($idProforma);

    Where $idProformais the variable that stores the id of the proforma that you want to use to get its related equipment.

    Finally to be able to iterate them we do the following in the view

    @foreach($equiposProforma as $equipoProforma)
    {{ propiedadUnoProforma }}
    {{ propiedadDosProforma }}
    @foreach($equipoProforma->equipos as $equipo)
        {{ propiedadUnoEquipos }}
        {{ propiedadDosEquipos }}
    @endforeach
@endforeach

    The previous query should be returning at the level of the first foreach the values ​​of the properties of the proforma model and within the second foreach the values ​​of the properties of the Team model.

    On the other hand, if you want all the proformas with their associated equipment, then just replace the use of findOrFail()with that of get(), the rest should remain the same:

    $equiposProforma = Proforma::with('equipos')->get();

    Clarifications:

    • Since your tables do not follow the Laravel conventions in their names, you must declare a property in the models that is equal to the name of each of them.
    • The foreign key that links to teams with proforma also does not follow the naming convention that Eloquent expects it to be: columna_idso in the method hasMany()as the second argument you must pass the name of said foreign key as a string.

    References

    • 1