export.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
$EXCEL_OUT = "培训课程名称(编号),必修人员,实际参加人员,报名而未参加人员,请假人员,免修人员\n";
if ( $LOGIN_USER_PRIV != "1" )
{
	$query = "SELECT * from TRAIN_NEWCOURSE where ".str_replace( "`", "'", $WHERE_STR )." order by TRAIN_ID desc";
}
else
{
	$query = "SELECT * from TRAIN_NEWCOURSE where 1=1";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TRAIN_ID = $ROW['TRAIN_ID'];
	$TRAINING_ID = $ROW['TRAINING_ID'];
	$TCOURSE_ID = $ROW['TCOURSE_ID'];
	$UNATTEND_PERSONS = $ROW['UNATTEND_PERSONS'];
	$query1 = "SELECT * from TRAIN_COURSES where COURSE_ID='".$TCOURSE_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$COURSE_NAME = $ROW1['COURSE_NAME'];
	}
	$query1 = "SELECT * from TRAIN_APPLY where APPLY_TID='".$TRAINING_ID."' and EXEMPT_FLAG='1' and APPLY_STATUS='1'";
	$cursor1 = exequery( $connection, $query1 );
	$USER_NAME = "";
	$APPLYER = "";
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$APPLYER .= $ROW1['APPLYER'].",";
		$query2 = "SELECT * from USER where USER_ID='".$ROW1['APPLYER']."'";
		$cursor2 = exequery( $connection, $query2 );
		if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
		{
			$USER_NAME .= $ROW2['USER_NAME'].",";
		}
	}
	$query1 = "SELECT * from TRAIN_NEWCOURSE where TRAINING_ID='".$TRAINING_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	$ATTEND_PERSONS = "";
	$MUST_LEARNER1 = "";
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$MUST_LEARNER1 = $ROW1['MUST_LEARNER'];
		$ATTEND_PERSONS = $ROW1['ATTEND_PERSONS'];
	}
	$query1 = "SELECT * from TRAIN_APPOINT_MUSTER where TRAINING_ID='".$TRAINING_ID."' and  APPOINT_MUSTER!=''";
	$cursor1 = exequery( $connection, $query1 );
	$MUST_LEARNER2 = "";
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$MUST_LEARNER2 .= $ROW1['APPOINT_MUSTER'].",";
	}
	$TOK = strtok( $MUST_LEARNER1.$MUST_LEARNER2, "," );
	$USER_NAME1 = "";
	while ( $TOK != "" )
	{
		if ( $USER_NAME1 != "" )
		{
			$USER_NAME1 .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME1 .= $ROW1['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	$TOK = strtok( $ATTEND_PERSONS, "," );
	$USER_NAME2 = "";
	while ( $TOK != "" )
	{
		if ( $USER_NAME2 != "" )
		{
			$USER_NAME2 .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME2 .= $ROW1['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	$TOK = strtok( $UNATTEND_PERSONS, "," );
	$USER_NAME4 = "";
	while ( $TOK != "" )
	{
		if ( $USER_NAME4 != "" )
		{
			$USER_NAME4 .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME4 .= $ROW1['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	$query1 = "SELECT APPLYER from TRAIN_APPLY where APPLY_TID='".$TRAINING_ID."' and EXEMPT_FLAG!='1' and (APPLY_STATUS!='0' or APPLY_STATUS!='3')";
	$cursor1 = exequery( $connection, $query1 );
	$APPLYER2 = "";
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$APPLYER21 = $ROW1['APPLYER'];
		if ( !find_id( $UNATTEND_PERSONS, $APPLYER21 ) )
		{
			if ( !find_id( $APPLYER, $APPLYER21 ) )
			{
				$APPLYER2 .= $ROW1['APPLYER'].",";
			}
		}
	}
	$APPLYER2_ARRAY = explode( ",", $APPLYER2 );
	$APPLYER2_ARRAY_NUM = sizeof( $APPLYER2_ARRAY );
	$APPLYER3 = "";
	$I = 0;
	for ( ;	$I < $APPLYER2_ARRAY_NUM;	++$I	)
	{
		if ( !find_id( $ATTEND_PERSONS, $APPLYER2_ARRAY[$I] ) )
		{
			if ( $APPLYER2_ARRAY[$I] != "" )
			{
				$APPLYER3 .= $APPLYER2_ARRAY[$I].",";
			}
		}
	}
	$TOK = strtok( $APPLYER3, "," );
	$USER_NAME3 = "";
	while ( $TOK != "" )
	{
		if ( $USER_NAME3 != "" )
		{
			$USER_NAME3 .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME3 .= $ROW1['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	$EXCEL_OUT .= $COURSE_NAME."(".$TRAIN_ID."),".$USER_NAME1.",".$USER_NAME2.",".$USER_NAME3.",".$USER_NAME4.",".$USER_NAME."\n";
}
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;
?>