public function getBook() { $books = Book::join('genre', 'genre.id', '=', 'book.genre_id')->join('author', 'author.id', '=', 'book.author_id')->join('publisher', 'publisher.id', '=', 'book.publisher_id')->select('book.id', 'title', 'genre_id', 'genre.name as genre_name', 'author_id', 'author.name as author_name', 'publisher_id', 'publisher.name as publisher_name', 'image', 'isbn', 'description_short', 'price', 'sale', 'quantity')->where('book.deleted', '=', 0)->get(); $genres = Genre::where('deleted', '=', 0)->orderBy('name')->get(); $authors = Author::where('deleted', '=', 0)->orderBy('name')->get(); $publishers = Publisher::where('deleted', '=', 0)->orderBy('name')->get(); $data = array('books' => $books, 'authors' => $authors, 'genres' => $genres, 'publishers' => $publishers); return view('admin.pages.book')->with('data', $data); }
/** * Get the filters for the territory. */ public static function getFilters($filters) { // userId if (array_key_exists('userId', $filters)) { $publisher = Publisher::where('user_id', $filters['userId'])->first(); if (!empty($publisher['id'])) { return ['publisher_id' => $publisher['id']]; } else { return ['id' => null]; } } }
public function update(Request $request) { $validator = Validator::make($request->all(), ['id' => 'required', 'name' => 'required', 'status' => 'required']); if ($validator->fails()) { return Response::json(array('result' => false, 'data' => 'data is valide.')); } $publisher = Publisher::where('id', $request->input('id'))->get()->first(); $publisher->name = $request->input('name'); $publisher->status = $request->input('status'); $result = $publisher->save(); if ($result) { return Response::json(array('result' => true, 'data' => $publisher)); } return Response::json(array('result' => false, 'data' => 'Update has been error.')); }
public function addbooks() { header('Content-Type: text/html; charset=utf-8'); for ($i = 0; $i <= 10; $i++) { $user = new User(); $user->name = $this->generateRandomString(5); $user->password = bcrypt($user->name); $user->email = $user->name . '@gmail.com'; $user->save(); } $names = ['%22feliz%20gouveia%22', '%22nuno%20ribeiro%22', '%22jose%20torres%22', '%22borges%20gouveia%22', '%22Sophia%20breyner%22', '%22Fernando%20Pessoa%22', '%22Eça%20De%20Queiros%22']; foreach ($names as $name) { $content = file_get_contents('https://www.googleapis.com/books/v1/volumes?q=' . $name); $content = json_decode($content, true); $auts = Author::all('name'); $authors = array(); foreach ($auts as $aut) { $authors[] = $aut['name']; } $pubs = Publisher::all('publisher'); $publishers = array(); foreach ($pubs as $pub) { $publishers[] = $pub['publisher']; } $cats = Collection::all('collection'); $categories = array(); foreach ($cats as $cat) { $categories[] = $cat['collection']; } foreach ($content['items'] as $data) { $data = $data['volumeInfo']; $book = new Book(); if (isset($data['title'])) { $book->title = $data['title']; } if (isset($data['subtitle'])) { $book->subtitle = $data['subtitle']; } if (isset($data['publishedDate'])) { $book->publishedDate = $data['publishedDate']; } if (isset($data['description'])) { $book->description = $data['description']; } if (isset($data['pageCount'])) { $book->pages = $data['pageCount']; } if (isset($data['language'])) { $book->language = $data['language']; } if (isset($data['industryIdentifiers'])) { foreach ($data['industryIdentifiers'] as $value) { if ($value['type'] == 'ISBN_13') { $book->isbn13 = $value['identifier']; } if ($value['type'] == 'ISBN_10') { $book->isbn10 = $value['identifier']; } } } if (isset($data['publisher'])) { if (!in_array($data['publisher'], $publishers)) { $publishers[] = $data['publisher']; $publisher = new Publisher(); $publisher->publisher = $data['publisher']; $publisher->save(); $publisher_id = $publisher->id; } else { $publisher = Publisher::where('publisher', '=', $data['publisher'])->limit(1)->get(); $publisher_id = $publisher[0]->id; } } if (isset($data['imageLinks']['thumbnail'])) { $book->cover = file_get_contents($data['imageLinks']['thumbnail']); } $book->price_day = random_int(0, 15); $book->price_bail = random_int(10, 50); $book->price_sale = random_int(10, 79); $books[] = $book; $book->id_publisher = $publisher_id; $book->id_user = rand(1, 10); $book->save(); $book_id = $book->id; if (isset($data['categories'])) { foreach ($data['categories'] as $value) { if (!in_array($value, $categories)) { $categories[] = $value; $category = new Collection(); $category->collection = $value; $category->save(); $category_id = $category->id; $collections = new Book_Collection(); $collections->book_id = $book_id; $collections->collection_id = $category_id; $collections->save(); } else { $category = Collection::where('collection', '=', $value)->limit(1)->get(); $collections = new Book_Collection(); $collections->book_id = $book_id; $collections->collection_id = $category[0]->id; $collections->save(); } } } if (isset($data['authors'])) { foreach ($data['authors'] as $value) { if (!in_array($value, $authors)) { $authors[] = $value; $author = new Author(); $author->name = $value; $author->save(); $author_id = $author->id; $author_book = new Author_Book(); $author_book->book_id = $book_id; $author_book->author_id = $author_id; $author_book->save(); } else { $author = Author::where('name', 'like', $value)->limit(1)->get(); $author_book = new Author_Book(); $author_book->book_id = $book_id; $author_book->author_id = $author[0]->id; $author_book->save(); } } } # code... } } }
public function view(Request $request, $publisherId = null) { if (!$this->hasAccess($request)) { return Response()->json(['error' => 'Access denied.'], 500); } if (Gate::denies('view-publishers')) { return Response()->json(['error' => 'Method not allowed'], 403); } try { $publisher = Publisher::where('id', $publisherId)->with('territories')->get(); $data = !empty($publisher[0]) ? $this->transform($publisher[0]->toArray(), 'publisher') : null; } catch (Exception $e) { $data = ['error' => 'Publisher not found', 'message' => $e->getMessage()]; } return ['data' => $data]; }
public function publisher() { if (Request::ajax()) { $data = Request::get('data'); $sort = Request::get('sort'); $list = Request::get('list'); switch ($data) { case 'pp': $source = Publisher::find($list); $source_book = Book::where('publisher_id', $list)->get(); return view('front.partials.list_item_pp_nxb', ['data' => $source, 'author_book' => $source_book]); case 'word': $source = Publisher::where('name', 'LIKE', $list . '%'); return view('front.partials.list_item_word', ['data' => $source->paginate(9), 'word' => $list]); default: $sources = DB::table('publishers'); $source = HomeController::sort($sources, $sort); return view('front.partials.list_item_all', ['data' => $source->paginate(9)]); } } $source_list = Publisher::orderBy('name', 'ASC')->paginate(9); $source_word = Publisher::select(DB::raw('substr(name,1,1) as alpha'))->groupBy(DB::raw('substr(name,1,1)'))->get(); return view('front.nxb', ['author_word' => $source_word, 'data' => $source_list, 'name_page' => 'Nhà xuất bản', 'table_name' => 'Publishers']); }
public function getPublisher() { $publishers = Publisher::where('deleted', '=', 0)->orderBy('name')->get(); return view('admin.pages.publisher')->with('publishers', $publishers); }