views_handler_filter_chado_boolean.inc

Go to the documentation of this file.

<?php

class views_handler_filter_chado_boolean extends views_handler_filter_boolean_operator {
  function init(&$view, $options) {
    parent::init($view, $options);

    $results = tripal_core_chado_select($this->table, array($this->field), array());
    $this->boolean_type_tf = FALSE;
    if (preg_match('/[tf]/', $results[0]->{$this->field})) {
      $this->boolean_type_tf = TRUE;
    }

  }

  function get_value_options() {

    if ($this->boolean_type_tf) {
      if (isset($this->definition['type'])) {
        if ($this->definition['type'] == 'yes-no') {
          $this->value_options = array('t' => t('Yes'), 'f' => t('No'));
        }
        if ($this->definition['type'] == 'on-off') {
          $this->value_options = array('t' => t('On'), 'f' => t('Off'));
        }
      }

      // Provide a fallback if the above didn't set anything.
      if (!isset($this->value_options)) {
        $this->value_options = array('t' => t('True'), 'f' => t('False'));
      }
    }
    else { //end of t/f boolean
      if (isset($this->definition['type'])) {
        if ($this->definition['type'] == 'yes-no') {
          $this->value_options = array(1 => t('Yes'), 0 => t('No'));
        }
        if ($this->definition['type'] == 'on-off') {
          $this->value_options = array(1 => t('On'), 0 => t('Off'));
        }
      }

      // Provide a fallback if the above didn't set anything.
      if (!isset($this->value_options)) {
        $this->value_options = array(1 => t('True'), 0 => t('False'));
      }
    } //end of 0/1 boolean
  }

  function query() {
    $this->ensure_my_table();

    $where = "$this->table_alias.$this->real_field ";

    if ($this->boolean_type_tf) {
      if (preg_match('/f/', $this->value)) {
        $where .= "= 'f'";
      }
      else {
        $where .= "= 't'";
      }
      $this->query->add_where($this->options['group'], $where);
    }
    else {
      if (empty($this->value)) {
        $where .= '= 0';
        if ($this->accept_null) {
          $where = '(' . $where . " OR $this->table_alias.$this->real_field IS NULL)";
        }
      }
      else {
        $where .= '<> 0';
      }
      $this->query->add_where($this->options['group'], $where);
    }
  }
}