📄 query.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>考核数据</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$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;
while ($ROW = mysql_fetch_array ($cursor))
{
$ITEM_NAME[$VOTE_COUNT] = $ROW['ITEM_NAME'];
++$VOTE_COUNT;
}
$ARRAY_COUNT = sizeof ($USER_ID);
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
$query1 = (((((''.'select MEMO,SCORE,`USER_NAME` , PRIV_NAME, DEPT_NAME FROM SCORE_DATE a LEFT OUTER JOIN USER b ON a.RANKMAN = b.USER_ID LEFT OUTER JOIN USER_PRIV c ON b.USER_PRIV = c.USER_PRIV LEFT OUTER JOIN DEPARTMENT d ON d.DEPT_ID = b.DEPT_ID 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'];
$MEMO = $ROW['MEMO'];
$MY_SCORE[$I][$COUNT] = explode (',', $SCORE);
$MY_MEMO[$I][$COUNT] = explode (',', $MEMO);
if (($ANONYMITY == '0'))
{
$RANK_NAME[$I][$COUNT] = $ROW['USER_NAME'];
$RANK_PRIV[$I][$COUNT] = $ROW['PRIV_NAME'];
$RANK_DEPT[$I][$COUNT] = $ROW['DEPT_NAME'];
}
else
{
$RANK_NAME[$I][$COUNT] = '****';
$RANK_PRIV[$I][$COUNT] = '****';
$RANK_DEPT[$I][$COUNT] = '****';
}
++$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);
continue;
}
}
}
}
$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;
continue;
}
else
{
$MY_AVE[$I][$count] = round (($MY_SCORESAM[$I][$count] / $MY_SCORECOUNT[$I][$count]), 2);
continue;
}
}
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 考核数据查询</span>
<input type="button" value="关闭" class="SmallButton" onclick="window.close();">
</td>
<td class="Small"><b>点击条目显示详细打分情况</b></td>
</tr>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="3" bgcolor="#000000" class="small">
<thead class="TableHeader">
<td nowrap align="center">部门</td>
';
echo ' <td nowrap align="center">姓名</td>
<td nowrap align="center">角色</td>
';
$ARRAY_COUNT = sizeof ($ITEM_NAME);
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
echo ' <td nowrap align="center">';
echo $ITEM_NAME[$I];
echo '</td>
';
}
echo ' <td nowrap align="center">总计</td>
</thead>
';
$ARRAY_COUNT = sizeof ($USER_NAME);
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
$TOTAL = 0;
echo ' <tr class="TableLine1" style="cursor:hand" onclick="td_detail(\'';
echo $I;
echo '\');" title="单击查看评分明细">
<td align="center">';
echo $USER_DEPT[$I];
echo '</td>
<td align="center">';
echo $USER_NAME[$I];
echo '</td>
<td align="center">';
echo $USER_PRIV[$I];
echo '</td>
';
$ARRAY_COUNT1 = sizeof ($MY_AVE[$I]);
$colnumber = ($ARRAY_COUNT1 + 4);
for ($count = 0; ($count < $ARRAY_COUNT1); ++$count)
{
$TOTAL = ($TOTAL + $MY_AVE[$I][$count]);
echo ' <td align="center">';
echo $MY_AVE[$I][$count];
echo '</td>
';
}
echo ' <td nowrap align="center">';
echo $TOTAL;
echo '</td>
</tr>
<tr class="TableData" id=';
echo $I;
echo ' style="display:none" onDblClick="td_close(\'';
echo $I;
echo '\');" title="双击关闭子窗口">
<td align="left" colspan=';
echo $colnumber;
echo '>
<br>
<table border="0" width="60%" cellspacing="1" cellpadding="3" bgcolor="#000000" class="small">
<thead class="TableHeader">
<td nowrap align="center">部门</td>
<td nowrap align="center">评分人姓名</td>
<td nowrap align="center">角色</td>
';
$ARRAY_COUNT2 = sizeof ($ITEM_NAME);
for ($I2 = 0; ($I2 < $ARRAY_COUNT2); ++$I2)
{
echo ' <td nowrap align="center">';
echo $ITEM_NAME[$I2];
echo '</td>
';
}
echo '
</thead>
';
$SON_COUNT = sizeof ($RANK_NAME[$I]);
for ($SON_I = 0; ($SON_I < $SON_COUNT); ++$SON_I)
{
$SON_TOTAL = 0;
echo ' <tr class="TableData" >
<td align="center">';
echo $RANK_DEPT[$I][$SON_I];
echo '</td>
<td align="center">';
echo $RANK_NAME[$I][$SON_I];
echo '</td>
<td align="center">';
echo $RANK_PRIV[$I][$SON_I];
echo '</td>
';
$SON_COUNT1 = sizeof ($MY_SCORE[$I][$SON_I]);
for ($soncount = 0; ($soncount < ($SON_COUNT1 - 1)); ++$soncount)
{
if (($MY_SCORE[$I][$SON_I][$soncount] == ''))
{
$SON_TOTAL = ($SON_TOTAL + 0);
}
else
{
$SON_TOTAL = ($SON_TOTAL + $MY_SCORE[$I][$SON_I][$soncount]);
}
echo ' <td align="center" nowrap>';
echo $MY_SCORE[$I][$SON_I][$soncount];
echo '<br>
';
if (($MY_MEMO[$I][$SON_I][$soncount] != ''))
{
echo ' ';
echo '<s';
echo 'pan class="big4">(批注：';
echo $MY_MEMO[$I][$SON_I][$soncount];
echo ')</span>
';
}
echo '
</td>
';
}
echo '
</tr>
';
}
echo ' </table>
<br>
</td>
</tr>
';
}
echo '
</table>
</body>
</html>
';
echo '<s';
echo 'cript Language="JavaScript">
function td_detail(I)
{
if(document.all(I).style.display=="none")
{document.all(I).style.display="";
document.all(I).style.cursor="hand";
}
else
document.all(I).style.display="none";
}
function td_close(I)
{
document.all(I).style.display="none";
}
</script>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -