QueryableTable Class Reference
Inheritance diagram for QueryableTable:
Public Member Functions | |
| QueryableTable () | |
| copy () | |
| processCell ($cellType, $params, $cellValue, $rowN, $colN) | |
| parseParams ($cell) | |
| status () | |
| nCols () | |
| nRows () | |
| size () | |
| select ($key, $values=array()) | |
| where ($key, $values=array()) | |
| filter ($key, $values=array()) | |
| filterCols ($key, $values=array()) | |
| join ($table, $fillEmpty=false) | |
| union ($table) | |
| limit ($start, $amount) | |
| limitCols ($start, $amount) | |
| trim () | |
| trimCols () | |
| trimRows () | |
| concat () | |
| toString () | |
| isError () | |
| showErrorsSimple () | |
| showErrors () | |
| render ($sortable=false) | |
| renderForPDF ($sortable=false) | |
| rasterize () | |
| transpose () | |
| count () | |
Static Public Member Functions | |
| static | union_tables ($tables) |
| static | join_tables ($tables) |
Public Attributes | |
| $id | |
| $structure | |
| $errors | |
| $xls | |
| $class | |
Static Public Attributes | |
| static | $idCounter = 0 |
Protected Member Functions | |
| preprocessStructure ($structure) | |
| updateDynamic () | |
| like ($patterns, $value) | |
| parseValues ($values) | |
Static Protected Member Functions | |
| static | join_t ($tables, $class) |
| static | union_t ($tables, $class) |
Detailed Description
This Class is designed to allow for a queryable table. Functions like select, where, join etc. can be used to create different types of tables. NOTE: This class creates a mutable object, which means that any queries made upon it will modify the data. In most cases, a call to copy() should be made before any queries. TODO: It would be extremely useful to have an SQL like parser for Budgets. This could code which uses this class cleaner, as well as it might be able to execute the actions faster since it could do some query optimizations.
Member Function Documentation
| QueryableTable::size | ( | ) |
Returns the number of cells in the QueryableTable
- Returns:
- int The number of cells in the QueryableTabe
The documentation for this class was generated from the following file:
- extensions/QueryableTable/QueryableTable.php
