product_calc.php

php模块设计。。。里面的模块很有学习价值

<?

	include("db_conn.php");	
	include("db_func.php");

	// 计算销售总金额
	$SQLStr1 = "SELECT sum(p_sell*p_price) FROM product";
	$res1 = db_query($SQLStr1);
	$row1 = db_fetch_array($res1);

	// 计算总库存成本
	$SQLStr2 = "SELECT sum(p_cost*p_numbers) FROM product";
	$res2 = db_query($SQLStr2);
	$row2 = db_fetch_array($res2);

	// 计算产品销售总利润
	$SQLStr3 = "SELECT sum((p_price-p_cost)*p_sell) FROM product";
	$res3 = db_query($SQLStr3);
	$row3 = db_fetch_array($res3);

	// 计算上架产品的库存成本
	$SQLStr4 = "SELECT sum(p_cost*p_numbers) FROM product WHERE p_actival = '1'";
	$res4 = db_query($SQLStr4);
	$row4 = db_fetch_array($res4);

	// 计算下架产品的库存成本
	$SQLStr5 = "SELECT sum(p_cost*p_numbers) FROM product WHERE p_actival = '0'";
	$res5 = db_query($SQLStr5);
	$row5 = db_fetch_array($res5);
	if ($row5[0] == '')
	  $row5[0] = '0';

	// 记算公司单项产品最高利润	
	$SQLStr6 = "SELECT p_id, (p_sell*p_price) AS p_max FROM product ORDER BY p_max DESC";
	$res6 = db_query($SQLStr6);
	$row6 = db_fetch_array($res6);

	// 计算库存不足的产品数量
	$SQLStr7 = "SELECT * FROM product WHERE p_numbers < 400";
	$res7 = db_query($SQLStr7);
	$num7 = db_num_rows($res7);
	
?>
<?
	include("up.htm");
?>
  <br>
  <table width="720" border="1" cellpadding="0" cellspacing="0" align="center" bordercolor="#9999CC">
    <tr> 
      <td> 
        <table width="720" border="1" align="center" cellspacing="0">
          <tr bgcolor="#99CCFF"> 
            <td colspan="4"> 
              <div align="center">产品管理简单计算功能</div>
            </td>
          </tr>
          <tr> 
            <td>公司总销售金额</td>
            <td>NT$ <?=$row1[0]?></td>
            <td>总库存成本</td>
            <td>NT$ <?=$row2[0]?></td>
          </tr>
          <tr> 
            <td>公司产品销售总利润 (销售 - 成本)</td>
            <td>NT$ <?=$row3[0]?></td>
            <td>上架产品库存成本</td>
            <td>NT$ <?=$row4[0]?></td>
          </tr>
          <tr> 
            <td height="27">公司单项产品最高利润</td>
            <td height="27">NT$ <?=$row6[p_max]?>《<?=$row6[p_id]?>》</td>
            <td height="27">已下架产品库存成本 </td>
            <td height="27">NT$ <?=$row5[0]?></td>
          </tr>
          <tr> 
            <td height="27" colspan="4">
              <div align="center">目前库存不足产品： 
                <select name="select">
<?
		 for ($i=0;$i<$num7;$i++)
		 {
		   $row7 = db_fetch_array($res7);
		   echo "<option value='" . $row7['p_id'] . "'>《" . $row7['p_numbers'] . "单位》" . $row7['p_name'] . "</option>";
		 }
?>
                </select>
              </div>
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
<? include("down.htm"); ?>