Esempi in PHP per Task Task::query

Esempio n. 1

File: routes.php Progetto: vanderlin/halp

    $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();
    return $leader->first();
    $q = Task::query();
    $q->notExpired()->withIsExpired();
    // $q->whereRaw("IFNULL(`task_date`, `created_at`) > '$today'");
    // $q->whereRaw(DB::raw("
    // 	IFNULL(`task_date`, `created_at`) >
    // 		(CASE WHEN `task_date` IS NULL THEN DATE_ADD(CURDATE(), INTERVAL $n_days DAY) ELSE CURRENT_DATE END)"));
    //$q->select('tasks.*', DB::raw("IFNULL(`task_date`, `created_at`) > (CASE WHEN `task_date` IS NULL THEN DATE_ADD(CURDATE(), INTERVAL $n_days DAY) ELSE CURRENT_DATE END) AS is_expired"));
    $q->withTrashed();
    // return $q->toSql();
    return $q->get();
    return $r;
});
// ------------------------------------------------------------------------
Route::get('php', function () {
    phpinfo();
});