public function index() { /* $users_q = User::join('tasks', 'tasks.claimed_id', '=', 'users.id') ->groupBy('users.id') ->orderBy('total_claimed_tasks', 'DESC') ->get(['users.*', DB::raw("count(".DB::getTablePrefix()."tasks.id) as total_claimed_tasks")]); // Paginate users $perPage = 10; $currentPage = Input::get('page') - 1; $pagedData = $users_q->slice($currentPage * $perPage, $perPage)->all(); $users = Paginator::make($pagedData, count($users_q), $perPage); */ $users = User::orderByClaimedTask()->get(); $leader = User::orderByClaimedTask()->first(); $top_user_last_week = User::mostHelpfulForWeek(Carbon\Carbon::now()->subWeek())->first(); $top_active_project = Project::orderByMostTasks()->with('user')->first(); $top_user_created_tasks = User::orderByCreatedTasks()->first(); $data = ['top_user_last_week' => $top_user_last_week, 'top_active_project' => $top_active_project, 'top_user_created_tasks' => $top_user_created_tasks, 'users' => $users, 'leader' => $leader]; return View::make('site.user.index', $data); }
} echo "{$id}<br>"; } dd(''); $start = Task::orderBy('created_at')->first()->created_at; $end = Carbon::now(); $res = []; $k = 0; $date = clone $start; for ($i = $start->weekOfYear; $i <= $end->weekOfYear; $i++) { $quary_award = Award::awardsForWeek(Award::AWARD_MOST_TASK_CREATED_WEEK, $date)->first(); array_push($res, ['i' => $i, 'inc' => $date->weekOfYear, $quary_award]); $date->addWeek(); } return [$start->weekOfYear, $end->weekOfYear, $res]; return Project::orderByMostTasks()->with('user')->get(); $last_week = last_week(); $user = User::mostHelpfulForProject()->first(); return [$user, Project::find($user->most_helped_project)]; // with('claimedTasks') // ->join('tasks', 'users.id', '=', 'tasks.claimed_id') // select([ // 'users.*', // DB::raw($sql) // ]); // ->sortByDesc(function($item) { // return $item->claimedTasks->count(); // })->each(function($item) { // return $item->totalClaimedTasks = $item->claimedTasks->count(); // })->values()->first(); // return $leader->toSql();