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;
if ( $PARENT_ID == -1 )
{
	echo "<TreeNode id=\"0\" text=\"根目录\" img_src=\"/images/endnode.gif\" href=\"folder.php?SORT_ID=0&amp;FILE_SORT=".$FILE_SORT."\" title=\"根目录\" target=\"file_main\" Xml=\"tree.php?SORT_ID=0&amp;FILE_SORT={$FILE_SORT}\"/>\n";
}
if ( $PARENT_ID == 0 )
{
	if ( $FILE_SORT == 1 )
	{
		$query = "SELECT FILE_SORT.SORT_ID,FILE_SORT.SORT_NAME,FILE_SORT.USER_ID,FILE_SORT.SHARE_USER,BYNAME_NO,BYNAME_NAME,REMARK from FILE_SORT left join FILE_SORT_BYNAME on FILE_SORT_BYNAME.SORT_ID=FILE_SORT.SORT_ID and FILE_SORT_BYNAME.USER_ID='".$LOGIN_USER_ID."'  where SORT_TYPE!='4' and SORT_PARENT=0 order by BYNAME_NO,SORT_NO,SORT_NAME";
	}
	else
	{
		$query = "SELECT FILE_SORT.SORT_ID,FILE_SORT.SORT_NAME,FILE_SORT.USER_ID,FILE_SORT.SHARE_USER,BYNAME_NO,BYNAME_NAME,REMARK from FILE_SORT left join FILE_SORT_BYNAME on FILE_SORT_BYNAME.SORT_ID=FILE_SORT.SORT_ID and FILE_SORT_BYNAME.USER_ID='".$LOGIN_USER_ID."' where SORT_TYPE='4' and FILE_SORT.USER_ID='{$LOGIN_USER_ID}' and SORT_PARENT=0 order by BYNAME_NO,SORT_NO,SORT_NAME";
	}
}
else if ( 0 < $PARENT_ID )
{
	$query = "SELECT FILE_SORT.*,BYNAME_NO,BYNAME_NAME,REMARK from FILE_SORT left join FILE_SORT_BYNAME on FILE_SORT_BYNAME.SORT_ID=FILE_SORT.SORT_ID and FILE_SORT_BYNAME.USER_ID='".$LOGIN_USER_ID."' where SORT_PARENT={$PARENT_ID} order by BYNAME_NO,SORT_NO,SORT_NAME";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SORT_ID = $ROW['SORT_ID'];
	$SORT_NAME = $ROW['SORT_NAME'];
	$USER_ID = $ROW['USER_ID'];
	$SHARE_USER = $ROW['SHARE_USER'];
	$BYNAME_NAME = $ROW['BYNAME_NAME'];
	$REMARK = $ROW['REMARK'];
	if ( $REMARK == "" )
	{
		$REMARK = $SORT_NAME;
	}
	if ( $BYNAME_NAME != "" )
	{
		$SORT_NAME = $BYNAME_NAME."(原名：".$SORT_NAME.")";
	}
	$ACCESS_PRIV = explode( "|", $USER_ID );
	if ( $USER_ID != $LOGIN_USER_ID && $ACCESS_PRIV[0] != "ALL_DEPT" && !find_id( $ACCESS_PRIV[0], $LOGIN_DEPT_ID ) || !find_id( $ACCESS_PRIV[1], $LOGIN_USER_PRIV ) || !find_id( $ACCESS_PRIV[2], $LOGIN_USER_ID ) )
	{
		$SORT_NAME = htmlspecialchars( $SORT_NAME );
		$SORT_NAME = str_replace( "\"", "&quot;", $SORT_NAME );
		$CHILD_COUNT = 0;
		$query = "SELECT count(*) from FILE_SORT where SORT_PARENT=".$SORT_ID;
		$cursor1 = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$CHILD_COUNT = $ROW[0];
		}
		if ( $FILE_SORT == 2 && $SHARE_USER != "" )
		{
			$FOLDER_IMG = "/images/endnode_share.gif";
		}
		else
		{
			$FOLDER_IMG = "/images/endnode.gif";
		}
		if ( $CHILD_COUNT == 0 )
		{
			echo "<TreeNode id=\"".$SORT_ID.( "\" text=\"".$SORT_NAME."\" img_src=\"{$FOLDER_IMG}\" href=\"folder.php?SORT_ID={$SORT_ID}&amp;FILE_SORT={$FILE_SORT}\" title=\"{$REMARK}\" target=\"file_main\"/>\n" );
		}
		else
		{
			echo "<TreeNode id=\"".$SORT_ID.( "\" text=\"".$SORT_NAME."\" img_src=\"{$FOLDER_IMG}\" href=\"folder.php?SORT_ID={$SORT_ID}&amp;FILE_SORT={$FILE_SORT}\" title=\"{$REMARK}\" target=\"file_main\" Xml=\"tree.php?SORT_ID={$SORT_ID}&amp;FILE_SORT={$FILE_SORT}\"/>\n" );
		}
	}
}
echo "</TreeNode>\n";
?>