modules/country_code/country_code_handler_filter_node_country.inc

<?php
// $Id: country_code_handler_filter_node_country.inc,v 1.10 2008/10/30 20:10:56 nedjo Exp $

/**
 * @file
 * Implementation of a views country filter for the country code module.
 */

/**
 * Filter by country.
 */
class country_code_handler_filter_node_country extends views_handler_filter_in_operator {

  function get_value_options() {
    if (!isset($this->value_options)) {
      $this->value_title = t('Country');
      $countries = array(
        '***COUNTRY_CODE***' => t("Current country"),
      );
      foreach (country_code_countries() as $code => $country) {
        $countries[$code] = $country->name;
      }
      $this->value_options = $countries;
    }
  }

  function query() {
    // If the current country code is global, we don't restrict content.
    if (empty($this->value) || in_array(COUNTRY_CODE_GLOBAL, $this->value)) {
      return;
    }

    $table = $this->ensure_my_table();
    $language_substrings = array();
    $options = array();
    foreach ($this->value as $value) {
      // The search strings include a dash(-), e.g., -ca, so we begin at the 3rd
      // character.
      $options[] = "SUBSTRING({$this->table_alias}.{$this->real_field}, 3) = '%s'";
      $language_substrings[] = '-' . $value;
    }

    $where = ' (' . implode(" OR ", $options) . ')';

    $this->query->add_where($this->options['group'], $where, $language_substrings);
  }

}
1	<?php
2	// $Id: country_code_handler_filter_node_country.inc,v 1.10 2008/10/30 20:10:56 nedjo Exp $
3
4	/**
5	* @file
6	* Implementation of a views country filter for the country code module.
7	*/
8
9	/**
10	* Filter by country.
11	*/
12	class country_code_handler_filter_node_country extends views_handler_filter_in_operator {
13
14	function get_value_options() {
15	if (!isset($this->value_options)) {
16	$this->value_title = t('Country');
17	$countries = array(
18	'*COUNTRY_CODE*' => t("Current country"),
19	);
20	foreach (country_code_countries() as $code => $country) {
21	$countries[$code] = $country->name;
22	}
23	$this->value_options = $countries;
24	}
25	}
26
27	function query() {
28	// If the current country code is global, we don't restrict content.
29	if (empty($this->value) \|\| in_array(COUNTRY_CODE_GLOBAL, $this->value)) {
30	return;
31	}
32
33	$table = $this->ensure_my_table();
34	$language_substrings = array();
35	$options = array();
36	foreach ($this->value as $value) {
37	// The search strings include a dash(-), e.g., -ca, so we begin at the 3rd
38	// character.
39	$options[] = "SUBSTRING({$this->table_alias}.{$this->real_field}, 3) = '%s'";
40	$language_substrings[] = '-' . $value;
41	}
42
43	$where = ' (' . implode(" OR ", $options) . ')';
44
45	$this->query->add_where($this->options['group'], $where, $language_substrings);
46	}
47
48	}