📄 add.php
字号:
<?php
function check_room( $M_ID, $M_ROOM, $M_START, $M_END )
{
global $connection;
$query = "select M_START,M_END,M_ID from MEETING where M_ID!='".$M_ID."' and M_ROOM='{$M_ROOM}' and (M_STATUS=1 or M_STATUS=2)";
$cursor = exequery( $connection, $query );
$COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$M_START1 = $ROW['M_START'];
$M_END1 = $ROW['M_END'];
if ( $M_START <= $M_START1 && !( $M_END1 <= $M_END ) || $M_START1 < $M_START && !( $M_START < $M_END1 ) || $M_START1 < $M_END && !( $M_END < $M_END1 ) || ( !( $M_START1 < $M_START ) && !( $M_END < $M_END1 ) ) )
{
++$COUNT;
$M_IDD = $M_IDD.$ROW['M_ID'].",";
}
}
$M_ID_STR = $M_IDD;
if ( 1 <= $COUNT )
{
return $M_ID_STR;
}
return "#";
}
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_file.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";
if ( $SMS_REMIND == "on" )
{
$SMS_REMIND = "1";
}
else
{
$SMS_REMIND = "0";
}
if ( $SMS2_REMIND == "on" )
{
$SMS2_REMIND = "1";
}
else
{
$SMS2_REMIND = "0";
}
if ( $M_START != "" )
{
$TIME_OK = is_date_time( $M_START );
if ( !$TIME_OK )
{
message( "错误", "开始时间格式不对，应形如 1999-1-2 09:30:00" );
button_back( );
exit( );
}
}
if ( $M_END != "" )
{
$TIME_OK = is_date_time( $M_END );
if ( !$TIME_OK )
{
message( "错误", "结束时间格式不对，应形如 1999-1-2 09:30:00" );
button_back( );
exit( );
}
}
if ( $M_START != "" && $M_END != "" && compare_date_time( $M_END, $M_START ) <= 0 )
{
message( "错误", "结束日期不能小于起始日期！" );
button_back( );
exit( );
}
check_room( "", $M_ROOM, $M_START, $M_END );
$SS = substr( check_room( "", $M_ROOM, $M_START, $M_END ), 0, 1 );
if ( is_number( $SS ) )
{
session_start( );
session_register( "M_NAME" );
session_register( "M_TOPIC" );
session_register( "M_ATTENDEE_OUT" );
$M_ATTENDEE = $COPY_TO_ID;
session_register( "M_ATTENDEE" );
session_register( "M_MANAGER" );
session_register( "M_DESC" );
session_register( "SECRET_TO_ID" );
session_register( "PRIV_ID" );
session_register( "TO_ID" );
message( "提示", "该时段有会议冲突" );
button_back( );
exit( );
}
session_start( );
session_unregister( "M_NAME" );
session_unregister( "M_TOPIC" );
session_unregister( "M_ATTENDEE_OUT" );
$M_ATTENDEE = $COPY_TO_ID;
session_unregister( "M_ATTENDEE" );
session_unregister( "M_MANAGER" );
session_unregister( "M_DESC" );
session_unregister( "SECRET_TO_ID" );
session_unregister( "PRIV_ID" );
session_unregister( "TO_ID" );
if ( 1 < count( $_FILES ) )
{
$ATTACHMENTS = upload( );
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD.$ATTACHMENTS['ID'];
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD.$ATTACHMENTS['NAME'];
}
else
{
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
if ( $M_ID == "" )
{
$query = "insert into MEETING(M_NAME,M_TOPIC,M_DESC,M_PROPOSER,M_REQUEST_TIME,M_ATTENDEE,M_START,M_END,M_ROOM,M_MANAGER,M_ATTENDEE_OUT,SMS_REMIND,SMS2_REMIND,ATTACHMENT_ID,ATTACHMENT_NAME,TO_ID,PRIV_ID,SECRET_TO_ID,RESEND_LONG,RESEND_SEVERAL) values('".$M_NAME."','{$M_TOPIC}','{$M_DESC}','{$M_PROPOSER}','{$M_REQUEST_TIME}','{$COPY_TO_ID}','{$M_START}','{$M_END}','{$M_ROOM}','{$M_MANAGER}','{$M_ATTENDEE_OUT}','{$SMS_REMIND}','{$SMS2_REMIND}','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}','{$TO_ID}','{$PRIV_ID}','{$SECRET_TO_ID}','{$RESEND_LONG}','{$RESEND_SEVERAL}')";
}
else
{
$query = "update MEETING set SECRET_TO_ID='".$SECRET_TO_ID."',PRIV_ID='{$PRIV_ID}',TO_ID='{$TO_ID}',M_NAME='{$M_NAME}',M_TOPIC='{$M_TOPIC}',M_DESC='{$M_DESC}',M_REQUEST_TIME='{$M_REQUEST_TIME}',M_ATTENDEE='{$COPY_TO_ID}',M_START='{$M_START}',M_END='{$M_END}',M_ROOM='{$M_ROOM}',M_MANAGER='{$M_MANAGER}',M_ATTENDEE_OUT='{$M_ATTENDEE_OUT}',SMS_REMIND='{$SMS_REMIND}',SMS2_REMIND='{$SMS2_REMIND}',ATTACHMENT_ID='{$ATTACHMENT_ID}',ATTACHMENT_NAME='{$ATTACHMENT_NAME}',RESEND_SEVERAL='{$RESEND_SEVERAL}',RESEND_LONG='{$RESEND_LONG}' where M_ID={$M_ID}";
}
exequery( $connection, $query );
if ( $M_ID == "" )
{
$M_ID = mysql_insert_id( );
}
$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 ( $OP == 0 )
{
header( "location: new.php?M_ID=".$M_ID );
}
else
{
if ( $M_MANAGER != "" && $SMS_REMIND1 == "on" )
{
send_sms( "", $M_PROPOSER, $M_MANAGER, 8, $M_PROPOSER_NAME."向您提交会议申请，请批示！", $REMIND_URL );
}
if ( $SMS2_REMIND1 == "on" )
{
send_mobile_sms_user( "", $M_PROPOSER, $M_MANAGER, $M_PROPOSER_NAME."向您提交会议申请，请批示！", 8 );
}
message( "提示", "会议申请保存成功！" );
button_back( );
}
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -