Bug #20529 » bug_11220_2.diff
| class.tslib_content.php Sat May 30 16:26:44 2009 | ||
|---|---|---|
|
* @see CONTENT(), numRows()
|
||
|
* @link http://typo3.org/doc.0.html?&tx_extrepmgm_pi1[extUid]=270&tx_extrepmgm_pi1[tocEl]=318&cHash=a98cb4e7e6
|
||
|
*/
|
||
|
function getQuery($table, $conf, $returnQueryArray=FALSE) {
|
||
|
|
||
|
// Construct WHERE clause:
|
||
|
$conf['pidInList'] = trim($this->stdWrap($conf['pidInList'],$conf['pidInList.']));
|
||
|
function getQuery($table, $conf, $returnQueryArray=FALSE) {
|
||
|
|
||
|
// All Values of $conf can be parsed through stdWrap
|
||
|
// The Values ('pidInList','uidInList','recursive','languageField') are stdWrap_ped by
|
||
|
// default while real datatype is unimportant (string, integer)
|
||
|
// Most SQL-Devices may optionally stdWrap_ped too ('where','groupBy','orderBy','join','leftjoin','rightjoin')
|
||
|
// To avoid potentially misbehaviors all SQL-Parameters and "min" and "begin" explicitly have to be noted with keyword stdWrap
|
||
|
// min., and begin. are parsed through calc, which is incompatible to prioCalc of stdWrap
|
||
|
// but stdWrap can be choosen by min.stdWrap and accordingly begin.stdWrap
|
||
|
// Values which must not be stdWrap_ped:
|
||
|
// - andWhere is stdWrap_ped anyway in function getWhere()
|
||
|
// changing this extra-handling is only possible by flag because of backward-compatibility
|
||
|
// Due to new Configuration-Options it's in responsibility of the TypoScript-Author that results are correct
|
||
|
// and Automatism can be switched off or overriden a bit more
|
||
|
|
||
|
$stdWrapAllowedValues = Array('pidInList.','uidInList.','recursive.','languageField.');
|
||
|
$stdWrapOptionalValues = Array('begin.','min.','selectFields.','where.','groupBy.','orderBy.','join.','leftjoin.','rightjoin.');
|
||
|
$doNotstdWrap = Array('andWhere.');
|
||
|
$config = Array();
|
||
|
foreach ($conf as $k => $v) {
|
||
|
if (!in_array($k,$doNotstdWrap) && !in_array($k.'.',$doNotstdWrap)) {
|
||
|
$r = '';
|
||
|
preg_match('/(.*?)(\.)?$/',$k,$r);
|
||
|
if (in_array($k,$stdWrapAllowedValues) || in_array($k.'.',$stdWrapAllowedValues)) {
|
||
|
// $conf['uidInList'] = trim($this->stdWrap($conf['uidInList'],$conf['uidInList.']));
|
||
|
$config[ $r[1] ] = trim($this->stdWrap($conf[ $r[1] ],$conf[ $k ]));
|
||
|
}
|
||
|
if (!strcmp($conf[$k]['stdWrap'],'') && (in_array($k.'.',$stdWrapOptionalValues) || in_array($k,$stdWrapOptionalValues))) {
|
||
|
$conf[ $r[1] ] = trim($this->stdWrap($conf[ $r[1] ]['stdWrap.'],$conf[ $k ]['stdWrap']));
|
||
|
}
|
||
|
elseif (!strcmp($conf[$k]['stdWrap'],'') && (!in_array($k.'.',$stdWrapOptionalValues) && !in_array($k,$stdWrapOptionalValues))) {
|
||
|
$config[ $r[1] ] = $conf[ $k ];
|
||
|
}
|
||
|
}
|
||
|
if (!isset($config[ $k ])) $config[ $k ] = $conf[ $k ];
|
||
|
}
|
||
|
|
||
|
// Handle recursive function for the pidInList
|
||
|
if (isset($conf['recursive'])) {
|
||
|
$conf['recursive'] = intval($conf['recursive']);
|
||
|
if ($conf['recursive'] > 0) {
|
||
|
foreach (explode(',', $conf['pidInList']) as $value) {
|
||
|
$pidList .= $value . ',' . $this->getTreeList($value, $conf['recursive']);
|
||
|
if (isset($config['recursive'])) {
|
||
|
$config['recursive'] = intval($config['recursive']);
|
||
|
if ($config['recursive'] > 0) {
|
||
|
foreach (explode(',', $config['pidInList']) as $value) {
|
||
|
$pidList .= $value . ',' . $this->getTreeList($value, $config['recursive']);
|
||
|
}
|
||
|
$conf['pidInList'] = trim($pidList, ',');
|
||
|
$config['pidInList'] = trim($pidList, ',');
|
||
|
}
|
||
|
}
|
||
|
|
||
|
if (!strcmp($conf['pidInList'],'')) {
|
||
|
$conf['pidInList'] = 'this';
|
||
|
// $conf['pidInList']['dontSetPid'] is set as new Option that avoids that
|
||
|
// an empty $conf['pidInList'] is filled with 'this' (= current pid)
|
||
|
if (!strcmp($config['pidInList'],'') && !$config['pidInList']['dontSetPid']) {
|
||
|
$config['pidInList'] = 'this';
|
||
|
}
|
||
|
$queryParts = $this->getWhere($table,$conf,TRUE);
|
||
|
$queryParts = $this->getWhere($table,$config,TRUE);
|
||
|
|
||
|
// Fields:
|
||
|
$queryParts['SELECT'] = $conf['selectFields'] ? $conf['selectFields'] : '*';
|
||
|
$queryParts['SELECT'] = $config['selectFields'] ? $config['selectFields'] : '*';
|
||
|
|
||
|
// Setting LIMIT:
|
||
|
if ($conf['max'] || $conf['begin']) {
|
||
|
if ($config['max'] || $config['begin']) {
|
||
|
$error=0;
|
||
|
|
||
|
// Finding the total number of records, if used:
|
||
|
if (strstr(strtolower($conf['begin'].$conf['max']),'total')) {
|
||
|
if (strstr(strtolower($config['begin'].$config['max']),'total')) {
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*)', $table, $queryParts['WHERE'], $queryParts['GROUPBY']);
|
||
|
if ($error = $GLOBALS['TYPO3_DB']->sql_error()) {
|
||
|
$GLOBALS['TT']->setTSlogMessage($error);
|
||
|
} else {
|
||
|
$row = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
|
||
|
$conf['max'] = str_ireplace('total', $row[0], $conf['max']);
|
||
|
$conf['begin'] = str_ireplace('total', $row[0], $conf['begin']);
|
||
|
$config['max'] = str_ireplace('total', $row[0], $config['max']);
|
||
|
$config['begin'] = str_ireplace('total', $row[0], $config['begin']);
|
||
|
}
|
||
|
$GLOBALS['TYPO3_DB']->sql_free_result($res);
|
||
|
}
|
||
|
if (!$error) {
|
||
|
$conf['begin'] = t3lib_div::intInRange(ceil($this->calc($conf['begin'])),0);
|
||
|
$conf['max'] = t3lib_div::intInRange(ceil($this->calc($conf['max'])),0);
|
||
|
if ($conf['begin'] && !$conf['max']) {
|
||
|
$conf['max'] = 100000;
|
||
|
// If ..[stdWrap] calculation by calc has to be avoided because it's incompatible with stdWrap-option prioCalc
|
||
|
$config['begin'] = (!$config['begin']['stdWrap']) ? t3lib_div::intInRange(ceil($this->calc($config['begin'])),0) : $config['begin'];
|
||
|
$config['max'] = (!$config['max']['stdWrap']) ? t3lib_div::intInRange(ceil($this->calc($config['max'])),0) : $config['max'];
|
||
|
if ($config['begin'] && !$config['max']) {
|
||
|
$config['max'] = 100000;
|
||
|
}
|
||
|
|
||
|
if ($conf['begin'] && $conf['max']) {
|
||
|
$queryParts['LIMIT'] = $conf['begin'].','.$conf['max'];
|
||
|
} elseif (!$conf['begin'] && $conf['max']) {
|
||
|
$queryParts['LIMIT'] = $conf['max'];
|
||
|
if ($config['begin'] && $config['max']) {
|
||
|
$queryParts['LIMIT'] = $config['begin'].','.$config['max'];
|
||
|
} elseif (!$config['begin'] && $config['max']) {
|
||
|
$queryParts['LIMIT'] = $config['max'];
|
||
|
}
|
||
|
}
|
||
|
}
|
||
|
|
||
|
|
||
|
if (!$error) {
|
||
|
|
||
|
|
||
|
// Setting up tablejoins:
|
||
|
$joinPart='';
|
||
|
if ($conf['join']) {
|
||
|
$joinPart = 'JOIN ' .trim($conf['join']);
|
||
|
} elseif ($conf['leftjoin']) {
|
||
|
$joinPart = 'LEFT OUTER JOIN ' .trim($conf['leftjoin']);
|
||
|
} elseif ($conf['rightjoin']) {
|
||
|
$joinPart = 'RIGHT OUTER JOIN ' .trim($conf['rightjoin']);
|
||
|
if ($config['join']) {
|
||
|
$joinPart = 'JOIN ' .trim($config['join']);
|
||
|
} elseif ($config['leftjoin']) {
|
||
|
$joinPart = 'LEFT OUTER JOIN ' .trim($config['leftjoin']);
|
||
|
} elseif ($config['rightjoin']) {
|
||
|
$joinPart = 'RIGHT OUTER JOIN ' .trim($config['rightjoin']);
|
||
|
}
|
||
|
|
||
|
|
||
|
// Compile and return query:
|
||
|
$queryParts['FROM'] = trim($table.' '.$joinPart);
|
||
|
$query = $GLOBALS['TYPO3_DB']->SELECTquery(
|
||
| ... | ... | |
|
$queryParts['ORDERBY'],
|
||
|
$queryParts['LIMIT']
|
||
|
);
|
||
|
|
||
|
return $returnQueryArray ? $queryParts : $query;
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
}
|
||
|
$query.=' AND '.$conf['languageField'].' IN ('.$sys_language_content.')';
|
||
|
}
|
||
|
|
||
|
$andWhere = trim($this->stdWrap($conf['andWhere'],$conf['andWhere.']));
|
||
|
|
||
|
if ($conf['andWhere'] && strtolower($conf['andWhere']['stdWrap']) != 'false') {
|
||
|
$andWhere = trim($this->stdWrap($conf['andWhere'],$conf['andWhere.']));
|
||
|
}
|
||
|
else $andWhere = $conf['andWhere'];
|
||
|
if ($andWhere) {
|
||
|
$query.=' AND '.$andWhere;
|
||
|
}
|
||