share_tree.php

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

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
header( "Content-type: text/xml" );
echo "<?xml version=\"1.0\" encoding=\"gb2312\"?>\n<TreeNode>\n";
$PARENT_ID = $SORT_ID;
$DEPT_ID_PREV = "";
if ( $PARENT_ID == 0 )
{
	$query = "SELECT SORT_ID,SORT_NAME,USER.DEPT_ID,DEPT_NAME from FILE_SORT,USER,DEPARTMENT where find_in_set('".$LOGIN_USER_ID."',SHARE_USER) and  USER.USER_ID=FILE_SORT.USER_ID and USER.DEPT_ID=DEPARTMENT.DEPT_ID order by DEPT_NO,DEPARTMENT.DEPT_ID,USER_NO,USER_NAME,SORT_NO,SORT_NAME";
}
else
{
	$query = "SELECT SORT_ID,SORT_NAME,USER.DEPT_ID,DEPT_NAME from FILE_SORT,USER,DEPARTMENT where SORT_PARENT=".$PARENT_ID." and USER.USER_ID=FILE_SORT.USER_ID and USER.DEPT_ID=DEPARTMENT.DEPT_ID order by DEPT_NO,DEPARTMENT.DEPT_ID,USER_NO,USER_NAME,SORT_NO,SORT_NAME";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SORT_ID = $ROW['SORT_ID'];
	$SORT_NAME = $ROW['SORT_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$DEPT_NAME = $ROW['DEPT_NAME'];
	$CHILD_COUNT = 0;
	$query = "SELECT count(*) from FILE_SORT where SORT_PARENT=".$SORT_ID;
	$cursor1 = exequery( $connection, $query );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$CHILD_COUNT = $ROW1[0];
	}
	if ( $PARENT_ID == 0 )
	{
		$FOLDER_IMG = "/images/endnode_share.gif";
		$USER_ID = sort_attrib( $SORT_ID, "USER_ID" );
		$query = "SELECT USER_NAME from USER where USER_ID='".$USER_ID."'";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME = $ROW1['USER_NAME'];
		}
		$SORT_NAME .= "(".$USER_NAME.")";
	}
	else
	{
		$FOLDER_IMG = "/images/endnode.gif";
	}
	$SORT_NAME = htmlspecialchars( $SORT_NAME );
	$SORT_NAME = str_replace( "\"", "&quot;", $SORT_NAME );
	if ( $CHILD_COUNT == 0 )
	{
		echo "<TreeNode id=\"".$SORT_ID.( "\" text=\"".$SORT_NAME."\" img_src=\"{$FOLDER_IMG}\" href=\"share_folder.php?SORT_ID={$SORT_ID}&amp;OP=1\" title=\"{$SORT_NAME}\" target=\"file_main\"/>\n" );
	}
	else
	{
		echo "<TreeNode id=\"".$SORT_ID.( "\" text=\"".$SORT_NAME."\" img_src=\"{$FOLDER_IMG}\" href=\"share_folder.php?SORT_ID={$SORT_ID}&amp;OP=1\" title=\"{$SORT_NAME}\" target=\"file_main\" Xml=\"share_tree.php?SORT_ID={$SORT_ID}&amp;OP=1\"/>\n" );
	}
	$DEPT_ID_PREV = $DEPT_ID;
}
echo "</TreeNode>\n";
?>