checkup.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 102 行

PHP
102
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  include_once 'inc/utility_sms1.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $query = (((''.'select * from MEETING where M_ID=\'').$M_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $M_STATUS1 = $ROW['M_STATUS'];
  }
  $query = (((((''.'update MEETING set M_STATUS=\'').$M_STATUS).'\' where M_ID=\'').$M_ID).'\'');
  exequery ($connection, $query);
  $query = (((''.'select * from MEETING where M_ID=\'').$M_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $M_PROPOSER = $ROW['M_PROPOSER'];
    $M_ATTENDEE = $ROW['M_ATTENDEE'];
    $M_START = $ROW['M_START'];
    $SMS_REMIND = $ROW['SMS_REMIND'];
    $SMS2_REMIND = $ROW['SMS2_REMIND'];
    $M_NAME = $ROW['M_NAME'];
    $M_ROOM = $ROW['M_ROOM'];
    $query = (((''.'select * from MEETING_ROOM where MR_ID=\'').$M_ROOM).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $MR_NAME = $ROW['MR_NAME'];
    }
    $query = (((''.'select * from USER where USER_ID=\'').$M_PROPOSER).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $M_PROPOSER_NAME = $ROW['USER_NAME'];
    }
  }
  if (($M_STATUS == '0'))
  {
    $CONTENT = '您的会议申请已被撤销!';
  }
  else
  {
    if (($M_STATUS == '1'))
    {
      $CONTENT = '您的会议申请已被批准!';
    }
    else
    {
      if (($M_STATUS == '3'))
      {
        $CONTENT = '您的会议申请未被批准!';
      }
    }
  }
  $query = 'select * from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PARA_VALUE = $ROW['PARA_VALUE'];
  }
  $SMS_REMIND1 = substr ($PARA_VALUE, 0, strpos ($PARA_VALUE, '|'));
  $SMS2_REMIND1 = substr ($PARA_VALUE, (strpos ($PARA_VALUE, '|') + 1));
  $REMIND_URL1 = ('meeting/query/meeting_detail.php?M_ID='.$M_ID);
  if ((((($M_STATUS == 0) OR ($M_STATUS == 1)) OR ($M_STATUS == 3)) AND find_id ($SMS_REMIND1, 8)))
  {
    send_sms ('', $LOGIN_USER_ID, $M_PROPOSER, 8, $CONTENT, $REMIND_URL1);
  }
  $M_START = substr ($M_START, 0, 16);
  $CONTENT = ((((('通知您于'.$M_START).'在').$MR_NAME).'开会,会议名称:').$M_NAME);
  if ((($M_STATUS == '1') AND (($SMS_REMIND == '1') OR find_id ($SMS_REMIND1, 8))))
  {
    send_sms ('', $M_PROPOSER, $M_ATTENDEE, 8, ($M_PROPOSER_NAME.$CONTENT), $REMIND_URL1);
  }
  if ((($M_STATUS == '1') AND (($SMS2_REMIND == '1') OR find_id ($SMS2_REMIND1, 8))))
  {
    send_mobile_sms_user ('', $M_PROPOSER, $M_ATTENDEE, ($M_PROPOSER_NAME.$CONTENT), 8);
  }
  if (($M_STATUS == '0'))
  {
    if (find_id ($SMS_REMIND1, 8))
    {
      send_sms ('', $M_PROPOSER, $M_ATTENDEE, 8, (('会议'.$M_NAME).'已经被取消!'), $REMIND_URL1);
    }
    if (find_id ($SMS2_REMIND1, 8))
    {
      send_mobile_sms_user ('', $M_PROPOSER, $M_ATTENDEE, (('会议'.$M_NAME).'已经被取消!'), 8);
    }
  }
  header (((''.'location: manage.php?M_STATUS=').$M_STATUS1));
  echo '</body>
</html>
';
?>

⌨️ 快捷键说明

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