Exemplo n.º 1
0
 public function pastEvents()
 {
     //Gets all the event details from the event database table
     $events = Event::onlyTrashed()->orderBy('deleted_at', 'desc')->paginate(5);
     //Returns the events view along with the $events array containing the query results from above
     return view('past', ['events' => $events]);
 }
Exemplo n.º 2
0
 /**
  * Show the admin dashboard.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //Gets all the event details from the event table
     $events = Event::orderBy('created_at', 'desc')->paginate(5, ['*'], 'events');
     $pastevents = Event::onlyTrashed()->orderBy('deleted_at', 'desc')->paginate(5, ['*'], 'past');
     //gets all messages from the messages table
     $messages = Message::join('users', 'users.id', '=', 'messages.userid')->select('users.name', 'users.email', 'messages.*')->whereNull('deleted_at')->orderBy('created_at', 'desc')->paginate(5, ['*'], 'messages');
     //gets all the read (deleted) messages from the messags table.
     $readMessages = Message::join('users', 'users.id', '=', 'messages.userid')->select('users.name', 'users.email', 'messages.*')->whereNotNull('deleted_at')->onlyTrashed()->orderBy('created_at', 'desc')->paginate(5, ['*'], 'read');
     //Returns the events view along with the $events, $messages and $readMessages arrays containing the query results from above
     return view('admin/admin', ['events' => $events, 'pastevents' => $pastevents, 'messages' => $messages, 'readMessages' => $readMessages]);
 }