本文整理汇总了PHP中app\Message::join方法的典型用法代码示例。如果您正苦于以下问题：PHP Message::join方法的具体用法？PHP Message::join怎么用？PHP Message::join使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Message的用法示例。
在下文中一共展示了Message::join方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: index
/**
* 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]);
}