<?php

  /**
  *
  * Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana
  * @file handler_field_ente_usuario.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/12/19 // (a&#241;o-mes-dia)
  * @version 0.2 // (0.1)
  *
  */

/**
 * Mostrar los entes planificadores en views.
 */
 class handler_field_user_ente extends views_handler_field {
  function render($values) {
     $title = '';
     if ($values->{$this->field_alias}) {
       $result = db_query("SELECT u.usuario, n.title FROM {ente_user_planificador} as u INNER JOIN {node} as n ON u.nid = n.nid WHERE u.usuario = %d", $values->ente_user_planificador_usuario);
       while($row = db_fetch_object($result)) {
         $title =  l($row->title, 'user/' . $row->usuario, array('html' => true, 'query' => 'destination=administrar_usuarios'));
       }
     } 
     return $title;
   }
 }