📄 search_file.php
字号:
<?php
function getdirbysortid( &$array_fsort_s, $sort_id )
{
$connection = openconnection( );
$sql = "\r\n\t SELECT SORT_ID,SORT_PARENT,SORT_NAME FROM file_sort\r\n\t\t WHERE SORT_ID=".$sort_id." \r\n\t ";
$res = exequery( $connection, $sql );
$row = mysql_fetch_array( $res );
$array_fsort_s['id'][] = $row['SORT_ID'];
$array_fsort_s['name'][] = $row['SORT_NAME'];
if ( $row['SORT_PARENT'] != 0 )
{
getdirbysortid( &$array_fsort_s, $row['SORT_PARENT'] );
}
return $array_fsort_s;
}
session_start( );
include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
include_once( "inc/utility_all.php" );
if ( $_REQUEST['cur_page'] == "" )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
$page_purview = 7;
if ( $_REQUEST['doc'] == "mydoc" )
{
$title = "个人文档 - 查询结果";
$message = "您的个人文件夹没有任何目录和文件！";
}
else if ( $_REQUEST['doc'] == "alldoc" )
{
$title = "公共文档 - 查询结果";
$message = "公共目录里没有任何目录和文件！";
}
echo "<html>\r\n<head>\r\n<title>";
echo $title;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/1/style.css\">\r\n\r\n";
echo "<s";
echo "cript src=\"mm_menu.js\"></script>\r\n";
echo "<s";
echo "cript Language=JavaScript>\r\n//window.setTimeout('this.location.reload();',120000);\r\n</script>\r\n\r\n\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\" > \r\n\r\n\r\n\r\n";
$SAFE_CHECK_OK = 0;
if ( find_id( $USER_FUNC_ID_STR, $page_purview ) )
{
$SAFE_CHECK_OK = 1;
}
if ( $SAFE_CHECK_OK == 0 )
{
message( "警告", "无该模块使用权限！如需使用该模块，请联系管理员重新设置本角色权限！" );
exit( );
}
else
{
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td class=\"tablehead1\"><img src=\"/images/menu/infofind.gif\" align=\"absmiddle\"> ";
echo $title;
echo "</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><br></td>\r\n </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo " <tr class=\"TableHeader\">\r\n <td width=\"32%\"><a href=\"";
echo $sufurl;
echo "&doc=";
echo $_REQUEST['doc'];
echo "&keyword=";
echo $_REQUEST['keyword'];
echo "&cur_page=";
echo $cur_page;
echo "&order=filename\" title=\"按文件名排序\">文件名</a>";
if ( $_REQUEST['order'] == "filename" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td width=\"10%\"><a href=\"";
echo $sufurl;
echo "&doc=";
echo $_REQUEST['doc'];
echo "&keyword=";
echo $_REQUEST['keyword'];
echo "&cur_page=";
echo $cur_page;
echo "&order=sort\" title=\"按文件夹排序\">文件夹</a>";
if ( $_REQUEST['order'] == "sort" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td>附件</td>\r\n <td width=\"5%\" nowrap ><a href=\"";
echo $sufurl;
echo "&doc=";
echo $_REQUEST['doc'];
echo "&keyword=";
echo $_REQUEST['keyword'];
echo "&cur_page=";
echo $cur_page;
echo "&order=createtime\" title=\"按创建时间排序\">编辑日期</a>";
if ( $_REQUEST['order'] == "createtime" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td width=\"5%\" nowrap >大小</td>\r\n <td width=\"10%\" nowrap >操作</td>\r\n </tr>\r\n ";
if ( $_REQUEST['doc'] == "mydoc" )
{
function selectfilesortrecursion( &$array_fsort, $file_sort )
{
$connection = openconnection( );
if ( $file_sort == "" )
{
$sql = "\r\n\t\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\t WHERE SORT_TYPE=4\r\n\t\t\t\t\t\t\t AND USER_ID='".$_SESSION['LOGIN_USER_ID']."'\r\n\t\t\t\t ";
}
else
{
$sql = "\r\n\t\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\t WHERE SORT_PARENT=".$file_sort."\r\n\t\t\t\t ";
}
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
$array_fsort['id'][] = $row['SORT_ID'];
$array_fsort['name'][] = $row['SORT_NAME'];
selectfilesortrecursion( &$array_fsort, $row['SORT_ID'] );
}
return $array_fsort;
}
}
else if ( $_REQUEST['doc'] == "alldoc" )
{
function selectfilesortrecursion( &$array_fsort, $file_sort )
{
$connection = openconnection( );
if ( $file_sort == "" )
{
$sql = "\r\n\t\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\t WHERE SORT_TYPE=4\r\n\t\t\t\t\t\t\t AND USER_ID='".$_SESSION['LOGIN_USER_ID']."'\r\n\t\t\t\t ";
}
else
{
$sql = "\r\n\t\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\t WHERE SORT_PARENT=".$file_sort."\r\n\t\t\t\t ";
}
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
$array_fsort['id'][] = $row['SORT_ID'];
$array_fsort['name'][] = $row['SORT_NAME'];
selectfilesortrecursion( &$array_fsort, $row['SORT_ID'] );
}
return $array_fsort;
}
}
$arflst = selectfilesortrecursion( &$array_fsort, "" );
$arstid = $arflst['id'];
if ( is_array( $arstid ) )
{
$in_term = implode( ",", $arstid );
}
else
{
$in_term = "";
}
if ( $in_term == "" )
{
echo "<tr><td algin='center' colspan='4'>";
message( "提示", $message );
echo "</td></tr>";
echo "</table>";
exit( );
}
$sql = "\r\n SELECT CONTENT_ID,SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,SHARE_USER,USER_ID FROM file_content\r\n\t\t WHERE (SORT_ID IN (".$in_term.") OR \r\n\t\t\t (INSTR(SHARE_USER,'".$_SESSION['LOGIN_USER_ID']."') AND USER_ID<>'".$_SESSION['LOGIN_USER_ID']."') AND SORT_ID<>0)\r\n\t\t\t AND (SUBJECT LIKE '%".$_REQUEST['keyword']."%' \r\n\t\t\t OR CONTENT LIKE '%".$_REQUEST['keyword']."%' )\r\n\t\t\t \r\n ";
switch ( $_REQUEST['order'] )
{
case "filename" :
$sql .= "ORDER BY SUBJECT ";
break;
case "createtime" :
$sql .= "ORDER BY SEND_TIME ";
break;
case "sort" :
$sql .= "ORDER BY SORT_ID ";
break;
default :
$sql .= "ORDER BY SEND_TIME ";
}
$sql .= $_REQUEST['sens'] ? " ASC" : " DESC";
$sql = page( $sql, 15 );
$res = exequery( $connection, $sql );
$doc_count = 0;
$doc_office = 0;
while ( $row = mysql_fetch_array( $res ) )
{
++$doc_count;
$content_id = $row['CONTENT_ID'];
$sort_id = $row['SORT_ID'];
$subject = $row['SUBJECT'];
$subjectlen = 50;
$subjectsuffix = "...";
$content = $row['CONTENT'];
$send_time = $row['SEND_TIME'];
$share_user = $row['SHARE_USER'];
$f_user_id = $row['USER_ID'];
$date_str = date( "Y-m-d", strtotime( $send_time ) );
$date_str = "<span style='font-size:10px'>".$date_str."</span>";
if ( $_REQUEST['keyword'] != "" )
{
$subject = replacestr( substrgb( strip_tags( $row['SUBJECT'] ), $subjectlen, $subjectsuffix ), "", $_REQUEST['keyword'] );
$subject_all = $row['SUBJECT'];
}
else
{
$subject = substrgb( strip_tags( $row['SUBJECT'] ), $subjectlen, $subjectsuffix );
$subject_all = $row['SUBJECT'];
}
$is_share = 0;
$shareflag = "";
$f_user_name = "";
if ( !( strpos( $share_user, $_SESSION['LOGIN_USER_ID'] ) === false ) && $f_user_id != $_SESSION['LOGIN_USER_ID'] )
{
$is_share = 1;
$sql_u = "SELECT USER_NAME FROM user WHERE USER_ID='".$f_user_id."'";
$rs_u = exequery( $connection, $sql_u );
$row_u = mysql_fetch_array( $rs_u );
$f_user_name = $row_u['USER_NAME'];
}
if ( $is_share == 1 )
{
$shareflag = " <img src='/images/littlegif/share_f2.gif' title='共享文件，创建人:{$f_user_name}'>({$f_user_name})";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -