<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>|| Validate VPN || - LogsysWMS</title>
</head>

<body>
<?PHP
ini_set('max_execution_time', 350);
include ("../Conections/SecurityAccess.php");

	
$sql=mysql_query("SELECT * FROM `tabla_inventario` WHERE `CVE_CUENTA`='27' and `CANTIDAD`>'0' and (`TIPO_UBICACION` is null or `TIPO_UBICACION`='')");
while($res=mysql_fetch_array($sql))
{///Inicia While 01
$Id_Res = $res['ID'];
$Sku_Res = $res['SKU'];
$Can_Res = $res['CANTIDAD'];
$Pal_Res = $res['NO_PALLET'];
	
	
	
	$sql_Mod="UPDATE tabla_inventario SET TIPO_UBICACION='STOCK' WHERE SKU='$Sku_Res' AND ID='$Id_Res' AND CANTIDAD='$Can_Res' AND NO_PALLET='$Pal_Res'";
	$resultado_Mod=mysql_query($sql_Mod,$conexion) or die(mysql_error());
	
	
}///Termna While 01

echo "<META HTTP-EQUIV=Refresh CONTENT='0; URL=TipoUbicacion2.php'>";
				
?>
</body>
</html>
