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'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('phones');
$authors = \App\Author::all();
foreach ($authors as $author) {
\App\Phone::create(['author_id' => $author->id, 'phone_number' => '0' . (string) (9099990000 + $author->id)]);
}
}
public function index()
{
$authors = Author::all();
if (Request::wantsJson()) {
return $authors;
}
return view('authors.index', compact('authors'));
}
/**
* 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::find($id);
$applications = Application::all();
$authors = Author::all();
$versions = [1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 3.0];
return view('application.edit', compact('application', 'author', 'applications', 'authors', 'versions'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
try {
$quotes = Author::all();
$statusCode = 200;
$response = ['data' => $quotes];
} catch (Exception $e) {
$statusCode = 400;
} finally {
return Response::json($response, $statusCode);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::table('applications')->delete();
$authors = Author::all();
$faker = Faker::create();
foreach ($authors as $author) {
for ($i = 0; $i < 1; $i++) {
Application::create(['title' => $faker->company, 'version' => $faker->randomFloat($nbMaxDecimals = 1, $min = 1, $max = 3), 'author_id' => $author->id]);
}
}
Model::reguard();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('author_author_type');
DatabaseSeeder::truncateTable('author_types');
try {
factory(\App\AuthorType::class, 10)->create();
} catch (\Illuminate\Database\QueryException $e) {
// name カラムの unique index の無視
}
$authors = \App\Author::all();
/** @var \App\Author $author */
foreach ($authors as $author) {
$author_types = \App\AuthorType::all()->random(rand(2, 5));
$author->types()->sync($author_types);
}
}
public function __construct()
{
$A_authors = Author::all();
view()->share('A_authors', $A_authors);
$A_projects = Project::all();
view()->share('A_projects', $A_projects);
$A_blogs = Blog::all();
view()->share('A_blogs', $A_blogs);
$A_newsletters = Newsletter::all();
view()->share('A_newsletters', $A_newsletters);
$A_quotations = Quotation::all();
view()->share('A_quotations', $A_quotations);
$quotations = Quotation::all();
//dump($quotations);
$quotations = count($quotations) > 1 ? $quotations->random(2) : $quotations;
view()->share('quotations', $quotations);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$authors = \App\Author::all();
return view('authors.index', ['authors' => $authors]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$authors = Author::all();
return $this->respondTo(['html' => view('authors.index', compact('authors')), 'default' => $authors]);
}
public function listAuthors($request, $response)
{
return $this->view->render($response, 'author/list.twig', ['authors' => Author::all()]);
}
/**
* 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'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
//
$users = Author::all();
return view('authors.index', compact('users'));
}
public function index()
{
$authors = \App\Author::all();
return view('author.index', compact('authors'));
}
public function index()
{
$authors = Author::all();
return json_encode($authors);
}
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...
}
}
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$applications = Application::all();
$authors = Author::all();
return view('application.create', compact('applications', 'authors'));
}
public function create()
{
$authors = \App\Author::all();
$category = \App\Category::all();
return view('admin.create', compact('authors', 'category'));
}
public function getAuthors()
{
$authors = Author::all();
return view('admin.authors', compact('authors'));
}
public function showQuotation($id)
{
$quotation = Quotation::findOrFail($id);
$authors = Author::all();
return view('administration.quotation.showQuotation')->with('quotation', $quotation)->with('authors', $authors);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$authors = Author::all();
return view('authors/authors', ['authors' => $authors]);
}
