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 + -
显示快捷键?