12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 |
- <?php
- /**
- * @file
- * Definition of views_handler_filter_group_by_numeric.
- */
- /**
- * Simple filter to handle greater than/less than filters
- *
- * @ingroup views_filter_handlers
- */
- class views_handler_filter_group_by_numeric extends views_handler_filter_numeric {
- /**
- * {@inheritdoc}
- */
- public function query() {
- $this->ensure_my_table();
- $field = $this->get_field();
- $info = $this->operators();
- if (!empty($info[$this->operator]['method'])) {
- $this->{$info[$this->operator]['method']}($field);
- }
- }
- /**
- * {@inheritdoc}
- */
- public function op_between($field) {
- $placeholder_min = $this->placeholder();
- $placeholder_max = $this->placeholder();
- if ($this->operator == 'between') {
- $this->query->add_having_expression($this->options['group'], "$field >= $placeholder_min", array($placeholder_min => $this->value['min']));
- $this->query->add_having_expression($this->options['group'], "$field <= $placeholder_max", array($placeholder_max => $this->value['max']));
- }
- else {
- $this->query->add_having_expression($this->options['group'], "$field <= $placeholder_min OR $field >= $placeholder_max", array($placeholder_min => $this->value['min'], $placeholder_max => $this->value['max']));
- }
- }
- /**
- * {@inheritdoc}
- */
- public function op_simple($field) {
- $placeholder = $this->placeholder();
- $this->query->add_having_expression($this->options['group'], "$field $this->operator $placeholder", array($placeholder => $this->value['value']));
- }
- /**
- * {@inheritdoc}
- */
- public function op_empty($field) {
- if ($this->operator == 'empty') {
- $operator = "IS NULL";
- }
- else {
- $operator = "IS NOT NULL";
- }
- $this->query->add_having_expression($this->options['group'], "$field $operator");
- }
- /**
- * {@inheritdoc}
- */
- public function ui_name($short = FALSE) {
- return $this->get_field(parent::ui_name($short));
- }
- /**
- * {@inheritdoc}
- */
- public function can_group() {
- return FALSE;
- }
- }
|