export.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
$EXCEL_OUT = "\"ID\",用户名,部门,姓名,性别,生日,角色,别名,用户排序号,管理范围,手机,IP,单位电话,单位传真,家庭地址,邮编,家庭电话,E-mail,QQ,MSN\n";
$query = "SELECT * from USER_PRIV where USER_PRIV='".$LOGIN_USER_PRIV."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRIV_NO = $ROW['PRIV_NO'];
}
if ( $USER_ID != "" )
{
	$WHERE_STR .= " and USER_ID like '%".$USER_ID."%'";
}
if ( $USER_NAME != "" )
{
	$WHERE_STR .= " and USER_NAME like '%".$USER_NAME."%'";
}
if ( $BYNAME != "" )
{
	$WHERE_STR .= " and BYNAME like '%".$BYNAME."%'";
}
if ( $SEX != "" )
{
	$WHERE_STR .= " and SEX=".$SEX;
}
if ( $DEPT_ID != "" )
{
	$WHERE_STR .= " and USER.DEPT_ID=".$DEPT_ID;
}
if ( $DEPT_ID != "0" )
{
	$WHERE_STR .= " and DEPARTMENT.DEPT_ID=USER.DEPT_ID";
}
if ( $DUTY_TYPE != "" )
{
	$WHERE_STR .= " and DUTY_TYPE=".$DUTY_TYPE;
}
if ( $USER_PRIV != "" )
{
	$WHERE_STR .= " and USER.USER_PRIV=".$USER_PRIV;
}
if ( $POST_PRIV != "" )
{
	$WHERE_STR .= " and POST_PRIV=".$POST_PRIV;
}
if ( $CANBROADCAST != "" )
{
	$WHERE_STR .= " and CANBROADCAST=".$CANBROADCAST;
}
if ( $NOT_LOGIN != "2" )
{
	$WHERE_STR .= " and NOT_LOGIN='".$NOT_LOGIN."'";
}
if ( $NOT_VIEW_USER != "2" )
{
	$WHERE_STR .= " and NOT_VIEW_USER='".$NOT_VIEW_USER."'";
}
if ( $NOT_VIEW_TABLE != "2" )
{
	$WHERE_STR .= " and NOT_VIEW_TABLE='".$NOT_VIEW_TABLE."'";
}
$query = "SELECT * from USER,USER_PRIV";
if ( $DEPT_ID != "0" )
{
	$query .= ",DEPARTMENT";
}
if ( $LOGIN_USER_PRIV != "1" )
{
	$query .= " where USER.USER_PRIV=USER_PRIV.USER_PRIV and USER_PRIV.PRIV_NO>".$PRIV_NO." and USER_PRIV.USER_PRIV!=1 ".$WHERE_STR." order by ";
}
else
{
	$query .= " where USER.USER_PRIV=USER_PRIV.USER_PRIV ".$WHERE_STR." order by ";
}
if ( $LAST_VISIT_TIME != "" )
{
	$query .= "LAST_VISIT_TIME ".$LAST_VISIT_TIME.",";
}
if ( $DEPT_ID != "0" )
{
	$query .= "DEPT_NO,";
}
$query .= "PRIV_NO,USER_NO,USER_NAME";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$UID = $ROW['UID'];
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = format_cvs( $ROW['USER_NAME'] );
	$BYNAME = format_cvs( $ROW['BYNAME'] );
	$SEX = $ROW['SEX'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$POST_PRIV = $ROW['POST_PRIV'];
	$USER_NO = $ROW['USER_NO'];
	$MOBIL_NO = $ROW['MOBIL_NO'];
	$BIND_IP = format_cvs( $ROW['BIND_IP'] );
	$PRIV_NAME = format_cvs( $ROW['PRIV_NAME'] );
	$DEPT_NAME = format_cvs( $ROW['DEPT_NAME'] );
	$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
	$FAX_NO_DEPT = $ROW['FAX_NO_DEPT'];
	$ADD_HOME = format_cvs( $ROW['ADD_HOME'] );
	$POST_NO_HOME = $ROW['POST_NO_HOME'];
	$TEL_NO_HOME = $ROW['TEL_NO_HOME'];
	$EMAIL = $ROW['EMAIL'];
	$OICQ_NO = $ROW['OICQ_NO'];
	$MSN = $ROW['MSN'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = strtok( $BIRTHDAY, " " );
	if ( $BIRTHDAY == "0000-00-00" )
	{
		$BIRTHDAY = "";
	}
	if ( !is_dept_priv( $DEPT_ID ) )
	{
	}
	else
	{
		if ( $DEPT_ID == 0 || $DEPT_ID == "" )
		{
			$DEPT_NAME = "离职人员/外部人员";
		}
		if ( $SEX == "0" )
		{
			$SEX = "男";
		}
		else if ( $SEX == "1" )
		{
			$SEX = "女";
		}
		if ( $POST_PRIV == "0" )
		{
			$POST_PRIV = "本部门";
		}
		else if ( $POST_PRIV == "1" )
		{
			$POST_PRIV = "全体";
		}
		else if ( $POST_PRIV == "2" )
		{
			$POST_PRIV = "指定部门";
		}
		$EXCEL_OUT .= "{$UID},{$USER_ID},{$DEPT_NAME},{$USER_NAME},{$SEX},{$BIRTHDAY},{$PRIV_NAME},{$BYNAME},{$USER_NO},{$POST_PRIV},{$MOBIL_NO},{$BIND_IP},{$TEL_NO_DEPT},{$FAX_NO_DEPT},{$ADD_HOME},{$POST_NO_HOME},{$TEL_NO_HOME},{$EMAIL},{$OICQ_NO},{$MSN}\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= OA用户.csv" );
echo $EXCEL_OUT;
?>