| 12
 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