📄 list.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
         $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'";
    }
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, 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;
 }
//echo $query1;
$cursor1 = exequery($connection, $query1);
?>
<br>
<div align="center">



<?
  $CUSTOMER_COUNT=0;
  $TOTAL_SUMSALE=0;
  $TOTAL_PRO_PRICE=0;
  $TOTAL_SER_PRICE=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;
    $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)
    {

?>
   <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=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SUMNAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>"><?=$TYPENAME_ARRAY[2]?>&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SUMNAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SUMNAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SUMSALE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售总额&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SUMSALE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SUMSALE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=PRO_PRICE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">产品销售额&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PRO_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRO_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SER_PRICE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">服务销售额&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SER_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SER_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">进一步统计</td>
  </tr>
<?
    }
    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$SUMNAME?></td>
      <td nowrap align="center"><?=$SUMSALE?></td>
      <td nowrap align="center"><?=$PRO_PRICE?></td>
      <td nowrap align="center"><?=$SER_PRICE?></td>
      <td nowrap align="left">
      <div align="center"><input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>1' value="YEAR(j.DATE),YEAR(j.DATE),年" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>1">年</label> &nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>2' value="MONTH,MONTH,月" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>2">月</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>3' value="a.CUSTOMER_AREA,d.CODE_NAME,地区" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>3">地区</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>4' value="j.CUSTOMER_ID,a.CUSTOMER_NAME,客户" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>4">客户</label>
      <br></div>
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>5' value="h.DEPT_ID,i.DEPT_NAME,销售部门" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>5">销售部门</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>6' value="h.USER_NAME,h.USER_NAME,销售人员" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>6">销售人员</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>7' value="j.PRODUCT_ID,k.PRODUCT_NAME,产品名称" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>7">产品名称</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>8' value="k.PRODUCT_MODE,m.CODE_NAME,产品类别" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>8">产品类别</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>9' value="j.SERVICE_ID,l.SERVICE_NAME,服务名称" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>9">服务名称</label>
      <br>
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>10' value="a.SOURCE,e.CODE_NAME,客户来源" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>10">客户来源</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>11' value="a.KIND,c.CODE_NAME,客户类别" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>11">客户类别</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>12' value="a.SELLMODE,b.CODE_NAME,销售方式" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>12">销售方式</label>
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>13' value="a.ATTRIBUTE,f.CODE_NAME,行业属性" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>13">行业属性</label>&nbsp;
      <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>14' value="a.ENTERTYPE,g.CODE_NAME,企业性质" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>14">企业性质</label>&nbsp;
      </td>
    </tr>

<?
}

if($CUSTOMER_COUNT==0)
{
   Message("","无满足条件的销售记录");
   Button_Back();
   exit;
}
?>
 <tr class="TableHeader">
      <td nowrap align="center">合计：</td>
      <td nowrap align="center"><?=$TOTAL_SUMSALE?></td>
      <td nowrap align="center"><?=$TOTAL_PRO_PRICE?></td>
       <td nowrap align="center"><?=$TOTAL_SER_PRICE?></td>
      <td nowrap align="center"></td>
 </tr>

<tr class="TableHeader">
      <td nowrap align="center" colspan=4>统计图</td>
      <td nowrap align="center"><a href="javascript:LoadWindow1('<?=$ARRAY_FIELD?>','<?=$graphValues1?>','<?=$graphValues2?>','<?=$graphValues3?>','<?=$TYPENAME_ARRAY[2]?>','1');"><img src="/images/finance1.gif" align="absmiddle" WIDTH="22" HEIGHT="22"  border=0 title="柱状图"></a>
      	&nbsp;&nbsp;&nbsp;<a href="javascript:LoadWindow1('<?=$ARRAY_FIELD?>','<?=$graphValues1?>','<?=$graphValues2?>','<?=$graphValues3?>','<?=$TYPENAME_ARRAY[2]?>','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>
上一页 12
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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