exp_rtx.php

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

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
header( "Content-Type: text/xml; charset=gb2312-8" );
header( "Content-Disposition: attachment; filename= OA组织机构.xml" );
$EXCEL_OUT = "<?xml version=\"1.0\" encoding=\"gb2312\" ?>\r\n<RTX2005OrLater_Exported_Data_9D373D5B-AA39-42e7-A819-BF5F7A8961FC>\r\n  <Database>";
$query = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV";
$USER_COUNT = 0;
$cursor = exequery( $connection, $query );
$USER_CODE = "1001";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$SEX = $ROW['SEX'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_PRIV = $ROW['USER_PRIV'];
	$PRIV_NAME = $ROW['PRIV_NAME'];
	$USER_NO = $ROW['USER_NO'];
	$NOT_LOGIN = $ROW['NOT_LOGIN'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$MOBIL_NO = $ROW['MOBIL_NO'];
	$BIRTHDAY = strtok( $BIRTHDAY, " " );
	if ( $BIRTHDAY == "0000-00-00" )
	{
		$BIRTHDAY = "";
	}
	if ( $USER_PRIV == 1 )
	{
		$USERTYPE = 0;
		$ROLEID = 2;
	}
	else
	{
		$USERTYPE = 1;
		$ROLEID = 1;
	}
	$EXCEL_OUT_SYS_USER .= ( "<item ID=\"".$USER_CODE."\" UserName=\"{$USER_ID}\" Name=\"{$USER_NAME}\" UserType=\"{$USERTYPE}\" Gender=\"{$SEX}\" Face=\"".( $SEX + 126 ) )."\" Mobile=\"\" Email=\"\" Phone=\"\" ProfileOpenLevel=\"0\" BuddyAuth=\"0\" LastLogonTime=\"0\" UserRight=\"00000000000000000000000000000000\" UserVersion=\"1\" AuthType=\"0\"/>\n";
	$EXCEL_OUT_USER_DETAIL .= "<item ID=\"".$USER_CODE."\" Birthday=\"{$BIRTHDAY}\" Age=\"0\" Fax=\"\" Position=\"{$PRIV_NAME}\" Version=\"{$USER_COUNT}\"/>\n";
	$EXCEL_OUT_USER_DEPT .= "<Item DeptID=\"".$DEPT_ID."\" UserID=\"{$USER_CODE}\"/>\n";
	$EXCEL_OUT_USER_ROLE .= "<Item UserID=\"".$USER_CODE."\" RoleID=\"{$ROLEID}\"/>\n";
	++$USER_CODE;
}
$query = "SELECT * from DEPARTMENT";
$DEPT_COUNT = 0;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$DEPT_COUNT;
	$DEPT_ID = $ROW['DEPT_ID'];
	$DEPT_NAME = $ROW['DEPT_NAME'];
	$DEPT_PARENT = $ROW['DEPT_PARENT'];
	$DEPT_NO = $ROW['DEPT_NO'];
	$EXCEL_OUT_DEPT .= "<Item DeptID=\"".$DEPT_ID."\" PDeptID=\"{$DEPT_PARENT}\" DeptName=\"{$DEPT_NAME}\" SortID=\"{$DEPT_NO}\" Version=\"{$DEPT_COUNT}\"/>\n";
}
$EXCEL_OUT .= "<Sys_User>".$EXCEL_OUT_SYS_USER."</Sys_User>\n";
$EXCEL_OUT .= "<RTX_UserDetail>".$EXCEL_OUT_USER_DETAIL."</RTX_UserDetail>\n";
$EXCEL_OUT .= "<RTX_UserDetail>".$EXCEL_OUT_USER_DETAIL."</RTX_UserDetail>\n";
$EXCEL_OUT .= "<RTX_DeptUser>".$EXCEL_OUT_USER_DEPT."</RTX_DeptUser>\n";
$EXCEL_OUT .= "<App_Right_UserRole>".$EXCEL_OUT_USER_ROLE."</App_Right_UserRole>\n";
$EXCEL_OUT .= "<RTX_Dept>".$EXCEL_OUT_DEPT."</RTX_Dept>\n";
$EXCEL_OUT .= "<SYS_SysConfig>\n\r\n      <Item UserVersion=\"".$USER_COUNT."\" DeptVersion=\"{$DEPT_COUNT}\"/>\n\r\n    </SYS_SysConfig>\n\r\n  </Database>\n\r\n</RTX2005OrLater_Exported_Data_9D373D5B-AA39-42e7-A819-BF5F7A8961FC>";
echo $EXCEL_OUT;
?>