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