📄 add.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
?>
<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!=""&&$VU_END!=""&&$VU_START> $VU_END)
{
Message("错误","起始日期不能小于结束日期！");
Button_Back();
exit;
}
if($VU_MILEAGE!=""&&!is_numeric($VU_MILEAGE))
{
Message("错误","里程应为数字！");
Button_Back();
exit;
}
$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_START >=$VU_START1 && $VU_START <= $VU_END1)||($VU_END >=$VU_START1 && $VU_END <= $VU_END1)||($VU_START <=$VU_START1 && $VU_END >= $VU_END1))
{
Message("提示","您所申请的车辆在使用中！");
Button_Back();
exit;
}
}
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($VU_OPERATOR!=""&& $VU_OPERATOR!=$LOGIN_USER_ID && $SMS_REMIND1=="on")
send_sms("",$VU_PROPOSER,$VU_OPERATOR,9,$VU_PROPOSER_NAME."向您提交车辆申请，请批示！");
if($VU_OPERATOR!=""&& $VU_OPERATOR!=$LOGIN_USER_ID && $SMS2_REMIND1=="on")
send_mobile_sms_user("",$VU_PROPOSER,$VU_OPERATOR,$VU_PROPOSER_NAME."向您提交车辆申请，请批示！",9);
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) 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')";
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' where VU_ID=$VU_ID";
exequery($connection,$query);
Message("提示","车辆使用申请保存成功！");
Button_Back();
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -