Extiendo noticia para que obtenga las imagenes, Corrijo la enie de Login

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

diff --git a/lib/noticia.php b/lib/noticia.php
index 0b37c92ecc67368862d8c1f45fe89f83e92abfc4..1f9a6656faf7a0ea93135c749d27e12661c36794 100644 (file)
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -56,7 +56,7 @@ class noticia {
         $this->noticia = $noticia;
         $db = MEconDAVDB::Connect();
        $query = "SELECT A.headline, A.title, A.abstract, A.article,
-                        A.publication_date, S.description
+                        A.publication_date, S.description, S.section_id
                  FROM Articles A, Sections S
                  WHERE Article_id = $noticia
                  AND A.section_id = S.section_id";
@@ -68,6 +68,7 @@ class noticia {
        $this->texto = $row[3];
        $this->fecha = new Date($row[4]);
        $this->seccion = $row[5];
+       $this->id_seccion = $row[6];
     }
     // -X2C
 
@@ -137,5 +138,46 @@ class noticia {
     }
     // -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
-?>
\ No newline at end of file
+?>