Forum How to return a single value from a scope?

mabasic

posted 10 years ago

Database Eloquent Views

Last updated 2 years ago.

mabasic

replied 10 years ago

Solution

This is the solution from an IRC user JasonLewis

public function scopeCityName($query)
{
    return $query
        ->join('cities', 'cities.id', '=', 'realestates.city_id')
        ->join('city_translations', 'cities.id', '=', 'city_translations.city_id')
        ->join('languages', 'city_translations.language_id', '=', 'languages.id')
        ->where('languages.code','=',Session::get('my.lang'))
        ->where('realestates.id','=',$this->id)
        ->select('city_translations.name as name')->pluck('name');
}

Last updated 2 years ago.