📄 search.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>车辆维护记录管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function delete_vehicle(VM_ID)
{
msg=\'确认要删除该维护信息么？\';
if(window.confirm(msg))
{
URL="delete.php?VM_ID=" + VM_ID;
window.location=URL;
}
}
function order_by(field,asc_desc)
{
window.location="search.php?FIELD="+field+"&ASC_DESC="+asc_desc;
}
</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 != '') AND !is_numeric ($VM_FEE_MIN)) OR (($VM_FEE_MAX != '') AND !is_numeric ($VM_FEE_MAX))))
{
message ('错误', '维护费用应为数字！');
button_back ();
exit ();
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/vehicle.gif" HEIGHT="20">';
echo '<s';
echo 'pan 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).'%\''));
}
session_start ();
$WHERE_STR = $WHERE_STR;
if (!session_is_registered ('WHERE_STR'))
{
session_register ('WHERE_STR');
}
if (($ASC_DESC == ''))
{
$ASC_DESC = '1';
}
if (($FIELD == ''))
{
$FIELD = 'VM_REQUEST_DATE';
}
$query = ('SELECT * from VEHICLE_MAINTENANCE where 1=1'.$WHERE_STR);
($query .= ((''.' order by ').$FIELD));
if (($ASC_DESC == '1'))
{
($query .= ' desc');
}
else
{
($query .= ' asc');
}
if (($ASC_DESC == '0'))
{
$ORDER_IMG = '<img border=0 src="/images/arrow_up.gif" width="11" height="10">';
}
else
{
$ORDER_IMG = '<img border=0 src="/images/arrow_down.gif" width="11" height="10">';
}
$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 = '维修';
}
else
{
if (($VM_TYPE == 1))
{
$VM_TYPE_DESC = '加油';
}
else
{
if (($VM_TYPE == 2))
{
$VM_TYPE_DESC = '洗车';
}
else
{
if (($VM_TYPE == 3))
{
$VM_TYPE_DESC = '年检';
}
else
{
if (($VM_TYPE == 4))
{
$VM_TYPE_DESC = '其它';
}
}
}
}
}
if (($VM_COUNT == 1))
{
$EXCEL_OUT = '车牌号,维护类型,维护原因,维护日期,经办人,维护费用,备注
';
echo '<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" onclick="order_by(\'VM_REQUEST_DATE\',\'';
if ((($FIELD == 'VM_REQUEST_DATE') OR ($FIELD == '')))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;" width="30%"><u>维护日期</u>';
if ((($FIELD == 'VM_REQUEST_DATE') OR ($FIELD == '')))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center">经办人</td>
<td nowrap align="center">维护费用</td>
<td nowrap align="center">备注</td>
<td nowrap align="center">操作</td>
</tr>
';
}
($EXCEL_OUT .= ((((((((((((($V_NUM.',').$VM_TYPE_DESC).',').$VM_REASON).',').$VM_REQUEST_DATE).',').$VM_PERSON).',').$VM_FEE).',').$VM_REMARK).'
'));
session_start ();
$MY_EXCEL_OUT = $EXCEL_OUT;
if (!session_is_registered ('MY_EXCEL_OUT'))
{
session_register ('MY_EXCEL_OUT');
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo $V_NUM;
echo '</td>
<td nowrap align="center">';
echo $VM_TYPE_DESC;
echo '</td>
<td nowrap align="left" title="';
echo $VM_REASON;
echo '">';
echo (csubstr ($VM_REASON, 0, 10).((10 < strlen ($VM_REASON)) ? '...' : ''));
echo '</td>
<td nowrap align="center">';
echo $VM_REQUEST_DATE;
echo '</td>
<td nowrap align="center">';
echo $VM_PERSON;
echo '</td>
<td nowrap align="right">';
echo $VM_FEE;
echo '</td>
<td nowrap align="left" title="';
echo $VM_REMARK;
echo '">';
echo (csubstr ($VM_REMARK, 0, 10).((10 < strlen ($VM_REMARK)) ? '...' : ''));
echo '</td>
<td nowrap align="center">
<a href="new.php?VM_ID=';
echo $VM_ID;
echo '">修改</a>
<a href=javascript:delete_vehicle(\'';
echo $VM_ID;
echo '\');>删除</a>
</td>
</tr>
';
}
if ((0 < $VM_COUNT))
{
echo ' <tr class="TableControl">
<td nowrap align="center"><b>合计：</b></td>
<td nowrap align="center" colspan="4"></td>
<td nowrap align="right">';
echo $VM_FEE_SUM;
echo '</td>
<td nowrap align="center" colspan="2">
</td>
</tr>
</table>
';
}
else
{
message ('', '暂无车辆维护信息');
}
echo '<br>
<br>
<div align="center">
<input type="button" value="导出" class="BigButton" onclick="location=\'export.php\';">
<input type="button" class="BigButton" value="打印" onclick="window.print();">
<input type="button" value="返回" class="BigButton" onClick="location=\'query.php\';" title="返回">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -