📄 new.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>车辆使用申请</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function IsNumber(str)
{
return str.match(/^[0-9]*$/)!=null;
}
function CheckForm()
{
if(document.form1.V_ID.value=="")
{ alert("请指车辆！");
return (false);
}
if(document.form1.VU_START.value=="")
{ alert("起始时间不能为空！");
return (false);
}
if (document.form1.VU_MILEAGE.value!=""&&!IsNumber(document.form1.VU_MILEAGE.value))
{ alert("里程应为数字！");
return (false);
}
if(document.form1.VU_OPERATOR.value=="")
{ alert("请指定调度人员！");
return (false);
}
form1.submit();
}
function showDetail()
{
form1.VU_DRIVER.selectedIndex=form1.V_ID.selectedIndex;
document.all("vehicle_detail").src="show_detail.php?V_ID="+document.form1.V_ID.value;
}
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:200px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
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+"px");
}
function td_clock(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
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");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$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"];
$SMS_REMIND=$ROW["SMS_REMIND"];
$SMS2_REMIND=$ROW["SMS2_REMIND"];
if($VU_START=="0000-00-00 00:00:00")
$VU_START="";
if($VU_END=="0000-00-00 00:00:00")
$VU_END="";
}
}
else
{
$VU_START=$CUR_TIME;
$VU_END=$CUR_TIME;
}
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"];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" HEIGHT="20"><span class="big3"> 车辆使用申请</span>
</td>
</tr>
</table>
<table align="center" border="0" width="620" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="add.php" method="post" name="form1">
<tr>
<td nowrap class="TableContent" width="80"> 车 牌 号：</td>
<td class="TableData" width="230">
<select name="V_ID" class="BigSelect" onchange="showDetail();">
<?
$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"];
?>
<option value="<?=$V_ID1?>" <? if($V_ID==$V_ID1) echo "selected";?>><?=$V_NUM?></option>
<?
}
?>
</select>
</td>
<td nowrap class="TableContent" width="80"> 司 机：</td>
<td class="TableData" width="230">
<select name="VU_DRIVER" class="BigSelect">
<?
$query = "SELECT * from VEHICLE order by V_NUM";
$cursor1= exequery($connection,$query);
while($ROW1=mysql_fetch_array($cursor1))
{
$V_DRIVER=$ROW1["V_DRIVER"];
?>
<option value="<?=$V_DRIVER?>" <? if($VU_DRIVER==$V_DRIVER) echo "selected";?>><?=$V_DRIVER?></option>
<?
}
?>
</select>
</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="<?=$VU_USER?>">
</td>
<td nowrap class="TableContent" width="80"> 用车部门：</td>
<td class="TableData">
<input type="hidden" name="VU_DEPT" value="<?=$VU_DEPT?>">
<input type="text" name="VU_DEPT_FIELD_DESC" value="<?=$VU_DEPT_FIELD_DESC?>" 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"> 起始时间：</td>
<td class="TableData">
<input type="text" name="VU_START" size="20" maxlength="19" class="BigInput" value="<?=$VU_START?>">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_START');">
<img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock('form1.VU_START');">
</td>
<td nowrap class="TableContent" width="80"> 结束时间：</td>
<td class="TableData">
<input type="text" name="VU_END" size="20" maxlength="19" class="BigInput" value="<?=$VU_END?>">
<img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.VU_END');">
<img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock('form1.VU_END');">
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 目 的 地：</td>
<td class="TableData">
<input type="text" name="VU_DESTINATION" size="20" maxlength="100" class="BigInput" value="<?=$VU_DESTINATION?>">
</td>
<td nowrap class="TableContent" width="80"> 里 程：</td>
<td class="TableData">
<input type="text" name="VU_MILEAGE" size="10" maxlength="14" class="BigInput" value="<?=$VU_MILEAGE?>"> (公里)
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 申 请 人：</td>
<td class="TableData">
<input type="text" name="VU_PROPOSER_NAME" size="10" maxlength="100" class="BigStatic" value="<?=$VU_PROPOSER_NAME?>" readonly>
<input type="hidden" name="VU_PROPOSER" value="<?=$LOGIN_USER_ID?>">
</td>
<td nowrap class="TableContent" width="80"> 调 度 员：</td>
<td class="TableData">
<select name="VU_OPERATOR" class="BigSelect">
<?
$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"];
?>
<option value="<?=$USER_ID?>" <? if($VU_OPERATOR==$USER_ID) echo "selected";?>><?=$USER_NAME?></option>
<?
}
}
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 事 由：</td>
<td class="TableData" colspan="3">
<textarea name="VU_REASON" class="BigInput" cols="74" rows="2"><?=$VU_REASON?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 备 注：</td>
<td class="TableData" colspan="3">
<textarea name="VU_REMARK" class="BigInput" cols="74" rows="2"><?=$VU_REMARK?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80"> 提醒调度员：</td>
<td class="TableData" colspan="3">
<input type="checkbox" name="SMS_REMIND1" id="SMS_REMIND1" checked><label for="SMS_REMIND1">使用内部短信</label>
<?
$query = "select * from SMS2_PRIV";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$TYPE_PRIV=$ROW["TYPE_PRIV"];
if(find_id($TYPE_PRIV,9)) //检查该模块是否允许手机提醒
{
?>
<input type="checkbox" name="SMS2_REMIND1" id="SMS2_REMIND1"><label for="SMS2_REMIND1">使用手机短信</label>
<?
}
?>
</td>
</tr>
<tr>
<td nowrap class="TableContent" width="80">通知申请人：</td>
<td class="TableData" colspan="3">
<input type="checkbox" name="SMS_REMIND" id="SMS_REMIND" checked><label for="SMS_REMIND">使用内部短信</label>
<?
$query = "select * from SMS2_PRIV";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$TYPE_PRIV=$ROW["TYPE_PRIV"];
if(find_id($TYPE_PRIV,8)) //检查该模块是否允许手机提醒
{
?>
<input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="SMS2_REMIND">使用手机短信</label><br>说明：调度员批准时会按照指定的方式通知申请人
<?
}
?>
</td>
</tr>
<tr class="TableControl">
<td nowrap colspan="4" align="center">
<input type="hidden" value="<?=$VU_ID?>" name="VU_ID">
<input type="hidden" name="VU_REQUEST_DATE" value="<?=$VU_REQUEST_DATE?>">
<input type="button" value="保存" class="BigButton" onclick="CheckForm();">
<input type="reset" value="重填" class="BigButton">
<?
if($VU_ID!="")
{
?>
<input type="button" value="返回" class="BigButton" onclick="location='query.php?VU_STATUS=<?=$VU_STATUS?>'">
<?
}
?>
</td>
</tr>
</table>
</form>
<iframe id="vehicle_detail" width="626" height="200" src="show_detail.php" frameBorder="0" frameSpacing="0" scrolling="no" align="center"></iframe>
<script>
document.all("vehicle_detail").src="show_detail.php?V_ID="+document.form1.V_ID.value;
</script>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -