⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 update.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.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_MILEAGE!=""&&!is_numeric($VU_MILEAGE))
{
   Message("错误","里程应为数字!");
   Button_Back();
   exit;
}
if($VU_MILEAGE=="")
   $VU_MILEAGE=0;

if($VU_OPERATOR!=""&&$VU_OPERATOR!=$LOGIN_USER_ID)
   send_sms("",$VU_PROPOSER,$VU_OPERATOR,9,$VU_PROPOSER_NAME."向您提交车辆申请,请批示!");

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) 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')";
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' where VU_ID=$VU_ID";

exequery($connection,$query);

header("location: query.php?VU_STATUS=$VU_STATUS");

?>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -