PHP Class CrudKit\Data\SQLDataProvider

Inheritance: extends BaseSQLDataProvider
Afficher le fichier Open project: skyronic/crudkit Class Usage Examples

Protected Properties

Свойство Type Description
$colDefs array Column definitions which are raw arrays and haven't been cast into the appropriate SQLColumn
$columns CrudKit\Data\SQL\SQLColumn[] An array of SQL Columns
$conn Doctrine\DBAL\Connection
$primary_col string
$summary_cols string[] A list of summary columns
$tableName string Name of the table

Méthodes publiques

Méthode Description
__construct ( Doctrine\DBAL\Connection $connection, $table = null, $primaryColumn = null, array $summaryCols = [] )
addColumn ( $id, $expr, $label, $options = [] )
createItem ( array $values )
deleteItem ( $rowId )
deleteMultipleItems ( array $ids )
getData ( array $params = [] )
getEditForm ( $id = null )
getEditFormOrder ( )
getForeignValues ( $localKey, $value )
getRelationshipValues ( $id, $foreign )
getRow ( $id = null )
getRowCount ( array $params = [] )
getSchema ( )
getSummaryColumns ( )
hasMany ( $id, $label, $page, $options )
init ( )
manyToOne ( $id, $foreignKey, $extTable, $primary, $nameColumn, $label )
oneToMany ( $id, $dataProvider, $externalKey, $localKey, $name )
setConn ( Doctrine\DBAL\Connection $connection )
setPrimaryColumn ( $id, $expr )
setRow ( $id = null, array $values = [] )
setSummaryColumns ( array $summary_cols )
setTable ( $table )

Méthodes protégées

Méthode Description
addConditionsToBuilder ( $builder, $filters )
getPrimaryColumn ( ) : SQLColumn
getRequiredFields ( )
getValidatorForField ( $formKey )
internalAddColumn ( $category, $id, $options = [] )
isFieldInSchema ( $formKey )
postProcessColumns ( )
prepareObjectForClient ( $object )
processColumns ( ) Converts columns from raw objects to more powerful cool objects
queryColumns ( $queryType, $queryValues, $valueType, boolean $keyValue = false, $ignoreNull = false ) : array Super cool and useful function to query columns and get a reduced subset

Method Details

__construct() public méthode

public __construct ( Doctrine\DBAL\Connection $connection, $table = null, $primaryColumn = null, array $summaryCols = [] )
$connection Doctrine\DBAL\Connection
$summaryCols array

addColumn() public méthode

public addColumn ( $id, $expr, $label, $options = [] )

addConditionsToBuilder() protected méthode

protected addConditionsToBuilder ( $builder, $filters )
$builder QueryBuilder
$filters

createItem() public méthode

public createItem ( array $values )
$values array

deleteItem() public méthode

public deleteItem ( $rowId )

deleteMultipleItems() public méthode

public deleteMultipleItems ( array $ids )
$ids array

getData() public méthode

public getData ( array $params = [] )
$params array

getEditForm() public méthode

public getEditForm ( $id = null )

getEditFormOrder() public méthode

public getEditFormOrder ( )

getForeignValues() public méthode

public getForeignValues ( $localKey, $value )

getPrimaryColumn() protected méthode

protected getPrimaryColumn ( ) : SQLColumn
Résultat CrudKit\Data\SQL\SQLColumn

getRelationshipValues() public méthode

public getRelationshipValues ( $id, $foreign )

getRequiredFields() protected méthode

protected getRequiredFields ( )

getRow() public méthode

public getRow ( $id = null )

getRowCount() public méthode

public getRowCount ( array $params = [] )
$params array

getSchema() public méthode

public getSchema ( )

getSummaryColumns() public méthode

public getSummaryColumns ( )

getValidatorForField() protected méthode

protected getValidatorForField ( $formKey )

hasMany() public méthode

public hasMany ( $id, $label, $page, $options )

init() public méthode

public init ( )

internalAddColumn() protected méthode

protected internalAddColumn ( $category, $id, $options = [] )

isFieldInSchema() protected méthode

protected isFieldInSchema ( $formKey )

manyToOne() public méthode

public manyToOne ( $id, $foreignKey, $extTable, $primary, $nameColumn, $label )

oneToMany() public méthode

public oneToMany ( $id, $dataProvider, $externalKey, $localKey, $name )

postProcessColumns() protected méthode

protected postProcessColumns ( )

prepareObjectForClient() protected méthode

protected prepareObjectForClient ( $object )

processColumns() protected méthode

Converts columns from raw objects to more powerful cool objects
protected processColumns ( )

queryColumns() protected méthode

Super cool and useful function to query columns and get a reduced subset
protected queryColumns ( $queryType, $queryValues, $valueType, boolean $keyValue = false, $ignoreNull = false ) : array
$queryType
$queryValues
$valueType
$keyValue boolean
Résultat array

setConn() public méthode

public setConn ( Doctrine\DBAL\Connection $connection )
$connection Doctrine\DBAL\Connection

setPrimaryColumn() public méthode

public setPrimaryColumn ( $id, $expr )

setRow() public méthode

public setRow ( $id = null, array $values = [] )
$values array

setSummaryColumns() public méthode

public setSummaryColumns ( array $summary_cols )
$summary_cols array

setTable() public méthode

public setTable ( $table )
$table string

Property Details

$colDefs protected_oe property

Column definitions which are raw arrays and haven't been cast into the appropriate SQLColumn
protected array $colDefs
Résultat array

$columns protected_oe property

An array of SQL Columns
protected SQLColumn[],CrudKit\Data\SQL $columns
Résultat CrudKit\Data\SQL\SQLColumn[]

$conn protected_oe property

protected Connection,Doctrine\DBAL $conn
Résultat Doctrine\DBAL\Connection

$primary_col protected_oe property

protected string $primary_col
Résultat string

$summary_cols protected_oe property

A list of summary columns
protected string[] $summary_cols
Résultat string[]

$tableName protected_oe property

Name of the table
protected string $tableName
Résultat string