📄 list1.php
字号:
{
$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\r\n from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n 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 j.SELLER = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n LEFT OUTER JOIN SYS_CODE k\r\n ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n ".$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\r\n from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n 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 j.SELLER = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n LEFT OUTER JOIN SYS_CODE k\r\n ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
$cursor1 = exequery( $connection, $query1 );
echo "<table cellspacing=\"1\" class=\"small\" cellpadding=\"3\" width=\"90%\">\r\n <tr>\r\n <td align=\"right\"><input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close()\"></td>\r\n </tr>\r\n</table>\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'];
$CONTACTCOUNT = $ROW['CONTACTCOUNT'];
$TOTALMONEY = $ROW['TOTALMONEY'];
$TOTALTIME = $ROW['TOTALTIME'];
$WHNAME = $ROW['WHNAME'];
$TOTAL_SUMSALE += $CONTACTCOUNT;
$TOTAL_PRO_PRICE += $TOTALTIME;
$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 )
{
echo " <tr class=\"TableHeader\">\r\n <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>\r\n </tr>\r\n <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=CONTACTCOUNT&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 "\">服务次数 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CONTACTCOUNT" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CONTACTCOUNT" )
{
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=TOTALTIME&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 "\">服务总时间 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "TOTALTIME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTALTIME" )
{
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=TOTALMONEY&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 "\">服务总成本 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "TOTALMONEY" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTALMONEY" )
{
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 $CONTACTCOUNT;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTALTIME;
echo "小时</td>\r\n <td nowrap align=\"center\">";
echo $TOTALMONEY;
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 <td nowrap align=\"center\">";
echo $TOTAL_PRO_PRICE;
echo "小时</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_SER_PRICE;
echo "</td>\r\n </tr>\r\n<br>\r\n<thead class=\"TableData\">\r\n <td nowrap align=\"center\" colspan=\"4\" width=\"700\" height=\"500\">\r\n <img id=\"graphValuesa\" src=\"statics/cakeimg.php?ARRAY_FIELD1=";
echo $ARRAY_FIELD;
echo "&graphValues1=";
echo $graphValuesa;
echo "&MODULENAME=按服务次数\">\r\n <img id=\"graphValuesb\" style=\"display:none\" src=\"statics/cakeimg.php?ARRAY_FIELD1=";
echo $ARRAY_FIELD;
echo "&graphValues1=";
echo $graphValuesb;
echo "&MODULENAME=按服务时间\">\r\n <img id=\"graphValuesc\" style=\"display:none\" src=\"statics/cakeimg.php?ARRAY_FIELD1=";
echo $ARRAY_FIELD;
echo "&graphValues1=";
echo $graphValuesc;
echo "&MODULENAME=按服务成本\">\r\n</td>\r\n</thead>\r\n</table>\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -