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 121 122 123 124 125 126 127
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html>
<head>
<link rel="stylesheet" type="text/css" href="../style.css">
<script src="jquery.js" type="text/javascript"></script>
<script src="jquery.maskedinput.js" type="text/javascript"></script></head>
<body >
<script type="text/javascript">
$(document).ready(function(){
$("#durprevh").mask("99:99");
});
</script>
<?php
include ($_SERVER["DOCUMENT_ROOT"]."/intra/_connexion.php");
?>
<table width="100%" align="center" bgcolor="#FFFFFF">
<tr>
<td height="18" valign="middle">
<div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif">
</font><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif">|
<a href="menu.php">Retour</a></font>
</div>
</tr>
</table>
<form name="form2" action="ajout_trav.php" method="POST">
<title> Dossier en cours</title>
<table width="100%" align="center">
<?php
if (isset($_POST['num_dossier'])) {
$numdossier=$_POST['num_dossier'];
}else {
$numdossier=$_GET['num_dossier'];
}
$sql = "SELECT num_dossier, num_immat,client FROM fiche where num_dossier='$numdossier'";
$sql_result = $mysqli->query($sql) or die('Erreur SQL !'.$sql.' ' .$mysqli->error);
$row = mysqli_fetch_array($sql_result);
?>
<H3>Dossier en cours</H3>
<div>
<p><label for="numimmat">Immatriculation:</label>
<?php echo strtoupper($row['num_immat']) ?></p>
<label for="numdossier">Nº Dossier:</label>
<?php echo strtoupper($row['num_dossier']) ?></p>
<input name="num_dossier" id="num_dossier" type="hidden" value="<?=$row['num_dossier']?>" >
<label for="client">Client:</label>
<?php echo strtoupper($row['client']) ?></p>
</div>
</table>
<table width="100%" align="center">
<H3>Attribution des travaux</H3>
<td><label for="nomtech">Choix du technicien :</label></td>
<td>
<?php
$sql = "SELECT cbarre_tech FROM technicien";
$sql_result = $mysqli->query($sql) or die('Erreur SQL !'.$sql.' ' .$mysqli->error);
while ($row = mysqli_fetch_array($sql_result))
{
$ntech = $row["cbarre_tech"];
@$option_block .= "<OPTION value=\"$ntech\">$ntech</OPTION>";
}
?>
<select name="tech" id="tech" STYLE="COLOR: #000000; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; width:250px;" class="majuscule";>;
<option value=""> </option>
<?php echo "$option_block"; ?> </select> <font size="1" face="Verdana, Arial, Helvetica, sans-serif" style="align:center;">
</td>
<tr>
<td><label for="spe">Travaux :</label></td>
<td>
<?php
$sql = "SELECT nom_cat FROM categorie ";
$sql_result = $mysqli->query($sql) or die('Erreur SQL !'.$sql.' ' .$mysqli->error);
while ($row = mysqli_fetch_array($sql_result))
{
$spe = $row["nom_cat"];
@$option_block1 .= "<OPTION value=\"$spe\">$spe</OPTION>";
}
?>
<select name="spe_tech" id="spe_tech" STYLE="COLOR: #000000; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; width:250px;" class="majuscule"; >
<option value=""> </option>
<?php echo "$option_block1"; ?> </select> <font size="1" face="Verdana, Arial, Helvetica, sans-serif" style="align:center;">
</td>
<tr>
<td><label for="dur_prev">Durée des travaux :</label></td>
<tr>
<td>
<td><label> Heures:Minutes</label>
<input name="durprevh" id="durprevh" type="texte" STYLE="COLOR: #000000; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; text-align: center;"/></td><tr>
<td>
<td align="center">
<p><button type="submit" > Ajouter</button></p>
</td>
</table>
</form>
<table width="80%" align="center" bgcolor="#FFFFFF">
<tr>
<td width="100%" colspan="5"> <p><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
$Requete ="SELECT ident_trav,num_dossier,cbarre_tech,nom_cat,dur_pre FROM travaux where num_dossier='$numdossier'";
$Req = $mysqli->query($Requete) or die('Erreur SQL !'.$Requete.' ' .$mysqli->error);
echo "<table font size=\"2\" class=\"texte\" width=\"100%\" border=\"1\" bordercolor=\"#000066\" cellspacing=\"0\" align=\"center\" face=\"Arial\">";
echo "<tr>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Nº dossier</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Nom Tech.</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Travaux</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Durée prévue</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Supp.</td>";
echo "</tr>";
while($Result = mysqli_fetch_array($Req))
{
echo "<tr>";
echo "<td align=\"center\">". stripslashes(strtoupper($Result['num_dossier']))." </td>";
echo "<td align=\"center\">". stripslashes(strtoupper($Result['cbarre_tech']))." </td>";
echo "<td align=\"center\">". stripslashes(strtoupper($Result['nom_cat']))." </td>";
echo "<td align=\"center\">". stripslashes(strtoupper($Result['dur_pre']))." </td>";
echo "<td WIDTH=3% align=\"center\"><input type=\"button\" value=\"Sup.\" style=\"FONT-FAMILY: Verdana; FONT-SIZE: 8pt\" OnClick=\"window.location='supp_trav.php?ident_trav=".$Result['ident_trav']."&&num_dossier=".$Result['num_dossier']."'\"></td>";
}
echo "</table>";
mysqli_free_result($Req);
?>
</body>
</html> |
Partager