📄 global_search.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>全局搜索</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script>\r\nfunction SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n  URL=\"/module/save_file?ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME+\"&A=1\";\r\n  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n  window.open(URL,null,\"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+loc_y+\",left=\"+loc_x+\",resizable=yes\");\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"0\">\r\n";
if ( !( $FILE_SORT != "1" ) && $FILE_SORT != "2" || !stristr( $HTTP_REFERER, "/general/file_folder/global_query.php" ) )
{
	exit( );
}
if ( $SUBJECT != "" )
{
	$where_str .= " and SUBJECT like '%".$SUBJECT."%'";
}
if ( $CONTENT_NO != "" )
{
	$where_str .= " and CONTENT_NO like '%".$CONTENT_NO."%'";
}
if ( $ATTACHMENT_DESC != "" )
{
	$where_str .= " and ATTACHMENT_DESC like '%".$ATTACHMENT_DESC."%'";
}
if ( $KEY1 != "" )
{
	$where_str .= " and CONTENT like '%".$KEY1."%'";
}
if ( $KEY2 != "" )
{
	$where_str .= " and CONTENT like '%".$KEY2."%'";
}
if ( $KEY3 != "" )
{
	$where_str .= " and CONTENT like '%".$KEY3."%'";
}
if ( $ATTACHMENT_NAME != "" )
{
	$where_str .= " and ATTACHMENT_NAME like '%".$ATTACHMENT_NAME."%'";
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/folder_search.gif\" align=\"absmiddle\"><b><span class=\"Big1\"> 全局搜索结果</span></b><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n";
$query = "SELECT * from FILE_CONTENT where 1".$where_str;
$query .= " order by CONTENT_NO,SEND_TIME desc";
$cursor = exequery( $connection, $query );
$CONTENT_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CONTENT_ID = $ROW['CONTENT_ID'];
	$SORT_ID = $ROW['SORT_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
	$USER_ID = $ROW['USER_ID'];
	if ( $ATTACHMENT_DATA != "" && !( $ATTACHMENT_NAME == "" ) || !( $ATTACHMENT_DATA != "" ) && !( $ATTACHMENT_NAME != "" ) )
	{
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$value == 0;
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT;	++$I	)
		{
			$FILE_PATH = $ATTACH_PATH.$ATTACHMENT_ID_ARRAY[$I]."/".$ATTACHMENT_NAME_ARRAY[$I];
			if ( !file_exists( $FILE_PATH ) )
			{
				break;
			}
			$msg = "";
			if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) && $SEARCH_DOC == "on" )
			{
				$msg = doc2txt( $FILE_PATH );
				$msg = preg_replace( "/<style>.+<\\/style>/is", "", $msg );
			}
			else if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".htm" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".html" ) )
			{
				$msg = file_get_contents( $FILE_PATH );
				$msg = strip_tags( $msg );
			}
			else if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".txt" ) )
			{
				$msg = file_get_contents( $FILE_PATH );
			}
			$msg = str_replace( " ", "", $msg );
			$msg = preg_replace( "/<[^>]+>/", "", $msg );
			$value = preg_match( "/.*".$ATTACHMENT_DATA.".*/i", $msg );
			if ( !$value )
			{
				continue;
			}
			break;
		}
	}
	if ( !( $value == 0 ) )
	{
		$SUBJECT = htmlspecialchars( $SUBJECT );
		$ATTACHMENT_NAME = htmlspecialchars( $ATTACHMENT_NAME );
		$ATTACHMENT_DESC = htmlspecialchars( $ATTACHMENT_DESC );
		$MANAGE_PRIV = 0;
		$DOWN_PRIV = 0;
		$NEW_PRIV = 0;
		if ( $SORT_ID != 0 )
		{
			do
			{
				$query1 = "SELECT * from FILE_SORT where SORT_ID='".$SORT_ID."'";
				$cursor1 = exequery( $connection, $query1 );
				if ( $ROW = mysql_fetch_array( $cursor1 ) )
				{
					$SORT_TYPE = sort_attrib( $SORT_ID, "SORT_TYPE" );
					$USER_ID = $ROW['USER_ID'];
					$MANAGE_USER = $ROW['MANAGE_USER'];
					$DOWN_USER = $ROW['DOWN_USER'];
					$NEW_USER = $ROW['NEW_USER'];
					$USER_ARRAY = explode( "|", $USER_ID );
					if ( $USER_ID != $LOGIN_USER_ID && $USER_ARRAY[0] != "ALL_DEPT" && !find_id( $USER_ARRAY[0], $LOGIN_DEPT_ID ) || !find_id( $USER_ARRAY[1], $LOGIN_USER_PRIV ) || !find_id( $USER_ARRAY[2], $LOGIN_USER_ID ) && $FILE_SORT == "1" && $SORT_TYPE == "4" || $FILE_SORT == "2" && $SORT_TYPE != "4" )
					{
						$MANAGE_ARRAY = explode( "|", $MANAGE_USER );
						$DOWN_ARRAY = explode( "|", $DOWN_USER );
						$NEW_ARRAY = explode( "|", $NEW_USER );
						if ( $USER_ID == $LOGIN_USER_ID || $MANAGE_ARRAY[0] == "ALL_DEPT" || find_id( $MANAGE_ARRAY[0], $LOGIN_DEPT_ID ) || find_id( $MANAGE_ARRAY[1], $LOGIN_USER_PRIV ) || find_id( $MANAGE_ARRAY[2], $LOGIN_USER_ID ) )
						{
							$MANAGE_PRIV = 1;
						}
						if ( $USER_ID == $LOGIN_USER_ID || $DOWN_ARRAY[0] == "ALL_DEPT" || find_id( $DOWN_ARRAY[0], $LOGIN_DEPT_ID ) || find_id( $DOWN_ARRAY[1], $LOGIN_USER_PRIV ) || find_id( $DOWN_ARRAY[2], $LOGIN_USER_ID ) )
						{
							$DOWN_PRIV = 1;
						}
						if ( !( $USER_ID == $LOGIN_USER_ID ) || !( $NEW_ARRAY[0] == "ALL_DEPT" ) || !find_id( $NEW_ARRAY[0], $LOGIN_DEPT_ID ) || !find_id( $NEW_ARRAY[1], $LOGIN_USER_PRIV ) || !find_id( $NEW_ARRAY[2], $LOGIN_USER_ID ) )
						{
							break;
						}
						$NEW_PRIV = 1;
						break;
						break;
					}
				}
			}
			else
			{
				if ( !( $USER_ID != $LOGIN_USER_ID ) )
				{
				}
			} while ( 0 );
		}
		$TREE_PATH = "";
		$TREE_PATH = full_path( $SORT_ID );
		if ( $TREE_PATH == "" && $SORT_ID == 0 )
		{
			$TREE_PATH = "/";
		}
		++$CONTENT_COUNT;
		if ( $CONTENT_COUNT == 1 )
		{
			echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\">文件夹</td>\r\n      <td nowrap align=\"center\">文件名称</td>\r\n      <td nowrap align=\"center\">附件文件</td>\r\n      <td nowrap align=\"center\">附件说明</td>\r\n      <td nowrap align=\"center\">发布时间 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n      <td nowrap align=\"center\">操作</td>\r\n  </tr>\r\n\r\n";
		}
		if ( $CONTENT_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "    <tr class=\"";
		echo $TableLine;
		echo "\">\r\n      <td>";
		echo $TREE_PATH;
		echo "</td>\r\n      <td align=\"center\"><a href=\"read.php?SORT_ID=";
		echo $SORT_ID;
		echo "&CONTENT_ID=";
		echo $CONTENT_ID;
		echo "&PAGE_START=";
		echo $PAGE_START;
		echo "\">";
		echo $SUBJECT;
		echo "</a></td>\r\n      <td align=\"left\">\r\n      ";
		if ( $ATTACHMENT_NAME == "" )
		{
			echo "无";
		}
		else
		{
			$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
			$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
			$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
				{
					break;
				}
				$ATTACH_SIZE = attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
				$ATTACH_SIZE = number_format( $ATTACH_SIZE, 0, ".", "," );
				echo "       <img src=\"/images/email_atta.gif\" align=\"absmiddle\">\r\n";
				if ( $DOWN_PRIV == 1 || !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) || !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
				{
					echo "              <a href=\"/inc/attach.php?ATTACHMENT_ID=";
					echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
					echo "&ATTACHMENT_NAME=";
					echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "\" target=\"_blank\">";
					echo $ATTACHMENT_NAME_ARRAY[$I];
					echo "</a>\r\n              <input type=\"button\" value=\"转存\" class=\"SmallButton\" onClick=\"SaveFile('";
					echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
					echo "','";
					echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "');\">\r\n";
				}
				else
				{
					echo "              ";
					echo $ATTACHMENT_NAME_ARRAY[$I];
				}
				if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
				{
					echo "\t     <input type=\"button\" value=\"阅读\" class=\"SmallButton\" onClick=\"window.open('/module/OC?ATTACHMENT_ID=";
					echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
					echo "&ATTACHMENT_NAME=";
					echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "&OP=5','";
					echo $ATTACHMENT_ID_ARRAY[$I];
					echo "','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">&nbsp;\r\n";
					if ( $MANAGE_PRIV == 1 )
					{
						echo "\t       <input type=\"button\" value=\"编辑\" class=\"SmallButton\" onClick=\"window.open('/module/OC?ATTACHMENT_ID=";
						echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
						echo "&ATTACHMENT_NAME=";
						echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
						echo "&OP=4','";
						echo $ATTACHMENT_ID_ARRAY[$I];
						echo "','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">&nbsp;\r\n";
					}
				}
				else if ( is_media( $ATTACHMENT_NAME_ARRAY[$I] ) )
				{
					echo "\t       <input type=\"button\" value=\"播放\" class=\"SmallButton\" onClick=\"window.open('/module/mediaplayer/index.php?MEDIA_NAME=";
					echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "&MEDIA_URL=";
					echo urlencode( ( "/inc/attach.php?ATTACHMENT_ID=".( $ATTACHMENT_ID_ARRAY[$I] * 3 + 2 ) )."&ATTACHMENT_NAME=".urlencode( $ATTACHMENT_NAME_ARRAY[$I] ) );
					echo "','media";
					echo $ATTACHMENT_ID_ARRAY[$I];
					echo "','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">&nbsp;\r\n";
				}
				echo "       (";
				echo $ATTACH_SIZE;
				echo "字节)<br>\r\n";
			}
		}
		echo "      </td>\r\n      <td align=\"center\">";
		echo $ATTACHMENT_DESC;
		echo "</td>\r\n      <td align=\"center\"width=\"150\" nowrap>";
		echo $SEND_TIME;
		echo "</td>\r\n      <td align=\"center\" width=\"80\" nowrap>\r\n";
		if ( $MANAGE_PRIV == 1 )
		{
			echo "          <a href=\"edit.php?FILE_SORT=";
			echo $FILE_SORT;
			echo "&SORT_ID=";
			echo $SORT_ID;
			echo "&CONTENT_ID=";
			echo $CONTENT_ID;
			echo "&PAGE_START=";
			echo $PAGE_START;
			echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_content(";
			echo $CONTENT_ID;
			echo ",";
			echo $SORT_ID;
			echo ");\"> 删除</a>\r\n";
		}
		echo "    &nbsp;\r\n      </td>\r\n  </tr>\r\n";
	}
}
if ( 0 < $CONTENT_COUNT )
{
	echo "  </table>\r\n";
	message( "", "<br>共找到".$CONTENT_COUNT."个符合条件的文件" );
}
else
{
	message( "", "<br>未找到符合条件的文件" );
}
echo "\r\n<br>\r\n<div align=\"center\">\r\n  <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='global_query.php?FILE_SORT=";
echo $FILE_SORT;
echo "'\">\r\n</div>\r\n\r\n<script>\r\nfunction delete_content(CONTENT_ID,SORT_ID)\r\n{\r\n  msg=\"确定要删除该文件吗？这将不可恢复！\";\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=\" + SORT_ID +\"&PAGE_START=";
echo $PAGE_START;
echo "&CONTENT_ID=\" + CONTENT_ID;\r\n    window.location=URL;\r\n  }\r\n}\r\n</script>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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