Laravel pass variable from controller query to model function

Question

I have a function on my model that check active status in equipment_station table,

originally it only checked one status, now i need to pass a parameter to the model with active or inactive values, I've tried this with no success.

controller:

model :

How can i change the parameter in the model, I send status from controller as inactive or active.

thanks in advance

could you paste the code instead of upload a screenshot

cwang
– cwang

2017-06-09 01:10:32 +00:00
Commented Jun 9, 2017 at 1:10 — cwang
– cwang, Commented Jun 9, 2017 at 1:10

cwang · Accepted Answer · 2017-06-09 01:18:45Z

1

You could you query scope

public function scopeActive($query, $active)
{
   return $query->where('active', $active);
}

then you can call it in your model

Estacion::active(true)->get();

answered Jun 9, 2017 at 1:18

cwang

1,10411 silver badges21 bronze badges

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

Comments

linktoahref · Accepted Answer · 2017-06-09 03:28:20Z

1

You could Constraint Eager Loading by specifying additional query constraints for the eager loading

$historial_estaction = 
Estacion::where('estacion.id', $id)
   ->whereHas('equipos', function($query) use ($estado1) {
        $query->where('equipo_estacion.estado', $estado1);
    })->with(['equipos' => function ($query) use ($estado1) {
        $query->where('estado', $estado1);
    }])->get();

Model:

public function equipos()
{
    return $this->belongsToMany('App\Equipo')
                ->withPivot('estado')
                ->withTimestamps();
}

edited Jun 9, 2017 at 3:28

answered Jun 9, 2017 at 3:19

linktoahref

8,0273 gold badges32 silver badges54 bronze badges

Collectives™ on Stack Overflow

Laravel pass variable from controller query to model function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related