class uc_views_attribute_handler_filter_attr in Ubercart Views 6.3
Filter by attributes - by justindodge
Hierarchy
- class \uc_views_attribute_handler_filter_attr extends \views_handler_filter_in_operator
Expanded class hierarchy of uc_views_attribute_handler_filter_attr
1 string reference to 'uc_views_attribute_handler_filter_attr'
- uc_views_attribute_views_data in uc_views_attribute/
views/ uc_views_attribute.views.inc - Implementation of hook_views_data().
File
- uc_views_attribute/
views/ uc_views_attribute_handler_filter_attr.inc, line 5
View source
class uc_views_attribute_handler_filter_attr extends views_handler_filter_in_operator {
function has_extra_options() {
return TRUE;
}
function option_definition() {
$options = parent::option_definition();
$options['type'] = array(
'default' => 'textfield',
);
return $options;
}
function get_value_options() {
if (!isset($this->value_options)) {
$aid = explode('_', $this->field);
$aid = $aid[1];
$this->value_title = t('Options');
$result = db_query("SELECT name, oid FROM {uc_attribute_options} WHERE aid = %d ORDER BY ordering", $aid);
while ($row = db_fetch_object($result)) {
$options[$row->oid] = $row->name;
}
if (count($options) == 0) {
$options[] = t('No options found.');
}
$this->value_options = $options;
}
}
function extra_options_form(&$form, &$form_state) {
$form['type'] = array(
'#type' => 'radios',
'#title' => t('Selection type'),
'#options' => array(
'select' => t('Checkboxes/Dropdown'),
'textfield' => t('Textfield'),
),
'#default_value' => $this->options['type'],
);
}
function value_form(&$form, &$form_state) {
parent::value_form($form, $form_state);
if ($this->options['type'] == 'textfield') {
$form['value'] = array(
'#type' => 'textfield',
'#title' => 'Text search',
);
}
}
function query() {
$aid = explode('_', $this->field);
$aid = $aid[1];
$key = db_result(db_query('SELECT name FROM {uc_attributes} WHERE aid = %d', $aid));
$this
->ensure_my_table();
$this->real_field = 'data';
$field = "{$this->table_alias}.{$this->real_field}";
$upper = '';
if ($this->operator == 'not in') {
$not = 'NOT';
}
if (!is_array($this->value)) {
$this->value = array(
$this->value,
);
}
foreach ($this->value as &$value) {
if ($this->options['type'] == 'textfield') {
$optval = $value;
}
else {
$optval = db_result(db_query('SELECT name FROM {uc_attribute_options} WHERE oid = %d', $value));
}
if (!$optval) {
//If we let the query get added, only products with the attribute enabled & with the value of that attribute empty
//will return. By default, I think it makes more sense to allow any product to return despite whether or not it
//has the attribute if the user put nothing in to search for.
//Adding a new type of filter that merely captures whether or not the attribute exists at all for the product may
//be the best way to capture the alternative. Or, perhaps a config option could be added to this filter :
//"Show products only if they have this attribute enabled". If this option is unchecked, a blank value returns all
//products. If checked, a blank value at least filters out products that dont have this attribute available.
continue;
}
$var = array(
$key => array(
0 => $optval,
),
);
$servar = serialize($var);
$l = strpos($servar, '{') + 1;
$r = strpos($servar, '}') - $l;
$value = substr($servar, $l, $r);
//@todo - this method of building the query does allow for partial text matching (i.e. 'foo' matches in 'foobar').
$this->query
->add_where($this->options['group'], "{$upper}(%s) {$not} LIKE {$upper}('%%%s%%')", $field, $value);
}
}
}