backendUserAuthentication = $GLOBALS['BE_USER'];
$this->languageService = $GLOBALS['LANG'];
$this->languageService->includeLLFile('EXT:core/Resources/Private/Language/locallang_t3lib_fullsearch.xlf');
$this->iconFactory = GeneralUtility::makeInstance(IconFactory::class);
}
/**
* Get form
*
* @return string
*/
public function form()
{
$markup = [];
$markup[] = '';
$markup[] = '';
$markup[] = '
';
$markup[] = '';
$markup[] = '';
$markup[] = '
';
return implode(LF, $markup);
}
/**
* Make store control
*
* @return string
*/
public function makeStoreControl()
{
// Load/Save
$storeArray = $this->initStoreArray();
$opt = [];
foreach ($storeArray as $k => $v) {
$opt[] = '';
}
// Actions:
if (ExtensionManagementUtility::isLoaded('sys_action') && $this->backendUserAuthentication->isAdmin()) {
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_action');
$queryBuilder->getRestrictions()->removeAll();
$statement = $queryBuilder->select('uid', 'title')
->from('sys_action')
->where($queryBuilder->expr()->eq('type', $queryBuilder->createNamedParameter(2, \PDO::PARAM_INT)))
->orderBy('title')
->execute();
$opt[] = '';
while ($row = $statement->fetch()) {
$opt[] = '';
}
}
$markup = [];
$markup[] = '';
$markup[] = '
';
$markup[] = '
Load/Save Query
';
$output .= '' . $this->makeStoreControl() . '
';
$output .= $msg;
}
// Query Maker:
$queryGenerator = GeneralUtility::makeInstance(QueryGenerator::class);
$queryGenerator->init('queryConfig', $GLOBALS['SOBE']->MOD_SETTINGS['queryTable']);
if ($this->formName) {
$queryGenerator->setFormName($this->formName);
}
$tmpCode = $queryGenerator->makeSelectorTable($GLOBALS['SOBE']->MOD_SETTINGS);
$output .= '' . 'Make query
' . $tmpCode . '
';
$mQ = $GLOBALS['SOBE']->MOD_SETTINGS['search_query_makeQuery'];
// Make form elements:
if ($queryGenerator->table && is_array($GLOBALS['TCA'][$queryGenerator->table])) {
if ($mQ) {
// Show query
$queryGenerator->enablePrefix = 1;
$queryString = $queryGenerator->getQuery($queryGenerator->queryConfig);
$selectQueryString = $queryGenerator->getSelectQuery($queryString);
$connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable($queryGenerator->table);
$isConnectionMysql = (bool)(strpos($connection->getServerVersion(), 'MySQL') === 0);
$fullQueryString = '';
try {
if ($mQ === 'explain' && $isConnectionMysql) {
// EXPLAIN is no ANSI SQL, for now this is only executed on mysql
// @todo: Move away from getSelectQuery() or model differently
$fullQueryString = 'EXPLAIN ' . $selectQueryString;
$dataRows = $connection->executeQuery('EXPLAIN ' . $selectQueryString)->fetchAll();
} elseif ($mQ === 'count') {
$queryBuilder = $connection->createQueryBuilder();
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$dataRows = $queryBuilder->count('*')
->from($queryGenerator->table)
->where(QueryHelper::stripLogicalOperatorPrefix($queryString));
$fullQueryString = $queryBuilder->getSQL();
$queryBuilder->execute()->fetchColumn(0);
$dataRows = [$dataRows];
} else {
$fullQueryString = $selectQueryString;
$dataRows = $connection->executeQuery($selectQueryString)->fetchAll();
}
if (!$this->backendUserAuthentication->userTS['mod.']['dbint.']['disableShowSQLQuery']) {
$output .= 'SQL query
' . htmlspecialchars($fullQueryString) . '
' . $cPR['header'] . '
' . $cPR['content'] . '
';
} catch (DBALException $e) {
if (!$this->backendUserAuthentication->userTS['mod.']['dbint.']['disableShowSQLQuery']) {
$output .= 'SQL query
' . htmlspecialchars($fullQueryString) . '
Error: '
. $e->getMessage()
. '
';
$output .= 'SQL error
' . $out . '
';
}
}
}
return '' . $output . '
';
}
/**
* Get query result code
*
* @param string $type
* @param array $dataRows Rows to display
* @param string $table
* @return string
*/
public function getQueryResultCode($type, array $dataRows, $table)
{
$out = '';
$cPR = [];
switch ($type) {
case 'count':
$cPR['header'] = 'Count';
$cPR['content'] = '
' . $dataRows[0] . ' records selected.';
break;
case 'all':
$rowArr = [];
$dataRow = null;
foreach ($dataRows as $dataRow) {
$rowArr[] = $this->resultRowDisplay($dataRow, $GLOBALS['TCA'][$table], $table);
}
if (is_array($this->hookArray['beforeResultTable'])) {
foreach ($this->hookArray['beforeResultTable'] as $_funcRef) {
$out .= GeneralUtility::callUserFunction($_funcRef, $GLOBALS['SOBE']->MOD_SETTINGS, $this);
}
}
if (!empty($rowArr)) {
$out .= ''
. $this->resultRowTitles($dataRow, $GLOBALS['TCA'][$table], $table) . implode(LF, $rowArr)
. '
';
}
if (!$out) {
$flashMessage = GeneralUtility::makeInstance(
FlashMessage::class,
'No rows selected!',
'',
FlashMessage::INFO
);
GeneralUtility::makeInstance(FlashMessageRendererResolver::class)
->resolve()
->render([$flashMessage]);
}
$cPR['header'] = 'Result';
$cPR['content'] = $out;
break;
case 'csv':
$rowArr = [];
$first = 1;
foreach ($dataRows as $dataRow) {
if ($first) {
$rowArr[] = $this->csvValues(array_keys($dataRow), ',', '');
$first = 0;
}
$rowArr[] = $this->csvValues($dataRow, ',', '"', $GLOBALS['TCA'][$table], $table);
}
if (!empty($rowArr)) {
$out .= '';
if (!$this->noDownloadB) {
$out .= '
';
}
// Downloads file:
// @todo: args. routing anyone?
if (GeneralUtility::_GP('download_file')) {
$filename = 'TYPO3_' . $table . '_export_' . date('dmy-Hi') . '.csv';
$mimeType = 'application/octet-stream';
header('Content-Type: ' . $mimeType);
header('Content-Disposition: attachment; filename=' . $filename);
echo implode(CRLF, $rowArr);
die;
}
}
if (!$out) {
$out = 'No rows selected!';
}
$cPR['header'] = 'Result';
$cPR['content'] = $out;
break;
case 'explain':
default:
foreach ($dataRows as $dataRow) {
$out .= '
' . DebugUtility::viewArray($dataRow);
}
$cPR['header'] = 'Explain SQL query';
$cPR['content'] = $out;
}
return $cPR;
}
/**
* CSV values
*
* @param array $row
* @param string $delim
* @param string $quote
* @param array $conf
* @param string $table
* @return string A single line of CSV
*/
public function csvValues($row, $delim = ',', $quote = '"', $conf = [], $table = '')
{
$valueArray = $row;
if ($GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels'] && $table) {
foreach ($valueArray as $key => $val) {
$valueArray[$key] = $this->getProcessedValueExtra($table, $key, $val, $conf, ';');
}
}
return CsvUtility::csvValues($valueArray, $delim, $quote);
}
/**
* Search
*
* @return string
*/
public function search()
{
$SET = $GLOBALS['SOBE']->MOD_SETTINGS;
$swords = $SET['sword'];
$out = '';
if ($swords) {
foreach ($GLOBALS['TCA'] as $table => $value) {
// Get fields list
$conf = $GLOBALS['TCA'][$table];
// Avoid querying tables with no columns
if (empty($conf['columns'])) {
continue;
}
$connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable($table);
$tableColumns = $connection->getSchemaManager()->listTableColumns($table);
$fieldsInDatabase = [];
foreach ($tableColumns as $column) {
$fieldsInDatabase[] = $column->getName();
}
$fields = array_intersect(array_keys($conf['columns']), $fieldsInDatabase);
$queryBuilder = $connection->createQueryBuilder();
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$queryBuilder->count('*')->from($table);
$likes = [];
$excapedLikeString = '%' . $queryBuilder->escapeLikeWildcards($swords) . '%';
foreach ($fields as $field) {
$likes[] = $queryBuilder->expr()->like(
$field,
$queryBuilder->createNamedParameter($excapedLikeString, \PDO::PARAM_STR)
);
}
$count = $queryBuilder->orWhere(...$likes)->execute()->fetchColumn(0);
if ($count > 0) {
$queryBuilder = $connection->createQueryBuilder();
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$queryBuilder->select('uid', $conf['ctrl']['label'])
->from($table)
->setMaxResults(200);
$likes = [];
foreach ($fields as $field) {
$likes[] = $queryBuilder->expr()->like(
$field,
$queryBuilder->createNamedParameter($excapedLikeString, \PDO::PARAM_STR)
);
}
$statement = $queryBuilder->orWhere(...$likes)->execute();
$lastRow = null;
$rowArr = [];
while ($row = $statement->fetch()) {
$rowArr[] = $this->resultRowDisplay($row, $conf, $table);
$lastRow = $row;
}
$markup = [];
$markup[] = '';
$markup[] = '
';
$markup[] = htmlspecialchars($this->languageService->sL($conf['ctrl']['title'])) . ' (' . $count . ')';
$markup[] = '
';
$markup[] = '
';
$markup[] = $this->resultRowTitles($lastRow, $conf, $table);
$markup[] = implode(LF, $rowArr);
$markup[] = '
';
$markup[] = '
';
foreach ($row as $fieldName => $fieldValue) {
if (GeneralUtility::inList($SET['queryFields'], $fieldName)
|| !$SET['queryFields']
&& $fieldName !== 'pid'
&& $fieldName !== 'deleted'
) {
if ($SET['search_result_labels']) {
$fVnew = $this->getProcessedValueExtra($table, $fieldName, $fieldValue, $conf, '
');
} else {
$fVnew = htmlspecialchars($fieldValue);
}
$out .= '' . $fVnew . ' | ';
}
}
$out .= '';
/** @var \TYPO3\CMS\Backend\Routing\UriBuilder $uriBuilder */
$uriBuilder = GeneralUtility::makeInstance(\TYPO3\CMS\Backend\Routing\UriBuilder::class);
if (!$row['deleted']) {
$out .= '';
} else {
$out .= '';
}
$_params = [$table => $row];
if (is_array($this->hookArray['additionalButtons'])) {
foreach ($this->hookArray['additionalButtons'] as $_funcRef) {
$out .= GeneralUtility::callUserFunction($_funcRef, $_params, $this);
}
}
$out .= ' |
';
return $out;
}
/**
* Get processed value extra
*
* @param string $table
* @param string $fieldName
* @param string $fieldValue
* @param array $conf Not used
* @param string $splitString
* @return string
*/
public function getProcessedValueExtra($table, $fieldName, $fieldValue, $conf, $splitString)
{
$out = '';
$fields = [];
// Analysing the fields in the table.
if (is_array($GLOBALS['TCA'][$table])) {
$fC = $GLOBALS['TCA'][$table]['columns'][$fieldName];
$fields = $fC['config'];
$fields['exclude'] = $fC['exclude'];
if (is_array($fC) && $fC['label']) {
$fields['label'] = preg_replace('/:$/', '', trim($this->languageService->sL($fC['label'])));
switch ($fields['type']) {
case 'input':
if (preg_match('/int|year/i', $fields['eval'])) {
$fields['type'] = 'number';
} elseif (preg_match('/time/i', $fields['eval'])) {
$fields['type'] = 'time';
} elseif (preg_match('/date/i', $fields['eval'])) {
$fields['type'] = 'date';
} else {
$fields['type'] = 'text';
}
break;
case 'check':
if (!$fields['items']) {
$fields['type'] = 'boolean';
} else {
$fields['type'] = 'binary';
}
break;
case 'radio':
$fields['type'] = 'multiple';
break;
case 'select':
$fields['type'] = 'multiple';
if ($fields['foreign_table']) {
$fields['type'] = 'relation';
}
if ($fields['special']) {
$fields['type'] = 'text';
}
break;
case 'group':
$fields['type'] = 'files';
if ($fields['internal_type'] === 'db') {
$fields['type'] = 'relation';
}
break;
case 'user':
case 'flex':
case 'passthrough':
case 'none':
case 'text':
default:
$fields['type'] = 'text';
}
} else {
$fields['label'] = '[FIELD: ' . $fieldName . ']';
switch ($fieldName) {
case 'pid':
$fields['type'] = 'relation';
$fields['allowed'] = 'pages';
break;
case 'cruser_id':
$fields['type'] = 'relation';
$fields['allowed'] = 'be_users';
break;
case 'tstamp':
case 'crdate':
$fields['type'] = 'time';
break;
default:
$fields['type'] = 'number';
}
}
}
switch ($fields['type']) {
case 'date':
if ($fieldValue != -1) {
$out = strftime('%d-%m-%Y', $fieldValue);
}
break;
case 'time':
if ($fieldValue != -1) {
if ($splitString === '
') {
$out = strftime('%H:%M' . $splitString . '%d-%m-%Y', $fieldValue);
} else {
$out = strftime('%H:%M %d-%m-%Y', $fieldValue);
}
}
break;
case 'multiple':
case 'binary':
case 'relation':
$out = $this->makeValueList($fieldName, $fieldValue, $fields, $table, $splitString);
break;
case 'boolean':
$out = $fieldValue ? 'True' : 'False';
break;
case 'files':
default:
$out = htmlspecialchars($fieldValue);
}
return $out;
}
/**
* Get tree list
*
* @param int $id
* @param int $depth
* @param int $begin
* @param string $permsClause
*
* @return string
*/
public function getTreeList($id, $depth, $begin = 0, $permsClause = null)
{
$depth = (int)$depth;
$begin = (int)$begin;
$id = (int)$id;
if ($id < 0) {
$id = abs($id);
}
if ($begin == 0) {
$theList = $id;
} else {
$theList = '';
}
if ($id && $depth > 0) {
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages');
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$statement = $queryBuilder->select('uid')
->from('pages')
->where(
$queryBuilder->expr()->eq('pid', $queryBuilder->createNamedParameter($id, \PDO::PARAM_INT)),
QueryHelper::stripLogicalOperatorPrefix($permsClause)
)
->execute();
while ($row = $statement->fetch()) {
if ($begin <= 0) {
$theList .= ',' . $row['uid'];
}
if ($depth > 1) {
$theList .= $this->getTreeList($row['uid'], $depth - 1, $begin - 1, $permsClause);
}
}
}
return $theList;
}
/**
* Make value list
*
* @param string $fieldName
* @param string $fieldValue
* @param array $conf
* @param string $table
* @param string $splitString
* @return string
*/
public function makeValueList($fieldName, $fieldValue, $conf, $table, $splitString)
{
$fieldSetup = $conf;
$out = '';
if ($fieldSetup['type'] === 'files') {
$d = dir(PATH_site . $fieldSetup['uploadfolder']);
while (false !== ($entry = $d->read())) {
if ($entry === '.' || $entry === '..') {
continue;
}
$fileArray[] = $entry;
}
$d->close();
natcasesort($fileArray);
foreach ($fileArray as $fileName) {
if (GeneralUtility::inList($fieldValue, $fileName) || $fieldValue == $fileName) {
if (!$out) {
$out = htmlspecialchars($fileName);
} else {
$out .= $splitString . htmlspecialchars($fileName);
}
}
}
}
if ($fieldSetup['type'] === 'multiple') {
foreach ($fieldSetup['items'] as $key => $val) {
if (substr($val[0], 0, 4) === 'LLL:') {
$value = $this->languageService->sL($val[0]);
} else {
$value = $val[0];
}
if (GeneralUtility::inList($fieldValue, $val[1]) || $fieldValue == $val[1]) {
if (!$out) {
$out = htmlspecialchars($value);
} else {
$out .= $splitString . htmlspecialchars($value);
}
}
}
}
if ($fieldSetup['type'] === 'binary') {
foreach ($fieldSetup['items'] as $Key => $val) {
if (substr($val[0], 0, 4) === 'LLL:') {
$value = $this->languageService->sL($val[0]);
} else {
$value = $val[0];
}
if (!$out) {
$out = htmlspecialchars($value);
} else {
$out .= $splitString . htmlspecialchars($value);
}
}
}
if ($fieldSetup['type'] === 'relation') {
$dontPrefixFirstTable = 0;
$useTablePrefix = 0;
if ($fieldSetup['items']) {
foreach ($fieldSetup['items'] as $key => $val) {
if (substr($val[0], 0, 4) === 'LLL:') {
$value = $this->languageService->sL($val[0]);
} else {
$value = $val[0];
}
if (GeneralUtility::inList($fieldValue, $value) || $fieldValue == $value) {
if (!$out) {
$out = htmlspecialchars($value);
} else {
$out .= $splitString . htmlspecialchars($value);
}
}
}
}
if (stristr($fieldSetup['allowed'], ',')) {
$from_table_Arr = explode(',', $fieldSetup['allowed']);
$useTablePrefix = 1;
if (!$fieldSetup['prepend_tname']) {
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($table);
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$statement = $queryBuilder->select($fieldName)->from($table)->execute();
while ($row = $statement->fetch()) {
if (stristr($row[$fieldName], ',')) {
$checkContent = explode(',', $row[$fieldName]);
foreach ($checkContent as $singleValue) {
if (!stristr($singleValue, '_')) {
$dontPrefixFirstTable = 1;
}
}
} else {
$singleValue = $row[$fieldName];
if ($singleValue !== '' && !stristr($singleValue, '_')) {
$dontPrefixFirstTable = 1;
}
}
}
}
} else {
$from_table_Arr[0] = $fieldSetup['allowed'];
}
if ($fieldSetup['prepend_tname']) {
$useTablePrefix = 1;
}
if ($fieldSetup['foreign_table']) {
$from_table_Arr[0] = $fieldSetup['foreign_table'];
}
$counter = 0;
$useSelectLabels = 0;
$useAltSelectLabels = 0;
$tablePrefix = '';
$labelFieldSelect = [];
foreach ($from_table_Arr as $from_table) {
if ($useTablePrefix && !$dontPrefixFirstTable && $counter != 1 || $counter == 1) {
$tablePrefix = $from_table . '_';
}
$counter = 1;
if (is_array($GLOBALS['TCA'][$from_table])) {
$labelField = $GLOBALS['TCA'][$from_table]['ctrl']['label'];
$altLabelField = $GLOBALS['TCA'][$from_table]['ctrl']['label_alt'];
if ($GLOBALS['TCA'][$from_table]['columns'][$labelField]['config']['items']) {
$items = $GLOBALS['TCA'][$from_table]['columns'][$labelField]['config']['items'];
foreach ($items as $labelArray) {
if (substr($labelArray[0], 0, 4) === 'LLL:') {
$labelFieldSelect[$labelArray[1]] = $this->languageService->sL($labelArray[0]);
} else {
$labelFieldSelect[$labelArray[1]] = $labelArray[0];
}
}
$useSelectLabels = 1;
}
$altLabelFieldSelect = [];
if ($GLOBALS['TCA'][$from_table]['columns'][$altLabelField]['config']['items']) {
$items = $GLOBALS['TCA'][$from_table]['columns'][$altLabelField]['config']['items'];
foreach ($items as $altLabelArray) {
if (substr($altLabelArray[0], 0, 4) === 'LLL:') {
$altLabelFieldSelect[$altLabelArray[1]] = $this->languageService->sL($altLabelArray[0]);
} else {
$altLabelFieldSelect[$altLabelArray[1]] = $altLabelArray[0];
}
}
$useAltSelectLabels = 1;
}
if (!$this->tableArray[$from_table]) {
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($from_table);
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
$selectFields = ['uid', $labelField];
if ($altLabelField) {
$selectFields[] = $altLabelField;
}
$queryBuilder->select(...$selectFields)
->from($from_table)
->orderBy('uid');
if (!$this->backendUserAuthentication->isAdmin() && $GLOBALS['TYPO3_CONF_VARS']['BE']['lockBeUserToDBmounts']) {
$webMounts = $this->backendUserAuthentication->returnWebmounts();
$perms_clause = $this->backendUserAuthentication->getPagePermsClause(Permission::PAGE_SHOW);
$webMountPageTree = '';
$webMountPageTreePrefix = '';
foreach ($webMounts as $webMount) {
if ($webMountPageTree) {
$webMountPageTreePrefix = ',';
}
$webMountPageTree .= $webMountPageTreePrefix
. $this->getTreeList($webMount, 999, ($begin = 0), $perms_clause);
}
if ($from_table === 'pages') {
$queryBuilder->where(
QueryHelper::stripLogicalOperatorPrefix($perms_clause),
$queryBuilder->expr()->in(
'uid',
$queryBuilder->createNamedParameter(
GeneralUtility::intExplode(',', $webMountPageTree),
Connection::PARAM_INT_ARRAY
)
)
);
} else {
$queryBuilder->where(
$queryBuilder->expr()->in(
'pid',
$queryBuilder->createNamedParameter(
GeneralUtility::intExplode(',', $webMountPageTree),
Connection::PARAM_INT_ARRAY
)
)
);
}
}
$statement = $queryBuilder->execute();
$this->tableArray[$from_table] = [];
while ($row = $statement->fetch()) {
$this->tableArray[$from_table][] = $row;
}
}
foreach ($this->tableArray[$from_table] as $key => $val) {
$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'] =
$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'] == 1
? 'on'
: $GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'];
$prefixString =
$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'] === 'on'
? ''
: ' [' . $tablePrefix . $val['uid'] . '] ';
if (GeneralUtility::inList($fieldValue, $tablePrefix . $val['uid'])
|| $fieldValue == $tablePrefix . $val['uid']) {
if ($useSelectLabels) {
if (!$out) {
$out = htmlspecialchars($prefixString . $labelFieldSelect[$val[$labelField]]);
} else {
$out .= $splitString . htmlspecialchars(
$prefixString . $labelFieldSelect[$val[$labelField]]
);
}
} elseif ($val[$labelField]) {
if (!$out) {
$out = htmlspecialchars($prefixString . $val[$labelField]);
} else {
$out .= $splitString . htmlspecialchars(
$prefixString . $val[$labelField]
);
}
} elseif ($useAltSelectLabels) {
if (!$out) {
$out = htmlspecialchars($prefixString . $altLabelFieldSelect[$val[$altLabelField]]);
} else {
$out .= $splitString . htmlspecialchars(
$prefixString . $altLabelFieldSelect[$val[$altLabelField]]
);
}
} else {
if (!$out) {
$out = htmlspecialchars($prefixString . $val[$altLabelField]);
} else {
$out .= $splitString . htmlspecialchars(($prefixString . $val[$altLabelField]));
}
}
}
}
}
}
}
return $out;
}
/**
* Render table header
*
* @param array $row Table columns
* @param array $conf Table TCA
* @param string $table Table name
* @return string HTML of table header
*/
public function resultRowTitles($row, $conf, $table)
{
$SET = $GLOBALS['SOBE']->MOD_SETTINGS;
$tableHeader = [];
// Start header row
$tableHeader[] = '';
// Iterate over given columns
foreach ($row as $fieldName => $fieldValue) {
if (GeneralUtility::inList($SET['queryFields'], $fieldName)
|| !$SET['queryFields']
&& $fieldName !== 'pid'
&& $fieldName !== 'deleted'
) {
if ($GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels']) {
$title = htmlspecialchars($this->languageService->sL($conf['columns'][$fieldName]['label']
? $conf['columns'][$fieldName]['label']
: $fieldName));
} else {
$title = htmlspecialchars($this->languageService->sL($fieldName));
}
$tableHeader[] = '| ' . $title . ' | ';
}
}
// Add empty icon column
$tableHeader[] = ' | ';
// Close header row
$tableHeader[] = '
';
return implode(LF, $tableHeader);
}
/**
* CSV row titles
*
* @param array $row
* @param array $conf
* @param mixed $table Not used
* @return string
*/
public function csvRowTitles($row, $conf, $table)
{
$out = '';
$SET = $GLOBALS['SOBE']->MOD_SETTINGS;
foreach ($row as $fieldName => $fieldValue) {
if (GeneralUtility::inList($SET['queryFields'], $fieldName)
|| !$SET['queryFields'] && $fieldName !== 'pid') {
if (!$out) {
if ($GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels']) {
$out = htmlspecialchars($this->languageService->sL($conf['columns'][$fieldName]['label']
? $conf['columns'][$fieldName]['label']
: $fieldName));
} else {
$out = htmlspecialchars($this->languageService->sL($fieldName));
}
} else {
if ($GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels']) {
$out .= ',' . htmlspecialchars($this->languageService->sL(($conf['columns'][$fieldName]['label']
? $conf['columns'][$fieldName]['label']
: $fieldName)));
} else {
$out .= ',' . htmlspecialchars($this->languageService->sL($fieldName));
}
}
}
}
return $out;
}
/**
* Sets the current name of the input form.
*
* @param string $formName The name of the form.
*/
public function setFormName($formName)
{
$this->formName = trim($formName);
}
}