export.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$EXCEL_OUT = "编号,HRID,用户姓名,培训课程,所在部门,入职日期,E-MAIL,\n";
$CONDITION_STR = "";
if ( $TRAIN_ID != "" )
{
	$CONDITION_STR .= " and TRAIN_ID='".$TRAIN_ID."'";
}
if ( $TRAIN_TYPE != "" )
{
	$CONDITION_STR .= " and TRAIN_TYPE='".$TRAIN_TYPE."'";
}
if ( $BEGIN_TIME1 != "" )
{
	$BEGIN_TIME1 .= " 00:00:00";
	$CONDITION_STR .= " and BEGIN_TIME>='".$BEGIN_TIME1."'";
}
if ( $BEGIN_TIME2 != "" )
{
	$BEGIN_TIME2 .= " 23:59:59";
	$CONDITION_STR .= " and BEGIN_TIME<='".$BEGIN_TIME2."'";
}
$query = "SELECT * from TRAIN_NEWCOURSE where 1=1";
$query .= $CONDITION_STR." order by TRAINING_ID desc";
$cursor = exequery( $connection, $query );
$PERSON_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TRAINING_ID = $ROW['TRAINING_ID'];
	$TRAIN_ID = $ROW['TRAIN_ID'];
	$ATTEND_PERSONS = $ROW['ATTEND_PERSONS'];
	$AVOIDER = $ROW['AVOIDER'];
	$UNATTEND_PERSONS = $ROW['UNATTEND_PERSONS'];
	$NOTATTENDER = $ROW['NOTATTENDER'];
	$TCOURSE_ID = $ROW['TCOURSE_ID'];
	$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'];
	}
	if ( $STAT_SHOU == 1 )
	{
		$MY_STR = $ATTEND_PERSONS;
	}
	if ( $STAT_SHOU == 2 )
	{
		$MY_STR = $UNATTEND_PERSONS.$NOTATTENDER;
	}
	if ( $STAT_SHOU == 3 )
	{
		$MY_STR = $AVOIDER;
	}
	$MY_STR_ARRAY = explode( ",", $MY_STR );
	$MY_STR_ARRAY_NUM = sizeof( $MY_STR_ARRAY );
	$I = 0;
	for ( ;	$I < $MY_STR_ARRAY_NUM - 1;	++$I	)
	{
		++$PERSON_COUNT;
		$query1 = "SELECT * from USER,HRMS where USER.USER_ID='".$MY_STR_ARRAY[$I]."' and USER.USER_ID=HRMS.USER_ID";
		$cursor1 = exequery( $connection, $query1 );
		$USER_NAME = "";
		$DEPT_ID = "";
		$EMAIL = "";
		$JOIN_DATE = "";
		$DEPT_NAME = "";
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME = $ROW1['USER_NAME'];
			$DEPT_ID = $ROW1['DEPT_ID'];
			$JOIN_DATE = $ROW1['JOIN_DATE'];
			$JOIN_DATE = substr( $JOIN_DATE, 0, 10 );
			if ( $JOIN_DATE == "0000-00-00" )
			{
				$JOIN_DATE = "";
			}
			$EMAIL = $ROW1['EMAIL'];
			$DEPT_NAME = dept_long_name( $DEPT_ID );
		}
		if ( $VU_DEPT != "" && $VU_DEPT != $DEPT_ID )
		{
			$EXCEL_OUT .= ( $I + 1 ).",".$MY_STR_ARRAY[$I].",".$USER_NAME.",".$COURSE_NAME."(".$TRAIN_ID."),".$DEPT_NAME.",".$JOIN_DATE.",".$EMAIL.",\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-Length: ".strlen( $EXCEL_OUT ) );
header( "Content-Disposition: attachment; filename= 员工培训统计.csv" );
echo $EXCEL_OUT;
?>