list1.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 377 行
PHP
377 行
<?
  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">
</head>
';
  $TYPENAME_ARRAY = explode (',', $SUMFIELD);
  $urlstr = ('strwhr1='.$strwhr1);
  $urlstr = (($urlstr.'&strvalue=').$strvalue);
  $WHERE_STR = ((' where '.$strwhr1).(((''.'=\'').$strvalue).'\''));
  if (($TO_ID != ''))
  {
    $urlstr = (($urlstr.'&TO_ID=').$TO_ID);
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
    ($WHERE_STR .= (((''.' and h.DEPT_ID in (').$TO_ID).')'));
  }
  if (($COPY_TO_ID != ''))
  {
    $urlstr = (($urlstr.'&COPY_TO_ID=').$COPY_TO_ID);
    $COPY_TO_ID = (('\''.str_replace (',', '\',\'', substr ($COPY_TO_ID, 0, -1))).'\'');
    ($WHERE_STR .= (((''.' and a.SELLER in (').$COPY_TO_ID).')'));
  }
  if (($SELL_MANAGEID != ''))
  {
    $urlstr = (($urlstr.'&SELL_MANAGEID=').$SELL_MANAGEID);
    ($WHERE_STR .= (((''.' and a.SELLER in (').$COPY_TO_ID).')'));
  }
  if (($CUSTOMER_NAME != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
    ($WHERE_STR .= ((' and a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($CUSTOMER_CODE != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
    ($WHERE_STR .= ((' and a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
  }
  if (($CUSTOMER_SHORT != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
    ($WHERE_STR .= ((' and a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
  }
  if (($CUSTOMER_AREA != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
    ($WHERE_STR .= (((''.' and a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
  }
  if (($CUSTOMER_ADD != ''))
  {
    $urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_ADD);
    ($WHERE_STR .= ((' and a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
  }
  if (($SOURCE != ''))
  {
    $urlstr = (($urlstr.'&SOURCE=').$SOURCE);
    if (($flagstr == ''))
    {
      $flagstr = 'e.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',e.CODE_NAME');
    }
    ($WHERE_STR .= (((''.' and a.SOURCE =\'').$SOURCE).'\''));
  }
  if (($KIND != ''))
  {
    $urlstr = (($urlstr.'&KIND=').$KIND);
    if (($flagstr == ''))
    {
      $flagstr = 'c.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',c.CODE_NAME');
    }
    ($WHERE_STR .= (((''.' and a.KIND =\'').$KIND).'\''));
  }
  if (($SELLMODE != ''))
  {
    $urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
    if (($flagstr == ''))
    {
      $flagstr = 'b.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',b.CODE_NAME');
    }
    ($WHERE_STR .= (((''.' and a.SELLMODE =\'').$SELLMODE).'\''));
  }
  if (($ATTRIBUTE != ''))
  {
    $urlstr = (($urlstr.'&ATTRIBUTE=').$ATTRIBUTE);
    if (($flagstr == ''))
    {
      $flagstr = 'f.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',f.CODE_NAME');
    }
    ($WHERE_STR .= (((''.' and a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
  }
  if (($ENTERTYPE != ''))
  {
    $urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
    if (($flagstr == ''))
    {
      $flagstr = 'g.CODE_NAME';
    }
    else
    {
      $flagstr = ($flagstr.',g.CODE_NAME');
    }
    ($WHERE_STR .= (((''.' and a.ENTERTYPE =\'').$ENTERTYPE).'\''));
  }
  if (($ENTERMEMO != ''))
  {
    $urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
    ($WHERE_STR .= ((' and a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
  }
  $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'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  if (($flagstr != ''))
  {
    $query1 = (((((((((('SELECT  '.$TYPENAME_ARRAY[1]).' as SUMNAME, count(DISTINCT a.CUSTOMER_ID) AS CUSTOMERCOUNT,CONCAT_WS(\'/\',').$flagstr).') as WHNAME,').$TYPENAME_ARRAY[0]).' as KINDID
        from CUSTOMER a LEFT OUTER JOIN SYS_CODE b
        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = \'SELL_MODE\'
        LEFT OUTER JOIN SYS_CODE c
        ON a.KIND = c.CODE_NO AND c.PARENT_NO = \'CRM_KIND\'
        LEFT OUTER JOIN SYS_CODE d
        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = \'AREA\'
        LEFT OUTER JOIN SYS_CODE e
        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = \'CRM_SOURCE\'
        LEFT OUTER JOIN SYS_CODE f
        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = \'CRM_ATTRIBUTE\'
        LEFT OUTER JOIN SYS_CODE g
        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = \'CRM_TYPE\'
        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
        LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  else
  {
    $query1 = (((((((('SELECT  '.$TYPENAME_ARRAY[1]).' as SUMNAME, count(DISTINCT a.CUSTOMER_ID) AS CUSTOMERCOUNT,').$TYPENAME_ARRAY[0]).' as KINDID
        from CUSTOMER a LEFT OUTER JOIN SYS_CODE b
        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = \'SELL_MODE\'
        LEFT OUTER JOIN SYS_CODE c
        ON a.KIND = c.CODE_NO AND c.PARENT_NO = \'CRM_KIND\'
        LEFT OUTER JOIN SYS_CODE d
        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = \'AREA\'
        LEFT OUTER JOIN SYS_CODE e
        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = \'CRM_SOURCE\'
        LEFT OUTER JOIN SYS_CODE f
        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = \'CRM_ATTRIBUTE\'
        LEFT OUTER JOIN SYS_CODE g
        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = \'CRM_TYPE\'
        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
        LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  $cursor1 = exequery ($connection, $query1);
  echo '
<table cellspacing="1" class="small" cellpadding="3">
<tr>
    <td nowrap class="TableData"><b>';
  echo $TYPEIDNAME;
  echo '</b>为<b>';
  echo $TYPENAME;
  echo '</b>的客户，按<b>';
  echo $TYPENAME_ARRAY[2];
  echo '</b>分布状况如下：</td>
</table>
<br>
<div align="center">
<table border="0" cellspacing="1" width="70%" class="small" bgcolor="#000000" cellpadding="3">
';
  $CUSTOMER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$CUSTOMER_COUNT;
    $SUMNAME = $ROW['SUMNAME'];
    $CUSTOMERCOUNT = $ROW['CUSTOMERCOUNT'];
    $WHNAME = $ROW['WHNAME'];
    $TOTAL_SUMSALE = ($TOTAL_SUMSALE + $CUSTOMERCOUNT);
    if (($WHNAME != ''))
    {
      $WHNAME = (('('.$WHNAME).')');
    }
    $ARRAY_FIELD = (($ARRAY_FIELD.$SUMNAME).',');
    $graphValues = (($graphValues.$CUSTOMERCOUNT).',');
    if (($urlstr == ''))
    {
      $WHERE_STR1 = ((('strwhr1='.$TYPENAME_ARRAY[0]).'&strvalue=').$ROW['KINDID']);
    }
    else
    {
      $WHERE_STR1 = (((($urlstr.'&strvalue=').$ROW['KINDID']).'&strwhr1=').$TYPENAME_ARRAY[0]);
    }
    if (($CUSTOMER_COUNT == 1))
    {
      echo '   <tr class="TableHeader">
      <td nowrap align="center"><a href="list1.php?SUMFIELD=';
      echo $SUMFIELD;
      echo '&';
      echo $urlstr;
      echo '&ORDERFIELD=SUMNAME&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 '">';
      echo $TYPENAME_ARRAY[2];
      echo '&nbsp;';
      if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'SUMNAME')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SUMNAME')))
      {
        echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
      }
      echo '</a></td>
      <td nowrap align="center"><a href="list1.php?SUMFIELD=';
      echo $SUMFIELD;
      echo '&';
      echo $urlstr;
      echo '&ORDERFIELD=CUSTOMERCOUNT&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 '">客户数';
      echo $WHNAME;
      echo '&nbsp;';
      if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMERCOUNT')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMERCOUNT')))
      {
        echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
      }
      echo '</a></td>
  </tr>
';
    }
    if ((($CUSTOMER_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $SUMNAME;
    echo '</td>
      <td nowrap align="center">';
    echo $CUSTOMERCOUNT;
    echo '</td>
     </tr>
';
  }
  echo ' <tr class="TableHeader">
      <td nowrap align="center">合计：</td>
      <td nowrap align="center">';
  echo $TOTAL_SUMSALE;
  echo '</td>
 </tr>
<br>
<div align="center">
 <img src="statics/cakeimg.php?ARRAY_FIELD1=';
  echo $ARRAY_FIELD;
  echo '&graphValues1=';
  echo $graphValues;
  echo '">
</div>
</table>
</div>
</body>
</html>';
?>
list1.php - 源码说明

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

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