PHP Класс Yajra\Datatables\Engines\BaseEngine

Наследование: implements Yajra\Datatables\Contracts\DataTableEngineContract
Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство Тип Описание
$request Yajra\Datatables\Request Datatables Request object.

Защищенные свойства (Protected)

Свойство Тип Описание
$appends array Array of data to append on json response.
$autoFilter boolean Auto-filter flag.
$builder Illuminate\Database\Query\Builder Query builder object.
$columnDef array DT columns definitions container (add/edit/remove/filter/order/escape).
$columns array Array of result columns/fields.
$connection Illuminate\Database\Connection Database connection used.
$database string Database driver used.
$extraColumns array Extra/Added columns.
$filterCallback callable Callback to override global search.
$filterCallbackParameters mixed Parameters to passed on filterCallback.
$filteredRecords integer Total filtered records.
$isFilterApplied boolean [internal] Track if any filter was applied for at least one column
$nullsLast boolean Flag for ordering NULLS LAST option.
$orderCallback callable Custom ordering callback.
$prefix string Database prefix
$query Illuminate\Database\Query\Builder | Illuminate\Database\Eloquent\Builder Builder object.
$query_type string Query type.
$serializer string | null Fractal serializer class.
$skipPaging boolean Skip paginate as needed.
$templates array DT row templates container.
$totalRecords integer Total records.
$transformer League\Fractal\TransformerAbstract Output transformer.
$withTrashed boolean By default we do not select soft deleted records

Открытые методы

Метод Описание
__call ( string $name, array $arguments ) : mixed Allows previous API calls where the methods were snake_case.
addColumn ( string $name, string | callable $content, boolean | integer $order = false ) Add column in collection.
addIndexColumn ( ) Add DT row index column on response.
addRowAttr ( string $key, string | callable $value ) Add DT_RowAttr template.
addRowData ( string $key, string | callable $value ) Add DT_RowData template.
blacklist ( array $blacklist ) Update list of columns that is not allowed for search/sort.
editColumn ( string $name, string | callable $content ) Edit column's content.
escapeColumns ( string | array $columns = '*' ) Declare columns to escape values.
filterColumn ( string $column, string | callable $method ) Override default column filter search.
getQueryBuilder ( mixed $instance = null ) : mixed Get Query Builder object.
isCaseInsensitive ( ) : boolean Get config is case insensitive status.
isDebugging ( ) : boolean Check if app is in debug mode.
isEloquent ( ) : boolean Check if the engine used was eloquent.
isOracleSql ( ) : boolean Check if the current sql language is based on oracle syntax.
isQueryBuilder ( ) : boolean Check query type is a builder.
isSmartSearch ( ) : boolean Check if DataTables uses smart search.
isWildcard ( ) : boolean Get config use wild card status.
make ( boolean $mDataSupport = false, boolean $orderFirst = false ) : Illuminate\Http\JsonResponse Organizes works.
order ( callable $closure ) Override default ordering method with a closure callback.
orderByNullsLast ( ) Set datatables to do ordering with NULLS LAST option.
orderColumn ( string $column, string $sql, array $bindings = [] ) Override default column ordering.
orderColumns ( array $columns, string $sql, array $bindings = [] ) Order each given columns versus the given custom sql.
removeColumn ( ) Remove column from collection.
setRowAttr ( array $data ) Set DT_RowAttr templates.
setRowClass ( string | callable $content ) Sets DT_RowClass template.
setRowData ( array $data ) Set DT_RowData templates.
setRowId ( string | callable $content ) Sets DT_RowId template.
setSerializer ( string $serializer ) Set fractal serializer class.
setTotalRecords ( integer $total ) Set total records manually.
setTransformer ( League\Fractal\TransformerAbstract $transformer ) Set data output transformer.
skipPaging ( ) Skip pagination as needed.
smart ( boolean $bool = true ) Set smart search config at runtime.
whitelist ( string | array $whitelist = '*' ) Update list of columns that is not allowed for search/sort.
with ( mixed $key, mixed $value = '' ) Append data on json response.
withTrashed ( boolean $withTrashed = true ) Change withTrashed flag value.

Защищенные методы

Метод Описание
createSerializer ( ) : League\Fractal\Serializer\SerializerAbstract Get or create transformer serializer instance.
createTransformer ( ) : League\Fractal\TransformerAbstract Get or create transformer instance.
extractColumnName ( string $str, boolean $wantsAlias ) : string Get column name from string.
filterRecords ( ) : void Perform necessary filters.
getColumnName ( integer $index, boolean $wantsAlias = false ) : string Get column name to be use for filtering and sorting.
getColumnNameByIndex ( integer $index ) : mixed Get column name by order column index.
getPrimaryKeyName ( ) : string If column name could not be resolved then use primary key.
getProcessedData ( boolean | false $object = false ) : array Get processed data
isBlacklisted ( string $column ) : boolean Check if column is blacklisted.
orderRecords ( boolean $skip ) : void Sort records.
overrideGlobalSearch ( callable $callback, mixed $parameters, boolean $autoFilter = false ) Update flags to disable global search
paginate ( ) : void Apply pagination.
render ( boolean $object = false ) : Illuminate\Http\JsonResponse Render json response.
setupKeyword ( string $value ) : string Setup search keyword.
showDebugger ( array $output ) : array Append debug parameters on output.
wildcardLikeString ( string $str, boolean $lowercase = true ) : string Adds % wildcards to the given string.

Описание методов

__call() публичный Метод

Will convert a camelCase API call to a snake_case call. Allow query builder method to be used by the engine.
public __call ( string $name, array $arguments ) : mixed
$name string
$arguments array
Результат mixed

addColumn() публичный Метод

Add column in collection.
public addColumn ( string $name, string | callable $content, boolean | integer $order = false )
$name string
$content string | callable
$order boolean | integer

addIndexColumn() публичный Метод

Add DT row index column on response.
public addIndexColumn ( )

addRowAttr() публичный Метод

Add DT_RowAttr template.
public addRowAttr ( string $key, string | callable $value )
$key string
$value string | callable

addRowData() публичный Метод

Add DT_RowData template.
public addRowData ( string $key, string | callable $value )
$key string
$value string | callable

blacklist() публичный Метод

Update list of columns that is not allowed for search/sort.
public blacklist ( array $blacklist )
$blacklist array

createSerializer() защищенный Метод

Get or create transformer serializer instance.
protected createSerializer ( ) : League\Fractal\Serializer\SerializerAbstract
Результат League\Fractal\Serializer\SerializerAbstract

createTransformer() защищенный Метод

Get or create transformer instance.
protected createTransformer ( ) : League\Fractal\TransformerAbstract
Результат League\Fractal\TransformerAbstract

editColumn() публичный Метод

Edit column's content.
public editColumn ( string $name, string | callable $content )
$name string
$content string | callable

escapeColumns() публичный Метод

Declare columns to escape values.
public escapeColumns ( string | array $columns = '*' )
$columns string | array

extractColumnName() защищенный Метод

Get column name from string.
protected extractColumnName ( string $str, boolean $wantsAlias ) : string
$str string
$wantsAlias boolean
Результат string

filterColumn() публичный Метод

Override default column filter search.
public filterColumn ( string $column, string | callable $method )
$column string
$method string | callable

filterRecords() защищенный Метод

Perform necessary filters.
protected filterRecords ( ) : void
Результат void

getColumnName() защищенный Метод

Get column name to be use for filtering and sorting.
protected getColumnName ( integer $index, boolean $wantsAlias = false ) : string
$index integer
$wantsAlias boolean
Результат string

getColumnNameByIndex() защищенный Метод

Get column name by order column index.
protected getColumnNameByIndex ( integer $index ) : mixed
$index integer
Результат mixed

getPrimaryKeyName() защищенный Метод

If column name could not be resolved then use primary key.
protected getPrimaryKeyName ( ) : string
Результат string

getProcessedData() защищенный Метод

Get processed data
protected getProcessedData ( boolean | false $object = false ) : array
$object boolean | false
Результат array

getQueryBuilder() публичный Метод

Get Query Builder object.
public getQueryBuilder ( mixed $instance = null ) : mixed
$instance mixed
Результат mixed

isBlacklisted() защищенный Метод

Check if column is blacklisted.
protected isBlacklisted ( string $column ) : boolean
$column string
Результат boolean

isCaseInsensitive() публичный Метод

Get config is case insensitive status.
public isCaseInsensitive ( ) : boolean
Результат boolean

isDebugging() публичный Метод

Check if app is in debug mode.
public isDebugging ( ) : boolean
Результат boolean

isEloquent() публичный Метод

Check if the engine used was eloquent.
public isEloquent ( ) : boolean
Результат boolean

isOracleSql() публичный Метод

Check if the current sql language is based on oracle syntax.
public isOracleSql ( ) : boolean
Результат boolean

isQueryBuilder() публичный Метод

Check query type is a builder.
public isQueryBuilder ( ) : boolean
Результат boolean

isSmartSearch() публичный Метод

Check if DataTables uses smart search.
public isSmartSearch ( ) : boolean
Результат boolean

isWildcard() публичный Метод

Get config use wild card status.
public isWildcard ( ) : boolean
Результат boolean

make() публичный Метод

Organizes works.
public make ( boolean $mDataSupport = false, boolean $orderFirst = false ) : Illuminate\Http\JsonResponse
$mDataSupport boolean
$orderFirst boolean
Результат Illuminate\Http\JsonResponse

order() публичный Метод

Override default ordering method with a closure callback.
public order ( callable $closure )
$closure callable

orderByNullsLast() публичный Метод

Set datatables to do ordering with NULLS LAST option.
public orderByNullsLast ( )

orderColumn() публичный Метод

Override default column ordering.
public orderColumn ( string $column, string $sql, array $bindings = [] )
$column string
$sql string
$bindings array

orderColumns() публичный Метод

Order each given columns versus the given custom sql.
public orderColumns ( array $columns, string $sql, array $bindings = [] )
$columns array
$sql string
$bindings array

orderRecords() защищенный Метод

Sort records.
protected orderRecords ( boolean $skip ) : void
$skip boolean
Результат void

overrideGlobalSearch() защищенный Метод

Update flags to disable global search
protected overrideGlobalSearch ( callable $callback, mixed $parameters, boolean $autoFilter = false )
$callback callable
$parameters mixed
$autoFilter boolean

paginate() защищенный Метод

Apply pagination.
protected paginate ( ) : void
Результат void

removeColumn() публичный Метод

Remove column from collection.
public removeColumn ( )

render() защищенный Метод

Render json response.
protected render ( boolean $object = false ) : Illuminate\Http\JsonResponse
$object boolean
Результат Illuminate\Http\JsonResponse

setRowAttr() публичный Метод

result: .
public setRowAttr ( array $data )
$data array

setRowClass() публичный Метод

result: .
public setRowClass ( string | callable $content )
$content string | callable

setRowData() публичный Метод

Set DT_RowData templates.
public setRowData ( array $data )
$data array

setRowId() публичный Метод

result: .
public setRowId ( string | callable $content )
$content string | callable

setSerializer() публичный Метод

Set fractal serializer class.
public setSerializer ( string $serializer )
$serializer string

setTotalRecords() публичный Метод

Set total records manually.
public setTotalRecords ( integer $total )
$total integer

setTransformer() публичный Метод

Set data output transformer.
public setTransformer ( League\Fractal\TransformerAbstract $transformer )
$transformer League\Fractal\TransformerAbstract

setupKeyword() защищенный Метод

Setup search keyword.
protected setupKeyword ( string $value ) : string
$value string
Результат string

showDebugger() защищенный Метод

Append debug parameters on output.
protected showDebugger ( array $output ) : array
$output array
Результат array

skipPaging() публичный Метод

Skip pagination as needed.
public skipPaging ( )

smart() публичный Метод

Set smart search config at runtime.
public smart ( boolean $bool = true )
$bool boolean

whitelist() публичный Метод

Update list of columns that is not allowed for search/sort.
public whitelist ( string | array $whitelist = '*' )
$whitelist string | array

wildcardLikeString() защищенный Метод

Adds % wildcards to the given string.
protected wildcardLikeString ( string $str, boolean $lowercase = true ) : string
$str string
$lowercase boolean
Результат string

with() публичный Метод

Append data on json response.
public with ( mixed $key, mixed $value = '' )
$key mixed
$value mixed

withTrashed() публичный Метод

Change withTrashed flag value.
public withTrashed ( boolean $withTrashed = true )
$withTrashed boolean

Описание свойств

$appends защищенное свойство

Array of data to append on json response.
protected array $appends
Результат array

$autoFilter защищенное свойство

Auto-filter flag.
protected bool $autoFilter
Результат boolean

$builder защищенное свойство

Query builder object.
protected Builder,Illuminate\Database\Query $builder
Результат Illuminate\Database\Query\Builder

$columnDef защищенное свойство

DT columns definitions container (add/edit/remove/filter/order/escape).
protected array $columnDef
Результат array

$columns защищенное свойство

Array of result columns/fields.
protected array $columns
Результат array

$connection защищенное свойство

Database connection used.
protected Connection,Illuminate\Database $connection
Результат Illuminate\Database\Connection

$database защищенное свойство

Database driver used.
protected string $database
Результат string

$extraColumns защищенное свойство

Extra/Added columns.
protected array $extraColumns
Результат array

$filterCallback защищенное свойство

Callback to override global search.
protected callable $filterCallback
Результат callable

$filterCallbackParameters защищенное свойство

Parameters to passed on filterCallback.
protected mixed $filterCallbackParameters
Результат mixed

$filteredRecords защищенное свойство

Total filtered records.
protected int $filteredRecords
Результат integer

$isFilterApplied защищенное свойство

[internal] Track if any filter was applied for at least one column
protected bool $isFilterApplied
Результат boolean

$nullsLast защищенное свойство

Flag for ordering NULLS LAST option.
protected bool $nullsLast
Результат boolean

$orderCallback защищенное свойство

Custom ordering callback.
protected callable $orderCallback
Результат callable

$prefix защищенное свойство

Database prefix
protected string $prefix
Результат string

$query защищенное свойство

Builder object.
protected Builder,Illuminate\Database\Query|Builder,Illuminate\Database\Eloquent $query
Результат Illuminate\Database\Query\Builder | Illuminate\Database\Eloquent\Builder

$query_type защищенное свойство

Query type.
protected string $query_type
Результат string

$request публичное свойство

Datatables Request object.
public Request,Yajra\Datatables $request
Результат Yajra\Datatables\Request

$serializer защищенное свойство

Fractal serializer class.
protected string|null $serializer
Результат string | null

$skipPaging защищенное свойство

Skip paginate as needed.
protected bool $skipPaging
Результат boolean

$templates защищенное свойство

DT row templates container.
protected array $templates
Результат array

$totalRecords защищенное свойство

Total records.
protected int $totalRecords
Результат integer

$transformer защищенное свойство

Output transformer.
protected TransformerAbstract,League\Fractal $transformer
Результат League\Fractal\TransformerAbstract

$withTrashed защищенное свойство

By default we do not select soft deleted records
protected bool $withTrashed
Результат boolean