class DataGridRepository extends DataGridRepository

Class DataGridRepository

Constants

TABLE_NAME

PRIMARY_KEY_COLUMN

Properties

protected Connection $db from AbstractRepository

Methods

__construct(Connection $db)

No description

bool|int
insert(array $data)

Executes the SQL insert statement

string
getTableName(string $tableName = '')

No description

bool|int
delete(int|array $entryId, string $columnName = self::PRIMARY_KEY_COLUMN)

Executes the SQL delete statement

bool|int
update(array $data, int|array $entryId)

Executes the SQL update statement

string
buildLimitStmt(int|string $limitStart = '', int|string $resultsPerPage = '')

Build the SQL limit

array
getOneById(int $entryId)

No description

array
getAll(ColumnPriorityQueue $columns)

No description

array
getColumns(ColumnPriorityQueue $gridColumns)

No description

string
getFrom()

No description

addJoin(QueryBuilder $queryBuilder)

No description

addWhere(QueryBuilder $queryBuilder)

No description

addGroupBy(QueryBuilder $queryBuilder)

No description

setOrderBy(ColumnPriorityQueue $gridColumns, QueryBuilder $queryBuilder)

No description

array
getParameters()

No description

Details

in AbstractRepository at line 28
__construct(Connection $db)

Parameters

Connection $db

in AbstractRepository at line 39
bool|int insert(array $data)

Executes the SQL insert statement

Parameters

array $data

Return Value

bool|int

in AbstractRepository at line 55
string getTableName(string $tableName = '')

Parameters

string $tableName

Return Value

string

in AbstractRepository at line 67
bool|int delete(int|array $entryId, string $columnName = self::PRIMARY_KEY_COLUMN)

Executes the SQL delete statement

Parameters

int|array $entryId
string $columnName

Return Value

bool|int

in AbstractRepository at line 95
bool|int update(array $data, int|array $entryId)

Executes the SQL update statement

Parameters

array $data
int|array $entryId

Return Value

bool|int

in AbstractRepository at line 114
protected string buildLimitStmt(int|string $limitStart = '', int|string $resultsPerPage = '')

Build the SQL limit

Parameters

int|string $limitStart
int|string $resultsPerPage

Return Value

string

in AbstractRepository at line 130
array getOneById(int $entryId)

Parameters

int $entryId

Return Value

array

in DataGridRepository at line 23
array getAll(ColumnPriorityQueue $columns)

Parameters

ColumnPriorityQueue $columns

Return Value

array

in DataGridRepository at line 44
protected array getColumns(ColumnPriorityQueue $gridColumns)

Parameters

ColumnPriorityQueue $gridColumns

Return Value

array

in DataGridRepository at line 65
protected string getFrom()

Return Value

string

in DataGridRepository at line 73
protected addJoin(QueryBuilder $queryBuilder)

Parameters

QueryBuilder $queryBuilder

in DataGridRepository at line 80
protected addWhere(QueryBuilder $queryBuilder)

Parameters

QueryBuilder $queryBuilder

in DataGridRepository at line 87
protected addGroupBy(QueryBuilder $queryBuilder)

Parameters

QueryBuilder $queryBuilder

in DataGridRepository at line 95
protected setOrderBy(ColumnPriorityQueue $gridColumns, QueryBuilder $queryBuilder)

Parameters

ColumnPriorityQueue $gridColumns
QueryBuilder $queryBuilder

in DataGridRepository at line 113
protected array getParameters()

Return Value

array