i want get only items has avg rate equal [3,5] // Example
when write in model
public function rate()
{
return $this->hasMany('App\Models\Rate', 'fk_service')->avg(rate);
}
get error Call to a member function addEagerConstraints() on string
when remove "->avg(rate)" get all data but i want only average rate
when write in model
public function rate()
{
return $this->hasMany('App\Models\Rate', 'fk_service');
}
// and in controller
$engravings = Engraving::where('engravings.status', 1);
if(!empty($request->rate)){
$engravings->whereHas('rate', function($query) use ($request){
// Code use WhereIn How To do it
});
}
$engravings = $engravings->get();
from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2VIHzT4
via IFTTT
Aucun commentaire:
Enregistrer un commentaire