excel_detail.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( ) );
$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 .= "部门\t";
$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 .= "\n";
$query1 = "select e.USER_NAME as PARTICIPANT,a.MEMO,a.SCORE,b.USER_NAME as USER_NAME,PRIV_NAME,d.DEPT_NAME \r\n            FROM SCORE_DATE a LEFT OUTER JOIN USER b ON a.RANKMAN = b.USER_ID \r\n                              LEFT OUTER JOIN USER_PRIV c ON b.USER_PRIV = c.USER_PRIV \r\n                              LEFT OUTER JOIN DEPARTMENT d ON d.DEPT_ID = b.DEPT_ID \r\n                              LEFT OUTER JOIN USER e ON a.PARTICIPANT = e.USER_ID \r\n                              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']."\t";
		$EXCEL_OUT .= $ROW['USER_NAME']."\t";
		$EXCEL_OUT .= $ROW['PRIV_NAME']."\t";
	}
	else
	{
		$EXCEL_OUT .= "****\t";
		$EXCEL_OUT .= "****\t";
		$EXCEL_OUT .= "****\t";
	}
	$EXCEL_OUT .= $ROW['PARTICIPANT']."\t";
	$ARRAY_COUNT1 = sizeof( $MY_SCORE );
	$MY_MEMO = explode( ",", $MEMO );
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT1;	++$I	)
	{
		if ( $MY_MEMO[$I] == "" )
		{
			$EXCEL_OUT .= $MY_SCORE[$I]."\t";
		}
		else
		{
			$EXCEL_OUT .= $MY_SCORE[$I]."(批注:".$MY_MEMO[$I].")\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;
?>