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');
}
-----------------------------------------------------------------------------------
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
Post a Comment