index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 571 行 · 第 1/2 页

  <tr>
    <td nowrap class="TableData">创建人： </td>
    <td nowrap class="TableData">
    <input type="hidden" name="CREATOR" value="';
  echo $LOGIN_USER_ID;
  echo '" >
';
  $query2 = (((''.'select USER_NAME from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
  $cursor2 = exequery ($connection, $query2);
  if ($ROW = mysql_fetch_array ($cursor2))
  {
    $SELLER1_NAME = $ROW['USER_NAME'];
  }
  echo '     <input type="text" name="CREATOR_NAME" class="BigStatic" readonly size="15" maxlength="100" value="';
  echo $SELLER1_NAME;
  echo '">
    </td>
     <td nowrap class="TableData">负责人： </td>
    <td nowrap class="TableData">
        <input type="hidden" name="TO_ID" value="';
  echo $RECIVER1;
  echo '">
        <input type="text" name="TO_NAME" class="BigStatic" readonly size="15" maxlength="100"  value="';
  echo $RECIVER_NAME1;
  echo '">
        <input type="button" value="选择" class="SmallButton" onClick="LoadWindow()" title="指定负责人" name="button">
    </td>
   </tr>
<tr>
 <td nowrap class="TableData">备注： </td>
    <td nowrap class="TableData" colspan="3">
        <textarea cols=57 rows=3 name="REMARK" class="BigInput" wrap="yes">';
  echo $REMARK1;
  echo '</textarea>
    </td>
</tr>
<tr>
  <td class="TableData" colspan="4">
       ';
  echo get_field_table (get_field_html ('SUPPLY_ORDER', $ORDER_ID));
  echo '  </td>
</tr>
<tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     订单明细：
    </td>
</tr>
<tr>
   	<td nowrap class="TableData">产品： </td>
    <td class="TableData" colspan="3">
      <input type="hidden" name="PRO_ID" value="">
      <input type="hidden" name="PRICE" value="">
      <input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20"  value="" rea';
  echo 'donly>&nbsp;
      <input type="button" value="选 择" class="SmallButton" onClick="LoadWindow3()" title="选择产品" name="button">&nbsp; 
      <input type="button" value="添加" class="SmallButton" title="添加" name="button" onclick="add_detail();"> 
    </td>
 </tr>
 <tr>
    <td nowrap class="TableData" colspan="4">
    	 <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#00000';
  echo '0" 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>
             <td nowrap align="center">总价</td>
             <td nowrap align="center">备注</td>
             <td nowrap align="center">操作</td>
';
  echo '
          </tr>
';
  $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
                   from ORDER_LINE a
                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
                   where a.ORDER_ID=\'').$ORDER_ID).'\' order by a.LINE_ID desc ');
  $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'];
    $TOTAL_PRICE = $ROW['TOTALPRICE'];
    $SUM_TRANS_QTY = ($SUM_TRANS_QTY + $TRANS_QTY);
    $SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
    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"><input type="text" value="';
    echo $TRANS_PRICE;
    echo '" name="';
    echo $LINE_ID;
    echo 'PRICE"></td>
      <td nowrap align="center"><input type="text" value="';
    echo $TRANS_QTY;
    echo '" name="';
    echo $LINE_ID;
    echo 'TRANS_QTY"></td>
      <td nowrap align="center">';
    echo $TOTAL_PRICE;
    echo '</td>
      <td nowrap align="center"><input type="text" value="';
    echo $MEMO;
    echo '" name="';
    echo $LINE_ID;
    echo 'MEMO"></td>
      <td nowrap align="center">&nbsp;
';
    if (($querstr != ''))
    {
      $urlstr1 = str_replace ('%', '&', $querstr);
      echo '      <a href="javascript:edit_line(\'';
      echo $LINE_ID;
      echo '\');">保存</a>
      &nbsp;
      <a href="javascript:delete_line(\'';
      echo $LINE_ID;
      echo '\');">删除</a>
';
    }
    else
    {
      echo '    <a href="javascript:edit_line(\'';
      echo $LINE_ID;
      echo '\');">保存</a>
      &nbsp;
    <a href="javascript:delete_line(\'';
      echo $LINE_ID;
      echo '\');">删除</a>
';
    }
    echo '      </td>
';
  }
  echo '              
        </table>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
';
  if (($querstr != ''))
  {
    $urlstr1 = str_replace ('%', '&', $querstr);
    echo '
        <input type="hidden"  name="OP">
        <input type="hidden" name="LINE_ID">
        <input type="hidden" value="';
    echo $ORDER_ID;
    echo '" name="ORDER_ID">
        <input type="hidden" name="querstr" value="';
    echo $querstr;
    echo '">
        <input type="hidden" value="';
    echo $querstr;
    echo '&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="submit" value="确定" class="BigButton"  name="button">&nbsp;
        <input type="button" value="转至订单管理页面" class="BigButton" onclick="location=\'../manage/ad_query/list.php?';
    echo $urlstr1;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '\'">
';
  }
  else
  {
    echo '    	 <input type="hidden"  name="OP">
    	 <input type="hidden" name="LINE_ID">
    	 <input type="hidden" value="';
    echo $ORDER_ID;
    echo '" name="ORDER_ID">
    	 <input type="hidden" value="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="submit" value="确定" class="BigButton" title="新建" name="button">&nbsp;
       <input type="button" value="转至订单管理页面" class="BigButton" onclick="location=\'../manage?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 '    </td>
   </tr>
  </form>
</table>
</body>
</html>
';
?>