tree.php

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

<?
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)
{
  if($FILE_SORT==1)
      $query = "SELECT * from FILE_SORT where (SORT_TYPE='1' or (SORT_TYPE='2' and DEPT_ID=$LOGIN_DEPT_ID) or (SORT_TYPE='3' and (InStr(USER_ID,',$LOGIN_USER_ID,')>0 or InStr(USER_ID,'$LOGIN_USER_ID,')=1))) and SORT_PARENT=$PARENT_ID order by SORT_NO,SORT_NAME";
  else
      $query = "SELECT * from FILE_SORT where SORT_TYPE='4' and USER_ID='$LOGIN_USER_ID' and SORT_PARENT=$PARENT_ID 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"];
    $USER_ID=$ROW["USER_ID"];
    $SHARE_USER=$ROW["SHARE_USER"];
    $SORT_PARENT=$ROW["SORT_PARENT"];

    if($USER_ID=="")
      $USER_ID=access_priv($SORT_ID);

    if($FILE_SORT==1&&!find_id($USER_ID,$LOGIN_USER_ID))
       continue;

    $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=\"$SORT_NAME\" 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=\"$SORT_NAME\" target=\"file_main\" Xml=\"tree.php?SORT_ID=$SORT_ID&amp;FILE_SORT=$FILE_SORT\"/>\n";

}//while

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