X-Git-Url: https://git.llucax.com/mecon/intranet.git/blobdiff_plain/1555e161f408c3be2f719ae0197a4a63d18774e0..4f8bc31d20f46ddb617fc55800841d680337155b:/sistema/local_lib/HTML_Titulares.php?ds=inline diff --git a/sistema/local_lib/HTML_Titulares.php b/sistema/local_lib/HTML_Titulares.php index 1de656c..7707d02 100644 --- a/sistema/local_lib/HTML_Titulares.php +++ b/sistema/local_lib/HTML_Titulares.php @@ -73,16 +73,26 @@ class HTML_Titulares extends HTML_Table { $query = "SELECT Articles.article_id, IF(Articles.publication_date > '$fecha_nuevo', 'NUEVA', null) FROM Articles, ArticlePublicationStates - WHERE Articles.article_publication_state_id = - ArticlePublicationStates.article_publication_state_id - AND ArticlePublicationStates.publication_state_id=5 "; + WHERE Articles.article_publication_state_id = + ArticlePublicationStates.article_publication_state_id + AND ArticlePublicationStates.publication_state_id=5 "; if(!is_null($grupo_secciones)) { $gs = new AI_GrupoSecciones($grupo_secciones); - $gs->cargar($db2); - if(count($gs->secciones) > 0) - $query .= 'AND Articles.section_id IN('.implode(',', $gs->secciones).') '; + $gs->cargar($db2); + if(count($gs->secciones) > 0) + $query .= ' AND Articles.section_id IN('.implode(',', $gs->secciones).') '; } + + //FIXME Agregado provisorio para cargar por herramienta lo que no es noticia + else{ + $gs = new AI_GrupoSecciones($grupo_secciones); + $gs->cargar($db2); + if(count($gs->secciones) > 0) + $query .= ' AND Articles.section_id NOT IN(53) '; + } + //FIXME Fin Agregado provisorio + if(!is_null($antiguedad)) { $hoy->subtractSeconds(60*60*24*$antiguedad); @@ -94,8 +104,8 @@ class HTML_Titulares extends HTML_Table { $this->numero_noticias = $result->numRows();//FIXME no documentado if(DB::isError($result)) die($result->getMessage("query mal hecho")); - $ht1 = new HTML_Table(array('width'=>'300', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0')); - $ht2 = new HTML_Table(array('width'=>'300', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0')); + $ht1 = new HTML_Table(array('width'=>'280', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0')); + $ht2 = new HTML_Table(array('width'=>'280', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0')); $impar = true; while($row = $result->fetchRow()) {