📄 query.php

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

include_once( "inc/auth.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\r\n<script>\r\nfunction CheckForm()\r\n{\r\n   if(document.form1.SUBJECT.value==\"\" && document.form1.CONTENT_NO.value==\"\" && document.form1.KEY1.value==\"\" && document.form1.KEY2.value==\"\" && document.form1.KEY3.value==\"\" && document.form1.ATTACHMENT_DESC.value==\"\" && document.form1.ATTACHMENT_NAME.value==\"\" && document.form1.ATTACHMENT_DATA.value==\"\")\r\n   { alert(\"请指定至少一个查询条件！\");\r\n     return (false);\r\n   }\r\n\r\n   return true;\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"0\" onload=\"document.form1.SUBJECT.focus();\">\r\n\r\n";
$query = "SELECT SORT_NAME,USER_ID from FILE_SORT where SORT_ID='".$SORT_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SORT_NAME = $ROW['SORT_NAME'];
	$USER_ID = $ROW['USER_ID'];
	$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 ) )
	{
		exit( );
	}
	$SORT_NAME = htmlspecialchars( $SORT_NAME );
}
else
{
	$SORT_NAME = "根目录";
}
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/folder_search.gif\" align=\"absmiddle\"><b><span class=\"Big1\"> ";
echo $SORT_NAME;
echo "- 查询文件</span></b><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"450\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n<form action=\"search.php\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">标题包含文字：</td>\r\n      <td nowrap><input type=\"text\" name=\"SUBJECT\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">排序号：</td>\r\n      <td nowrap><input type=\"text\" name=\"CONTENT_NO\" class=\"BigInput\" size=\"10\"></td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\" align=\"center\">内容[关键词1]：</td>\r\n    <td class=\"TableData\"><input type=\"text\" name=\"KEY1\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\" align=\"center\">内容[关键词2]：</td>\r\n    <td class=\"TableData\"><input type=\"text\" name=\"KEY2\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\" align=\"center\">内容[关键词3]：</td>\r\n    <td class=\"TableData\"><input type=\"text\" name=\"KEY3\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">附件说明包含文字：</td>\r\n      <td nowrap><input type=\"text\" name=\"ATTACHMENT_DESC\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">附件文件名包含文字：</td>\r\n      <td nowrap><input type=\"text\" name=\"ATTACHMENT_NAME\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">附件内容包含文字：</td>\r\n      <td nowrap><input type=\"text\" name=\"ATTACHMENT_DATA\" class=\"BigInput\" size=\"20\"></td>\r\n  </tr>\r\n";
if ( strtolower( substr( PHP_OS, 0, 3 ) ) == "win" )
{
	echo "  <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">搜索Word(doc)文档：</td>\r\n      <td nowrap><input type=\"checkbox\" name=\"SEARCH_DOC\" id=\"SEARCH_DOC\">&nbsp;&nbsp;<label for=\"SEARCH_DOC\">可能会导致搜索速度很慢！</label></td>\r\n  </tr>\r\n";
}
echo "  <tr >\r\n      <td nowrap class=\"TableControl\" colspan=\"2\" align=\"center\">\r\n          <input type=\"hidden\" name=\"SORT_ID\" value=\"";
echo $SORT_ID;
echo "\">\r\n          <input type=\"hidden\" name=\"FILE_SORT\" value=\"";
echo $FILE_SORT;
echo "\">\r\n          <input type=\"submit\" value=\"查询\" class=\"BigButton\" title=\"进行文件查询\">&nbsp;&nbsp;\r\n          <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='folder.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "'\">\r\n      </td>\r\n  </tr>\r\n</table>\r\n</form>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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