index.php

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

      </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="CONTRACT_ID" value="';
    echo $CONTRACT_ID;
    echo '">
        <input type="hidden" name="LINE_ID" value="';
    echo $LINE_ID;
    echo '">
        <input type="hidden" name="TYPE" value="';
    echo $TYPE;
    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?CONTRACT_ID=';
      echo $CONTRACT_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="CONTRACT_ID" value="';
    echo $CONTRACT_ID;
    echo '">
        <input type="hidden" name="LINE_ID" value="';
    echo $LINE_ID;
    echo '">
        <input type="hidden" name="TYPE" value="';
    echo $TYPE;
    echo '">
        <input type="hidden" value="CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&CONTRACT_TYPE=';
    echo $CONTRACT_TYPE;
    echo '&CONTRACT_NO=';
    echo $CONTRACT_NO;
    echo '&CONTRACT_NAME=';
    echo $CONTRACT_NAME;
    echo '&DATE_TYPE=';
    echo $DATE_TYPE;
    echo '&CONTRACT_LINKMAN1=';
    echo $CONTRACT_LINKMAN1;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&CONTRACT_LINKMAN2=';
    echo $CONTRACT_LINKMAN2;
    echo '&SIGN=';
    echo $SIGN;
    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?CONTRACT_ID=';
      echo $CONTRACT_ID;
      echo '&CUSTOMER_NAME=';
      echo $CUSTOMER_NAME;
      echo '&KIND=';
      echo $KIND;
      echo '&SELLMODE=';
      echo $SELLMODE;
      echo '&CONTRACT_TYPE=';
      echo $CONTRACT_TYPE;
      echo '&DATE_TYPE=';
      echo $DATE_TYPE;
      echo '&CONTRACT_NO=';
      echo $CONTRACT_NO;
      echo '&CONTRACT_NAME=';
      echo $CONTRACT_NAME;
      echo '&CONTRACT_LINKMAN1=';
      echo $CONTRACT_LINKMAN1;
      echo '&SIGN=';
      echo $SIGN;
      echo '&CONTRACT_LINKMAN2=';
      echo $CONTRACT_LINKMAN2;
      echo '&DATE1=';
      echo $DATE1;
      echo '&DATE2=';
      echo $DATE2;
      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=\'../?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&CONTRACT_TYPE=';
    echo $CONTRACT_TYPE;
    echo '&DATE_TYPE=';
    echo $DATE_TYPE;
    echo '&CONTRACT_NO=';
    echo $CONTRACT_NO;
    echo '&CONTRACT_NAME=';
    echo $CONTRACT_NAME;
    echo '&CONTRACT_LINKMAN1=';
    echo $CONTRACT_LINKMAN1;
    echo '&CONTRACT_LINKMAN2=';
    echo $CONTRACT_LINKMAN2;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&SIGN=';
    echo $SIGN;
    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,
                   c.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.TRANS_PRICE as TRANS_PRICE,
                   a.TRANS_QTY as TRANS_QTY,a.TOTAL_PRICE as TOTAL_PRICE,a.PAYMENT as PAYMENT,IF(a.TOTAL_PRICE-a.PAYMENT<0,0,a.TOTAL_PRICE-a.PAYMENT) as QIANKUAN,a.MEMO as MEMO,a.TYPE as TYPE from CONTRACT_LINE a
            LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID AND a.TYPE=\'PRO\'
            LEFT OUTER JOIN SERVICE c ON a.SERVICE_ID = c.SERVICE_ID AND a.TYPE=\'SER\'
           where CONTRACT_ID=\'').$CONTRACT_ID).'\' ');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  $SUM_TRANS_QTY = 0;
  $SUM_TOTAL_PRICE = 0;
  $SUM_PAYMENT = 0;
  $SUM_QIANKUAN = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$VOTE_COUNT;
    $LINE_ID = $ROW['LINE_ID'];
    $PRODUCT_ID = $ROW['PRODUCT_ID'];
    $PRODUCT_NAME = $ROW['PRODUCT_NAME'];
    $SERVICE_ID = $ROW['SERVICE_ID'];
    $SERVICE_NAME = $ROW['SERVICE_NAME'];
    $TRANS_PRICE = $ROW['TRANS_PRICE'];
    $TRANS_QTY = $ROW['TRANS_QTY'];
    $TOTAL_PRICE = $ROW['TOTAL_PRICE'];
    $PAYMENT = $ROW['PAYMENT'];
    $QIANKUAN = $ROW['QIANKUAN'];
    $MEMO = $ROW['MEMO'];
    $SUM_TRANS_QTY = ($SUM_TRANS_QTY + $TRANS_QTY);
    $SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
    $SUM_PAYMENT = ($SUM_PAYMENT + $PAYMENT);
    $SUM_QIANKUAN = ($SUM_QIANKUAN + $QIANKUAN);
    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>
      <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 $SERVICE_NAME;
    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">';
    echo $PAYMENT;
    echo '</td>
      <td nowrap align="center">';
    echo $QIANKUAN;
    echo '</td>
      <td nowrap align="center">&nbsp;
';
    if (($querstr != ''))
    {
      $urlstr1 = str_replace ('%', '&', $querstr);
      echo '      <a href="index.php?LINE_ID=';
      echo $LINE_ID;
      echo '&CONTRACT_ID=';
      echo $CONTRACT_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 $CONTRACT_ID;
      echo '\');">删除</a>
';
    }
    else
    {
      echo '    <a href="index.php?LINE_ID=';
      echo $LINE_ID;
      echo '&CONTRACT_ID=';
      echo $CONTRACT_ID;
      echo '&CUSTOMER_NAME=';
      echo $CUSTOMER_NAME;
      echo '&KIND=';
      echo $KIND;
      echo '&SELLMODE=';
      echo $SELLMODE;
      echo '&CONTRACT_TYPE=';
      echo $CONTRACT_TYPE;
      echo '&DATE_TYPE=';
      echo $DATE_TYPE;
      echo '&CONTRACT_NO=';
      echo $CONTRACT_NO;
      echo '&CONTRACT_NAME=';
      echo $CONTRACT_NAME;
      echo '&CONTRACT_LINKMAN1=';
      echo $CONTRACT_LINKMAN1;
      echo '&SIGN=';
      echo $SIGN;
      echo '&CONTRACT_LINKMAN2=';
      echo $CONTRACT_LINKMAN2;
      echo '&DATE1=';
      echo $DATE1;
      echo '&DATE2=';
      echo $DATE2;
      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 $CONTRACT_ID;
      echo '\');">删除</a>
';
    }
    echo '
      </td>
    </tr>
';
  }
  if ((0 < $VOTE_COUNT))
  {
    echo ' <tr align="center" class="TableControl">
  <td colspan="3" 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">';
    echo $SUM_PAYMENT;
    echo '</td>
  <td nowrap align="center">';
    echo $SUM_QIANKUAN;
    echo '</td>
  <td nowrap align="center"></td>
 </tr>
</table>
';
  }
  echo '
</body>
</html>';
?>