⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 update.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 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 + -