public function borrowList()
{
if (Datatable::shouldHandle()) {
return Datatable::collection(Book::with('author')->orderBy('id', 'desc')->get())->showColumns('id', 'title', 'amount', 'stock')->addColumn('author', function ($model) {
return $model->author->name;
})->addColumn('borrow', function ($model) {
$html = '<a href="' . route('books.borrow', $model->id) . '" class="btn btnn"> <i class="mdi-action-grade"></i> </a>';
return $html;
})->searchColumns('title', 'amount', 'author')->orderColumns('title', 'amount', 'author')->make();
}
}
public function download($id)
{
$book = Book::with(array('chapter' => function ($query) {
$query->orderBy('order', 'asc');
}, 'chapter.element' => function ($query) {
$query->orderBy('order', 'asc');
}))->where("id", "=", $id)->get();
$view = View::make('pdf/result', array("book" => $book));
$pdf = new TCPDF();
$pdf->AddPage();
$pdf->writeHTML($view, true, false, true, false, '');
$filename = public_path() . '/pdf/test.pdf';
$pdf->output($filename, 'F');
return Response::download($filename);
}
public static function search($query)
{
# If there is a query, search the library with that query
if ($query) {
# Eager load tags and author
$books = Book::with('tags', 'author')->whereHas('author', function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhereHas('tags', function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhere('title', 'LIKE', "%{$query}%")->orWhere('published', 'LIKE', "%{$query}%")->get();
} else {
# Eager load tags and author
$books = Book::with('tags', 'author')->get();
}
return $books;
}
public function index()
{
if (Datatable::shouldHandle()) {
return Datatable::collection(Book::with('author')->orderBy('id', 'desc')->get())->showColumns('id', 'title', 'amount')->addColumn('author', function ($model) {
return $model->author->name;
})->addColumn('1', function ($model) {
$html = '<a href="' . route('admin.books.edit', $model->id) . '" class="btn btnn"> <i class="mdi-editor-mode-edit"></i> </a>';
return $html;
})->addColumn('2', function ($model) {
$html = Form::open(['route' => ['admin.books.destroy', $model->id], 'method' => 'delete']);
$html .= '<button class="btn btnn" type="submit"> <i class="mdi-action-delete"></i> </button>';
$html .= Form::close();
return $html;
})->searchColumns('title', 'amount', 'author')->orderColumns('title', 'amount', 'author')->make();
}
return View::make('books.index')->withTitle('Buku');
}
/**
* Search among books, authors and tags
* @return Collection
*/
public static function search($query)
{
# If there is a query, search the library with that query
if ($query) {
# Eager load tags and author
$books = Book::with('tags', 'author')->whereHas('author', function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhereHas('tags', function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhere('title', 'LIKE', "%{$query}%")->orWhere('published', 'LIKE', "%{$query}%")->get();
# Note on what `use` means above:
# Closures may inherit variables from the parent scope.
# Any such variables must be passed to the `use` language construct.
} else {
# Eager load tags and author
$books = Book::with('tags', 'author')->get();
}
return $books;
}
public function getBooks()
{
$booklist1 = Book::with('Chapter')->with('Publisher')->get();
return $booklist1;
}
public function getEdit($id)
{
$book = Book::with('author')->findOrFail($id);
$authors = Author::getIdNamePair();
return View::make('book_edit')->with('book', $book)->with('authors', $authors);
}
/**
* Process the "Edit a book form"
* @return Redirect
*/
public function postEdit()
{
try {
$book = Book::with('tags')->findOrFail(Input::get('id'));
} catch (exception $e) {
return Redirect::to('/book')->with('flash_message', 'Book not found');
}
try {
# http://laravel.com/docs/4.2/eloquent#mass-assignment
$book->fill(Input::except('tags'));
$book->save();
# Update tags associated with this book
if (!isset($_POST['tags'])) {
$_POST['tags'] = array();
}
$book->updateTags($_POST['tags']);
return Redirect::action('BookController@getIndex')->with('flash_message', 'Your changes have been saved.');
} catch (exception $e) {
return Redirect::to('/book')->with('flash_message', 'Error saving changes.');
}
}
public function getIndex()
{
$books = Book::with('Author')->get();
return View::make('book_list')->with('books', $books);
}
public function create_book_without_isbn()
{
$this->assertEquals(new Book('Example', new Author('Test')), Book::with()->name('Example')->author(new Author('Test'))->create());
}
