source: sipes/0.3-modules/ente_planificador_sector/includes/views/views_handler_filter_ente_organismo.inc @ 303fae2

<?php

  /**
  *
  * Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana
  * @file handler_field_ente_organismo_publ.inc
  * Drupal part Module to install ente planificador module
  * Copyright 2011 Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana (CENDITEL)
  *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version.
  * 
  * This program is distributed in the hope that it will be useful,
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
  * 
  * You should have received a copy of the GNU General Public License
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
  *
  * Probado con un servidor Apache 2.0,
  * Postgresql version 7.4.7 y 8.1 mysql 5.0.32 y PHP version 4.3.11 y 5.2.0-8
  *
  * @author Cenditel Merida - Ing. Jose Puentes
  * @date 2014-11-19 // (a&#241;o-mes-dia)
  * @version 0.2 // (0.1)
  *
  */

/**
 * Generar filtro por organismo Prublico en views
 */
class views_handler_filter_ente_organismo extends views_handler_filter_many_to_one {
  function get_value_options() { }
  function value_form(&$form, &$form_state) {
    global $user;
    //$ente_planificador = node_load($user->entes);
    $options[0] = "Seleccione";
    $nivel = 2;
    $result = db_query("SELECT n.nid, n.title FROM {node} AS n INNER JOIN {ente_planificador_hierarchical} AS e ON n.nid = e.nid WHERE level = %d", $nivel);
    while ($row = db_fetch_object($result)) {
      $options[$row->nid] = $row->title;
    }
    $form['value']['organismo'] = array(
      '#type' =>'select',
      '#options' => $options,
    );
  }

  /**
   * Provide the basic form which calls through to subforms.
   * If overridden, it is best to call through to the parent,
   * or to at least make sure all of the functions in this form
   * are called.
   */
  function options_form(&$form, &$form_state) {
    if ($this->can_expose()) {
      $this->show_expose_button($form, $form_state);
    }
    $form['op_val_start'] = array('#value' => '<div class="clear-block">');
    $this->show_operator_form($form, $form_state);
    $this->show_value_form($form, $form_state);
    $this->value_submit($form, $form_state);
    $form['op_val_end'] = array('#value' => '</div>');
    if ($this->can_expose()) {
      $this->show_expose_form($form, $form_state);
    }
    //excluyendo el campo
    if ($this->options['exposed'] == 1) {
      $roles = user_roles();
      $form['fieldset_roles'] = array(
        '#type' => 'fieldset',
        '#title' => t('Excluir Filtros'),
        '#weight' => 0,
      ); 
      $form['fieldset_roles']['roles_exclude_organismo'] = array(
        '#type' => 'checkboxes',
        '#weight' => 0,
        '#title' => t('Excluir Filtros por roles de la Presentacion'),
        '#options' => $roles,
        '#default_value' => variable_get('roles_exclude_organismo', 0),
        '#description' => t('Seleccione los roles para escluir los filtros.'),
      );
      /*$opciones['0']= "Seleccione";
      $opciones = entes_planificadores_obtiene_tipos();
      $form['fieldset_roles']['nivel_planificacion'] = array(
        '#title' => t('Nivel del ente Planificador al que se le ha de presentar el filtro'),
        '#type' =>'select',
        '#options' => $opciones,
        '#default_value' => $this->options['fieldset_roles']['nivel_planificacion'],
      );*/
    }
  }
  
 /**
   * Perform any necessary changes to the form values prior to storage.
   * There is no need for this function to actually store the data.
   */
  function value_submit($form, &$form_state) {
    if (isset($form_state['values']['options']['fieldset_roles']['roles_exclude_organismo'])) {
      variable_set('roles_exclude_organismo', $form_state['values']['options']['fieldset_roles']['roles_exclude_organismo']);
    }
    /*if (isset($form_state['values']['options']['fieldset_roles']['nivel_planificacion'])) {
      variable_set('nivel_planificacion_'.$form_state['values']['options']['identifier'], $form_state['values']['options']['fieldset_roles']['nivel_planificacion']);
    }*/
  }

  function query() {
    $aid = explode('_',$this->field);
    $aid = $aid[1];
    $this->ensure_my_table();
    $field = "organismo";
    $upper = '';
    $operation_attribute = "=";
    if($this->operator == 'not in') {
      $operation_attribute = '<>';
    }
    if(!is_array($this->value)) {
      $this->value = array($this->value);
    }
    foreach ($this->value as &$value) {
      if ($value) {
        $this->query->add_where($this->options['group'], "$upper(%s) %s  %d", $field, $operation_attribute, $value);
      }
    }
  }
}