⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 global_search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
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>
function delete_comment(CONTENT_ID)
{
  msg="确定要删除该文件吗?";
  if(window.confirm(msg))
  {
    URL="delete.php?BOARD_ID=<?=$BOARD_ID?>&CONTENT_ID=" + CONTENT_ID;
    window.location=URL;
  }
}
</script>
</head>

<body class="bodycolor" topmargin="0">

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/folder_search.gif" align="absmiddle"><b><span class="Big1"> 全局搜索结果</span></b><br>
    </td>
  </tr>
</table>

<?
  //-------查询文件-------
  $query = "SELECT * from FILE_CONTENT where 1";

  if($SUBJECT!="")
     $query.= " and SUBJECT like '%$SUBJECT%'";

  if($CONTENT_NO!="")
     $query.= " and CONTENT_NO like '%$CONTENT_NO%'";
     
  if($ATTACHMENT_DESC!="")
     $query.= " and ATTACHMENT_DESC like '%$ATTACHMENT_DESC%'";

  if($KEY1!="")
     $query.= " and CONTENT like '%$KEY1%'";

  if($KEY2!="")
     $query.= " and CONTENT like '%$KEY2%'";

  if($KEY3!="")
     $query.= " and CONTENT like '%$KEY3%'";

  if($ATTACHMENT_NAME!="")
     $query.= " and ATTACHMENT_NAME like '%$ATTACHMENT_NAME%'";

  $query.= " order by CONTENT_NO,SEND_TIME desc";
  $cursor = exequery($connection,$query);
  //echo $query;

  $CONTENT_COUNT = 0;
  while($ROW=mysql_fetch_array($cursor))
  {
    $CONTENT_ID = $ROW["CONTENT_ID"];
    $SORT_ID = $ROW["SORT_ID"];
    $SUBJECT = $ROW["SUBJECT"];
    $SEND_TIME = $ROW["SEND_TIME"];
    $ATTACHMENT_ID = $ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME = $ROW["ATTACHMENT_NAME"];
    $ATTACHMENT_DESC = $ROW["ATTACHMENT_DESC"];
    $USER_ID = $ROW["USER_ID"];

    if($ATTACHMENT_DATA!="" && $ATTACHMENT_NAME=="")
       continue;
    if($ATTACHMENT_DATA!="" && $ATTACHMENT_NAME!="")
    {
       $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
       $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

       $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
       $value==0;
       for($I=0;$I<$ARRAY_COUNT;$I++)
       {
          $FILE_PATH=$ATTACH_PATH.$ATTACHMENT_ID_ARRAY[$I]."/".$ATTACHMENT_NAME_ARRAY[$I];
          if(!file_exists($FILE_PATH))
             break;
          $msg="";
          if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")&&$SEARCH_DOC=="on")
          {
             $msg=doc2txt($FILE_PATH);
             $msg = preg_replace("/<style>.+<\/style>/is", "", $msg);
          }
          else if(stristr($ATTACHMENT_NAME_ARRAY[$I],".htm")||stristr($ATTACHMENT_NAME_ARRAY[$I],".html"))
          {
             $msg=file_get_contents($FILE_PATH);
             $msg=strip_tags($msg);
          }
          else if(stristr($ATTACHMENT_NAME_ARRAY[$I],".txt"))
          {
             $msg=file_get_contents($FILE_PATH);
          }

          $msg = str_replace(" ", "", $msg);
          $msg = preg_replace("/<[^>]+>/", "", $msg);
          $value = preg_match("/.*$ATTACHMENT_DATA.*/i", $msg);
          if($value)
             break;
       }
       if($value==0)
          continue;
    }

    $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);

//---------- 文件夹属性查阅 ----------------------
 $TREE_PATH="";
 $query1 = "SELECT * from FILE_SORT where SORT_ID='$SORT_ID'";
 $cursor1 = exequery($connection,$query1);
 if($ROW=mysql_fetch_array($cursor1))
 {
    $SORT_TYPE=sort_attrib($SORT_ID,"SORT_TYPE");
    $DEPT_ID=sort_attrib($SORT_ID,"DEPT_ID");
    $TREE_PATH=full_path($SORT_ID);
    $USER_ID=$ROW["USER_ID"];

    if($SORT_TYPE!="4")
    {
      $NEW_USER=$ROW["NEW_USER"];
      $MANAGE_USER=$ROW["MANAGE_USER"];
      $DOWN_USER=$ROW["DOWN_USER"];

      if($USER_ID=="")
         $USER_ID=access_priv($SORT_ID);
      if($MANAGE_USER=="")
         $MANAGE_USER=sort_priv($SORT_ID,"MANAGE_USER");
      if($DOWN_USER=="")
         $DOWN_USER=sort_priv($SORT_ID,"DOWN_USER");
      if($NEW_USER=="")
         $NEW_USER=sort_priv($SORT_ID,"NEW_USER");
      $MANAGE_USER=check_id($USER_ID,$MANAGE_USER,true);
      $DOWN_USER=check_id($USER_ID,$DOWN_USER,true);
      $NEW_USER=check_id($USER_ID,$NEW_USER,true);
      
      $NEW_PRIV=0;
      $MANAGE_PRIV=0;
      $DOWN_PRIV=0;

      if(find_id($NEW_USER,$LOGIN_USER_ID))
         $NEW_PRIV=1;

      if(find_id($MANAGE_USER,$LOGIN_USER_ID))
         $MANAGE_PRIV=1;

      if(find_id($DOWN_USER,$LOGIN_USER_ID))
         $DOWN_PRIV=1;
    }
    else
    {
      $NEW_PRIV=1;
      $MANAGE_PRIV=1;
      $DOWN_PRIV=1;
    }

 }
 else
    continue;

 if($SORT_ID==0)
 {
 	   $SORT_TYPE=4;
 	   $NEW_PRIV=1;
     $MANAGE_PRIV=1;
     $DOWN_PRIV=1;
 }

 //-- 判断是否符合当前文件柜分类（个人/公共）--
 if(($FILE_SORT==2 && $SORT_TYPE!=4)||($FILE_SORT==1 && $SORT_TYPE==4))
    continue;

 if($SORT_TYPE==2 && $DEPT_ID!=$LOGIN_DEPT_ID)
    continue;

 if($SORT_TYPE==3 && !find_id($USER_ID,$LOGIN_USER_ID))
    continue;

 if($SORT_TYPE==4 && $USER_ID!=$LOGIN_USER_ID)
    continue;

 $CONTENT_COUNT++;

//-----------------------------------------------
    if($CONTENT_COUNT==1)
    {
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">文件夹</td>
      <td nowrap align="center">文件名称</td>
      <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>
      <td nowrap align="center">操作</td>
  </tr>

<?
    }

    if($CONTENT_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td align="center"><?=$TREE_PATH?></td>
      <td align="center"><a href="read.php?SORT_ID=<?=$SORT_ID?>&CONTENT_ID=<?=$CONTENT_ID?>&PAGE_START=<?=$PAGE_START?>"><?=$SUBJECT?></a></td>
      <td align="left">
      <?
      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]=="")
               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','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
             if($MANAGE_PRIV==1)
             {
?>
	       <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;
<?
           }
?>
       (<?=$ATTACH_SIZE?>字节)<br>
<?
      }
    }
      ?>
      </td>
      <td align="center"><?=$ATTACHMENT_DESC?></td>
      <td align="center"width="150" nowrap><?=$SEND_TIME?></td>
      <td align="center" width="80" nowrap>
<?
      if($MANAGE_PRIV==1)
      {
?>
          <a href="edit.php?FILE_SORT=<?=$FILE_SORT?>&SORT_ID=<?=$SORT_ID?>&CONTENT_ID=<?=$CONTENT_ID?>&PAGE_START=<?=$PAGE_START?>">编辑</a>&nbsp;
          <a href="javascript:delete_content(<?=$CONTENT_ID?>,<?=$SORT_ID?>);"> 删除</a>
<?
      }
?>    &nbsp;
      </td>
  </tr>
<?
 }

 if($CONTENT_COUNT>0)
 {
?>
  </table>
<?
 }
 else
    Message("","<br>未找到符合条件的文件");

?>

<br>
<div align="center">
  <input type="button" value="返回" class="BigButton" onclick="location='global_query.php?FILE_SORT=<?=$FILE_SORT?>'">
</div>

<script>
function delete_content(CONTENT_ID,SORT_ID)
{
  msg="确定要删除该文件吗？这将不可恢复！";
  if(window.confirm(msg))
  {
    URL="delete.php?FILE_SORT=<?=$FILE_SORT?>&SORT_ID=" + SORT_ID +"&PAGE_START=<?=$PAGE_START?>&CONTENT_ID=" + CONTENT_ID;
    window.location=URL;
  }
}
</script>
</body>
</html>

⌨️ 快捷键说明

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