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

📄 index.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
🔍 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>订单明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function LoadWindow1()
{
  URL="/module/crm/product_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
';
  echo '
function CheckForm()
{
    	if(document.form1.PRO_NAME.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
      if(document.form1.PRO_ID.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
      if(document.form1.PRICE.value=="")
      { alert("单价不能为空！");
        return (false);
      }
       if(document.form1.TRANS';
  echo '_QTY.value=="")
      { alert("数量不能为空！");
        return (false);
      }
      document.form1.submit();
}
function clear_dept1()
{
  document.form1.PRO_ID.value="";
	document.form1.PRO_NAME.value="";
	document.form1.PRICE.value="";
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event';
  echo '.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function delete_vote(LINE_ID,ORDER_ID)
{
 msg=\'确认删除订单明细吗？\';
 if(window.confirm(msg))
 {
  URL="delete.php?LINE_ID="+LINE_ID+"&ORDER_ID="+OR';
  echo 'DER_ID+"&PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&PROVIDER_CODE=';
  echo $PROVIDER_CODE;
  echo '&PROVIDER_SHORT=';
  echo $PROVIDER_SHORT;
  echo '&PROVIDER_AREA=';
  echo $PROVIDER_AREA;
  echo '&ORDER_TYPE=';
  echo $ORDER_TYPE;
  echo '&ORDER_NO=';
  echo $ORDER_NO;
  echo '&ORDER_NAME=';
  echo $ORDER_NAME;
  echo '&RECIVER=';
  echo $RECIVER;
  echo '&DATE1=';
  echo $DATE1;
  echo '&DATE2=';
  echo $DATE2;
  echo '&CREATOR=';
  echo $CREATOR;
  echo '&DATE_TYPE=';
  echo $DATE_TYPE;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '";
  window.location=URL;
 }
}
function delete_vote1(LINE_ID,ORDER_ID)
{
 msg=\'确认删除订单明细吗？\';
 if(window.confirm(msg))
 {
  URL="delete.php?LINE_ID="+LINE_ID+"&ORDER_ID="+ORDER_ID+"&querstr="+document.all("querstr").value;;
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  if (($LINE_ID != ''))
  {
    $query = ((''.'SELECT  a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
                   a.TRANS_PRICE as TRANS_PRICE,
                   a.TRANS_QTY as TRANS_QTY,a.MEMO as MEMO
                  from ORDER_LINE  a
                  LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID=b.PRODUCT_ID
                  where a.LINE_ID=').$LINE_ID);
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $LINE_ID = $ROW['LINE_ID'];
      $PRODUCT_ID = $ROW['PRODUCT_ID'];
      $PRODUCT_NAME = $ROW['PRODUCT_NAME'];
      $TRANS_PRICE = $ROW['TRANS_PRICE'];
      $TRANS_QTY = $ROW['TRANS_QTY'];
      $MEMO = $ROW['MEMO'];
    }
  }
  echo '<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="add.php"  method="post" name="form1">
    <tr>
      <td nowrap  class="TableData">产品：</td>
      <td class="TableData">
        <input type="hidden" name="PRO_ID" value="';
  echo $PRODUCT_ID;
  echo '">
        <input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20"  value="';
  echo $PRODUCT_NAME;
  echo '" readonly>
        &nbsp;<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
        &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_dept1()" title="清空" name="button">
      </td>
    </tr>
   <tr>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
';
  if (($TRANS_PRICE == ''))
  {
    echo '      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
';
  }
  else
  {
    echo '        <input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="';
    echo $TRANS_PRICE;
    echo '">
';
  }
  echo '      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="';
  echo $TRANS_QTY;
  echo '">
      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">备注：</td>
      <td class="TableData">
        <textarea name="MEMO" cols="45" rows="5" class="BigInput">';
  echo $MEMO;
  echo '</textarea>
      </td>
  </tr>
    <tr align="center" class="TableControl">
';
  if (($querstr != ''))
  {
    $urlstr1 = str_replace ('%', '&', $querstr);
    echo '      <td colspan="2" nowrap>
        <input type="hidden" name="ORDER_ID" value="';
    echo $ORDER_ID;
    echo '">
        <input type="hidden" name="LINE_ID" value="';
    echo $LINE_ID;
    echo '">
        <input type="hidden" name="querstr" value="';
    echo $querstr;
    echo '">
        <input type="hidden" value="ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '" name="QUERY_LIST">
        <input type="hidden" value="ad_query" name="FLAGSOURCE">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
';
    if (($LINE_ID != ''))
    {
      echo '        <input type="button" value="取消" class="BigButton" onclick="location=\'index.php?ORDER_ID=';
      echo $ORDER_ID;
      echo '&querstr=';
      echo $querstr;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '\'">
';
    }
    echo '      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location=\'../ad_query/list.php?';
    echo $urlstr1;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '\'">
      </td>
';
  }
  else
  {
    echo '  <td colspan="2" nowrap>
        <input type="hidden" name="ORDER_ID" value="';
    echo $ORDER_ID;
    echo '">
        <input type="hidden" name="LINE_ID" value="';
    echo $LINE_ID;
    echo '">
        <input type="hidden" value="ORDER_ID=';
    echo $ORDER_ID;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&PROVIDER_CODE=';
    echo $PROVIDER_CODE;
    echo '&PROVIDER_SHORT=';
    echo $PROVIDER_SHORT;
    echo '&PROVIDER_AREA=';
    echo $PROVIDER_AREA;
    echo '&ORDER_TYPE=';
    echo $ORDER_TYPE;
    echo '&ORDER_NO=';
    echo $ORDER_NO;
    echo '&ORDER_NAME=';
    echo $ORDER_NAME;
    echo '&RECIVER=';
    echo $RECIVER;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&CREATOR=';
    echo $CREATOR;
    echo '&DATE_TYPE=';
    echo $DATE_TYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '" name="QUERY_LIST">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
';
    if (($LINE_ID != ''))
    {
      echo '        <input type="button" value="取消" class="BigButton" onclick="location=\'index.php?ORDER_ID=';
      echo $ORDER_ID;
      echo '&PROVIDER_NAME=';
      echo $PROVIDER_NAME;
      echo '&PROVIDER_CODE=';
      echo $PROVIDER_CODE;
      echo '&PROVIDER_SHORT=';
      echo $PROVIDER_SHORT;
      echo '&PROVIDER_AREA=';
      echo $PROVIDER_AREA;
      echo '&ORDER_TYPE=';
      echo $ORDER_TYPE;
      echo '&ORDER_NO=';
      echo $ORDER_NO;
      echo '&ORDER_NAME=';
      echo $ORDER_NAME;
      echo '&RECIVER=';
      echo $RECIVER;
      echo '&DATE1=';
      echo $DATE1;
      echo '&DATE2=';
      echo $DATE2;
      echo '&CREATOR=';
      echo $CREATOR;
      echo '&DATE_TYPE=';
      echo $DATE_TYPE;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '\'">
';
    }
    echo '      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location=\'../?ORDER_ID=';
    echo $ORDER_ID;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&PROVIDER_CODE=';
    echo $PROVIDER_CODE;
    echo '&PROVIDER_SHORT=';
    echo $PROVIDER_SHORT;
    echo '&PROVIDER_AREA=';
    echo $PROVIDER_AREA;
    echo '&ORDER_TYPE=';
    echo $ORDER_TYPE;
    echo '&ORDER_NO=';
    echo $ORDER_NO;
    echo '&ORDER_NAME=';
    echo $ORDER_NAME;
    echo '&RECIVER=';
    echo $RECIVER;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&CREATOR=';
    echo $CREATOR;
    echo '&DATE_TYPE=';
    echo $DATE_TYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '\'">
      </td>
';
  }
  echo '    </tr>
  </table>
</form>
';
  $query = (((''.'SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
                   a.TRANS_PRICE as TRANS_PRICE,
                   a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,
                   b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE
                   from ORDER_LINE a
                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
                   where a.ORDER_ID=\'').$ORDER_ID).'\' ');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  $SUM_TRANS_QTY = 0;
  $SUM_TOTAL_PRICE = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $LINE_ID = $ROW['LINE_ID'];
    $PRODUCT_ID = $ROW['PRODUCT_ID'];
    $PRODUCT_NAME = $ROW['PRODUCT_NAME'];
    $TRANS_PRICE = $ROW['TRANS_PRICE'];
    $TRANS_QTY = $ROW['TRANS_QTY'];
    $PAYMENT = $ROW['PAYMENT'];
    $MEMO = $ROW['MEMO'];
    $PRODUCT_CODE = $ROW['PRODUCT_CODE'];
    $PRODUCT_TYPE = $ROW['PRODUCT_TYPE'];
    $TOTAL_PRICE = $ROW['TOTALPRICE'];
    $SUM_TRANS_QTY = ($SUM_TRANS_QTY + $TRANS_QTY);
    $SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
    if (($VOTE_COUNT == 1))
    {
      echo '      <table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
        <tr>
         <td background="/images/dian1.gif" width="100%"></td>
        </tr>
      </table>
      <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
        <tr>
        <td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
      echo '<s';
      echo 'pan class="big3">&nbsp;合同明细</span>
        </td>
       </tr>
      </table>
     <br>
     <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
     <tr class="TableHeader">
  	  <td nowrap align="center">产品名称</td>
       <td nowrap align="center">产品编码</td>
        <td nowrap align="center">产品型号</td>
      <td nowrap align="center">采购单价</td';
      echo '>
      <td nowrap align="center">采购数量</td>
        <td nowrap align="center">总价</td>
      <td nowrap align="center">操作</td>
    </tr>
';
    }
    if ((($VOTE_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $PRODUCT_NAME;
    echo '</td>
       <td align="center">';
    echo $PRODUCT_CODE;
    echo '</td>
       <td align="center">';
    echo $PRODUCT_TYPE;
    echo '</td>
      <td align="center">';
    echo $TRANS_PRICE;
    echo '</td>
      <td nowrap align="center">';
    echo $TRANS_QTY;
    echo '</td>
      <td nowrap align="center">';
    echo $TOTAL_PRICE;
    echo '</td>
      <td nowrap align="center">&nbsp;
';
    if (($querstr != ''))
    {
      $urlstr1 = str_replace ('%', '&', $querstr);
      echo '      <a href="index.php?LINE_ID=';
      echo $LINE_ID;
      echo '&ORDER_ID=';
      echo $ORDER_ID;
      echo '&querstr=';
      echo $querstr;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '">修改</a>
      &nbsp;
      <a href="javascript:delete_vote1(\'';
      echo $LINE_ID;
      echo '\',\'';
      echo $ORDER_ID;
      echo '\');">删除</a>
';
    }
    else
    {
      echo '    <a href="index.php?LINE_ID=';
      echo $LINE_ID;
      echo '&ORDER_ID=';
      echo $ORDER_ID;
      echo '&PROVIDER_NAME=';
      echo $PROVIDER_NAME;
      echo '&PROVIDER_CODE=';
      echo $PROVIDER_CODE;
      echo '&PROVIDER_SHORT=';
      echo $PROVIDER_SHORT;
      echo '&PROVIDER_AREA=';
      echo $PROVIDER_AREA;
      echo '&ORDER_TYPE=';
      echo $ORDER_TYPE;
      echo '&ORDER_NO=';
      echo $ORDER_NO;
      echo '&ORDER_NAME=';
      echo $ORDER_NAME;
      echo '&RECIVER=';
      echo $RECIVER;
      echo '&DATE1=';
      echo $DATE1;
      echo '&DATE2=';
      echo $DATE2;
      echo '&CREATOR=';
      echo $CREATOR;
      echo '&DATE_TYPE=';
      echo $DATE_TYPE;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '">修改</a>
      &nbsp;
    <a href="javascript:delete_vote(\'';
      echo $LINE_ID;
      echo '\',\'';
      echo $ORDER_ID;
      echo '\');">删除</a>
';
    }
    echo '
      </td>
    </tr>
';
  }
  if ((0 < $VOTE_COUNT))
  {
    echo ' <tr align="center" class="TableControl">
  <td colspan="4" nowrap>合计：</td>
  <td nowrap align="center">';
    echo $SUM_TRANS_QTY;
    echo '</td>
  <td nowrap align="center">';
    echo $SUM_TOTAL_PRICE;
    echo '</td>
  <td nowrap align="center"></td>
 </tr>
</table>
';
  }
  echo '
</body>
</html>';
?>

⌨️ 快捷键说明

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