Laravel Query

-----------------------------------------------------------------------------------
public function getuser(){
        $user = User::selectRaw('users.id,users.name,users.email')
                        //->with('city.address')
                        ->with(['city' => function ($query) {
                            $query->select('user_city.id','user_city.userId','user_city.city_name');
                            $query->where('user_city.active',1);
                        }, 'city.address' => function ($query) {
                            $query->select('user_address.id','user_address.cityID','user_address.address','user_address.active');
                            $query->where('user_address.active',1);
                        }])
                        ->groupBy('users.id')
                        ->get();
        return response(['user' => $user,'message' => 'successfull get']);
}

public function city()

    {
        return $this->hasMany('App\City','userId','id');
    }

public function address()
    {
        return $this->hasMany('App\Address','cityID','id');
    }

-----------------------------------------------------------------------------------

Comments

Popular posts from this blog

API

Encryption and Decryption By PHP

Seeder