function afficher_liste_gtanieres() { $lien = "/tanieres/tanieres.php?taniere=new"; $button = "<input type='button' onClick='Javascript:document.location.href=\"{$lien}\"' value='Ajouter une tanière'"; $button .= " class='mh_form_submit'>"; $position = "Tris en distance en PA, Position de départ : <br>"; $position .= "X=" . formulaire_listbox("x_troll", -150, 150, 1, $_REQUEST['x_troll'], "plusmoins", "yes", true, false); $position .= "Y=" . formulaire_listbox("y_troll", -150, 150, 1, $_REQUEST['y_troll'], "plusmoins", "yes", true, false); $position .= "Z=" . formulaire_listbox("z_troll", 0, 100, 1, $_REQUEST['z_troll'], "plusmoins", "yes", true, false); $lien_base = "/tanieres/tanieres.php?taniere=liste&nb_ppage={$nb_ppage}&criteres="; $position .= " <input type='submit' value='Trier' class='mh_form_submit'>"; echo "<form name='trieForm' action='{$lien_base}' method='POST'>"; afficher_titre_tableau("Les Grandes Tanières", $button . "<br><br>" . $position); echo "</form>"; $lesGTanieres = selectDbGrandesTanieres(); $debut = $_REQUEST['debut']; $order = $_REQUEST['order']; $criteres = $_REQUEST['criteres']; $nb_ppage = $_REQUEST['nb_ppage']; if (!isset($debut)) { $debut = 0; } if ($criteres == "") { $criteres = 'nom_gtaniere'; } if ($nb_ppage == "") { $nb_ppage = 10; } $lien_base = "/tanieres/tanieres.php?taniere=liste&"; $lien_base .= "x_troll=" . $_REQUEST['x_troll']; $lien_base .= "&y_troll=" . $_REQUEST['y_troll']; $lien_base .= "&z_troll=" . $_REQUEST['z_troll']; $lien_base .= "&criteres="; ?> <table class='mh_tdborder' width='60%' align='center'> <tr> <td> <table width='100%' cellspacing='0'> <tr class='mh_tdtitre' align="center"> <td> Nombre de tanières par page : <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=10"; ?> '>10</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=50"; ?> '>50</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=100"; ?> '>100</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=200"; ?> '>200</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=500"; ?> '>500</a> <table width='100%' class='mh_tdpage' cellpadding=2> <?php $lien_base = "/tanieres/tanieres.php?taniere=liste&nb_ppage={$nb_ppage}&criteres="; $x_troll = $_REQUEST['x_troll']; $y_troll = $_REQUEST['y_troll']; $z_troll = $_REQUEST['z_troll']; $nbtotal = selectDbGrandesTanieresCount(); $lesGTanieres = selectDbGrandesTanieres("", $debut, $nb_ppage, $criteres, $order, $x_troll, $y_troll, $z_troll); $nbGTanieres = count($lesGTanieres); if (is_numeric($x_troll) && is_numeric($y_troll) && is_numeric($z_troll)) { usort($lesGTanieres, "callbackSortDistancePa"); } $criteres .= "&x_troll=" . $x_troll; $criteres .= "&y_troll=" . $y_troll; $criteres .= "&z_troll=" . $z_troll; $barre_nav = construct_barre_navigation($debut, $nbGTanieres, $nbtotal, $cfg_nbres_ppage, $nb_ppage, $lien_base, $criteres, $order); $i = 0; $j = 0; while (list($key, $res) = each($lesGTanieres)) { $j++; if ($j < $debut) { next; } if ($j > $nb_ppage) { break; } if ($i % 10 == 0) { afficher_entete_liste_gtaniere($lien_base, $criteres, $order, $x_troll, $y_troll, $z_troll); } $res = $lesGTanieres[$i]; afficher_ligne_gtaniere($res, $x_troll, $y_troll, $z_troll); $i++; } ?> </table> <?php echo $barre_nav; ?> </td> </tr> </table> </tr> </td> </table><br> <?php }
function afficherListeTrollAnatomique() { global $db_vue_rm; $debut = $_REQUEST['debut']; $order = $_REQUEST['order']; $criteres = $_REQUEST['criteres']; $nb_ppage = $_REQUEST['nb_ppage']; if (!isset($debut)) { $debut = 0; } if ($criteres == "") { $criteres = 'nom_troll'; } if ($nb_ppage == "") { $nb_ppage = 10; } $lien_base = "/anatomique/anatomique.php?id_troll=liste&criteres="; ?> <table class='mh_tdborder' width='60%' align='center'> <tr> <td> <table width='100%' cellspacing='0'> <tr class='mh_tdtitre' align="center"> <td> Nombre de trolls par pages : <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=10"; ?> '>10</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=50"; ?> '>50</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=100"; ?> '>100</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=200"; ?> '>200</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=500"; ?> '>500</a> <table class='mh_tdpage' width='100%' cellpadding=2> <?php $lien_base = "/anatomique/anatomique.php?id_troll=liste&nb_ppage={$nb_ppage}&criteres="; $nbtotal = selectDbAnalyseAnatomiqueCount(); $lesAnats = selectDbAnalyseAnatomique("", $debut, $nb_ppage, $criteres, $order); $nbAnats = count($lesAnats); $barre_nav = construct_barre_navigation($debut, $nbAnats, $nbtotal, $cfg_nbres_ppage, $nb_ppage, $lien_base, $criteres, $order); for ($i = 1; $i <= $nbAnats; $i++) { if (($i - 1) % 10 == 0) { afficherEnteteListeAnatomique($lien_base, $criteres, $order); } $res = $lesAnats[$i]; echo afficher_ligne_anatomique($res); } echo "</table>"; echo $barre_nav; ?> </td> </tr> </table> </tr> </td> </table><br> <?php }
function afficherListeBugs() { global $db_vue_rm; $debut = $_REQUEST['debut']; $order = $_REQUEST['order']; $criteres = $_REQUEST['criteres']; $nb_ppage = $_REQUEST['nb_ppage']; $outil = $_REQUEST['outil']; if ($debut == "" && $order == "" && $criteres == "" && $nb_ppage == "" && $outil == "") { $criteres = 'etat_bug, type_bug desc, criticite_bug desc'; $nb_ppage = 50; } if (!isset($debut)) { $debut = 0; } //if ($criteres == "") if ($nb_ppage == "") { $nb_ppage = 10; } $lien_base = "/bugs.php?outil={$outil}&criteres="; afficherListeBugsJs(); ?> <table class='mh_tdborder' width='100%' align='center'> <tr> <td> <table width='100%' cellspacing='0'> <tr class='mh_tdtitre' align="center"> <td><form name='formList'> Nombre de bugs par pages : <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=10"; ?> '>10</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=50"; ?> '>50</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=100"; ?> '>100</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=200"; ?> '>200</a> <a href='<?php echo $lien_base . $criteres . "&order=" . $order . "&nb_ppage=500"; ?> '>500</a> <br>Tri pratique : <a href='<?php echo $lien_base; ?> etat_bug,type_bug desc,criticite_bug desc&order=&nb_ppage=50'>État, types et criticité</a> <br>Filtrer <?php echo "<select name='outil' onChange='Javascript:changeOutil();'>"; afficher_listbox_select("", $outil, "Tous"); afficher_listbox_select("bestiaire", $outil); afficher_listbox_select("bugs", $outil); afficher_listbox_select("firemago", $outil_touche_bug); afficher_listbox_select("gps", $outil); afficher_listbox_select("ggc", $outil); afficher_listbox_select("recherchator", $outil); afficher_listbox_select("rg", $outil); afficher_listbox_select("stats", $outil); afficher_listbox_select("trombinoscope", $outil_touche_bug); afficher_listbox_select("vue2d", $outil); afficher_listbox_select("vtt", $outil); afficher_listbox_select("autre", $outil); echo "</select></form>"; ?> <table class='mh_tdpage' width='100%' cellpadding=2> <?php $lien_base = "/bugs.php?outil={$outil}&nb_ppage={$nb_ppage}&criteres="; $nbtotal = selectDbBugsCount(); $lesBugs = selectDbBugs("", $outil, $debut, $nb_ppage, $criteres, $order); $nbBugs = count($lesBugs); $barre_nav = construct_barre_navigation($debut, $nbBugs, $nbtotal, $cfg_nbres_ppage, $nb_ppage, $lien_base, $criteres, $order); for ($i = 1; $i <= $nbBugs; $i++) { if (($i - 1) % 10 == 0) { afficherEnteteListeBugs($lien_base, $criteres, $order); } $res = $lesBugs[$i]; $etat_bug = $res[etat_bug]; $criticite_bug = $res[criticite_bug]; $type_bug = $res[type_bug]; $description_bug = stripslashes($res[description_bug]); // Si la description est trop longue, on la coupe if (strlen($description_bug) >= 85) { $description_bug = substr($description_bug, 0, 85) . "..."; } if ($etat_bug == "clos") { $etat_c = "bbbbff"; } elseif ($etat_bug == "en-cours") { $etat_c = "161"; } elseif ($etat_bug == "ouvert") { $etat_c = "911"; } if ($criticite_bug == "basse") { $criticite_c = "117"; } elseif ($criticite_bug == "moyenne") { $criticite_c = "F42"; } else { //if ($criticite_bug == "haute") $criticite_c = "911"; } if ($type_bug == "souhait") { $type_c = "117"; } else { //$type_bug == "bug") $type_c = "911"; } $classe = "ligne invisible"; if ($etat_bug == "clos") { $etat_c = ""; $type_c = ""; $criticite_c = ""; $classe = "ligne "; } elseif ($etat_bug == "en-cours") { $etat_c = "161"; } elseif ($etat_bug == "ouvert") { $etat_c = "911"; } $lien = "href='bugs.php?bug={$res['id_bug']}'"; //echo "<tr class='$classe' onmouseover=\"this.className='item-mouseover'\""; //echo " onmouseout=\"this.className='$classe'\" >"; echo "<tr class='mh_tdpage'>"; echo "<td><a {$lien}>{$res['id_bug']}</a></td>"; echo "<td><a {$lien}>{$res['outil_touche_bug']}</a></td>"; echo "<td style='background-color:#{$criticite_c};'><a {$lien}>{$criticite_bug}</a></td>"; echo "<td style='background-color:#{$type_c};'><a {$lien}>{$type_bug}</a></td>"; echo "<td style='background-color:#{$etat_c};'><a {$lien}>{$etat_bug}</a></td>"; echo "<td><a {$lien}>" . stripslashes($res[nom_emetteur]) . " ({$res['id_troll_emetteur_bug']})</a></td>"; echo "<td><a {$lien}>" . stripslashes($res[nom_responsable]) . " ({$res['id_troll_responsable_bug']})</a></td>"; echo "<td><a {$lien}>" . date('d/m/y H:i', $res[date_ouverture_bug]) . "</a></td>"; echo "<td><a {$lien}>"; if (date('d/m/y H:i', $res[date_cloture_bug]) != "01/01/70 01:00") { echo date('d/m/y H:i', $res[date_cloture_bug]); } echo "</a></td>"; echo "<td><a {$lien}>{$description_bug}</a></td>"; echo "</tr>"; } echo "</table>"; echo $barre_nav; ?> </td> </tr> </table> </tr> </td> </table><br> <?php }