X-Git-Url: https://git.llucax.com/mecon/intranet.git/blobdiff_plain/707e1370e56a9a9536a81aab72b530c48e3d361e..0f6144a2f8fae03e6d20a3f24db8b2c034cf9823:/lib/noticia.php diff --git a/lib/noticia.php b/lib/noticia.php index 96ba6b2..bd92c7b 100644 --- a/lib/noticia.php +++ b/lib/noticia.php @@ -55,16 +55,20 @@ class noticia { { $this->noticia = $noticia; $db = MEconDAVDB::Connect(); - $query = "SELECT headline, title, abstract, article, publication_date - 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(); - $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->fecha = new Date($row[4]); + $this->seccion = $row[5]; + $this->id_seccion = $row[6]; } // -X2C @@ -95,9 +99,9 @@ class noticia { * @return string * @access public */ - function getAbstracto() // ~X2C + function getSintesis() // ~X2C { - return $this->abstracto; + return $this->sintesis; } // -X2C @@ -123,5 +127,27 @@ class noticia { } // -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 ?>