📄 viewsalesh.php

📁 一个php的公司信息系统
💻 PHP
字号:
<?
  require('session.inc');
  require('connect.inc');
  if ($usern=="none")
  {
    html_header("非法登录，拒绝访问 - ACCESS DENIED",'<META http-equiv="refresh" content="3; url=index.php">');
    echo "<td align=right valign=center><br>
    Sorry, 您正想非法登录本系统，请正常登录!<br>系统会在3秒后自动返回登录页面。
    <br><br><br><a href=index.php>返回登录</a></td>";
    html_footer();
  }
  else
  {
?>
<html>
<head>
<title>::: DATABASE 化妆品公司数据库管理系统 - 查询销售单明细 :::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="common.css" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="770" border="0" cellspacing="0" cellpadding="0" align="center" height="450">
  <tr>
    <td background="images/bg2.jpg">
      <table width="770" border="0" cellspacing="0" cellpadding="0" height="450">
        <tr>
           <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="0" height="450">
              <tr>
                <td height="140" class="bigh"><font color="#FF3333">查询销售单明细</font></td>
              </tr>
              <tr>
                <td valign=top>
                  <div align="right"><br>
<?
  $str_sql="select * from SALERC where said = '$said';";
  $result=mysql_db_query($db,$str_sql,$link_id);
  if (!$result) html_error_exit('MySQL查询命令失败!');
  $nor=@mysql_num_rows($result);
  $num=$page*8;
  $dp=$page+1;
  $num0=$num+1;
  $maxp=ceil($nor/8);
  if ($page<$maxp-1) $num1=$dp*8;
    else $num1=$nor;

  $str_sql="select * from SALERC where said = '$said' limit $num,8;";
  $result=mysql_db_query($db,$str_sql,$link_id);
  if (!$result) html_error_exit('MySQL查询命令失败!');

  echo "编号<font face=Arial color=#ff3333><b> $said </b></font>
  　　销售<font color=#ff3333><b> $saname </b></font>
  　　销售日期 <font face=Arial>$sadate </font>
  　　制表人 $mtp";
?>
<table width="45%" border="0" cellspacing="2" cellpadding="1">
                    <tr bgcolor="#000000">
                      <td>
                        <div align="center"><b><font color="#FFFFFF">产　　品</font></b></div>
                      </td>
                      <td>
                        <div align="center"><b><font color="#FFFFFF">销 售 量</font></b></div>
                      </td>
                      <td>
                        <div align="center"><b><font color="#FFFFFF">销售金额</font></b></div>
                      </td>
                    </tr>
<?
    $html='';
    $bgc='DDDDDD';
    while ($record=mysql_fetch_object($result))
    {
      if ($bgc=='DDDDDD')
        $bgc='EEEEEE';
      else
        $bgc='DDDDDD';
      $pid=$record->pid;
      $samount=$record->samount;
      $money=$record->money;

      $str_sql="select pname from PRODUCTTB where pid = '$pid';";
      $res=mysql_db_query($db,$str_sql,$link_id);
      if (!$res) html_error_exit('MySQL查询命令失败!');
      $rec=mysql_fetch_object($res);
      $pname=$rec->pname;
      $html.='                <tr bgcolor='.$bgc.'>
                              <td>'.$pname.'</td>
                              <td>'.$samount.'</td>
                              <td>'.$money.'</td>
                            </tr>';
    }
    $html.='</table><br><div align=right>';
    echo $html;
    if ($page!=0) {
      $n=$page-1;
      echo "<a href=viewsalesh.php?said=$said&saname=$saname&sadate=$sadate&mtp=$mtp&pp=$pp&page=0>第一页</a>　<a href=viewsalesh.php?said=$said&saname=$saname&sadate=$sadate&mtp=$mtp&pp=$pp&page=$n>上一页</a>　";
    }
    echo "　<a href=viewsale.php?page=$pp>返回销售单查询</a>　<a href=index2.php>返回首页</a>　";
    if (($maxp!=0)&&($page<($lp=$maxp-1))) {
      $n=$page+1;
      echo "　<a href=viewsalesh.php?said=$said&saname=$saname&sadate=$sadate&mtp=$mtp&pp=$pp&page=$n>下一页</a>　<a href=viewsalesh.php?said=$said&saname=$saname&sadate=$sadate&mtp=$mtp&pp=$pp&page=$lp>最后页</a>";
    }
    echo "</div>";
?>                    <br>
                  </div>

                </td>
              </tr>
              <tr>
                <td height="40">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0" height="40">
                    <tr>
                      <td valign="bottom" align="right"><font face="Arial"><b>Powered
                        by <img src="images/php.gif" width="39" height="20" align="absmiddle">
                        &amp; <img src="images/mysql.gif" width="82" height="20" align="absmiddle"></b></font></td>
                      <td align="right" valign="bottom" width="200"><font face="Arial">&copy;
                        <a href="mailto:lonelyp@etang.com">Lonely Passenger</a>,2001<br>
                        All rights reserved!</font></td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>
<?
  }
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -