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();
