public function getAuthors(Request $request) { $term = $request->input('term'); $authors = Author::where('name', 'like', '%' . $term . '%')->get(); foreach ($authors as $author) { $aut[] = $author->name; } return json_encode($aut); }
/** * Run the database seeds. * * @return void */ public function run() { $author_id = \App\Author::where('last_name', '=', 'Fitzgerald')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => 'The Great Gatsby', 'author_id' => $author_id, 'user_id' => 1, 'published' => 1925, 'cover' => 'http://img2.imagesbn.com/p/9780743273565_p0_v4_s114x166.JPG', 'purchase_link' => 'http://www.barnesandnoble.com/w/the-great-gatsby-francis-scott-fitzgerald/1116668135?ean=9780743273565']); $author_id = \App\Author::where('last_name', '=', 'Plath')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => 'The Bell Jar', 'author_id' => $author_id, 'user_id' => 1, 'published' => 1963, 'cover' => 'http://img1.imagesbn.com/p/9780061148514_p0_v2_s114x166.JPG', 'purchase_link' => 'http://www.barnesandnoble.com/w/bell-jar-sylvia-plath/1100550703?ean=9780061148514']); $author_id = \App\Author::where('last_name', '=', 'Angelou')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => 'I Know Why the Caged Bird Sings', 'author_id' => $author_id, 'user_id' => 1, 'published' => 1969, 'cover' => 'http://img1.imagesbn.com/p/9780345514400_p0_v1_s114x166.JPG', 'purchase_link' => 'http://www.barnesandnoble.com/w/i-know-why-the-caged-bird-sings-maya-angelou/1100392955?ean=9780345514400']); }
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); }
/** * 检查作者是否存在 * **/ public function isAuthorExist($payload) { if ($payload['feed']) { $author = Author::where('feed', $payload['feed'])->first(); if ($author) { return true; } else { return false; } } }
/** * Run the database seeds. * * @return void */ public function run() { $author_id = \App\Author::where('last_name', '=', 'Fitzgerald')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => '1.mp4', 'author_id' => $author_id, 'user_id' => 1, 'published' => 100, 'cover' => 'img/thumbnail.png', 'purchase_link' => 'this video gives a overview of the .etc file']); $author_id = \App\Author::where('last_name', '=', 'Plath')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => '2.mp4', 'author_id' => $author_id, 'user_id' => 1, 'published' => 90, 'cover' => 'img/thumbnail.png', 'purchase_link' => 'this is a high level view of the way Laravel is a framework of frameworks']); $author_id = \App\Author::where('last_name', '=', 'Angelou')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => '3.mp4', 'author_id' => $author_id, 'user_id' => 1, 'published' => 90, 'cover' => 'img/thumbnail.png', 'purchase_link' => 'this describes the way Laravel uses the MVC framework']); $author_id = \App\Author::where('last_name', '=', 'Angelou')->pluck('id'); DB::table('books')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'title' => '4.mp4', 'author_id' => $author_id, 'user_id' => 1, 'published' => 90, 'cover' => 'img/thumbnail.png', 'purchase_link' => 'this discusses the routes.php file']); }
/** * Display the quotes for given author. * * @param $slug * * @return Response * @internal param int $slug */ public function quotes($slug) { try { $author = Author::where(['slug' => $slug])->firstOrFail(); $statusCode = 200; $response = ['data' => $author->quotes()->get()]; } catch (Exception $e) { $statusCode = 400; } finally { return Response::json($response, $statusCode); } }
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 getAuthor() { $authors = Author::where('deleted', '=', 0)->orderBy('name')->get(); return view('admin.pages.author')->with('authors', $authors); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit() { $user_id = Auth::user()->id; $data = INPUT::all(); $rules = $this->rules(); $messages = $this->messages(); $validator = Validator::make($data, $rules, $messages); if (!$validator->fails()) { $book = Book::find($data['id']); $book->title = $data['title']; $book->subtitle = $data['subtitle']; $book->publishedDate = $data['publishedDate']; $book->description = $data['description']; $book->pages = $data['pages']; $book->isbn10 = $data['isbn10']; $book->isbn13 = $data['isbn13']; $book->price_day = $data['price_day']; $book->price_bail = $data['price_bail']; $book->price_sale = $data['price_sale']; $book->language = $data['language']; if ($data['publisher'] != $book->id_publisher) { if ($data['publisher'] != '0') { $book->id_publisher = $data['publisher']; } else { $publisher = new Publisher(); $publisher->publisher = $data['newpublisher']; $publisher->save(); $book->id_publisher = $publisher->id; } } if (isset($data['cover'])) { $book->cover = file_get_contents($data['cover']); } $book_id = $book->id; Book_Collection::where('book_id', $book_id)->delete(); Author_Book::where('book_id', $book_id)->delete(); $book_collection = new Book_Collection(); $book_collection->book_id = $book_id; $book_collection->collection_id = $data['collection']; $authors = explode(',', $data['authors']); foreach ($authors as $author) { $tmp = Author::where('name', 'like', $author)->limit(1)->get(); if (count($tmp) > 0) { $author_book = new Author_Book(); $author_book->book_id = $book_id; $author_book->author_id = $tmp[0]->id; $author_book->save(); } else { $newAuthor = new Author(); $newAuthor->name = $author; $newAuthor->save(); $author_id = $newAuthor->id; $author_book = new Author_Book(); $author_book->book_id = $book_id; $author_book->author_id = $author_id; $author_book->save(); } } $book->save(); return redirect('book/edit/' . $book_id . ''); } return back()->withInput($data)->withErrors($validator); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $application = Application::find($id); $author = Author::where('id', '=', $application->author_id); return view('application.edit', compact('application', 'author')); }
public function author() { if (Request::ajax()) { $data = Request::get('data'); $sort = Request::get('sort'); $list = Request::get('list'); switch ($data) { case 'pp': $author = Author::find($list); $author_book = Book::where('author_id', $list)->get(); return view('front.partials.list_item_pp_author', ['data' => $author, 'author_book' => $author_book]); case 'word': $author = Author::where('name', 'LIKE', $list . '%'); return view('front.partials.list_item_word', ['data' => $author->paginate(9), 'word' => $list]); default: $authors = DB::table('Authors'); $author = HomeController::sort($authors, $sort); return view('front.partials.list_item_all', ['data' => $author->paginate(9)]); } } $author_list = Author::orderBy('name', 'ASC')->paginate(9); $author_word = Author::select(DB::raw('substr(name,1,1) as alpha'))->groupBy(DB::raw('substr(name,1,1)'))->get(); return view('front.tacgia', ['author_word' => $author_word, 'data' => $author_list, 'name_page' => 'Tác giả', 'table_name' => 'Authors']); }
/** * Show all send messages in a list * * @param int $id * @return Response */ public function mailSendAll() { $members = Member::all(); //all data of member collection $id = Auth::id(); $author = User::find($id); //$author = User::find($id); $sends = Author::where('mail_send', '=', '1')->where('mail_author', '=', $id)->get(); //retrieve data of unread message $unread = Inbox::where('mail_read', '=', '0')->where('member_id', '=', $id)->get()->count(); return view('vendor/flatAdmin/mailSendAll', compact(array('members', 'author', 'unread', 'id', 'sends'))); }