delete.php

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

PHP
97 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date_time ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '起始时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date_time ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '截止时间格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (((($END_DATE != '') AND ($BEGIN_DATE != '')) AND ($END_DATE < $BEGIN_DATE)))
  {
    message ('错误', '截止时间不能晚于起始时间!');
    button_back ();
    exit ();
  }
  if (($DUTY == 'on'))
  {
    $query = 'delete from ATTEND_DUTY where 1=1';
    if (($BEGIN_DATE != ''))
    {
      ($query .= (((''.' and REGISTER_TIME>=\'').$BEGIN_DATE).'\''));
    }
    if (($END_DATE != ''))
    {
      ($query .= (((''.' and REGISTER_TIME<=\'').$END_DATE).'\''));
    }
    exequery ($connection, $query);
  }
  if (($OUT == 'on'))
  {
    $query = 'delete from ATTEND_OUT where 1=1';
    if (($BEGIN_DATE != ''))
    {
      ($query .= (((''.' and SUBMIT_TIME>=\'').$BEGIN_DATE).'\''));
    }
    if (($END_DATE != ''))
    {
      ($query .= (((''.' and SUBMIT_TIME<=\'').$END_DATE).'\''));
    }
    exequery ($connection, $query);
  }
  if (($LEAVE == 'on'))
  {
    $query = 'delete from ATTEND_LEAVE where 1=1';
    if (($BEGIN_DATE != ''))
    {
      ($query .= (((''.' and LEAVE_DATE1>=\'').$BEGIN_DATE).'\''));
    }
    if (($END_DATE != ''))
    {
      ($query .= (((''.' and LEAVE_DATE2<=\'').$END_DATE).'\''));
    }
    exequery ($connection, $query);
  }
  if (($EVECTION == 'on'))
  {
    $query = 'delete from ATTEND_EVECTION where 1=1';
    if (($BEGIN_DATE != ''))
    {
      ($query .= (((''.' and EVECTION_DATE1>=\'').$BEGIN_DATE).'\''));
    }
    if (($END_DATE != ''))
    {
      ($query .= (((''.' and EVECTION_DATE2<=\'').$END_DATE).'\''));
    }
    exequery ($connection, $query);
  }
  message ('提示', '记录已删除！');
  button_back ();
  echo '
</body>
</html>
';
?>

delete.php - 源码说明

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

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

⌨️ 快捷键说明

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