<?php use Carbon\Carbon; use Task\Task; use Notification\Notification; Route::any('test-query', function () { foreach (Award::getAwards() as $type) { preg_match('/\\d+/', $type->name, $matches); if ($matches) { $id = $matches[0]; } 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')