📄 list1.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>客户服务统计结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function chk(input,strwher)
{
if(strwher=="graphValuesa")
{document.all.graphValuesa.style.display='';
document.all.graphValuesb.style.display='none';
document.all.graphValuesc.style.display='none';}
if(strwher=="graphValuesb")
{document.all.graphValuesa.style.display='none';
document.all.graphValuesb.style.display='';
document.all.graphValuesc.style.display='none';}
if(strwher=="graphValuesc")
{document.all.graphValuesa.style.display='none';
document.all.graphValuesb.style.display='none';
document.all.graphValuesc.style.display='';}
}
</script>
</head>
<?
$TYPENAME_ARRAY=explode(",",$SUMFIELD);
//-----------先组织SQL语句-----------
$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."©_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 ='$CRM_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."%'";
}
if($CUSTOMERUSERDEF1!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
$WHERE_STR.=" and a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
$WHERE_STR.=" and a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
$WHERE_STR.=" and a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
$WHERE_STR.=" and a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
$WHERE_STR.=" and a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
if($CONTACT_TYPE!="")
{
$urlstr=$urlstr."&CONTACT_TYPE=".$CONTACT_TYPE;
$WHERE_STR.=" and j.CONTACT_TYPE ='$CONTACT_TYPE'";
}
if($CONTACT_DATE1!="")
{
$urlstr=$urlstr."&CONTACT_DATE1=".$CONTACT_DATE1;
$WHERE_STR.=" and j.CONTACT_DATE>='$CONTACT_DATE1'";
}
if($CONTACT_DATE2!="")
{
$urlstr=$urlstr."&CONTACT_DATE2=".$CONTACT_DATE2;
$WHERE_STR.=" and j.CONTACT_DATE<='$CONTACT_DATE2'";
}
if($SATISFY!="")
{
$urlstr=$urlstr."&SATISFY=".$SATISFY;
$WHERE_STR.=" and j.SATISFY ='$SATISFY'";
}
if($CONTACT_CONTENT!="")
{
$urlstr=$urlstr."&CONTACT_CONTENT=".$CONTACT_CONTENT;
$WHERE_STR.=" and j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
}
if($CONTACTUSERDEF1!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF1=".$CONTACTUSERDEF1;
$WHERE_STR.=" and j.USERDEF1 like '%".$CONTACTUSERDEF1."%'";
}
if($CONTACTUSERDEF2!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF2=".$CONTACTUSERDEF2;
$WHERE_STR.=" and j.USERDEF2 like '%".$CONTACTUSERDEF2."%'";
}
if($CONTACTUSERDEF3!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF3=".$CONTACTUSERDEF3;
$WHERE_STR.=" and j.USERDEF3 like '%".$CONTACTUSERDEF3."%'";
}
if($CONTACTUSERDEF4!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF4=".$CONTACTUSERDEF4;
$WHERE_STR.=" and j.USERDEF4 like '%".$CONTACTUSERDEF4."%'";
}
if($CONTACTUSERDEF5!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF5=".$CONTACTUSERDEF5;
$WHERE_STR.=" and j.USERDEF5 like '%".$CONTACTUSERDEF5."%'";
}
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];
}
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);
?>
<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"];
$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($CUSTOMER_COUNT==1)
{
?>
<tr class="TableHeader">
<td nowrap align="center" colspan=4><input type="radio" name='FLAG' id='FLAG1' value="a" checked onclick="return chk(this,'graphValuesa');"><label for="FLAG1">服务次数</label> <input type="radio" name='FLAG' id='FLAG2' value="b" onclick="return chk(this,'graphValuesb');"><label for="FLAG2">服务总时间</label> <input type="radio" name='FLAG' id='FLAG3' value="c" onclick="return chk(this,'graphValuesc');"><label for="FLAG3">服务总成本</label></td>
</tr>
<tr class="TableHeader">
<td nowrap align="center"><a href="list1.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]?> <? 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="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=CONTACTCOUNT&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?>">服务次数 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CONTACTCOUNT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTACTCOUNT"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=TOTALTIME&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?>">服务总时间 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="TOTALTIME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTALTIME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=TOTALMONEY&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?>">服务总成本 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="TOTALMONEY"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTALMONEY"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></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"><?=$CONTACTCOUNT?></td>
<td nowrap align="center"><?=$TOTALTIME?>小时</td>
<td nowrap align="center"><?=$TOTALMONEY?></td>
</tr>
<?
}
?>
<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>
</tr>
<br>
<div align="center">
<img id="graphValuesa" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValuesa?>&MODULENAME=按服务次数">
<img id="graphValuesb" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValuesb?>&MODULENAME=按服务时间">
<img id="graphValuesc" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValuesc?>&MODULENAME=按服务成本">
</div>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -