/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { /* Suppression de la variable non utilisée $tasks : Resolve as false positive car variable necessaire */ $tasks = Task::latest('updated_at')->get(); /* Duplication de 'tasks.index' : Resolve as false positive */ return view('tasks.index', compact('tasks')); }
public function index() { $userType = Auth::user()->type; if ($userType == "admin" || $userType == "manager") { $tasks = Task::latest()->get(); } else { $tasks = Task::where(['taskType' => 'user', 'assignedTo' => Auth::user()->id])->get(); } return view('tasks.index', compact('tasks')); }
public function dashboard() { $thisWeekDeadline = \DB::select("SELECT COUNT(0) as cnt FROM tasks WHERE completed_at IS NULL AND due_date < ?", [Carbon::now()->addWeek()])[0]->cnt; $assignedToYou = \DB::select("SELECT COUNT(0) as cnt \n FROM tasks \n INNER JOIN task_user ON tasks.id = task_user.task_id\n WHERE completed_at IS NULL\n AND task_user.user_id = ?", [\Auth::user()->id])[0]->cnt; $completedCount = \DB::select("select sum(isnull(completed_at)) as not_completed, sum(not isnull(completed_at)) as completed from tasks group by completed_at;")[0]; /*$tasksCount = \DB::table('tasks') ->select('project_id', 'completed_at', \DB::raw('COUNT(0) total')) ->groupBy('project_id', 'completed_at') ->get(); dd($tasksCount);*/ $latest = Task::latest()->whereNull('completed_at')->with('project')->take(25)->get(); return view('dashboard.dashboard', ['latest' => $latest, 'thisWeekDeadline' => $thisWeekDeadline, 'assignedToYou' => $assignedToYou, 'completedCount' => $completedCount, 'faker' => \Faker\Factory::create()]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $data['tasks'] = Task::latest('updated_at')->get(); return view('tasks.index', $data); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $tasks = Task::latest('id')->get(); return view('tasks.index', compact('tasks')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $tasks = Task::latest()->get(); return $this->response(['task_list' => $this->taskTransformer->transformCollection($tasks->toArray())]); }
public function all() { return Task::latest()->get(); }
public function dashBoard(Request $request) { $tasks = Task::latest('date')->where('userId', $request->user()->id)->get(); //tasks sorted by date TODO give only users tasks return view('dashBoard', compact('tasks')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $tasks = Task::latest()->paginate(20); $no = $tasks->firstItem(); return view('tasks.index', compact('tasks', 'no')); }