📄 result.php
字号:
<?
//include_once("inc/auth.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=$TOTAL_SAM+$ROW["MAX"];
$VOTE_COUNT++;
}
//===========================考核分数==================================
$ARRAY_COUNT=sizeof($USER_ID);
for($I=0;$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]);
for ($count=0;$count<$field_count;$count++)
{
for($I=0;$I<$USER_COUNT;$I++)
{
$RECORD_COUNT= sizeof($MY_SCORE[$I]);
for ($field=0;$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);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$ARRAY_COUNT1=sizeof($MY_SCORESAM[$I]);
for($count=0;$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],0);}
}
}
//-------------求取总分----------------
$ARRAY_COUNT=sizeof($USER_NAME);
for($I=0;$I<$ARRAY_COUNT;$I++)
{$TOTAL=0;
$ARRAY_COUNT1=sizeof($MY_AVE[$I]);
for($count=0;$count<$ARRAY_COUNT1;$count++)
{ $TOTAL=$TOTAL+$MY_AVE[$I][$count];
}
$USER_SAM[$I]=$TOTAL;
}
$ARRAY_STATIS=explode(",",$STATICS);
//$ARRAY_STATIS=array("100","90","89","80","79","70","69","60","59");
$ARRAY_COUNT=sizeof($ARRAY_STATIS);
$USER_SAM_COUNT=sizeof($USER_SAM);
$temp=0;
$a=0;
for ($i=0;$i<$ARRAY_COUNT;$i=$i+2)
{
if (($i+1)<$ARRAY_COUNT)
{
$ARRAY_FIELD[$temp]=$ARRAY_STATIS[$i]."-".$ARRAY_STATIS[$i+1];
$FIELD_VALUE=0;
for($count=0;$count<$USER_SAM_COUNT;$count++)
{
if($USER_SAM[$count]<=$ARRAY_STATIS[$i] and $USER_SAM[$count]>=$ARRAY_STATIS[$i+1])
{$FIELD_VALUE++;
$USER_COUNTNAME[$temp][$a]=$USER_NAME[$count];
$a=$a+1;}
}
$graphValues[$temp]=$FIELD_VALUE;
}
else
{$ARRAY_FIELD[$temp]=$ARRAY_STATIS[$i]."-"."0";
$FIELD_VALUE=0;
for($count=0;$count<$USER_SAM_COUNT;$count++)
{
if($USER_SAM[$count]<=$ARRAY_STATIS[$i] and $USER_SAM[$count]>=0)
{$FIELD_VALUE++;
$USER_COUNTNAME[$temp][$a]=$USER_NAME[$count];
$a=$a+1;}
}
$graphValues[$temp]=$FIELD_VALUE;
}
$temp++;
$a=0;
}
?>
<html>
<head>
<title>分值统计结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="0" leftmargin="0">
<TABLE>
<tr>
<td> </td>
</tr>
<TR>
<TD>
<img src="staticspaint.php?GROUP_ID=<?=$GROUP_ID?>&FLOW_ID=<?=$FLOW_ID?>&STATICS=<?=$STATICS?>" align="absmiddle">
</TD>
<td> </td>
<TD>
<?
$fieldcount=sizeof($ARRAY_FIELD);
for ($i=0; $i<$fieldcount; $i++)
{
echo "<font color=#0099FF><b><font size=2>".$ARRAY_FIELD[$i]."</font></b><br>";
for ($t=0; $t<sizeof($USER_COUNTNAME[$i]); $t++)
{
echo "<font color=#0099FF><b><font size=2>".$USER_COUNTNAME[$i][$t].",</font></b>";
}
echo "<br>";
echo "<br>";
}
?>
</TD>
</TABLE>
<div align=center>
<input type="button" value="关闭" class="SmallButton" onclick="window.close();">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -