contractlist.php

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

';
      }
      if (($STYPE == 'D'))
      {
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          if (($$FIELDNO1 == $TYPEVALUE_ARRAY[$I]))
          {
            echo '         ';
            echo $TYPENAME_ARRAY[$I];
            continue;
          }
        }
      }
      if (($STYPE == 'C'))
      {
        $temp = str_replace ('，', ',', $$FIELDNO1);
        $temp_ARRAY = explode (',', $temp);
        $temp_ARRAY_count = sizeof ($temp_ARRAY);
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          $flag = 0;
          for ($T = 0; ($T < $temp_ARRAY_count); ++$T)
          {
            if (($temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I]))
            {
              echo '        ';
              echo $TYPENAME_ARRAY[$I];
              echo ',
';
              continue;
            }
          }
        }
      }
      if (($STYPE == 'R'))
      {
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          if (($$FIELDNO1 == $TYPEVALUE_ARRAY[$I]))
          {
            echo '        ';
            echo $TYPENAME_ARRAY[$I];
            continue;
          }
        }
      }
      echo '
    </td>
 </tr>
';
    }
  }
  echo ' <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
      合同明细: 
    </td>
 </tr>
 <tr>
    <td nowrap  class="TableData" colspan="4" align="left">
    	<br>
      ';
  $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 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>
        <td nowrap align="center">总价</td>
      <td nowrap align="center">已付款数</td>
    ';
      echo '   <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>
    </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>
 </tr>
</table>
';
  }
  else
  {
    message ('<br>提示', '没有定义合同明细');
  }
  echo '<br>
    </td>
 </tr>
 <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
      付款记录: 
    </td>
 </tr>
 <tr>
    <td nowrap  class="TableData" colspan="4" align="left">
    	<br>
';
  $query = (((''.'SELECT  a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
                   a.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.PRICE as TRANS_PRICE,
                   a.AMT as TRANS_QTY,a.TOTAL_PRICE as TOTAL_PRICE,a.TYPE as TYPE,a.DATE as TRANS_DATE,f.USER_NAME as SELLER,g.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID
                   from SALE_HISTORY 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\'
                   LEFT OUTER JOIN CONTRACT_LINE d ON a.LINE_ID = d.LINE_ID
                   LEFT OUTER JOIN CONTRACT e ON d.CONTRACT_ID = e.CONTRACT_ID
                   LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID
                   LEFT OUTER JOIN CUSTOMER  g ON a.CUSTOMER_ID=g.CUSTOMER_ID
                   where a.CONTRACT_ID=\'').$CONTRACT_ID).'\' order by TYPE,HISTORY_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'];
    $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'];
    $TRANS_DATE = $ROW['TRANS_DATE'];
    $SELLER = $ROW['SELLER'];
    $CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
    $TYPE = $ROW['TYPE'];
    $MEMO = $ROW['MEMO'];
    $HISTORY_ID = $ROW['HISTORY_ID'];
    $SUM_TRANS_QTY = ($SUM_TRANS_QTY + $TRANS_QTY);
    $SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
    if (($VOTE_COUNT == 1))
    {
      echo '<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>
      <td nowrap align="center">交付总价</td>
      <td nowrap align="center">交付日期</td>
      <td n';
      echo 'owrap 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 $TRANS_DATE;
    echo '</td>
       <td nowrap align="center">';
    echo $CUSTOMER_NAME;
    echo '</td>
       <td nowrap align="center">';
    echo $SELLER;
    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"></td>
  <td nowrap align="center"></td>
  <td nowrap align="center"></td>
 </tr>
</table>
';
  }
  else
  {
    message ('<br>提示', '没有付款记录');
  }
  echo '    
    	<br>
    </td>
 </tr>
 <tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
        <input type="button" value="关闭"  onclick="window.close()" class="BigButton"  name="button">&nbsp;
    </td>
 </tr>
 </form>
</table>
</body>
</html>
';
?>