📄 share_folder.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

$PAGE_SIZE=10;
?>

<html>
<head>
<title>文件柜</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script Language="JavaScript">
function set_page()
{
 PAGE_START=(document.all("PAGE_NUM").value-1)*<?=$PAGE_SIZE?>+1;
 location="share_folder.php?SORT_ID=<?=$SORT_ID?>&PAGE_START="+PAGE_START;
}
</script>
<body class="bodycolor" topmargin="0">
<?
 function share_access_priv($SORT_ID)
 {
    if($SORT_ID==0)
       return false;
    
    global $LOGIN_USER_ID,$connection;
    $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"];
       $SHARE_USER=$ROW["SHARE_USER"];
    }
    
    if(find_id($SHARE_USER,$LOGIN_USER_ID))
       return true;
    else
       return share_access_priv($SORT_PARENT);
 }
 
 if(!share_access_priv($SORT_ID))
    exit;
 
 $query = "SELECT * from FILE_SORT where SORT_ID=$SORT_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $SORT_NAME=$ROW["SORT_NAME"];
    $USER_ID=$ROW["USER_ID"];
    
    $SORT_NAME=str_replace("&","&amp;",$SORT_NAME);
    $SORT_NAME=str_replace("<","&lt",$SORT_NAME);
    $SORT_NAME=str_replace(">","&gt",$SORT_NAME);
    $SORT_NAME=stripslashes($SORT_NAME);
 }

 //=============================== 查阅文件信息 ===================================
 $query = "SELECT count(*) from FILE_CONTENT where SORT_ID=$SORT_ID";
 $cursor= exequery($connection,$query);
 $FILE_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $FILE_COUNT=$ROW[0];

 if($FILE_COUNT==0)
 {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><b><span class="Big1"> <?=$SORT_NAME?> (共享文件柜)</span></b><br>
    </td>
  </tr>
</table>
<br>
<?
   Message("","该文件夹尚无文件");
   exit;
 }

 //============ 存在文章，开始计算分页 =================

 //--- 计算总页数 ---
 $PAGE_TOTAL=$FILE_COUNT/$PAGE_SIZE;
 $PAGE_TOTAL=ceil($PAGE_TOTAL);

 //--- 计算,末页 ---
 if($FILE_COUNT<=$PAGE_SIZE)
    $LAST_PAGE_START=1;
 else if($FILE_COUNT%$PAGE_SIZE==0)
    $LAST_PAGE_START=$FILE_COUNT-$PAGE_SIZE+1;
 else
    $LAST_PAGE_START=$FILE_COUNT-$FILE_COUNT%$PAGE_SIZE+1;

 //--- 智能分页 ---
 //-- 页首 --
 if($PAGE_START=="")
    $PAGE_START=1;

 if($PAGE_START>$FILE_COUNT)
    $PAGE_START=$LAST_PAGE_START;

 if($PAGE_START<1)
    $PAGE_START=1;

 //-- 页尾 --
 $PAGE_END=$PAGE_START+$PAGE_SIZE-1;

 if($PAGE_END>$FILE_COUNT)
    $PAGE_END=$FILE_COUNT;

 //--- 计算当前页 ---
 $PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><b><span class="Big1"> <?=$SORT_NAME?> (共享文件柜)</span></b><br>
    </td>
    <td valign="bottom">
    <span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>篇 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>篇)</span>
    </td>
    </tr>
</table>

<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">文件名称</td>
      <td nowrap align="center">附件</td>
      <td nowrap align="center">发布时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
  </tr>

<?
  $query = "SELECT * from FILE_CONTENT where SORT_ID=$SORT_ID order by CONTENT_NO,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($FILE_COUNT>$PAGE_END)
       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"];

    $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";
?>
    <tr class="<?=$TableLine?>">
      <td><a href="read.php?SORT_ID=<?=$SORT_ID?>&CONTENT_ID=<?=$CONTENT_ID?>&PAGE_START=<?=$PAGE_START?>"><?=$SUBJECT?></a></td>
      <td nowrap>
      <?
      if($ATTACHMENT_NAME=="")
         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]=="")
               continue;
      ?>
       <img src="/images/email_atta.gif" align="absmiddle">
       <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>
<?
            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');"><br>
<?
            }
           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;
<?
           }
        }
      }
?>
      </td>
      <td align="center"><?=$SEND_TIME?></td>
  </tr>

<?
  }
?>
  <tr class="TableControl">
   <td colspan="6" align="center">
     <input type="button"  value="首页" class="SmallButton"  <?if($PAGE_START==1)echo "disabled";?> onclick="location='share_folder.php?SORT_ID=<?=$SORT_ID?>'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='share_folder.php?SORT_ID=<?=$SORT_ID?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" <?if($PAGE_END>=$FILE_COUNT)echo "disabled";?> onclick="location='share_folder.php?SORT_ID=<?=$SORT_ID?>&PAGE_START=<?=($PAGE_END+1)?>'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  <?if($PAGE_END>=$FILE_COUNT)echo "disabled";?> onclick="location='share_folder.php?SORT_ID=<?=$SORT_ID?>&PAGE_START=<?=$LAST_PAGE_START?>'"> &nbsp;&nbsp;
     页数
     <input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;&nbsp;
   </td>
  </tr>
</table>

</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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