del_res.php

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

PHP

110 行

<?
  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">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date_time ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '起始时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
    $REMARK = ((('删除'.$BEGIN_DATE).' - ').$CUR_TIME);
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date_time ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '截止时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
    $REMARK = (('删除'.$END_DATE).'之前');
  }
  if ((($BEGIN_DATE != '') AND ($END_DATE != '')))
  {
    $REMARK = ((('删除'.$BEGIN_DATE).' - ').$END_DATE);
  }
  if (((($END_DATE != '') AND ($BEGIN_DATE != '')) AND ($END_DATE < $BEGIN_DATE)))
  {
    message ('错误', '截止时间不能晚于起始时间!');
    button_back ();
    exit ();
  }
  if (($BEGIN_DATE != ''))
  {
    ($query1 .= (((''.'SEND_TIME>=\'').$BEGIN_DATE).'\' and '));
  }
  if (($END_DATE != ''))
  {
    ($query1 .= (((''.'SEND_TIME<=\'').$END_DATE).'\' and '));
  }
  $query1 = substr ($query1, 0, -5);
  if (($SMS == 'on'))
  {
    $query = ('delete from SMS where '.$query1);
    exequery ($connection, $query);
    ($REMARK .= '的所有内部短信');
  }
  if ((($EMAIL == 'on') OR ($EMAIL_INBOX == 'on')))
  {
    $query = ('select * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and '.$query1);
    if (($EMAIL_INBOX == 'on'))
    {
      ($query .= ' and BOX_ID=\'0\' and SEND_FLAG=\'1\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\' or DELETE_FLAG=\'2\')');
    }
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $EMAIL_ID = $ROW['EMAIL_ID'];
      $BODY_ID = $ROW['BODY_ID'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      if (($ATTACHMENT_ID != ''))
      {
        delete_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME);
      }
      ($EMAIL_ID_STR .= ($EMAIL_ID.','));
      ($BODY_ID_STR .= ($BODY_ID.','));
    }
    $query = (((''.'delete from EMAIL where find_in_set(EMAIL_ID,\'').$EMAIL_ID_STR).'\')');
    exequery ($connection, $query);
    $query = (((''.'delete from EMAIL_BODY where find_in_set(BODY_ID,\'').$BODY_ID_STR).'\')');
    exequery ($connection, $query);
    if (($SMS == 'on'))
    {
      ($REMARK .= '和所有内部邮件');
    }
    else
    {
      if (($EMAIL == 'on'))
      {
        ($REMARK .= '的所有内部邮件');
      }
      else
      {
        ($REMARK .= '的所有内部邮件收件箱邮件');
      }
    }
  }
  add_log (12, $REMARK, $LOGIN_USER_ID);
  message ('提示', '操作已完成!');
  button_back ();
  echo '
</body>
</html>
';
?>

del_res.php - 源码说明

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

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

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?