PHP 클래스 Yajra\Datatables\Engines\QueryBuilderEngine

저자: Arjay Angeles ([email protected])
상속: extends BaseEngine
파일 보기 프로젝트 열기: yajra/laravel-datatables-oracle 1 사용 예제들

공개 메소드들

메소드 설명
__construct ( Builder $builder, Request $request )
castColumn ( string $column ) : string Wrap a column and cast in pgsql.
columnSearch ( ) : void Perform column search.
count ( ) : integer Counts current query.
filter ( Closure $callback, boolean $globalSearch = false ) Set auto filter off and run your own filter.
filtering ( ) : void Perform global search.
make ( boolean $mDataSupport = false, boolean $orderFirst = false ) : Illuminate\Http\JsonResponse Organizes works
ordering ( ) : void Perform sorting of columns.
paging ( ) : void Perform pagination
results ( ) : array | static[] Get results
totalCount ( ) : integer Count total items.

보호된 메소드들

메소드 설명
compileColumnQuery ( mixed $query, string | Closur\Closure $method, mixed $parameters, string $column, string $keyword ) Perform filter column on selected field.
compileColumnSearch ( integer $i, mixed $column, string $keyword ) Compile queries for column search.
compileQuerySearch ( mixed $query, string $column, string $keyword, string $relation = 'or' ) Compile query builder where clause depending on configurations.
compileRelationSearch ( mixed $query, string $relation, string $column, string $keyword ) Add relation query on global search.
getEagerLoads ( ) : array Get eager loads keys if eloquent.
getNullsLastSql ( string $column, string $direction ) : string Get NULLS LAST SQL.
init ( Request $request, Builder $builder, string $type = 'builder' ) Initialize attributes.
joinEagerLoadedColumn ( string $relation, string $relationColumn ) : string Join eager loaded relation and get the related column name.
parameterize ( ) : array Build Query Builder Parameters.
prepareKeyword ( string $keyword ) : string Prepare search keyword based on configurations.
regexColumnSearch ( mixed $column, string $keyword ) Compile regex query column search.
wrap ( string $column ) : string Wrap column with DB grammar.

비공개 메소드들

메소드 설명
getSearchKeyword ( integer $i, boolean $raw = false ) : string Get proper keyword to use for search.
modelUseSoftDeletes ( ) : boolean Check if model use SoftDeletes trait

메소드 상세

__construct() 공개 메소드

public __construct ( Builder $builder, Request $request )
$builder Illuminate\Database\Query\Builder
$request Yajra\Datatables\Request

castColumn() 공개 메소드

Wrap a column and cast in pgsql.
public castColumn ( string $column ) : string
$column string
리턴 string

columnSearch() 공개 메소드

Perform column search.
public columnSearch ( ) : void
리턴 void

compileColumnQuery() 보호된 메소드

Perform filter column on selected field.
protected compileColumnQuery ( mixed $query, string | Closur\Closure $method, mixed $parameters, string $column, string $keyword )
$query mixed
$method string | Closur\Closure
$parameters mixed
$column string
$keyword string

compileColumnSearch() 보호된 메소드

Compile queries for column search.
protected compileColumnSearch ( integer $i, mixed $column, string $keyword )
$i integer
$column mixed
$keyword string

compileQuerySearch() 보호된 메소드

Compile query builder where clause depending on configurations.
protected compileQuerySearch ( mixed $query, string $column, string $keyword, string $relation = 'or' )
$query mixed
$column string
$keyword string
$relation string

compileRelationSearch() 보호된 메소드

Add relation query on global search.
protected compileRelationSearch ( mixed $query, string $relation, string $column, string $keyword )
$query mixed
$relation string
$column string
$keyword string

count() 공개 메소드

Counts current query.
public count ( ) : integer
리턴 integer

filter() 공개 메소드

Overrides global search
public filter ( Closure $callback, boolean $globalSearch = false )
$callback Closure
$globalSearch boolean

filtering() 공개 메소드

Perform global search.
public filtering ( ) : void
리턴 void

getEagerLoads() 보호된 메소드

Get eager loads keys if eloquent.
protected getEagerLoads ( ) : array
리턴 array

getNullsLastSql() 보호된 메소드

Get NULLS LAST SQL.
protected getNullsLastSql ( string $column, string $direction ) : string
$column string
$direction string
리턴 string

init() 보호된 메소드

Initialize attributes.
protected init ( Request $request, Builder $builder, string $type = 'builder' )
$request Yajra\Datatables\Request
$builder Illuminate\Database\Query\Builder
$type string

joinEagerLoadedColumn() 보호된 메소드

Join eager loaded relation and get the related column name.
protected joinEagerLoadedColumn ( string $relation, string $relationColumn ) : string
$relation string
$relationColumn string
리턴 string

make() 공개 메소드

Organizes works
public make ( boolean $mDataSupport = false, boolean $orderFirst = false ) : Illuminate\Http\JsonResponse
$mDataSupport boolean
$orderFirst boolean
리턴 Illuminate\Http\JsonResponse

ordering() 공개 메소드

Perform sorting of columns.
public ordering ( ) : void
리턴 void

paging() 공개 메소드

Perform pagination
public paging ( ) : void
리턴 void

parameterize() 보호된 메소드

Build Query Builder Parameters.
protected parameterize ( ) : array
리턴 array

prepareKeyword() 보호된 메소드

Prepare search keyword based on configurations.
protected prepareKeyword ( string $keyword ) : string
$keyword string
리턴 string

regexColumnSearch() 보호된 메소드

Compile regex query column search.
protected regexColumnSearch ( mixed $column, string $keyword )
$column mixed
$keyword string

results() 공개 메소드

Get results
public results ( ) : array | static[]
리턴 array | static[]

totalCount() 공개 메소드

Count total items.
public totalCount ( ) : integer
리턴 integer

wrap() 보호된 메소드

Wrap column with DB grammar.
protected wrap ( string $column ) : string
$column string
리턴 string