1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
| <html>
<head>
<title>Detail_Intervention</title>
<link href="css/style2.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php
$connect=mysql_connect("localhost", "root", "") or die ("Echec de la connexion au serveur !");
$select=mysql_select_db("telegestion_client");
if (isset($_GET["nom"]) && isset ($_GET["ville"])) {
$nom=$_GET["nom"].$ville=$_GET["ville"];
} else {
$nom = '';
$ville = '';
}
$sql = ' SELECT DISTINCT telegestion_client.`nom` , telegestion_client.`ville` '
. ' FROM telegestion_client'
. ' JOIN complementaire'
. ' ON telegestion_client.`nom` = complementaire.`nom` && telegestion_client.`ville` = complementaire.`ville` '
. " WHERE telegestion_client.`nom` = '".$nom."' AND telegestion_client.`ville` = '".$ville."' ";
$query="select * from complementaire";
if(isset($_GET["test"]))
switch($_GET["test"])
{
case 1 : $query="select * from complementaire order by nom asc"; break;
case 2 : $query="select * from complementaire order by nom desc"; break;
case 3 : $query="select * from complementaire order by ville asc"; break;
case 4 : $query="select * from complementaire order by ville desc"; break;
case 5 : $query="select * from complementaire order by date asc"; break;
case 6 : $query="select * from complementaire order by date desc"; break;
case 7 : $query="select * from complementaire order by materiel asc"; break;
case 8 : $query="select * from complementaire order by materiel desc"; break;
case 9 : $query="select * from complementaire order by probleme asc"; break;
case 10 : $query="select * from complementaire order by probleme desc"; break;
case 11 : $query="select * from complementaire order by travaux asc"; break;
case 12 : $query="select * from complementaire order by travaux desc"; break;
case 13 : $query="select * from complementaire order by technicien asc"; break;
case 14 : $query="select * from complementaire order by technicien desc"; break;
case 15 : $query="select * from complementaire order by nb_heures_intervention asc"; break;
case 16 : $query="select * from complementaire order by nb_heures_intervention asc"; break;
default : $query="select * from complementaire";
}
$result=mysql_query($query);
$totenrege=mysql_num_rows($result);
echo "<form action='affichage_detail_intervention.php' method='get' name='affichage_detail_intervention' enctype='multipart/form-data'>";
echo "<form action='affichage_detail_intervention.php' method='get' name='affichage_detail_intervention' enctype='multipart/form-data'>";
echo "<table width=100% border=1 align=center>";
echo "<tr bgcolor='#000000'>";
if ($totenrege==0)
echo "<td colspan=9><h2>IL N'Y A PAS D'INFO DE CLIENTS</td>";
else
{echo "<td colspan=9><h2>IL Y A ".$totenrege." CLIENT(S)</td>";
echo "</tr>";
echo "<tr align=center bgcolor=#87CEEB>";
echo "<td><b><h4 class='h41'>nom <a href='affichage_detail_intervention.php?test=1'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=2'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>ville <a href='affichage_detail_intervention.php?test=3'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=4'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>date <a href='affichage_detail_intervention.php?test=5'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=6'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>materiel <a href='affichage_detail_intervention.php?test=7'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=8'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>probleme <a href='affichage_detail_intervention.php?test=9'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=10'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>travaux <a href='affichage_detail_intervention.php?test=11'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=12'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>technicien <a href='affichage_detail_intervention.php?test=13'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=14'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "<td><b><h4 class='h41'>nb_heures_intervention <a href='affichage_detail_intervention.php?test=15'><img border=0 src='http://127.0.0.1/Telegestion/images/haut.gif'><a> <a href='affichage_detail_intervention.php?test=16'><img border=0 src='http://127.0.0.1/Telegestion/images/bas.gif'><a></b></td>";
echo "</tr>";
}
echo "</form>";
$i=0;
while ($row=mysql_fetch_array($result))
{
if ($i==0)
{
echo "<tr bgcolor=#D3D3D3>";
$i++;
}
else
{
echo "<tr bgcolor=#FFFFFF>";
$i--;
}
echo "<td><h5>".$row["nom"]."</td>";
echo "<td><h5>".$row["ville"]."</td>";
echo "<td><h5>".$row["date"]."</td>";
echo "<td><h5>".$row["materiel"]."</td>";
echo "<td><h5>".$row["probleme"]."</td>";
echo "<td><h5>".$row["travaux"]."</td>";
echo "<td><h5>".$row["technicien"]."</td>";
echo "<td><h5>".$row["nb_heures_intervention"]."</td>";
echo "<tr>";
}
echo "</table>";
echo "<br><br>";
echo "<table width=50% align=center>";
echo "<tr>";
echo "</tr>";
echo "</table>";
?>
</body>
</html> |