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

📄 all.php

📁 通达OA的PDA部分源代码
💻 PHP
字号:
🔍 
<?

  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  echo '
<html>
<head>
<title>短信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

';
  echo '<script Language=JavaScript>
window.setTimeout(\'this.location.reload();\',80000);
</script>

</head>

<body>

';
  $query = '' . 'SELECT count(*) from SMS where TO_ID=\'' . $LOGIN_USER_ID . '\' and SEND_TIME<=\'' . $CUR_TIME . '\'';
  $cursor = exequery ($connection, $query);
  $SMS_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SMS_COUNT = $ROW[0];
  }

  if ($SMS_COUNT == 0)
  {
			echo '无已接收的短信息';
  }
  else
  {
    $PER_PAGE = 10;
    $PAGES = 1;
    $PAGE_COUNT = ceil ($SMS_COUNT / $PER_PAGE);
    if (($CUR_PAGE <= 0 OR $CUR_PAGE == ''))
    {
      $CUR_PAGE = 1;
    }

    if ($PAGE_COUNT < $CUR_PAGE)
    {
      $CUR_PAGE = $PAGE_COUNT;
    }

    echo '已接收的短信息
    共';
    echo $SMS_COUNT;
    echo '条短信息
       <a href="all.php?P='.$P.'&CUR_PAGE=1">首页</a>&nbsp;
';


    if (1 <= $CUR_PAGE - 1)
    {
      echo '       <a  href="all.php?P='.$P.'&CUR_PAGE=';
      echo $CUR_PAGE - 1;
      echo '">上一页</a>&nbsp;
';
    }
    else
    {
      echo '       上一页&nbsp;
';
    }

    if ($CUR_PAGE + 1 <= $PAGE_COUNT)
    {
      echo '       <a  href="all.php?P='.$P.'&CUR_PAGE=';
      echo $CUR_PAGE + 1;
      echo '">下一页</a>&nbsp;
';
    }
    else
    {
      echo '       下一页&nbsp;
';
    }
    echo '<a href="all.php?P='.$P.'&CUR_PAGE=';
    echo $PAGE_COUNT;
    echo '">末页</a>&nbsp;&nbsp;';
    echo '<br><hr>

';
    $query = '' . 'SELECT * from SMS where TO_ID=\'' . $LOGIN_USER_ID . '\' and SEND_TIME<=\'' . $CUR_TIME . '\' order by SEND_TIME desc';
    $cursor = exequery ($connection, $query);
    $SMS_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$SMS_COUNT;
      if ($SMS_COUNT < $CUR_PAGE * $PER_PAGE - $PER_PAGE + 1)
      {
        continue;
      }
      else
      {
        if ($CUR_PAGE * $PER_PAGE < $SMS_COUNT)
        {
          break;
        }

        $SMS_ID = $ROW['SMS_ID'];
        $FROM_ID = $ROW['FROM_ID'];
        $SEND_TIME = $ROW['SEND_TIME'];
        $SMS_TYPE = $ROW['SMS_TYPE'];
        $CONTENT = $ROW['CONTENT'];
        $CONTENT = htmlspecialchars ($CONTENT);
        $REMIND_FLAG = $ROW['REMIND_FLAG'];

        $query1 = '' . 'SELECT * from USER where USER_ID=\'' . $FROM_ID . '\'';
        $cursor1 = exequery ($connection, $query1);
        if ($ROW = mysql_fetch_array ($cursor1))
        {
          $FROM_NAME = $ROW['USER_NAME'];
          $AVATAR = $ROW['AVATAR'];
        }
        else
        {
          $FROM_NAME = $FROM_ID;
          $AVATAR = '';
        }
echo $SMS_COUNT." ";
        echo $FROM_NAME.":";
        echo $SEND_TIME.";";
        echo $CONTENT;
    echo '<a href="edit.php?P=';
    echo $P;
    echo '&TO_NAME=';
    echo $FROM_NAME;
    echo '"> 回复</a>&nbsp;        
        <hr>';
      }
    }
  }

  echo '
<a href="../main.php?P=';
  echo $P;
  echo '">返回</a>
</body>
</html>
';
?>

⌨️ 快捷键说明

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