📄 document_function.php
字号:
<?php
function getfilepath( $SORT_ID, &$GETFILEPATH )
{
global $connection;
$query = "\r\n\t\t\tSELECT SORT_PARENT,SORT_ID,SORT_NAME FROM file_sort WHERE SORT_ID = '".$SORT_ID."' ;\r\n\t\t\t";
$res = exequery( $connection, $query );
$ROW = mysql_fetch_array( $res );
$SORT_PARENT = $ROW['SORT_PARENT'];
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_ID = $ROW['SORT_ID'];
$GETFILEPATH = $SORT_NAME."/".$GETFILEPATH;
if ( $SORT_PARENT != 0 )
{
getfilepath( $SORT_PARENT, &$GETFILEPATH );
}
if ( $GETFILEPATH == "/" )
{
$GETFILEPATH = "";
}
return $GETFILEPATH;
}
function getalldocument( &$FILE_COUNT, $FILE_PAR )
{
global $connection;
$LOGIN_USER_ID = $_SESSION['LOGIN_USER_ID'];
if ( $FILE_PAR == 0 )
{
$query = "\r\n\t\t\t\t SELECT SORT_ID,SORT_PARENT,SORT_NAME,SORT_TYPE,USER_ID FROM file_sort\r\n\t\t\t\t\t WHERE SORT_TYPE=4\r\n\t\t\t\t\t\t AND USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t\t AND SORT_PARENT=0 \r\n\t\t\t\t\t ORDER BY CREATE_TIME DESC\r\n\t\t ";
}
else
{
$query = " \r\n\t\t\t\t\tSELECT SORT_ID,SORT_PARENT,SORT_NAME,SORT_TYPE,USER_ID FROM file_sort\r\n\t\t\t\t\t WHERE SORT_PARENT=".$FILE_PAR." \r\n\t\t\t\t\t ORDER BY CREATE_TIME DESC\r\n\t\t\t\t\t\t ";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$FILE_COUNT .= $SORT_ID.",";
getalldocument( &$FILE_COUNT, $SORT_ID );
}
return $FILE_COUNT;
}
function getsorttree( $SORT_ID_CHOOSE, $FILE_SORT, $PARENT_ID, $LOGIN_DEPT_ID, $LOGIN_USER_ID, $SORT )
{
global $DEEP_COUNT;
if ( $DEEP_COUNT == "" )
{
$DEEP_COUNT = "|";
}
$connection = openconnection( );
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_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_NAME";
}
}
else
{
$query = "SELECT * from FILE_SORT where SORT_PARENT={$PARENT_ID} order by SORT_NAME";
}
$cursor = exequery( $connection, $query );
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " |";
$XML_TEXT = "";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_NAME = str_replace( "<", "<", $SORT_NAME );
$SORT_NAME = str_replace( ">", ">", $SORT_NAME );
$SORT_NAME = stripslashes( $SORT_NAME );
$OPTION_TEXT_CHILD = getsorttree( $SORT_ID_CHOOSE, $FILE_SORT, $SORT_ID, $LOGIN_DEPT_ID, $LOGIN_USER_ID, $SORT );
$OPTION_TEXT .= "<option value={$SORT_ID}";
if ( $SORT_ID == $SORT_ID_CHOOSE )
{
$OPTION_TEXT .= " selected";
}
$OPTION_TEXT .= ">".$DEEP_COUNT1."─".$SORT_NAME."</option>\n";
if ( $SORT == 1 && $SORT_ID == $SORT_ID_CHOOSE )
{
}
else if ( $OPTION_TEXT_CHILD != "" )
{
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
function tokenizequoted( $string )
{
$tokens = array( );
$nextToken = strtok( $string, "," );
for ( ; $nextToken !== false; $nextToken = strtok( "," ) )
{
$tokens[] = $nextToken;
}
return $tokens;
}
include_once( "inc/auth.php" );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -