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