- Children
- Implements
Countable
Methods |
public __construct() |
public addFind(array $parameters) : PHPFUI
|
public addGroupBy(string $field, bool $rollup = false) : static Add a valid group field
|
public addJoin(string $table, PHPFUI Add a join with another table
|
public addOrderBy(string $field, string $ascending = 'ASC') : static |
public addSelect(object|string $field, string $as = '') : static Add a field the the select, must be a valid field |
public addUnion(PHPFUI Add table for union.
|
public static capitalSplit(string $key) : string Split a string into words based on capital letters. Successive capital letters are considered an appreviation and grouped together. |
public cleanField(string $fieldName) : string |
public count() : int Returns the count for the limited query. |
public delete(bool $allowDeleteAll = false) : static Delete record matching the requested parameters |
public displayTransform(string $field, ?mixed $value = NULL) : ?mixed transform any field or table.field from join |
public find(array $parameters) : PHPFUI
|
public static getAllTables(array $skipTables = []) : array Get all tables in the application
|
public getArrayCursor() : PHPFUI Return a array collection matching the requested parameters |
public getDataObjectCursor() : PHPFUI Return a object collection matching the requested parameters |
public getExplainRows() : array Return an array of the explain query
|
public getFields() : array
|
public getGroupBy() : string
|
public getHaving(array $input) : string Return the string starting with "having" for the query
|
public getHavingCondition() : PHPFUI |
public getLastInput() : array
|
public getLastSql() : string |
public getLimit() : ?int
|
public getLimitClause() : string
|
public getOffset() : ?int |
public getOrderBy() : string
|
public getPage() : int |
public getPrimaryKeys() : array
|
public getRecord() : PHPFUI |
public getRecordCursor() : PHPFUI Return a Record collection matching the requested parameters |
public getRows() : array
|
public getSelectFields() : string
|
public getSelectSQL(array $input, bool $limited = true) : string
|
public getTableName() : string |
public getWhere(array $input) : string Return the string starting with "where" for the query
|
public getWhereCondition() : PHPFUI |
public insert(array $records, string $ignore = '') : bool Mass insertion. Does not use a transaction, so surround by a transaction if needed
|
public insertOrIgnore(array $records) : bool Inserts current data into table or ignores duplicate key if found
|
public setDistinct(string $distinct = 'DISTINCT') : static |
public setFullJoinSelects(bool $fullSelects = true) : static |
public setGroupBy(string $field, bool $rollup = false) : static Reset to this group by field
|
public setHaving(?PHPFUI |
public setLimit(int $limit = 20, ?int $page = NULL) : static
|
public setOffset(int $offset) : static |
public setOrderBy(string $field, string $ascending = 'ASC') : static |
public setSelectFields(string $clause) : static Set user defined select fields. |
public static setTranslationCallback(callable $callback) : void |
public setWhere(?PHPFUI |
public total() : int Returns the total count for the unlimited query. |
public translate(string $field = '') : string Translate any valid field. $field must be a valid field, or empty to return the translated table name. Joined fields should be specified as table.field. |
public update(array $variables) : static Update all record matching the requested parameters with the variables passed
|
public updateFromTable(array $request) : bool
|
public validateFromTable(array $request) : array
|
Properties |
protected static string $className = '' |
protected string $distinct = '' |
protected array $groupBys = []
|
protected ?PHPFUI |
protected PHPFUI |
protected array $joins = []
|
protected array $lastInput = []
|
protected string $lastSql = '' |
protected ?int $limit = NULL |
protected ?int $offset = NULL |
protected array $orderBys = []
|
protected ?int $page = NULL |
protected array $selects = []
|
protected array $unions = []
|
protected ?PHPFUI |
Properties |
private bool $fullJoinSelects = false |
private static $translationCallback = NULL
|
Methods |
private doTranslation(string $text) : string |
private getCountSQL(array $input) : string
|
private getJoins(array $input) : string
|
private getTotalSQL(array $input) : string
|
Properties |
protected static string $className = '' |
private static $translationCallback = NULL
|
Methods |
public static capitalSplit(string $key) : string Split a string into words based on capital letters. Successive capital letters are considered an appreviation and grouped together. |
public static getAllTables(array $skipTables = []) : array Get all tables in the application
|
public static setTranslationCallback(callable $callback) : void |