Esempio n. 1
0
<?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')