📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
  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 CheckForm()
{
	 if(document.all("LINE_ID").value=="" )
    {
    	  alert("请选择订单明细！！");
        return (false);
    }
    if(document.all("TRANS_QTY").value=="")
    {
    	  alert("交付数量不能空！！");
        return (false);
    }
   document.form1.submit();
}
function checknum(p)
{
  var l = p.length;
  var count=0;
  for(var ';
  echo 'i=0; i<l; i++)
  {
  var digit = p.charAt(i);
  if(digit == "." )
  {
    ++count;
    if(count>1)
    {
     return 0;
    }
  }
  else if(digit < "0" || digit > "9")
    {
     return 0;
    }
    }
  return 1;
}
function select_value(LINE_ID,PRODUCT_ID,PRODUCT_NAME,TRANS_PRICE,PROVIDER_ID)
{
    document.all("LINE_ID").value=LINE_ID;
    document.all("PRO_ID").value=PRODUCT';
  echo '_ID;
    document.all("PRO_NAME").value=PRODUCT_NAME;
    document.all("PRICE").value=TRANS_PRICE;
    document.all("PROVIDER_ID").value=PROVIDER_ID;
    document.all("OP").value="ADD";
}
function select_value1(LINE_ID,PRODUCT_ID,PRODUCT_NAME,TRANS_PRICE,TRANS_QTY,HISTORY_ID)
{
      document.all("HISTORY_ID").value=HISTORY_ID;
      document.all("LINE_ID").value=LINE_ID;
      documen';
  echo 't.all("PRO_ID").value=PRODUCT_ID;
      document.all("PRO_NAME").value=PRODUCT_NAME;
      document.all("PRICE").value=TRANS_PRICE;
      document.all("TRANS_QTY").value=TRANS_QTY;
      document.all("OP").value="MOD";
}
function delete_vote(HISTORY_ID,ORDER_ID)
{
 msg=\'确认删除该接货记录吗？\';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&ORDER_ID="+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 '";
  window.location=URL;
 }
}
function delete_vote1(HISTORY_ID,ORDER_ID)
{
 msg=\'确认删除该接货记录吗？\';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&ORDER_ID="+ORDER_ID+"&querstr="+document.all("querstr").value;;
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $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,c.PROVIDER_ID as PROVIDER_ID,
                   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
                   LEFT OUTER JOIN SUPPLY_ORDER c ON a.ORDER_ID = c.ORDER_ID
                   where a.ORDER_ID=\'').$ORDER_ID).'\' ');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 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'];
    $PROVIDER_ID = $ROW['PROVIDER_ID'];
    $TOTAL_PRICE = $ROW['TOTALPRICE'];
    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">采购单价</';
      echo 'td>
      <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;
       <a href="javascript:select_value(\'';
    echo $LINE_ID;
    echo '\',\'';
    echo $PRODUCT_ID;
    echo '\',\'';
    echo $PRODUCT_NAME;
    echo '\',\'';
    echo $TRANS_PRICE;
    echo '\',\'';
    echo $PROVIDER_ID;
    echo '\');"> 选择</a>
      </td>
    </tr>
';
  }
  echo '</table>
<br>
<table border="0" width="50%" 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">
        <input type="text" name="PRO_NAME" size="20" class="';
  echo 'BigStatic" maxlength="20" readonly>
      </td>
    </tr>
   <tr>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigStatic" class="BigInput" readonly>
      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">本次交付数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS';
  echo '_QTY" size="20" maxlength="20" class="BigInput">
      </td>
   </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
';
  if (($querstr != ''))
  {
    $urlstr1 = str_replace ('%', '&', $querstr);
    echo '        <input type="hidden" name="ORDER_ID" value="';
    echo $ORDER_ID;
    echo '">
        <input type="hidden" name="LINE_ID">
        <input type="hidden" name="PROVIDER_ID" value="';
    echo $PROVIDER_ID;
    echo '">
        <input type="hidden" name="OP">
        <input type="hidden" name="HISTORY_ID">
        <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;
12 下一页
⌨️ 快捷键说明

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