add.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 135 行
PHP
135 行
<?
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 (($VU_START != ''))
{
$TIME_OK = is_date_time ($VU_START);
if (!$TIME_OK)
{
message ('错误', '起始时间格式不对，应形如 1999-1-2 09:30:00');
button_back ();
exit ();
}
}
if (($VU_END != ''))
{
$TIME_OK = is_date_time ($VU_END);
if (!$TIME_OK)
{
message ('错误', '结束时间格式不对，应形如 1999-1-2 09:30:00');
button_back ();
exit ();
}
}
if (((($VU_START != '') AND ($VU_END != '')) AND ($VU_END < $VU_START)))
{
message ('错误', '起始日期不能小于结束日期！');
button_back ();
exit ();
}
if ((($VU_MILEAGE != '') AND !is_numeric ($VU_MILEAGE)))
{
message ('错误', '里程应为数字！');
button_back ();
exit ();
}
$V_ID = substr ($V_ID, 0, strpos ($V_ID, '*'));
$query1 = ((''.'select * from VEHICLE_USAGE where VU_STATUS=2 and V_ID=').$V_ID);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$VU_START1 = $ROW1['VU_START'];
$VU_END1 = $ROW1['VU_END'];
if ((((($VU_START1 <= $VU_START) AND ($VU_START <= $VU_END1)) OR (($VU_START1 <= $VU_END) AND ($VU_END <= $VU_END1))) OR (($VU_START <= $VU_START1) AND ($VU_END1 <= $VU_END))))
{
message ('提示', '您所申请的车辆在使用中！');
button_back ();
exit ();
continue;
}
}
if (($VU_MILEAGE == ''))
{
$VU_MILEAGE = 0;
}
if (($SMS_REMIND == 'on'))
{
$SMS_REMIND = '1';
}
else
{
$SMS_REMIND = '0';
}
if (($SMS2_REMIND == 'on'))
{
$SMS2_REMIND = '1';
}
else
{
$SMS2_REMIND = '0';
}
if (($TO_ID != ''))
{
$SHOW_FLAG = '0';
}
else
{
$SHOW_FLAG = '1';
}
if (($VU_ID == ''))
{
$query = (((((((((((((((((((((((((((((((((((''.'insert into VEHICLE_USAGE(V_ID,VU_PROPOSER,VU_REQUEST_DATE,VU_USER,VU_MILEAGE,VU_REASON,VU_REMARK,VU_START,VU_END,VU_DEPT,VU_DESTINATION,VU_OPERATOR,VU_DRIVER,SMS_REMIND,SMS2_REMIND,DEPT_MANAGER,DMER_STATUS,SHOW_FLAG) values(\'').$V_ID).'\',\'').$VU_PROPOSER).'\',\'').$VU_REQUEST_DATE).'\',\'').$VU_USER).'\',\'').$VU_MILEAGE).'\',\'').$VU_REASON).'\',\'').$VU_REMARK).'\',\'').$VU_START).'\',\'').$VU_END).'\',\'').$VU_DEPT).'\',\'').$VU_DESTINATION).'\',\'').$VU_OPERATOR).'\',\'').$VU_DRIVER).'\',\'').$SMS_REMIND).'\',\'').$SMS2_REMIND).'\',\'').$TO_ID).'\',\'0\',\'').$SHOW_FLAG).'\')');
}
else
{
$query = ((((((((((((((((((((((((((((((((((''.'update VEHICLE_USAGE set V_ID=\'').$V_ID).'\',VU_PROPOSER=\'').$VU_PROPOSER).'\',VU_REQUEST_DATE=\'').$VU_REQUEST_DATE).'\',VU_USER=\'').$VU_USER).'\',VU_MILEAGE=\'').$VU_MILEAGE).'\',VU_REASON=\'').$VU_REASON).'\',VU_REMARK=\'').$VU_REMARK).'\',VU_START=\'').$VU_START).'\',VU_END=\'').$VU_END).'\',VU_DEPT=\'').$VU_DEPT).'\',VU_DESTINATION=\'').$VU_DESTINATION).'\',VU_OPERATOR=\'').$VU_OPERATOR).'\',VU_DRIVER=\'').$VU_DRIVER).'\',SMS_REMIND=\'').$SMS_REMIND).'\',SMS2_REMIND=\'').$SMS2_REMIND).'\',DEPT_MANAGER=\'').$TO_ID).'\',DMER_STATUS=\'0\' where VU_ID=').$VU_ID);
}
exequery ($connection, $query);
if (($VU_ID == ''))
{
$VU_ID = mysql_insert_id ();
}
if ((($TO_ID != '') AND ($TO_ID != $LOGIN_USER_ID)))
{
$REMIND_URL = 'vehicle/dept_manage';
if (($SMS_REMIND1 == 'on'))
{
send_sms ('', $VU_PROPOSER, $TO_ID, 9, ($VU_PROPOSER_NAME.'请求车辆申请部门审批，请批示！'), $REMIND_URL);
}
if (($SMS2_REMIND1 == 'on'))
{
send_mobile_sms_user ('', $VU_PROPOSER, $TO_ID, ($VU_PROPOSER_NAME.'请求车辆申请部门审批，请批示！'), 9);
}
}
else
{
if ((($VU_OPERATOR != '') AND ($VU_OPERATOR != $LOGIN_USER_ID)))
{
$REMIND_URL1 = 'vehicle';
if (($SMS_REMIND1 == 'on'))
{
send_sms ('', $VU_PROPOSER, $VU_OPERATOR, 9, ($VU_PROPOSER_NAME.'向您提交车辆申请，请批示！'), $REMIND_URL1);
}
if (($SMS2_REMIND1 == 'on'))
{
send_mobile_sms_user ('', $VU_PROPOSER, $VU_OPERATOR, ($VU_PROPOSER_NAME.'向您提交车辆申请，请批示！'), 9);
}
}
}
message ('提示', '提交申请成功！');
button_back ();
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?