update.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 92 行

PHP

92 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  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 (compare_date_time ($VU_END, $VU_START) <= 0)))
  {
    message ('错误', '结束时间不能小于起始时间！');
    button_back ();
    exit ();
  }
  if ((($VU_MILEAGE != '') AND !is_numeric ($VU_MILEAGE)))
  {
    message ('错误', '里程应为数字！');
    button_back ();
    exit ();
  }
  $query = (((''.'select VU_STATUS from VEHICLE_USAGE where VU_ID=\'').$VU_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_STATUS1 = $ROW['VU_STATUS'];
  }
  if ((($VU_STATUS1 == 2) AND (compare_date_time ($VU_START, $CUR_TIME) == 1)))
  {
    $MY_STR = 'VU_STATUS=\'1\',';
  }
  if (($VU_MILEAGE == ''))
  {
    $VU_MILEAGE = 0;
  }
  $V_ID = substr ($V_ID, 0, strpos ($V_ID, '*'));
  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) 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).'\')');
  }
  else
  {
    $query = (('update VEHICLE_USAGE set '.$MY_STR).((((((((((((((((((((((((((((''.'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).'\' where VU_ID=').$VU_ID));
  }
  exequery ($connection, $query);
  if (($VU_ID == ''))
  {
    $VU_ID = mysql_insert_id ();
  }
  $query = 'select * from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PARA_VALUE = $ROW['PARA_VALUE'];
  }
  $SMS_REMIND1 = substr ($PARA_VALUE, 0, strpos ($PARA_VALUE, '|'));
  $REMIND_URL = 'vehicle/checkup';
  if (((($VU_OPERATOR != '') AND ($VU_OPERATOR != $LOGIN_USER_ID)) AND find_id ($SMS_REMIND1, 9)))
  {
    send_sms ('', $VU_PROPOSER, $VU_OPERATOR, 9, ($VU_PROPOSER_NAME.'向您提交车辆申请，请批示！'), $REMIND_URL);
  }
  header (((''.'location: query.php?VU_STATUS=').$VU_STATUS));
  echo '
</body>
</html>
';
?>

update.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 update.php 源码文件，采用 PHP 编程语言编写，共 92 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?