PHP code example of wpzag / laravel-query-builder

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

wpzag / laravel-query-builder example snippets

'models' => [
    User::class => [
       '
       'filterable' => ['*:except:role', 'posts.title', 'posts.body', 'posts.created_at'],
       'sortable' => ['*'],
       'max_per_page' => 20             
     ],   
 ]       

 

$builder = QueryBuilder::for(User:class); //This applies // Returns the eloquent collection

$builder->withPagination() // Applies pagination to the query

$builder->withAppends() // Applies appends to the query

$builder->withPaginationAndAppends() // Applies pagination & appends to the query

 

QueryBuilder::for(User:class)->query()->where('id', '>', 1)->get();


// Or if you are using  withPagination(),withAppends() or withPaginationAndAppends() :
QueryBuilder::for(User:class, function($query){

	//extra queries here
	
	return $next($query);
})->withPaginationAndAppends();

users?filter[name]=john,rose

// User::where('name','like','%john%')
//       ->orWhere('name','like','%rose%')->get();

users?filter[name,username]=john

// User::where('name','like','%john%')
//       ->orWhere('username','like','%rose%')->get();

users?filter[name]=john,rose&filter[age]=gt.20

// User::where('name','like','%john%')
//       ->orWhere('name','like','%rose%')
//       ->where('age','>',20)->get();

users?filter[age][between]=[29,40]

// User::whereBetween('age', [29, 40])->get();

users?filter[email_verified_at][empty]

// User::whereNull('email_verified_at')->get();

users?filter[created_at][date]=2020-01-01

// User::whereDate('created_at', '2020-01-01')->get();

users?filter[posts.created_at]=lt.2020-01-01

// User::whereHas('posts', function($query) {
//     $query->whereDate('created_at', '<', '2020-01-01');
// })->get();

users?filter[role][not-in]=[admin,teacher,student]

// User::whereNotIn('role', ['admin', 'teacher', 'student'])->get();

users?sort=-created_at

// User::orderBy('created_at', 'desc')->get();

users?sort=-statues,name

// User::orderBy('statues', 'desc')->orderBy('name', 'asc')->get();

users?append=fullname

// User::get()->append('fullname')

users?ser::with('profile','posts.comments.author')->get();

users?page=2&limit=10

// User::paginate(10);

bash
php artisan vendor:publish --tag="query-builder-config"