📄 list1.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "<html>\r\n<head>\r\n<title>客户统计结果 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n";
$TYPENAME_ARRAY = explode( ",", $SUMFIELD );
$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 .= ",e.CODE_NAME";
}
$WHERE_STR .= " and a.SOURCE ='".$SOURCE."'";
}
if ( $KIND != "" )
{
$urlstr = $urlstr."&KIND=".$KIND;
if ( $flagstr == "" )
{
$flagstr = "c.CODE_NAME";
}
else
{
$flagstr .= ",c.CODE_NAME";
}
$WHERE_STR .= " and a.KIND ='".$KIND."'";
}
if ( $SELLMODE != "" )
{
$urlstr = $urlstr."&SELLMODE=".$SELLMODE;
if ( $flagstr == "" )
{
$flagstr = "b.CODE_NAME";
}
else
{
$flagstr .= ",b.CODE_NAME";
}
$WHERE_STR .= " and a.SELLMODE ='".$SELLMODE."'";
}
if ( $ATTRIBUTE != "" )
{
$urlstr = $urlstr."&ATTRIBUTE=".$ATTRIBUTE;
if ( $flagstr == "" )
{
$flagstr = "f.CODE_NAME";
}
else
{
$flagstr .= ",f.CODE_NAME";
}
$WHERE_STR .= " and a.ATTRIBUTE ='".$ATTRIBUTE."'";
}
if ( $ENTERTYPE != "" )
{
$urlstr = $urlstr."&ENTERTYPE=".$ENTERTYPE;
if ( $flagstr == "" )
{
$flagstr = "g.CODE_NAME";
}
else
{
$flagstr .= ",g.CODE_NAME";
}
$WHERE_STR .= " and a.ENTERTYPE ='".$ENTERTYPE."'";
}
if ( $ENTERMEMO != "" )
{
$urlstr = $urlstr."&ENTERMEMO=".$ENTERMEMO;
$WHERE_STR .= " and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELDNO = "CUSTOMER".$ROW['FIELDNO'];
if ( $$FIELDNO != "" )
{
$CUSTOMERID_STR = "";
if ( $urlstr == "" )
{
$urlstr = $FIELDNO."=".$$FIELDNO;
}
else
{
$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.")";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
}
}
}
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\r\n from CUSTOMER a LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n ".$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\r\n from CUSTOMER a LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
$cursor1 = exequery( $connection, $query1 );
echo "\r\n<table cellspacing=\"1\" class=\"small\" cellpadding=\"3\" width=\"80%\">\r\n <tr>\r\n <td nowrap class=\"TableData\"><b>";
echo $TYPEIDNAME;
echo "</b>为<b>";
echo $TYPENAME;
echo "</b>的客户，按<b>";
echo $TYPENAME_ARRAY[2];
echo "</b>分布状况如下：</td>\r\n <td align=\"right\"><input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close()\"></td>\r\n </tr>\r\n</table>\r\n<br>\r\n<div align=\"center\">\r\n<table width=\"70%\" class=\"TableBlock\">\r\n";
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$CUSTOMER_COUNT;
$SUMNAME = $ROW['SUMNAME'];
$CUSTOMERCOUNT = $ROW['CUSTOMERCOUNT'];
$WHNAME = $ROW['WHNAME'];
$TOTAL_SUMSALE += $CUSTOMERCOUNT;
if ( $WHNAME != "" )
{
$WHNAME = "(".$WHNAME.")";
}
$ARRAY_FIELD = $ARRAY_FIELD.$SUMNAME.",";
$graphValues = $graphValues.$CUSTOMERCOUNT.",";
if ( $urlstr == "" )
{
$WHERE_STR1 = "strwhr1=".$TYPENAME_ARRAY[0]."&strvalue=".$ROW['KINDID'];
}
else
{
$WHERE_STR1 = $urlstr."&strvalue=".$ROW['KINDID']."&strwhr1=".$TYPENAME_ARRAY[0];
}
if ( $CUSTOMER_COUNT == 1 )
{
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\"><a href=\"list1.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 " ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SUMNAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SUMNAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"list1.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=CUSTOMERCOUNT&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 $WHNAME;
echo " ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CUSTOMERCOUNT" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMERCOUNT" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n </tr>\r\n";
}
if ( $CUSTOMER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $SUMNAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $CUSTOMERCOUNT;
echo "</td>\r\n </tr>\r\n\r\n";
}
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">合计：</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_SUMSALE;
echo "</td>\r\n </tr>\r\n<thead class=\"TableData\">\r\n <td nowrap align=\"center\" colspan=\"2\" width=\"700\" height=\"500\"><img src=\"statics/cakeimg.php?ARRAY_FIELD1=";
echo $ARRAY_FIELD;
echo "&graphValues1=";
echo $graphValues;
echo "\"></td>\r\n</thead>\r\n</table>\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -