📄 list.php
字号:
else $urlstr=$urlstr."&ENTERMEMO=".$ENTERMEMO;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ENTERMEMO like '%".$ENTERMEMO."%'";
else
$WHERE_STR.=" and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if($CUSTOMERUSERDEF1!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
else $urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
else
$WHERE_STR.=" and a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
else $urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
else
$WHERE_STR.=" and a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
else $urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
else
$WHERE_STR.=" and a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
else $urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
else
$WHERE_STR.=" and a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
else $urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
else
$WHERE_STR.=" and a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
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);
?>
<br>
<div align="center">
<?
$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.")";
if($SUMNAME=="")$SUMNAME="其他";
$ARRAY_FIELD=$ARRAY_FIELD.$SUMNAME.",";
$graphValues=$graphValues.$CUSTOMERCOUNT.",";
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]?> <? 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=CUSTOMERCOUNT&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?>">客户数<?=$WHNAME?> <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMERCOUNT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMERCOUNT"){?><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"><?=$CUSTOMERCOUNT?></td>
<td nowrap align="center"><input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>1' value="h.DEPT_ID,i.DEPT_NAME,销售部门" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>1">销售部门</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>2' value="h.USER_NAME,h.USER_NAME,销售人员" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>2">销售人员</label>
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>3' value="a.CUSTOMER_AREA,d.CODE_NAME,地区" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>3">地区</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>4' value="a.SOURCE,e.CODE_NAME,客户来源" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>4">客户来源</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>5' value="a.KIND,c.CODE_NAME,客户类别" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>5">客户类别</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>6' value="a.SELLMODE,b.CODE_NAME,销售方式" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>6">销售方式</label>
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>7' value="a.ATTRIBUTE,f.CODE_NAME,行业属性" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>7">行业属性</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>8' value="a.ENTERTYPE,g.CODE_NAME,企业性质" onclick="return chk(this,'<?=$WHERE_STR1?>');"><label for="SUMFIELD<?=$CUSTOMER_COUNT?><?=$CUSTOMER_COUNT?>8">企业性质</label>
</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"></td>
</tr>
<tr class="TableHeader">
<td nowrap align="center" colspan=2>统计图</td>
<td nowrap align="center"><a href="javascript:LoadWindow1('<?=$ARRAY_FIELD?>','<?=$graphValues?>','1');"><img WIDTH="22" HEIGHT="22" src="/images/finance1.gif" align="absmiddle" border=0 title="柱状图"></a>
<a href="javascript:LoadWindow1('<?=$ARRAY_FIELD?>','<?=$graphValues?>','2');"><img WIDTH="22" HEIGHT="22" src="/images/cake.gif" align="absmiddle" 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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -