export_wc.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_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)>=to_days('\$".$DATE1."') and to_days(SUBMIT_TIME)<=to_days('\${$DATE2}') order by DEPT_NO,USER_NO,USER_NAME";
$cursor = exequery( $connection, $query );
$OUT_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$OUT_TYPE = $ROW['OUT_TYPE'];
	$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
	$OUT_TIME1 = $ROW['OUT_TIME1'];
	$OUT_TIME2 = $ROW['OUT_TIME2'];
	$ALLOW = $ROW['ALLOW'];
	$STATUS = $ROW['STATUS'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$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
	{
		++$OUT_COUNT;
		if ( $STATUS == "0" )
		{
			$STATUS_DESC = "外出";
		}
		else if ( $STATUS == "1" )
		{
			$STATUS_DESC = "已归来";
		}
		if ( $ALLOW == "0" )
		{
			$STATUS_DESC = "待批";
		}
		if ( $ALLOW == "2" )
		{
			$STATUS_DESC = "不批准";
		}
		$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},{$OUT_TYPE},{$SUBMIT_TIME},{$OUT_TIME1},{$OUT_TIME2},{$LEADER_NAME},{$STATUS_DESC}\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;
?>