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; }