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);
}
