WEBWMS
/
invreportprint.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}
	$sql="";
	$allLoc="";
	$allcustcn="";
	$allcANDl="";
	/*if(isset($_GET['SQL'])){
		$sql = $_GET['SQL'];
		echo $sql;
	}*/
	if(isset($_SESSION['SQL1'])){
		//echo $_SESSION['SQL1'].'<br>';
		$sql=$_SESSION['SQL1'];
		//$sql = $sql." ORDER BY `showinv2`.`LOC` ASC";
		//echo $sql;
		$result=mysql_query($sql,$dbc);
		//$row_Rec=mysql_fetch_assoc($result);
		$resultLOC=mysql_query($sql,$dbc);
		while($row_Rec_LOC=mysql_fetch_assoc($resultLOC)){
			$allLoc=$allLoc.$row_Rec_LOC['LOC'].",";
			$allcustcn=$allcustcn.$row_Rec_LOC['custcn'].",";
			$allcANDl=$allcANDl.$row_Rec_LOC['LOC']."->".$row_Rec_LOC['custcn'].",";
		}
		$allLoc=rtrim($allLoc,",");
		$allcustcn=rtrim($allcustcn,",");
		$allcANDl=rtrim($allcANDl,",");
		//echo $allLoc;
		//echo $allcustcn;
	}
?>
<html>
<head>
<title>盘库单打印</title>
</head>
<body align="center">
<h2>盘库单</h2>
<table border = "0" cellpadding="0" cellspacing="0" width="100%">
<tr><td width="10%">盘库库位(带供应商)</td><td colspan="3" width="90%">
<?php echo $allcANDl;?>
</td></tr>
<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr><td>盘库日期</td><td>（手写）_____________________</td>
<td>盘库人员签字</td><td>（手写）_____________________</td></tr>
</table>
<br>
<table border = "1" cellpadding="1" cellspacing="1" width="100%">
<tr><td>行号</td><td>商品编码</td><td>批次号</td><td>商品中文</td><td>库位号</td><td>库存数量</td><td>实盘数量(手写)</td></tr>
<?php
//Id	LOTID	SKU	QTY	ASNID	VCODE	LOC	skucn	custcn
$i1=1;
while($row_Rec=mysql_fetch_assoc($result)){?>
<tr><td><?php echo $i1++;?></td>
<td align="center"><?php echo '<img src="./barcodegen/php1d.php?text='.$row_Rec['SKU'].'"/>'?></td>
<td><?php echo $row_Rec['LOTID']?></td>
<td><?php echo $row_Rec['skucn']?></td>
<td align="center"><?php echo '<img src="./barcodegen/php1d.php?text='.$row_Rec['LOC'].'"/>'?></td>
<td><?php echo $row_Rec['QTY']?></td>
<td></td></tr>
<?php } ?>
</table>
</body>
<p align="right">
打印时间：
<?php date_default_timezone_set("Etc/GMT-8");
	echo date('Y-m-d h:i:s',time());?>
</p>
<script type="text/javascript">
	window.print();
</script>
</html>