📄 search.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">
<script>
function delete_vehicle(VM_ID)
{
msg='确认要删除该维护信息么？';
if(window.confirm(msg))
{
URL="delete.php?VM_ID=" + VM_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
if($VU_REQUEST_DATE_MIN!="")
{
$TIME_OK=is_date($VU_REQUEST_DATE_MIN);
if(!$TIME_OK)
{ Message("错误","申请日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_REQUEST_DATE_MIN.=" 00:00:00";
}
if($VU_REQUEST_DATE_MAX!="")
{
$TIME_OK=is_date($VU_REQUEST_DATE_MAX);
if(!$TIME_OK)
{ Message("错误","申请日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_REQUEST_DATE_MAX.=" 23:59:59";
}
if($VU_START_MIN!="")
{
$TIME_OK=is_date($VU_START_MIN);
if(!$TIME_OK)
{ Message("错误","起始日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_START_MIN.=" 00:00:00";
}
if($VU_START_MAX!="")
{
$TIME_OK=is_date($VU_START_MAX);
if(!$TIME_OK)
{ Message("错误","起始日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_START_MAX.=" 23:59:59";
}
if($VU_END_MIN!="")
{
$TIME_OK=is_date($VU_END_MIN);
if(!$TIME_OK)
{ Message("错误","结束日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_END_MIN.=" 00:00:00";
}
if($VU_END_MAX!="")
{
$TIME_OK=is_date($VU_END_MAX);
if(!$TIME_OK)
{ Message("错误","结束日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
$VU_END_MAX.=" 23:59:59";
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" HEIGHT="20"><span class="big3"> 车辆使用记录查询</span>
</td>
</tr>
</table>
<?
if($VU_STATUS!="")
$WHERE_STR.=" and VU_STATUS='$VU_STATUS'";
if($V_ID!="")
$WHERE_STR.=" and V_ID='$V_ID'";
if($VU_REQUEST_DATE_MIN!="")
$WHERE_STR.=" and VU_REQUEST_DATE>='$VU_REQUEST_DATE_MIN'";
if($VU_REQUEST_DATE_MAX!="")
$WHERE_STR.=" and VU_REQUEST_DATE<='$VU_REQUEST_DATE_MAX'";
if($VU_USER!="")
$WHERE_STR.=" and VU_USER like '%$VU_USER%'";
if($VU_DEPT!="")
$WHERE_STR.=" and VU_DEPT='$VU_DEPT'";
if($VU_START_MIN!="")
$WHERE_STR.=" and VU_START>='$VU_START_MIN'";
if($VU_START_MAX!="")
$WHERE_STR.=" and VU_START<='$VU_START_MAX'";
if($VU_END_MIN!="")
$WHERE_STR.=" and VU_END>='$VU_END_MIN'";
if($VU_END_MAX!="")
$WHERE_STR.=" and VU_END<='$VU_END_MAX'";
if($TO_ID!="")
$WHERE_STR.=" and VU_PROPOSER='$TO_ID'";
if($VU_OPERATOR!="")
$WHERE_STR.=" and VU_OPERATOR='$VU_OPERATOR'";
if($VU_REASON!="")
$WHERE_STR.=" and VU_REASON like '%$VU_REASON%'";
if($VU_REMARK!="")
$WHERE_STR.=" and VU_REMARK like '%$VU_REMARK%'";
//============================ =======================================
$query = "SELECT * from VEHICLE_USAGE where 1=1".$WHERE_STR." order by VU_STATUS,VU_START";
$cursor= exequery($connection,$query);
$VU_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$VU_COUNT++;
$VU_ID=$ROW["VU_ID"];
$V_ID=$ROW["V_ID"];
$VU_PROPOSER=$ROW["VU_PROPOSER"];
$VU_REQUEST_DATE=$ROW["VU_REQUEST_DATE"];
$VU_USER=$ROW["VU_USER"];
$VU_REASON=$ROW["VU_REASON"];
$VU_START =$ROW["VU_START"];
$VU_END=$ROW["VU_END"];
$VU_MILEAGE=$ROW["VU_MILEAGE"];
$VU_DEPT=$ROW["VU_DEPT"];
$VU_STATUS=$ROW["VU_STATUS"];
$VU_REMARK=$ROW["VU_REMARK"];
$VU_DESTINATION=$ROW["VU_DESTINATION"];
$VU_OPERATOR=$ROW["VU_OPERATOR"];
$VU_MILEAGE_SUM+=$VU_MILEAGE;
if($VU_START=="0000-00-00 00:00:00")
$VU_START="";
if($VU_END=="0000-00-00 00:00:00")
$VU_END="";
if($VU_REQUEST_DATE=="0000-00-00 00:00:00")
$VU_REQUEST_DATE="";
$query = "SELECT * from USER where USER_ID='$VU_PROPOSER'";
$cursor1= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
$VU_PROPOSER_NAME=$ROW["USER_NAME"];
if($VU_DEPT!="")
{
$query = "SELECT * from DEPARTMENT where DEPT_ID=$VU_DEPT";
$cursor1= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
$VU_DEPT_FIELD_DESC=$ROW["DEPT_NAME"];
}
$query = "SELECT * from VEHICLE where V_ID='$V_ID'";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$V_NUM=$ROW1["V_NUM"];
if($VU_STATUS==0)
$VU_STATUS_DESC="待批";
elseif($VU_STATUS==1)
$VU_STATUS_DESC="已准";
elseif($VU_STATUS==2)
$VU_STATUS_DESC="使用中";
elseif($VU_STATUS==3)
$VU_STATUS_DESC="未准";
elseif($VU_STATUS==4)
$VU_STATUS_DESC="空闲";
if($VU_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">车牌号</td>
<td nowrap align="center">用车人</td>
<td align="center">事由</td>
<td nowrap align="center">开始时间</td>
<td nowrap align="center">结束时间</td>
<td align="center">备注</td>
<td nowrap align="center">操作</td>
</tr>
<?
}
?>
<tr class="TableData">
<td nowrap align="center"><a href="javascript:;" onClick="window.open('../vehicle_detail.php?V_ID=<?=$V_ID?>','','height=360,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=280,top=160,,resizable=yes');"><?=$V_NUM?></a></td>
<td nowrap align="center"><?=$VU_USER?></td>
<td align="center"><?=$VU_REASON?></td>
<td nowrap align="center"><?=$VU_START?></a></td>
<td nowrap align="center"><?=$VU_END?></a></td>
<td align="center"><?=$VU_REMARK?></td>
<td nowrap align="center">
<a href="javascript:;" onClick="window.open('../usage_detail.php?VU_ID=<?=$VU_ID?>','','height=380,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=200,left=280,resizable=yes');">详细信息</a>
</td>
</tr>
<?
}
if($VU_COUNT>0)
{
?>
</table>
<?
}
else
Message("","无符合条件的车辆使用信息");
Button_Back();
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -