export_qj.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$EXCEL_OUT = "部门,姓名,请假原因,开始日期,结束日期,批示领导,状态\n";
$query = "SELECT * from ATTEND_LEAVE,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_LEAVE.USER_ID=USER.USER_ID and ((to_days(LEAVE_DATE1)>=to_days('".$DATE1."') and to_days(LEAVE_DATE1)<=to_days('{$DATE2}')) or (to_days(LEAVE_DATE2)>=to_days('{$DATE1}') and to_days(LEAVE_DATE2)<=to_days('{$DATE2}')) or (to_days(LEAVE_DATE1)<=to_days('{$DATE1}') and to_days(LEAVE_DATE2)>=to_days('{$DATE2}'))) and allow in('1','3') order by DEPT_NO,USER_NO,USER_NAME";
$cursor = exequery( $connection, $query );
$LEAVE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID = $ROW['USER_ID'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$LEAVE_ID = $ROW['LEAVE_ID'];
	$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
	$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
	$LEAVE_TYPE = $ROW['LEAVE_TYPE'];
	$LEADER_ID = $ROW['LEADER_ID'];
	$STATUS = $ROW['STATUS'];
	$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 ) )
	{
		++$LEAVE_COUNT;
		switch ( $LEAVE_TYPE )
		{
		case "1" :
			$LEAVE_TYPE = "事假";
			break;
		case "2" :
			$LEAVE_TYPE = "病假";
			break;
		case "3" :
			$LEAVE_TYPE = "婚假";
			break;
		case "4" :
			$LEAVE_TYPE = "产假";
			break;
		case "5" :
			$LEAVE_TYPE = "其它";
		}
		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},{$LEAVE_TYPE},{$LEAVE_DATE1},{$LEAVE_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;
?>