X-Git-Url: https://git.llucax.com/mecon/intranet.git/blobdiff_plain/534be32199334fd820115b65e0ccbded391945fd..f5f3a1c3c7197cc0baa49fc15f96a27054c49f64:/sistema/www/noticias.php

diff --git a/sistema/www/noticias.php b/sistema/www/noticias.php
index 16e2119..90f5331 100644
--- a/sistema/www/noticias.php
+++ b/sistema/www/noticias.php
@@ -28,8 +28,10 @@
        require_once '../local_lib/HTML_Noticia.php';
        require_once '../../lib/mecondavdb.php';
        $db = MEconDAVDB::Connect();
-       $fecha_limite = '2003-07-01';
-       $fecha_nuevo  = '2003-07-07';
+       $hoy = new Date();
+       $fecha_nuevo  = $hoy->format('%Y-%m-%d');
+       $hoy->subtractSeconds(60*60*24*7);//7 dias
+       $fecha_limite = $hoy->format('%Y-%m-%d');
        $query = "SELECT Articles.article_id,
                         IF(Articles.publication_date > '$fecha_nuevo', 'NUEVA', null)
                  FROM Articles, ArticlePublicationStates
@@ -41,28 +43,28 @@
        $result = $db->query($query);
        if(DB::isError($result))
          die($result->getMessage("query mal hecho"));
-       $ht = new HTML_Table(array('width'=>'600', 'border'=>'0', 'cellspacing'=>'0'));
-       $not1 = $not2 = null;
+       $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'));
+       $impar = true;
        while($row = $result->fetchRow())
        {
-         
          $n = new noticia($row[0]);
          $not = new HTML_Noticia($n);
 	 if($row[1] == 'NUEVA')
              $not->setNuevo(true);
-	 if(is_null($not1)) $not1 = $not;
-	 elseif(is_null($not2))
+	 if($impar)
 	 {
-	   $not2 = $not;
-           $ht->addRow(array($not1, $not2));
+	   $impar = false;
+           $ht1->addRow(array($not));
 	 }
 	 else
 	 {
-	   $not1 = $not;
-	   $not2 = null;
+	   $impar = true;
+           $ht2->addRow(array($not));
 	 }
        }
-       if(is_null($not2)) $ht->addRow(array($not1));
+       $ht = new HTML_Table(array('width'=>'300', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0'));
+       $ht->addRow(array($ht1,$ht2));
        $ht->display();
     ?>
     </td>