index.php

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

PHP
45
字号
<?
  include_once 'inc/auth.php';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $query = 'SELECT * from VEHICLE_USAGE where VU_STATUS=1';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_ID3 = $ROW['VU_ID'];
    $V_ID3 = $ROW['V_ID'];
    $VU_START3 = $ROW['VU_START'];
    if (($VU_START3 <= $CUR_TIME))
    {
      exequery ($connection, (((''.'UPDATE VEHICLE_USAGE set VU_STATUS= \'2\' where VU_ID=\'').$VU_ID3).'\''));
      exequery ($connection, (((''.'UPDATE VEHICLE set USEING_FLAG= \'1\' where V_ID=\'').$V_ID3).'\''));
      continue;
    }
  }
  $query = 'SELECT * from VEHICLE_USAGE where VU_STATUS=2';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_ID3 = $ROW['VU_ID'];
    $V_ID3 = $ROW['V_ID'];
    $VU_END3 = $ROW['VU_END'];
    if (($VU_END3 <= $CUR_TIME))
    {
      exequery ($connection, (((''.'UPDATE VEHICLE_USAGE set VU_STATUS= \'4\' where VU_ID=\'').$VU_ID3).'\''));
      exequery ($connection, (((''.'UPDATE VEHICLE set USEING_FLAG= \'0\' where V_ID=\'').$V_ID3).'\''));
      continue;
    }
  }
  echo '<html>
<head>
<title>车辆使用申请</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<frameset rows="30,*"  cols="*" frameborder="NO" border="0" framespacing="0" id="frame1">
    <frame name="menu_top" scrolling="no" noresize src="menu_top.php" frameborder="0">
    <frame name="menu_main" scrolling="auto" noresize src="new.php" frameborder="1">
</frameset>
</htm';
  echo 'l>
';
?>

⌨️ 快捷键说明

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