PHP Класс PMA\libraries\controllers\table\TableSearchController

Наследование: extends PMA\libraries\controllers\TableController
Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство Тип Описание
$url_query

Открытые методы

Метод Описание
__construct ( string $searchType, string $url_query ) Constructor
changeTableInfoAction ( ) : void Change table info action
displaySelectionFormAction ( $datalabel = null ) : void Display selection form action
doSelectionAction ( ) : void Do selection action
findAction ( ) : void Find action
getColumnMinMax ( string $column ) : array Finds minimum and maximum value of a given column.
getColumnProperties ( integer $search_index, integer $column_index ) : array Provides a column's type, collation, operators list, and criteria value to display in table search form
getDataRowAction ( ) : void Get data row action
getReplacePreview ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : string Returns HTML for previewing strings found and their replacements
indexAction ( ) : void Index action
rangeSearchAction ( ) : void Range search action
replace ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : void Replaces a given string in a column with a give replacement
replaceAction ( ) : void Replace action
zoomSubmitAction ( string $dataLabel, string $goto ) : void Zoom submit action

Приватные методы

Метод Описание
_buildSqlQuery ( ) : string Builds the sql search query from the post parameters
_generateWhereClause ( ) : string Generates the where clause for the SQL search query to be executed
_getEnumWhereClause ( mixed $criteriaValues, string $func_type ) : string Return the where clause in case column's type is ENUM.
_getGeomWhereClause ( mixed $criteriaValues, string $names, string $func_type, string $types, boolean $geom_func = null ) : string Return the where clause for a geometrical column.
_getRegexReplaceRows ( integer $columnIndex, string $find, string $replaceWith, string $charSet ) : array Finds and returns Regex pattern and their replacements
_getSubTabs ( ) : array Returns an array with necessary configurations to create sub-tabs in the table_select page.
_getWhereClause ( mixed $criteriaValues, string $names, string $types, string $func_type, boolean $unaryFlag, boolean $geom_func = null ) : string Return the where clause for query generation based on the inputs provided.
_loadTableInfo ( ) : void Gets all the columns of a table along with their types, collations and whether null or not.

Описание методов

__construct() публичный Метод

Constructor
public __construct ( string $searchType, string $url_query )
$searchType string Search type
$url_query string URL query

changeTableInfoAction() публичный Метод

Change table info action
public changeTableInfoAction ( ) : void
Результат void

displaySelectionFormAction() публичный Метод

Display selection form action
public displaySelectionFormAction ( $datalabel = null ) : void
Результат void

doSelectionAction() публичный Метод

Do selection action
public doSelectionAction ( ) : void
Результат void

findAction() публичный Метод

Find action
public findAction ( ) : void
Результат void

getColumnMinMax() публичный Метод

Finds minimum and maximum value of a given column.
public getColumnMinMax ( string $column ) : array
$column string Column name
Результат array

getColumnProperties() публичный Метод

Provides a column's type, collation, operators list, and criteria value to display in table search form
public getColumnProperties ( integer $search_index, integer $column_index ) : array
$search_index integer Row number in table search form
$column_index integer Column index in ColumnNames array
Результат array Array containing column's properties

getDataRowAction() публичный Метод

Get data row action
public getDataRowAction ( ) : void
Результат void

getReplacePreview() публичный Метод

Returns HTML for previewing strings found and their replacements
public getReplacePreview ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : string
$columnIndex integer index of the column
$find string string to find in the column
$replaceWith string string to replace with
$useRegex boolean to use Regex replace or not
$charSet string character set of the connection
Результат string HTML for previewing strings found and their replacements

indexAction() публичный Метод

Index action
public indexAction ( ) : void
Результат void

rangeSearchAction() публичный Метод

Range search action
public rangeSearchAction ( ) : void
Результат void

replace() публичный Метод

Replaces a given string in a column with a give replacement
public replace ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : void
$columnIndex integer index of the column
$find string string to find in the column
$replaceWith string string to replace with
$useRegex boolean to use Regex replace or not
$charSet string character set of the connection
Результат void

replaceAction() публичный Метод

Replace action
public replaceAction ( ) : void
Результат void

zoomSubmitAction() публичный Метод

Zoom submit action
public zoomSubmitAction ( string $dataLabel, string $goto ) : void
$dataLabel string Data label
$goto string Goto
Результат void

Описание свойств

$url_query защищенное свойство

protected $url_query