export_cc.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_org.php" );
$EXCEL_OUT = "部门,姓名,出差地点,开始日期,结束日期,批示领导,状态\n";
$query = "SELECT * from ATTEND_EVECTION,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_EVECTION.USER_ID=USER.USER_ID and ((to_days(EVECTION_DATE1)>=to_days('".$DATE1."') and to_days(EVECTION_DATE1)<=to_days('{$DATE2}')) or (to_days(EVECTION_DATE2)>=to_days('{$DATE1}') and to_days(EVECTION_DATE2)<=to_days('{$DATE2}')) or (to_days(EVECTION_DATE1)<=to_days('{$DATE1}') and to_days(EVECTION_DATE2)>=to_days('{$DATE2}'))) order by DEPT_NO,USER_NO,USER_NAME";
$cursor = exequery( $connection, $query );
$EVECTION_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID = $ROW['USER_ID'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$EVECTION_ID = $ROW['EVECTION_ID'];
	$EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
	$EVECTION_DATE1 = strtok( $EVECTION_DATE1, " " );
	$EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
	$EVECTION_DATE2 = strtok( $EVECTION_DATE2, " " );
	$EVECTION_DEST = $ROW['EVECTION_DEST'];
	$STATUS = $ROW['STATUS'];
	$LEADER_ID = $ROW['LEADER_ID'];
	$LEADER_NAME = "";
	$query = "SELECT * from USER where USER_ID='".$LEADER_ID."'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$LEADER_NAME = $ROW['USER_NAME'];
	}
	if ( !is_dept_priv( $DEPT_ID ) )
	{
	}
	else
	{
		++$EVECTION_COUNT;
		if ( $STATUS == "1" )
		{
			$STATUS = "在外";
		}
		else
		{
			$STATUS = "归来";
		}
		$query1 = "select * from DEPARTMENT where DEPT_ID=".$DEPT_ID;
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$USER_DEPT_NAME = $ROW['DEPT_NAME'];
		}
		$EXCEL_OUT .= "{$USER_DEPT_NAME},{$USER_NAME},{$EVECTION_DEST},{$EVECTION_DATE1},{$EVECTION_DATE2},{$LEADER_NAME},{$STATUS}\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;
?>