Fetch rows that are in the maximum extents of the geometry represented by a BOX2D string
void
addBbox
(Zend_Db_Select $select, string $bbox)
-
Zend_Db_Select
$select
-
string
$bbox: Geometry represented by a BOX2D string
Add item
integer
addItemForEditCallback
(Zend_Db_Table_Row $row, [Zend_Form $form = NULL])
-
Zend_Db_Table_Row
$row: New row
-
Zend_Form
$form: Form object populated with request data
Redefined in descendants as:
Sets label user settings for current layer
array
addLabelFields
(Zend_Db_Select $select, $fields)
-
Zend_Db_Select
$select
-
array
$fields: Fields
Delete item
bool
deleteItemForEditCallback
(integer $gid)
Redefined in descendants as:
Format information results
void
formatInfoResults
(stdClass $itemField, string $name, mixed $value, Zend_Form $form)
-
stdClass
$itemField
-
string
$name
-
mixed
$value
-
Zend_Form
$form: Edit attributes form object of this layer
Format search results
Zend_Db_Table_Rowset
formatSearchResults
(Zend_Db_Table_Rowset $rows, Zend_Form $form)
-
Zend_Db_Table_Rowset
$rows
-
Zend_Form
$form: Edit attributes form object of this layer
Get area
string
getArea
(string $geometry)
-
string
$geometry: Geometry expression that can be represented by a field name or a string in WKT/GeoJSON format
Get rows that have a $field LIKE $text
Zend_Db_Table_Rowset
getByField
(array $field, string $text, [ $options = array()])
-
array
$field
-
string
$text
-
array
$options: Available options:
- form Zend_Form - Edit attributes form object of this layer
- bbox string - Fetch rows that are in the maximum extents of the geometry represented by a BOX2D string
- limit integer - Number of rows to fecth
Get data by point coordinates and pixel size
Zend_Db_Table_Rowset
getByPoint
(float $x, float $y, float $buffer, [ $options = array()])
-
float
$x: North coordinate
-
float
$y: East coordinate
-
float
$buffer: Buffer size in meters
-
array
$options: Available options:
- form Zend_Form - Edit attributes form object of this layer
- limit integer - Number of rows to fecth
Get the table default
This is used by the Information controller. It shows all the fields with their default field and then you click on one all the fields of the clicked row are shown.
string
getDefaultField
()
Get item for add
void
getItemForAddCallback
([Zend_Form $form = NULL])
-
Zend_Form
$form: Form object populated with request data
Get item for edit
Zend_Db_Table_Row
getItemForEditCallback
(Zend_Db_Table_Row $row, [Zend_Form $form = NULL])
-
Zend_Db_Table_Row
$row: Updated row
-
Zend_Form
$form: Form object populated with request data
Redefined in descendants as:
Get items
Zend_Db_Table_Rowset
getItems
([ $options = array()])
-
array
$options: Available options:
- geometryAsWkt bool - Return geometry in WKT format
- whereIntersection string - Fetch rows that intersect specified table name and geometry (table.the_geom)
- whereId integer - Fetch row with the specified id
Get maximum and minimum value of a field
Zend_Db_Table_Rowset
getMaxAndMinValues
(Zend_Db_Table_Row $field)
-
Zend_Db_Table_Row
$field: Field
Get an array of table fields
array
getPublicFields
([ $options = array()])
-
array
$options: Available options
Get maximum and minimum value of a field
Zend_Db_Table_Rowset
getRandomValues
(Zend_Db_Table_Row $field, [ $options = array()])
-
Zend_Db_Table_Row
$field: Field
-
array
$options: Available options:
- limit integer - Number of rows to fecth
Get the current select object of table
Zend_Db_Select
getSelect
([string $dump = 'gid_geometry_label'], [ $options = array()])
-
string
$dump: - What data should be requested from the layer (gid_geometry, gid_geometry_label, all, all_table, count)
-
array
$options: Available options:
- geometryAsWkt bool - Return geometry in WKT format
- geometryAsGeoJSON bool - Return geometry in GeoJSON format
- withIntersection string - Table name and geometry field (table.the_geom) that will be intersected with the current geometry. Returns the product of the intersection as the geometry.
- whereIntersection string - Fetch rows that intersect specified table name and geometry (table.the_geom)
- whereStm string - Fetch rows that match the specified statement
- fields array - An array [[name, visibility, expr]] of additional field to fetch
- form Zend_Form - Edit attributes form object of this layer
- limit integer - Number of rows to fecth
Redefined in descendants as:
Get settings
array
getSettings
()
Fetch unique value of a column
array
getUniqueColumnValues
(string $field, [ $options = array()], array $optionsAvailable)
-
string
$field: Column from which to fetch values
-
array
$optionsAvailable: options:
- limit integer - Number of rows to fecth
-
array
$options
Called after getSelect to join tables to current table
void
joinTables
(Zend_Db_Select $select, [ $options = array()])
-
Zend_Db_Select
$select
-
array
$options: Available options
Update geometry
string
parseGeometryBeforeEdit
(string $geometry)
-
string
$geometry: Geometry represented as WKT
Set settings
void
setSettings
(array $settings)
-
array
$settings: Settings
Update item
bool
updateItemForEditCallback
(Zend_Db_Table_Row $row, [Zend_Form $form = NULL], $oldRow)
-
Zend_Db_Table_Row
$row: Updated row
-
Zend_Form
$form: Form object populated with request data
-
$oldRow
Redefined in descendants as:
Filter select
void
_filter
(Zend_Db_Select $select, [ $options = array()])
-
Zend_Db_Select
$select
-
array
$options: Available options
Called after _joinTables
void
_joinTablesCallback
(Zend_Db_Select $select)
Redefined in descendants as:
Called after getPublicFields
array
_publicFieldsCallback
( $fieldsArr, [ $options = array()])
-
array
$fieldsArr
-
array
$options: Available options
Redefined in descendants as:
Query builder
void
_querybuilder
(Zend_Db_Select $select, [ $options = array()])
-
Zend_Db_Select
$select
-
array
$options: Available options:
- querybuilder array - Query builder settings
Called after _querybuilder
void
_querybuilderCallback
(Zend_Db_Select $select, [ $options = array()])
-
Zend_Db_Select
$select
-
array
$options: Available options
Redefined in descendants as:
Is called after getSelect to apply custom logic
void
_selectCallback
(Zend_Db_Select $select, [ $options = array()])
-
Zend_Db_Select
$select
-
array
$options: Available options
Redefined in descendants as:
Inherited Methods
Inherited From Giscuit_Db_Table_Abstract
Giscuit_Db_Table_Abstract::__construct()
Giscuit_Db_Table_Abstract::count()
Giscuit_Db_Table_Abstract::getPrimaryKey()
Giscuit_Db_Table_Abstract::joinMultilangField()
Giscuit_Db_Table_Abstract::moveItem()
Giscuit_Db_Table_Abstract::whereActive()
Giscuit_Db_Table_Abstract::whereCurrentUser()
Giscuit_Db_Table_Abstract::whereId()