index.php

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

         LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID
         LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID
         LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = \'CRM_KIND\'
         LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = \'SELL_MODE\'
         LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID
         '.$WHERE_STR).' group by a.CONTRACT_ID').$HAVING).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * $PER_PAGE);
  if (($offest < 0))
  {
    $offest = 0;
  }
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($CUSTOMER_COUNT == 0))
  {
    message ('<br>提示', '没有符合条件的合同');
    exit ();
  }
  else
  {
    echo '
<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&';
    echo $urlstr;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&';
    echo $urlstr;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE + 1);
    echo '&';
    echo $urlstr;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
        <a href="index.php?CUR_PAGE=';
    echo $PAGE_COUNT;
    echo '&';
    echo $urlstr;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/last02.gif\'  width=\'24\' border=\'0\' height=\'15\' alt=\'末页\' style="cursor:hand"></a>
      到
      <input type="text" name="PAGE_NUM" size="3" maxlength="4"  class="SmallInput">
      页
      <img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page(\'';
    echo $urlstr;
    echo '\')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
    </td>
    <td align="right">
      ';
    echo $CUR_PAGE;
    echo '/';
    echo $PAGE_COUNT;
    echo '页&nbsp;共&nbsp;';
    echo $CUSTOMER_COUNT;
    echo '&nbsp;条
    </td>
  </tr>
</table>
<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"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CONTRACT_NO&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">合同编号&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CONTRACT_NO')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CONTRACT_NO')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CONTRACT_NAME&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">合同名称&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CONTRACT_NAME')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CONTRACT_NAME')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">客户名称&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=TOTALPRICE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">合同总价&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'TOTALPRICE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'TOTALPRICE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=PAYMENT&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">已付款数&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'PAYMENT')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PAYMENT')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=BEGIN_DATE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">生效日期&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'BEGIN_DATE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'BEGIN_DATE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=END_DATE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">终止日期&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'END_DATE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'END_DATE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CREATE_DATE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">创建日期&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CREATE_DATE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CREATE_DATE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center">创建人</td>
      <td nowrap align="center">操作</td>
  </tr>
';
    $CUSTOMER_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      ++$CUSTOMER_COUNT;
      $CONTRACT_ID1 = $ROW['CONTRACT_ID'];
      $CONTRACT_NO1 = $ROW['CONTRACT_NO'];
      $CONTRACT_NAME1 = $ROW['CONTRACT_NAME'];
      $CONTRACT_TYPE1 = $ROW['CONTRACT_TYPE'];
      $CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
      $TOTALPRICE1 = $ROW['TOTALPRICE'];
      $PAYMENT = $ROW['PAYMENT'];
      $BEGIN_DATE1 = $ROW['BEGIN_DATE'];
      $END_DATE1 = $ROW['END_DATE'];
      $CREATE_DATE1 = $ROW['CREATE_DATE'];
      $SELLER1 = $ROW['SELLER'];
      if ((($CUSTOMER_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="';
      echo $CONTRACT_ID1;
      echo '" ';
      if (($SIGN == '1'))
      {
        echo 'disabled';
      }
      echo ' onClick="check_one(self);"></td>
      <td nowrap align="center">';
      echo $CONTRACT_NO1;
      echo '</td>
       <td nowrap align="center">';
      echo $CONTRACT_NAME1;
      echo '</td>
      <td nowrap align="center">';
      echo $CUSTOMER_NAME1;
      echo '</td>
      <td nowrap align="center">';
      echo $TOTALPRICE1;
      echo '</td>
       <td nowrap align="center">';
      echo $PAYMENT;
      echo '</td>
      <td nowrap align="center">';
      echo $BEGIN_DATE1;
      echo '</td>
      <td nowrap align="center">';
      echo $END_DATE1;
      echo '</td>
      <td nowrap align="center">';
      echo $CREATE_DATE1;
      echo '</td>
      <td nowrap align="center">';
      echo $SELLER1;
      echo '</td>
      <td nowrap align="center">
	      <a href="edit.php?CONTRACT_ID=';
      echo $CONTRACT_ID1;
      echo '&';
      echo $urlstr;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '">编辑</a>
        <a href="javascript:delete_customer(\'';
      echo $CONTRACT_ID1;
      echo '\',\'';
      echo $urlstr;
      echo '\');">删除</a><br>
        <a href="contract_line?CONTRACT_ID=';
      echo $CONTRACT_ID1;
      echo '&';
      echo $urlstr;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '">合同明细</a><br>
        <a href="contract_history?CONTRACT_ID=';
      echo $CONTRACT_ID1;
      echo '&';
      echo $urlstr;
      echo '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '">付款记录</a>
      </td>
    </tr>
';
    }
  }
  echo '<tr class="TableControl">
 <td colspan="11">
 	   &nbsp;<input type="checkbox" name="allbox" id="allbox_for"  ';
  if (($SIGN == '1'))
  {
    echo 'disabled';
  }
  echo ' onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="批量删除" class="SmallButton" onClick="delete_mail(\'';
  echo $urlstr;
  echo '\');" title="删除所选客户"> &nbsp;
 </td>
</tr>
</table>
</body>
</html>
';
?>