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

📄 read.php

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

  include_once '../auth.php';
  include_once 'inc/utility_all.php';
?>
<html>
<head>
<title>读邮件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>

<?
 $IMAGE_COUNT=0;
 $IMG_TYPE_STR="gif,jpg,png,tiff,bmp,iff,jp2,jpx,jb2,jpc,xbm,wbmp,";
 
 $query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL_ID='$EMAIL_ID' and EMAIL.BODY_ID=EMAIL_BODY.BODY_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $FROM_ID=$ROW["FROM_ID"];
    $TO_ID=$ROW["TO_ID"];
    $TO_ID2=$ROW["TO_ID2"];
    $COPY_TO_ID=$ROW["COPY_TO_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $IMPORTANT=$ROW["IMPORTANT"];
    $CONTENT=$ROW["CONTENT"];
    $SEND_TIME=$ROW["SEND_TIME"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
    $READ_FLAG=$ROW["READ_FLAG"];
    $SIZE=$ROW["SIZE"];

    if($IMPORTANT=='0' || $IMPORTANT=="")
       $IMPORTANT_DESC="";
    else if($IMPORTANT=='1')
       $IMPORTANT_DESC="<font color=\"#FF6600\">重要</font>";
    else if($IMPORTANT=='2')
       $IMPORTANT_DESC="<font color=\"#FF0000\">非常重要</font>";

    $SUBJECT=htmlspecialchars($SUBJECT);

    $query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $DEPT_ID=$ROW["DEPT_ID"];
       $DEPT_NAME=dept_long_name($DEPT_ID);
       $FROM_NAME="<u title=\"部门：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW["USER_NAME"]."</u>";
    }

    $TO_ARRAY=array();
    $query1 = "SELECT * from USER where find_in_set(USER_ID,'$TO_ID2')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
    {
       $USER_ID=$ROW["USER_ID"];
       $TO_ARRAY[$USER_ID]["DEPT_NAME"]=dept_long_name($ROW["DEPT_ID"]);
       $TO_ARRAY[$USER_ID]["USER_NAME"]=$ROW["USER_NAME"];
    }
    
    $TOK=strtok($TO_ID2,",");
    while($TOK!="")
    {
       $TO_NAME_TITLE.=$TO_ARRAY[$TOK]["USER_NAME"].",";
       if(strlen($TO_NAME_TITLE)<80)
          $TO_NAME.="<u title=\"部门：".$TO_ARRAY[$TOK]["DEPT_NAME"]."\" style=\"cursor:hand\">".$TO_ARRAY[$TOK]["USER_NAME"]."</u>,";
       else
          $TO_NAME_LONG=1;
       $TOK=strtok(",");
    }

    $COPY_TO_ARRAY=array();
    $query1 = "SELECT * from USER where find_in_set(USER_ID,'$COPY_TO_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
    {
       $USER_ID=$ROW["USER_ID"];
       $COPY_TO_ARRAY[$USER_ID]["DEPT_NAME"]=dept_long_name($ROW["DEPT_ID"]);
       $COPY_TO_ARRAY[$USER_ID]["USER_NAME"]=$ROW["USER_NAME"];
    }
    
    $TOK=strtok($COPY_TO_ID,",");
    while($TOK!="")
    {
       $TO_NAME_TITLE.=$COPY_TO_ARRAY[$TOK]["USER_NAME"].",";
       if(strlen($COPY_TO_NAME_TITLE)<80)
          $COPY_TO_NAME.="<u title=\"部门：".$COPY_TO_ARRAY[$TOK]["DEPT_NAME"]."\" style=\"cursor:hand\">".$COPY_TO_ARRAY[$TOK]["USER_NAME"]."</u>,";
       else
          $COPY_TO_NAME_LONG=1;
       $TOK=strtok(",");
    }
 }

 if(substr($TO_NAME,-1)==",")
    $TO_NAME=substr($TO_NAME,0,-1);
 if(substr($COPY_TO_NAME,-1)==",")
    $COPY_TO_NAME=substr($COPY_TO_NAME,0,-1);

 if($TO_ID!=$LOGIN_USER_ID)
    exit;
?>

<?=$SUBJECT?> <?=$IMPORTANT_DESC?>
      <br><b>发件人：</b><?=$FROM_NAME?>
      <b>发送于：</b><?=$SEND_TIME?>
      <br>
<b>内容：</b><br>
<?=$CONTENT?>
<br> <b>附　件：</b>
<?
      if($ATTACHMENT_NAME=="")
         echo "无";
      else
      {
         $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
         $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
         echo "<br>";
         $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
         for($I=0;$I<$ARRAY_COUNT-1;$I++)
         {
         	  $EXT_NAME=strtolower(substr(strrchr($ATTACHMENT_NAME_ARRAY[$I],"."),1));
            if(find_id($IMG_TYPE_STR,$EXT_NAME))
               $IMAGE_COUNT++;
               
         	  $ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
            $ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
           <a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
           (<?=$ATTACH_SIZE?>字节)<br>
<?         }//for
      }//else
?>

<?
if($IMAGE_COUNT>0)
{
?>
    <tr>
      <td class="TableData">
        <img src="/images/image.gif" align="absmiddle" border="0">&nbsp;附件图片: <br><br>

<?
   for($I=0;$I<$ARRAY_COUNT;$I++)
   {
      if($ATTACHMENT_ID_ARRAY[$I]=="")
         continue;

      $EXT_NAME=substr(strrchr($ATTACHMENT_NAME_ARRAY[$I],"."),1);
      $EXT_NAME=strtolower($EXT_NAME);
      if(find_id($IMG_TYPE_STR,$EXT_NAME))
      {
         $IMAGE_COUNT1++;
?>
                <a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME_ARRAY[$I]?>" target="_blank"><img src="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME_ARRAY[$I]?>" border="0"  width="100" height="100" alt="文件名：<?=$ATTACHMENT_NAME_ARRAY[$I]?>"></a>　
<?
      }
   }
?>
<?
}
?>

<br>

<?
if($READ_FLAG=="0")
{
 $query = "update EMAIL set READ_FLAG='1' where EMAIL_ID=$EMAIL_ID";
 exequery($connection,$query);
}
?>
<?
  echo '<a href="../email/?P=';
  echo $P;
  echo '">返回</a>';
  
?>
</body>
</html>

⌨️ 快捷键说明

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