?? search.php
字號:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.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>\r\nfunction delete_vehicle(VM_ID)\r\n{\r\n msg='確認要刪除該維護信息么？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?VM_ID=\" + VM_ID;\r\n window.location=URL;\r\n }\r\n}\r\nfunction order_by(field,asc_desc)\r\n{\r\n window.location=\"search.php?V_ID=";
echo $V_ID;
echo "&BEGIN_DATE=";
echo $BEGIN_DATE;
echo "&END_DATE=";
echo $END_DATE;
echo "&VM_TYPE=";
echo $VM_TYPE;
echo "&VM_REASON=";
echo $VM_REASON;
echo "&VM_PERSON=";
echo $VM_PERSON;
echo "&VM_FEE_MIN=";
echo $VM_FEE_MIN;
echo "&VM_FEE_MAX=";
echo $VM_FEE_MAX;
echo "&VM_REMARK=";
echo $VM_REMARK;
echo "&FIELD=\"+field+\"&ASC_DESC=\"+asc_desc;\r\n}\r\n</script>\r\n\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
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( );
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/vehicle.gif\" HEIGHT=\"20\"><span class=\"big3\"> 維護記錄管理</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
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."%'";
}
$WHERE_STR .= field_where_str( "VEHICLE_MAINTENANCE", $_POST, "VEHICLE_MAINTENANCE.VM_ID" );
if ( $FIELD == "" )
{
$query_order = " order by VM_REQUEST_DATE";
$FIELD = "VM_REQUEST_DATE";
}
else
{
$query_order = " order by ".$FIELD;
if ( $ASC_DESC == "1" )
{
$query_order .= " desc";
}
else
{
$query_order .= " 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\">";
}
$query = "SELECT * from VEHICLE_MAINTENANCE where 1=1".$WHERE_STR.$query_order;
$cursor = exequery( $connection, $query );
$VM_COUNT = 0;
$VM_FEE_SUM = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VM_COUNT;
$VM_ID1 = $ROW['VM_ID'];
$V_ID1 = $ROW['V_ID'];
$VM_REQUEST_DATE1 = $ROW['VM_REQUEST_DATE'];
$VM_TYPE1 = $ROW['VM_TYPE'];
$VM_REASON1 = $ROW['VM_REASON'];
$VM_FEE1 = $ROW['VM_FEE'];
$VM_PERSON1 = $ROW['VM_PERSON'];
$VM_REMARK1 = $ROW['VM_REMARK'];
$VM_FEE_SUM += $VM_FEE1;
if ( $VM_REQUEST_DATE1 == "0000-00-00" )
{
$VM_REQUEST_DATE1 = "";
}
$query = "SELECT * from VEHICLE where V_ID='".$V_ID1."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$V_NUM1 = $ROW1['V_NUM'];
}
if ( $VM_TYPE1 == 0 )
{
$VM_TYPE_DESC = "維修";
}
else if ( $VM_TYPE1 == 1 )
{
$VM_TYPE_DESC = "加油";
}
else if ( $VM_TYPE1 == 2 )
{
$VM_TYPE_DESC = "洗車";
}
else if ( $VM_TYPE1 == 3 )
{
$VM_TYPE_DESC = "年檢";
}
else if ( $VM_TYPE1 == 4 )
{
$VM_TYPE_DESC = "其它";
}
if ( $VM_COUNT == 1 )
{
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\" onclick=\"order_by('V_ID','";
if ( $FIELD == "V_ID" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>車牌號</u>";
if ( $FIELD == "V_ID" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\" onclick=\"order_by('VM_TYPE','";
if ( $FIELD == "VM_TYPE" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>維護類型</u>";
if ( $FIELD == "VM_TYPE" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\" onclick=\"order_by('VM_REASON','";
if ( $FIELD == "VM_REASON" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>維護原因</u>";
if ( $FIELD == "VM_REASON" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\" onclick=\"order_by('VM_REQUEST_DATE','";
if ( $FIELD == "VM_REQUEST_DATE" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>維護日期</u>";
if ( $FIELD == "VM_REQUEST_DATE" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\" onclick=\"order_by('VM_PERSON','";
if ( $FIELD == "VM_PERSON" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>經辦人</u>";
if ( $FIELD == "VM_PERSON" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\" onclick=\"order_by('VM_FEE','";
if ( $FIELD == "VM_FEE" )
{
echo 1 - $ASC_DESC;
}
else
{
echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>維護費用</u>";
if ( $FIELD == "VM_FEE" )
{
echo $ORDER_IMG;
}
echo "</td>\r\n <td nowrap align=\"center\">備注</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableData\">\r\n <td nowrap align=\"center\">";
echo $V_NUM1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $VM_TYPE_DESC;
echo "</td>\r\n <td nowrap align=\"left\" title=\"";
echo $VM_REASON1;
echo "\">";
echo csubstr( $VM_REASON1, 0, 10 ).( 10 < strlen( $VM_REASON1 ) ? "..." : "" );
echo "</td>\r\n <td nowrap align=\"center\">";
echo $VM_REQUEST_DATE1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $VM_PERSON1;
echo "</td>\r\n <td nowrap align=\"right\">";
echo $VM_FEE1;
echo "</td>\r\n <td nowrap align=\"left\" title=\"";
echo $VM_REMARK1;
echo "\">";
echo csubstr( $VM_REMARK1, 0, 10 ).( 10 < strlen( $VM_REMARK1 ) ? "..." : "" );
echo "</td>\r\n <td nowrap align=\"center\">\r\n <a href=\"new.php?VM_ID=";
echo $VM_ID1;
echo "\">修改</a> \r\n <a href=javascript:delete_vehicle('";
echo $VM_ID1;
echo "');>刪除</a>\r\n </td>\r\n </tr>\r\n";
}
if ( 0 < $VM_COUNT )
{
echo " <tr class=\"TableControl\">\r\n <td nowrap align=\"center\"><b>合計：</b></td>\r\n <td nowrap align=\"center\" colspan=\"4\"></td>\r\n <td nowrap align=\"right\">";
echo $VM_FEE_SUM;
echo "</td>\r\n <td nowrap align=\"center\" colspan=\"2\">\r\n </td>\r\n </tr>\r\n </table>\r\n<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"導出\" class=\"BigButton\" onClick=\"window.open('export.php?V_ID=";
echo $V_ID;
echo "&BEGIN_DATE=";
echo $BEGIN_DATE;
echo "&END_DATE=";
echo $END_DATE;
echo "&VM_TYPE=";
echo $VM_TYPE;
echo "&VM_REASON=";
echo $VM_REASON;
echo "&VM_PERSON=";
echo $VM_PERSON;
echo "&VM_FEE_MIN=";
echo $VM_FEE_MIN;
echo "&VM_FEE_MAX=";
echo $VM_FEE_MAX;
echo "&VM_REMARK=";
echo $VM_REMARK;
echo "&FIELD=";
echo $FIELD;
echo "&ASC_DESC=";
echo $ASC_DESC;
echo "');\" title=\"導出word文件\"> \r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='query.php'\"> \r\n</div>\r\n";
}
else
{
message( "", "暫無車輛維護信息" );
button_back( );
}
echo "\r\n</body>\r\n\r\n</html>\r\n";
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -