});
// Group the books by the price...e.g if 3 books have thesame price, it groups them together as one
Route::get('book_groupBy', function () {
$books = \App\Book::groupBy('price')->get();
return $books;
});
// Return all books that have pages_count less than 150
Route::get('book_having', function () {
$books = \App\Book::having('pages_count', '<', 150)->get();
return $books;
});
// Return all books including the ones that have been deleted
// Listen: this requires your migration already has $table->softDeletes();
// and your Model also uses the Eloquent SoftDeletes trait
Route::get('all_books_including_those_that_have_been_deleted', function () {
$books = \App\Book::withTrashed()->get();
return $books;
});
// Return only all the books that have been deleted
Route::get('only_deleted_books', function () {
$books = \App\Book::onlyTrashed()->get();
return $books;
});
// Restore a record that has been deleted provided you have the id
Route::get('restore_deleted_book', function () {
$trashedBook = \App\Book::find($trashedBookId);
$trashedBook->restore();
});
// Truly delete a record, I mean really really delete..I mean Bye Bye to the record
Route::get('truly_delete_a_record', function () {
// $bookId refers to the id of the book you want to truly delete