📄 filelist.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?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" );
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", "" );
}
$SORT_ID = $_REQUEST['SORT_ID'];
if ( $SORT_ID == "" )
{
	$SORT_ID = 0;
}
$FILE_SORT = $_REQUEST['FILE_SORT'];
if ( $FILE_SORT == "" )
{
	$FILE_SORT = 1;
}
include_once( "inc/config_doc.inc.php" );
global $FILE_PATH_PURVIEW;
global $DOWN_PATH_PURVIEW;
global $ALLREADPUR;
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}\r\n.inputdubl{\r\n\tbackground-color:#CCCCCC;\r\n}\r\n</style>\r\n\r\n<div style=\"display:none;position:absolute; visibility:show;left:0px;top:0px;padding:1px;background:#ffffff;border:1px solid #00BE00;width:120px;color:#666666;z-index: 9999;filter:alpha(opacity=100);\" id=\"divnote\"><table><tr><td><img src=\"/images/workflow/success.gif\" ";
echo "id=\"imgntext\"></td> <td>";
echo "<s";
echo "pan id=\"ntext\" style=\"color:green\">发送成功</span></td></tr></table></div>\r\n\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 checkAll(){\r\n\tvar allcheckbox = document.getElementsByName('allbox')[0].checked;\r\n\tvar singlebox =document.getElementsByName(\"check_select\");\r\n\t  for(i=0;i";
echo "<s";
echo "inglebox.length;i++){\r\n\t\t  if(allcheckbox){\r\n\t\t   singlebox.item(i).checked=true;\r\n\t\t  }else{\r\n\t\t   singlebox.item(i).checked=false;\r\n\t\t  }\r\n\t  }\r\n}\r\n\r\nfunction checkOne(el){\r\n\tvar allstate = el.checked;\r\n\r\n\tif(!allstate){\r\n\t\tdocument.getElementsByName(\"allbox\")[0].checked=false;\r\n\t}\r\n\tif(isAllCol('check_select')){\r\n\t\tdocument.getElementsByName(\"allbox\")[0].checked=true;\r\n   }\r\n}\r\n\r\n\r\nfunction del";
echo "eteDocument(CONTENT_ID,fromwhere,this_id,FILE_SORT)\r\n{\r\n\tif(FILE_SORT==1){\r\n\tvar thistype = document.getElementById('what_'+CONTENT_ID).tagName;\r\n\tif(thistype=='INPUT'){\t\r\n\t\t  msg=\"确定要删除该文件吗?\";\r\n\t\t  if(window.confirm(msg))\r\n\t\t  {\r\n\t\t\tURL=\"delete.php?CONTENT_ID=\"+CONTENT_ID+\"&cur_page=";
echo $cur_page;
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "&order=";
echo $_REQUEST['order'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&s_id=\"+this_id+\"&fromwhere=\"+fromwhere ;\r\n\t\t\twindow.location=URL;\r\n\t\t  }\r\n\t}else{\r\n\t var thistypevalue = document.getElementById('what_'+CONTENT_ID).alt;\r\n\t  if(thistypevalue==\"锁定信息\"){\r\n\t\t  alert(\"此文档处于编辑锁定状态不能删除!鼠标滑过左边的锁提示锁定信息!\");\r\n\t  }else{ \t\t\t\t\r\n\t\t  msg=\"您编辑还没有保存!您确定要删除该文件吗?\";\r\n\t\t  if(window.confirm(msg))\r\n\t\t  {\r\n\t\t\tURL=\"delete.php?CONTENT_ID=";
echo "\"+CONTENT_ID+\"&cur_page=";
echo cur_page;
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "&order=";
echo $_REQUEST['order'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&s_id=\"+this_id+\"&fromwhere=\"+fromwhere;\r\n\t\t\twindow.location=URL;\r\n\t\t  }\r\n\t  }\r\n\t //thistypevalue = thistypevalue.substring();\r\n\t}\r\n\t}else{\r\n   msg=\"确定要删除该文件吗?\";\r\n\t\t  if(window.confirm(msg))\r\n\t\t  {\r\n\t\t\tURL=\"delete.php?CONTENT_ID=\"+CONTENT_ID+\"&cur_page=";
echo $cur_page;
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "&order=";
echo $_REQUEST['order'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&s_id=\"+this_id+\"&fromwhere=\"+fromwhere ;\r\n\t\t\twindow.location=URL;\r\n\t\t  }\r\n\t}\r\n}\r\n\r\n\r\nfunction changeSort(sort,file)\r\n{\r\n  delete_str=\"\";\r\n  if(sort==\"0\")\r\n  {\r\n     for(i=0;i<document.all(\"check_select\").length;i++)\r\n     {\r\n         el=document.all(\"check_select\").item(i);\r\n         if(el.checked)\r\n         {  val=el.value;\r\n            delete_str+=val + \",\";\r\n         }\r\n     }\r\n\r\n     if(i==0)\r";
echo "\n     {\r\n         el=document.all(\"check_select\");\r\n         if(el.checked)\r\n         {  val=el.value;\r\n            delete_str+=val + \",\";\r\n         }\r\n     }\r\n\r\n     if(delete_str==\"\")\r\n     {\r\n        alert(\"要转移文件，请至少选择其中一个。\");\r\n        document.form1.reset();\r\n        return;\r\n     }\r\n  }\r\n  if(sort==\"0\")\r\n    sort_parent=document.all(\"SORT_PARENT\").value;\r\n  else\r\n    sort_pare";
echo "nt=document.all(\"SORT_ID\").value;\r\n\turl=\"change_sort.php?FILE_STR=\"+ delete_str +\"&SORT_ID=";
echo $SORT_ID;
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_PARENT=\"+sort_parent+\"&SORT=\"+sort+\"&PAGE_START=";
echo $PAGE_START;
echo "&SORT_ID=";
echo $SORT_ID;
echo "\";\r\n  \r\n  if(file\t== \"file\")\r\n  {\r\n\t msg\t= \"确定要转移此文件吗？\";\r\n\t if(window.confirm(msg))\r\n\t {\r\n\t\tlocation=url;\r\n\t }\r\n   }\r\n   \r\n   if(file\t== \"dir\")\r\n   {\r\n   \t  msg = \"确定要转移此文件夹吗？\";\r\n\t  if(window.confirm(msg))\r\n\t  {\r\n\t\tlocation=url;\r\n\t  }\r\n   }\r\n}\r\n\r\nfunction isAllCol(colname){\r\n\t\tvar object = document.getElementsByName(colname);\r\n\t\tvar length = object.length;\r\n\t\tfor(var j=0;j<leng";
echo "th;j++){\r\n\t\t\tif(!(object[j].checked)){\r\n\t\t\t\treturn false;\t\t\t   \r\n\t\t\t\tbreak;\r\n\t\t\t}\r\n\t\t\t\r\n\t\t}\r\n\t\treturn true;\r\n\t}\r\n\r\n\r\nfunction rePurview(){\r\n\talert(\"你没有足够的权限回复此文档,详情请咨询系统管理员!\");\r\n\treturn false;\r\n}\r\nfunction getLockMassage(log_id){\r\n\tvar obj = \"lockdiv\";\r\n\tvar objdiv = document.getElementById(obj);\r\n\tobjdiv.style.display = \"\";\r\n\tobjdiv.focus();\r\n\tobjdiv.style.posLeft = event.c";
echo "lientX+document.body.scrollLeft+10;\r\n\tobjdiv.style.posTop = event.clientY+document.body.scrollTop;\r\n\tobjdiv.innerHTML = \"<div id='picload'><img src='/images/loading.gif'>数据加载中，请稍等...</div>\";\r\n\turl = \"lock_massage_show.php\";\r\n\tpar =  \"LOG_ID=\"+log_id;\r\n\tloadingdata(obj,url,par);\r\n}\r\nfunction openLock(open_id,sort_id){\r\n\t location.href = '/general/file_folder/file_new/filelist.php?cur_page=";
echo $_REQUEST['cur_page'];
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&SAVE_LOG='+open_id+'&SORT_ID=";
echo $_REQUEST['SORT_ID'];
echo "';\r\n}\r\nfunction editDocument(CONTENT_ID,SORT_ID,FILE_SORT){\r\n\r\n\tif(FILE_SORT==1){\r\n\tvar thistype = document.getElementById('what_'+CONTENT_ID).tagName;\r\n\tif(thistype=='INPUT'){\twindow.parent.location.href='neworedit/index.php?FILE_SORT=";
echo $FILE_SORT;
echo "&cur_page=";
echo $_REQUEST['cur_page'];
echo "&CONTENT_ID='+CONTENT_ID+'&SORT_ID='+SORT_ID;\r\n\t}else{\r\n\t var thistypevalue = document.getElementById('what_'+CONTENT_ID).alt;\r\n\t  if(thistypevalue==\"锁定信息\"){\r\n\t\t  alert(\"此文档处于编辑锁定状态不能编辑!鼠标滑过左边的锁提示锁定信息!\");\r\n\t  }else{ \t\t\t\twindow.parent.location.href='neworedit/index.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID='+SORT_ID+'&cur_page=";
echo $_REQUEST['cur_page'];
echo "&CONTENT_ID='+CONTENT_ID;\r\n\t  }\r\n\t}\r\n}else{\r\n\t  window.parent.location.href='neworedit/index.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID='+SORT_ID+'&cur_page=";
echo $_REQUEST['cur_page'];
echo "&CONTENT_ID='+CONTENT_ID;\r\n\t}\r\n}\r\nfunction sendOutLockSms(content_id,lock_user_id){\r\n\tvar formName = \"form1\";\r\n\tvar subObj = document.getElementById('savebutton');\r\n\t//var simgObj = document.getElementById('saveimg');\r\n\r\n\t//simgObj.style.filter = \"gray()\";\r\n\tsubObj.disabled = true;\r\n\r\n\tvar objOtext = document.getElementById('otext');\r\n\tobjOtext.innerHTML = \"数据保存中...\";\r\n\tvar saveGimg = {\r\n\t\ton";
echo "Create: function(){\r\n\t\t\tElement.show('div_save');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('div_save');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimg);\r\n\r\n\tvar par = \"lock_user_id=\"+lock_user_id+\"&content_id=\"+content_id;\r\n\tvar url = \"send_lock_sms.php\" \r\n\tqueryString = par;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSucces";
echo "s : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\tshowNText();\r\n\t\t\t\t\t\t\tdocument.getElementById('lockdiv').style.display='none';\r\n\t\t\t\t\t\t\t//simgObj.style.filter = \"\";\r\n\t\t\t\t\t\t\t//subObj.disabled = \"\";\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n</script>\r\n</head>\r\n\r\n";
if ( $FILE_SORT == 1 )
{
	$FILEPATH = "&nbsp;<a href=\"filelist.php?SORT_ID=0&FILE_SORT=1\">公共文档目录</a>/".getfilepath( $SORT_ID, &$GETFILEPATH, $FILE_SORT, "link" );
}
else
{
	$FILEPATH = "&nbsp;<a href=\"filelist.php?SORT_ID=0&FILE_SORT=2\">个人文档目录</a>/".getfilepath( $SORT_ID, &$GETFILEPATH, $FILE_SORT, "link" );
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"1\" onLoad=\"setVariables(); checkLocation('div_save',120,20,1);\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n  <tr class=\"tablehead2\">\r\n  \t<td>\r\n\t";
echo "<s";
echo "pan style=\"\">";
echo $FILEPATH;
echo "</span>\r\n\t</td>\r\n  </tr>\r\n</table>\r\n<table cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"1\">\r\n";
$inputcoun = 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 = "SELECT a.SORT_ID,a.USER_ID,a.CONTENT_ID,a.SUBJECT,a.SEND_TIME,a.ATTACHMENT_ID,a.ATTACHMENT_NAME,a.ATTACHMENT_DESC,a.USER_ID,b.SORT_NAME ";
if ( $FILE_SORT == 1 )
{
	$query .= " from FILE_CONTENT a,FILE_SORT b,DOCUMENT_SHARE c";
	$query .= "  WHERE (a.CONTENT_ID = c.DOCUMENT_ID and a.SORT_ID=b.SORT_ID) ";
}
else
{
	$query .= "  from FILE_CONTENT a,FILE_SORT b";
	$query .= "  WHERE (a.SORT_ID=b.SORT_ID) ";
}
if ( $SORT_ID == 0 && $FILE_SORT == 1 )
{
	$query .= " \r\n\t\t\t\tAND (a.SORT_ID IN ({$ALLREADPUR}) \r\n\t\t\t\t\tOR (c.FILE_TYPE=1\r\n\t\t\t\t\tand( \r\n\t\t\t\t\t   (INStr(c.DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(c.DEPT_ID,'{$LOGIN_DEPT_ID},')=1) \r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (INStr(c.PRIV_ID,',{$LOGIN_USER_PRIV},')>0 or INStr(c.PRIV_ID,'{$LOGIN_USER_PRIV},')=1)\r\n\t\t\t\t\t   or \r\n\t\t\t\t\t   (INStr(c.USER_ID,',{$LOGIN_USER_ID},')>0 or INStr(c.USER_ID,'{$LOGIN_USER_ID},')=1)\r\n\t\t\t\t\t   )\r\n\t\t\t\t\t)\r\n\t\t\t\t)\r\n\t\t";
}
if ( $SORT_ID != 0 && $FILE_SORT == 1 )
{
	$query .= " \r\n\t\t\tAND ((a.SORT_ID IN ({$ALLREADPUR})and(a.SORT_ID IN ({$DOWN_PATH_PURVIEW}))) \r\n\t\t\t\tOR (c.FILE_TYPE=1\r\n\t\t\t\t\tand( \r\n\t\t\t\t\t   (INStr(c.DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(c.DEPT_ID,'{$LOGIN_DEPT_ID},')=1) \r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (INStr(c.PRIV_ID,',{$LOGIN_USER_PRIV},')>0 or INStr(c.PRIV_ID,'{$LOGIN_USER_PRIV},')=1)\r\n\t\t\t\t\t   or \r\n\t\t\t\t\t   (INStr(c.USER_ID,',{$LOGIN_USER_ID},')>0 or INStr(c.USER_ID,'{$LOGIN_USER_ID},')=1)\r\n\t\t\t\t\t   )\r\n\t\t\t\tand (a.SORT_ID IN ({$DOWN_PATH_PURVIEW})))\r\n\t\t\t\t)";
}
if ( $FILE_SORT == 2 )
{
	$query .= " AND (a.SORT_ID IN ({$FILE_PATH_PURVIEW}))";
}
switch ( $_REQUEST['order'] )
{
case "subject" :
	$query .= " order by a.SUBJECT";
	break;
case "user_creat" :
	$query .= " order by a.USER_ID";
	break;
case "user_time" :
	$query .= " order by a.SEND_TIME";
	break;
case "file" :
	$query .= " order by a.SORT_ID";
	break;
default :
	$query .= " order by a.SEND_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'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$SEND_TIME = substr( $SEND_TIME, 0, 10 );
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
	$SORT_NAME = $ROW['SORT_NAME'];
	$USER_ID = $ROW['USER_ID'];
	$SORT_ID = $ROW['SORT_ID'];
	$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 "\">\r\n\t\t<td align = 'center'>\r\n\t\t";
	if ( $FILE_SORT == 1 )
	{
		$sql_max = "\r\n\t\t\t\t\tSELECT max(OPERATION_DATE) as MAXTIME FROM sys_op_log WHERE SEQ_ID = '".$CONTENT_ID."' and OPERATION_TYPE = 2 and TABLE_NAME ='file_content'\r\n\t\t\t\t\t";
		$res_max = exequery( $connection, $sql_max );
		$ROWMAX = mysql_fetch_array( $res_max );
		$LOG_MAX_TIME = $ROWMAX['MAXTIME'];
		$query_save = "\r\n\t\t\t\t\tSELECT LOG_ID FROM sys_op_log WHERE SEQ_ID = '".$CONTENT_ID."' and OPERATION_TYPE = 4 and OPERATION_DATE > '{$LOG_MAX_TIME}' and TABLE_NAME ='file_content'\r\n\t\t\t\t\t";
		$res_save = exequery( $connection, $query_save );
		$ROWSAVE = mysql_fetch_array( $res_save );
		$LOG_SAVE_ID = $ROWSAVE['LOG_ID'];
		$sql_user = "\r\n\t\t\t\t\tSELECT USER_ID,LOG_ID FROM sys_op_log WHERE SEQ_ID = '".$CONTENT_ID."' and OPERATION_TYPE = 2 and  OPERATION_DATE = '{$LOG_MAX_TIME}' and TABLE_NAME ='file_content'\r\n\t\t\t\t\t";
		$res_user = exequery( $connection, $sql_user );
		$ROWUSER = mysql_fetch_array( $res_user );
		$LOG_MAX_USER = $ROWUSER['USER_ID'];
		$LOG_ID = $ROWUSER['LOG_ID'];
		if ( $LOG_SAVE_ID == "" && $LOG_ID != "" && opinionpurview( "MANAGE", $SORT_ID ) )
		{
12 下一页
⌨️ 快捷键说明

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