submit.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 110 行
PHP
110 行
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>上下班登记</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$query1 = (((''.'select * from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DUTY_TYPE = $ROW['DUTY_TYPE'];
}
$query = ((''.'SELECT * from ATTEND_CONFIG where DUTY_TYPE=').$DUTY_TYPE);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
if (($REGISTER_TYPE == 1))
{
$DUTY_TIME = $ROW['DUTY_TIME1'];
$DUTY_TYPE = $ROW['DUTY_TYPE1'];
}
else
{
if (($REGISTER_TYPE == 2))
{
$DUTY_TIME = $ROW['DUTY_TIME2'];
$DUTY_TYPE = $ROW['DUTY_TYPE2'];
}
else
{
if (($REGISTER_TYPE == 3))
{
$DUTY_TIME = $ROW['DUTY_TIME3'];
$DUTY_TYPE = $ROW['DUTY_TYPE3'];
}
else
{
if (($REGISTER_TYPE == 4))
{
$DUTY_TIME = $ROW['DUTY_TIME4'];
$DUTY_TYPE = $ROW['DUTY_TYPE4'];
}
else
{
if (($REGISTER_TYPE == 5))
{
$DUTY_TIME = $ROW['DUTY_TIME5'];
$DUTY_TYPE = $ROW['DUTY_TYPE5'];
}
else
{
if (($REGISTER_TYPE == 6))
{
$DUTY_TIME = $ROW['DUTY_TIME6'];
$DUTY_TYPE = $ROW['DUTY_TYPE6'];
}
}
}
}
}
}
}
$DUTY_INTERVAL_BEFORE = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE);
$query = (((''.'SELECT * from SYS_PARA where PARA_NAME=\'').$DUTY_INTERVAL_BEFORE).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$DUTY_INTERVAL_BEFORE = $ROW['PARA_VALUE'];
}
$DUTY_INTERVAL_AFTER = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE);
$query = (((''.'SELECT * from SYS_PARA where PARA_NAME=\'').$DUTY_INTERVAL_AFTER).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$DUTY_INTERVAL_AFTER = $ROW['PARA_VALUE'];
}
$REGISTER_TIME = (($CUR_DATE.' ').$DUTY_TIME);
if (((($DUTY_INTERVAL_BEFORE * 60) < (strtotime ($REGISTER_TIME) - strtotime ($CUR_TIME))) OR (($DUTY_INTERVAL_AFTER * 60) < (strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME)))))
{
if (($DUTY_TYPE == '1'))
{
message ('警告', (((((''.'规定时间之前 ').$DUTY_INTERVAL_BEFORE).' 分钟,之后 ').$DUTY_INTERVAL_AFTER).' 分钟起可进行上班登记!'));
}
if (($DUTY_TYPE == '2'))
{
message ('警告', (((((''.'规定时间之前 ').$DUTY_INTERVAL_BEFORE).' 分钟,之后 ').$DUTY_INTERVAL_AFTER).' 分钟起可进行下班登记!'));
}
button_back ();
exit ();
}
$query = (((((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$LOGIN_USER_ID).'\' and REGISTER_TYPE=\'').$REGISTER_TYPE).'\' and to_days(REGISTER_TIME)=to_days(\'').$CUR_TIME).'\')');
$cursor = exequery ($connection, $query);
if (!$ROW = mysql_fetch_array ($cursor))
{
$query = (((((((((''.'insert into ATTEND_DUTY(USER_ID,REGISTER_TYPE,REGISTER_TIME,REGISTER_IP) values (\'').$LOGIN_USER_ID).'\',\'').$REGISTER_TYPE).'\',\'').$CUR_TIME).'\',\'').$_SERVER['REMOTE_ADDR']).'\')');
exequery ($connection, $query);
}
header ('location: index.php');
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?