<?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
?>