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

📄 search.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
🔍 
<?php

include_once( "inc/auth.php" );
include_once( "inc/document_function.php" );
include_once( "inc/function_page_01.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility.php" );
$SHAREALLDOC = getsharedocument( "2" );
$SHAREALLDOC = substr( $SHAREALLDOC, 0, -1 );
if ( $SHAREALLDOC == "" )
{
	$SHAREALLDOC = 0;
}
if ( $_REQUEST['cur_page'] == "" )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
$SAVE_LOG = $_REQUEST['SAVE_LOG'];
if ( $SAVE_LOG != "" )
{
	savesysoplog( $SAVE_LOG, "4", "file_content", "" );
}
echo "<html>\r\n<head>\r\n";
echo "<s";
echo "tyle>\r\n.tdstyle{\r\n\tborder-bottom-width: 1px;\r\n\tborder-bottom-color: #CCCCFF;\r\n\theight:24px;\r\n}\r\n.linktextOp{\r\n\tborder-bottom: 1px double #0033CC;\r\n\tcolor:#0033CC;\r\n\tcursor:hand; \r\n\t}\r\n.linkdivOp{\r\n\tcolor:#0033CC;\r\n\tcursor:hand; \r\n\t}\r\n</style>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/document_new.js\"></SCRIPT>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/common.js\"></SCRIPT>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/follow.js\"></SCRIPT>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/prototype.js\"></SCRIPT>\r\n";
echo "<s";
echo "cript>\r\nfunction rearchDcoument(){\r\n\twindow.location.href =\"query.php\";\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\" >\r\n    <td><IMG SRC=\"/images/menu/work_plan.gif\" WIDTH=\"30\" HEIGHT=\"25\" BORDER=\"0\" align=\"absmiddle\">共享文档\r\n    </td>\r\n  </tr>\r\n </table>\r\n <table border=\"0\" width=\"100%\" cellspacing";
echo "=\"0\" cellpadding=\"0\">\r\n  <tr class=\"tablehead2\">\r\n  \t<td>\r\n\t<BUTTON class=\"btn\" onClick=\"location.href='/general/file_folder/file_new/doc_share/index.php'\" title=\"返回\"><table><tr valign=\"top\" ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返 回</span></td></tr></table></BUTTON>\r\n\t</td>\r\n  </tr>\r\n</table>\r\n<table cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"1\">\r\n";
$DOC_COUNT = 0;
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
$query = "\r\n\t\t   SELECT FC.CONTENT_ID,FC.SUBJECT,FC.ATTACHMENT_ID,FC.ATTACHMENT_NAME,FC.ATTACHMENT_DESC,FC.USER_ID,DS.SHARE_TIME FROM  file_content as FC,document_share as DS  \r\n\t\t\t\tWHERE FC.CONTENT_ID = DS.DOCUMENT_ID \r\n\t\t\t\t\tAND DS.FILE_TYPE = 2\r\n\t\t\t\t\t   AND( \r\n\t\t\t\t\t   (INStr(DS.DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(DS.DEPT_ID,'{$LOGIN_DEPT_ID},')=1) \r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (INStr(DS.PRIV_ID,',{$LOGIN_PRIV_ID},')>0 or INStr(DS.PRIV_ID,'{$LOGIN_PRIV_ID},')=1)\r\n\t\t\t\t\t   or \r\n\t\t\t\t\t   (INStr(DS.USER_ID,',{$LOGIN_USER_ID},')>0 or INStr(DS.USER_ID,'{$LOGIN_USER_ID},')=1)\r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (FC.USER_ID='{$LOGIN_USER_ID}')\r\n\t\t\t\t\t   ) \r\n\t\t\t\t\t\tAND (\r\n\t\t\t";
if ( $SUBJECT != "" )
{
	if ( $POSITION != "" )
	{
		$query .= " (FC.CONTENT LIKE '%{$SUBJECT}%' ) OR ";
	}
	if ( $POSITION1 != "" )
	{
		$query .= " (FC.SUBJECT LIKE '%{$SUBJECT}%' ) OR ";
	}
	if ( $POSITION2 != "" )
	{
		$query .= " (FC.ATTACHMENT_DESC LIKE '%{$SUBJECT}%' ) OR ";
	}
	if ( $POSITION == "" && $POSITION1 == "" && $POSITION2 == "" )
	{
		$query .= "(FC.CONTENT LIKE '%{$SUBJECT}%' )OR (FC.SUBJECT LIKE '%{$SUBJECT}%' )OR(FC.ATTACHMENT_DESC LIKE '%{$SUBJECT}%' ))";
	}
	else
	{
		$query .= "0 )";
	}
}
else
{
	$query .= "1 )";
}
if ( $creat_user_id != "" )
{
	$creat_user_id = ",".$creat_user_id;
	$creat_user_id = str_replace( ",", "','", $creat_user_id );
	$creat_user_id = substr( $creat_user_id, 2, -2 );
	$query .= " AND (FC.USER_ID IN ({$creat_user_id}))";
}
if ( $creat_date_start != "" )
{
	$query .= "AND to_days(date_format(DS.SHARE_TIME,'%Y-%m-%d')) >= to_days('".$_REQUEST['creat_date_start']."')";
}
if ( $creat_date_end != "" )
{
	$query .= " AND to_days(date_format(DS.SHARE_TIME,'%Y-%m-%d')) <= to_days('".$_REQUEST['creat_date_end']."')";
}
switch ( $_REQUEST['order'] )
{
case "subject" :
	$query .= " order by FC.SUBJECT";
	break;
case "share_user" :
	$query .= " order by FC.USER_ID";
	break;
case "share_time" :
	$query .= " order by DS.SHARE_TIME";
	break;
default :
	$query .= " order by DS.SHARE_TIME ";
	break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 12 );
$cousor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cousor ) )
{
	++$DOC_COUNT;
	if ( $DOC_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	$CONTENT_ID = $ROW['CONTENT_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
	$USER_ID = $ROW['USER_ID'];
	$SHARE_TIME = $ROW['SHARE_TIME'];
	$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 );
	echo "       \t<tr class=\"";
	echo $TableLine;
	echo "\"> </td>\r\n\t\t<td height='23px'><a href=\"javascript:openDocumentsWindows('../read.php?FILE_SORT=2&CONTENT_ID=";
	echo $CONTENT_ID;
	echo "&cur_page=";
	echo $cur_page;
	echo "')\" title=\"";
	echo $SUBJECT;
	echo "\">\r\n\t   ";
	echo substrgb( $SUBJECT, 30, "..." );
	echo "\t\t</a></td>\r\n\t\t<td>\r\n\t\t";
	if ( $ATTACHMENT_ID == "" )
	{
		echo "&nbsp;";
	}
	else
	{
		echo "\t\t";
		echo "<s";
		echo "pan style=\"cursor:hand;\" onClick=\"showSlave(";
		echo $CONTENT_ID;
		echo ")\"><IMG SRC=\"/images/document/attachment_18.gif\" BORDER=\"0\" ALT=\"\"></span>\t\r\n\t\t";
	}
	echo "\t\t</td>\r\n\t\t<td>";
	echo getusernamenew( $USER_ID );
	echo "</td>\r\n\t\t<td>";
	echo $SHARE_TIME;
	echo "</td>\r\n\t\t";
	if ( $USER_ID == $LOGIN_USER_ID )
	{
		echo "<td><a href=\"javascript:returnShare('{$CONTENT_ID}')\" class=\\smallbutton\">回收共享</a></td>";
	}
	else
	{
		echo "<td>回收共享</td>";
	}
}
echo "<thead class=\"TableHeader\">\r\n<td><a href=\"";
echo $sufurl;
echo "&order=subject&cur_page=";
echo $cur_page;
echo "&POSITION=";
echo $_REQUEST['POSITION'];
echo "&POSITION1=";
echo $_REQUEST['POSITION1'];
echo "&POSITION2=";
echo $_REQUEST['POSITION2'];
echo "&creat_user_id=";
echo $_REQUEST['creat_user_id'];
echo "&SUBJECT=";
echo $_REQUEST['SUBJECT'];
echo "&creat_date_start=";
echo $_REQUEST['creat_date_start'];
echo "&creat_date_end=";
echo $_REQUEST['creat_date_end'];
echo "\">文档名称";
if ( $_REQUEST['order'] == "subject" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n<td >附件</td>\r\n<td><a href=\"";
echo $sufurl;
echo "&order=share_user&cur_page=";
echo $cur_page;
echo "&POSITION=";
echo $_REQUEST['POSITION'];
echo "&POSITION1=";
echo $_REQUEST['POSITION1'];
echo "&POSITION2=";
echo $_REQUEST['POSITION2'];
echo "&creat_user_id=";
echo $_REQUEST['creat_user_id'];
echo "&SUBJECT=";
echo $_REQUEST['SUBJECT'];
echo "&creat_date_start=";
echo $_REQUEST['creat_date_start'];
echo "&creat_date_end=";
echo $_REQUEST['creat_date_end'];
echo "\">共享人";
if ( $_REQUEST['order'] == "share_user" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n<td><a href=\"";
echo $sufurl;
echo "&order=share_time&cur_page=";
echo $cur_page;
echo "&POSITION=";
echo $_REQUEST['POSITION'];
echo "&POSITION1=";
echo $_REQUEST['POSITION1'];
echo "&POSITION2=";
echo $_REQUEST['POSITION2'];
echo "&creat_user_id=";
echo $_REQUEST['creat_user_id'];
echo "&SUBJECT=";
echo $_REQUEST['SUBJECT'];
echo "&creat_date_start=";
echo $_REQUEST['creat_date_start'];
echo "&creat_date_end=";
echo $_REQUEST['creat_date_end'];
echo "\">共享时间";
if ( $_REQUEST['order'] == "share_time" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n<td >操作</td>\r\n</thead>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellpadding=\"0\">\r\n   <td width=\"83%\" align=\"right\">\r\n ";
disp( "sens=".$_REQUEST['sens']."&order=".$_REQUEST['order'] );
echo "   </td>\r\n  </tr>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page."&FILE_SORT=".$FILE_SORT );
}
if ( $DOC_COUNT == 0 )
{
	message( "", "没有满足条件的文档！" );
}
echo "</table>\r\n\r\n<div id=\"divslave\" style=\"display:none;position:absolute;width:380px;height:auto;padding:5px;background-color: #FFFFFF;border: 1px solid #848484;z-index:10;\" onblur=\"hideDiv('divslave')\">\r\n</div>\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

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