📄 search_pub_file.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?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  nowrap ><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%\" nowrap ><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 width=\"5%\" nowrap >附件</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.") \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 = 80;
		$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'] != "" )
		{
			$content = replacestr( substrgb( strip_tags( $row['CONTENT'] ), 200, "..." ), "red", $_REQUEST['keyword'] );
			$subject = replacestr( substrgb( strip_tags( $row['SUBJECT'] ), 38, "..." ), "red", $_REQUEST['keyword'] );
		}
		else
		{
			$content = substrgb( strip_tags( $row['CONTENT'] ), 200, "..." );
			$subject = substrgb( strip_tags( $row['SUBJECT'] ), 38, "..." );
		}
		unset( $array_fsort_s );
		$arraySort = getdirbysortid( &$array_fsort_s, $sort_id );
		$finally_sort_id = "";
		$f_key = count( $arraySort['id'] ) - 1;
		$finally_sort_id = $arraySort['id'][$f_key];
		$sql_pri = "SELECT SORT_TYPE,NEW_USER,MANAGE_USER,DOWN_USER FROM FILE_SORT WHERE SORT_ID=".$finally_sort_id;
		$rs_pri = exequery( $connection, $sql_pri );
		$row_pri = mysql_fetch_array( $rs_pri );
		$new_user = $row_pri['NEW_USER'];
		$manage_user = $row_pri['MANAGE_USER'];
		$down_user = $row_pri['DOWN_USER'];
		$new_priv = 0;
		$manage_priv = 0;
		$down_priv = 0;
		if ( find_id( $new_user, $_SESSION['LOGIN_USER_ID'] ) )
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -