📄 query.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" );
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";
echo "<s";
echo "cript>\r\nfunction CheckForm()\r\n{\r\n if(document.form1.SUBJECT.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</s";
echo "cript>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"document.form1.SUBJECT.focus();\">\r\n\r\n";
$connection = openconnection( );
$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'];
}
$query = "SELECT * from FILE_SORT where SORT_ID={$SORT_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_NAME = str_replace( "<", "<", $SORT_NAME );
$SORT_NAME = str_replace( ">", ">", $SORT_NAME );
$SORT_NAME = stripslashes( $SORT_NAME );
$DEPT_ID = $ROW['DEPT_ID'];
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'];
}
}
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 = "个人文件夹";
}
}
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<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#FFFFFF\">\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=\"t";
echo "ext\" name=\"SUBJECT\" class=\"BigInput\" size=\"20\"></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";
echo ">\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=\"";
echo "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\"> 可能会导致搜索速度很慢！</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=\"进行文件查询\"> \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 + -