📄 edit.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" );
include_once( "inc/conn.php" );
include_once( "inc/utility_all.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 Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.SUBJECT.value==\"\")\r\n { alert(\"文件名称不能为空！\");\r\n return (false);\r\n }\r\n\r\n if (document.form1.ATTACHMENT&&document.form1.ATTACHMENT.value!=\"\")\r\n {\r\n var file_temp=document.form1.ATTACHMENT.value,file_name;\r\n var Pos;\r\n Pos=file_temp.lastIndexOf(\"\\\\\");\r\n file_name=file_temp.substring(Pos+1,fil";
echo "e_temp.length);\r\n document.form1.ATTACHMENT_NAME.value=file_name;\r\n }\r\n\r\n document.form1.CONTENT.value=EDIT_HTML.GetHtml();\r\n\r\n return (true);\r\n}\r\n\r\nfunction upload_attach()\r\n{\r\n if (document.form1.ATTACHMENT.value!=\"\")\r\n {\r\n var file_temp=document.form1.ATTACHMENT.value,file_name;\r\n var Pos;\r\n Pos=file_temp.lastIndexOf(\"\\\\\");\r\n file_name=file_temp.substring(Pos+1,file";
echo "_temp.length);\r\n document.form1.ATTACHMENT_NAME.value=file_name;\r\n }\r\n else\r\n {\r\n \t alert(\"请选择要上传的文件！\");\r\n \t return (false);\r\n }\r\n document.form1.OP.value=2;\r\n document.form1.CONTENT.value=EDIT_HTML.GetHtml();\r\n\r\n document.form1.submit();\r\n}\r\n\r\nfunction delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n msg=\"确定要删除文件 '\"+ ATTACHMENT_NAME +\"' 吗?\";\r\n if(window.";
echo "confirm(msg))\r\n {\r\n URL=\"delete_attach.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 "&ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction Load_Do()\r\n{\r\n EDIT_HTML.SetHtml(document.form1.CONTENT.value);\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"Load_Do();\">\r\n\r\n";
$query = "SELECT * from FILE_CONTENT where CONTENT_ID={$CONTENT_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$CONTENT = str_replace( "\"", "'", $CONTENT );
$CONTENT_NO = $ROW['CONTENT_NO'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
}
$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_ID == 0 )
{
$SORT_TYPE = $ROW['SORT_TYPE'];
$DEPT_ID = $ROW['DEPT_ID'];
$USER_ID = $ROW['USER_ID'];
$DOWN_USER = $ROW['DOWN_USER'];
$DOWN_PRIV = 0;
if ( find_id( $DOWN_USER, $LOGIN_USER_ID ) || $SORT_TYPE == "4" || $SORT_ID == 0 )
{
$DOWN_PRIV = 1;
}
switch ( $SORT_TYPE )
{
case "2" :
if ( !( $DEPT_ID != $LOGIN_DEPT_ID ) )
{
break;
}
exit( );
break;
case "3" :
if ( find_id( $USER_ID, $LOGIN_USER_ID ) )
{
break;
}
exit( );
break;
case "4" :
if ( $USER_ID != $LOGIN_USER_ID )
{
break;
}
exit( );
}
}
if ( $FILE_SORT == "2" )
{
$query = "SELECT * from USER where USER_ID='{$LOGIN_USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FOLDER_CAPACITY = $ROW['FOLDER_CAPACITY'];
}
function tree_size( $SORT_ID_TMP )
{
global $CONTENT_COUNT;
$connection = openconnection( );
$query = "select * from FILE_CONTENT where SORT_ID={$SORT_ID_TMP}";
$cursor = exequery( $connection, $query );
$SORT_SIZE = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$CONTENT_COUNT;
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SORT_SIZE += strlen( $CONTENT ) + strlen( $SUBJECT );
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT - 1; ++$I )
{
$SORT_SIZE += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
$query = "select * from FILE_SORT where SORT_PARENT={$SORT_ID_TMP}";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID_TMP = $ROW['SORT_ID'];
$SORT_SIZE += tree_size( $SORT_ID_TMP );
}
return $SORT_SIZE;
}
function tree_size_root( )
{
global $LOGIN_USER_ID;
$connection = openconnection( );
$query = "select * from FILE_CONTENT where SORT_ID=0 AND USER_ID='{$LOGIN_USER_ID}'";
$cursor = exequery( $connection, $query );
$SORT_SIZE = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SORT_SIZE += strlen( $CONTENT ) + strlen( $SUBJECT );
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT - 1; ++$I )
{
$SORT_SIZE += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
return $SORT_SIZE;
}
if ( $FOLDER_CAPACITY != 0 )
{
$USER_ID = $LOGIN_USER_ID;
$CONTENT_COUNT = 0;
$query = "select * from FILE_SORT where SORT_TYPE=4 and USER_ID='{$USER_ID}' and SORT_PARENT=0";
$cursor = exequery( $connection, $query );
$SORT_SIZE = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID_TMP = $ROW['SORT_ID'];
$SORT_SIZE += tree_size( $SORT_ID_TMP );
}
$SORT_SIZE += tree_size_root( );
if ( $FOLDER_CAPACITY * 1024 * 1024 < $SORT_SIZE )
{
$CAPACITY_FLAG = 1;
}
else
{
$CAPACITY_FLAG = 0;
}
}
else
{
$CAPACITY_FLAG = 0;
}
}
else
{
$CAPACITY_FLAG = 0;
}
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/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><b>";
echo "<s";
echo "pan class=\"Big1\"> 编辑文件</span></b>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n <table border=\"0\" width=\"550\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <form enctype=\"multipart/form-data\" action=\"update.php\" method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n <tr>\r\n <td nowrap class=\"TableData\"> 文件名称：</td>\r\n <td class=\"TableData\">\r\n <input ty";
echo "pe=\"text\" name=\"SUBJECT\" size=\"50\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $SUBJECT;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 排序号：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"CONTENT_NO\" size=\"10\" maxlength=\"20\" class=\"BigInput\" value=\"";
echo $CONTENT_NO;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" valign=\"top\"> 文件内容：</td>\r\n <td class=\"TableData\">\r\n <iframe name=\"EDIT_HTML\" width=\"100%\" height=260 src=\"/module/editor\" viewastext type=\"text/x-scriptlet\"></iframe>\r\n <input type=\"hidden\" name=\"CONTENT\" value=\"";
echo $CONTENT;
echo "\">\r\n </td>\r\n </tr>\r\n <tr class=\"TableContent\">\r\n <td nowrap>附件文档：</td>\r\n <td nowrap>\r\n";
if ( $ATTACHMENT_ID == "" )
{
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\" align=\"absmiddle\">\r\n";
if ( $DOWN_PRIV == 1 || !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) && !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) && !stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
{
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 "\" target=\"_blank\">";
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\" value=\"阅读\" class=\"SmallButton\" onClick=\"window.open('/module/OC?ATTACHMENT_ID=";
echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
echo "&ATTACHMENT_NAME=";
echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
echo "&OP=5&PRINT=1',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\"> \r\n\t <input type=\"button\" value=\"编辑\" class=\"SmallButton\" onClick=\"window.open('/module/OC?ATTACHMENT_ID=";
echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
echo "&ATTACHMENT_NAME=";
echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
echo "&OP=4',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\"> \r\n";
}
echo "\t <input type=\"button\" value=\"删除\" class=\"SmallButton\" onClick=\"delete_attach('";
echo $ATTACHMENT_ID_ARRAY[$I];
echo "','";
echo $ATTACHMENT_NAME_ARRAY[$I];
echo "');\">\r\n";
echo "(".$ATTACH_SIZE."字节)<br>";
}
}
}
echo " </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap>附件上传：</td>\r\n <td nowrap>\r\n";
if ( $CAPACITY_FLAG == 1 )
{
echo "个人文件柜容量超过限制({$FOLDER_CAPACITY} MB)，不能上传附件！";
}
else
{
echo " <input type=\"file\" name=\"ATTACHMENT\" size=\"30\" class=\"BigInput\" title=\"选择附件文件\">\r\n <input type=\"button\" class=\"BigButton\" value=\"上传附件\" onclick=\"upload_attach();\">\r\n <input type=\"hidden\" name=\"ATTACHMENT_ID_OLD\" value=\"";
echo $ATTACHMENT_ID;
echo "\">\r\n <input type=\"hidden\" name=\"ATTACHMENT_NAME_OLD\" value=\"";
echo $ATTACHMENT_NAME;
echo "\">\r\n";
}
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 附件说明：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"ATTACHMENT_DESC\" size=\"30\" maxlength=\"50\" class=\"BigInput\" value=\"";
echo $ATTACHMENT_DESC;
echo "\">\r\n </td>\r\n </tr>\r\n";
if ( $FILE_SORT == "1" )
{
echo " <tr>\r\n <td nowrap class=\"TableData\">提醒：</td>\r\n <td class=\"TableData\">\r\n <input type=\"checkbox\" name=\"SMS_REMIND\" id=\"SMS_REMIND\"><label for=\"SMS_REMIND\">使用内部短信提醒用户</label>\r\n";
$query = "select * from SMS2_PRIV";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TYPE_PRIV = $ROW['TYPE_PRIV'];
}
if ( find_id( $TYPE_PRIV, 16 ) )
{
echo " <input type=\"checkbox\" name=\"SMS2_REMIND\" id=\"SMS2_REMIND\"><label for=\"SMS2_REMIND\">使用手机短信提醒用户</label>\r\n";
}
echo " </td>\r\n </tr>\r\n";
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"hidden\" value=\"";
echo $CONTENT_ID;
echo "\" name=\"CONTENT_ID\">\r\n <input type=\"hidden\" name=\"FILE_SORT\" value=\"";
echo $FILE_SORT;
echo "\">\r\n <input type=\"hidden\" value=\"";
echo $SORT_ID;
echo "\" name=\"SORT_ID\">\r\n <input type=\"hidden\" value=\"";
echo $PAGE_START;
echo "\" name=\"PAGE_START\">\r\n <input type=\"hidden\" name=\"ATTACHMENT_NAME\" maxlength=\"100\">\r\n <input type=\"hidden\" name=\"OP\" value=\"1\">\r\n <input type=\"submit\" value=\"确定\" class=\"BigButton\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='folder.php?FILE_SORT=";
echo $FILE_SORT;
echo "&SORT_ID=";
echo $SORT_ID;
echo "&PAGE_START=";
echo $PAGE_START;
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 + -