// Get the sum of all pages of books that have pages count greater than 170
Route::get('book_get_books_sum_price', function () {
$countTotal = \App\Book::where('pages_count', '>', 170)->sum('pages_count');
return $countTotal;
});
/**
* Utility Methods - Eager Loading Techniques. more gonna be added
*/
// Skip nothing and take 3 records
Route::get('book_skip_and_take', function () {
$books = \App\Book::skip(0)->take(2)->get();
return $books;
});
// Skip the first two records and take the next 3 records
Route::get('book_skip_and_take_again', function () {
$books = \App\Book::skip(2)->take(3)->get();
return $books;
});
// Order the books in ascending order according to their title, `desc` is also an alternative
Route::get('book_orderBy', function () {
$books = \App\Book::orderBy('title', 'asc')->get();
return $books;
});
// 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();
