PHP code example of mattsplat / table-queries

1. Go to this page and download the library: Download mattsplat/table-queries library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

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

mattsplat / table-queries example snippets


$options = $request->only(['query', 'limit', 'page', 'orderBy', 'ascending', 'filter']);

$results = (new NoteTableQuery($options))->get();

return $results;


'sales as year_sales' => function ($q) {
    $q->selectRaw('sum(sales.amount)')->where('date', '>', today()->subYear())
}


User::with(['sales' => function ($q) { $q->where('date', '>', today()->subYear()) }])


$filters = [
            'age:>:21',
            'start_date:gte:11/21/2009',
            'id:in:33,44,200'                                                                
           ]
$results = (new TableQueryBuilder($query))
                ->setOptions(['filters' => $filters]);


$filters = collect($request->filter)->map(function ($name, $f) {
    return $name.$f;
})