📄 query_all.php
字号:
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>车辆申请查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript 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';
echo '+"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+"p';
echo 'x");
}
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>
<b';
echo 'ody 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 no';
echo 'wrap class="TableContent" width="80"> 状 态：</td>
<td class="TableData">
';
echo '<s';
echo 'elect 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">
';
echo '<s';
echo 'elect name="V_ID" class="BigSelect" size>1>
<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'];
echo ' <option value="';
echo $V_ID1;
echo '">';
echo $V_NUM;
echo '</option>
';
}
echo ' </select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 司 机：</td>
<td class="TableData"><input type="text" name="VU_DRIVER" size="11" maxlength="100" class="BigInput"></td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 申请日期：</td>
<td class="TableData">
<input type="text" name="VU_REQUEST_DATE_MIN" size=';
echo '"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" onc';
echo 'lick="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">
';
echo ' <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"> 起始日期';
echo '：</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="/imag';
echo 'es/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';
echo '="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"> 申 ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -