📄 search.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>接收短信查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_sms(SMS_ID)
{
 msg=\'确认要删除该手机短信么？\';
 if(window.confirm(msg))
 {
  URL="delete_sms.php?SMS_ID=" + SMS_ID;
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" 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 SMS2 where SEND_TIME<=\'').$END_DATE).'\'');
  }
  else
  {
    if (($END_DATE == ''))
    {
      $query = (((''.'SELECT * from SMS2 where SEND_TIME>=\'').$BEGIN_DATE).'\'');
    }
    else
    {
      $query = (((((''.'SELECT * from SMS2 where SEND_TIME>=\'').$BEGIN_DATE).'\' and SEND_TIME<=\'').$END_DATE).'\'');
    }
  }
  if (($TO_ID != ''))
  {
    $TO_ID = substr ($TO_ID, 0, (strlen ($TO_ID) - 1));
    $TO_ID = str_replace (',', '\',\'', $TO_ID);
    $TO_ID = (('\''.$TO_ID).'\'');
    ($query .= (((''.' and FROM_ID in(').$TO_ID).')'));
  }
  if (($CONTENT != ''))
  {
    ($query .= (((''.' and CONTENT like \'%').$CONTENT).'%\''));
  }
  ($query .= (((''.' and PHONE=\'').$PHONE).'\' and SEND_FLAG=\'1\''));
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/mobile_sms.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 接收短信查询结果 （最多显示500条记录）</span>
    </td>
  </tr>
</table>
';
  ($query .= ' order by SEND_TIME desc,SMS_ID desc');
  $cursor = exequery ($connection, $query);
  $SMS_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$SMS_COUNT;
    if ((500 < $SMS_COUNT))
    {
      break;
    }
    $FROM_ID = $ROW['FROM_ID'];
    $CONTENT = $ROW['CONTENT'];
    $SEND_TIME = $ROW['SEND_TIME'];
    $USER_NAME = '';
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$FROM_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $USER_NAME = $ROW['USER_NAME'];
    }
    if (($SMS_COUNT == 1))
    {
      echo '     <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>
';
    }
    if ((($SMS_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '      <td>';
    echo $CONTENT;
    echo '</td>
      <td nowrap align="center">';
    echo $SEND_TIME;
    echo '</td>
    </tr>
';
  }
  if (($SMS_COUNT == 0))
  {
    message ('', '无符合条件的手机短信记录');
  }
  else
  {
    echo '</table>';
    message ('', (((''.'共 ').$SMS_COUNT).' 条记录'));
  }
  button_back ();
  echo '
</body>
</html>
';
?>
⌨️ 快捷键说明

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