📄 result.php
字号:
<?php
include_once( "inc/auth.php" );
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\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\" align=\"center\">\r\n<tr>\r\n <td class=\"Big\"><img src=\"/images/menu/statistic.gif\" align=\"absmiddle\" width=\"22\" height=\"18\"><span class=\"big3\"> 课程统计结果</span></td>\r\n</tr>\r\n</table><br>\r\n";
if ( $STAT == 1 )
{
$query = "select YEAR(BEGIN_TIME) as MY_YEAR,COUNT(*) as NUM from TRAIN_NEWCOURSE group by YEAR(BEGIN_TIME)";
}
else
{
if ( $STAT == 2 )
{
if ( $YEAR == "" )
{
$YEAR = date( Y, time( ) );
}
$query = "select MONTH(BEGIN_TIME) as MY_YEAR,COUNT(*) as NUM from TRAIN_NEWCOURSE where YEAR(BEGIN_TIME)='".$YEAR."' group by MONTH(BEGIN_TIME)";
}
else
{
if ( $YEAR == "" )
{
$YEAR = date( Y, time( ) );
}
$query = "select TRAIN_TTYPE.TYPE_NAME as MY_YEAR,COUNT(*) as NUM from TRAIN_NEWCOURSE,TRAIN_TTYPE where YEAR(TRAIN_NEWCOURSE.BEGIN_TIME)='".$YEAR."' and TRAIN_NEWCOURSE.TRAIN_TYPE=TRAIN_TTYPE.TYPE_ID group by TRAIN_NEWCOURSE.TRAIN_TYPE";
}
}
$cursor = exequery( $connection, $query );
$YEAR_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$YEAR_COUNT;
$MY_YEAR[$YEAR_COUNT] = $ROW['MY_YEAR'];
if ( $STAT == 2 )
{
$MY_YEAR_STR .= $ROW['MY_YEAR']."月份,";
}
else
{
$MY_YEAR_STR .= $ROW['MY_YEAR'].",";
}
$NUM[$YEAR_COUNT] = $ROW['NUM'];
$NUM_STR .= $ROW['NUM'].",";
}
if ( $STAT_SHOW == 1 && $YEAR_COUNT != 0 )
{
$I = 1;
for ( ; $I <= $YEAR_COUNT; ++$I )
{
if ( $I % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
if ( $I == 1 )
{
echo "<table class=\"TableList\" width=\"50%\" align=\"center\">\r\n <tr class=\"TableHeader\"> \t \r\n <td nowrap align=\"center\">";
if ( $STAT == 1 )
{
echo "年份";
}
if ( $STAT == 2 )
{
echo "月份";
}
if ( $STAT == 3 )
{
echo "培训类别";
}
echo "</td>\r\n <td nowrap align=\"center\">培训课程数量</td>\r\n </tr>\r\n";
}
echo " \r\n <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $MY_YEAR[$I];
echo "</td>\r\n <td nowrap align=\"center\">";
echo $NUM[$I];
echo "</td>\r\n </tr>\r\n \r\n";
}
echo "</table> \r\n";
}
else if ( $STAT_SHOW == 2 && $YEAR_COUNT != 0 )
{
$MODULENAME = "按";
if ( $STAT == 1 )
{
$MODULENAME .= "年份";
}
if ( $STAT == 2 )
{
$MODULENAME .= "月份";
}
if ( $STAT == 3 )
{
$MODULENAME .= "培训类别";
}
$MODULENAME .= "统计培训课程数量图";
echo "<div align=\"center\">\r\n <img src=\"statics/cakeimg.php?ARRAY_FIELD1=";
echo $MY_YEAR_STR;
echo "&GRAPHVALUES1=";
echo $NUM_STR;
echo "&MODULENAME=";
echo $MODULENAME;
echo "\">\r\n</div>\r\n";
}
else if ( $YEAR_COUNT != 0 )
{
echo "<div align=\"center\">\r\n <img src=\"statics/staticspaint.php?ARRAY_FIELD1=";
echo $MY_YEAR_STR;
echo "&GRAPHVALUES1=";
echo $NUM_STR;
echo "&MODULENAME=";
echo urlencode( $MODULENAME );
echo "\">\r\n</div>\r\n";
}
if ( $YEAR_COUNT == 0 )
{
message( "提示", "无统计数据" );
}
button_back( );
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -