update.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 75 行
PHP
75 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_sms1.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">
';
if ((($CAL_DATE != '') AND !is_date ($CAL_DATE)))
{
message ('错误', '日期格式不对,应形如 1999-1-2');
button_back ();
exit ();
}
if ((($REMIND_TIME != '') AND !is_date_time ($REMIND_TIME)))
{
message ('错误', '日期格式不对,应形如 1999-1-2');
button_back ();
exit ();
}
$query = ((''.'select * from CALENDAR where CAL_ID=').$CAL_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CAL_TIME1 = $ROW['CAL_TIME'];
$CONTENT1 = $ROW['CONTENT'];
$SMS_CONTENT1 = csubstr ($CONTENT1, 0, 100);
$SMS_CONTENT2 = $CONTENT1;
$OVER_STATUS = $ROW['OVER_STATUS'];
}
$query = (((((''.'delete from CALENDAR where CAL_ID=\'').$CAL_ID).'\' and USER_ID=\'').$LOGIN_USER_ID).'\'');
exequery ($connection, $query);
$query = (((((((''.'delete from SMS where FROM_ID=\'').$LOGIN_USER_ID).'\' and SEND_TIME=\'').$CAL_TIME1).'\' and CONTENT like \'%').$SMS_CONTENT1).'%\' and SMS_TYPE=\'5\'');
exequery ($connection, $query);
$query = (((((((''.'delete from SMS2 where FROM_ID=\'').$LOGIN_USER_ID).'\' and SEND_TIME=\'').$CAL_TIME1).'\' and CONTENT like \'%').$SMS_CONTENT2).'%\' and SEND_FLAG=\'0\'');
exequery ($connection, $query);
if ((($END_HOUR < $CAL_HOUR) OR (($END_HOUR == $CAL_HOUR) AND ($END_MIN < $CAL_MIN))))
{
message ('错误', '开始时间晚于结束时间!');
button_back ();
exit ();
}
$CAL_TIME = ((((($CAL_DATE.' ').$CAL_HOUR).':').$CAL_MIN).':00');
$END_TIME = ((((($CAL_DATE.' ').$END_HOUR).':').$END_MIN).':00');
if (($REMIND_TIME == ''))
{
$REMIND_TIME = $CAL_TIME;
}
$query = (((((((((((((''.'insert into CALENDAR(USER_ID,CAL_TIME,END_TIME,CAL_TYPE,CONTENT,OVER_STATUS) values (\'').$LOGIN_USER_ID).'\',\'').$CAL_TIME).'\',\'').$END_TIME).'\',\'').$CAL_TYPE).'\',\'').$CONTENT).'\',\'').$OVER_STATUS).'\')');
exequery ($connection, $query);
$CAL_ID = mysql_insert_id ();
if (($SMS_REMIND == 'on'))
{
$REMIND_URL = ('1:calendar/arrange/note.php?CAL_ID='.$CAL_ID);
$SMS_CONTENT = ('请查看日程安排!
内容:'.csubstr ($CONTENT, 0, 100));
send_sms ($REMIND_TIME, $LOGIN_USER_ID, $LOGIN_USER_ID, 5, $SMS_CONTENT, $REMIND_URL);
}
if (($SMS2_REMIND == 'on'))
{
$SMS_CONTENT = ('OA日程安排:'.$CONTENT);
send_mobile_sms_user ($REMIND_TIME, $LOGIN_USER_ID, $LOGIN_USER_ID, $SMS_CONTENT, 5);
}
header ((('location: '.$REFER_URL).((((((''.'?YEAR=').$CAL_YEAR).'&MONTH=').$CAL_MON).'&DAY=').$CAL_DAY)));
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?