⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 detail.php

📁 通达OA28 部分程序源码
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>销售记录详细资料 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>

<?
 

 $query = "SELECT * from SALE_HISTORY where HISTORY_ID=$HISTORY_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
        $HISTORY_ID=$ROW["HISTORY_ID"];
    $CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
    $PRODUCT_ID1=$ROW["PRODUCT_ID"];
    $DATE1=$ROW["DATE"];
    $AMT1=$ROW["AMT"];
    $PRICE1=$ROW["PRICE"];
    $DISCOUNT1=$ROW["DISCOUNT"];
    $SALESMAN1=$ROW["SALESMAN"];
    $MEMO1=$ROW["MEMO"];
    
    $query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID=$CUSTOMER_ID1";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
          $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];    
          
        $query = "SELECT PRODUCT_NAME,PRODUCT_TYPE from PRODUCT where PRODUCT_ID=$PRODUCT_ID1";
      $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
         $PRODUCT_NAME=$ROW["PRODUCT_NAME"];    
          $PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];    
          
          if($PRODUCT_TYPE!="")
            $PRODUCT_NAME_TYPE=$PRODUCT_NAME.$PRODUCT_TYPE;
          else
            $PRODUCT_NAME_TYPE=$PRODUCT_NAME;
    }
          
    $CUSTOMER_NAME=str_replace("<","&lt",$CUSTOMER_NAME);$CUSTOMER_NAME=str_replace(">","&gt",$CUSTOMER_NAME);$CUSTOMER_NAME=stripslashes($CUSTOMER_NAME);
    $PRODUCT_NAME_TYPE=str_replace("<","&lt",$PRODUCT_NAME_TYPE);$PRODUCT_NAME_TYPE=str_replace(">","&gt",$PRODUCT_NAME_TYPE);$PRODUCT_NAME_TYPE=stripslashes($PRODUCT_NAME_TYPE);
    $DATE1=str_replace("<","&lt",$DATE1);$DATE1=str_replace(">","&gt",$DATE1);$DATE1=stripslashes($DATE1);
    $AMT1=str_replace("<","&lt",$AMT1);$AMT1=str_replace(">","&gt",$AMT1);$AMT1=stripslashes($AMT1);
    $PRICE1=str_replace("<","&lt",$PRICE1);$PRICE1=str_replace(">","&gt",$PRICE1);$PRICE1=stripslashes($PRICE1);
    $DISCOUNT1=str_replace("<","&lt",$DISCOUNT1);$DISCOUNT1=str_replace(">","&gt",$DISCOUNT1);$DISCOUNT1=stripslashes($DISCOUNT1);
    $SALESMAN1=str_replace("<","&lt",$SALESMAN1);$SALESMAN1=str_replace(">","&gt",$SALESMAN1);$SALESMAN1=stripslashes($SALESMAN1);
    $MEMO1=str_replace("<","&lt",$MEMO1);$MEMO1=str_replace(">","&gt",$MEMO1);$MEMO1=stripslashes($MEMO1);
 }

?>

<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 销售记录详细信息</span>
    </td>
  </tr>
</table>

<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form name="form1">
   <tr>
    <td nowrap class="TableData">客户： </td>
    <td class="TableData">
      <?=$CUSTOMER_NAME?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">产品： </td>
    <td class="TableData">
      <?=$PRODUCT_NAME_TYPE?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">销售日期： </td>
    <td nowrap class="TableData">
      <?=$DATE1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">数量：</td>
    <td nowrap class="TableData">
      <?=$AMT1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">价格：</td>
    <td nowrap class="TableData">
      <?=$PRICE1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">折扣：</td>
    <td nowrap class="TableData">
      <?=$DISCOUNT1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">发货员：</td>
    <td nowrap class="TableData">
      <?=$SALESMAN1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">备注： </td>
    <td nowrap class="TableData">
      <?=$MEMO1?>&nbsp;
    </td>
   </tr>
   <tr align="center" class="TableControl">
     <td colspan="2">
       <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
     </td>
   </tr>
  </form>
</table>

</body>
</html>

⌨️ 快捷键说明

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