📄 checkup.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_sms1.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "select M_STATUS 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'];
$SMS_REMIND = $ROW['SMS_REMIND'];
$SMS2_REMIND = $ROW['SMS2_REMIND'];
$M_NAME = $ROW['M_NAME'];
$M_ROOM = $ROW['M_ROOM'];
$M_START2 = $M_START = $ROW['M_START'];
$M_END = $ROW['M_END'];
$RESEND_LONG = $ROW['RESEND_LONG'];
$RESEND_SEVERAL = $ROW['RESEND_SEVERAL'];
if ( 4 < $RESEND_SEVERAL )
{
$RESEND_SEVERAL = 4;
}
$query = "select MR_NAME 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 USER_NAME 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 PARA_VALUE 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 = "1:meeting/query/meeting_detail.php?M_ID=".$M_ID;
if ( ( $M_STATUS == 0 || $M_STATUS == 1 || $M_STATUS == 3 ) && 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" && ( $SMS_REMIND == "1" || find_id( $SMS_REMIND1, 8 ) ) )
{
send_sms( "", $M_PROPOSER, $M_ATTENDEE, 8, $M_PROPOSER_NAME.$CONTENT, $REMIND_URL1 );
}
if ( $M_STATUS == "1" && ( $SMS2_REMIND == "1" || 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 );
}
}
if ( 0 < $RESEND_LONG && 0 < $RESEND_SEVERAL && $M_START2 != "NULL" )
{
$I = 0;
for ( ; $I < $RESEND_SEVERAL; ++$I )
{
$SEND_TIME = strtotime( $M_START2 ) - $RESEND_LONG * 3600 - $I * 20 * 60;
$SEND_TIME = date( "Y-m-d H:i:s", $SEND_TIME );
send_sms( $SEND_TIME, $M_PROPOSER, $M_ATTENDEE, 8, $M_START."在".$MR_NAME."开会，请按时参加。", $REMIND_URL1 );
}
}
header( "location: manage.php?M_STATUS=".$M_STATUS1 );
echo "</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -