📄 update.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>新建事务</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
//------------------- 保存 -----------------------
$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;
}
$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%'";
exequery($connection,$query);
if($END_HOUR<$CAL_HOUR || ($END_HOUR==$CAL_HOUR && $END_MIN<$CAL_MIN))
{
Message("错误","开始时间晚于结束时间!");
Button_Back();
exit;
}
$CAL_TIME=$CAL_YEAR."-".$CAL_MON."-".$CAL_DAY." ".$CAL_HOUR.":".$CAL_MIN.":00";
$END_TIME=$CAL_YEAR."-".$CAL_MON."-".$CAL_DAY." ".$END_HOUR.":".$END_MIN.":00";
$query="insert into CALENDAR(USER_ID,CAL_TIME,END_TIME,CAL_TYPE,CONTENT) values ('$LOGIN_USER_ID','$CAL_TIME','$END_TIME','$CAL_TYPE','$CONTENT')";
exequery($connection,$query);
//------- 短信提醒 --------
if($SMS_REMIND=="on")
{
$SMS_CONTENT="请查看日程安排!\n内容:".csubstr($CONTENT,0,100);
send_sms($CAL_TIME,$LOGIN_USER_ID,$LOGIN_USER_ID,5,$SMS_CONTENT);
}
if($SMS2_REMIND=="on")
{
$SMS_CONTENT="OA日程安排:".$CONTENT;
send_mobile_sms_user($CAL_TIME,$LOGIN_USER_ID,$LOGIN_USER_ID,$SMS_CONTENT,5);
}
header("location: ../index.php?YEAR=$CAL_YEAR&MONTH=$CAL_MON&DAY=$CAL_DAY");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -