📄 query.php

📁 极限网络智能办公系统 - Office Automation 2.8 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 );
		}
	}
	return 0;
}

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";
echo "<s";
echo "cript>\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 (fa";
echo "lse);\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=\"5\" onload=\"document.form1.SUBJECT.focus();\">\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'];
}
$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( "<", "&lt", $SORT_NAME );
	$SORT_NAME = str_replace( ">", "&gt", $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 = "个人文件夹";
	}
}
else
{
	$SORT_NAME = "根目录";
	$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\" align=\"absmiddle\"><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<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";
echo "\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\">内
⌨️ 快捷键说明

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