📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "\r\n<html>\r\n<head>\r\n<title>销售管线结果 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction chk(input,strwher)\r\n {\r\n URL=\"list1.php?\"+strwher+\"&SUMFIELD=\"+input.value;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n\r\nfunction LoadWindow1(ARRAY_FIELD,graphValues1,graphValues2,graphValues3,showname,type)\r\n {\r\n URL=\"statics?ARRAY_FIELD=\"+ARRAY_FIELD+\"&graphValues1=\"+graphValues1+\"&graphValues2=\"+graphValues2+\"&graphValues3=\"+graphValues3+\"&showname=\"+showname+\"&type=\"+type;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" WIDTH=\"22\" HEIGHT=\"22\" align=\"absmiddle\"><span class=\"big3\"> 销售管线结果</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n";
if ( $ORDERFIELD != "" )
{
if ( $ORDERSIGN == "DOWN" )
{
$ORDERTYPE = "ASC";
}
if ( $ORDERSIGN == "UP" )
{
$ORDERTYPE = "DESC";
}
$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query1 = "SELECT count(CHANCE_ID) COUNT,sum(BARGAIN_MONEY) MONEY from SALE_CHANCE";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TOTAL_COUNT = $ROW['COUNT'];
$TOTAL_MONEY = $ROW['MONEY'];
}
$query1 = "SELECT `CHANCE_STATUS`,count(CHANCE_ID) COUNT,sum(BARGAIN_MONEY) MONEY\r\n\t from SALE_CHANCE GROUP BY `CHANCE_STATUS`".$OREDERBY;
$cursor1 = exequery( $connection, $query1 );
$CHANCE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$CHANCE_COUNT;
$CHANCE_STATUS = $ROW['CHANCE_STATUS'];
$COUNT = $ROW['COUNT'];
$MONEY = $ROW['MONEY'];
$CHANCE_STATUS = get_code_name( $CHANCE_STATUS, "CHANCE_STATUS" );
if ( $CHANCE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
if ( $CHANCE_COUNT == 1 )
{
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $CHANCE_STATUS;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $COUNT;
echo "</td>\r\n <td nowrap align=\"center\">";
echo sprintf( "%.2f", $COUNT / $TOTAL_COUNT * 100 );
echo "%</td>\r\n <td nowrap align=\"center\">";
echo $MONEY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo sprintf( "%.2f", $MONEY / $TOTAL_MONEY * 100 );
echo "%</td>\r\n </tr>\r\n\r\n";
}
if ( $CHANCE_COUNT == 0 )
{
message( "", "无销售管线" );
button_back( );
exit( );
}
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">合计：</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_COUNT;
echo "</td>\r\n <td nowrap align=\"center\"></td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_MONEY;
echo "</td>\r\n <td nowrap align=\"center\"></td>\r\n </tr>\r\n <thead class=\"TableHeader\">\r\n <TD>销售状态</TD>\r\n <TD>任务数</TD>\r\n <TD>任务比例</TD>\r\n <TD>预计总额</TD>\r\n <TD>金额比例</TD>\r\n </thead>\r\n</table>\r\n<br>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -