📄 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\r\n";
$connection = openconnection( );
$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'];
}
if ( $M_STATUS == "0" )
{
$CONTENT = "您的会议申请已被撤销！";
}
else if ( $M_STATUS == "1" )
{
$CONTENT = "您的会议申请已被批准！";
}
else if ( $M_STATUS == "3" )
{
$CONTENT = "您的会议申请未被批准！";
}
if ( $M_STATUS == 0 || $M_STATUS == 1 || $M_STATUS == 3 )
{
send_sms( $connection, $LOGIN_USER_ID, $M_PROPOSER, 8, $CONTENT );
}
if ( $M_STATUS == 2 )
{
$query = "select * from MEETING where M_ID='{$M_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$M_NAME = $ROW['M_NAME'];
$M_TOPIC = $ROW['M_TOPIC'];
$M_DESC = $ROW['M_DESC'];
$M_ATTENDEE = $ROW['M_ATTENDEE'];
$M_START = $ROW['M_START'];
$M_ROOM = $ROW['M_ROOM'];
$M_END = $ROW['M_END'];
}
$query = "select * from MEETING_ROOM where MR_ID='{$M_ROOM}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$M_ROOM_NAME = $ROW['MR_NAME'];
}
$TO_ID = "ALL_DEPT";
$SUBJECT = "会议通知";
$CONTENT = "<p align=\"center\"><strong><font color=\"black\" size=\"5\">会议通知</font></strong></p>";
$CONTENT .= "<center>";
$CONTENT .= "<table style=\"BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-table-layout-alt: fixed\" cellSpacing=\"0\" cellPadding=\"0\" border=\"1\">";
$CONTENT .= " <tbody>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">名</font><font color=\"black\" face=\"Times New Roman\"> ";
$CONTENT .= " </font><font color=\"black\">称：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 414pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt\" width=\"552\" colSpan=\"3\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt\"><o:p>";
$CONTENT .= $M_NAME;
$CONTENT .= " </o:p>";
$CONTENT .= " </span></p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">主</font><font color=\"black\" face=\"Times New Roman\"> ";
$CONTENT .= " </font><font color=\"black\">题：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 414pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"552\" colSpan=\"3\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\">";
$CONTENT .= $M_TOPIC;
$CONTENT .= " </p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">描</font><font color=\"black\" face=\"Times New Roman\"> ";
$CONTENT .= " </font><font color=\"black\">述：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 414pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"552\" colSpan=\"3\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt\"><o:p>";
$CONTENT .= $M_DESC;
$CONTENT .= " </o:p>";
$CONTENT .= " </span> </p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">出席人员：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 414pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"552\" colSpan=\"3\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt\"><o:p>";
$CONTENT .= " </o:p>";
$CONTENT .= $M_ATTENDEE;
$CONTENT .= " <o:p>";
$CONTENT .= " </o:p>";
$CONTENT .= " </span> </p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">开始时间：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 171pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"228\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt\"><o:p>";
$CONTENT .= $M_START;
$CONTENT .= " </o:p>";
$CONTENT .= " </span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" noWrap width=\"108\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">结束时间：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 162pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"216\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt\"><o:p>";
$CONTENT .= $M_START;
$CONTENT .= " </o:p>";
$CONTENT .= " </span></p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " <tr>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 68.4pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt\" width=\"91\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><span lang=\"EN-US\" style=\"mso-font-kerning: 0pt\"><font color=\"black\">会 ";
$CONTENT .= " 议 室：</font></span></p>";
$CONTENT .= " </td>";
$CONTENT .= " <td style=\"BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 414pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt\" width=\"552\" colSpan=\"3\">";
$CONTENT .= " <p class=\"MsoNormal\" style=\"MARGIN: 0cm 0cm 0pt\"><font face=\"Times New Roman\"><span lang=\"EN-US\" style=\"FONT-SIZE: 12pt; FONT-FAMILY: 宋体\"><o:p>";
$CONTENT .= $M_ROOM_NAME;
$CONTENT .= " </o:p>";
$CONTENT .= " </span></font></p>";
$CONTENT .= " </td>";
$CONTENT .= " </tr>";
$CONTENT .= " </tbody>";
$CONTENT .= " </table>";
$CONTENT .= " <br>";
$CONTENT .= " </center>";
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
$BEGIN_DATE = date( "Y-m-d H:i:s", time( ) );
$END_DATE = $M_END;
$query = "insert into NOTIFY(FROM_ID,TO_ID,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,END_DATE) values ('{$LOGIN_USER_ID}','{$TO_ID}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$BEGIN_DATE}','{$END_DATE}')";
exequery( $connection, $query );
}
header( "location: index.php" );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -