<?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 Operation 149
    /**
     * @return void
     * @access public
     */
    function getCuil()// ~X2C
    {
        trigger_error('Not implemented!', E_USER_WARNING);
    }
    // -X2C

    // +X2C Operation 151
    /**
     * @return void
     * @access public
     */
    function getOtrosDatos()// ~X2C
    {
        if(!is_null($this->datos['tipo_agente'])) {
            $aux['fecha_nac'] = $this->datos['fecha_nac']; 
            $aux['edad'] = $this->datos['edad']; 
            $aux['estado_civil'] = $this->datos['estado_civil']; 
            $aux['domicilio'] = $this->datos['domicilio']; 
            $aux['puerta'] = $this->datos['num_puerta']; 
            $aux['piso'] = $this->datos['piso']; 
            $aux['depto'] = $this->datos['depto']; 
            $aux['localidad'] = $this->datos['localidad']; 
            $aux['provincia'] = $this->datos['provincia']; 
            $aux['calle1'] = $this->datos['calle1']; 
            $aux['calle2'] = $this->datos['calle2']; 
            $aux['cp'] = $this->datos['cp']; 
            $aux['telefono'] = $this->datos['telefono']; 
            $aux['cargo'] = $this->datos['cargo']; 
            $aux['nivel'] = $this->datos['nivel']; 
            $aux['grado'] = $this->datos['grado']; 
            $aux['func_ejec'] = $this->datos['func_ejec']; 
            $aux['obra_social'] = $this->datos['obra_social']; 
            $aux['afiliado'] = $this->datos['afiliado']; 
            $aux['conyuge'] = $this->datos['conyuge']; 
            $aux['fecha_nac_conyuge'] = $this->datos['fecha_nac_cony']; 
            $aux['tipo_doc_conyuge'] = $this->datos['tipodoc_cony']; 
            $aux['nro_doc_cony'] = $this->datos['nrodoc_cony']; 
        }
        return $aux;
    }

} // -X2C Class :Agente
?>