source: sipes/0.3-modules/proyectos_operativos_seguimiento/views/proyecto_operativo_seguimiento_views_handler_filter_mes.inc @ f74cf58

<?php
  /**
  *
  * Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana
  * @file proyecto_operativo_seguimiento_views_handler_filter_sid.inc
  * Drupal part Module ente_planificador_hierarchical module
  * Copyright 2017 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 - PHD. Juan Vizcarrondo
  * @date 2017-05-04 // (a&#241;o-mes-dia)
  * @version 0.2 // (0.1)
  *
  */


/**
 * Filter by state.
 */
class proyecto_operativo_seguimiento_views_handler_filter_mes extends views_handler_filter_in_operator {
  var $value_form_type = 'select';
  function get_value_options() {
    if (!isset($this->value_options)) {
      $this->value_title = t('Month Seguimiento');
      $meses = array(
        1 => t('January'),
        2 => t('February'), 
        3 => t('March'), 
        4 => t('April'),
        5 => t('May'),
        6 => t('June'),
        7 => t('July'),
        8 => t('August'),
        9 => t('September'),
        10 => t('Octuber'),
        11 => t('November'),
        12 => t('December'),
      );
      $this->value_options = $meses;
    }
  }
  function query() {
    if (empty($this->value)) {
      return;
    }
    $this->ensure_my_table();
    $placeholder = !empty($this->definition['numeric']) ? '%d' : "'%s'";

    if (count($this->value) == 1) {
      $this->operator = ($this->operator == 'in') ? '= ' : '!= ';
      $in = !empty($this->definition['numeric']) ? '%d' : "'%s'";
    }
    else {
      $replace = array_fill(0, sizeof($this->value), $placeholder);
      $in = ' (' . implode(", ", $replace) . ')';
    }
    $this->query->add_where($this->options['group'], $this->table_alias . '.mes ' . $this->operator . $in, $this->value);
  }
}