From 78860b66af59d050da193ab0628890a8f9587841 Mon Sep 17 00:00:00 2001
From: Gonzalo Merayo <merayo@gmail.com>
Date: Thu, 19 Jun 2003 20:20:34 +0000
Subject: [PATCH] Agrego los objetos Dependencia y Agente...todavia muy jovenes

---
 lib/MECON/Agente.php      | 163 ++++++++++++++++++++++++++++++++++++++
 lib/MECON/Dependencia.php |  96 ++++++++++++++++++++++
 2 files changed, 259 insertions(+)
 create mode 100644 lib/MECON/Agente.php
 create mode 100644 lib/MECON/Dependencia.php

diff --git a/lib/MECON/Agente.php b/lib/MECON/Agente.php
new file mode 100644
index 0000000..5134383
--- /dev/null
+++ b/lib/MECON/Agente.php
@@ -0,0 +1,163 @@
+<?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
+?>
\ No newline at end of file
diff --git a/lib/MECON/Dependencia.php b/lib/MECON/Dependencia.php
new file mode 100644
index 0000000..f4592d0
--- /dev/null
+++ b/lib/MECON/Dependencia.php
@@ -0,0 +1,96 @@
+<?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 16:54:08 2003
+// | Author:  Gonzalo Merayo <gmeray@mecon.gov.ar>
+// +----------------------------------------------------------------------+
+//
+// $Id$
+// $Author$
+// $URL$
+// $Date$
+// $Rev$
+//
+
+#require_once 'PEAR.php';
+require_once 'MECON/Agente.php';
+require_once 'DB.php';
+
+
+
+// +X2C Class 145 :dependencia
+/**
+ * @access protected
+ */
+class dependencia {
+  /**
+   * @var    int $codep
+   * @access public
+   */
+  var $codep;
+
+  // ~X2C
+
+  // +X2C Operation 147
+  /**
+   * @param  int $codep 
+   *
+   * @return void
+   * @access public
+   */
+  function dependencia($codep) // ~X2C
+  {
+    $this->codep = $codep;
+  }
+  // -X2C
+
+  // +X2C Operation 148
+  /**
+   * @return void
+   * @access public
+   */
+  function getAgentes() // ~X2C
+  {
+//Planta y becarios	  
+      $agentes = array();
+      $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 nrodoc 
+              FROM web003
+	      WHERE codep = $this->codep";
+      $result = $db->query($sql);
+      if(DB::isError($result))
+        die($result->getMessage("query mal hecho"));
+      while($row = $result->fetchRow())
+        $agentes[] = new Agente($row[0]);
+//Contratados	  
+      $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 codep = $this->codep";
+      $result = $db->query($sql);
+      if(DB::isError($result))
+        die($result->getMessage("query mal hecho"));
+      while($row = $result->fetchRow())
+        $agentes[] = new Agente($row[0]);
+      return $agentes;
+  }
+  // -X2C
+
+} // -X2C Class :dependencia
+?>
-- 
2.43.0