‪TYPO3CMS  ‪main
TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController Class Reference

Public Member Functions

 __construct (protected IconFactory $iconFactory, protected readonly UriBuilder $uriBuilder, protected readonly ModuleTemplateFactory $moduleTemplateFactory, protected readonly PlatformHelper $platformHelper,)
 
 handleRequest (ServerRequestInterface $request)
 

Protected Member Functions

 menuConfig (ServerRequestInterface $request)
 
 setUpDocHeader (ModuleTemplate $moduleTemplate)
 
 referenceIndexAction (ModuleTemplate $view, ServerRequestInterface $request)
 
 searchAction (ModuleTemplate $view, ServerRequestInterface $request)
 
 queryMaker (ServerRequestInterface $request)
 
 getSelectQuery (string $qString='')
 
string getTreeList (int $id, int $depth, int $begin=0, string $permsClause='')
 
array getQueryResultCode (string $type, array $dataRows, string $table, ServerRequestInterface $request)
 
 csvValues (array $row, string $delim=',', string $quote='"', array $conf = [], string $table = '')
 
 resultRowTitles (?array $row, array $conf)
 
 resultRowDisplay (array $row, array $conf, string $table, ServerRequestInterface $request)
 
 getProcessedValueExtra (string $table, string $fieldName, string $fieldValue, array $conf, string $splitString)
 
 makeValueList (string $fieldName, string $fieldValue, array $conf, string $table, string $splitString)
 
 getQuery (array $queryConfig, string $pad='')
 
 getQuerySingle (array $conf, bool $first)
 
mixed cleanInputVal (array $conf, string $suffix='')
 
 convertIso8601DatetimeStringToUnixTimestamp (array $conf)
 
 isDateOfIso8601Format (mixed $date)
 
 makeSelectorTable (array $modSettings, ServerRequestInterface $request, string $enableList='table, fields, query, group, order, limit')
 
 cleanUpQueryConfig (array $queryConfig)
 
 verifyType (string $fieldName)
 
 verifyComparison (int $comparison, bool $neg)
 
 getFormElements (int $subLevel=0, string|array $queryConfig=null, string $parent='')
 
 getDateTimePickerField (string $name, string $timestamp, string $type)
 
 makeOptionList (string $fieldName, array $conf, string $table)
 
 mkOperatorSelect (string $name, string $op, bool $draw, bool $submit)
 
 makeComparisonSelector (string $subscript, string $fieldName, array $conf)
 
 mkCompSelect (string $name, int $comparison, int $neg)
 
 printCodeArray (array $codeArr, int $recursionLevel=0)
 
 mkFieldToInputSelect (string $name, string $fieldName)
 
 procesData (ServerRequestInterface $request, array $qC=[])
 
 getSubscript ($arr)
 
 getLabelCol ()
 
 mkTypeSelect (string $name, string $fieldName, string $prepend='FIELD_')
 
 updateIcon ()
 
 setAndCleanUpExternalLists (string $name, string $list, string $force='')
 
 mkTableSelect (string $name, string $cur)
 
 init (string $name, string $table, string $fieldList='', array $settings=[])
 
 makeFieldList ()
 
 makeStoreControl ()
 
 procesStoreControl (ServerRequestInterface $request)
 
 cleanStoreQueryConfigs (array $storeQueryConfigs, array $storeArray)
 
 addToStoreQueryConfigs (array $storeQueryConfigs, int $index)
 
 loadStoreQueryConfigs (array $storeQueryConfigs, int $storeIndex, array $writeArray)
 
 initStoreArray ()
 
 search (ServerRequestInterface $request)
 
 recordStatisticsAction (ModuleTemplate $view, ServerRequestInterface $request)
 
 relationsAction (ModuleTemplate $view)
 
 getBackendUserAuthentication ()
 
 getLanguageService ()
 
string getDropdownMenu (string $elementName, string|int $currentValue, mixed $menuItems, ServerRequestInterface $request)
 
string getFuncCheck (string $elementName, string|bool|int $currentValue, ServerRequestInterface $request, string $tagParams='')
 

Protected Attributes

array $MOD_MENU = []
 
array $MOD_SETTINGS = []
 
string $formName = ''
 
string $moduleName = 'system_dbint'
 
bool $showFieldAndTableNames = false
 
string $table = ''
 
bool $enablePrefix = false
 
int $noDownloadB = 0
 
array $tableArray = []
 
array $queryConfig = []
 
array $extFieldLists = []
 
array $fields = []
 
string $storeList = 'search_query_smallparts,search_result_labels,labels_noprefix,show_deleted,queryConfig,queryTable,queryFields,queryLimit,queryOrder,queryOrderDesc,queryOrder2,queryOrder2Desc,queryGroup,search_query_makeQuery'
 
bool $enableQueryParts = false
 
array $lang
 
string $fieldName = ''
 
string $name = ''
 
string $fieldList
 
array $comp_offsets
 
array $compSQL
 

Private Member Functions

 renderNoResultsFoundMessage ()
 

Detailed Description

"DB Check" module.

This class is a specific Backend controller implementation and is not part of the TYPO3's Core API.

Definition at line 68 of file DatabaseIntegrityController.php.

Constructor & Destructor Documentation

◆ __construct()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::__construct ( protected IconFactory  $iconFactory,
protected readonly UriBuilder  $uriBuilder,
protected readonly ModuleTemplateFactory  $moduleTemplateFactory,
protected readonly PlatformHelper  $platformHelper 
)

Definition at line 223 of file DatabaseIntegrityController.php.

Member Function Documentation

◆ addToStoreQueryConfigs()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::addToStoreQueryConfigs ( array  $storeQueryConfigs,
int  $index 
)
protected

◆ cleanInputVal()

mixed TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::cleanInputVal ( array  $conf,
string  $suffix = '' 
)
protected

◆ cleanStoreQueryConfigs()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::cleanStoreQueryConfigs ( array  $storeQueryConfigs,
array  $storeArray 
)
protected

◆ cleanUpQueryConfig()

◆ convertIso8601DatetimeStringToUnixTimestamp()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::convertIso8601DatetimeStringToUnixTimestamp ( array  $conf)
protected

◆ csvValues()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::csvValues ( array  $row,
string  $delim = ',',
string  $quote = '"',
array  $conf = [],
string  $table = '' 
)
protected

◆ getBackendUserAuthentication()

◆ getDateTimePickerField()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getDateTimePickerField ( string  $name,
string  $timestamp,
string  $type 
)
protected

◆ getDropdownMenu()

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getDropdownMenu ( string  $elementName,
string|int  $currentValue,
mixed  $menuItems,
ServerRequestInterface  $request 
)
protected

Returns a selector box to switch the view.

Parameters
string$elementName‪The form elements name, probably something like "SET[...]
string | int$currentValue‪The value to be selected currently.
mixed$menuItems‪An array with the menu items for the selector box
Returns
‪string HTML code for selector box

Definition at line 2860 of file DatabaseIntegrityController.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\camelCaseToLowerCaseUnderscored().

Referenced by TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController\searchAction().

◆ getFormElements()

◆ getFuncCheck()

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getFuncCheck ( string  $elementName,
string|bool|int  $currentValue,
ServerRequestInterface  $request,
string  $tagParams = '' 
)
protected

Checkbox function menu.

Parameters
string$elementName‪The form elements name, probably something like "SET[...]
string | bool | int$currentValue‪The value to be selected currently.
string$tagParams‪Additional attributes for the checkbox input tag
Returns
‪string HTML code for checkbox

Definition at line 2905 of file DatabaseIntegrityController.php.

Referenced by TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController\makeSelectorTable(), and TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController\searchAction().

◆ getLabelCol()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getLabelCol ( )
protected

◆ getLanguageService()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getLanguageService ( )
protected

◆ getProcessedValueExtra()

◆ getQuery()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getQuery ( array  $queryConfig,
string  $pad = '' 
)
protected

◆ getQueryResultCode()

◆ getQuerySingle()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getQuerySingle ( array  $conf,
bool  $first 
)
protected

◆ getSelectQuery()

◆ getSubscript()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getSubscript (   $arr)
protected

◆ getTreeList()

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::getTreeList ( int  $id,
int  $depth,
int  $begin = 0,
string  $permsClause = '' 
)
protected

◆ handleRequest()

◆ init()

◆ initStoreArray()

◆ isDateOfIso8601Format()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::isDateOfIso8601Format ( mixed  $date)
protected

Checks if the given value is of the ISO 8601 format.

Definition at line 1350 of file DatabaseIntegrityController.php.

Referenced by TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController\convertIso8601DatetimeStringToUnixTimestamp().

◆ loadStoreQueryConfigs()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::loadStoreQueryConfigs ( array  $storeQueryConfigs,
int  $storeIndex,
array  $writeArray 
)
protected

◆ makeComparisonSelector()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::makeComparisonSelector ( string  $subscript,
string  $fieldName,
array  $conf 
)
protected

◆ makeFieldList()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::makeFieldList ( )
protected

◆ makeOptionList()

◆ makeSelectorTable()

◆ makeStoreControl()

◆ makeValueList()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::makeValueList ( string  $fieldName,
string  $fieldValue,
array  $conf,
string  $table,
string  $splitString 
)
protected

Definition at line 1025 of file DatabaseIntegrityController.php.

◆ menuConfig()

◆ mkCompSelect()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::mkCompSelect ( string  $name,
int  $comparison,
int  $neg 
)
protected

◆ mkFieldToInputSelect()

◆ mkOperatorSelect()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::mkOperatorSelect ( string  $name,
string  $op,
bool  $draw,
bool  $submit 
)
protected

◆ mkTableSelect()

◆ mkTypeSelect()

◆ printCodeArray()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::printCodeArray ( array  $codeArr,
int  $recursionLevel = 0 
)
protected

◆ procesData()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::procesData ( ServerRequestInterface  $request,
array  $qC = [] 
)
protected

◆ procesStoreControl()

◆ queryMaker()

◆ recordStatisticsAction()

◆ referenceIndexAction()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::referenceIndexAction ( ModuleTemplate  $view,
ServerRequestInterface  $request 
)
protected

◆ relationsAction()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::relationsAction ( ModuleTemplate  $view)
protected

◆ renderNoResultsFoundMessage()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::renderNoResultsFoundMessage ( )
private

◆ resultRowDisplay()

◆ resultRowTitles()

◆ search()

◆ searchAction()

◆ setAndCleanUpExternalLists()

◆ setUpDocHeader()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::setUpDocHeader ( ModuleTemplate  $moduleTemplate)
protected

◆ updateIcon()

◆ verifyComparison()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::verifyComparison ( int  $comparison,
bool  $neg 
)
protected

◆ verifyType()

TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::verifyType ( string  $fieldName)
protected

Member Data Documentation

◆ $comp_offsets

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$comp_offsets
protected
Initial value:
= [
'text' => 0,
'number' => 1,
'multiple' => 2,
'relation' => 2,
'date' => 3,
'time' => 3,
'boolean' => 4,
'binary' => 5,
]

Definition at line 158 of file DatabaseIntegrityController.php.

◆ $compSQL

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$compSQL
protected

Definition at line 168 of file DatabaseIntegrityController.php.

◆ $enablePrefix

bool TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$enablePrefix = false
protected

Definition at line 89 of file DatabaseIntegrityController.php.

◆ $enableQueryParts

bool TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$enableQueryParts = false
protected

Definition at line 96 of file DatabaseIntegrityController.php.

◆ $extFieldLists

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$extFieldLists = []
protected

Definition at line 93 of file DatabaseIntegrityController.php.

◆ $fieldList

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$fieldList
protected

◆ $fieldName

◆ $fields

◆ $formName

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$formName = ''
protected

Definition at line 80 of file DatabaseIntegrityController.php.

◆ $lang

◆ $MOD_MENU

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$MOD_MENU = []
protected

The module menu items array.

Definition at line 73 of file DatabaseIntegrityController.php.

◆ $MOD_SETTINGS

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$MOD_SETTINGS = []
protected

Current settings for the keys of the MOD_MENU array.

Definition at line 78 of file DatabaseIntegrityController.php.

◆ $moduleName

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$moduleName = 'system_dbint'
protected

Definition at line 81 of file DatabaseIntegrityController.php.

◆ $name

◆ $noDownloadB

int TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$noDownloadB = 0
protected

Definition at line 90 of file DatabaseIntegrityController.php.

◆ $queryConfig

◆ $showFieldAndTableNames

bool TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$showFieldAndTableNames = false
protected

If the current user is an admin and $GLOBALS['TYPO3_CONF_VARS']['BE']['debug'] is set to true, the names of fields and tables are displayed.

Definition at line 87 of file DatabaseIntegrityController.php.

◆ $storeList

string TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$storeList = 'search_query_smallparts,search_result_labels,labels_noprefix,show_deleted,queryConfig,queryTable,queryFields,queryLimit,queryOrder,queryOrderDesc,queryOrder2,queryOrder2Desc,queryGroup,search_query_makeQuery'
protected

Definition at line 95 of file DatabaseIntegrityController.php.

◆ $table

◆ $tableArray

array TYPO3\CMS\Lowlevel\Controller\DatabaseIntegrityController::$tableArray = []
protected

Definition at line 91 of file DatabaseIntegrityController.php.