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 + -
显示快捷键?