1 |
85ad3d82
|
Assos Assos
|
<?php
|
2 |
|
|
|
3 |
|
|
/**
|
4 |
|
|
* @file
|
5 |
|
|
* Definition of views_handler_filter_boolean_operator.
|
6 |
|
|
*/
|
7 |
|
|
|
8 |
|
|
/**
|
9 |
|
|
* Simple filter to handle matching of boolean values
|
10 |
|
|
*
|
11 |
|
|
* Definition items:
|
12 |
|
|
* - label: (REQUIRED) The label for the checkbox.
|
13 |
|
|
* - type: For basic 'true false' types, an item can specify the following:
|
14 |
|
|
* - true-false: True/false (this is the default)
|
15 |
|
|
* - yes-no: Yes/No
|
16 |
|
|
* - on-off: On/Off
|
17 |
|
|
* - enabled-disabled: Enabled/Disabled
|
18 |
|
|
* - accept null: Treat a NULL value as false.
|
19 |
|
|
* - use equal: If you use this flag the query will use = 1 instead of <> 0.
|
20 |
|
|
* This might be helpful for performance reasons.
|
21 |
|
|
*
|
22 |
|
|
* @ingroup views_filter_handlers
|
23 |
|
|
*/
|
24 |
|
|
class views_handler_filter_boolean_operator extends views_handler_filter {
|
25 |
|
|
// exposed filter options
|
26 |
|
|
var $always_multiple = TRUE;
|
27 |
|
|
// Don't display empty space where the operator would be.
|
28 |
|
|
var $no_operator = TRUE;
|
29 |
|
|
// Whether to accept NULL as a false value or not
|
30 |
|
|
var $accept_null = FALSE;
|
31 |
|
|
|
32 |
|
|
function construct() {
|
33 |
|
|
$this->value_value = t('True');
|
34 |
|
|
if (isset($this->definition['label'])) {
|
35 |
|
|
$this->value_value = $this->definition['label'];
|
36 |
|
|
}
|
37 |
|
|
if (isset($this->definition['accept null'])) {
|
38 |
|
|
$this->accept_null = (bool) $this->definition['accept null'];
|
39 |
|
|
}
|
40 |
|
|
else if (isset($this->definition['accept_null'])) {
|
41 |
|
|
$this->accept_null = (bool) $this->definition['accept_null'];
|
42 |
|
|
}
|
43 |
|
|
$this->value_options = NULL;
|
44 |
|
|
parent::construct();
|
45 |
|
|
}
|
46 |
|
|
|
47 |
|
|
/**
|
48 |
|
|
* Return the possible options for this filter.
|
49 |
|
|
*
|
50 |
|
|
* Child classes should override this function to set the possible values
|
51 |
|
|
* for the filter. Since this is a boolean filter, the array should have
|
52 |
|
|
* two possible keys: 1 for "True" and 0 for "False", although the labels
|
53 |
|
|
* can be whatever makes sense for the filter. These values are used for
|
54 |
|
|
* configuring the filter, when the filter is exposed, and in the admin
|
55 |
|
|
* summary of the filter. Normally, this should be static data, but if it's
|
56 |
|
|
* dynamic for some reason, child classes should use a guard to reduce
|
57 |
|
|
* database hits as much as possible.
|
58 |
|
|
*/
|
59 |
|
|
function get_value_options() {
|
60 |
|
|
if (isset($this->definition['type'])) {
|
61 |
|
|
if ($this->definition['type'] == 'yes-no') {
|
62 |
|
|
$this->value_options = array(1 => t('Yes'), 0 => t('No'));
|
63 |
|
|
}
|
64 |
|
|
if ($this->definition['type'] == 'on-off') {
|
65 |
|
|
$this->value_options = array(1 => t('On'), 0 => t('Off'));
|
66 |
|
|
}
|
67 |
|
|
if ($this->definition['type'] == 'enabled-disabled') {
|
68 |
|
|
$this->value_options = array(1 => t('Enabled'), 0 => t('Disabled'));
|
69 |
|
|
}
|
70 |
|
|
}
|
71 |
|
|
|
72 |
|
|
// Provide a fallback if the above didn't set anything.
|
73 |
|
|
if (!isset($this->value_options)) {
|
74 |
|
|
$this->value_options = array(1 => t('True'), 0 => t('False'));
|
75 |
|
|
}
|
76 |
|
|
}
|
77 |
|
|
|
78 |
|
|
function option_definition() {
|
79 |
|
|
$options = parent::option_definition();
|
80 |
|
|
|
81 |
|
|
$options['value']['default'] = FALSE;
|
82 |
|
|
|
83 |
|
|
return $options;
|
84 |
|
|
}
|
85 |
|
|
|
86 |
|
|
function operator_form(&$form, &$form_state) {
|
87 |
|
|
$form['operator'] = array();
|
88 |
|
|
}
|
89 |
|
|
|
90 |
|
|
function value_form(&$form, &$form_state) {
|
91 |
|
|
if (empty($this->value_options)) {
|
92 |
|
|
// Initialize the array of possible values for this filter.
|
93 |
|
|
$this->get_value_options();
|
94 |
|
|
}
|
95 |
|
|
if (!empty($form_state['exposed'])) {
|
96 |
|
|
// Exposed filter: use a select box to save space.
|
97 |
|
|
$filter_form_type = 'select';
|
98 |
|
|
}
|
99 |
|
|
else {
|
100 |
|
|
// Configuring a filter: use radios for clarity.
|
101 |
|
|
$filter_form_type = 'radios';
|
102 |
|
|
}
|
103 |
|
|
$form['value'] = array(
|
104 |
|
|
'#type' => $filter_form_type,
|
105 |
|
|
'#title' => $this->value_value,
|
106 |
|
|
'#options' => $this->value_options,
|
107 |
|
|
'#default_value' => $this->value,
|
108 |
|
|
);
|
109 |
|
|
if (!empty($this->options['exposed'])) {
|
110 |
|
|
$identifier = $this->options['expose']['identifier'];
|
111 |
|
|
if (!empty($form_state['exposed']) && !isset($form_state['input'][$identifier])) {
|
112 |
|
|
$form_state['input'][$identifier] = $this->value;
|
113 |
|
|
}
|
114 |
|
|
// If we're configuring an exposed filter, add an <Any> option.
|
115 |
|
|
if (empty($form_state['exposed']) || empty($this->options['expose']['required'])) {
|
116 |
|
|
$any_label = variable_get('views_exposed_filter_any_label', 'new_any') == 'old_any' ? '<Any>' : t('- Any -');
|
117 |
|
|
if ($form['value']['#type'] != 'select') {
|
118 |
|
|
$any_label = check_plain($any_label);
|
119 |
|
|
}
|
120 |
|
|
$form['value']['#options'] = array('All' => $any_label) + $form['value']['#options'];
|
121 |
|
|
}
|
122 |
|
|
}
|
123 |
|
|
}
|
124 |
|
|
|
125 |
|
|
function value_validate($form, &$form_state) {
|
126 |
|
|
if ($form_state['values']['options']['value'] == 'All' && !empty($form_state['values']['options']['expose']['required'])) {
|
127 |
|
|
form_set_error('value', t('You must select a value unless this is an non-required exposed filter.'));
|
128 |
|
|
}
|
129 |
|
|
}
|
130 |
|
|
|
131 |
|
|
function admin_summary() {
|
132 |
|
|
if ($this->is_a_group()) {
|
133 |
|
|
return t('grouped');
|
134 |
|
|
}
|
135 |
|
|
if (!empty($this->options['exposed'])) {
|
136 |
|
|
return t('exposed');
|
137 |
|
|
}
|
138 |
|
|
if (empty($this->value_options)) {
|
139 |
|
|
$this->get_value_options();
|
140 |
|
|
}
|
141 |
|
|
// Now that we have the valid options for this filter, just return the
|
142 |
|
|
// human-readable label based on the current value. The value_options
|
143 |
|
|
// array is keyed with either 0 or 1, so if the current value is not
|
144 |
|
|
// empty, use the label for 1, and if it's empty, use the label for 0.
|
145 |
|
|
return $this->value_options[!empty($this->value)];
|
146 |
|
|
}
|
147 |
|
|
|
148 |
|
|
function expose_options() {
|
149 |
|
|
parent::expose_options();
|
150 |
|
|
$this->options['expose']['operator_id'] = '';
|
151 |
|
|
$this->options['expose']['label'] = $this->value_value;
|
152 |
|
|
$this->options['expose']['required'] = TRUE;
|
153 |
|
|
}
|
154 |
|
|
|
155 |
|
|
function query() {
|
156 |
|
|
$this->ensure_my_table();
|
157 |
|
|
$field = "$this->table_alias.$this->real_field";
|
158 |
|
|
|
159 |
|
|
if (empty($this->value)) {
|
160 |
|
|
if ($this->accept_null) {
|
161 |
|
|
$or = db_or()
|
162 |
|
|
->condition($field, 0, '=')
|
163 |
|
|
->condition($field, NULL, 'IS NULL');
|
164 |
|
|
$this->query->add_where($this->options['group'], $or);
|
165 |
|
|
}
|
166 |
|
|
else {
|
167 |
|
|
$this->query->add_where($this->options['group'], $field, 0, '=');
|
168 |
|
|
}
|
169 |
|
|
}
|
170 |
|
|
else {
|
171 |
|
|
if (!empty($this->definition['use equal'])) {
|
172 |
|
|
$this->query->add_where($this->options['group'], $field, 1, '=');
|
173 |
|
|
}
|
174 |
|
|
else {
|
175 |
|
|
$this->query->add_where($this->options['group'], $field, 0, '<>');
|
176 |
|
|
}
|
177 |
|
|
}
|
178 |
|
|
}
|
179 |
|
|
} |