<?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: Thu Jul 3 14:49:15 2003                                   |
// | Autor:  Gonzalo Merayo <gmeray@mecon.gov.ar>                                                    |
// +--------------------------------------------------------------------+
//
// $Id: xmi2code.tpl.php 1 2003-06-23 18:29:20Z gmeray $
//

require_once 'mecondavdb.php';
require_once 'Date.php';


// +X2C Class 161 :noticia
/**
 * @access public
 */
class noticia {
    /**
     * @var    int $Noticia
     * @access public
     */
    var $Noticia;

    // ~X2C

    // +X2C Operation 169
    /**
     * @param  int $noticia codigo de la noticia
     *
     * @return void
     * @access public
     */
    function noticia($noticia) // ~X2C
    {
        $this->noticia = $noticia;
        $db = MEconDAVDB::Connect();
	$query = "SELECT A.headline, A.title, A.abstract, A.article,
	                 A.publication_date, S.description, S.section_id
	          FROM Articles A, Sections S
		  WHERE Article_id = $noticia
		  AND A.section_id = S.section_id";
	$result = $db->query($query);
	$row = $result->fetchRow();
	$this->titulo = $row[0];
	$this->titulo2 = $row[1];
	$this->sintesis = $row[2];
	$this->texto = $row[3];
	$this->fecha = new Date($row[4]);
	$this->seccion = $row[5];
	$this->id_seccion = $row[6];
    }
    // -X2C

    // +X2C Operation 180
    /**
     * @return string
     * @access public
     */
    function getTitulo() // ~X2C
    {
        return $this->titulo;
    }
    // -X2C

    // +X2C Operation 181
    /**
     * @return string
     * @access public
     */
    function getTexto() // ~X2C
    {
        return $this->texto;
    }
    // -X2C

    // +X2C Operation 182
    /**
     * @return string
     * @access public
     */
    function getSintesis() // ~X2C
    {
        return $this->sintesis;
    }
    // -X2C

    // +X2C Operation 183
    /**
     * @return string
     * @access public
     */
    function getTitulo2() // ~X2C
    {
        return $this->titulo2;
    }
    // -X2C

    // +X2C Operation 186
    /**
     * @return string
     * @access public
     */
    function getFecha() // ~X2C
    {
        return $this->fecha;
    }
    // -X2C

    // +X2C Operation 191
    /**
     * @return void
     * @access public
     */
    function getSeccion() // ~X2C
    {
        return $this->seccion;
    }
    // -X2C

    // +X2C Operation 197
    /**
     * @return void
     * @access public
     */
    function getidSeccion() // ~X2C
    {
        return $this->id_seccion;
    }
    // -X2C

    // +X2C Operation 199
    /**
     * @return void
     * @access public
     */
    function getLinks() // ~X2C
    {
        $db = MEconDAVDB::Connect();
        $sql = "SELECT link_id FROM Relations WHERE article_id = ".$this->noticia;
        return $db->getCol($sql);
    }
    // -X2C

    // +X2C Operation 200
    /**
     * @return void
     * @access public
     */
    function getArchivos() // ~X2C
    {
        $db = MEconDAVDB::Connect();
        $sql = "SELECT file_for_article_id, caption FROM FilesForArticle WHERE article_id = ".$this->noticia;
        $result =& $db->query($sql);
        $archivos = array();
        while($row =& $result->getRow())
          $archivos[] = array('numero'=>$row[0], 'texto'=>$row[1]);
        return $archivos;
    }
    // -X2C

} // -X2C Class :noticia
?>