📄 search.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>车辆维护记录管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_vehicle(VM_ID)
{
msg='确认要删除该维护信息么？';
if(window.confirm(msg))
{
URL="delete.php?VM_ID=" + VM_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
if($BEGIN_DATE!="")
{
$TIME_OK=is_date($BEGIN_DATE);
if(!$TIME_OK)
{ Message("错误","维护日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
if($END_DATE!="")
{
$TIME_OK=is_date($END_DATE);
if(!$TIME_OK)
{ Message("错误","维护日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
if($VM_FEE_MIN!=""&&!is_numeric($VM_FEE_MIN) || $VM_FEE_MAX!=""&&!is_numeric($VM_FEE_MAX))
{
Message("错误","维护费用应为数字！");
Button_Back();
exit;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/vehicle.gif" HEIGHT="20"><span class="big3"> 维护记录管理</span>
</td>
</tr>
</table>
<?
if($V_ID!="")
$WHERE_STR.=" and V_ID='$V_ID'";
if($BEGIN_DATE!="")
$WHERE_STR.=" and VM_REQUEST_DATE>='$BEGIN_DATE'";
if($END_DATE!="")
$WHERE_STR.=" and VM_REQUEST_DATE<='$END_DATE'";
if($VM_TYPE!="")
$WHERE_STR.=" and VM_TYPE='$VM_TYPE'";
if($VM_REASON!="")
$WHERE_STR.=" and VM_REASON like '%$VM_REASON%'";
if($VM_PERSON!="")
$WHERE_STR.=" and VM_PERSON like '%$VM_PERSON%'";
if($VM_FEE_MIN!="")
$WHERE_STR.=" and VM_FEE>=$VM_FEE_MIN";
if($VM_FEE_MAX!="")
$WHERE_STR.=" and VM_FEE=$VM_FEE_MAX";
if($VM_REMARK!="")
$WHERE_STR.=" and VM_REMARK like '%$VM_REMARK%'";
//============================ =======================================
$query = "SELECT * from VEHICLE_MAINTENANCE where 1=1".$WHERE_STR." order by VM_REQUEST_DATE desc";
$cursor= exequery($connection,$query);
$VM_COUNT=0;
$VM_FEE_SUM=0;
while($ROW=mysql_fetch_array($cursor))
{
$VM_COUNT++;
$VM_ID=$ROW["VM_ID"];
$V_ID=$ROW["V_ID"];
$VM_REQUEST_DATE=$ROW["VM_REQUEST_DATE"];
$VM_TYPE=$ROW["VM_TYPE"];
$VM_REASON=$ROW["VM_REASON"];
$VM_FEE=$ROW["VM_FEE"];
$VM_PERSON=$ROW["VM_PERSON"];
$VM_REMARK =$ROW["VM_REMARK"];
$VM_FEE_SUM+=$VM_FEE;
if($VM_REQUEST_DATE=="0000-00-00")
$VM_REQUEST_DATE="";
$query = "SELECT * from VEHICLE where V_ID=$V_ID";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$V_NUM=$ROW1["V_NUM"];
if($VM_TYPE==0)
$VM_TYPE_DESC="维修";
elseif($VM_TYPE==1)
$VM_TYPE_DESC="加油";
elseif($VM_TYPE==2)
$VM_TYPE_DESC="洗车";
elseif($VM_TYPE==3)
$VM_TYPE_DESC="年检";
elseif($VM_TYPE==4)
$VM_TYPE_DESC="其它";
if($VM_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">车牌号</td>
<td nowrap align="center">维护类型</td>
<td nowrap align="center">维护原因</td>
<td nowrap align="center">维护日期日期</td>
<td nowrap align="center">经办人</td>
<td nowrap align="center">维护费用</td>
<td nowrap align="center">备注</td>
<td nowrap align="center">操作</td>
</tr>
<?
}
?>
<tr class="TableData">
<td nowrap align="center"><?=$V_NUM?></td>
<td nowrap align="center"><?=$VM_TYPE_DESC?></td>
<td nowrap align="left" title="<?=$VM_REASON?>"><?=csubstr($VM_REASON,0,10).(strlen($VM_REASON)>10?"...":"")?></td>
<td nowrap align="center"><?=$VM_REQUEST_DATE?></td>
<td nowrap align="center"><?=$VM_PERSON?></td>
<td nowrap align="right"><?=$VM_FEE?></td>
<td nowrap align="left" title="<?=$VM_REMARK?>"><?=csubstr($VM_REMARK,0,10).(strlen($VM_REMARK)>10?"...":"")?></td>
<td nowrap align="center">
<a href="new.php?VM_ID=<?=$VM_ID?>">修改</a>
<a href=javascript:delete_vehicle('<?=$VM_ID?>');>删除</a>
</td>
</tr>
<?
}
if($VM_COUNT>0)
{
?>
<tr class="TableControl">
<td nowrap align="center"><b>合计：</b></td>
<td nowrap align="center" colspan="4"></td>
<td nowrap align="right"><?=$VM_FEE_SUM?></td>
<td nowrap align="center" colspan="2">
</td>
</tr>
</table>
<?
}
else
Message("","暂无车辆维护信息");
Button_Back();
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -