📄 data_table.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/training.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 评估结果 － ";
echo $ASSESS_OBJ;
echo "</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$query = "select count(*) from TRAIN_ASSESS_DATA where ASSESS_ID=".$ASSESS_ID." and ITEM_ID=''";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ASSESS_DATA_COUNT = $ROW[0];
}
if ( $ASSESS_DATA_COUNT != 0 )
{
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <tr class=\"TableHeader\">\r\n \t<td align=\"center\">评估人</td> \t\r\n";
$query = "SELECT * from TRAIN_ASSESS_ITEM where ASSESS_ID='".$ASSESS_ID."' order by TYPE DESC,ORDER_NO,ITEM_ID DESC";
$cursor = exequery( $connection, $query );
$ASSESS_ITEM_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ASSESS_ITEM_COUNT;
$DISCRIPTION = $ROW['DISCRIPTION'];
$TYPE = $ROW['TYPE'];
$ITEM_ID .= $ROW['ITEM_ID']."~";
if ( $TYPE == 1 )
{
++$ITEM_COUNT;
}
echo " \t \t\r\n \t<td align=\"center\">";
echo $DISCRIPTION;
echo "</td>\r\n";
}
echo " </tr> \r\n";
$query = "select * from TRAIN_ASSESS_TITLE where ASSESS_ID=".$ASSESS_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ANONYMITY = $ROW['ANONYMITY'];
}
$query = "select * from TRAIN_ASSESS_DATA where ASSESS_ID=".$ASSESS_ID." and ITEM_ID=''";
$cursor = exequery( $connection, $query );
$ASSESS_DATA_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ASSESS_DATA_COUNT;
$ASSESS_USER = $ROW['ASSESS_USER'];
$query1 = "select * from USER where USER_ID='".$ASSESS_USER."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
if ( $ANONYMITY == 0 )
{
$USER_NAME = $ROW1['USER_NAME'];
}
else
{
$USER_NAME = "***";
}
}
if ( $ASSESS_DATA_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $USER_NAME;
echo "</td> \t\r\n";
$ASSESS_DATA = $ROW['ASSESS_DATA'];
$MY_DATA[$ASSESS_DATA_COUNT] = explode( "~", $ASSESS_DATA );
$ARRAY_NUM = sizeof( $MY_DATA[$ASSESS_DATA_COUNT] );
$I = 0;
for ( ; $I < $ARRAY_NUM - 1; ++$I )
{
$SUM[$I] += $MY_DATA[$ASSESS_DATA_COUNT][$I];
$MY_ITEM_ID = explode( "~", $ITEM_ID );
$MY_ITEM_ID_COUNT = sizeof( $MY_ITEM_ID );
$J = 0;
for ( ; $J < $MY_ITEM_ID_COUNT - 1; ++$J )
{
$query2 = "select ASSESS_DATA from TRAIN_ASSESS_DATA where ASSESS_ID='".$ASSESS_ID."' and ITEM_ID='{$MY_ITEM_ID[$J]}' and ASSESS_USER='{$ASSESS_USER}' and ITEM_ID!=''";
$cursor2 = exequery( $connection, $query2 );
$ASSESS_DATA2[$J] = "";
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$ASSESS_DATA2[$J] = $ROW2['ASSESS_DATA'];
}
}
echo " \t\r\n <td align=\"center\" title=\"";
echo $ASSESS_DATA2[$I];
echo "\" style=\"cursor:hand\">";
echo str_replace( "\n", "<br>", $MY_DATA[$ASSESS_DATA_COUNT][$I] );
echo " ";
if ( $ASSESS_DATA2[$I] != "" )
{
echo "<font color=red>？</font>";
}
echo "</td>\r\n";
}
echo " </tr>\r\n";
}
if ( 0 < $ITEM_COUNT )
{
echo " \r\n <tr class=\"TableLine1\">\r\n <td nowrap align=\"center\">合计</td> \r\n";
$I = 0;
for ( ; $I < $ARRAY_NUM - 1; ++$I )
{
echo " <td nowrap align=\"center\">";
if ( $SUM[$I] != 0 )
{
echo $SUM[$I];
}
echo "</td>\r\n";
}
echo " </tr> \r\n <tr class=\"TableLine2\">\r\n <td nowrap align=\"center\">均值</td> \r\n";
$I = 0;
for ( ; $I < $ARRAY_NUM - 1; ++$I )
{
echo " <td nowrap align=\"center\">";
if ( $SUM[$I] != 0 )
{
echo round( $SUM[$I] / $ASSESS_DATA_COUNT, 2 );
}
echo "</td>\r\n";
}
echo " </tr>\r\n";
}
echo " \r\n\r\n <tr class=\"TableControl\">\r\n \t <td align=\"center\"colspan=\"";
echo $ASSESS_ITEM_COUNT + 1;
echo "\">\r\n <input type=\"button\" value=\"导出\" class=\"BigButton\" onclick=\"location='export.php?ASSESS_ID=";
echo $ASSESS_ID;
echo "'\" title=\"导出评估信息\" name=\"button\"> \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n </td>\r\n </tr> \r\n</table>\r\n\r\n";
}
else
{
message( "提示", "没有评估数据" );
echo "<br>\r\n<div align=\"center\"><input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"window.close();\" title=\"关闭窗口\"></div>\r\n";
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -