folder.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

				echo "   <a href=\"query.php?FILE_SORT=";
				echo $FILE_SORT;
				echo "&SORT_ID=";
				echo $SORT_ID;
				echo "&refreshno=";
				echo $_REQUEST['refreshno'];
				echo "\"><img src=\"/images/button/searchfile.gif\" title=\"查询文件\" border=\"0\"></a>\r\n";
			}
		}
		if ( !( $FILE_SORT == 1 && $SORT_ID == 0 ) )
		{
			if ( $NEW_PRIV == 1 || $FILE_SORT == 2 )
			{
				echo "  <a href=\"folder_new?FILE_SORT=";
				echo $FILE_SORT;
				echo "&SORT_ID=";
				echo $SORT_ID;
				echo "&refreshno=";
				echo $_REQUEST['refreshno'];
				echo "\"><img src=\"/images/button/setfilefolder.gif\" title=\"创建子文件夹\" border=\"0\"></a>\r\n";
			}
			if ( $FILE_SORT == 2 && $SORT_ID != 0 || $MANAGE_PRIV == 1 && $SORT_PARENT != 0 )
			{
				echo "   <a href=\"folder_edit?FILE_SORT=";
				echo $FILE_SORT;
				echo "&SORT_ID=";
				echo $SORT_ID;
				echo "&refreshno=";
				echo $_REQUEST['refreshno'];
				echo "\"><img src=\"/images/button/renamefilefolder.gif\"  title=\"重命名此文件夹\" border=\"0\"></a>\r\n   <a href=\"javascript:delete_sort(";
				echo $SORT_ID;
				echo ")\"><img src=\"/images/button/delfilefolder.gif\"  title=\"删除此文件夹\" border=\"0\">\r\n   ";
				if ( $SORT_ID != 0 )
				{
					echo "   \r\n   ";
				}
				echo "</td>\r\n</tr>\r\n   <tr class=\"TableLine2\">\r\n     <td>转移此文件夹至：\r\n       ";
				echo "<s";
				echo "elect name=\"SORT_ID\" onChange=\"change_sort('1','dir');\" class=\"SmallSelect\">\r\n         ";
				echo my_sort_tree( $SORT_ID, $FILE_SORT, 0, $LOGIN_DEPT_ID, $LOGIN_USER_ID, 1 );
				echo "       </select>\r\n       ";
			}
			echo "       ";
		}
		echo "</td>\r\n   </tr>\r\n  </table>\r\n";
		if ( $SORT_ID != 0 )
		{
			echo "<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#FFFFFF\">\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"5\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap>选择</td>\r\n      <td nowrap>文件名称</td>\r\n      <td nowrap>附件文件</td>\r\n      <td nowrap>创建人</td>\r\n\t  <td nowrap>发布时间</td>\r\n";
			if ( $MANAGE_PRIV == 1 )
			{
				echo "      <td nowrap align=\"center\">操作</td>\r\n";
			}
			echo "  </tr>\r\n";
			$query1 = "SELECT F.SORT_NAME,F.CREATE_TIME FROM FILE_SORT F WHERE ";
			$query1 .= " SORT_ID = '".$SORT_ID."'   ORDER BY CREATE_TIME DESC";
			$cursor1 = exequery( $connection, $query1 );
			while ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				++$FILE_COUNT;
				$SORT_NAME = $ROW['SORT_NAME'];
				$CREATE_TIME = $ROW['CREATE_TIME'];
				if ( $FILE_COUNT % 2 == 1 )
				{
					$TableLine = "TableLine1";
				}
				else
				{
					$TableLine = "TableLine2";
				}
				$query3 = "select * from file_sort where sort_parent=".$_REQUEST['SORT_ID'];
				$cursor3 = exequery( $connection, $query3 );
				$filecount = 0;
				while ( $row3 = mysql_fetch_array( $cursor3 ) )
				{
					$sort_id = $row3['SORT_ID'];
					$sort_name = $row3['SORT_NAME'];
					$create_time = $row3['CREATE_TIME'];
					++$filecount;
					if ( $filecount % 2 == 1 )
					{
						$TableLines = "TableLine1";
					}
					else
					{
						$TableLines = "TableLine2";
					}
					echo "<tr class=\"";
					echo $TableLines;
					echo "\">\r\n   <td>&nbsp;</td>\r\n   <td>";
					echo "<img src=\"/images/menu/tree_diropen.gif\"><a href=\"folder.php?SORT_ID=".$sort_id."&FILE_SORT=".$_REQUEST['FILE_SORT']."&refreshno=".$_REQUEST['refreshno']."\">".$sort_name."</a><br>";
					echo "</td>\r\n   <td>&nbsp;</td>\r\n   <td>&nbsp;</td>\r\n   <td>";
					echo $create_time;
					echo "</td>\r\n";
					if ( $MANAGE_PRIV == 1 )
					{
						echo "   <td>\r\n   <a href=\"folder_edit?FILE_SORT=";
						echo $_REQUEST['FILE_SORT'];
						echo "&SORT_ID=";
						echo $sort_id;
						echo "&refreshno=";
						echo $_REQUEST['refreshno'];
						echo "\">编辑</a>&nbsp;\r\n   <a href=\"javascript:delete_sort(";
						echo $sort_id;
						echo ")\"> 删除</a></td>\r\n";
					}
				}
				echo "   </tr>\r\n";
			}
			$query = "SELECT a.CONTENT_ID,a.SUBJECT,a.SEND_TIME,a.ATTACHMENT_ID,a.ATTACHMENT_NAME, ";
			$query .= " a.ATTACHMENT_DESC,a.USER_ID from FILE_CONTENT a,FILE_SORT b";
			$query .= "  WHERE a.SORT_ID = b.SORT_ID ";
			$query .= " AND a.SORT_ID='".$SORT_ID."'";
			$query .= " order by SEND_TIME desc";
			$cursor = exequery( $connection, $query );
			$FILE_COUNT = 0;
			while ( $ROW = mysql_fetch_array( $cursor ) )
			{
				++$FILE_COUNT;
				if ( $FILE_COUNT < $PAGE_START )
				{
					continue;
				}
				else
				{
					if ( $PAGE_END < $FILE_COUNT )
					{
						break;
					}
				}
				$CONTENT_ID = $ROW['CONTENT_ID'];
				$SUBJECT = $ROW['SUBJECT'];
				$SEND_TIME = $ROW['SEND_TIME'];
				$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
				$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
				$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
				$sql_n = "SELECT USER_NAME FROM user WHERE USER_ID='".$ROW['USER_ID']."'";
				$rs_n = exequery( $connection, $sql_n );
				$row_n = mysql_fetch_array( $rs_n );
				$USER_NAME = $row_n['USER_NAME'];
				$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 );
				if ( $FILE_COUNT % 2 == 1 )
				{
					$TableLine = "TableLine1";
				}
				else
				{
					$TableLine = "TableLine2";
				}
				echo "   \r\n\t<tr class=\"";
				echo $TableLine;
				echo "\">\r\n      <td><input type=\"checkbox\" name=\"email_select\" value=\"";
				echo $CONTENT_ID;
				echo "\" onClick=\"check_one(self);\"></td>\r\n      <td ><a href=\"read.php?FILE_SORT=";
				echo $_REQUEST['FILE_SORT'];
				echo "&SORT_ID=";
				echo $SORT_ID;
				echo "&CONTENT_ID=";
				echo $CONTENT_ID;
				echo "&PAGE_START=";
				echo $PAGE_START;
				echo "&refreshno=";
				echo $_REQUEST['refreshno'];
				echo "\">";
				echo $SUBJECT;
				echo "</a></td>\r\n      <td align=\"left\">\r\n      ";
				if ( $ATTACHMENT_NAME == "" )
				{
					echo "无";
				}
				else
				{
					$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
					$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
					$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
					$I = 0;
					for ( ;	$I < $ARRAY_COUNT;	++$I	)
					{
						if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
						{
						}
						else
						{
							$ATTACH_SIZE = attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
							$ATTACH_SIZE = number_format( $ATTACH_SIZE, 0, ".", "," );
							echo "       <img src=\"/images/email_atta.gif\">\r\n";
							if ( $DOWN_PRIV == 1 )
							{
								echo "          <a href=\"/inc/attach.php?ATTACHMENT_ID=";
								echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
								echo "&ATTACHMENT_NAME=";
								echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
								echo "\">";
								echo $ATTACHMENT_NAME_ARRAY[$I];
								echo "</a>\r\n";
							}
							else
							{
								echo "          ";
								echo $ATTACHMENT_NAME_ARRAY[$I];
							}
							if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
							{
								echo "\t   <input type=\"button\" onClick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
								echo $CONTENT_ID;
								echo "&EditType=0&UserName=";
								echo $_SESSION['LOGIN_USER_ID'];
								echo ";&ATTACHMENT_ID=";
								echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
								echo "&ATTACHMENT_NAME=";
								echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
								echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\" value=\"阅读\" class=\"SmallButton\">\r\n";
								if ( $MANAGE_PRIV == 1 )
								{
									echo "\t       <input type=\"button\" value=\"编辑\" class=\"SmallButton\" onClick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
									echo $CONTENT_ID;
									echo "&EditType=2&UserName=";
									echo $_SESSION['LOGIN_USER_ID'];
									echo ";&ATTACHMENT_ID=";
									echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
									echo "&ATTACHMENT_NAME=";
									echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
									echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">\r\n";
								}
							}
							echo "       (";
							echo $ATTACH_SIZE;
							echo "字节)<br>\r\n";
						}
					}
				}
				echo "      </td>\r\n      <td >";
				echo $USER_NAME;
				echo "</td>\r\n      <td  width=\"150\" nowrap>";
				echo $SEND_TIME;
				echo "</td>\r\n";
				if ( $MANAGE_PRIV == 1 )
				{
					echo "      <td width=\"100\" nowrap>\r\n          <a href=\"edit.php?FILE_SORT=";
					echo $FILE_SORT;
					echo "&SORT_ID=";
					echo $SORT_ID;
					echo "&CONTENT_ID=";
					echo $CONTENT_ID;
					echo "&PAGE_START=";
					echo $PAGE_START;
					echo "&refreshno=";
					echo $_REQUEST['refreshno'];
					echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_content(";
					echo $CONTENT_ID;
					echo ");\"> 删除</a>&nbsp;";
					if ( $SORT_TYPE == 4 )
					{
						echo "<a href=\"#\" onClick=\"doshare(";
						echo $CONTENT_ID;
						echo ",";
						echo $PAGE_START;
						echo ")\" class=\"smallbutton\">共享</a>";
					}
					echo "      </td>\r\n";
				}
				echo "\r\n  </tr>\r\n\r\n";
			}
			echo "  </table>\r\n";
			if ( 0 < $FILE_COUNT )
			{
				echo "<table width=\"100%\" border=\"0\" cellpadding=\"5\">\r\n<tr>\r\n  <td >\r\n     <input type=\"checkbox\" name=\"allbox\" onClick=\"check_all();\">全部选中&nbsp;&nbsp;\r\n";
				if ( $MANAGE_PRIV == 1 )
				{
					echo "     转移至：\r\n     ";
					echo "<s";
					echo "elect name=\"SORT_PARENT\" onChange=\"change_sort('0','file');\" class=\"SmallSelect\">\r\n";
					echo my_sort_trees( $SORT_ID, $FILE_SORT, 0, $LOGIN_DEPT_ID, $LOGIN_USER_ID, 0 );
					echo "     </select>&nbsp;&nbsp;\r\n";
				}
				echo "   </td>\r\n   <td  align=\"right\">\r\n   ";
				if ( $PAGE_START != 1 )
				{
					echo "  <a href=\"folder.php?FILE_SORT=";
					echo $FILE_SORT;
					echo "&SORT_ID=";
					echo $SORT_ID;
					echo "\">首页</a>";
				}
				echo "   ";
				if ( $PAGE_START != 1 )
				{
					echo "<a href=\"folder.php?FILE_SORT=";
					echo $FILE_SORT;
					echo "&SORT_ID=";
					echo $SORT_ID;
					echo "&PAGE_START=";
					echo $PAGE_START - $PAGE_SIZE;
					echo "\"> 上一页</a>";
				}
				echo " \r\n   ";
				if ( !( $FILE_COUNT <= $PAGE_END ) )
				{
					echo " <a href=\"folder.php?FILE_SORT=";
					echo $FILE_SORT;
					echo "&SORT_ID=";
					echo $SORT_ID;
					echo "&PAGE_START=";
					echo $PAGE_END + 1;
					echo "\">下一页</a>";
				}
				echo "  \r\n   ";
				if ( !( $FILE_COUNT <= $PAGE_END ) )
				{
					echo " <a href=\"folder.php?FILE_SORT=";
					echo $FILE_SORT;
					echo "&SORT_ID=";
					echo $SORT_ID;
					echo "&PAGE_START=";
					echo $LAST_PAGE_START;
					echo "\">末页</a>";
				}
				echo "   \r\n    页数\r\n     <input type=\"text\" name=\"PAGE_NUM\" value=\"";
				echo $PAGE_NUM;
				echo "\" class=\"SmallInput\" size=\"2\"> <a href=\"#\" onClick=\"set_page();\" title=\"转到指定的页面\">转到</a>&nbsp;\r\n   </td>\r\n  </tr>\r\n</table>\r\n\r\n";
			}
		}
	}
}
echo "</form>\r\n\r\n\r\n";
echo "<s";
echo "cript>\r\nfunction delete_content(CONTENT_ID)\r\n{\r\n  msg=\"确定要删除该文件吗？这将不可恢复！\";\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&CONTENT_ID=\" + CONTENT_ID+\"&refreshno=";
echo $_REQUEST['refreshno'];
echo "\";\r\n    window.location=URL;\r\n  }\r\n}\r\n\r\nfunction delete_sort(SORT_ID)\r\n{\r\n  msg=\"确定要删除该文件夹吗？这将删除该文件夹中的所有文件和子文件夹，且不可恢复！\";\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete_sort.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=\" + SORT_ID+\"&refreshno=";
echo $_REQUEST['refreshno'];
echo "\";\r\n    window.location=URL;\r\n  }\r\n}\r\nfunction change_sort(sort,file)\r\n{\r\n  delete_str=\"\";\r\n  if(sort==\"0\")\r\n  {\r\n     for(i=0;i<document.all(\"email_select\").length;i++)\r\n     {\r\n\r\n         el=document.all(\"email_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\n     {\r\n         el=document.all(\"email_sele";
echo "ct\");\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_parent=document.all(\"SORT_ID\").value;\r\n  url=\"c";
echo "hange_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 "&refreshno=";
echo $_REQUEST['refreshno'];
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\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</script>\r\n";
echo "</body>\r\n</html>";
?>