edit.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 427 行

PHP
427 行
字号 
<?
include_once("inc/auth.php");
include_once("inc/conn.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>编辑文件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language="JavaScript">
function CheckForm()
{
   if(document.form1.SUBJECT.value=="")
   { alert("文件名称不能为空！");
     return (false);
   }

   if (document.form1.ATTACHMENT&&document.form1.ATTACHMENT.value!="")
   {
     var file_temp=document.form1.ATTACHMENT.value,file_name;
     var Pos;
     Pos=file_temp.lastIndexOf("\\");
     file_name=file_temp.substring(Pos+1,file_temp.length);
     document.form1.ATTACHMENT_NAME.value=file_name;
   }

<?
if(!(stristr($HTTP_USER_AGENT,"Firefox")||stristr($HTTP_USER_AGENT,"Opera")))
{
?>
   document.form1.CONTENT.value=EDIT_HTML.GetHtml();
<?
}
?>

   return (true);
}

function upload_attach()
{
  if (document.form1.ATTACHMENT.value!="")
   {
     var file_temp=document.form1.ATTACHMENT.value,file_name;
     var Pos;
     Pos=file_temp.lastIndexOf("\\");
     file_name=file_temp.substring(Pos+1,file_temp.length);
     document.form1.ATTACHMENT_NAME.value=file_name;
   }
   else
   {
   	 alert("请选择要上传的文件！");
   	 return (false);
   }
   document.form1.OP.value=2;
   document.form1.CONTENT.value=EDIT_HTML.GetHtml();

   document.form1.submit();
}

function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="确定要删除文件 '"+ ATTACHMENT_NAME +"' 吗?";
  if(window.confirm(msg))
  {
    URL="delete_attach.php?FILE_SORT=<?=$FILE_SORT?>&SORT_ID=<?=$SORT_ID?>&CONTENT_ID=<?=$CONTENT_ID?>&PAGE_START?>=<?=$PAGE_START?>&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME;
    window.location=URL;
  }
}

function Load_Do()
{
<?
if(!(stristr($HTTP_USER_AGENT,"Firefox")||stristr($HTTP_USER_AGENT,"Opera")))
{
?>
   EDIT_HTML.SetHtml(document.form1.CONTENT.value);
<?
}
?>
}
</script>
</head>

<body class="bodycolor" topmargin="5" onload="Load_Do();">

<?
 //============================ 文件信息 =======================================
 $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"];
 }

 //--- 安全性 ---
 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;
 }

 $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)
                   exit;
                break;
       case "3":
                if(!find_id($USER_ID,$LOGIN_USER_ID))
                   exit;
                break;
       case "4":
                if($USER_ID!=$LOGIN_USER_ID)
                   exit;
                break;
    }
 }

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);
    for($I=0;$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);
    for($I=0;$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($SORT_SIZE>$FOLDER_CAPACITY*1024*1024)
      $CAPACITY_FLAG=1;
   else
      $CAPACITY_FLAG=0;
}
else
   $CAPACITY_FLAG=0;
}
else
   $CAPACITY_FLAG=0;
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><b><span class="Big1"> 编辑文件</span></b>
    </td>
  </tr>
</table>

 <table border="0" width="550" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="update.php"  method="post" name="form1" onsubmit="return CheckForm();">
    <tr>
      <td nowrap class="TableData"> 文件名称：</td>
      <td class="TableData">
        <input type="text" name="SUBJECT" size="50" maxlength="100" class="BigInput" value="<?=$SUBJECT?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 排序号：</td>
      <td class="TableData">
        <input type="text" name="CONTENT_NO" size="10" maxlength="20" class="BigInput" value="<?=$CONTENT_NO?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData" valign="top"> 文件内容：</td>
      <td class="TableData">
<?
if(stristr($HTTP_USER_AGENT,"Firefox")||stristr($HTTP_USER_AGENT,"Opera"))
{
?>
<textarea style="width:100%;height:200px" name="CONTENT"><?=$CONTENT?></textarea>
<?
}
else
{
?>
        <iframe name="EDIT_HTML" width="100%" height=260 src="/module/editor" viewastext type="text/x-scriptlet"></iframe>
        <input type="hidden" name="CONTENT"  value="<?=$CONTENT?>">
<?
}
?>
      </td>
    </tr>
    <tr class="TableContent">
      <td nowrap>附件文档：</td>
      <td nowrap>
<?
      if($ATTACHMENT_ID=="")
         echo "无附件";
      else
      {
         $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
         $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

         $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
         for($I=0;$I<$ARRAY_COUNT;$I++)
         {
            if($ATTACHMENT_ID_ARRAY[$I]=="")
               break;

            $ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
            $ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
           <img src="/images/email_atta.gif" align="absmiddle">
<?
           if($DOWN_PRIV==1||(!stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")&&!stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")&&!stristr($ATTACHMENT_NAME_ARRAY[$I],".xls")))
           {
?>
              <a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
<?
           }
           else
           {
?>
              <?=$ATTACHMENT_NAME_ARRAY[$I]?>
<?
           }
           if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
           {
?>
	       <input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5&PRINT=1','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
	       <input type="button" value="编辑" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=4','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
           }
           else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
           {
?>
	       <input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
           }
?>
	       <input type="button" value="删除" class="SmallButton" onClick="delete_attach('<?=$ATTACHMENT_ID_ARRAY[$I]?>','<?=$ATTACHMENT_NAME_ARRAY[$I]?>');">
<?
           echo "(".$ATTACH_SIZE."字节)<br>";
         }//for
      }//else
?>
      </td>
    </tr>
    <tr class="TableData">
      <td nowrap>附件上传：</td>
      <td nowrap>
<?
if($CAPACITY_FLAG==1)
{
        echo "个人文件柜容量超过限制($FOLDER_CAPACITY MB)，不能上传附件！";
}
else
{
?>
        <input type="file" name="ATTACHMENT" size="30" class="BigInput" title="选择附件文件">
        <input type="button" class="BigButton" value="上传附件" onclick="upload_attach();">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
<?
}
?>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 附件说明：</td>
      <td class="TableData">
        <input type="text" name="ATTACHMENT_DESC" size="30" maxlength="50" class="BigInput" value="<?=$ATTACHMENT_DESC?>">
      </td>
    </tr>
<?
if($FILE_SORT=="1")
{
?>
    <tr>
      <td nowrap class="TableData">提醒：</td>
      <td class="TableData">
        <input type="checkbox" name="SMS_REMIND" id="SMS_REMIND"><label for="SMS_REMIND">使用内部短信提醒用户</label>
<?
  $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)) //检查该模块是否允许手机提醒
  {
?>
        <input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND"><label for="SMS2_REMIND">使用手机短信提醒用户</label>
<?
  }
?>
      </td>
    </tr>
<?
}
?>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" value="<?=$CONTENT_ID?>" name="CONTENT_ID">
        <input type="hidden" name="FILE_SORT" value="<?=$FILE_SORT?>">
        <input type="hidden" value="<?=$SORT_ID?>" name="SORT_ID">
        <input type="hidden" value="<?=$PAGE_START?>" name="PAGE_START">
        <input type="hidden" name="ATTACHMENT_NAME" maxlength="100">
        <input type="hidden" name="OP" value="1">
        <input type="submit" value="确定" class="BigButton">&nbsp;&nbsp;
        <input type="button" value="返回" class="BigButton" onClick="location='folder.php?FILE_SORT=<?=$FILE_SORT?>&SORT_ID=<?=$SORT_ID?>&PAGE_START=<?=$PAGE_START?>'">
      </td>
    </tr>
  </table>
</form>

</body>
</html>

edit.php - 源码说明

本页面展示了「极限网络智能办公系统 Office Automation V3.0官方100％源代码.」中的 edit.php 源码文件，采用 PHP 编程语言编写，共 427 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Automation相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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