📄 edit.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<script Language=\"JavaScript\">\r\nfunction IsNumber(str)\r\n{\r\n return str.match(/^[0-9]*\$/)!=null;\r\n}\r\n\r\nfunction CheckForm()\r\n{\r\n if(document.form1.V_ID.value==\"\")\r\n { alert(\"请指车辆！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.VU_START.value==\"\")\r\n { alert(\"起始时间不能为空！\");\r\n return (false);\r\n }\r\n\r\n if (document.form1.VU_MILEAGE.value!=\"\"&&!IsNumber(document.form1.VU_MILEAGE.value))\r\n { alert(\"里程应为数字！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.VU_OPERATOR.value==\"\")\r\n { alert(\"请指定调度人员！\");\r\n return (false);\r\n }\r\n\r\n form1.submit();\r\n}\r\n\r\nfunction showDetail()\r\n{\r\n var tem1 =form1.V_ID.value.indexOf(\"*\");\r\n var tem2 =form1.V_ID.value.substr(0,tem1);\r\n var tem3 =form1.V_ID.value.substr(tem1+1); \r\n\r\n form1.VU_DRIVER.value=tem3;\r\n document.all(\"vehicle_detail\").src=\"../show_detail.php?V_ID=\"+tem2;\r\n}\r\n\r\nfunction LoadWindow(field_id,id,desc)\r\n{\r\n URL=\"/ikernel/select?FIELD_ID=\"+field_id+\"&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:0;status:0;help:0;resizable:1;dialogWidth:300px;dialogHeight:250px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\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 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\r\nfunction td_clock(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/clock.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:120px;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\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $VU_ID != "" )
{
$query = "SELECT * from VEHICLE_USAGE where VU_ID=".$VU_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$V_ID = $ROW['V_ID'];
$VU_PROPOSER = $ROW['VU_PROPOSER'];
$VU_REQUEST_DATE = $ROW['VU_REQUEST_DATE'];
$VU_USER = $ROW['VU_USER'];
$VU_REASON = $ROW['VU_REASON'];
$VU_START = $ROW['VU_START'];
$VU_END = $ROW['VU_END'];
$VU_MILEAGE = $ROW['VU_MILEAGE'];
$VU_DEPT = $ROW['VU_DEPT'];
$VU_STATUS = $ROW['VU_STATUS'];
$VU_REMARK = $ROW['VU_REMARK'];
$VU_DESTINATION = $ROW['VU_DESTINATION'];
$VU_OPERATOR = $ROW['VU_OPERATOR'];
$VU_DRIVER = $ROW['VU_DRIVER'];
if ( $VU_START == "0000-00-00 00:00:00" )
{
$VU_START = "";
}
if ( $VU_END == "0000-00-00 00:00:00" )
{
$VU_END = "";
}
}
}
if ( $VU_REQUEST_DATE == "0000-00-00 00:00:00" || $VU_REQUEST_DATE == "" )
{
$VU_REQUEST_DATE = $CUR_TIME;
}
if ( $VU_PROPOSER == "" )
{
$VU_PROPOSER = $LOGIN_USER_ID;
}
$query = "SELECT * from USER where USER_ID='".$VU_PROPOSER."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$VU_PROPOSER_NAME = $ROW['USER_NAME'];
}
if ( $VU_DEPT != "" )
{
$query = "SELECT * from DEPARTMENT where DEPT_ID=".$VU_DEPT;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$VU_DEPT_FIELD_DESC = $ROW['DEPT_NAME'];
}
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" HEIGHT=\"20\"><span class=\"big3\"> 车辆使用申请</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table align=\"center\" border=\"0\" width=\"620\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n<form enctype=\"multipart/form-data\" action=\"update.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 车 牌 号：</td>\r\n <td class=\"TableData\" width=\"230\">\r\n <select name=\"V_ID\" class=\"BigSelect\" onchange=\"showDetail();\">\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'];
$V_DRIVER = $ROW1['V_DRIVER'];
echo " <option value=\"";
echo $V_ID1;
echo "*";
echo $V_DRIVER;
echo "\" ";
if ( $V_ID == $V_ID1 )
{
echo "selected";
}
echo ">";
echo $V_NUM;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 司 机：</td>\r\n <td class=\"TableData\" width=\"230\">\r\n <input type=\"text\" name=\"VU_DRIVER\" size=\"11\" class=\"BigInput\" value=\"";
echo $VU_DRIVER;
echo "\"> \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=\"BigStatic\" value=\"";
echo $VU_USER;
echo "\" readonly>\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 用车部门：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"VU_DEPT\" value=\"";
echo $VU_DEPT;
echo "\">\r\n <input type=\"text\" name=\"VU_DEPT_FIELD_DESC\" value=\"";
echo $VU_DEPT_FIELD_DESC;
echo "\" class=BigStatic size=20 maxlength=100 readonly>\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\" size=\"20\" maxlength=\"19\" class=\"BigInput\" value=\"";
echo $VU_START;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_calendar('form1.VU_START');\">\r\n <img src=\"/images/menu/clock.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_clock('form1.VU_START');\">\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 结束时间：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VU_END\" size=\"20\" maxlength=\"19\" class=\"BigInput\" value=\"";
echo $VU_END;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_calendar('form1.VU_END');\">\r\n <img src=\"/images/menu/clock.gif\" border=\"0\" align=\"absMiddle\" style=\"cursor:hand\" onclick=\"td_clock('form1.VU_END');\">\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_DESTINATION\" size=\"20\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $VU_DESTINATION;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 里 程：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VU_MILEAGE\" size=\"20\" maxlength=\"14\" class=\"BigInput\" value=\"";
echo $VU_MILEAGE;
echo "\">\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_PROPOSER_NAME\" size=\"10\" maxlength=\"100\" class=\"BigStatic\" value=\"";
echo $VU_PROPOSER_NAME;
echo "\" readonly>\r\n <input type=\"hidden\" name=\"VU_PROPOSER\" value=\"";
echo $VU_PROPOSER;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 调 度 员：</td>\r\n <td class=\"TableData\">\r\n <select name=\"VU_OPERATOR\" class=\"BigStatic\">\r\n";
$query = "SELECT * from USER where USER_ID='".$VU_OPERATOR."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo " <option value=\"";
echo $USER_ID;
echo "\" selected>";
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\" colspan=\"3\">\r\n <textarea name=\"VU_REASON\" class=\"BigInput\" cols=\"74\" rows=\"2\">";
echo $VU_REASON;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\" width=\"80\"> 备 注：</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <textarea name=\"VU_REMARK\" class=\"BigInput\" cols=\"74\" rows=\"2\">";
echo $VU_REMARK;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr class=\"TableControl\">\r\n <td nowrap colspan=\"4\" align=\"center\">\r\n <input type=\"hidden\" value=\"";
echo $VU_ID;
echo "\" name=\"VU_ID\">\r\n <input type=\"hidden\" value=\"";
echo $VU_STATUS;
echo "\" name=\"VU_STATUS\">\r\n <input type=\"hidden\" value=\"";
echo $VU_REQUEST_DATE;
echo "\" name=\"VU_REQUEST_DATE\">\r\n <input type=\"button\" value=\"保存\" class=\"BigButton\" onclick=\"CheckForm();\"> \r\n <input type=\"reset\" value=\"重填\" class=\"BigButton\"> \r\n";
if ( $VU_ID != "" )
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='query.php?VU_STATUS=";
echo $VU_STATUS;
echo "'\">\r\n";
}
echo " </td>\r\n </tr>\r\n </table>\r\n</form>\r\n\r\n<iframe id=\"vehicle_detail\" width=\"626\" height=\"200\" src=\"../show_detail.php\" frameBorder=\"0\" frameSpacing=\"0\" scrolling=\"yes\" align=\"center\"></iframe>\r\n\r\n<script>\r\n var tem1 =form1.V_ID.value.indexOf(\"*\");\r\n var tem2 =form1.V_ID.value.substr(0,tem1);\r\n \r\n document.all(\"vehicle_detail\").src=\"../show_detail.php?V_ID=\"+tem2;\r\n</script>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -