search.php

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

PHP
318 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  include_once 'inc/check_type.php';
  include_once 'inc/ip2add.php';
  echo '
<html>
<head>
<title>系统日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_';
  echo 'select").checked=false;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0)
  {
    ';
  echo '  el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除日志，请至少选择其中一条。");
     return;
  }
  msg=\'确认要删除所选日志么？\';
  if(window.confirm(msg))
  {
    url="delete.php?LOG_ID="+ delete_str;
    location=url;
  }
}
</script>
</head>
<body class="bodyc';
  echo 'olor" topmargin="5">
';
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date_time ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '起始时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date_time ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '截止时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (($BEGIN_DATE == ''))
  {
    $query = (((''.'SELECT * from SYS_LOG where TIME<=\'').$END_DATE).'\'');
  }
  else
  {
    if (($END_DATE == ''))
    {
      $query = (((''.'SELECT * from SYS_LOG where TIME>=\'').$BEGIN_DATE).'\'');
    }
    else
    {
      $query = (((((''.'SELECT * from SYS_LOG where TIME>=\'').$BEGIN_DATE).'\' and TIME<=\'').$END_DATE).'\'');
    }
  }
  if (($TYPE != ''))
  {
    ($query .= (((''.' and TYPE=\'').$TYPE).'\''));
  }
  if (($IP != ''))
  {
    ($query .= (((''.' and IP=\'').$IP).'\''));
  }
  if (($OPERATION == '1'))
  {
    $query = ('delete'.substr ($query, 8));
    if (($TO_ID != ''))
    {
      ($query .= (((''.' and FIND_IN_SET(USER_ID,\'').$TO_ID).'\')'));
    }
    exequery ($connection, $query);
    $AFFACT_ROWS = mysql_affected_rows ();
    echo '<br><br>';
    message ('', (((''.'共删除 ').$AFFACT_ROWS).' 条日志记录'));
    button_back ();
    exit ();
  }
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/system.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 查询结果 （最多显示300条记录）</span>
    </td>
  </tr>
</table>
<br>
';
  if (($TO_ID == ''))
  {
    ($query .= ' order by TIME desc');
    $cursor = exequery ($connection, $query);
    $LOG_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$LOG_COUNT;
      if ((300 < $LOG_COUNT))
      {
        break;
      }
      $LOG_ID = $ROW['LOG_ID'];
      $USER_ID = $ROW['USER_ID'];
      $TIME = $ROW['TIME'];
      $IP = $ROW['IP'];
      $IP_ADD = convertip ($IP);
      $TYPE = $ROW['TYPE'];
      $REMARK = $ROW['REMARK'];
      $USER_ID = addslashes ($USER_ID);
      $USER_NAME = '';
      $query1 = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $USER_NAME = $ROW1['USER_NAME'];
      }
      $TYPE_DESC = get_code_name ($TYPE, 'SYS_LOG');
      if (($LOG_COUNT == 1))
      {
        echo '           <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
';
      }
      if ((($LOG_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '           <tr class="';
      echo $TableLine;
      echo '">
             <td>&nbsp;<input type="checkbox" name="email_select" value="';
      echo $LOG_ID;
      echo '" onClick="check_one(self);"></td>
             <td nowrap align="center">';
      echo $USER_NAME;
      echo '</td>
             <td nowrap align="center">';
      echo $TIME;
      echo '</td>
             <td nowrap align="center">';
      echo $IP;
      echo '</td>
             <td nowrap align="center">';
      echo $IP_ADD;
      echo '</td>
             <td nowrap align="center">';
      echo $TYPE_DESC;
      echo '</td>
             <td align="left">';
      echo $REMARK;
      echo '</td>
           </tr>
';
    }
  }
  else
  {
    $USER_ID_ARRAY = explode (',', $TO_ID);
    $USER_ID_ARRAY_NUM = (sizeof ($USER_ID_ARRAY) - 1);
    $LOG_COUNT = 0;
    for ($I = 0; ($I < $USER_ID_ARRAY_NUM); ++$I)
    {
      ($query1 .= ($query.(((''.' and USER_ID=\'').$USER_ID_ARRAY[$I]).'\' order by TIME desc')));
      $cursor = exequery ($connection, $query1);
      while ($ROW = mysql_fetch_array ($cursor))
      {
        ++$LOG_COUNT;
        if ((300 < $LOG_COUNT))
        {
          break;
        }
        $LOG_ID = $ROW['LOG_ID'];
        $USER_ID = $ROW['USER_ID'];
        $TIME = $ROW['TIME'];
        $IP = $ROW['IP'];
        $IP_ADD = convertip ($IP);
        $TYPE = $ROW['TYPE'];
        $REMARK = $ROW['REMARK'];
        $USER_ID = addslashes ($USER_ID);
        $USER_NAME = '';
        $query2 = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
        $cursor2 = exequery ($connection, $query2);
        if ($ROW2 = mysql_fetch_array ($cursor2))
        {
          $USER_NAME = $ROW2['USER_NAME'];
        }
        $TYPE_DESC = get_code_name ($TYPE, 'SYS_LOG');
        if (($LOG_COUNT == 1))
        {
          echo '
           <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
';
        }
        if ((($LOG_COUNT % 2) == 1))
        {
          $TableLine = 'TableLine1';
        }
        else
        {
          $TableLine = 'TableLine2';
        }
        echo '           <tr class="';
        echo $TableLine;
        echo '">
             <td>&nbsp;<input type="checkbox" name="email_select" value="';
        echo $LOG_ID;
        echo '" onClick="check_one(self);"></td>
             <td nowrap align="center">';
        echo $USER_NAME;
        echo '</td>
             <td nowrap align="center">';
        echo $TIME;
        echo '</td>
             <td nowrap align="center">';
        echo $IP;
        echo '</td>
             <td nowrap align="center">';
        echo $IP_ADD;
        echo '</td>
             <td nowrap align="center">';
        echo $TYPE_DESC;
        echo '</td>
             <td nowrap align="center">';
        echo $REMARK;
        echo '</td>
           </tr>
';
      }
      $query1 = '';
    }
  }
  if (($LOG_COUNT == 0))
  {
    message ('', '无符合条件的日志记录');
    button_back ();
    exit ();
  }
  else
  {
    echo '   <thead 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>
      <td nowrap align="center">IP地址</td>
      <td nowrap align="center">IP所在地</td>
      <td nowrap align="center">日志类型</td>
      <td nowrap align="center">备注</td>
  ';
    echo ' </thead>
   <tfoot class="TableControl">
     <td colspan="8">&nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
         <label for="allbox_for">全选</label> &nbsp;
         <input type="button"  value="删除" class="SmallButton" onClick="delete_mail();" title="删除所选日志"> &nbsp;
     </td>
   </tfoot>
</table>
';
    button_back ();
  }
  echo '</body>
</html>
';
?>

search.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 search.php 源码文件，采用 PHP 编程语言编写，共 318 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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