result.php

通达OA2007SE源代码 非常好的

<?
  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);
          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;
      }
    }
  }
  $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_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 ($ARRAY_STATIS[($i + 1)] <= $USER_SAM[$count])))
        {
          ++$FIELD_VALUE;
          $USER_COUNTNAME[$temp][$a] = $USER_NAME[$count];
          $a = ($a + 1);
          continue;
        }
      }
      $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 (0 <= $USER_SAM[$count])))
        {
          ++$FIELD_VALUE;
          $USER_COUNTNAME[$temp][$a] = $USER_NAME[$count];
          $a = ($a + 1);
          continue;
        }
      }
      $graphValues[$temp] = $FIELD_VALUE;
    }
    ++$temp;
    $a = 0;
  }
  echo '<html>
<head>
<title>分值统计结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="0" leftmargin="0">
<TABLE>
	<tr>
		<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
	</tr>
 <TR>
   <TD>
   	<img src="staticspaint.php?GROUP_ID=';
  echo $GROUP_ID;
  echo '&FLOW_ID=';
  echo $FLOW_ID;
  echo '&STATICS=';
  echo $STATICS;
  echo '" align="absmiddle">
   </TD>
  <td>&nbsp;&nbsp;&nbsp;</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>';
  }
  echo '
   </TD>
</TABLE>
<div align=center>
	 <input type="button"  value="关闭" class="SmallButton" onclick="window.close();">
</div>
</body>
</html>
';
?>