<?php /* vim: set binary expandtab tabstop=4 shiftwidth=4 textwidth=80:
-------------------------------------------------------------------------------
                             Ministerio de Economía
                                    meconlib
-------------------------------------------------------------------------------
This file is part of meconlib.
 
meconlib 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.
 
meconlib 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; if not,
write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
Boston, MA  02111-1307  USA
-------------------------------------------------------------------------------
Creado: Thu Jun 19 15:17:11 2003
Autor:  Gonzalo Merayo <gmeray@mecon.gov.ar>
-------------------------------------------------------------------------------
$Id$
-----------------------------------------------------------------------------*/

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

// +X2C Class 131 :MECON_Agente
/**
 * @access public
 */
class MECON_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(!in_array('tipo_agente',array_keys($this->datos)))
            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
    {
        if(! is_null($agente))
            $this->buscarAgente($agente);
    }
    // -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 MECON_Tiempo_Hora($this->datos['hora_desde']);
        else
            return new MECON_Tiempo_Hora($this->datos['hentra']);
    }
    // -X2C

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

    // +X2C Operation 149
    /**
     * @return void
     * @access public
     */
    function getCuil() // ~X2C
    {
        $aux = $this->datos['cuil'];
        $aux = preg_replace('/(\d{2})(\d*)(\d{1})/','$1-$2-$3',$aux);
        return $aux;
    }
    // -X2C

    // +X2C Operation 151
    /**
     * @return void
     * @access public
     */
    function getOtrosDatos() // ~X2C
    {
        if(!is_null($this->datos['tipo_agente'])) {
            $aux['tipo_doc'] = $this->datos['tipodoc'];
            $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;
        } else {
            return false;
        }
    }
    // -X2C

    // +X2C Operation 154
    /**
     * @param  int $agente 
     *
     * @return void
     * @access public
     */
    function buscarAgente($agente) // ~X2C
    {
        $this->agente = $agente;
        $dsn = 'mysql://intranet:intranet@intranet-db.mecon.ar/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.mecon.ar/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
                return false;
        }
        return true;
    }
    // -X2C

} // -X2C Class :MECON_Agente
?>