/** * Responds to requests to GET /books */ public function getIndex(Request $request) { // Get all the books "owned" by the current logged in users // Sort in descending order by id $books = \App\Book::where('user_id', '=', \Auth::id())->orderBy('id', 'DESC')->get(); return view('books.index')->with('books', $books); }
public function borrow2() { //$user = user::where('email', '=', Input::get('bemail'))->firstOrFail(); $returnData = ""; $name = Input::get("name"); $email = Input::get("email"); if (Request::ajax()) { $userCount = User::where('email', '=', Input::get('email'))->count(); $bookCount = Book::where('barcode', '=', Input::get('barcode'))->count(); if ($userCount == 1) { $returnData = $returnData . " user existed "; $user = User::where('email', '=', Input::get('email'))->find(1); } if ($userCount == 0) { $name = Input::get("name"); $email = Input::get("email"); $user = user::create(array('email' => $email, 'name' => $name)); $returnData = $returnData . " user is created "; } if ($bookCount == 1) { $returnData = $returnData . " book existed "; $book = Book::where('barcode', '=', Input::get('barcode'))->find(1); } if ($bookCount == 0) { $title = Input::get('title'); $author = Input::get('author'); $barcode = Input::get('barcode'); $book = book::create(array('title' => $title, 'author' => $author, 'barcode' => $barcode)); $returnData = $returnData . " book is created "; } $borrow = Borrow::create(array('user_id' => $user->id, 'book_id' => $book->id)); $returnData = $returnData . " borrowing is successful user id =" . $user->id . " book id =" . $book->id; } return $returnData; }
public function schoolClicked($id) { $schools = School::all(); $programs = Program::where('school_id', '=', $id)->get(); $books = Book::where('school_id', '=', $id)->get(); return view('home')->with('programs', $programs)->with('schools', $schools); }
public function book($id) { $settings = Setting::first(); $books = Book::get(); $currentbook = Book::where('id', $id)->firstOrFail(); return view('front.book', ['books' => $books, 'settings' => $settings, 'currentbook' => $currentbook]); }
public function deleteAllWithBookType($book_type_id) { // Get All Books $books = Book::where('book_type_id', $book_type_id)->delete(); // Passing data to response service return $this->responseService->returnMessage($books, 'No Books were Found.'); }
/** * @Given 書籍 :bookName 已被 :username 借出 */ public function bookCheckedOutByUser($bookName, $username) { $book = Book::where('name', $bookName)->first(); $user = User::where('username', $username)->first(); $book->available = false; $book->save(); factory(CheckoutHistory::class)->create(['book_id' => $book->id, 'user_id' => $user->id]); }
function getExample10() { $book = \App\Book::where('title', '=', 'The Great Gatsby')->first(); echo $book->title . ' is tagged with : '; foreach ($book->tags as $tag) { echo $tag->name . ' '; } }
function getExample7() { $book = \App\Book::where('author', 'LIKE', '%Scott%')->first(); if ($book) { return $book->title; } else { return 'Book not found.'; } }
/** * Treat this method as a controller action. * Return view() or other content to display. */ public function run() { // $listItem = Book::where('cate_id', '=', $this->config['id'])->orderBy(DB::raw('RAND()'))->take($this->config['count'])->get(); // return view("widgets.featured_books", [ // 'config' => $this->config, // 'featuredItem' => $featuredItem // ]); return view("widgets.samecategory_books", compact('listItem')); }
public function create() { if (Auth::check()) { $user = Auth::user(); $count = Book::where('user_id', '=', $user->id)->count(); $mybooks = Book::where('user_id', '=', $user->id)->orderBy('updated_at', 'desc')->take(10)->get(); return view('sell')->with('mybooks', $mybooks)->with('count', $count); } else { return redirect()->route('getLogin'); } }
function getExample5() { //DELETE $book = new Book(); $harry_potter = Book::where('author', '=', 'J.K.Rowling')->first(); if ($harry_potter != null) { $harry_potter->delete(); echo 'deleted Harry Potter'; } return 'example5'; }
/** * Run the database seeds. * * @return void */ public function run() { $books = ['The Great Gatsby' => ['1'], 'A Fire in the Deep' => ['5'], 'Deepness in the Sky' => ['10']]; foreach ($books as $title => $rating) { $book = \App\Book::where('title', 'like', $title)->first(); foreach ($rating as $ratingName) { $rating = \App\Rating::where('rating', 'LIKE', $ratingName)->first(); $book->ratings()->save($rating); } } }
/** * Run the database seeds. * * @return void */ public function run() { $books = ['The Great Gatsby' => ['novel', 'fiction', 'classic', 'wealth'], 'The Bell Jar' => ['novel', 'fiction', 'classic', 'women'], 'I Know Why the Caged Bird Sings' => ['autobiography', 'nonfiction', 'classic', 'women']]; foreach ($books as $title => $tags) { $book = \App\Book::where('title', 'like', $title)->first(); foreach ($tags as $tagName) { $tag = \App\Tag::where('name', 'LIKE', $tagName)->first(); $book->tags()->save($tag); } } }
/** * Run the database seeds. * * @return void */ public function run() { $books = ['screen cast' => ['php', 'html', 'css', 'mysql'], 'pdf cast' => ['php', 'html', 'css', 'js'], 'flash cast' => ['forms', 'front-end', 'css', 'js']]; foreach ($books as $title => $tags) { $book = \App\Book::where('title', 'like', $title)->first(); foreach ($tags as $tagName) { $tag = \App\Tag::where('name', 'LIKE', $tagName)->first(); $book->tags()->save($tag); } } }
/** * Run the database seeds. * * @return void */ public function run() { $books = ['1.mp4' => ['mysql', 'security', 'php', 'model'], '2.mp4' => ['mysql', 'security', 'php', 'controller'], '3.mp4' => ['ui', 'nonfiction', 'js', 'view'], '4.mp4' => ['mysql', 'ui', 'html', 'css']]; foreach ($books as $title => $tags) { $book = \App\Book::where('title', 'like', $title)->first(); foreach ($tags as $tagName) { $tag = \App\Tag::where('name', 'LIKE', $tagName)->first(); $book->tags()->save($tag); } } }
public function search(Request $request) { if (strlen($request->search) >= 1) { $books = Book::where('book_title', 'like', "%{$request->search}%")->paginate(3); if ($books->total() > 1) { Flash::success('Result'); } else { Flash::success('Not Found'); } } else { $books = Book::where('book_title', 'like', "%aaaaaaaaaaaaaaaaaaaa%")->paginate(3); } return view('home', compact('books')); }
/** * Run the database seeds. * * @return void */ public function run() { $books = ["The Great Gatsby" => ['Jill', 'Jamal'], "A Fire in the Deep" => ['jon macleod', 'Jill'], "Deepness in the Sky" => ['Jamal', 'Jill', 'jon macleod']]; foreach ($books as $title => $user) { # First get the book $book = \App\Book::where('title', 'like', $title)->first(); # Now loop through each comment for this user, adding the pivot foreach ($user as $userName) { $user = \App\User::where('name', 'LIKE', $userName)->first(); # Connect this comment to this book $book->users()->save($user); } } }
public function advancedSearchAction(Request $request) { $num = 10; $username = $request->session()->get("username"); $name = $request->input("name"); $author = $request->input("author"); $publishing = $request->input("publishing"); $category = $request->input("category"); $isbn = $request->input("isbn"); $books = Book::where("book-name", "like", '%' . $name . '%')->where("author", "like", '%' . $author . '%')->where('publishing', 'like', '%' . $publishing . '%')->where('category-id', '=', $category)->where('isbn', 'like', '%' . $isbn . '%')->paginate($num); $books->appends(["name" => $name, "author" => $author, "publishing" => $publishing, "category" => $category, "isbn" => $isbn]); $categories = $this->getCategoryArray(Category::all()); return view('/reader/BookList', ['username' => $username, 'books' => $books, 'categories' => $categories]); }
/** * Run the database seeds. * * @return void */ public function run() { # First, create an array of all the books we want to associate comments with # The *key* will be the book title, and the *value* will be an array of comments. $books = ['The Great Gatsby' => ['good', 'great'], 'A Fire in the Deep' => ['great', 'bad'], 'Deepness in the Sky' => ['good', 'great', 'bad']]; # Now loop through the above array, creating a new pivot for each book to comment foreach ($books as $title => $comment) { # First get the book $book = \App\Book::where('title', 'like', $title)->first(); # Now loop through each comment for this book, adding the pivot foreach ($comment as $commentName) { $comment = \App\Comment::where('comment', 'LIKE', $commentName)->first(); # Connect this comment to this book $book->comments()->save($comment); } } }
/** * Run the database seeds. * * @return void */ public function run() { # First, create an array of all the books we want to associate tags with # The *key* will be the book title, and the *value* will be an array of tags. $books = ['The Great Gatsby' => ['novel', 'fiction', 'classic', 'wealth'], 'The Bell Jar' => ['novel', 'fiction', 'classic', 'women'], 'I Know Why the Caged Bird Sings' => ['autobiography', 'nonfiction', 'classic', 'women']]; # Now loop through the above array, creating a new pivot for each book to tag foreach ($books as $title => $tags) { # First get the book $book = \App\Book::where('title', 'like', $title)->first(); # Now loop through each tag for this book, adding the pivot foreach ($tags as $tagName) { $tag = \App\Tag::where('name', 'LIKE', $tagName)->first(); # Connect this tag to this book $book->tags()->save($tag); } } }
public function sortBook(Request $request) { if ($request->sort_type == 'name') { $books = Book::where('genre_id', '=', $request->id)->orderBy('title'); } else { if ($request->sort_type == 'price_up') { $books = Book::where('genre_id', '=', $request->id)->orderBy('price'); } else { $books = Book::where('genre_id', '=', $request->id)->orderBy('price', 'desc'); } } if ($books->count() > 0) { $data = array('books' => $books->get()); return $data; } else { return 'false'; } }
public function buy_books() { // session_start(); if (!isset($_SESSION['user_id'])) { $msg = "You are not Login , Please Login First..."; return view('login')->with('message', $msg); } $price = 0; $cid = cart::max('c_id') + 1; foreach ($_SESSION['cart'] as $item) { cart::create(['b_id' => $item["id"], 'c_id' => $cid]); $b = Book::where('b_id', $item["id"])->first(); $price = $price + $b->price; } trans::create(['u_id' => $_SESSION['user_id'], 'c_id' => $cid, 'amount' => $price]); $_SESSION['cart'] = array(); $msg = "Thank you for buying, Book are added to your transaction..."; return redirect()->action('UserController@show_trans'); }
public function adminIndex() { if (Auth::check()) { if (Auth::user()->userable_type == 'customer') { return view('errors.404'); } else { $countNewOrder = Order::where('shipped', '=', 0)->where('seen', '=', 0)->where('deleted', '=', 0)->count(); $countNewCustomer = Customer::where('created_at', '>', date('Y-m-d'))->where('created_at', '<', date('Y-m-d H:i:s'))->count(); $countSale = Book::where('sale', '>', 0)->count(); $books_sale = 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)->where('book.sale', '>', 0)->get(); $books_selling = Book::join('genre', 'genre.id', '=', 'book.genre_id')->join('author', 'author.id', '=', 'book.author_id')->join('publisher', 'publisher.id', '=', 'book.publisher_id')->join('order_detail', 'order_detail.book_id', '=', 'book.id')->selectRaw('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, book.quantity, SUM(order_detail.quantity) as sum_quantity')->where('book.deleted', '=', 0)->groupBy('book_id')->orderBy('sum_quantity', 'desc')->take(10)->get(); $data = array('books_sale' => $books_sale, 'books_selling' => $books_selling); return view('admin.pages.index', compact('countNewOrder', 'countNewCustomer', 'countSale'))->with('data', $data); } } else { return view('errors.404'); } }
public function deleteFromBooks() { $errors = array(); $data = array(); // Getting posted data and decodeing json ANGULAR POST $_POST = json_decode(file_get_contents('php://input'), true); // checking for blank values. if (empty($_POST['id'])) { $errors['id'] = 'ID is required.'; } if (!empty($errors)) { $data['errors'] = $errors; } else { $data['message'] = $_POST['id']; $book_id = $_POST['id']; \App\Book::where('id', '=', $book_id)->delete(); } // response back. echo json_encode($data); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function getBooks(Request $request) { try { $term = $request->input(); $url = ''; if (count($term) > 1) { $books = Book::where('books.active', 1); if ($term['title'] != '') { $books = $books->where('title', 'like', '%' . $request->input('title') . '%'); } $url['title'] = $term['title']; if ($term['author'] != '') { $books = $books->join('author_book', 'books.id', '=', 'author_book.book_id'); $books = $books->join('authors', 'author_book.author_id', '=', 'authors.id'); $books = $books->where('authors.name', 'like', '%' . $request->input('author') . '%'); } $url['author'] = $term['author']; if ($term['collection'] != '') { $books = $books->join('books_collections', 'books_collections.book_id', '=', 'books.id'); $books = $books->where('books_collections.collection_id', '=', $request->input('collection')); } $url['collection'] = $term['collection']; if ($term['sort'] != '') { $books = $books->orderBy('price_day', $term['sort']); } $url['sort'] = $term['sort']; $books = $books->select('books.*'); $books = $books->paginate(6); } else { $books = \App\Book::where('active', '1')->paginate(6); } } catch (\Exception $e) { return back(); } finally { $collections = ['' => ''] + \App\Collection::lists('collection', 'id')->all(); return view('home', ['books' => $books, 'collections' => $collections, 'url' => $url]); } }
public function generate($vendor_slug, $tour_slug, $schedule_id) { // ------------------------------------------------- // check vendor // ------------------------------------------------- $vendor = Vendor::SlugIs($vendor_slug)->first(); if (!$vendor) { App::abort(404); } // ------------------------------------------------- // check tour // ------------------------------------------------- $tour = $vendor->tours()->slugIs($tour_slug)->first(); if (!$tour) { App::abort(404); } // ------------------------------------------------- // schedule // ------------------------------------------------- $schedule = $tour->schedules()->find($schedule_id); if (!$schedule) { App::abort(404); } // ------------------------------------------------- // generate voucher // ------------------------------------------------- $book = Book::where('user_id', '=', Auth::id())->ofSchedule($schedule->id)->first(); if (!$book) { $book = new Book(); $book->fill(['discount_currency' => $schedule->currency, 'discount' => $schedule->discount, 'discount_code' => str_random(6), 'user_id' => Auth::id(), 'schedule_id' => $schedule->id]); if (!$book->save()) { return redirect()->back()->withErrors($book->getErrors); } } return redirect()->route('web.me.index'); }
public function destroy($id) { Book::where('id', $id)->delete(); return redirect('books'); }
/** * Handle search * @param Request $request * @return Response */ public function search(Request $request) { if ($request->input('form') == 'basic_search') { $this->validate($request, ['key_words' => 'required']); $queryString = str_replace(' ', '+', $request->input('key_words')); return redirect()->route('studentResults', [$queryString]); } if ($request->input('form') == 'refined_search') { $isbn = $request->input('isbn', null); $pub = $request->input('publisher', null); $title = $request->input('title', null); $author = $request->input('author', null); if (!is_null($isbn)) { $book = Book::where('isbn', $isbn)->first(); if (is_null($book)) { $keywords = trim($pub . ' ' . $title . ' ' . $author); $queryString = str_replace(' ', '+', $keywords); return redirect()->route('studentResults', [$queryString]); } else { return redirect()->route('studentResults', ['found', $book->id]); } } } }
/** * * Searches books based on either title or author name * * @return $this|\Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function search() { $criteria = Input::get('criteria'); $needle = Input::get('searchQuery'); if ($criteria) { $books = Book::where($criteria, 'LIKE', "%{$needle}%")->get(); return view('search')->with('books', $books); } else { return view('search'); } }
/** * Responds to requests to GET /books */ public function getIndex() { $books = \App\Book::where('user_id', '=', \Auth::id())->orderBy('id', 'DESC')->get(); //dump($books->toArray()); return view('books.index')->with('books', $books); }