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
}
