</tr>
<tr>
<td colspan="2" class="txt"><?php
$formate = stripslashes($titre1[1]);
$formate = substr($formate, 0, 150);
echo "{$formate} ...";
?>
</td>
</tr>
<tr>
<td width="90%" height="26"><?php
taille($titre1[4], $titre1[3]);
?>
détail de l'article</a></td>
<td valign="top" width="20" align="right"><img src="../zimages/<?php
$nom = imagelu($titre1[3], $id_user);
echo "{$nom}";
?>
" width="20" height="24"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="lelien" colspan="2">
<?php
actifs($id_user);
?>
<table width="100%" border="0" cellspacing="4" name="tab04">
<tr>
<td class="titrtabl" width="24%">date de création</td>
function listing($id_user, $service, $page)
{
/* -- $n varible qui defini le nombre de ligne qui s'affichent dans le listing -- */
if ($id_user) {
//Si l'utilisateur est connécté
$affichage = DatabaseOperation::query("select * from perso where id_user={$id_user}");
$na = mysql_fetch_array($affichage);
}
if (!$na[nbligne]) {
$nb = 20;
} else {
$nb = $na[nbligne];
}
/* --- choix de l'order en fonction du choix utilisateur et definition si po encore inscrit --- */
if (!$na[date]) {
$order = "desc";
} else {
if ($na[date] == 1) {
$order = "";
} else {
if ($na[date] == 2) {
$order = "desc";
}
}
}
if ($id_user) {
//Si l'utilisateur est connecté
/* systeme d'exclusion ou non des infos deja lu */
if (!$na[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})";
} else {
if ($na[lu] == 1) {
$result2 = "SELECT * FROM articles, modes WHERE (modes.id_user = {$id_user}) ";
} else {
if ($na[lu] == 2) {
$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})";
}
}
}
/* 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 = modes.id_service)";
$result2 .= "and (articles.nivo_conf <= modes.serv_conf)";
/* ---- defini la page service sur laquelle on se trouve ---- */
$result2 .= "and (articles.id_art_serv = '{$service}')";
//$result2 .= "and (articles.homepage = '4') ";
$result2 .= "and (articles.publica != '')";
$result2 .= "and (articles.diffusion = '')";
/* rajouter dans l'order l'ordre souhaité par l'utilisateur */
$result2 .= "order by date_modif {$order} ";
} else {
/* systeme d'exclusion ou non des infos deja lu */
/*
if(!$na[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)";}
else if($na[lu]==1){$result2 ="SELECT * FROM articles, modes WHERE (modes.id_user = $id_user) ";}
else if($na[lu]==2){$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 .= "and (articles.id_art_serv = modes.id_service)";
$result2 .= "and (articles.nivo_conf <= modes.serv_conf)";
$result2 .= "and (articles.id_art_serv = '$service')";
//$result2 .= "and (articles.homepage = '4') ";
$result2 .= "and (articles.publica != '')";
$result2 .= "and (articles.diffusion = '')";
$result2 .= "order by date_modif $order ";
*/
$date_limite = date("Y-m-d", mktime(0, 0, 0, date("m") - 4, date("d"), date("Y")));
$result2 = "SELECT * FROM articles WHERE ";
/* retrouver le niveau du user dans la table mode et sortir les articles en fonction de ce nivo modes */
//$test .= " and (articles.id_art_serv = modes.id_service)";
$result2 .= " (articles.nivo_conf = '1')";
// $test .= " and (articles.homepage = '$homepage') ";
/* ---- defini la page service sur laquelle on se trouve ---- */
$result2 .= " and (articles.id_art_serv = '{$service}') ";
$result2 .= " and (articles.publica != '') ";
$result2 .= " and (articles.diffusion = '') ";
$result2 .= "and (articles.date_modif > '{$date_limite} 00:00:00' ) ";
/* --- on rajoute la fonction du non lu pour ordonner si on le souhaite --- */
$result2 .= "order by articles.nivo_conf desc, date_modif DESC limit 0,1";
}
if (empty($page)) {
$page = 1;
}
$requete = DatabaseOperation::query("{$result2}");
$total = mysql_num_rows($requete);
$debut = ($page - 1) * $nb;
$result2 .= "LIMIT {$debut},{$nb}";
if ($requete = @DatabaseOperation::query("{$result2}")) {
while ($rows = mysql_fetch_array($requete)) {
echo "<tr bgcolor=\"#FFFFCC\">";
/* ------------
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;
$titreart = stripslashes($rows[titre_art]);
$auteurart = stripslashes($rows[auteur]);
$sujetart = stripslashes($rows[sujet]);
echo "<td class=\"txttabl\" width=\"22%\">{$date}</td>";
echo "<td class=\"txttabl\" width=\"24%\">{$titreart}</td>";
echo "<td class=\"txttabl\" width=\"24%\">";
$ab = DatabaseOperation::query("select * from salaries where id_user='******'");
$ligne = mysql_fetch_array($ab);
echo "{$ligne['nom']} {$ligne['prenom']}</td>";
echo "<td class=\"txttabl\" width=\"24%\">{$sujetart}<br>";
taille($rows[taille], $rows[num_article]);
echo "détail de l'article</a></td>";
echo "<td align=\"center\" bgcolor=\"#FFFFFF\"><img src=\"../zimages/";
$nomimg = imagelu($rows[num_article], $id_user);
echo "{$nomimg}";
echo "\" width=\"20\" height=\"24\"></td>";
}
}
echo "</tr>";
echo "</table>";
echo "<table width=\"100%\" border=\"0\" cellspacing=\"4\">";
echo "<tr>";
echo "<td width=80% align=center>";
$nbpages = ceil($total / $nb);
for ($i = 1; $i <= $nbpages; $i++) {
echo "<a href=\"{$PHP_SELF}?page={$i}&service={$service}\"><font size=1 color=#000000><b>";
if ($page == $i) {
echo "<font color=#FF6600><b> page{$i} </b></font></a>\n";
} else {
echo "<font color=#000000><b> page{$i} </b></font></a>\n";
}
if ($i < $nbpages) {
echo " - ";
}
}
echo "</td>";
}
