share_tree.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 57 行

<?
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";
echo "<TreeNode>\n";

$PARENT_ID=$SORT_ID;
//$LOGIN_DEPT_ID=1;
//$LOGIN_USER_ID="lxq";

if($PARENT_ID==0)
   $query = "SELECT * from FILE_SORT where find_in_set('$LOGIN_USER_ID',SHARE_USER) order by SORT_NO,SORT_NAME";
else
   $query = "SELECT * from FILE_SORT where SORT_PARENT=$PARENT_ID order by SORT_NO,SORT_NAME";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
    $SORT_ID=$ROW["SORT_ID"];
    $SORT_NAME=$ROW["SORT_NAME"];
    $SHARE_USER=$ROW["SHARE_USER"];

    $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 * 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\" 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\" title=\"$SORT_NAME\" target=\"file_main\" Xml=\"share_tree.php?SORT_ID=$SORT_ID\"/>\n";

}//while

echo "</TreeNode>\n";
?>