⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 global_search.php

📁 极限网络智能办公系统—MYOA26—100％—源程序。
💻 PHP
字号:
🔍 
<?php

function tree_parent( $SORT_ID )
{
	global $TREE_PATH;
	$connection = openconnection( );
	$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_ID}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_PARENT = $ROW['SORT_PARENT'];
		$SORT_NAME = $ROW['SORT_NAME'];
		$TREE_PATH = $SORT_NAME."/".$TREE_PATH;
		if ( $SORT_PARENT == 0 )
		{
			return $SORT_ID;
		}
		else
		{
			return tree_parent( $SORT_PARENT );
		}
	}
}

include_once( "inc/auth.php" );
include_once( "inc/conn.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";
echo "<s";
echo "cript>\r\nfunction delete_comment(CONTENT_ID)\r\n{\r\n  msg=\"确定要删除该文件吗?\";\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?BOARD_ID=";
echo $BOARD_ID;
echo "&CONTENT_ID=\" + CONTENT_ID;\r\n    window.location=URL;\r\n  }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" WIDTH=\"22\" HEIGHT=\"20\"><b>";
echo "<s";
echo "pan class=\"Big1\">全部文件搜索结果</span></b><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n";
$query = "SELECT * from FILE_CONTENT where 1";
if ( $SUBJECT != "" )
{
	$query .= " and SUBJECT like '%{$SUBJECT}%'";
}
if ( $ATTACHMENT_DESC != "" )
{
	$query .= " and ATTACHMENT_DESC like '%{$ATTACHMENT_DESC}%'";
}
if ( $KEY1 != "" )
{
	$query .= " and CONTENT like '%{$KEY1}%'";
}
if ( $KEY2 != "" )
{
	$query .= " and CONTENT like '%{$KEY2}%'";
}
if ( $KEY3 != "" )
{
	$query .= " and CONTENT like '%{$KEY3}%'";
}
if ( $ATTACHMENT_NAME != "" )
{
	$query .= " and ATTACHMENT_NAME like '%{$ATTACHMENT_NAME}%'";
}
$query .= " order by 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'];
	if ( $ATTACHMENT_DATA != "" && $ATTACHMENT_NAME == "" )
	{
	}
	else
	{
		if ( $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 ) )
				{
				}
				else
				{
					$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 )
					{
						break;
					}
				}
			}
			if ( $value == 0 )
			{
				continue;
			}
		}
		$SUBJECT = str_replace( "<", "&lt", $SUBJECT );
		$SUBJECT = str_replace( ">", "&gt", $SUBJECT );
		$SUBJECT = stripslashes( $SUBJECT );
		$ATTACHMENT_NAME = str_replace( "<", "&lt", $ATTACHMENT_NAME );
		$ATTACHMENT_NAME = str_replace( ">", "&gt", $ATTACHMENT_NAME );
		$ATTACHMENT_NAME = stripslashes( $ATTACHMENT_NAME );
		$ATTACHMENT_DESC = str_replace( "<", "&lt", $ATTACHMENT_DESC );
		$ATTACHMENT_DESC = str_replace( ">", "&gt", $ATTACHMENT_DESC );
		$ATTACHMENT_DESC = stripslashes( $ATTACHMENT_DESC );
		$TREE_PATH = "";
		$TREE_PARENT = tree_parent( $SORT_ID );
		$query1 = "SELECT * from FILE_SORT where SORT_ID={$TREE_PARENT}";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$SORT_TYPE = $ROW['SORT_TYPE'];
			$SORT_NAME = $ROW['SORT_NAME'];
			$USER_ID = $ROW['USER_ID'];
			$DEPT_ID = $ROW['DEPT_ID'];
			$DOWN_USER = $ROW['DOWN_USER'];
			if ( $SORT_TYPE != "4" )
			{
				$NEW_USER = $ROW['NEW_USER'];
				$MANAGE_USER = $ROW['MANAGE_USER'];
				$NEW_PRIV = 0;
				$MANAGE_PRIV = 0;
				$DOWN_PRIV = 0;
				if ( find_id( $NEW_USER, $LOGIN_USER_ID ) )
				{
					$NEW_PRIV = 1;
				}
				if ( find_id( $MANAGE_USER, $LOGIN_USER_ID ) )
				{
					$MANAGE_PRIV = 1;
				}
				if ( find_id( $DOWN_USER, $LOGIN_USER_ID ) )
				{
					$DOWN_PRIV = 1;
				}
			}
			else
			{
				$NEW_PRIV = 1;
				$MANAGE_PRIV = 1;
				$DOWN_PRIV = 1;
			}
		}
		if ( $FILE_SORT == 2 && $SORT_TYPE != 4 || $FILE_SORT == 1 && $SORT_TYPE == 4 )
		{
		}
		else if ( $SORT_TYPE == 2 && $DEPT_ID != $LOGIN_DEPT_ID )
		{
		}
		else if ( $SORT_TYPE == 3 && !find_id( $USER_ID, $LOGIN_USER_ID ) )
		{
		}
		else if ( $SORT_TYPE == 4 && $USER_ID != $LOGIN_USER_ID )
		{
		}
		else
		{
			++$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=";
				echo "\"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 align=\"center\">";
			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] == "" )
					{
					}
					else
					{
						$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\">\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 "         \r\n              <a href=\"/inc/attach.php?ATTACHMENT_ID=";
							echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
							echo "&ATTACHMENT_NAME=";
							echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
							echo "\">";
							echo $ATTACHMENT_NAME_ARRAY[$I];
							echo "</a>\r\n";
						}
						else
						{
							echo "         \r\n              ";
							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',null,'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',null,'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";
}
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";
echo "<s";
echo "cript>\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 + -