public function ToDo() { $todoListActive = Todo::select(DB::raw("todo.*, DATE_FORMAT(todo.date_added,'%d-%m-%Y') as date1"))->where('date_deleted', '0000-00-00 00:00:00')->where('date_archieved', '0000-00-00 00:00:00')->get(); // return $todoListActive; $todoListArchieved = Todo::where('user_id', Auth::User()->id)->where('date_deleted', "!=", "0000-00-00 00:00:00")->get(); $todoListDeleted = Todo::where('user_id', Auth::User()->id)->where('date_archieved', "!=", "0000-00-00 00:00:00")->get(); return view('todo')->with('todoListActive', $todoListActive)->with('todoListArchieved', $todoListArchieved)->with('todoListDeleted', $todoListDeleted); }