📄 delete.php
字号:
<?
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 != '')
{
if ($BEGIN_DATE != '')
{
if ($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>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -