index.php

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

  if (($SERVICE_DESC != ''))
  {
    ($WHERE_STR .= ((' and d.SERVICE_DESC like \'%'.$SERVICE_DESC).'%\''));
  }
  if (($DATE1 != ''))
  {
    ($WHERE_STR .= (((''.'  and a.DATE>=\'').$DATE1).'\''));
  }
  if (($DATE2 != ''))
  {
    ($WHERE_STR .= (((''.'  and a.DATE<=\'').$DATE2).'\''));
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $CUSTOMER_COUNT = 0;
  $query = ('SELECT count(*) from SALE_HISTORY a
        LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
        LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
        LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
        LEFT OUTER JOIN USER  e ON a.SALESMAN=e.USER_ID
        '.$WHERE_STR);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $CUSTOMER_COUNT = $ROW[0];
  }
  $PER_PAGE = 10;
  $PAGE_COUNT = ceil (($CUSTOMER_COUNT / $PER_PAGE));
  if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
  {
    $CUR_PAGE = 1;
  }
  if (($PAGE_COUNT < $CUR_PAGE))
  {
    $CUR_PAGE = $PAGE_COUNT;
  }
  $query1 = (('SELECT c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE,f.USER_NAME as CREATOR
         from SALE_HISTORY a
         LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
         LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
         LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
         LEFT OUTER JOIN USER  e ON a.SALESMAN=e.USER_ID
         LEFT OUTER JOIN USER  f ON a.CREATOR=f.USER_ID
         '.$WHERE_STR).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * 10);
  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&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    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()" 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?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&ORDERFIELD=PRODUCT_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 == 'PRODUCT_NAME')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRODUCT_NAME')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
       <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&ORDERFIELD=SERVICE_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 == 'SERVICE_NAME')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SERVICE_NAME')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&ARE=';
    echo $ARE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&SERVICE_NAME=';
    echo $SERVICE_NAME;
    echo '&SERVICE_DESC=';
    echo $SERVICE_DESC;
    echo '&DATE1=';
    echo $DATE1;
    echo '&DATE2=';
    echo $DATE2;
    echo '&ORDERFIELD=PRICE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }