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
|
<table width="100%" align="center" bgcolor="#FFFFFF">
<tr>
<td width="100%" colspan="5"> <p><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?
$sql1= "SELECT nom_parc FROM parc order by nom_parc";
$sql_result1 = mysql_query($sql1) or die("Couldn't execute query1.");
while ($row1 = mysql_fetch_array($sql_result1)) {
$varorig = $row1 ["nom_parc"];
@$option_block1 .= "<OPTION value=\"$varorig\">$varorig</OPTION>";
}
$Requete = mysql_query("SELECT client,origine,stock,chassis,types,couleurs,MAX(datesortie) as datesort
FROM vn
WHERE stock = $numstock
group by client,stock");
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\">Num. Stock</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Num. Chassis</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Type</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Couleurs</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Client</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">Origine</td>";
echo "<td WIDTH=3% align=\"center\" bgcolor=\"#DBE8E8\">Choix du Parc</td>";
echo "<td align=\"center\" bgcolor=\"#DBE8E8\">valider</td>";
echo "</tr>";
while($Result = mysql_fetch_array($Requete))
{
echo "<tr>";
echo "<td align=\"center\">". stripslashes($Result['stock'])." </td>";
echo "<td align=\"center\">". stripslashes($Result['chassis'])." </td>";
echo "<td align=\"center\">". stripslashes($Result['types'])." </td>";
echo "<td align=\"center\">". stripslashes($Result['couleurs'])." </td>";
echo "<td align=\"center\">". stripslashes($Result['client'])." </td>";
echo "<td align=\"center\">". stripslashes($Result['origine'])." </td>";
?>
<td><select name="nparc" id="nparc" STYLE="COLOR: #000000; FONT-FAMILY: Verdana; FONT-SIZE: 8pt">
<option value=""></option><? echo "$option_block1"; ?></select></td>
<?
echo "<td WIDTH=3% align=\"center\"><input type=\"button\" value=\"Valider Parc\" style=\"FONT-FAMILY: Verdana; FONT-SIZE: 8pt\" OnClick=\"window.location='import_parc.php?p_chassis=".$Result['chassis']."&&p_stock=".$Result['stock']."&&p_parc=".$varorig."&&p_datentree=".date("Y-m-d")."'\"></td>";
}
echo "</table>";
?>
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></p></td>
</tr>
</table> |
Partager