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
| case "069" :
echo "<TR>";
echo "<TD BGCOLOR=lightblue>DLC/OL*</TD>";
echo "<TD BGCOLOR=lightblue>Lot</TD>";
echo "<TD BGCOLOR=lightblue>Quantité</TD>";
echo "<TD BGCOLOR=lightblue>Nb Pal</TD>";
echo "<TD BGCOLOR=lightblue>Date entree</TD>";
echo "<TD BGCOLOR=lightblue>Emplacement</TD>";
echo "</TR>";
$result=mysql_query( "SELECT olligne, ref, DATE_FORMAT( entree , '%d/%m/%Y') , empla, qte, idx_palette FROM emplacement WHERE stock='$client' AND ref='$ref'") or die( mysql_error());
mysql_select_db("alltransports") or die("Could not select database");
while ( list( $olligne, $ref , $entree, $empla, $qte , $idx_palette ) = mysql_fetch_row( $result ) )
{
$batch='';
//$details=mysql_query( "SELECT batch,quantite FROM demisas_ean WHERE idx_entree='$idx_palette'") or die( mysql_error());
$details=mysql_query( "SELECT lot, qte FROM europac_details WHERE idx_palette='$idx_palette'") or die( mysql_error());
if ( mysql_num_rows( $details ) != 0 )
{
list( $item,$datefab ) = mysql_fetch_row( $details );
}
echo "<TR>";
echo "<TD BGCOLOR=lightblue>$olligne</TD>";
echo "<TD BGCOLOR=lightblue>$item</TD>";
echo "<TD BGCOLOR=lightblue>$datefab</TD>";
echo "<TD BGCOLOR=lightblue>$qte</TD>";
echo "<TD BGCOLOR=lightblue>$entree</TD>";
echo "<TD BGCOLOR=lightblue>$empla</TD>";
echo "</TR>";
}
break;; |
Partager