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

📄 submit.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_all.php");

if($CAL_ID=="")
   $WIN_TITLE="新建事务";
else
   $WIN_TITLE="编辑事务";
?>

<html>
<head>
<title><?=$WIN_TITLE?></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">

<?
//------------------- 保存 -----------------------
if($END_HOUR<$CAL_HOUR || ($END_HOUR==$CAL_HOUR && $END_MIN<$CAL_MIN))
{
   Message("错误","开始时间晚于结束时间!");
   Button_Back();
   exit;
}

if($CAL_ID!="")
{
   $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 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);
}

$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";

if($CAL_ID=="")
   $query="insert into CALENDAR(USER_ID,CAL_TIME,END_TIME,CAL_TYPE,CONTENT,MANAGER_ID,OVER_STATUS) values ('$USER_ID','$CAL_TIME','$END_TIME','1','$CONTENT','$LOGIN_USER_ID','0')";
else
   $query="update CALENDAR set CAL_TIME='$CAL_TIME',END_TIME='$END_TIME',CONTENT='$CONTENT' where CAL_ID=$CAL_ID";
exequery($connection,$query);

//------- 短信提醒 --------
$CUR_TIME=date("Y-m-d H:i:s",time());
$query = "select * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $USER_NAME=$ROW["USER_NAME"];

if($SMS_REMIND=="on")
{
   $SMS_CONTENT=$USER_NAME."为您安排新的工作。\n内容:".csubstr($CONTENT,0,100);
   send_sms($CAL_TIME,$LOGIN_USER_ID,$USER_ID,5,$SMS_CONTENT);
   send_sms($CUR_TIME,$LOGIN_USER_ID,$USER_ID,5,$SMS_CONTENT);
}

if($SMS2_REMIND=="on")
{
   $SMS_CONTENT="OA日程安排:".$USER_NAME."为您安排新的工作,内容:".$CONTENT;
   send_mobile_sms_user($CAL_TIME,$LOGIN_USER_ID,$USER_ID,$SMS_CONTENT,5);
   send_mobile_sms_user($CUR_TIME,$LOGIN_USER_ID,$USER_ID,$SMS_CONTENT,5);
}

Message("","保存成功");
Button_Back();
?>
<script Language="JavaScript">
window.opener.location.reload();
</script>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -