PHP Book::with方法代码示例

 public function find($id)
 {
     // Get book by id
     $book = Book::with('chapters.pages')->find($id);
     // Passing data to response service
     return $this->responseService->returnMessage($book, 'Book was not Found.');
 }

 public function index()
 {
     $books = Book::with('Author')->where(function ($query) {
         $min_price = \Request::has('min_price') ? \Request::get('min_price') : null;
         $max_price = \Request::has('max_price') ? \Request::get('max_price') : null;
         $authors = \Request::has('authors') ? \Request::get('authors') : [];
         if (isset($min_price)) {
             $query->where('price', '>=', $min_price);
         }
         if (isset($max_price)) {
             $query->where('price', '<=', $max_price);
         }
         if (isset($authors)) {
             $query->where(function ($q) {
                 $input_authors = \Request::has('authors') ? \Request::get('authors') : [];
                 // $books_all = \App\Book::with('Author')->get();
                 //перебираем все чекнутые боксы
                 foreach ($input_authors as $input_author) {
                     // автор == выборка из авторов где Ид = чекнутому боксу. Первый
                     $author = \App\Author::with('books')->where('id', '=', $input_author)->first();
                     // выборка внутри выбранного автора по книгам
                     foreach ($author->books as $author_book) {
                         //запрос Айди книги == айди книг у этого автора
                         $q->orWhere('id', '=', $author_book->id);
                     }
                 }
             });
         }
     })->paginate(2);
     $authors_list = \App\Author::all();
     return view('books.list', compact('books', 'authors_list'));
 }

 function getExample8()
 {
     $book = \App\Book::with('author')->first();
     dump($book->toArray());
     echo $book->title . ' was written by ';
     //echo $book->author->first_name;
     //echo $book->title.' was written by '.$book->author->first_name.' '.$book->author->last_name;
 }

 public function index()
 {
     $books = Book::with(array('authors', 'category', 'format'))->orderBy('book_added_at', 'desc')->paginate(config('library.posts_per_page'));
     $imagePath = \Config::get('library.uploads.webpath');
     $imageCoverName = \Config::get('library.uploads.cover_name');
     $deffaultImage = \Config::get('library.uploads.deffault_image');
     return view('allBook', compact('books', 'imagePath', 'imageCoverName', 'deffaultImage'));
 }

 /**
  * Get all the books with their authors
  */
 function getExample9()
 {
     # Eager load the authors with the books
     $books = \App\Book::with('author')->get();
     foreach ($books as $book) {
         echo $book->author->first_name . ' ' . $book->author->last_name . ' wrote ' . $book->title . '<br>';
     }
     dump($books->toArray());
 }

 function getExample11()
 {
     $books = \App\Book::with('tags')->get();
     foreach ($books as $book) {
         echo '<br>' . $book->title . ' is tagged with: ';
         foreach ($book->tags as $tag) {
             echo $tag->name . ' ';
         }
     }
 }

 /**
  * Responds to requests to GET /books/edit/{$id}
  */
 public function getEdit($id = null)
 {
     // get book to edit
     $book = \App\Book::with('tags')->find($id);
     $authorModel = new \App\Author();
     $authors_for_dropdown = $authorModel->getAuthorsForDropdown();
     // get all the tags
     $tagModel = new \App\Tag();
     $tags_for_checkboxes = $tagModel->getTagsForCheckboxes();
     //dump($tags_for_checkboxes);
     // get the tags for this book
     $tags_for_this_book = [];
     foreach ($book->tags as $tag) {
         $tags_for_this_book[] = $tag->name;
     }
     //dump($tags_for_this_book);
     //dump($authors_for_dropdown);
     if (is_null($book)) {
         \Session::flash('flash_message', 'Book not found.');
         //return redirect('\books');
     }
     return view('books.edit')->with(['book' => $book, 'authors_for_dropdown' => $authors_for_dropdown, 'tags_for_checkboxes' => $tags_for_checkboxes, 'tags_for_this_book' => $tags_for_this_book]);
 }

 /**
  * Responds to requests to GET /books/edit/{$id}
  */
 public function getEdit($id = null)
 {
     # Get this book and eager load its tags
     $book = \App\Book::with('tags')->find($id);
     if (is_null($book)) {
         \Session::flash('flash_message', 'Media not found.');
         return redirect('\\books');
     }
     # Get all the possible formats so we can build the formats dropdown in the view
     $formatModel = new \App\Format();
     $formats_for_dropdown = $formatModel->getFormatsForDropdown();
     # Get all the possible tags so we can include them with checkboxes in the view
     $tagModel = new \App\Tag();
     $tags_for_checkbox = $tagModel->getTagsForCheckboxes();
     /*
     Create a simple array of just the tag names for tags associated with this book;
     will be used in the view to decide which tags should be checked off
     */
     $tags_for_this_book = [];
     foreach ($book->tags as $tag) {
         $tags_for_this_book[] = $tag->name;
     }
     return view('books.edit')->with(['book' => $book, 'formats_for_dropdown' => $formats_for_dropdown, 'tags_for_checkbox' => $tags_for_checkbox, 'tags_for_this_book' => $tags_for_this_book]);
 }

 public function books()
 {
     $books = Book::with('category', 'shelf')->orderByTitle()->get();
     return view('lms.books', compact('books'));
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function showBook($bookClubId, $bookId)
 {
     //return \App\Book::
     $user = auth()->check() ? auth()->user() : new \App\User();
     $book = \App\Book::with('authors', 'publisher', 'category', 'language')->findOrFail($bookId);
     $statuses = $book->clubStatus($bookClubId);
     $bookclub = \App\BookClub::findOrFail($bookClubId);
     $request_route = 'bookclubs.books.requestbook';
     $book_statuses = \App\BookStatus::all()->lists('name', 'id');
     return view('bookclubs.books.show')->with(compact('book', 'bookclub', 'user', 'statuses', 'request_route', 'book_statuses'));
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $book = \App\Book::with('authors', 'publisher', 'category', 'language')->findOrFail($id);
     $authors = \App\Author::all()->lists('name', 'name');
     $book_authors = $book->authors()->lists('name');
     // return $book_authors;
     return view('books.edit')->with(compact('book'))->with(compact('authors', 'book_authors'));
 }

 public function getBooks()
 {
     // API dlya Angular
     return \App\Book::with(["Author"])->with(["categories"])->get();
 }

 public function ratingSearch($rate)
 {
     $books = \App\Book::with('ratings', 'LIKE', $rate)->get();
     foreach ($books as $book) {
         echo '<br>' . $book->title . ' has a rating of';
         $mean = 0;
         $i = 0;
         $rate = 0;
         foreach ($book->rating as $rating) {
             $mean = $mean + $rating;
             $i++;
         }
         $rate = $mean / $i;
         echo ' has a rating of ' + $rate;
     }
 }