list.php

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

        $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;
    }
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CONTACT\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('CONTACT'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $CONTACTID_STR = '';
      if (($urlstr == ''))
      {
        $urlstr = (($FIELDNO.'=').$$FIELDNO);
      }
      else
      {
        $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      }
      $WHERE_STR1 = ((((' where TABLENAME=\'CONTACT\' 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))).'\'');
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where j.CONTACT_ID in (').$CONTACTID_STR).')'));
        continue;
      }
      else
      {
        ($WHERE_STR .= (((''.' and j.CONTACT_ID in (').$CONTACTID_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 j.CONTACT_ID) AS CONTACTCOUNT,sum(j.TIME_COST) as TOTALTIME,sum(j.MONEY_COST) as TOTALMONEY,CONCAT_WS(\'/\',').$flagstr).') as WHNAME,').$TYPENAME_ARRAY[0]).' as KINDID
        from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
        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 j.SELLER = h.USER_ID
        LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
        LEFT OUTER JOIN SYS_CODE k
        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  else
  {
    $query1 = (((((((('SELECT  '.$TYPENAME_ARRAY[1]).' as SUMNAME, count(DISTINCT j.CONTACT_ID) AS CONTACTCOUNT,sum(j.TIME_COST) as TOTALTIME,sum(j.MONEY_COST) as TOTALMONEY,').$TYPENAME_ARRAY[0]).' as KINDID
        from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
        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 j.SELLER = h.USER_ID
         LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
        LEFT OUTER JOIN SYS_CODE k
        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  $cursor1 = exequery ($connection, $query1);
  echo '<br>
<div align="center">
';
  $CUSTOMER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$CUSTOMER_COUNT;
    $SUMNAME = $ROW['SUMNAME'];
    $CONTACTCOUNT = $ROW['CONTACTCOUNT'];
    $TOTALMONEY = $ROW['TOTALMONEY'];
    $TOTALTIME = $ROW['TOTALTIME'];
    $WHNAME = $ROW['WHNAME'];
    $TOTAL_SUMSALE = ($TOTAL_SUMSALE + $CONTACTCOUNT);
    $TOTAL_PRO_PRICE = ($TOTAL_PRO_PRICE + $TOTALTIME);
    $TOTAL_SER_PRICE = ($TOTAL_SER_PRICE + $TOTALMONEY);
    if (($WHNAME != ''))
    {
      $WHNAME = (('('.$WHNAME).')');
    }
    if (($SUMNAME == ''))
    {
      $SUMNAME = '其他';
    }
    $ARRAY_FIELD = (($ARRAY_FIELD.$SUMNAME).',');
    $graphValuesa = (($graphValuesa.$CONTACTCOUNT).',');
    $graphValuesc = (($graphValuesc.$TOTALMONEY).',');
    $graphValuesb = (($graphValuesb.$TOTALTIME).',');
    if (($urlstr == ''))
    {
      $WHERE_STR1 = ((((((('strwhr1='.$TYPENAME_ARRAY[0]).'&strvalue=').$ROW['KINDID']).'&TYPENAME=').$SUMNAME).'&TYPEIDNAME=').$TYPENAME_ARRAY[2]);
    }
    else
    {
      $WHERE_STR1 = (((((((($urlstr.'&strvalue=').$ROW['KINDID']).'&strwhr1=').$TYPENAME_ARRAY[0]).'&TYPENAME=').$SUMNAME).'&TYPEIDNAME=').$TYPENAME_ARRAY[2]);
    }
    if (($CUSTOMER_COUNT == 1))
    {
      echo '   <table border="0" cellspacing="1" width="70%" class="small" bgcolor="#000000" cellpadding="3">
   <tr class="TableHeader">
      <td nowrap align="center"><a href="list.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="list.php?SUMFIELD=';
      echo $SUMFIELD;
      echo '&';
      echo $urlstr;
      echo '&ORDERFIELD=CONTACTCOUNT&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 == 'CONTACTCOUNT')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CONTACTCOUNT')))
      {
        echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
      }
      echo '</a></td>
      <td nowrap align="center"><a href="list.php?SUMFIELD=';
      echo $SUMFIELD;
      echo '&';
      echo $urlstr;
      echo '&ORDERFIELD=TOTALTIME&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 == 'TOTALTIME')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'TOTALTIME')))
      {
        echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
      }
      echo '</a></td>
      <td nowrap align="center"><a href="list.php?SUMFIELD=';
      echo $SUMFIELD;
      echo '&';
      echo $urlstr;
      echo '&ORDERFIELD=TOTALMONEY&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 == 'TOTALMONEY')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'TOTALMONEY')))
      {
        echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
      }
      echo '</a></td>
      <td nowrap align="center">进一步统计</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 $CONTACTCOUNT;
    echo '</td>
       <td nowrap align="center">';
    echo $TOTALTIME;
    echo '小时</td>
        <td nowrap align="center">';
    echo $TOTALMONEY;
    echo '</td>
      <td nowrap align="left"><input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '1\' value="h.DEPT_ID,i.DEPT_NAME,销售部门" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '1">销售部门</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '2\' value="h.USER_ID,h.USER_NAME,销售人员" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '2">销售人员</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '3\' value="j.CONTACT_TYPE,k.CODE_NAME,客户服务类型" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '3">客户服务类型</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '4\' value="a.CUSTOMER_ID,a.CUSTOMER_NAME,客户"  onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '4">客户</label><br>
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '5\' value="a.CUSTOMER_AREA,d.CODE_NAME,地区" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '5">地区</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '6\' value="a.SOURCE,e.CODE_NAME,客户来源" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '6">客户来源</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '7\' value="a.KIND,c.CODE_NAME,客户类别" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '7">客户类别</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '8\' value="a.SELLMODE,b.CODE_NAME,销售方式" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '8">销售方式</label>
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '9\' value="a.ATTRIBUTE,f.CODE_NAME,行业属性" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '9">行业属性</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '10\' value="a.ENTERTYPE,g.CODE_NAME,企业性质" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '10">企业性质</label>&nbsp;
      </td>
    </tr>
';
  }
  if (($CUSTOMER_COUNT == 0))
  {
    message ('', '无满足条件的客户服务记录');
    button_back ();
    exit ();
  }
  echo ' <tr class="TableHeader">
      <td nowrap align="center">合计：</td>
      <td nowrap align="center">';
  echo $TOTAL_SUMSALE;
  echo '</td>
      <td nowrap align="center">';
  echo $TOTAL_PRO_PRICE;
  echo '小时</td>
       <td nowrap align="center">';
  echo $TOTAL_SER_PRICE;
  echo '</td>
      <td nowrap align="center"></td>
 </tr>
<tr class="TableHeader">
      <td nowrap align="center" colspan=4>统计图&nbsp;&nbsp;（<input type="radio" name=\'FLAG\' id=\'FLAG1\' value="a" checked><label for="FLAG1">服务次数</label>&nbsp;&nbsp;<input type="radio" name=\'FLAG\' id=\'FLAG2\' value="b" ><label for="FLAG2">服务总时间</label> &nbsp;&nbsp;<input type="radio" name=\'FLAG\' id=\'FLAG3\' value="c"><label ';
  echo 'for="FLAG3">服务总成本</label>）</td>
      <td nowrap align="center" ><a href="javascript:LoadWindow1(\'';
  echo $ARRAY_FIELD;
  echo '\',\'';
  echo $graphValuesa;
  echo '\',\'';
  echo $graphValuesb;
  echo '\',\'';
  echo $graphValuesc;
  echo '\',\'1\');"><img src="/images/finance1.gif" align="absmiddle" border=0 WIDTH="22" HEIGHT="22" ></a>
      	&nbsp;&nbsp;&nbsp;<a href="javascript:LoadWindow1(\'';
  echo $ARRAY_FIELD;
  echo '\',\'';
  echo $graphValuesa;
  echo '\',\'';
  echo $graphValuesb;
  echo '\',\'';
  echo $graphValuesc;
  echo '\',\'2\');"><img src="/images/cake.gif" align="absmiddle" border=0  WIDTH="22" HEIGHT="22" ></a></td>
</tr>
</table>
</div>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">
</div>
</body>
</html>
';
?>