<?php

  /**
  *
  * Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana
  * @file handler_field_ente_actividad.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
  *
  * @author Cenditel Merida - Msc. Juan Vizcarrondo
  * Modificado por: Msc. Juan Vizcarrondo @date YYYY-MM-DD. 
  * @date 2010-08-27 // (a&#241;o-mes-dia)
  * @version 0.2 // (0.1)
  *
  */

/**
 * Mostrar la actividad en views.
 */
class handler_field_ente_actividad extends views_handler_field_prerender_list {
  function construct() {
    parent::construct();
    $this->additional_fields['nid'] = array('table' => 'node', 'field' => 'nid');
  }
  function query() {
    $this->add_additional_fields();
    $this->field_alias = $this->aliases['nid'];
  }
  function pre_render($values) {
    $nids = array();
    $this->items = array();

    foreach ($values as $result) {
      $nids[] = $result->{$this->aliases['nid']};
    }
    if ($nids) {
      $result = db_query("SELECT u.nid, u.actividad, r.nombre FROM {ente_actividad} r INNER JOIN {ente_actividad_ente} u ON u.actividad = r.id_actividad WHERE u.nid IN (" . implode(', ', $nids) . ") ORDER BY r.nombre");
      while ($actividad = db_fetch_object($result)) {
        $this->items[$actividad->nid][$actividad->actividad]['actividades'] = check_plain($actividad->nombre);
        $this->items[$actividad->nid][$actividad->actividad]['actividad'] = $actividad->actividad;
      }
    }
  }
  function render_item($count, $item) {
    return $item['actividades'];
  }
}