ContextualRangeFilter.php in Views Contextual Range Filter 8
File
src/ContextualRangeFilter.php
View source
<?php
namespace Drupal\contextual_range_filter;
class ContextualRangeFilter {
const CONTEXTUAL_RANGE_FILTER_SEPARATOR1 = '--';
const CONTEXTUAL_RANGE_FILTER_SEPARATOR2 = ':';
private static function split($range) {
if (is_array($range)) {
$range = reset($range);
}
$range = trim($range);
$from_to = explode(self::CONTEXTUAL_RANGE_FILTER_SEPARATOR1, $range);
if (count($from_to) < 2) {
$from_to = explode(self::CONTEXTUAL_RANGE_FILTER_SEPARATOR2, $range);
}
return count($from_to) == 1 ? [
reset($from_to),
FALSE,
] : $from_to;
}
public static function buildRangeQuery($views_argument_plugin, $field = NULL, $range_converter = NULL) {
if (!isset($views_argument_plugin) || $views_argument_plugin->value === FALSE) {
return;
}
$real_field = $views_argument_plugin->realField;
if (!isset($field)) {
$field = "{$views_argument_plugin->tableAlias}.{$real_field}";
}
$is_not = !empty($views_argument_plugin->options['not']);
$null_check = $is_not ? "OR {$field} IS NULL" : '';
$group = $views_argument_plugin->query
->setWhereGroup($is_not ? 'AND' : 'OR');
foreach ($views_argument_plugin->value as $range) {
$placeholder = $views_argument_plugin->query
->placeholder($real_field);
list($from, $to) = self::split($range);
if (is_callable($range_converter)) {
list($from, $to) = call_user_func($range_converter, $from, $to);
}
if ($to === FALSE) {
$operator = $is_not ? '!=' : '=';
$views_argument_plugin->query
->addWhereExpression($group, "{$field} {$operator} {$placeholder} {$null_check}", [
$placeholder => $range,
]);
}
elseif ($from != '' && $to != '') {
$operator = $is_not ? 'NOT BETWEEN' : 'BETWEEN';
$placeholder_from = $placeholder;
$placeholder_to = $views_argument_plugin->query
->placeholder($real_field);
$args = [
$placeholder_from => $from,
$placeholder_to => $to,
];
$expression = "{$field} {$operator} {$placeholder_from} AND {$placeholder_to} {$null_check}";
$views_argument_plugin->query
->addWhereExpression($group, $expression, $args);
}
elseif ($from != '') {
$operator = $is_not ? '<' : '>=';
$views_argument_plugin->query
->addWhereExpression($group, "{$field} {$operator} {$placeholder} {$null_check}", [
$placeholder => $from,
]);
}
elseif ($to != '') {
$operator = $is_not ? '>' : '<=';
$views_argument_plugin->query
->addWhereExpression($group, "{$field} {$operator} {$placeholder} {$null_check}", [
$placeholder => $to,
]);
}
}
}
}