query.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 121 行

PHP
121
字号
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>查询文件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function CheckForm()
{
   if(document.form1.SUBJECT.value=="" && document.form1.CONTENT_NO.value=="" && document.form1.KEY1.value=="" && document.form1.KEY2.value=="" && document.form1.KEY3.value=="" && document.form1.ATTACHMENT_DESC.value=="" && document.form1.ATTACHMENT_NAME.value=="" && document.form1.ATTACHMENT_DATA.value=="")
   { alert("请指定至少一个查询条件!");
     return (fa';
  echo 'lse);
   }
   return true;
}
</script>
</head>
<body class="bodycolor" topmargin="0" onload="document.form1.SUBJECT.focus();">
';
  $query = (((''.'SELECT SORT_NAME,USER_ID 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'];
    $USER_ARRAY = explode ('|', $USER_ID);
    if (((((($USER_ID != $LOGIN_USER_ID) AND ($USER_ARRAY[0] != 'ALL_DEPT')) AND !find_id ($USER_ARRAY[0], $LOGIN_DEPT_ID)) AND !find_id ($USER_ARRAY[1], $LOGIN_USER_PRIV)) AND !find_id ($USER_ARRAY[2], $LOGIN_USER_ID)))
    {
      exit ();
    }
    $SORT_NAME = htmlspecialchars ($SORT_NAME);
  }
  else
  {
    $SORT_NAME = '根目录';
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/folder_search.gif" align="absmiddle"><b>';
  echo '<s';
  echo 'pan class="Big1"> ';
  echo $SORT_NAME;
  echo '- 查询文件</span></b><br>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center">
<form action="search.php" name="form1" onsubmit="return CheckForm();">
  <tr class="TableData">
      <td nowrap align="center">标题包含文字:</td>
      <td nowrap><input type="text" name="SUBJECT" class="BigInput" size="20"></td>
 ';
  echo ' </tr>
  <tr class="TableData">
      <td nowrap align="center">排序号:</td>
      <td nowrap><input type="text" name="CONTENT_NO" class="BigInput" size="10"></td>
  </tr>
  <tr>
    <td nowrap class="TableData" align="center">内容[关键词1]:</td>
    <td class="TableData"><input type="text" name="KEY1" class="BigInput" size="20"></td>
  </tr>
  <tr>
    <td nowrap class="TableData" align="center">内容[';
  echo '关键词2]:</td>
    <td class="TableData"><input type="text" name="KEY2" class="BigInput" size="20"></td>
  </tr>
  <tr>
    <td nowrap class="TableData" align="center">内容[关键词3]:</td>
    <td class="TableData"><input type="text" name="KEY3" class="BigInput" size="20"></td>
  </tr>
  <tr class="TableData">
      <td nowrap align="center">附件说明包含文字:</td>
      <td nowrap><input type="text" nam';
  echo 'e="ATTACHMENT_DESC" class="BigInput" size="20"></td>
  </tr>
  <tr class="TableData">
      <td nowrap align="center">附件文件名包含文字:</td>
      <td nowrap><input type="text" name="ATTACHMENT_NAME" class="BigInput" size="20"></td>
  </tr>
  <tr class="TableData">
      <td nowrap align="center">附件内容包含文字:</td>
      <td nowrap><input type="text" name="ATTACHMENT_DATA" class="BigInput" size=';
  echo '"20"></td>
  </tr>
';
  if ((strtolower (substr (PHP_OS, 0, 3)) == 'win'))
  {
    echo '  <tr class="TableData">
      <td nowrap align="center">搜索Word(doc)文档:</td>
      <td nowrap><input type="checkbox" name="SEARCH_DOC" id="SEARCH_DOC">&nbsp;&nbsp;<label for="SEARCH_DOC">可能会导致搜索速度很慢!</label></td>
  </tr>
';
  }
  echo '  <tr >
      <td nowrap class="TableControl" colspan="2" align="center">
          <input type="hidden" name="SORT_ID" value="';
  echo $SORT_ID;
  echo '">
          <input type="hidden" name="FILE_SORT" value="';
  echo $FILE_SORT;
  echo '">
          <input type="submit" value="查询" class="BigButton" title="进行文件查询">&nbsp;&nbsp;
          <input type="button" value="返回" class="BigButton" onclick="location=\'folder.php?FILE_SORT=';
  echo $FILE_SORT;
  echo '&SORT_ID=';
  echo $SORT_ID;
  echo '\'">
      </td>
  </tr>
</table>
</form>
</body>
</html>';
?>

⌨️ 快捷键说明

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