📄 result.php
字号:
<?php
include_once( "inc/utility_all.php" );
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from SCORE_DATE where FLOW_ID='".$FLOW_ID."' group by PARTICIPANT";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID[$VOTE_COUNT] = $ROW['PARTICIPANT'];
$query1 = "SELECT `USER_ID` , `USER_NAME` , PRIV_NAME, DEPT_NAME FROM `USER` a LEFT OUTER JOIN DEPARTMENT b ON a.DEPT_ID = b.DEPT_ID LEFT OUTER JOIN USER_PRIV c ON a.USER_PRIV = c.USER_PRIV where a.USER_ID='".$USER_ID[$VOTE_COUNT]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME[$VOTE_COUNT] = $ROW['USER_NAME'];
}
$USER_PRIV[$VOTE_COUNT] = $ROW['PRIV_NAME'];
$USER_DEPT[$VOTE_COUNT] = $ROW['DEPT_NAME'];
++$VOTE_COUNT;
}
$query = "SELECT * from SCORE_ITEM where GROUP_ID='".$GROUP_ID."'";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
$TOTAL_SAM = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_NAME[$VOTE_COUNT] = $ROW['ITEM_NAME'];
$TOTAL_SAM += $ROW['MAX'];
++$VOTE_COUNT;
}
$ARRAY_COUNT = sizeof( $USER_ID );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$query1 = "select SCORE from SCORE_DATE where PARTICIPANT='".$USER_ID[$I]."' and FLOW_ID='{$FLOW_ID}'";
$cursor1 = exequery( $connection, $query1 );
$COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SCORE = $ROW['SCORE'];
$MY_SCORE[$I][$COUNT] = explode( ",", $SCORE );
++$COUNT;
}
}
$USER_COUNT = sizeof( $USER_ID );
$field_count = sizeof( $MY_SCORE[0][0] );
$count = 0;
for ( ; $count < $field_count; ++$count )
{
$I = 0;
for ( ; $I < $USER_COUNT; ++$I )
{
$RECORD_COUNT = sizeof( $MY_SCORE[$I] );
$field = 0;
for ( ; $field < $RECORD_COUNT; ++$field )
{
$MY_SCORESAM[$I][$count] = $MY_SCORESAM[$I][$count] + $MY_SCORE[$I][$field][$count];
if ( $MY_SCORE[$I][$field][$count] != 0 )
{
$MY_SCORECOUNT[$I][$count] = $MY_SCORECOUNT[$I][$count] + 1;
}
}
}
}
$ARRAY_COUNT = sizeof( $USER_NAME );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$ARRAY_COUNT1 = sizeof( $MY_SCORESAM[$I] );
$count = 0;
for ( ; $count < $ARRAY_COUNT1 - 1; ++$count )
{
if ( $MY_SCORECOUNT[$I][$count] == "" )
{
$MY_AVE[$I][$count] = 0;
}
else
{
$MY_AVE[$I][$count] = round( $MY_SCORESAM[$I][$count] / $MY_SCORECOUNT[$I][$count], 2 );
}
}
}
$ARRAY_COUNT = sizeof( $USER_NAME );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$TOTAL = 0;
$ARRAY_COUNT1 = sizeof( $MY_AVE[$I] );
$count = 0;
for ( ; $count < $ARRAY_COUNT1; ++$count )
{
$TOTAL += $MY_AVE[$I][$count];
}
$USER_SAM[$I] = $TOTAL;
}
$ARRAY_STATIS = explode( ",", $STATICS );
$ARRAY_COUNT = sizeof( $ARRAY_STATIS );
$USER_SAM_COUNT = sizeof( $USER_SAM );
$temp = 0;
$a = 0;
$i = 0;
for ( ; $i < $ARRAY_COUNT; $i += 2 )
{
if ( $i + 1 < $ARRAY_COUNT )
{
$ARRAY_FIELD[$temp] = $ARRAY_STATIS[$i]."-".$ARRAY_STATIS[$i + 1];
$FIELD_VALUE = 0;
$count = 0;
for ( ; $count < $USER_SAM_COUNT; ++$count )
{
if ( !( $USER_SAM[$count] <= $ARRAY_STATIS[$i] ) && !( $ARRAY_STATIS[$i + 1] <= $USER_SAM[$count] ) )
{
++$FIELD_VALUE;
$USER_COUNTNAME[$temp][$a] = $USER_NAME[$count];
$a += 1;
}
}
$graphValues[$temp] = $FIELD_VALUE;
}
else
{
$ARRAY_FIELD[$temp] = $ARRAY_STATIS[$i]."-0";
$FIELD_VALUE = 0;
$count = 0;
for ( ; $count < $USER_SAM_COUNT; ++$count )
{
if ( !( $USER_SAM[$count] <= $ARRAY_STATIS[$i] ) && !( 0 <= $USER_SAM[$count] ) )
{
++$FIELD_VALUE;
$USER_COUNTNAME[$temp][$a] = $USER_NAME[$count];
$a += 1;
}
}
$graphValues[$temp] = $FIELD_VALUE;
}
++$temp;
$a = 0;
}
echo "<html>\r\n<head>\r\n<title>分值统计结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n\r\n<body topmargin=\"0\" leftmargin=\"0\">\r\n\r\n<TABLE>\r\n\t<tr>\r\n\t\t<td> </td>\r\n\t</tr>\r\n <TR>\r\n <TD>\r\n <img src=\"staticspaint.php?GROUP_ID=";
echo $GROUP_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&STATICS=";
echo $STATICS;
echo "\" align=\"absmiddle\">\r\n </TD>\r\n <td> </td>\r\n <TD>\r\n";
$fieldcount = sizeof( $ARRAY_FIELD );
$i = 0;
for ( ; $i < $fieldcount; ++$i )
{
echo "<font color=#0099FF><b><font size=2>".$ARRAY_FIELD[$i]."</font></b><br>";
$t = 0;
for ( ; $t < sizeof( $USER_COUNTNAME[$i] ); ++$t )
{
echo "<font color=#0099FF><b><font size=2>".$USER_COUNTNAME[$i][$t].",</font></b>";
}
echo "<br><br>";
}
echo "\r\n </TD>\r\n</TABLE>\r\n<div align=center>\r\n\t <input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close();\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -