<?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 Operation 150
    /**
     * @return dependencia
     * @access public
     * @static
     */
    function getDependencias() // ~X2C
    {
      $dsn = 'mysql://intranet:intranet@intranet-db/CODEP';
      $db = DB::connect($dsn);
      if (DB::isError($db)) die ($db->getMessage("No pudo conectarse a la base"));
      $sql = "SELECT codigo_actual 
              FROM Dependencias
	      WHERE dependencia_esta_activa = 1";
      $result = $db->query($sql);
      if(DB::isError($result))
        die($result->getMessage("query mal hecho"));
      $dependencias[] = array();
      while($row = $result->fetchRow())
        $dependencias[] = $row[0];
      return $dependencias;
    }
    // -X2C

} // -X2C Class :Dependencia
?>