public function getUsersList($requestOnly)
{
$this->requestOnly = $requestOnly;
$userAll = $this->select(
'users.id', 'users.name', 'users.email',
'users.city_id', 'users.affiliate_id', 'status', 'cities.city'
)
->JoinCity()
->WhereListUser()
->with('groups')
->with('affiliate')
->with('session')
->get();
return $userAll;
}
function scopeJoinCity($query)
{
return $query->join('cities', 'users.city_id', '=', 'cities.id');
}
function scopeWhereListUser($query)
{
$r = $this->requestOnly;
// выборки
if($r['status']=='хз') {
$query->where('users.status', '=', $r['status']);
}
return $query;
}