PHP Note::with方法代码示例

 public function show($notebookId, $noteId, $versionId)
 {
     $note = Note::with(array('users' => function ($query) {
         $query->where('note_user.user_id', '=', Auth::user()->id);
     }, 'notebook' => function ($query) use(&$notebookId) {
         $query->where('id', $notebookId > 0 ? '=' : '>', $notebookId > 0 ? $notebookId : '0');
     }, 'version' => function ($query) {
     }))->where('id', '=', $noteId)->whereNull('deleted_at')->first();
     $currentVersion = $note->version()->first();
     if (is_null($currentVersion)) {
         return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
     }
     while (!is_null($currentVersion)) {
         if ($currentVersion->id == $versionId || $versionId == '0') {
             return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_SUCCESS, $currentVersion);
         }
         $currentVersion = $currentVersion->previous()->first();
     }
     return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
 }

 private function getNoteVersionsBrief($noteId)
 {
     $note = Note::with('version')->where('notes.id', '=', $noteId)->first();
     $versionsObject = $note->version()->first();
     if (is_null($versionsObject)) {
         return null;
     }
     $versionsArray = [];
     $tmp = $versionsObject;
     $isLatest = true;
     $versions = array();
     while (!is_null($tmp)) {
         $versionsArray[] = $tmp;
         $user = $tmp->user()->first();
         $versions[] = array('id' => $tmp->id, 'previous_id' => $tmp->previous_id, 'next_id' => $tmp->next_id, 'latest' => $isLatest, 'timestamp' => $tmp->created_at->getTimestamp(), 'username' => $user->firstname . ' ' . $user->lastname);
         $isLatest = false;
         $tmp = $tmp->previous()->first();
     }
     return $versions;
 }

 public function get($argv = array())
 {
     //the version_id has to be included here or the eager load below will fail
     //also, all off the ids of the relationships have to be here also, or it will also fail
     $defaultNotesSelect = array('notes.id', 'notes.notebook_id', 'notes.created_at', 'notes.updated_at', 'notes.version_id');
     $defaultVersionsSelect = array('versions.id', 'versions.title', 'versions.content_preview', 'versions.content', 'versions.user_id');
     $defaultTagsSelect = array('tags.id', 'tags.visibility', 'tags.title');
     $defaultUsersSelect = array('users.id', 'users.firstname', 'users.lastname');
     $userId = $this->getArg($argv, 'userid');
     $id = $this->getArg($argv, 'id');
     $notebookId = $this->getArg($argv, 'notebookid');
     $data = \Note::with(array('version' => function ($query) use(&$defaultVersionsSelect, &$defaultUsersSelect) {
         $query->select($defaultVersionsSelect)->with(array('user' => function ($query) use(&$defaultUsersSelect) {
             $query->select($defaultUsersSelect);
         }));
     }, 'tags' => function ($query) use(&$defaultTagsSelect, &$userId) {
         $query->select($defaultTagsSelect)->where('visibility', '=', 1)->orWhere('tags.user_id', '=', $userId);
     }, 'users' => function ($query) use(&$defaultUsersSelect) {
         $query->select($defaultUsersSelect)->wherePivot('umask', '=', \PaperworkHelpers::UMASK_OWNER);
     }))->join('note_user', function ($join) use(&$userId) {
         $join->on('note_user.note_id', '=', 'notes.id')->where('note_user.user_id', '=', $userId)->where('note_user.umask', '>', 0);
     })->select($defaultNotesSelect);
     $idCount = count($id);
     if ($idCount > 0) {
         $data->where('notes.id', '=', $argv['id'][0]);
     }
     if ($idCount > 1) {
         for ($i = 1; $i < $idCount; $i++) {
             $data->orWhere('notes.id', '=', $argv['id'][$i]);
         }
     }
     if (isset($notebookId) && $notebookId != \PaperworkDb::DB_ALL_ID) {
         $data->where('notes.notebook_id', '=', $notebookId);
     }
     $data->whereNull('deleted_at');
     return $data->get();
 }

 public function index()
 {
     $loggedInUser = Auth::user()->id;
     $notes = Note::with('user')->where('user_id', '=', $loggedInUser)->orderBy('updated_at', 'desc')->paginate(10);
     return View::make('notes.index')->with('notes', $notes);
 }

 public function showNotes()
 {
     $notes = Note::with('user')->where('public_or_private', '=', 'public')->orderBy('id', 'desc')->paginate(10);
     return View::make('feed.notes')->with('notes', $notes);
 }