list.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 1,014 行 · 第 1/2 页
PHP
1,014 行
<?
  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 chk(input,strwher)
{
  URL="list1.php?"+strwher+"&SUMFIELD="+input.value;
  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 LoadWindow1(ARRAY_FIELD,graphValues1,graphValues2,graphValues3,showname,type)
{ ';
  echo ' 
  URL="statics?ARRAY_FIELD="+ARRAY_FIELD+"&graphValues1="+graphValues1+"&graphValues2="+graphValues2+"&graphValues3="+graphValues3+"&showname="+showname+"&type="+type; 
  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");
}
</script>
</head>
<body class="bod';
  echo 'ycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3">&nbsp;&nbsp;销售统计结果</span><br>
    </td>
  </tr>
</table>
';
  $TYPENAME_ARRAY = explode (',', $SUMFIELD);
  if (($TYPENAME_ARRAY[0] == 'MONTH'))
  {
    $TYPENAME_ARRAY[0] = 'CONCAT_WS(\'-\', YEAR(j.DATE) , MONTH(j.DATE))';
    $TYPENAME_ARRAY[1] = 'CONCAT_WS(\'-\', YEAR(j.DATE) , MONTH(j.DATE))';
    $TEMPMONTH = '1';
  }
  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 j.SALESMAN in (').$COPY_TO_ID).')'));
    }
    else
    {
      ($WHERE_STR .= (((''.' and j.SALESMAN 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 h.DEPT_ID in (').$TO_ID).')'));
    }
    else
    {
      ($WHERE_STR .= (((''.' and h.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 a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.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 a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.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 a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.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 a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
  }
  if (($CUSTOMER_ADD != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_ADD='.$CUSTOMER_ADD);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_ADD);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
  }
  if (($SOURCE != ''))
  {
    if (($flagstr == ''))
    {
      $flagstr = 'e.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',e.CODE_NAME');
    }
    if (($urlstr == ''))
    {
      $urlstr = ('SOURCE='.$SOURCE);
    }
    else
    {
      $urlstr = (($urlstr.'&SOURCE=').$SOURCE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.SOURCE =\'').$SOURCE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.SOURCE =\'').$SOURCE).'\''));
    }
  }
  if (($KIND != ''))
  {
    if (($flagstr == ''))
    {
      $flagstr = 'c.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',c.CODE_NAME');
    }
    if (($urlstr == ''))
    {
      $urlstr = ('KIND='.$KIND);
    }
    else
    {
      $urlstr = (($urlstr.'&KIND=').$KIND);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.KIND =\'').$KIND).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.KIND =\'').$KIND).'\''));
    }
  }
  if (($SELLMODE != ''))
  {
    if (($flagstr == ''))
    {
      $flagstr = 'b.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',b.CODE_NAME');
    }
    if (($urlstr == ''))
    {
      $urlstr = ('SELLMODE='.$SELLMODE);
    }
    else
    {
      $urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.SELLMODE =\'').$SELLMODE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.SELLMODE =\'').$SELLMODE).'\''));
    }
  }
  if (($ATTRIBUTE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ATTRIBUTE='.$ATTRIBUTE);
    }
    else
    {
      $urlstr = (($urlstr.'&ATTRIBUTE=').$ATTRIBUTE);
    }
    if (($flagstr == ''))
    {
      $flagstr = 'f.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',f.CODE_NAME');
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
  }
  if (($ENTERTYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERTYPE='.$ENTERTYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
    }
    if (($flagstr == ''))
    {
      $flagstr = 'g.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',g.CODE_NAME');
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
  }
  if (($ENTERMEMO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERMEMO='.$ENTERMEMO);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
  }
  if (($PRODUCT_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('PRODUCT_NAME='.$PRODUCT_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&PRODUCT_NAME=').$PRODUCT_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where k.PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and k.PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
    }
  }
  if (($PRODUCT_MODE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('PRODUCT_MODE='.$PRODUCT_MODE);
    }
    else
    {
      $urlstr = (($urlstr.'&PRODUCT_MODE=').$PRODUCT_MODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where k.PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and k.PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
    }
  }
  if (($PRODUCT_TYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('PRODUCT_TYPE='.$PRODUCT_TYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&PRODUCT_TYPE=').$PRODUCT_TYPE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where k.PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and k.PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
    }
  }
  if (($SERVICE_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SERVICE_NAME='.$SERVICE_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&SERVICE_NAME=').$SERVICE_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where l.SERVICE_NAME like \'%'.$SERVICE_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and l.SERVICE_NAME like \'%'.$SERVICE_NAME).'%\''));
    }
  }
  if (($SERVICE_DESC != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SERVICE_DESC='.$SERVICE_DESC);
    }
    else
    {
      $urlstr = (($urlstr.'&SERVICE_DESC=').$SERVICE_DESC);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where l.SERVICE_DESC like \'%'.$SERVICE_DESC).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and l.SERVICE_DESC like \'%'.$SERVICE_DESC).'%\''));
    }
  }
  if (($DATE1 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('DATE1='.$DATE1);
    }
    else
    {
      $urlstr = (($urlstr.'&DATE1=').$DATE1);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.DATE>=\'').$DATE1).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and j.DATE>=\'').$DATE1).'\''));
    }
  }
  if (($DATE2 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('DATE2='.$DATE2);
    }
    else
    {
      $urlstr = (($urlstr.'&DATE2=').$DATE2);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.DATE<=\'').$DATE2).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and j.DATE<=\'').$DATE2).'\''));
    }
  }
  $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 a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      continue;
    }
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
list.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 list.php 源码文件，采用 PHP 编程语言编写，共 1,014 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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