export.php

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

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$EXCEL_OUT = "部门,姓名,性别,生日,角色,用户名,别名,用户排序号,管理范围,手机,IP,在线时长,最后登陆时间,登陆次数\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 ) )
{
	$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 = $ROW['BIND_IP'];
	$PRIV_NAME = format_cvs( $ROW['PRIV_NAME'] );
	$DEPT_NAME = format_cvs( $ROW['DEPT_NAME'] );
	$LAST_VISIT_TIME = $ROW['LAST_VISIT_TIME'];
	$ONLINE = $ROW['ONLINE'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = strtok( $BIRTHDAY, " " );
	if ( $BIRTHDAY == "0000-00-00" )
	{
		$BIRTHDAY = "";
	}
	if ( $LAST_VISIT_TIME == "0000-00-00 00:00:00" )
	{
		$LAST_VISIT_TIME = "";
	}
	$MIN = floor( $ONLINE / 60 );
	$HOUR = floor( $MIN / 60 );
	$MIN %= 60;
	$ONLINE_DESC = $HOUR."小时".$MIN."分";
	$query = "SELECT count(*) from SYS_LOG where USER_ID='".$USER_ID."'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$LOGIN_COUNT = $ROW1[0];
	}
	if ( is_dept_priv( $DEPT_ID ) )
	{
		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 .= "{$DEPT_NAME},{$USER_NAME},{$SEX},{$BIRTHDAY},{$PRIV_NAME},{$USER_ID},{$BYNAME},{$USER_NO},{$POST_PRIV},{$MOBIL_NO},{$BIND_IP},{$ONLINE_DESC},{$LAST_VISIT_TIME},{$LOGIN_COUNT}\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;
?>