master

分支 (1)

管理

管理

master

WEBWMS
/
receivereport.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	//echo 'abc';

	if(isset($_GET['id'])){
		$id=$_GET['id'];
		//echo $id;
		$sql="SELECT *
  			  FROM `asnh`
			  INNER JOIN `asnd` ON `asnh`.ID = `asnd`.ID
			  WHERE  `asnh`.`ID` =$id";
		$result=mysql_query($sql,$dbc);
		$row_Rec=mysql_fetch_assoc($result);
	}
/*
ID	ASNID	ASNState	CUSTID	CUSTMNO	REVTIME	BUSINO	INBONO	CARRNO	TGW	TVOL	SHIPTO	SHIPFROM	CHEPAI	BAIKAHAO	REMARK	REF01	PKGTYPE	nID	ID	ASNID	ITEMNO	SKU	SKUCN	SKUEN	VEDCODE	UOM	UOMNUM	FDUNIT	TWEIGHT	UNITWEIGHT	SKUN	CUSTMITEM	COO	UNITPRICE	TPRICE	LOC
**/
?>
<html>
<head>
<title>收货单打印</title>
</head>
<body align="center">
<h2>收货单</h2>
<table border = "0" cellpadding="0" cellspacing="0" width="100%">
<tr><td>ASN编号</td><td><?PHP echo $row_Rec['ASNID']?></td>
<td>客户ID</td><td><?PHP echo $row_Rec['CUSTID']?></td>
<td>ASN创建时间</td><td><?PHP echo $row_Rec['REVTIME']?></td></tr>
<tr><td>入库单号</td><td><?PHP echo $row_Rec['INBONO']?></td>
<td>订单编号</td><td><?PHP echo $row_Rec['BUSINO']?></td>
<td>送货车牌</td><td><?PHP echo $row_Rec['CHEPAI']?></td></tr>
</table>
<table border = "1" cellpadding="1" cellspacing="1" width="100%">
<tr><td>行号</td><td>商品编码</td><td>商品中文名</td><td>收货数量</td><td>实收库位(手写)</td></tr>
<?php
	$i1=1;
	$tqty=0;
	do{?>
	<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['SKUCN']?>
		</td>
		<td align="center">
<?php echo '<img src="./barcodegen/php1d.php?text='.$row_Rec['UOMNUM'].'"/>';
		$tqty = $tqty + $row_Rec['UOMNUM'];
?>
		</td>
		<td></td>
	</tr>
<?php }while($row_Rec=mysql_fetch_assoc($result));?>
</table>
<p align="right">应收总数：<?php echo $tqty?></p>
<br><br>
<p align="right">收货人签字：______________________</p>
</body>
<script type="text/javascript">
	window.print();
</script>
</html>