list.php

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

      $urlstr = ('SELLER_NAME='.$SELLER_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&SELLER_NAME=').$SELLER_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where g.USER_NAME like \'%'.$SELLER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and g.USER_NAME like \'%'.$SELLER_NAME).'%\''));
    }
  }
  if (($CONTRACT_MEMO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_MEMO='.$CONTRACT_MEMO);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_MEMO=').$CONTRACT_MEMO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_MEMO like \'%'.$CONTRACT_MEMO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_MEMO like \'%'.$CONTRACT_MEMO).'%\''));
    }
  }
  if (($CONTRACT_ARTICLE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_ARTICLE='.$CONTRACT_ARTICLE);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_ARTICLE=').$CONTRACT_ARTICLE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_ARTICLE like \'%'.$CONTRACT_ARTICLE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_ARTICLE like \'%'.$CONTRACT_ARTICLE).'%\''));
    }
  }
  if (($CONTRACT_CONTENT != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_CONTENT='.$CONTRACT_CONTENT);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_CONTENT=').$CONTRACT_CONTENT);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_CONTENT like \'%'.$CONTRACT_CONTENT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_CONTENT like \'%'.$CONTRACT_CONTENT).'%\''));
    }
  }
  if (($DATE1 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('DATE1='.$DATE1);
    }
    else
    {
      $urlstr = (($urlstr.'&DATE1=').$DATE1);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE>=\'').$DATE1).'\'')));
    }
    else
    {
      ($WHERE_STR .= (('  and a.'.$DATE_TYPE).(((''.'_DATE>=\'').$DATE1).'\'')));
    }
  }
  if (($DATE2 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('DATE2='.$DATE2);
    }
    else
    {
      $urlstr = (($urlstr.'&DATE2=').$DATE2);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE<=\'').$DATE2).'\'')));
    }
    else
    {
      ($WHERE_STR .= (('  and a.'.$DATE_TYPE).(((''.'_DATE<=\'').$DATE2).'\'')));
    }
  }
  if (($SIGN == '0'))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SIGN='.$SIGN);
    }
    else
    {
      $urlstr = (($urlstr.'&SIGN=').$SIGN);
    }
    $HAVING = ' HAVING PAYMENT<TOTALPRICE';
  }
  if (($SIGN == '1'))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SIGN='.$SIGN);
    }
    else
    {
      $urlstr = (($urlstr.'&SIGN=').$SIGN);
    }
    $HAVING = ' HAVING PAYMENT>=TOTALPRICE';
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CUSTOMER\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('CUSTOMER'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $CUSTOMERID_STR = '';
      if (($urlstr == ''))
      {
        $urlstr = (($FIELDNO.'=').$$FIELDNO);
      }
      else
      {
        $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      }
      $WHERE_STR1 = ((((' where TABLENAME=\'CUSTOMER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
      $query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
      $cursor1 = exequery ($connection, $query1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $CUSTOMERID_STR = (($CUSTOMERID_STR.$ROW1['IDENTY_ID']).',');
      }
      $CUSTOMERID_STR = (('\''.str_replace (',', '\',\'', substr ($CUSTOMERID_STR, 0, -1))).'\'');
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where d.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      else
      {
        ($WHERE_STR .= (((''.' and d.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      continue;
    }
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CONTRACT\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('CONTRACT'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $CONTRACTID_STR = '';
      if (($urlstr == ''))
      {
        $urlstr = (($FIELDNO.'=').$$FIELDNO);
      }
      else
      {
        $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      }
      $WHERE_STR1 = ((((' where TABLENAME=\'CONTRACT\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
      $query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
      $cursor1 = exequery ($connection, $query1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $CONTRACTID_STR = (($CONTRACTID_STR.$ROW1['IDENTY_ID']).',');
      }
      $CONTRACTID_STR = (('\''.str_replace (',', '\',\'', substr ($CONTRACTID_STR, 0, -1))).'\'');
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.CONTRACT_ID in (').$CONTRACTID_STR).')'));
        continue;
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.CONTRACT_ID in (').$CONTRACTID_STR).')'));
        continue;
      }
      continue;
    }
  }
  if (($urlstr == ''))
  {
    $urlstr = ('SELLER_TYPE='.$SELLER_TYPE);
  }
  else
  {
    $urlstr = (($urlstr.'&SELLER_TYPE=').$SELLER_TYPE);
  }
  if (($urlstr == ''))
  {
    $urlstr = ('DATE_TYPE='.$DATE_TYPE);
  }
  else
  {
    $urlstr = (($urlstr.'&DATE_TYPE=').$DATE_TYPE);
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $CUSTOMER_COUNT = 0;
  $query = ((('SELECT a.CONTRACT_ID,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT  from CONTRACT a
        LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = \'CONTRACT_TYPE\'
        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
        LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID
        '.$WHERE_STR).' group by a.CONTRACT_ID').$HAVING);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$CUSTOMER_COUNT;
  }
  $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 a.CONTRACT_ID as CONTRACT_ID,a.CONTRACT_NAME as CONTRACT_NAME,a.CONTRACT_NO as CONTRACT_NO,
         b.CODE_NAME as CONTRACT_TYPE,d.CUSTOMER_NAME as CUSTOMER_NAME,e.CODE_NAME as KIND,f.CODE_NAME as SELLMODE,
         g.USER_NAME as SELLER,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,a.CREATE_DATE as CREATE_DATE,
         a.BEGIN_DATE as BEGIN_DATE,a.END_DATE as END_DATE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT,h.USER_NAME as CONTRACT_LINKMAN2
         from CONTRACT a
         LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = \'CONTRACT_TYPE\'
         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
         LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID
         '.$WHERE_STR).' group by a.CONTRACT_ID').$HAVING).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * 10);
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($CUSTOMER_COUNT == 0))
  {
    message ('<br>提示', '没有符合条件的合同记录');
    button_back ();
    exit ();
  }
  else
  {
    echo '
<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="list.php?';
    echo $urlstr;
    echo '&CUR_PAGE=1&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="list.php?';
    echo $urlstr;
    echo '&CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
        <a href="list.php?';
    echo $urlstr;
    echo '&CUR_PAGE=';
    echo ($CUR_PAGE + 1);
    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="list.php?';
    echo $urlstr;
    echo '&CUR_PAGE=';
    echo $PAGE_COUNT;
    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"><a href="list.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="list.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CONTRACT_NAME&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {