📄 query.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\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\" width=\"470\">\r\n <select name=\"V_ID\" class=\"BigSelect\">\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\"> 维护日期：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"BEGIN_DATE\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BEGIN_DATE');\"> 至\r\n <input type=\"text\" name=\"END_DATE\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_calendar('form1.END_DATE');\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 维护类型：</td>\r\n <td class=\"TableData\">\r\n <SELECT name=\"VM_TYPE\" 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>\r\n <option value=\"4\">其它</option>\r\n </SELECT>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 维护原因：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VM_REASON\" size=\"30\" maxlength=\"200\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 经 办 人：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VM_PERSON\" size=\"10\" maxlength=\"200\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 维护费用：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VM_FEE_MIN\" size=\"10\" maxlength=\"200\" class=\"BigInput\" value=\"\"> 至\r\n <input type=\"text\" name=\"VM_FEE_MAX\" size=\"10\" maxlength=\"200\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"> 备 注：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VM_REMARK\" size=\"30\" maxlength=\"200\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\" colspan=\"2\">\r\n ";
echo get_field_table( get_field_html( "VEHICLE_MAINTENANCE", "", "1" ) );
echo " </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\"> \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 + -