list.php

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

      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  if (($flagstr != ''))
  {
    $query1 = (((((((((('SELECT  '.$TYPENAME_ARRAY[1]).' as SUMNAME, sum(j.TOTAL_PRICE) AS SUMSALE,sum(j.AMT) as PRO_QTY,sum(j.AMT*PRICE) as PRO_PRICE,(sum(j.TOTAL_PRICE)-sum(j.AMT*PRICE)) as SER_PRICE,CONCAT_WS(\'/\',').$flagstr).') as WHNAME,').$TYPENAME_ARRAY[0]).' as KINDID
        from SALE_HISTORY j
        LEFT OUTER JOIN CUSTOMER a
        ON j.CUSTOMER_ID=a.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.SALESMAN = h.USER_ID
        LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
        LEFT OUTER JOIN PRODUCT  k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE=\'PRO\'
        LEFT OUTER JOIN SYS_CODE m
        ON k.PRODUCT_TYPE = m.CODE_NO AND m.PARENT_NO = \'PRODUCT_MODE\'
        LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE=\'SER\'
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  else
  {
    $query1 = (((((((('SELECT  '.$TYPENAME_ARRAY[1]).' as SUMNAME, sum(j.TOTAL_PRICE) AS SUMSALE,sum(j.AMT) as PRO_QTY,sum(j.AMT*PRICE) as PRO_PRICE,(sum(j.TOTAL_PRICE)-sum(j.AMT*PRICE)) as SER_PRICE,').$TYPENAME_ARRAY[0]).' as KINDID
          from SALE_HISTORY j
          LEFT OUTER JOIN CUSTOMER a
          ON j.CUSTOMER_ID=a.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.SALESMAN = h.USER_ID
         LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
         LEFT OUTER JOIN PRODUCT  k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE=\'PRO\'
         LEFT OUTER JOIN SYS_CODE m
         ON k.PRODUCT_MODE=m.CODE_NO AND m.PARENT_NO = \'PRODUCT_MODE\'
         LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE=\'SER\'
        ').$WHERE_STR).' GROUP BY ').$TYPENAME_ARRAY[0]).$OREDERBY);
  }
  $cursor1 = exequery ($connection, $query1);
  echo '<br>
<div align="center">
';
  $CUSTOMER_COUNT = 0;
  $TOTAL_SUMSALE = 0;
  $TOTAL_PRO_PRICE = 0;
  $TOTAL_SER_PRICE = 0;
  $TOTAL_PRO_QTY = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$CUSTOMER_COUNT;
    $SUMNAME = $ROW['SUMNAME'];
    $SUMSALE = $ROW['SUMSALE'];
    $PRO_QTY = $ROW['PRO_QTY'];
    $PRO_PRICE = $ROW['PRO_PRICE'];
    $SER_PRICE = $ROW['SER_PRICE'];
    $TOTAL_SUMSALE = ($TOTAL_SUMSALE + $SUMSALE);
    $TOTAL_PRO_PRICE = ($TOTAL_PRO_PRICE + $PRO_PRICE);
    $TOTAL_SER_PRICE = ($TOTAL_SER_PRICE + $SER_PRICE);
    $TOTAL_PRO_QTY = ($TOTAL_PRO_QTY + $PRO_QTY);
    $WHNAME = $ROW['WHNAME'];
    if (($WHNAME != ''))
    {
      $WHNAME = (('('.$WHNAME).')');
    }
    if (($SUMNAME == ''))
    {
      $SUMNAME = '其他';
    }
    else
    {
      $ARRAY_FIELD = (($ARRAY_FIELD.$SUMNAME).',');
      $graphValues1 = (($graphValues1.$SUMSALE).',');
      $graphValues2 = (($graphValues2.$PRO_PRICE).',');
      $graphValues3 = (($graphValues3.$SER_PRICE).',');
    }
    if (($TEMPMONTH == '1'))
    {
      if (($urlstr == ''))
      {
        $WHERE_STR1 = ((((('strwhr1=month&strvalue='.$ROW['KINDID']).'&TYPENAME=').$SUMNAME).'&TYPEIDNAME=').$TYPENAME_ARRAY[2]);
      }
      else
      {
        $WHERE_STR1 = (((((((($urlstr.'&strvalue=').$ROW['KINDID']).'&strwhr1=').'month').'&TYPENAME=').$SUMNAME).'&TYPEIDNAME=').$TYPENAME_ARRAY[2]);
      }
    }
    else
    {
      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=SUMSALE&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 == 'SUMSALE')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SUMSALE')))
      {
        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=PRO_PRICE&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 == 'PRO_PRICE')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRO_PRICE')))
      {
        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=PRO_QTY&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 == 'PRO_QTY')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRO_QTY')))
      {
        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=SER_PRICE&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 == 'SER_PRICE')))
      {
        echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
      }
      if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SER_PRICE')))
      {
        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 $SUMSALE;
    echo '</td>
      <td nowrap align="center">';
    echo $PRO_PRICE;
    echo '</td>
      <td nowrap align="center">';
    echo $PRO_QTY;
    echo '</td>
      <td nowrap align="center">';
    echo $SER_PRICE;
    echo '</td>
      <td nowrap align="left">
      <div align="center"><input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '1\' value="YEAR(j.DATE),YEAR(j.DATE),年" 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="MONTH,MONTH,月" 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="a.CUSTOMER_AREA,d.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="j.CUSTOMER_ID,a.CUSTOMER_NAME,客户" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '4">客户</label>
      <br></div>
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '5\' value="h.DEPT_ID,i.DEPT_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="h.USER_NAME,h.USER_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="j.PRODUCT_ID,k.PRODUCT_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="k.PRODUCT_MODE,m.CODE_NAME,产品类别" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '8">产品类别</label>&nbsp;
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '9\' value="j.SERVICE_ID,l.SERVICE_NAME,服务名称" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '9">服务名称</label>
      <br>
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '10\' value="a.SOURCE,e.CODE_NAME,客户来源" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '10">客户来源</label>&nbsp;
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '11\' value="a.KIND,c.CODE_NAME,客户类别" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '11">客户类别</label>&nbsp;
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '12\' value="a.SELLMODE,b.CODE_NAME,销售方式" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '12">销售方式</label>
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '13\' value="a.ATTRIBUTE,f.CODE_NAME,行业属性" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '13">行业属性</label>&nbsp;
      <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '14\' value="a.ENTERTYPE,g.CODE_NAME,企业性质" onclick="return chk(this,\'';
    echo $WHERE_STR1;
    echo '\');"><label for="SUMFIELD';
    echo $CUSTOMER_COUNT;
    echo '14">企业性质</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_PRO_QTY;
  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=5>统计图</td>
      <td nowrap align="center"><a href="javascript:LoadWindow1(\'';
  echo $ARRAY_FIELD;
  echo '\',\'';
  echo $graphValues1;
  echo '\',\'';
  echo $graphValues2;
  echo '\',\'';
  echo $graphValues3;
  echo '\',\'';
  echo $TYPENAME_ARRAY[2];
  echo '\',\'1\');"><img src="/images/finance1.gif" align="absmiddle" WIDTH="22" HEIGHT="22"  border=0 title="柱状图"></a>
      &nbsp;&nbsp;&nbsp;<a href="javascript:LoadWindow1(\'';
  echo $ARRAY_FIELD;
  echo '\',\'';
  echo $graphValues1;
  echo '\',\'';
  echo $graphValues2;
  echo '\',\'';
  echo $graphValues3;
  echo '\',\'';
  echo $TYPENAME_ARRAY[2];
  echo '\',\'2\');"><img src="/images/cake.gif" align="absmiddle" WIDTH="22" HEIGHT="22"  border=0 title="饼状图"></a></td>
</tr>
</table>
</div>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">
</div>
</body>
</html>';
?>