<?php
// vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
// +----------------------------------------------------------------------+
// | PHP Version 4                                                        |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2003 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.02 of the PHP license,      |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.php.net/license/2_02.txt.                                 |
// | If you did not receive a copy of the PHP license and are unable to   |
// | obtain it through the world-wide-web, please send a note to          |
// | license@php.net so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Created: Thu Jun 19 15:17:11 2003
// | Author:  Gonzalo Merayo <gmeray@mecon.gov.ar>
// +----------------------------------------------------------------------+
//
// $Id$
// $Author$
// $URL$
// $Date$
// $Rev$
//

#require_once 'PEAR.php';
require_once 'DB.php';
require_once 'MECON/Tiempo/Hora.php';


// +X2C Class 131 :Agente
/**
 * @access public
 */
class Agente {
  /**
   * @var    int $agente
   * @access public
   */
  var $agente;

  /**
   * @var    int $datos
   * @access public
   */
  var $datos;

  // ~X2C

  // +X2C Operation 133
  /**
   * @return string
   * @access public
   */
  function getDependencia() // ~X2C
  {
      return $this->datos['codep'];//TODO esta no es la columna correcta
  }
  // -X2C

  // +X2C Operation 134
  /**
   * @return void
   * @access public
   */
  function getTipo() // ~X2C
  {
      if(is_null($this->datos['tipo_agente']))
        return 'CON '.$this->datos['marco_legal'];
      else
        return $this->datos['tipo_agente'];
      
  }
  // -X2C

  // +X2C Operation 135
  /**
   * @param  int $agente 
   *
   * @return void
   * @access public
   */
  function Agente($agente) // ~X2C
  {
      $this->agente = $agente;
      $dsn = 'mysql://intranet:intranet@intranet-db/novedades';
      $db = DB::connect($dsn);
      if (DB::isError($db)) die ($db->getMessage("No pudo conectarse a la base"));
      $sql = "SELECT * 
              FROM web003
	      WHERE nrodoc = $agente";
      $result = $db->query($sql);
      if(DB::isError($result))
        die($result->getMessage("query mal hecho"));
      if($result->numRows() > 0)
      {
          $this->datos = $result->fetchRow(DB_FETCHMODE_ASSOC); 
      }
      else
      {
          $dsn = 'mysql://intranet:intranet@intranet-db/Contratados';
          $db = DB::connect($dsn);
          if (DB::isError($db)) die ($db->getMessage("No pudo conectarse a la base"));
          $sql = "SELECT * 
                  FROM Contratados
	          WHERE nrodoc = $agente";
          $result = $db->query($sql);
          if(DB::isError($result))
            die($result->getMessage("query mal hecho"));
          if($result->numRows() > 0)
          {
            $this->datos = $result->fetchRow(DB_FETCHMODE_ASSOC);
          }
	  else
            trigger_error("Ahhhhh, agente no encontrado!"); 
      }
  }
  // -X2C

  // +X2C Operation 138
  /**
   * @return void
   * @access public
   */
  function getNombre() // ~X2C
  {
      return $this->datos['nombre'];
  }
  // -X2C

  // +X2C Operation 139
  /**
   * @return void
   * @access public
   */
  function getHoraDesde() // ~X2C
  {
      if(is_null($this->datos['hentra']))
          return new Hora($this->datos['hora_desde']);
      else
          return new Hora($this->datos['hentra']);
  }
  // -X2C

  // +X2C Operation 140
  /**
   * @return void
   * @access public
   */
  function getHoraHasta() // ~X2C
  {
      if(is_null($this->datos['hsale']))
          return new Hora($this->datos['hora_hasta']);
      else
          return new Hora($this->datos['hsale']);
  }
  // -X2C

} // -X2C Class :Agente
?>