Arreglos varios de las noticias

[mecon/intranet.git] / lib / noticia.php

diff --git a/lib/noticia.php b/lib/noticia.php
index 0580e8de688b6ec944572c914f760f8dacd86ab9..fc41b8037fabc3cc60d614c3520916ea585e9bcf 100644 (file)
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -27,7 +27,8 @@
 // $Id: xmi2code.tpl.php 1 2003-06-23 18:29:20Z gmeray $
 //
 
 // $Id: xmi2code.tpl.php 1 2003-06-23 18:29:20Z gmeray $
 //
 

-
+require_once 'mecondavdb.php';
+require_once 'Date.php';

 
 
 // +X2C Class 161 :noticia
 
 
 // +X2C Class 161 :noticia


@@ -52,9 +53,138 @@ class noticia {
      */
     function noticia($noticia) // ~X2C
     {
      */
     function noticia($noticia) // ~X2C
     {

-        trigger_error('Not implemented!', E_USER_WARNING);
+        $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 R.link_id, A.headline
+                FROM Relations R, Articles A
+                WHERE R.link_id = A.article_id
+                AND   R.article_id = ".$this->noticia;
+        $result =& $db->query($sql);
+        $links = array();
+        while($row =& $result->fetchRow())
+          $links[] = array('numero'=>$row[0], 'texto'=>$row[1]);
+        return $links;
+    }
+    // -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->fetchRow())
+          $archivos[] = array('numero'=>$row[0], 'texto'=>$row[1]);
+        return $archivos;

     }
     // -X2C
 
 } // -X2C Class :noticia
     }
     // -X2C
 
 } // -X2C Class :noticia

-?>
\ No newline at end of file
+?>