excel_report.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?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;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ITEM_NAME[$VOTE_COUNT] = $ROW['ITEM_NAME'];
	++$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 );
		}
	}
}
$EXCEL_OUT .= "部门\t";
$EXCEL_OUT .= "姓名\t";
$EXCEL_OUT .= "角色\t";
$ARRAY_COUNT = sizeof( $ITEM_NAME );
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$EXCEL_OUT .= $ITEM_NAME[$I]."\t";
}
$EXCEL_OUT .= "总分";
$EXCEL_OUT .= "\n";
$ARRAY_COUNT = sizeof( $USER_NAME );
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$TOTAL = 0;
	$EXCEL_OUT .= $USER_DEPT[$I]."\t";
	$EXCEL_OUT .= $USER_NAME[$I]."\t";
	$EXCEL_OUT .= $USER_PRIV[$I]."\t";
	$ARRAY_COUNT1 = sizeof( $MY_AVE[$I] );
	$count = 0;
	for ( ;	$count < $ARRAY_COUNT1;	++$count	)
	{
		$TOTAL += $MY_AVE[$I][$count];
		$EXCEL_OUT .= $MY_AVE[$I][$count]."\t";
	}
	$EXCEL_OUT .= $TOTAL."\t";
	$EXCEL_OUT .= "\n";
}
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;
?>