add.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 142 行
PHP
142 行
<?
function check_room ($M_ID, $M_ROOM, $M_START, $M_END)
{
global $connection;
$query = (((((''.'select * 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) AND ($M_END1 <= $M_END)) OR (($M_START1 < $M_START) AND ($M_START < $M_END1))) OR (($M_START1 < $M_END) AND ($M_END < $M_END1))) OR (($M_START1 < $M_START) AND ($M_END < $M_END1))))
{
++$COUNT;
$M_IDD = (($M_IDD.$ROW['M_ID']).',');
continue;
}
}
$M_ID_STR = $M_IDD;
if ((1 <= $COUNT))
{
return $M_ID_STR;
}
else
{
return '#';
}
}
include_once 'inc/auth.php';
include_once 'inc/check_type.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">
';
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 != '') AND ($M_END != '')) AND (compare_date_time ($M_END, $M_START) <= 0)))
{
message ('错误', '结束日期不能小于起始日期！');
button_back ();
exit ();
}
$SS = substr (check_room ('', $M_ROOM, $M_START, $M_END), 0, 1);
if (is_number ($SS))
{
message ('提示', '该时段有会议冲突');
button_back ();
exit ();
}
if (($ATTACHMENT_NAME != ''))
{
$ATTACHMENT_ID = upload ($ATTACHMENT, $ATTACHMENT_NAME);
$ATTACHMENT_ID = (($ATTACHMENT_ID_OLD.$ATTACHMENT_ID).',');
$ATTACHMENT_NAME = (($ATTACHMENT_NAME_OLD.$ATTACHMENT_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) 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).'\')');
}
else
{
$query = ((((((((((((((((((((((((((((((''.'update MEETING set 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).'\' 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 != '') AND ($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 '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?