excel_detail.php

通达OA2007SE源代码 非常好的

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'SELECT ANONYMITY from SCORE_FLOW  where FLOW_ID=\'').$FLOW_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $ANONYMITY = $ROW['ANONYMITY'];
  }
  $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;
  }
  ($EXCEL_OUT .= '部门	');
  ($EXCEL_OUT .= '评分人	');
  ($EXCEL_OUT .= '角色	');
  ($EXCEL_OUT .= '被考核人	');
  $ARRAY_COUNT = sizeof ($ITEM_NAME);
  for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
  {
    ($EXCEL_OUT .= ($ITEM_NAME[$I].'	'));
  }
  ($EXCEL_OUT .= '
');
  $query1 = (((''.'select e.USER_NAME as PARTICIPANT,a.MEMO,a.SCORE,b.USER_NAME as USER_NAME,PRIV_NAME,d.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 
                              LEFT OUTER JOIN USER e ON a.PARTICIPANT = e.USER_ID 
                              where a.FLOW_ID=\'').$FLOW_ID).'\'');
  $cursor1 = exequery ($connection, $query1);
  $COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    $SCORE = $ROW['SCORE'];
    $MEMO = $ROW['MEMO'];
    $PARTICIPANT = $ROW['PARTICIPANT'];
    $MY_SCORE = explode (',', $SCORE);
    if (($ANONYMITY == '0'))
    {
      ($EXCEL_OUT .= ($ROW['DEPT_NAME'].'	'));
      ($EXCEL_OUT .= ($ROW['USER_NAME'].'	'));
      ($EXCEL_OUT .= ($ROW['PRIV_NAME'].'	'));
    }
    else
    {
      ($EXCEL_OUT .= '****	');
      ($EXCEL_OUT .= '****	');
      ($EXCEL_OUT .= '****	');
    }
    ($EXCEL_OUT .= ($ROW['PARTICIPANT'].'	'));
    $ARRAY_COUNT1 = sizeof ($MY_SCORE);
    for ($I = 0; ($I < $ARRAY_COUNT1); ++$I)
    {
      ($EXCEL_OUT .= ($MY_SCORE[$I].'	'));
    }
    ($EXCEL_OUT .= '
');
  }
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/vnd.ms-excel');
  header ('Accept-Ranges: bytes');
  header (('Accept-Length: '.strlen ($EXCEL_OUT)));
  header ((((''.'Content-Disposition: attachment; filename=考核分数明细报表-').$FLOW_TITLE).'.xls'));
  echo $EXCEL_OUT;
?>