public function users()
{
if (Gate::denies('all-users')) {
abort(403);
}
$users = User::paginate(20);
$suspended = $users->where('role', 'suspended')->count();
$active = $users->where('role', 'active')->count();
$rush = $users->where('role', 'rush')->count();
$admin = $users->where('role', 'admin')->count();
$superadmin = $users->where('role', 'superadmin')->count();
$suspended_queries = Project::whereHas('user', function ($project) {
// $suspended_queries = Query::whereHas( 'user', function ($query) {
$project->where('role', '=', 'suspended');
})->count();
$active_queries = Project::whereHas('user', function ($project) {
// $active_queries = Query::whereHas( 'user', function ($query) {
$project->where('role', '=', 'active');
})->count();
$rush_queries = Project::whereHas('user', function ($project) {
// $rush_queries = Query::whereHas( 'user', function ($query) {
$project->where('role', '=', 'rush');
})->count();
$admin_queries = Project::whereHas('user', function ($project) {
// $admin_queries = Query::whereHas( 'user', function ($query) {
$project->where('role', '=', 'admin');
})->count();
$superadmin_queries = Project::whereHas('user', function ($project) {
// $superadmin_queries = Query::whereHas( 'user', function ($query) {
$project->where('role', '=', 'superadmin');
})->count();
return view('users', ['users' => $users, 'suspended' => $suspended, 'active' => $active, 'rush' => $rush, 'admin' => $admin, 'superadmin' => $superadmin, 'suspended_queries' => $suspended_queries, 'active_queries' => $active_queries, 'rush_queries' => $rush_queries, 'admin_queries' => $admin_queries, 'superadmin_queries' => $superadmin_queries]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$projects = Project::whereHas('tasks', function ($query) {
$query->whereNull('closed_at');
})->with(['tasks' => function ($query) {
$query->whereNull('closed_at')->orderBy('urgent', 'desc')->orderBy('created_at', 'desc');
}, 'client'])->orderBy('rate', 'desc')->orderBy('name')->get();
return view('task.index', compact('projects'));
}
