- Modificaciones en algunos links de la intranet

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

diff --git a/lib/noticia.php b/lib/noticia.php
index 1f9a6656faf7a0ea93135c749d27e12661c36794..cc2b5f7ef9fd3657a1b880cddac40080da28e408 100644 (file)
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -2,16 +2,16 @@
 // vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
 // +--------------------------------------------------------------------+
 // |                      Ministerio de Economía                        |
 // vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
 // +--------------------------------------------------------------------+
 // |                      Ministerio de Economía                        |

-// |                             Intranet                              |
+// |                             Intranet                               |

 // +--------------------------------------------------------------------+
 // +--------------------------------------------------------------------+

-// | This file is part of Intranet.                                    |
+// | This file is part of Intranet.                                     |

 // |                                                                    |
 // |                                                                    |

-// | Intranet is free software; you can redistribute it and/or modify  |
+// | 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.                             |
 // |                                                                    |
 // | 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   |
+// | 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.                           |
 // | 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.                           |


@@ -20,16 +20,15 @@
 // | along with Hooks; if not, write to the Free Software Foundation,   |
 // | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA      |
 // +--------------------------------------------------------------------+
 // | 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>                                                    |
+// | 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 $
 //
 
 // +--------------------------------------------------------------------+
 //
 // $Id: xmi2code.tpl.php 1 2003-06-23 18:29:20Z gmeray $
 //
 

-require_once 'mecondavdb.php';

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

-
+require_once 'intranetdb.php';

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


@@ -54,10 +53,10 @@ class noticia {
     function noticia($noticia) // ~X2C
     {
         $this->noticia = $noticia;
     function noticia($noticia) // ~X2C
     {
         $this->noticia = $noticia;

-        $db = MEconDAVDB::Connect();
+        $db = IntranetDB::Connect();

        $query = "SELECT A.headline, A.title, A.abstract, A.article,
                         A.publication_date, S.description, S.section_id
        $query = "SELECT A.headline, A.title, A.abstract, A.article,
                         A.publication_date, S.description, S.section_id

-                 FROM Articles A, Sections S
+                 FROM MEconDAV.Articles A, MEconDAV.Sections S

                  WHERE Article_id = $noticia
                  AND A.section_id = S.section_id";
        $result = $db->query($query);
                  WHERE Article_id = $noticia
                  AND A.section_id = S.section_id";
        $result = $db->query($query);


@@ -156,9 +155,16 @@ class noticia {
      */
     function getLinks() // ~X2C
     {
      */
     function getLinks() // ~X2C
     {

-        $db = MEconDAVDB::Connect();
-        $sql = "SELECT link_id FROM Relations WHERE article_id = ".$this->noticia;
-        return $db->getCol($sql);
+        $db = IntranetDB::Connect();
+        $sql = "SELECT R.link_id, A.headline
+                FROM MEconDAV.Relations R, MEconDAV.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
 


@@ -169,11 +175,11 @@ class noticia {
      */
     function getArchivos() // ~X2C
     {
      */
     function getArchivos() // ~X2C
     {

-        $db = MEconDAVDB::Connect();
-        $sql = "SELECT file_for_article_id, caption FROM FilesForArticle WHERE article_id = ".$this->noticia;
+        $db = IntranetDB::Connect();
+        $sql = "SELECT file_for_article_id, caption FROM MEconDAV.FilesForArticle WHERE article_id = ".$this->noticia;

         $result =& $db->query($sql);
         $archivos = array();
         $result =& $db->query($sql);
         $archivos = array();

-        while($row =& $result->getRow())
+        while($row =& $result->fetchRow())

           $archivos[] = array('numero'=>$row[0], 'texto'=>$row[1]);
         return $archivos;
     }
           $archivos[] = array('numero'=>$row[0], 'texto'=>$row[1]);
         return $archivos;
     }