From 4b08135a35b4ba9f3e87dfdb4cdc427800e359ac Mon Sep 17 00:00:00 2001
From: Leandro Lucarella <llucax@gmail.com>
Date: Thu, 24 Jun 2004 20:41:17 +0000
Subject: [PATCH] - Pase a meconlib los objetos para mostrar la informacion de
 legajos

---
 lib/MECON/Legajos/Estudios.php           |  93 ++++++++++++++++
 lib/MECON/Legajos/ExperienciaLaboral.php | 121 +++++++++++++++++++++
 lib/MECON/Legajos/Familiares.php         | 128 +++++++++++++++++++++++
 3 files changed, 342 insertions(+)
 create mode 100644 lib/MECON/Legajos/Estudios.php
 create mode 100644 lib/MECON/Legajos/ExperienciaLaboral.php
 create mode 100644 lib/MECON/Legajos/Familiares.php

diff --git a/lib/MECON/Legajos/Estudios.php b/lib/MECON/Legajos/Estudios.php
new file mode 100644
index 0000000..60a1060
--- /dev/null
+++ b/lib/MECON/Legajos/Estudios.php
@@ -0,0 +1,93 @@
+<?php
+// vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
+// +--------------------------------------------------------------------+
+// |                      Ministerio de Economía                        |
+// |                             Intranet                               |
+// +--------------------------------------------------------------------+
+// | This file is part of Intranet.                                     |
+// |                                                                    |
+// | Intranet 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.                             |
+// |                                                                    |
+// | Intranet 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 Hooks; if not, write to the Free Software Foundation,   |
+// | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA      |
+// +--------------------------------------------------------------------+
+// | Creado: Mon Jul 7 17:22:10 2003                                    |
+// | Autor:  Matías Sklar <msklar@mecon.gov.ar>                         |
+// +--------------------------------------------------------------------+
+//
+// $Id: Intranet_Legajos_Estudios.php 23 2003-07-15 18:56:42Z msklar $
+//
+
+
+
+// +X2C includes
+require_once 'DB.php';
+// ~X2C
+
+// +X2C Class 163 :Servicios_Legajos_Estudios
+/**
+ * Estudios del agente
+ *
+ * @access public
+ */
+// XXX - Pregunta llucar: POR QUE CATSO HEREDA DE DB???
+class MECON_Legajos_Estudios extends DB {
+    /**
+     * @var    int $agente
+     * @access public
+     */
+    var $agente;
+
+    /**
+     * @var    int $datos
+     * @access public
+     */
+    var $datos;
+
+    // ~X2C
+
+    // +X2C Operation 166
+    /**
+     * @param  int $agente 
+     *
+     * @return void
+     * @access public
+     */
+    function MECON_Legajos_Estudios($db,$agente) // ~X2C
+    {
+        $this->agente = $agente;
+        $sql = "SELECT * 
+                FROM novedades.web005
+                WHERE documento = $agente";
+        $result = $db->query($sql);
+        if (DB::isError($result))
+            trigger_error($result->getMessage('Query mal hecho'), E_USER_ERROR);
+
+        for ($fila = 0; $fila < $result->numRows(); $fila++) {
+            $this->datos[$fila] = $result->fetchRow(DB_FETCHMODE_ASSOC);
+        }
+    }
+    // -X2C
+
+    // +X2C Operation 172
+    /**
+     * @return void
+     * @access public
+     */
+    function getEstudios() // ~X2C
+    {
+        return $this->datos;
+    }
+    // -X2C
+
+} // -X2C Class :Servicios_Legajos_Estudios
+?>
diff --git a/lib/MECON/Legajos/ExperienciaLaboral.php b/lib/MECON/Legajos/ExperienciaLaboral.php
new file mode 100644
index 0000000..27d8f89
--- /dev/null
+++ b/lib/MECON/Legajos/ExperienciaLaboral.php
@@ -0,0 +1,121 @@
+<?php
+// vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
+// +--------------------------------------------------------------------+
+// |                      Ministerio de Economía                        |
+// |                             Intranet                               |
+// +--------------------------------------------------------------------+
+// | This file is part of Intranet.                                     |
+// |                                                                    |
+// | Intranet 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.                             |
+// |                                                                    |
+// | Intranet 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 Hooks; if not, write to the Free Software Foundation,   |
+// | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA      |
+// +--------------------------------------------------------------------+
+// | Creado: Mon Jul 7 17:22:10 2003                                    |
+// | Autor:  Matías Sklar <msklar@mecon.gov.ar>                         |
+// +--------------------------------------------------------------------+
+//
+// $Id: Intranet_Legajos_ExperienciaLaboral.php 23 2003-07-15 18:56:42Z msklar $
+//
+
+// +X2C includes
+require_once 'DB.php';
+// ~X2C
+
+// +X2C Class 155 :Servicios_Legajos_ExperienciaLaboral
+/**
+ * Antigüedad laboral del agente
+ *
+ * @access public
+ */
+// XXX - Pregunta llucar: POR QUE CATSO HEREDA DE DB???
+class MECON_Legajos_ExperienciaLaboral extends DB {
+    /**
+     * @var    int $agente
+     * @access public
+     */
+    var $agente;
+
+    /**
+     * @var    int $antiguedad
+     * @access public
+     */
+    var $antiguedad;
+
+    /**
+     * @var    int $experiencia
+     * @access public
+     */
+    var $experiencia;
+
+    // ~X2C
+
+    // +X2C Operation 159
+    /**
+     * @param  int $agente 
+     *
+     * @return void
+     * @access public
+     */
+    function MECON_Legajos_ExperienciaLaboral($db,$agente) // ~X2C
+    {
+        $this->agente = $agente;
+        $sql = "SELECT * 
+                FROM novedades.web032
+                WHERE nrodoc = $agente
+                ORDER BY desde";
+        $result_exp = $db->query($sql);
+        if (DB::isError($result_exp))
+            trigger_error($result_exp->getMessage('Query mal hecho'), E_USER_ERROR);
+
+        for ($fila = 0; $fila < $result_exp->numRows(); $fila++) {
+            $this->experiencia[$fila] = $result_exp->fetchRow(DB_FETCHMODE_ASSOC);
+        }
+
+        $sql = "SELECT *
+                FROM novedades.web031
+                WHERE nrodoc = $agente";
+        $result_ant = $db->query($sql);
+        if (DB::isError($result_ant))
+            trigger_error($result_ant->getMessage('Query mal hecho'), E_USER_ERROR);
+
+        if ($result_ant->numRows() > 0) {
+            $this->antiguedad = $result_ant->fetchRow(DB_FETCHMODE_ASSOC);
+        }
+
+    }
+    // -X2C
+
+    // +X2C Operation 160
+    /**
+     * @return void
+     * @access public
+     */
+    function getAntiguedad() // ~X2C
+    {
+        return $this->antiguedad;
+    }
+    // -X2C
+
+    // +X2C Operation 161
+    /**
+     * @return void
+     * @access public
+     */
+    function getExperiencia() // ~X2C
+    {
+        return $this->experiencia;
+    }
+    // -X2C
+
+} // -X2C Class :Servicios_Legajos_ExperienciaLaboral
+?>
diff --git a/lib/MECON/Legajos/Familiares.php b/lib/MECON/Legajos/Familiares.php
new file mode 100644
index 0000000..195480d
--- /dev/null
+++ b/lib/MECON/Legajos/Familiares.php
@@ -0,0 +1,128 @@
+<?php
+// vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
+// +--------------------------------------------------------------------+
+// |                      Ministerio de Economía                        |
+// |                             Intranet                               |
+// +--------------------------------------------------------------------+
+// | This file is part of Intranet.                                     |
+// |                                                                    |
+// | Intranet 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.                             |
+// |                                                                    |
+// | Intranet 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 Hooks; if not, write to the Free Software Foundation,   |
+// | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA      |
+// +--------------------------------------------------------------------+
+// | Creado: Mon Jul 7 17:22:10 2003                                    |
+// | Autor:  Matías Sklar <msklar@mecon.gov.ar>                         |
+// +--------------------------------------------------------------------+
+//
+// $Id: Intranet_Legajos_Familiares.php 23 2003-07-15 18:56:42Z msklar $
+//
+
+// +X2C includes
+require_once 'DB.php';
+// ~X2C
+
+// +X2C Class 154 :Servicios_Legajos_Familiares
+/**
+ * @access public
+ */
+// XXX - Pregunta llucar: POR QUE CATSO HEREDA DE DB???
+class MECON_Legajos_Familiares extends DB {
+    /**
+     * @var    int $agente
+     * @access public
+     */
+    var $agente;
+
+    /**
+     * @var    int $datos
+     * @access public
+     */
+    var $datos;
+
+    // ~X2C
+
+    // +X2C Operation 169
+    /**
+     * @param  int $agente 
+     *
+     * @return void
+     * @access public
+     */
+    function MECON_Legajos_Familiares($db,$agente) // ~X2C
+    {
+        $this->agente = $agente;
+        $sql = "SELECT * 
+                FROM novedades.web004
+                WHERE documento = $agente";
+        $result = $db->query($sql);
+        if (DB::isError($result))
+            trigger_error($result->getMessage('Query mal hecho'), E_USER_ERROR);
+
+        for ($fila = 0; $fila < $result->numRows(); $fila++) {
+            $this->datos[$fila] = $result->fetchRow(DB_FETCHMODE_ASSOC);
+        }
+    }
+    // -X2C
+
+    // +X2C Operation 170
+    /**
+     * @return void
+     * @access public
+     */
+    function getHijos() // ~X2C
+    {
+        $aux = array();
+        $fila = 0;
+        if(is_array($this->datos)) {
+            foreach (array_keys($this->datos) as $key) {
+                if($this->datos[$key]['parentesco']=='H') {
+                 $aux[$fila]['nombre'] = $this->datos[$key]['nombre'];
+                 $aux[$fila]['tipo_doc'] = $this->datos[$key]['tipodoc'];
+                 $aux[$fila]['nro_doc'] = $this->datos[$key]['nrodoc'];
+                 $aux[$fila]['fecha_nac'] = $this->datos[$key]['fecha_nac'];
+                 $aux[$fila]['parentesco'] = $this->datos[$key]['parentesco'];
+                 $fila++;
+                }
+            }
+        }
+        return $aux;
+    }
+    // -X2C
+
+    // +X2C Operation 171
+    /**
+     * @return void
+     * @access public
+     */
+    function getFamiliares() // ~X2C
+    {
+        $aux = array();
+        $fila = 0;
+        if(is_array($this->datos)) {
+            foreach (array_keys($this->datos) as $key) {
+                if($this->datos[$key]['parentesco']!="H") {
+                    $aux[$fila]['nombre'] = $this->datos[$key]['nombre'];
+                    $aux[$fila]['tipo_doc'] = $this->datos[$key]['tipodoc'];
+                    $aux[$fila]['nro_doc'] = $this->datos[$key]['nrodoc'];
+                    $aux[$fila]['fecha_nac'] = $this->datos[$key]['fecha_nac'];
+                    $aux[$fila]['parentesco'] = $this->datos[$key]['parentesco'];
+                    $fila++;
+                }
+            }
+        }
+        return $aux;
+    }
+    // -X2C
+
+} // -X2C Class :Servicios_Legajos_Familiares
+?>
-- 
2.43.0