del_email.php

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

PHP
81 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  if ((($DELETE == 'del') OR ($DELETE == 'unread')))
  {
    if (($DELETE == 'del'))
    {
      $query = (((''.'select EMAIL_ID,EMAIL.BODY_ID,SUBJECT,TO_ID,FROM_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\'  and SEND_FLAG=\'1\' and DELETE_FLAG=\'1\'');
    }
    else
    {
      if (($DELETE == 'unread'))
      {
        $query = (((''.'select EMAIL_ID,EMAIL.BODY_ID,SUBJECT,TO_ID,FROM_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\'  and SEND_FLAG=\'1\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\') and READ_FLAG!=\'1\'');
      }
    }
    $cursor0 = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor0))
    {
      $EMAIL_ID = $ROW['EMAIL_ID'];
      $BODY_ID = $ROW['BODY_ID'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      $FROM_ID = $ROW['FROM_ID'];
      $TO_ID = $ROW['TO_ID'];
      $SUBJECT = $ROW['SUBJECT'];
      if (($DELETE == 'unread'))
      {
        $SMS_CONTENT = ('请查收我的邮件！
主题：'.csubstr ($SUBJECT, 0, 100));
        $query = (((((((''.'delete from SMS where SMS_TYPE=\'2\' and FROM_ID=\'').$LOGIN_USER_ID).'\' and TO_ID=\'').$TO_ID).'\' and CONTENT=\'').$SMS_CONTENT).'\'');
        exequery ($connection, $query);
      }
      $query1 = ((''.'select count(*) from EMAIL where BODY_ID=').$BODY_ID);
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $GROUP_COUNT = $ROW[0];
      }
      if (($GROUP_COUNT <= 1))
      {
        if (($ATTACHMENT_NAME != ''))
        {
          $ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
          $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
          $ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
          for ($I = 0; ($I < ($ARRAY_COUNT - 1)); ++$I)
          {
            delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
          }
        }
        ($BODY_ID_STR .= ($BODY_ID.','));
      }
      $query = ((''.'delete from EMAIL where EMAIL_ID=').$EMAIL_ID);
      exequery ($connection, $query);
    }
  }
  else
  {
    $query = (((''.'update EMAIL,EMAIL_BODY set DELETE_FLAG=\'2\' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and SEND_FLAG=\'1\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\') and READ_FLAG=\'1\'');
    exequery ($connection, $query);
    $query = (((''.'update EMAIL,EMAIL_BODY set DELETE_FLAG=\'4\' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and SEND_FLAG=\'1\' and DELETE_FLAG=\'3\' and READ_FLAG=\'1\'');
    exequery ($connection, $query);
  }
  $query = (((''.'delete from EMAIL_BODY where find_in_set(BODY_ID,\'').$BODY_ID_STR).'\')');
  exequery ($connection, $query);
  header (((''.'location: index.php?PAGE_START=').$PAGE_START));
  echo '
</body>
</html>
';
?>

del_email.php - 源码说明

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

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

⌨️ 快捷键说明

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