export.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$EXCEL_OUT = '部门,姓名,姓别,生日,角色,用户名,别名,用户排序号,管理范围
';
$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 ($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 . '\'';
}
if ($LOGIN_USER_PRIV != '1')
{
	$query = 'SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and 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 = 'SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV ' . $WHERE_STR . ' order by ';
}
if ($LAST_VISIT_TIME != '')
{
	$query .= 'LAST_VISIT_TIME ' . $LAST_VISIT_TIME . ',';
}
$query .= 'DEPT_NO,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'];
	$PRIV_NAME = format_cvs ($ROW['PRIV_NAME']);
	$DEPT_NAME = format_cvs ($ROW['DEPT_NAME']);
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = strtok ($BIRTHDAY, ' ');
	if ($BIRTHDAY == '0000-00-00')
	{
		$BIRTHDAY = '';
	}
	if (is_dept_priv ($DEPT_ID))
	{
		if (!((!($DEPT_ID == 0) AND !($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 . '
');
		continue;
	}
}
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;
?>