$sqlPresses = "SELECT systeam_presses.IdPresse, systeam_presses.PresseType, systeam_presses.PresseTitreDoc,
systeam_presses.PresseDescription, systeam_presses.PresseLinkToDoc, systeam_presses.PresseDateCreation,
systeam_presses.PresseDatePublication, systeam_presses.PresseDateDepublication FROM systeam_presses";
$sqlPresses .= " WHERE PresseType=2 ";
if($_GET['espace']>0) $sqlPresses.= " AND systeam_presses.IdEspace = ".$_GET['espace'];
$sqlPresses.= " AND (PresseDatePublication=0 OR PresseDatePublication<=".$dateActuelle.")";
$sqlPresses.= " AND (PresseDateDepublication=0 OR PresseDateDepublication>=".$dateActuelle.")";
$sqlPresses .= " ORDER BY systeam_presses.PresseDateCreation DESC";
$nav = new Navigation($connexion, $sqlPresses, $_GET['page'], 10,5,"?espace=".$_GET['espace'], "", "");
$resultPresses = dbQuery($nav->RequeteSQL(), $connexion);
$nbretour = $nav->NbTotal();
?>
Customer area access
This area is restricted to BEAM-REPORT customers and users in charge of a BEAM-REPORT evaluation.
if(dbResOk($resultPresses)){ ?>
Customer area access
while( $rstPresse = dbFetchArray($resultPresses, $connexion)){ ?>
Type :
if(file_exists($rstPresse['PresseLinkToDoc'])){
$poids = filesize($rstPresse['PresseLinkToDoc']);
$poidsformat = formatFileSize($poids);
$extension = substr($rstPresse['PresseLinkToDoc'],-3);
if(file_exists("template/systeam/img/ico-".$extension.".gif")){
echo " ";
}else{
echo " ";
}
echo "Télécharger le document (".$poidsformat.")
";
}
?>
}?>
} ?>
echo $nav->AffichageNavigation();?>