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

📄 index.php

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

  include_once '../auth.php';
  $CUR_DATE = date ('Y-m-d', time ());

 $query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
 $cursor= exequery($connection,$query);
 $NEW_LETER_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $NEW_LETER_COUNT=$ROW[0];
  if($NEW_LETER_COUNT==0){$ALL=1;	
  	}  
  echo '
<html>
<head>
<title>内部邮件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>
<body>
<font color=blue size=+2><b>';
echo $NEW_LETER_COUNT;
echo '封新邮件</b></font>
<br><br>


';

	$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='$BOX_ID' and READ_FLAG='0' and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') order by READ_FLAG,SEND_TIME desc";
 

  $cursor = exequery ($connection, $query);
  $EMAIL_COUNT = 0;
  
  
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$EMAIL_COUNT;
    if (20 < $EMAIL_COUNT)
    {
      break;
    }

    $EMAIL_ID = $ROW['EMAIL_ID'];
    $FROM_ID = $ROW['FROM_ID'];
    $SEND_TIME = $ROW['SEND_TIME'];
    $IMPORTANT = $ROW['IMPORTANT'];
    if (($IMPORTANT == '0' OR $IMPORTANT == ''))
    {
      $IMPORTANT_DESC = '';
    }
    else
    {
      if ($IMPORTANT == '1')
      {
        $IMPORTANT_DESC = '<font color=red>重要</font>';
      }
      else
      {
        if ($IMPORTANT == '2')
        {
          $IMPORTANT_DESC = '<font color=red>非常重要</font>';
        }
      }
    }

    $SUBJECT = $ROW['SUBJECT'];
    $query1 = '' . 'SELECT * from USER where USER_ID=\'' . $FROM_ID . '\'';
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_NAME = $ROW['USER_NAME'];
    }
    else
    {
      $FROM_NAME = $FROM_ID;
    }

    echo '
';
    echo $EMAIL_COUNT;
    echo '.';
    echo $FROM_NAME;
    echo '：';
    echo $SUBJECT;
    echo ' ';
    echo $IMPORTANT_DESC;
    echo '<br>
<i>';
    echo $SEND_TIME;
    echo '</i>
<a href="read.php?P=';
    echo $P;
    echo '&EMAIL_ID=';
    echo $EMAIL_ID;
    echo '"> 阅读</a>&nbsp;
<hr>
';
  }

  if ($EMAIL_COUNT == 0)
  {
    echo '无新邮件';
  }

  echo '
<a href="./all.php?P=';
  echo $P;
  echo '">全部邮件</a>';

  echo '
<a href="../main.php?P=';
  echo $P;
  echo '">返回</a>
<br>';
$CUR_TIME=date("Y-m-d H:i:s",time());
echo $CUR_TIME;
echo '
</body>
</html>
';
?>

⌨️ 快捷键说明

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