list.php

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

PHP
845 行
字号
12
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = 10;
  echo '
<html>
<head>
<title>合同查询结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
 function delete_customer(CONTRACT_ID,querstr)
{
 msg=\'确认要删除该合同？\';
 if(window.confirm(msg))
 {
  URL="../delete.php?querstr="+querstr+"&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CONTRACT_ID=" + CONTRACT_ID;
  window.location=URL;
 }
}
function set_page(urlstr)
{
 PAGE_START=PAGE_NUM.value;
 location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '";
}
	function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").';
  echo 'checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
</script>
</head>
';
  $urlstr = ('DATE_TYPE='.$DATE_TYPE);
  ($WHERE_STR .= (((((''.' where (a.SELLER =\'').$LOGIN_USER_ID).'\' or a.CONTRACT_LINKMAN2=\'').$LOGIN_USER_ID).'\')'));
  if (($CUSTOMER_NAME != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
    ($WHERE_STR .= ((' and d.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($CUSTOMER_CODE != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
    ($WHERE_STR .= ((' and d.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
  }
  if (($CUSTOMER_SHORT != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
    ($WHERE_STR .= ((' and d.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
  }
  if (($CUSTOMER_AREA != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
    ($WHERE_STR .= (((''.' and d.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
  }
  if (($CUSTOMER_ADD != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_AREA);
    ($WHERE_STR .= ((' and d.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
  }
  if (($SOURCE != ''))
  {
    $urlstr = (($urlstr.'&SOURCE=').$SOURCE);
    ($WHERE_STR .= (((''.' and d.SOURCE =\'').$SOURCE).'\''));
  }
  if (($KIND != ''))
  {
    $urlstr = (($urlstr.'&KIND=').$KIND);
    ($WHERE_STR .= (((''.' and d.KIND =\'').$KIND).'\''));
  }
  if (($SELLMODE != ''))
  {
    $urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
    ($WHERE_STR .= (((''.' and d.SELLMODE =\'').$SELLMODE).'\''));
  }
  if (($ATTRIBUTE != ''))
  {
    $urlstr = (($urlstr.'&ATTRIBUTE=').$SELLMODE);
    ($WHERE_STR .= (((''.' and d.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
  }
  if (($ENTERTYPE != ''))
  {
    $urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
    ($WHERE_STR .= (((''.' and d.ENTERTYPE =\'').$ENTERTYPE).'\''));
  }
  if (($ENTERMEMO != ''))
  {
    $urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
    ($WHERE_STR .= ((' and d.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
  }
  if (($CONTRACT_TYPE != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_TYPE=').$CONTRACT_TYPE);
    ($WHERE_STR .= (((''.' and a.CONTRACT_TYPE =\'').$CONTRACT_TYPE).'\''));
  }
  if (($CONTRACT_NO != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_NO=').$CONTRACT_NO);
    ($WHERE_STR .= ((' and a.CONTRACT_NO like \'%'.$CONTRACT_NO).'%\''));
  }
  if (($CONTRACT_NAME != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_NAME=').$CONTRACT_NAME);
    ($WHERE_STR .= ((' and a.CONTRACT_NAME like \'%'.$CONTRACT_NAME).'%\''));
  }
  if (($CONTRACT_LINKMAN1 != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_LINKMAN1=').$CONTRACT_LINKMAN1);
    ($WHERE_STR .= ((' and a.CONTRACT_LINKMAN1 like \'%'.$CONTRACT_LINKMAN1).'%\''));
  }
  if (($CONTRACT_LINKMANNAME2 != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_LINKMANNAME2=').$CONTRACT_LINKMANNAME2);
    ($WHERE_STR .= ((' and h.USER_NAME like \'%'.$CONTRACT_LINKMANNAME2).'%\''));
  }
  if (($SELLER_NAME != ''))
  {
    $urlstr = (($urlstr.'&SELLER_NAME=').$SELLER_NAME);
    ($WHERE_STR .= ((' and g.USER_NAME like \'%'.$SELLER_NAME).'%\''));
  }
  if (($CONTRACT_MEMO != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_MEMO=').$CONTRACT_MEMO);
    ($WHERE_STR .= ((' and a.CONTRACT_MEMO like \'%'.$CONTRACT_MEMO).'%\''));
  }
  if (($CONTRACT_ARTICLE != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_ARTICLE=').$CONTRACT_ARTICLE);
    ($WHERE_STR .= ((' and a.CONTRACT_ARTICLE like \'%'.$CONTRACT_ARTICLE).'%\''));
  }
  if (($CONTRACT_CONTENT != ''))
  {
    $urlstr = (($urlstr.'&CONTRACT_CONTENT=').$CONTRACT_CONTENT);
    ($WHERE_STR .= ((' and a.CONTRACT_CONTENT like \'%'.$CONTRACT_CONTENT).'%\''));
  }
  if (($LDATE1 != ''))
  {
    $urlstr = (($urlstr.'&LDATE1=').$LDATE1);
    ($WHERE_STR .= (('  and a.'.$DATE_TYPE).(((''.'_DATE>=\'').$LDATE1).'\'')));
  }
  if (($LDATE2 != ''))
  {
    $urlstr = (($urlstr.'&LDATE2=').$LDATE2);
    ($WHERE_STR .= (('  and a.'.$DATE_TYPE).(((''.'_DATE<=\'').$LDATE2).'\'')));
  }
  if (($SIGN == '0'))
  {
    $urlstr = (($urlstr.'&SIGN=').$SIGN);
    $HAVING = ' HAVING PAYMENT<TOTALPRICE';
  }
  if (($SIGN == '1'))
  {
    $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 = '';
      $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))).'\'');
      ($WHERE_STR .= (((''.' and d.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
      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 != ''))
    {
      $CONTACTID_STR = '';
      $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))
      {
        $CONTACTID_STR = (($CONTACTID_STR.$ROW1['IDENTY_ID']).',');
      }
      $CONTACTID_STR = (('\''.str_replace (',', '\',\'', substr ($CONTACTID_STR, 0, -1))).'\'');
      ($WHERE_STR .= (((''.' and a.CONTRACT_ID in (').$CONTACTID_STR).')'));
      continue;
    }
  }
  $urlstr1 = str_replace ('&', '%', $urlstr);
  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">选择</td>
      <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 == ''))
    {
      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="list.php?';
    echo $urlstr;
    echo '&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
12

list.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 list.php 源码文件，采用 PHP 编程语言编写，共 845 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?