list.php

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

PHP
1,174 行
字号
123
<?
  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 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 show_detail(CONTRACT_ID)
  {
    URL="linelist.php?CONTRACT_ID="+CONTRACT_ID;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
function show_detail1(CONTRACT_ID)
  {
    URL="historylist.php?CONTRACT_ID="+CONTRACT_ID;
    mylef';
  echo 't=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
function show_detail2(CONTRACT_ID)
  {
    URL="contractlist.php?CONTRACT_ID="+CONTRACT_ID;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no';
  echo ',menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }  
</script>
</head>
';
  if (($COPY_TO_ID != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('COPY_TO_ID='.$COPY_TO_ID);
    }
    else
    {
      $urlstr = (($urlstr.'&COPY_TO_ID=').$COPY_TO_ID);
    }
    $COPY_TO_ID = (('\''.str_replace (',', '\',\'', substr ($COPY_TO_ID, 0, -1))).'\'');
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.'.$SELLER_TYPE).(((''.' in (').$COPY_TO_ID).')')));
    }
    else
    {
      ($WHERE_STR .= ((' and a.'.$SELLER_TYPE).(((''.'  in (').$COPY_TO_ID).')')));
    }
  }
  if (($TO_ID != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('TO_ID='.$TO_ID);
    }
    else
    {
      $urlstr = (($urlstr.'&TO_ID=').$TO_ID);
    }
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where g.DEPT_ID in (').$TO_ID).')'));
    }
    else
    {
      ($WHERE_STR .= (((''.' and g.DEPT_ID in (').$TO_ID).')'));
    }
  }
  if (($CUSTOMER_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_NAME='.$CUSTOMER_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where d.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and d.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
    }
  }
  if (($CUSTOMER_CODE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_CODE='.$CUSTOMER_CODE);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where d.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and d.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
    }
  }
  if (($CUSTOMER_SHORT != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_SHORT='.$CUSTOMER_SHORT);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where d.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and d.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
    }
  }
  if (($CUSTOMER_AREA != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_AREA='.$CUSTOMER_AREA);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
  }
  if (($CUSTOMER_ADD != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_ADD='.$CUSTOMER_AREA);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_AREA);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where d.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and d.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
  }
  if (($SOURCE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SOURCE='.$SOURCE);
    }
    else
    {
      $urlstr = (($urlstr.'&SOURCE=').$SOURCE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.SOURCE =\'').$SOURCE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.SOURCE =\'').$SOURCE).'\''));
    }
  }
  if (($KIND != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('KIND='.$KIND);
    }
    else
    {
      $urlstr = (($urlstr.'&KIND=').$KIND);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.KIND =\'').$KIND).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.KIND =\'').$KIND).'\''));
    }
  }
  if (($SELLMODE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SELLMODE='.$SELLMODE);
    }
    else
    {
      $urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.SELLMODE =\'').$SELLMODE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.SELLMODE =\'').$SELLMODE).'\''));
    }
  }
  if (($ATTRIBUTE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ATTRIBUTE='.$ATTRIBUTE);
    }
    else
    {
      $urlstr = (($urlstr.'&ATTRIBUTE=').$SELLMODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
  }
  if (($ENTERTYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERTYPE='.$ENTERTYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where d.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and d.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
  }
  if (($ENTERMEMO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERMEMO='.$ENTERMEMO);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where d.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and d.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
  }
  if (($CONTRACT_TYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_TYPE='.$CONTRACT_TYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_TYPE=').$CONTRACT_TYPE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.CONTRACT_TYPE =\'').$CONTRACT_TYPE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.CONTRACT_TYPE =\'').$CONTRACT_TYPE).'\''));
    }
  }
  if (($CONTRACT_NO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_NO='.$CONTRACT_NO);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_NO=').$CONTRACT_NO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_NO like \'%'.$CONTRACT_NO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_NO like \'%'.$CONTRACT_NO).'%\''));
    }
  }
  if (($CONTRACT_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_NAME='.$CONTRACT_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_NAME=').$CONTRACT_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_NAME like \'%'.$CONTRACT_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_NAME like \'%'.$CONTRACT_NAME).'%\''));
    }
  }
  if (($CONTRACT_LINKMAN1 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_LINKMAN1='.$CONTRACT_LINKMAN1);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_LINKMAN1=').$CONTRACT_LINKMAN1);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CONTRACT_LINKMAN1 like \'%'.$CONTRACT_LINKMAN1).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CONTRACT_LINKMAN1 like \'%'.$CONTRACT_LINKMAN1).'%\''));
    }
  }
  if (($CONTRACT_LINKMANNAME2 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTRACT_LINKMANNAME2='.$CONTRACT_LINKMANNAME2);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTRACT_LINKMANNAME2=').$CONTRACT_LINKMANNAME2);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where h.USER_NAME like \'%'.$CONTRACT_LINKMANNAME2).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and h.USER_NAME like \'%'.$CONTRACT_LINKMANNAME2).'%\''));
    }
  }
  if (($SELLER_NAME != ''))
  {
    if (($urlstr == ''))
    {
123

list.php - 源码说明

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

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

⌨️ 快捷键说明

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