📄 query_all.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>车辆申请查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function LoadWindow(id,desc)
{
URL="/module/dept_select_single?ID="+id+"&DESC="+desc;
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:1;status:0;help:0;resizable:1;dialogWidth:300px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function LoadWindow1()
{
URL="/module/user_select_single";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<br>
<table border="0" width="500" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="search.php" method="post" name="form1">
<tr>
<td colspan="2" nowrap class="TableHeader">
<img src="/images/green_arrow.gif"> 请指定查询条件：
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 状 态：</td>
<td class="TableData">
<select name="VU_STATUS" class="BigSelect">
<option value=""></option>
<option value="0">待批</option>
<option value="1">已准</option>
<option value="2">使用中</option>
<option value="3">未准</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 车 牌 号：</td>
<td class="TableData">
<select name="V_ID" class="BigSelect">
<option value=""></option>
<?
$query = "SELECT * from VEHICLE order by V_NUM";
$cursor1= exequery($connection,$query);
while($ROW1=mysql_fetch_array($cursor1))
{
$V_ID1=$ROW1["V_ID"];
$V_NUM=$ROW1["V_NUM"];
?>
<option value="<?=$V_ID1?>"><?=$V_NUM?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 申请日期：</td>
<td class="TableData">
<input type="text" name="VU_REQUEST_DATE_MIN" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_REQUEST_DATE_MIN');"> 至
<input type="text" name="VU_REQUEST_DATE_MAX" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_REQUEST_DATE_MAX');">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 用 车 人：</td>
<td class="TableData">
<input type="text" name="VU_USER" size="20" maxlength="100" class="BigInput" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 用车部门：</td>
<td class="TableData">
<input type="hidden" name="VU_DEPT" value="">
<input type="text" name="VU_DEPT_FIELD_DESC" value="" class=BigStatic size=20 maxlength=100 readonly>
<input type=button value='选 择' class=SmallButton style=height:22px onClick=LoadWindow('VU_DEPT','VU_DEPT_FIELD_DESC') title=选择 name=button>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 起始日期：</td>
<td class="TableData">
<input type="text" name="VU_START_MIN" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_START_MIN');"> 至
<input type="text" name="VU_START_MAX" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_START_MAX');">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 结束日期：</td>
<td class="TableData">
<input type="text" name="VU_END_MIN" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_END_MIN');"> 至
<input type="text" name="VU_END_MAX" size="12" maxlength="10" class="BigInput" value="">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_END_MAX');">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 申 请 人：</td>
<td class="TableData">
<input type="text" name="TO_NAME" size="10" class="BigStatic" readonly>
<input type="button" value='选 择' class="SmallButton" style="height:22px" onClick="LoadWindow1();" title="指定申请人" name="button">
<input type="hidden" name="TO_ID" value="">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 调 度 员：</td>
<td class="TableData">
<select name="VU_OPERATOR" class="BigSelect">
<option value=""></option>
<?
$query = "SELECT * from VEHICLE_OPERATOR where OPERATOR_ID=1";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
{
$OPERATOR_NAME=$ROW1["OPERATOR_NAME"];
$query = "SELECT * from USER where USER_ID!='' and find_in_set(USER_ID,'$OPERATOR_NAME') order by USER_NO,USER_NAME";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
?>
<option value="<?=$USER_ID?>"><?=$USER_NAME?></option>
<?
}
}
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 事 由：</td>
<td class="TableData">
<input type="text" name="VU_REASON" class="BigInput" size="30">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 备 注：</td>
<td class="TableData">
<input type="text" name="VU_REMARK" class="BigInput" size="30">
</td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="submit" value="查询" class="BigButton" onclick="action='search.php';">
<input type="submit" value="导出" class="BigButton" onclick="action='export.php';">
<input type="reset" value="重填" class="BigButton">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -