/** * Returns the condition to be used with SQL where * @param array $data filter settings * @return string the filtering condition or null if the filter is disabled */ function get_sql_filter($data) { if ($data['value'] === 0) { return 'TRUE'; } return parent::get_sql_filter($data); }
/** * Returns the condition to be used with SQL where * @param array $data filter settings * @return array the filtering condition with optional parameters * or null if the filter is disabled */ function get_sql_filter($data) { if ($data['value'] === 0) { return array('TRUE', array()); } return parent::get_sql_filter($data); }
/** * Returns the condition to be used with SQL where * @uses $CFG * @param array $data filter settings * @return string the filtering condition or null if the filter is disabled */ function get_sql_filter($data) { global $CFG; $sql = parent::get_sql_filter($data); $full_fieldname = $this->get_full_fieldname(); if (empty($full_fieldname)) { return null; } $sql = "{$this->_outerfield} IN " . " (SELECT {$this->_innerfield}" . ' FROM ' . $CFG->prefix . $this->_table . ' ' . $this->_alias . $this->_wrapper . ' WHERE ' . $sql . ')'; return $sql; }