Read more about sorting features like: custom sorts, sort direction. #Sorting a query based on a request: /users?sort=id: $users = QueryBuilder :: for ( User ::class ) -> allowedSorts ( 'id' ) -> get () // all `User`s sorted by ascending id
Read more about include features like: including nested relationships, including relationship count. #Including relations based on a request: /users?include=posts: $users = QueryBuilder :: for ( User ::class ) -> allowedIncludes ( 'posts' ) -> get () // all `User`s with their `posts` loaded Read more about filtering features like: partial filters, exact filters, scope filters, custom filters, ignored values, default filter values. #Basic usage #Filter a query based on a request: /users?filter=John: use Spatie\QueryBuilder\QueryBuilder $users = QueryBuilder :: for ( User ::class ) -> allowedFilters ( 'name' ) -> get () // all `User`s that contain the string "John" in their name Here's how we use the package ourselves in Mailcoach. Query parameter names follow the JSON API specification as closely as possible. This means all your favorite methods and macros are still available. For most of my projects, this is all I need for my DB architecture. The QueryBuilder used in this package extends Laravel's default Eloquent builder. $queryBuilder = User:: select() // Do some querying.This package allows you to filter, sort and include eloquent relations based on a request. $title = 'Registered User Report' // Report title $meta = [ // For displaying filters description on header 'Registered on' => $fromDate. Laravel.io is a forum and community portal for developers who use the Laravel PHP framework About ProcessMaker ProcessMaker is an easy to use BPM and workflow software solution. $fromDate = $request-> input( 'from_date') Public function displayReport( Request $request)
0 kommentar(er)
