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

📄 search.php

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

function tree_parent( $SORT_ID )
{
	$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'];
		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";
$TREE_PARENT = tree_parent( $SORT_ID );
$query = "SELECT * from FILE_SORT where SORT_ID={$TREE_PARENT}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SORT_TYPE = $ROW['SORT_TYPE'];
}
$connection = openconnection( );
$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SORT_ID = $ROW['SORT_ID'];
	$SORT_NAME = $ROW['SORT_NAME'];
	$SORT_NAME = str_replace( "<", "&lt", $SORT_NAME );
	$SORT_NAME = str_replace( ">", "&gt", $SORT_NAME );
	$SORT_NAME = stripslashes( $SORT_NAME );
	$DEPT_ID = $ROW['DEPT_ID'];
	if ( $SORT_TYPE != "4" )
	{
		$USER_ID = $ROW['USER_ID'];
		$NEW_USER = $ROW['NEW_USER'];
		$MANAGE_USER = $ROW['MANAGE_USER'];
		$DOWN_USER = $ROW['DOWN_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;
		}
		if ( $DEPT_ID != "0" )
		{
			$query1 = "SELECT * from DEPARTMENT where DEPT_ID=".$DEPT_ID;
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$DEPT_NAME = $ROW['DEPT_NAME'];
			}
		}
	}
	else
	{
		$NEW_PRIV = 1;
		$MANAGE_PRIV = 1;
		$DOWN_PRIV = 1;
	}
	switch ( $SORT_TYPE )
	{
	case "1" :
		$SORT_TYPE_DESC = "全体";
		break;
	case "2" :
		$SORT_TYPE_DESC = $DEPT_NAME;
		break;
	case "3" :
		$SORT_TYPE_DESC = "指定人员";
		break;
	case "4" :
		$SORT_TYPE_DESC = "个人";
	}
	if ( $SORT_TYPE == "4" )
	{
		$INDEX_PAGE = "index2.php";
	}
	else
	{
		$INDEX_PAGE = "index1.php";
	}
}
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\"> ";
echo $SORT_NAME;
echo "（";
echo $SORT_TYPE_DESC;
echo "）- 文件查询结果</span></b><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n";
$query = "SELECT * from FILE_CONTENT where SORT_ID={$SORT_ID}";
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'];
	$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;
			}
		}
		++$CONTENT_COUNT;
		$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 );
		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\">发布时间 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n";
			if ( $MANAGE_PRIV == 1 )
			{
				echo "      <td nowrap align=\"center\">操作</td>\r\n";
			}
			echo "  </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\"><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";
		if ( $MANAGE_PRIV == 1 )
		{
			echo "      <td align=\"center\" width=\"80\" nowrap>\r\n          <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 ");\"> 删除</a>\r\n      </td>\r\n";
		}
		echo "  </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='query.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "'\">\r\n</div>\r\n\r\n";
echo "<s";
echo "cript>\r\nfunction delete_content(CONTENT_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=";
echo $SORT_ID;
echo "&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 + -