Class QueryBuilderEngine

Class QueryBuilderEngine.

Yajra\Datatables\Engines\BaseEngine implements Yajra\Datatables\Contracts\DataTableEngineContract

Yajra\Datatables\Engines\QueryBuilderEngine

Direct known subclasses

Namespace: Yajra\Datatables\Engines
Package: Yajra\Datatables\Engines
Author: Arjay Angeles aqangeles@gmail.com
Located at Engines/QueryBuilderEngine.php

Methods summary
`public`	# `__construct( Illuminate\Database\Query\Builder $builder, Yajra\Datatables\Request $request )` Parameters `$builder` `$request`
`protected`	# `init( Yajra\Datatables\Request $request, Illuminate\Database\Query\Builder $builder, string $type = 'builder' )` Initialize attributes. Initialize attributes. Parameters `$request` `$builder` `$type`
`public`	# `filter( Closure $callback, boolean $globalSearch = false )` Set auto filter off and run your own filter. Overrides global search Set auto filter off and run your own filter. Overrides global search Parameters `$callback` `$globalSearch` Returns $this
`public Illuminate\Http\JsonResponse`	# `make( boolean $mDataSupport = false, boolean $orderFirst = false )` Organizes works Organizes works Parameters `$mDataSupport` `$orderFirst` Returns Illuminate\Http\JsonResponse Overrides `Yajra\Datatables\Engines\BaseEngine::make()`
`public integer`	# `totalCount( )` Count total items. Count total items. Returns integer
`public integer`	# `count( )` Counts current query. Counts current query. Returns integer
`protected string`	# `wrap( string $column )` Wrap column with DB grammar. Wrap column with DB grammar. Parameters `$column` Returns string
`public`	# `filtering( )` Perform global search. Perform global search.
`protected`	# `compileColumnQuery( mixed $query, string\|Closure $method, mixed $parameters, string $column, string $keyword )` Perform filter column on selected field. Perform filter column on selected field. Parameters `$query` `$method` `$parameters` `$column` `$keyword`
`protected array`	# `parameterize( )` Build Query Builder Parameters. Build Query Builder Parameters. Returns array
`protected array`	# `getEagerLoads( )` Get eager loads keys if eloquent. Get eager loads keys if eloquent. Returns array
`protected`	# `compileRelationSearch( mixed $query, string $relation, string $column, string $keyword )` Add relation query on global search. Add relation query on global search. Parameters `$query` `$relation` `$column` `$keyword`
`protected`	# `compileQuerySearch( mixed $query, string $column, string $keyword, string $relation = 'or' )` Compile query builder where clause depending on configurations. Compile query builder where clause depending on configurations. Parameters `$query` `$column` `$keyword` `$relation`
`public string`	# `castColumn( string $column )` Wrap a column and cast in pgsql. Wrap a column and cast in pgsql. Parameters `$column` Returns string
`protected string`	# `prepareKeyword( string $keyword )` Prepare search keyword based on configurations. Prepare search keyword based on configurations. Parameters `$keyword` Returns string
`public`	# `columnSearch( )` Perform column search. Perform column search.
`protected string`	# `joinEagerLoadedColumn( string $relation, string $relationColumn )` Join eager loaded relation and get the related column name. Join eager loaded relation and get the related column name. Parameters `$relation` `$relationColumn` Returns string
`protected`	# `compileColumnSearch( integer $i, mixed $column, string $keyword )` Compile queries for column search. Compile queries for column search. Parameters `$i` `$column` `$keyword`
`protected`	# `regexColumnSearch( mixed $column, string $keyword )` Compile regex query column search. Compile regex query column search. Parameters `$column` `$keyword`
`public`	# `ordering( )` Perform sorting of columns. Perform sorting of columns.
`public`	# `paging( )` Perform pagination Perform pagination
`public array\|static[]`	# `results( )` Get results Get results Returns array\|static[]

Methods inherited from Yajra\Datatables\Engines\BaseEngine
__call(), addColumn(), addIndexColumn(), addRowAttr(), addRowData(), blacklist(), createTransformer(), editColumn(), escapeColumns(), extractColumnName(), filterColumn(), filterRecords(), getColumnName(), getColumnNameByIndex(), getPrimaryKeyName(), getQueryBuilder(), isBlacklisted(), isCaseInsensitive(), isDebugging(), isEloquent(), isOracleSql(), isQueryBuilder(), isSmartSearch(), isWildcard(), order(), orderColumn(), orderColumns(), orderRecords(), overrideGlobalSearch(), paginate(), prefixColumn(), removeColumn(), render(), setRowAttr(), setRowClass(), setRowData(), setRowId(), setSerializer(), setTotalRecords(), setTransformer(), setupKeyword(), showDebugger(), skipPaging(), smart(), tableNames(), whitelist(), wildcardLikeString(), with(), withTrashed()

Properties inherited from Yajra\Datatables\Engines\BaseEngine
`$autoFilter, $builder, $columnDef, $columns, $connection, $database, $extraColumns, $filterCallback, $filterCallbackParameters, $filteredRecords, $isFilterApplied, $orderCallback, $prefix, $query, $query_type, $request, $serializer, $skipPaging, $templates, $totalRecords, $transformer, $withTrashed`

Namespaces

Classes

Class QueryBuilderEngine

Direct known subclasses

Parameters

Parameters

Parameters

Returns

Parameters

Returns

Overrides

Returns

Returns

Parameters

Returns

Parameters

Returns

Returns

Parameters

Parameters

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Parameters

Returns