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]);
}
/**
* 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]);
}