- Filtré la información de los contratados.

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

diff --git a/lib/noticia.php b/lib/noticia.php
index 88f9f089d7619555c467e7348c33fb28a0766225..bd92c7b5d54ff4f7f16d3f7d0f6f0cc4ff29a736 100644 (file)
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -28,6 +28,7 @@
 //
 
 require_once 'mecondavdb.php';
 //
 
 require_once 'mecondavdb.php';

+require_once 'Date.php';

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


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

-        $this->noticia;
+        $this->noticia = $noticia;

         $db = MEconDAVDB::Connect();
         $db = MEconDAVDB::Connect();

-       $query = "SELECT headline, title, abstract, article
-                 FROM Articles
-                 WHERE Article_id = $noticia";
+       $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();
        $result = $db->query($query);
        $row = $result->fetchRow();

-       $this->titulo2 = $row[0];
-       $this->titulo = $row[1];
-       $this->abstracto = $row[2];
+       $this->titulo = $row[0];
+       $this->titulo2 = $row[1];
+       $this->sintesis = $row[2];

        $this->texto = $row[3];
        $this->texto = $row[3];

+       $this->fecha = new Date($row[4]);
+       $this->seccion = $row[5];
+       $this->id_seccion = $row[6];

     }
     // -X2C
 
     }
     // -X2C
 


@@ -93,9 +99,9 @@ class noticia {
      * @return string
      * @access public
      */
      * @return string
      * @access public
      */

-    function getAbstracto() // ~X2C
+    function getSintesis() // ~X2C

     {
     {

-        return $this->abstracto;
+        return $this->sintesis;

     }
     // -X2C
 
     }
     // -X2C
 


@@ -110,5 +116,38 @@ class noticia {
     }
     // -X2C
 
     }
     // -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 Class :noticia
 ?>
 } // -X2C Class :noticia
 ?>