/**
* Build the filter query for the given element.
* Can be overwritten in plugin - e.g. see checkbox element which checks for partial matches
*
* @param string $key element name in format `tablename`.`elementname`
* @param string $condition =/like etc
* @param string $label search string - already quoted if specified in filter array options
* @param string $originalValue original filter value without quotes or %'s applied
* @param string $type filter type advanced/normal/prefilter/search/querystring/searchall
*
* @return string sql query part e,g, "key = value"
*/
public function getFilterQuery($key, $condition, $label, $originalValue, $type = 'normal')
{
$value = $label;
$db = JFactory::getDbo();
if ($type == 'searchall') {
// $$$ hugh - (sometimes?) $label is already quoted, which is causing havoc ...
$values = $this->replaceLabelWithValue(trim($label, "'"));
if (empty($values)) {
$value = '';
} else {
$value = $values[0];
}
if ($value == '') {
$value = $label;
}
if (!preg_match('#^\'.*\'$#', $value)) {
$value = $db->quote($value);
}
}
$this->encryptFieldName($key);
$params = $this->getParams();
if ($params->get('multiple')) {
$originalValue = trim($value, "'");
/*
* JSON stored values will back slash "/". So wwe need to add "\\\\"
* before it to escape it for the query.
*/
$originalValue = str_replace("/", "\\\\/", $originalValue);
$where1 = '["' . $originalValue . '",%';
$where2 = '%,"' . $originalValue . '",%';
$where3 = '%,"' . $originalValue . '"]';
$str = "({$key} {$condition} {$value} " . " OR {$key} LIKE " . $db->quote('["' . $originalValue . '"%') . " OR {$key} LIKE " . $db->quote('%"' . $originalValue . '"%') . " OR {$key} LIKE " . $db->quote('%"' . $originalValue . '"]') . ")";
return $str;
} else {
return parent::getFilterQuery($key, $condition, $value, $originalValue, $type);
}
}
/**
* build the filter query for the given element.
* @param $key element name in format `tablename`.`elementname`
* @param $condition =/like etc
* @param $value search string - already quoted if specified in filter array options
* @param $originalValue - original filter value without quotes or %'s applied
* @param string filter type advanced/normal/prefilter/search/querystring/searchall
* @return string sql query part e,g, "key = value"
*/
function getFilterQuery($key, $condition, $label, $originalValue, $type = 'normal')
{
$value = $label;
if ($type == 'searchall') {
// $$$ hugh - (sometimes?) $label is already quoted, which is causing havoc ...
$db = JFactory::getDbo();
$values = $this->replaceLabelWithValue(trim($label, "'"));
if (empty($values)) {
$value = '';
} else {
$value = $values[0];
}
if ($value == '') {
$value = $label;
}
if (!preg_match('#^\'.*\'$#', $value)) {
$value = $db->Quote($value);
}
}
$this->encryptFieldName($key);
$params =& $this->getParams();
if ($params->get('multiple')) {
$originalValue = trim($value, "'");
return " ({$key} {$condition} {$value} OR {$key} LIKE \"{$originalValue}',%\"" . " OR {$key} LIKE \"%:'{$originalValue}',%\"" . " OR {$key} LIKE \"%:'{$originalValue}'\"" . " )";
} else {
return parent::getFilterQuery($key, $condition, $value, $originalValue, $type);
}
}
/**
* build the filter query for the given element.
* @param $key element name in format `tablename`.`elementname`
* @param $condition =/like etc
* @param $value search string - already quoted if specified in filter array options
* @param $originalValue - original filter value without quotes or %'s applied
* @param string filter type advanced/normal/prefilter/search/querystring/searchall
* @return string sql query part e,g, "key = value"
*/
function getFilterQuery($key, $condition, $label, $originalValue, $type = 'normal')
{
$value = $label;
if ($type == 'searchall') {
// $$$ hugh - (sometimes?) $label is already quoted, which is causing havoc ...
$db = JFactory::getDbo();
$values = $this->replaceLabelWithValue(trim($label, "'"));
if (empty($values)) {
$value = '';
} else {
$value = $values[0];
}
if ($value == '') {
$value = $label;
}
if (!preg_match('#^\'.*\'$#', $value)) {
$value = $db->Quote($value);
}
}
$this->encryptFieldName($key);
$params = $this->getParams();
if ($params->get('multiple')) {
$originalValue = trim($value, "'");
$where1 = '["' . $originalValue . '",%';
$where2 = '%,"' . $originalValue . '",%';
$where3 = '%,"' . $originalValue . '"]';
return ' (' . $key . ' ' . $condition . ' ' . $value . ' OR ' . $key . ' LIKE \'' . $where1 . '\' OR ' . $key . ' LIKE \'' . $where2 . '\' OR ' . $key . ' LIKE \'' . $where3 . '\' )';
} else {
return parent::getFilterQuery($key, $condition, $value, $originalValue, $type);
}
}
