<table height="73" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<?php
$i=0;
$rlt2=mysql_query("select in_wh_record.*,prod.name,prod.model,prod.coding,wh_units.wh_units_name from in_wh_record,prod,wh_units where in_wh_record.docu_id='$id' and in_wh_record.prod_id=prod.id and in_wh_record.units=wh_units.id and in_wh_record.inorout='in' order by in_wh_record.id DESC limit 0,5"); while($row2=mysql_fetch_object($rlt2))
{
?>
<tr>
<td width="123" height="23" bgcolor="#FFFFFF"> <?php echo $row2->coding?></td>
<td width="153" bgcolor="#FFFFFF"> <?php echo $row2->name;?></td>
<td width="146" bgcolor="#FFFFFF"> <?php echo $row2->model;?></td>
<td width="50" align="center" bgcolor="#FFFFFF"> <?php echo $row2->wh_units_name?></td>
<td width="94" bgcolor="#FFFFFF"> <?php echo $row2->num?></td>
<td width="149" bgcolor="#FFFFFF"> <?php echo $row2->price?></td>
<td width="225" bgcolor="#FFFFFF"> <?php echo $row2->amount?> </td>
</tr> <?php $i++;}?>
<tr>
<td height="23" bgcolor="#FFFFFF">页小计:</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="center" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> 这里是数量页小计</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> 这里是金额页小计</td>
</tr>
<tr>
<td height="23" bgcolor="#FFFFFF">合计:</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="center" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> <?php $rlt5=mysql_query("select sum(t1.num) from ( select num from in_wh_record where docu_id ='$id') t1");$row5=mysql_fetch_array($rlt5); echo $row5[0]?></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> <?php $rlt6=mysql_query("select sum(t1.amount) from ( select amount from in_wh_record where docu_id ='$id') t1");$row6=mysql_fetch_array($rlt6); echo $row6[0]?></td>
</tr>
</table>
<?php
$i=0;
$rlt2=mysql_query("select in_wh_record.*,prod.name,prod.model,prod.coding,wh_units.wh_units_name from in_wh_record,prod,wh_units where in_wh_record.docu_id='$id' and in_wh_record.prod_id=prod.id and in_wh_record.units=wh_units.id and in_wh_record.inorout='in' order by in_wh_record.id DESC limit 0,5"); while($row2=mysql_fetch_object($rlt2))
{
?>
<tr>
<td width="123" height="23" bgcolor="#FFFFFF"> <?php echo $row2->coding?></td>
<td width="153" bgcolor="#FFFFFF"> <?php echo $row2->name;?></td>
<td width="146" bgcolor="#FFFFFF"> <?php echo $row2->model;?></td>
<td width="50" align="center" bgcolor="#FFFFFF"> <?php echo $row2->wh_units_name?></td>
<td width="94" bgcolor="#FFFFFF"> <?php echo $row2->num?></td>
<td width="149" bgcolor="#FFFFFF"> <?php echo $row2->price?></td>
<td width="225" bgcolor="#FFFFFF"> <?php echo $row2->amount?> </td>
</tr> <?php $i++;}?>
<tr>
<td height="23" bgcolor="#FFFFFF">页小计:</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="center" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> 这里是数量页小计</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> 这里是金额页小计</td>
</tr>
<tr>
<td height="23" bgcolor="#FFFFFF">合计:</td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="center" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> <?php $rlt5=mysql_query("select sum(t1.num) from ( select num from in_wh_record where docu_id ='$id') t1");$row5=mysql_fetch_array($rlt5); echo $row5[0]?></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> <?php $rlt6=mysql_query("select sum(t1.amount) from ( select amount from in_wh_record where docu_id ='$id') t1");$row6=mysql_fetch_array($rlt6); echo $row6[0]?></td>
</tr>
</table>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货