1 | <?php |
---|
2 | /** |
---|
3 | * @file |
---|
4 | * Contains the numeric argument handler. |
---|
5 | */ |
---|
6 | |
---|
7 | /** |
---|
8 | * Basic argument handler for arguments that are numeric. Incorporates |
---|
9 | * break_phrase. |
---|
10 | * |
---|
11 | * @ingroup views_argument_handlers |
---|
12 | */ |
---|
13 | class views_handler_argument_numeric extends views_handler_argument { |
---|
14 | function option_definition() { |
---|
15 | $options = parent::option_definition(); |
---|
16 | |
---|
17 | $options['break_phrase'] = array('default' => FALSE); |
---|
18 | $options['not'] = array('default' => FALSE); |
---|
19 | |
---|
20 | return $options; |
---|
21 | } |
---|
22 | |
---|
23 | function options_form(&$form, &$form_state) { |
---|
24 | parent::options_form($form, $form_state); |
---|
25 | |
---|
26 | // allow + for or, , for and |
---|
27 | $form['break_phrase'] = array( |
---|
28 | '#type' => 'checkbox', |
---|
29 | '#title' => t('Allow multiple terms per argument'), |
---|
30 | '#description' => t('If selected, users can enter multiple arguments in the form of 1+2+3 or 1,2,3.'), |
---|
31 | '#default_value' => !empty($this->options['break_phrase']), |
---|
32 | ); |
---|
33 | |
---|
34 | $form['not'] = array( |
---|
35 | '#type' => 'checkbox', |
---|
36 | '#title' => t('Exclude the argument'), |
---|
37 | '#description' => t('If selected, the numbers entered in the argument will be excluded rather than limiting the view.'), |
---|
38 | '#default_value' => !empty($this->options['not']), |
---|
39 | ); |
---|
40 | } |
---|
41 | |
---|
42 | function title() { |
---|
43 | if (!$this->argument) { |
---|
44 | return !empty($this->definition['empty field name']) ? $this->definition['empty field name'] : t('Uncategorized'); |
---|
45 | } |
---|
46 | |
---|
47 | if (!empty($this->options['break_phrase'])) { |
---|
48 | views_break_phrase($this->argument, $this); |
---|
49 | } |
---|
50 | else { |
---|
51 | $this->value = array($this->argument); |
---|
52 | $this->operator = 'or'; |
---|
53 | } |
---|
54 | |
---|
55 | if (empty($this->value)) { |
---|
56 | return !empty($this->definition['empty field name']) ? $this->definition['empty field name'] : t('Uncategorized'); |
---|
57 | } |
---|
58 | |
---|
59 | if ($this->value === array(-1)) { |
---|
60 | return !empty($this->definition['invalid input']) ? $this->definition['invalid input'] : t('Invalid input'); |
---|
61 | } |
---|
62 | |
---|
63 | return implode($this->operator == 'or' ? ' + ' : ', ', $this->title_query()); |
---|
64 | } |
---|
65 | |
---|
66 | /** |
---|
67 | * Override for specific title lookups. |
---|
68 | */ |
---|
69 | function title_query() { |
---|
70 | return $this->value; |
---|
71 | } |
---|
72 | |
---|
73 | function query() { |
---|
74 | $this->ensure_my_table(); |
---|
75 | |
---|
76 | if (!empty($this->options['break_phrase'])) { |
---|
77 | views_break_phrase($this->argument, $this); |
---|
78 | } |
---|
79 | else { |
---|
80 | $this->value = array($this->argument); |
---|
81 | } |
---|
82 | |
---|
83 | $null_check = empty($this->options['not']) ? '' : " OR $this->table_alias.$this->real_field IS NULL"; |
---|
84 | |
---|
85 | if (count($this->value) > 1) { |
---|
86 | $operator = empty($this->options['not']) ? 'IN' : 'NOT IN'; |
---|
87 | $placeholders = implode(', ', array_fill(0, sizeof($this->value), '%d')); |
---|
88 | $this->query->add_where(0, "$this->table_alias.$this->real_field $operator ($placeholders) $null_check", $this->value); |
---|
89 | } |
---|
90 | else { |
---|
91 | $operator = empty($this->options['not']) ? '=' : '!='; |
---|
92 | $this->query->add_where(0, "$this->table_alias.$this->real_field $operator %d $null_check", $this->argument); |
---|
93 | } |
---|
94 | } |
---|
95 | } |
---|