echo "<tr bgcolor=\"#FF3333\" class=\"logFFCC66\">";
$jour = substr($date, 8, 2);
$mois = substr($date, 5, 2);
$annee = substr($date, 0, 4);
$date = $jour . "/" . $mois . "/" . $annee;
$titre = stripslashes($titre);
$sujet = stripslashes($sujet);
echo " <td class=\"txttabl\" width=\"20\" bgcolor=\"#FFFFCC\">{$date}</td>";
echo " <td class=\"txttabl\" width=\"80\" bgcolor=\"#FFFFCC\"> {$titre}</td>";
echo " <td class=\"txttabl\" width=\"90\" bgcolor=\"#FFFFCC\">{$auteur} {$auteur2}</td>";
echo " <td class=\"txttabl\" width=\"200\" bgcolor=\"#FFFFCC\"> {$sujet}";
$ouou = "recherche";
if ($memoire != "") {
$titou = $memoire;
}
taille2($taille, $numa, $titou, $ouou);
echo "<br>détail de l'article</a></td>";
echo " <td class=\"txttabl\" width=\"20\" bgcolor=\"#FFFFCC\">{$globalConfig}</td>";
echo "</tr>";
$i++;
}
}
echo "<tr><td colspan=5 align=right><a href=\"#bas\"><img src=\"../zimages/bas.gif\" width=\"25\" height=\"26\" border=\"0\" alt=\"aller en bas de page\"></a><a href=\"#haut\"><img src=\"../zimages/haut.gif\" width=\"25\" height=\"26\" border=\"0\" alt=\"aller en haut de page\"></a></td></tr>";
echo " </table><br><br> \n";
?>
<img src="../images-index/articles_archiv.gif">
<?php
echo "<table width=\"90%\" border=\"0\" cellpadding=\"0\" align=center>";
/* On parcourt le tableau de mot
$taille = mysql_result($result, $i, taille);
$date = mysql_result($result, $i, date_crea);
$globalConfig = mysql_result($result, $i, nivo_conf);
echo "<tr bgcolor=\"#FF3333\" class=\"logFFCC66\">";
$jour = substr($date, 8, 2);
$mois = substr($date, 5, 2);
$annee = substr($date, 0, 4);
$date = $jour . "/" . $mois . "/" . $annee;
$titre = stripslashes($titre);
$sujet = stripslashes($sujet);
echo " <td class=\"txttabl\" width=\"20\" bgcolor=\"#FFFFCC\">{$date}</td>";
echo " <td class=\"txttabl\" width=\"80\" bgcolor=\"#FFFFCC\"> {$titre}</td>";
echo " <td class=\"txttabl\" width=\"90\" bgcolor=\"#FFFFCC\">{$auteur} {$auteur2}</td>";
echo " <td class=\"txttabl\" width=\"200\" bgcolor=\"#FFFFCC\"> {$sujet}";
$ouou = "recherchefine";
taille2($taille, $numa, "", $ouou);
echo "<br>détail de l'article</a></td>";
echo " <td class=\"txttabl\" width=\"20\" bgcolor=\"#FFFFCC\">{$globalConfig}</td>";
echo "</tr>";
$i++;
}
}
echo "<tr><td colspan=5 align=right><a href=\"#bas\"><img src=\"../zimages/bas.gif\" width=\"25\" height=\"26\" border=\"0\" alt=\"aller en bas de page\"></a><a href=\"#haut\"><img src=\"../zimages/haut.gif\" width=\"25\" height=\"26\" border=\"0\" alt=\"aller en haut de page\"></a></td></tr>";
echo " </table><br> \n";
?>
<?php
}
if ($archives == "oui") {
?>
function rapide1($id_user, $service, $titou)
{
if ($id_user) {
//Si l'utilisateur est connecté, il voit les articles en rapport avec son niveau
//Chargement des données utilisateurs
$recordSalaries = new DatabaseRecord("salaries", $id_user);
$date_creation_salaries = $recordSalaries->date_creation_salaries;
//echo $_SESSION["date_creation_salaries"];
/* systeme d'exclusion ou non des infos deja lu */
// $result2 ="SELECT * FROM modes, articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = $id_user) WHERE lu.id_art is null and (modes.id_user = $id_user)";
$result2 = "SELECT * FROM articles left join lu on (articles.num_article = lu.id_art) and (lu.id_user = {$id_user}) WHERE lu.id_art is null ";
/* retrouver le niveau du user dans la table mode et sortir les articles en fonction de ce nivo modes */
//$result2 .= "and (articles.id_art_serv = '$service')";
//$result2 .= "and (articles.id_art_serv = modes.id_service)";
//$result2 .= "and (articles.nivo_conf <= modes.serv_conf)";
$result2 .= "and (articles.publica != 0)";
$result2 .= "and (articles.diffusion = '')" . "and (articles.date_modif>'" . $date_creation_salaries . "') ";
/* rajouter dans l'order l'ordre souhaité par l'utilisateur */
$result2 .= "order by date_modif desc";
} else {
////Si il est déconnecté, il ne voit seulement que les articles de niveau 1 des deux derniers mois {
$date_limite = date("Y-m-d", mktime(0, 0, 0, date("m") - 4, date("d"), date("Y")));
/* systeme d'exclusion ou non des infos deja lu */
$result2 = "SELECT * FROM articles WHERE ";
/* retrouver le niveau du user dans la table mode et sortir les articles en fonction de ce nivo modes */
//$result2 .= "(articles.id_art_serv = '$service')";
//$result2 .= "and (articles.id_art_serv = modes.id_service)";
//$result2 .= "and (articles.nivo_conf = '1') ";
$result2 .= " (articles.nivo_conf = '1') ";
$result2 .= "and (articles.publica != 0) ";
$result2 .= "and (articles.diffusion = '') ";
$result2 .= "and (articles.date_modif > '{$date_limite} 00:00:00' )";
/* rajouter dans l'order l'ordre souhaité par l'utilisateur */
$result2 .= "order by date_modif desc";
}
//echo $result2;
$requete = DatabaseOperation::query("{$result2}");
$total = mysql_num_rows($requete);
echo "<table width=\"100%\" border=\"0\" cellspacing=\"4\"><tr>";
if ($requete = @DatabaseOperation::query("{$result2}")) {
while ($rows = mysql_fetch_array($requete)) {
echo "<tr bgcolor=\"#FF3333\" class=\"logFFCC66\">";
/* affichage unique du service */
$variable = Lib::isDefined("variable", 0);
if ($variable != 1) {
$variable = 1;
$servik = DatabaseOperation::query("select * from services where id_service = '{$rows['id_art_serv']}'");
$rok = mysql_fetch_array($servik);
echo "{$rok['intitule_ser']}";
}
/* ------------
formatage date
------------- */
$date = $rows["date_crea"];
$jour = substr($date, 8, 2);
$mois = substr($date, 5, 2);
$annee = substr($date, 0, 4);
$date = $jour . "/" . $mois . "/" . $annee;
$titre_art = stripslashes($rows["titre_art"]);
$sujet = stripslashes($rows["sujet"]);
echo "<td class=\"titrtabl\" width=\"60\" bgcolor=\"#FFFFCC\">{$date}</td>";
echo "<td class=\"titrtabl\" width=\"43%\" bgcolor=\"#FFFFCC\">{$titre_art}</td>";
echo "<td class=\"titrtabl\" width=\"10%\" bgcolor=\"#FFFFCC\">";
$ab = DatabaseOperation::query("select * from salaries where id_user='******'");
$ligne = mysql_fetch_array($ab);
echo $ligne["nom"] . " " . $ligne["prenom"] . "</td>";
echo "<td class=\"titrtabl\" width=\"30%\" bgcolor=\"#FFFFCC\">{$sujet}<br>";
$nva = "nouveaute";
taille2($rows["taille"], $rows["num_article"], "", $nva);
echo "lien sur l'article</a></td>";
echo "<td class=\"titrtabl\" width=\"5%\" bgcolor=\"#FFFFCC\">" . $rows["nivo_conf"] . "</td>";
echo "<td align=\"center\" bgcolor=\"#FFFFCC\" width=\"2%\"><input type=\"checkbox\" name=\"" . $rows["num_article"] . "\" value=\"1\"></td>";
echo "<input type=hidden name=\"ids[]\" value=\"" . $rows["num_article"] . "\">";
}
}
echo "</tr></table>";
return $total;
}
