QueryView

class \TYPO3\CMS\Core\Database\QueryView

Class used in module tools/dbint (advanced search) and which may hold code specific for that module However the class has a general principle in it which may be used in the web/export module.

Deprecated

since v11, will be removed in v12

Table of Contents

Properties

$hookArray  : array
$noDownloadB  : int
$storeList  : string
$backendUserAuthentication  : BackendUserAuthentication
$formName  : string
$iconFactory  : IconFactory
$languageService  : LanguageService
$menuItems  : array
$moduleName  : string
$settings  : array
Settings, usually from the controller (previously known from $GLOBALS['SOBE']->MOD_SETTINGS
$tableArray  : array

Methods

__construct()  : mixed
addToStoreQueryConfigs()  : array
Add to store query configs
cleanStoreQueryConfigs()  : array
Clean store query configs
csvRowTitles()  : string
CSV row titles
csvValues()  : string
CSV values
form()  : string
Get form
getProcessedValueExtra()  : string
Get processed value extra
getQueryResultCode()  : array
Get query result code
getTreeList()  : string
Get tree list
initStoreArray()  : array
Init store array
loadStoreQueryConfigs()  : array
Load store query configs
makeStoreControl()  : string
Make store control
makeValueList()  : string
Make value list
procesStoreControl()  : string
Process store control
queryMaker()  : string
Query marker
resultRowDisplay()  : string
Result row display
resultRowTitles()  : string
Render table header
saveQueryInAction()  : int
Save query in action
search()  : string
Search
setFormName()  : mixed
Sets the current name of the input form.

Properties

$storeList

public string $storeList = 'search_query_smallparts,search_result_labels,labels_noprefi…
Show the full value'search_query_smallparts,search_result_labels,labels_noprefix,show_deleted,queryConfig,queryTable,queryFields,queryLimit,queryOrder,queryOrderDesc,queryOrder2,queryOrder2Desc,queryGroup,search_query_makeQuery'

$menuItems

protected array $menuItems = []

information on the menu of this module

$settings

Settings, usually from the controller (previously known from $GLOBALS['SOBE']->MOD_SETTINGS

protected array $settings = []

$tableArray

protected array $tableArray = []

Methods

__construct()

public __construct([array|null $settings = null ][, array|null $menuItems = null ][, string|null $moduleName = null ]) : mixed

Parameters

$settings : array|null = null

previously stored in $GLOBALS['SOBE']->MOD_SETTINGS

$menuItems : array|null = null

previously stored in $GLOBALS['SOBE']->MOD_MENU

$moduleName : string|null = null

previously stored in $GLOBALS['SOBE']->moduleName

addToStoreQueryConfigs()

Add to store query configs

public addToStoreQueryConfigs(array $storeQueryConfigs, int $index) : array

Parameters

$storeQueryConfigs : array
$index : int

Return values

array

cleanStoreQueryConfigs()

Clean store query configs

public cleanStoreQueryConfigs(array $storeQueryConfigs, array $storeArray) : array

Parameters

$storeQueryConfigs : array
$storeArray : array

Return values

array

csvRowTitles()

CSV row titles

public csvRowTitles(array $row, array $conf) : string

Parameters

$row : array
$conf : array

Tags

todo

Unused?

Return values

string

csvValues()

CSV values

public csvValues(array $row[, string $delim = ',' ][, string $quote = '"' ][, array $conf = [] ][, string $table = '' ]) : string

Parameters

$row : array
$delim : string = ','
$quote : string = '"'
$conf : array = []
$table : string = ''

Return values

string —

A single line of CSV

form()

Get form

public form() : string

Return values

string

getProcessedValueExtra()

Get processed value extra

public getProcessedValueExtra(string $table, string $fieldName, string $fieldValue, array $conf, string $splitString) : string

Parameters

$table : string
$fieldName : string
$fieldValue : string
$conf : array

Not used

$splitString : string

Return values

string

getQueryResultCode()

Get query result code

public getQueryResultCode(string $type, array $dataRows, string $table) : array

Parameters

$type : string
$dataRows : array

Rows to display

$table : string

Tags

throws
Exception

Return values

array —

HTML-code for "header" and "content"

getTreeList()

Get tree list

public getTreeList(int $id, int $depth[, int $begin = 0 ][, string $permsClause = null ]) : string

Parameters

$id : int
$depth : int
$begin : int = 0
$permsClause : string = null

Return values

string

initStoreArray()

Init store array

public initStoreArray() : array

Return values

array

loadStoreQueryConfigs()

Load store query configs

public loadStoreQueryConfigs(array $storeQueryConfigs, int $storeIndex, array $writeArray) : array

Parameters

$storeQueryConfigs : array
$storeIndex : int
$writeArray : array

Return values

array

makeStoreControl()

Make store control

public makeStoreControl() : string

Return values

string

makeValueList()

Make value list

public makeValueList(string $fieldName, string $fieldValue, array $conf, string $table, string $splitString) : string

Parameters

$fieldName : string
$fieldValue : string
$conf : array
$table : string
$splitString : string

Return values

string

procesStoreControl()

Process store control

public procesStoreControl() : string

Return values

string

queryMaker()

Query marker

public queryMaker() : string

Return values

string

resultRowDisplay()

Result row display

public resultRowDisplay(array $row, array $conf, string $table) : string

Parameters

$row : array
$conf : array
$table : string

Return values

string

resultRowTitles()

Render table header

public resultRowTitles(array $row, array $conf) : string

Parameters

$row : array

Table columns

$conf : array

Table TCA

Return values

string —

HTML of table header

saveQueryInAction()

Save query in action

public saveQueryInAction(int $uid) : int

Parameters

$uid : int

Return values

int

Search

public search() : string

Return values

string

setFormName()

Sets the current name of the input form.

public setFormName(string $formName) : mixed

Parameters

$formName : string

The name of the form.

On this page