?? 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 + -