export.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "select count(*) from TRAIN_ASSESS_DATA where ASSESS_ID=".$ASSESS_ID." and ITEM_ID=''";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ASSESS_DATA_COUNT = $ROW[0];
}
$query = "SELECT * from TRAIN_ASSESS_ITEM where ASSESS_ID='".$ASSESS_ID."' order by TYPE DESC,ORDER_NO,ITEM_ID DESC";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DISCRIPTION .= $ROW['DISCRIPTION'].",";
}
$EXCEL_OUT = "评估人,".$DISCRIPTION."\n";
$query = "select * from TRAIN_ASSESS_TITLE where ASSESS_ID=".$ASSESS_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ANONYMITY = $ROW['ANONYMITY'];
}
$query = "select * from TRAIN_ASSESS_DATA where ASSESS_ID=".$ASSESS_ID." and ITEM_ID=''";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ASSESS_USER = $ROW['ASSESS_USER'];
	$query1 = "select * from USER where USER_ID='".$ASSESS_USER."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		if ( $ANONYMITY == 0 )
		{
			$USER_NAME = $ROW1['USER_NAME'];
		}
		else
		{
			$USER_NAME = "匿名";
		}
	}
	$ASSESS_DATA = $ROW['ASSESS_DATA'];
	$MY_DATA[$ASSESS_DATA_COUNT] = explode( "~", $ASSESS_DATA );
	$ARRAY_NUM = sizeof( $MY_DATA[$ASSESS_DATA_COUNT] );
	$ASSESS_DATA4 = "";
	$I = 0;
	for ( ;	$I < $ARRAY_NUM - 1;	++$I	)
	{
		$SUM[$I] += $MY_DATA[$ASSESS_DATA_COUNT][$I];
		$ASSESS_DATA4 .= format_cvs( $MY_DATA[$ASSESS_DATA_COUNT][$I] ).",";
	}
	$ASSESS_DATA1 .= $USER_NAME.",".$ASSESS_DATA4."\n";
}
$EXCEL_OUT .= $ASSESS_DATA1;
$I = 0;
for ( ;	$I < $ARRAY_NUM - 1;	++$I	)
{
	if ( $SUM[$I] == 0 )
	{
		$ASSESS_DATA2 .= " ,";
		$ASSESS_DATA3 .= " ,";
	}
	else
	{
		$ASSESS_DATA2 .= $SUM[$I].",";
		$ASSESS_DATA3 .= round( $SUM[$I] / $ASSESS_DATA_COUNT, 2 ).",";
	}
}
$ASSESS_DATA2 = "合计,".$ASSESS_DATA2."\n";
$ASSESS_DATA3 = "均值,".$ASSESS_DATA3."\n";
$EXCEL_OUT = $EXCEL_OUT.$ASSESS_DATA2.$ASSESS_DATA3;
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-Length: ".strlen( $EXCEL_OUT ) );
header( "Content-Disposition: attachment; filename= 评估数据.csv" );
echo $EXCEL_OUT;
?>