Advertisement
Advertisement
| 07.03.2008 at 02:47AM PDT, ID: 23536257 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: |
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!--#INCLUDE virtual="/KAMOnline/incs/connection.asp" -->
<!--#INCLUDE virtual="/KAMOnline/incs/authenticationcheck.asp" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Hire Fleet</title>
<style type="text/css">
<!--
body,td,th {font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #000000; font-weight:bold}
body {background-color: #D6D3CE; margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px;}
a {font-size: 12px; color: #FFFFFF;}
a:link {text-decoration: none; color: #5677B4;}
a:visited {text-decoration: none; color: #5677B4;}
a:hover {text-decoration: underline; color: #5677B4;}
a:active {text-decoration: none; color: #5677B4;}
.style1 {font-size:24px}
.style2 {font-size:11px; font-weight:100}
.style3 {font-size:18px; font-weight:bold}
.style4 {font-size:12px; font-weight:bold}
.style5 {font-size:11px; font-weight:100; color:#99ccff; font-style:italic}
.style6 {font-size:13px; color:#FFFFFF}
.style7 {font-size:36px; color:#99ccff;}
.style8 {font-size:13px; color:#99ccff; font-weight:bold; background-color:#000000}
.style9 {font-size:12px; font-weight:100}
-->
</style>
<%
Dim strOnFleet, strGroup, strDepot, strVehList
strOnFleet = Request.Form("OnFleet")
If strOnFleet = "" Then
strOnFleet = "Yes"
End If
strGroup = Request.Form("Group")
If strGroup <> "" Then
strOnFleet = ""
strDepot = ""
End If
strDepot = Request.Form("Depot")
strVehList = Request.Form("VehList")
%>
</head>
<body>
<form name="Show" id="Show" method="post" style="margin-bottom:0px">
<table width="250" border="0" cellspacing="0" cellpadding="1">
<tr>
<td valign="middle"><fieldset style="padding-bottom:5px">
<legend>Show</legend>
<table width="246" border="0" cellspacing="0" cellpadding="1">
<tr>
<td align="right" valign="middle">Fleet</td>
<td align="left" valign="middle">
<select name="OnFleet" id="OnFleet" class="style2" style="width:80px" onchange="document.Show.submit()">
<option value="Yes">Yes</option>
<%
Dim objRSOnFleet, msqlOnFleet
msqlOnFleet = "SELECT Hire_Fleet.On_Fleet " & _
"FROM Hire_Fleet " & _
"GROUP BY Hire_Fleet.On_Fleet " & _
"HAVING ((Not (Hire_Fleet.On_Fleet) Is Null And (Hire_Fleet.On_Fleet) <> ""Yes"")) " & _
"ORDER BY Hire_Fleet.On_Fleet"
Set objRSOnFleet = Server.CreateObject("ADODB.Recordset")
objRSOnFleet.Open msqlOnFleet, objConn, , adLockOptimistic, adCmdTable
If Not objRSOnFleet.EOF Then
Do Until objRSOnFleet.EOF
%>
<option value="<%= objRSOnFleet.fields("On_Fleet")%>"<%If objRSOnFleet.fields("On_Fleet") = strOnFleet Then Response.Write(" selected")%>><%= objRSOnFleet.fields("On_Fleet")%></option>
<%
objRSOnFleet.MoveNext
Loop
End If
objRSOnFleet.Close
Set objRSOnFleet = Nothing
%>
</select></td>
<td align="right" valign="middle">Group</td>
<td align="left" valign="middle"><select name="Group" id="Group" class="style2" style="width:70px" onchange="document.Show.submit()">
<option value="">All</option>
<%
Dim objRSGroup, msqlGroup
msqlGroup = "SELECT lookupHIREGROUPS.Group " & _
"FROM lookupHIREGROUPS " & _
"ORDER BY lookupHIREGROUPS.Group"
Set objRSGroup = Server.CreateObject("ADODB.Recordset")
objRSGroup.Open msqlGroup, objConn, , adLockOptimistic, adCmdTable
If Not objRSGroup.EOF Then
Do Until objRSGroup.EOF
%>
<option value="<%= objRSGroup.fields("Group")%>"<%If objRSGroup.fields("Group") = strGroup Then Response.Write(" selected")%>><%= objRSGroup.fields("Group")%></option>
<%
objRSGroup.MoveNext
Loop
End If
objRSGroup.Close
Set objRSGroup = Nothing
%>
</select></td>
</tr>
<tr>
<td align="right" valign="middle">Depot</td>
<td align="left" valign="middle"><select name="Depot" id="Depot" class="style2" style="width:80px">
<option value="">All</option>
<%
Dim objRSDepot, msqlDepot
msqlDepot = "SELECT Hire_Fleet.Depot " & _
"FROM Hire_Fleet " & _
"GROUP BY Hire_Fleet.Depot " & _
"HAVING ((Not (Hire_Fleet.Depot) Is Null)) " & _
"ORDER BY Hire_Fleet.Depot"
Set objRSDepot = Server.CreateObject("ADODB.Recordset")
objRSDepot.Open msqlDepot, objConn, , adLockOptimistic, adCmdTable
If Not objRSDepot.EOF Then
Do Until objRSDepot.EOF
%>
<option value="<%= objRSDepot.fields("Depot")%>"><%= objRSDepot.fields("Depot")%></option>
<%
objRSDepot.MoveNext
Loop
End If
objRSDepot.Close
Set objRSDepot = Nothing
%>
</select></td>
<td align="right" valign="middle">G Box</td>
<td align="left" valign="middle"><select name="GBox" id="GBox" class="style2" style="width:70px">
<option value="">All</option>
<option value="Auto">Auto</option>
<option value="Manual">Manual</option>
</select></td>
</tr>
<tr>
<td align="right" valign="middle">Status</td>
<td colspan="3" align="left" valign="middle"><select name="Status" id="Status" class="style2" style="width:195px">
<option value="">All</option>
<%
Dim objRSStatus, msqlStatus
msqlStatus = "SELECT Hire_Fleet.STATUS " & _
"FROM Hire_Fleet " & _
"GROUP BY Hire_Fleet.STATUS " & _
"HAVING ((Not (Hire_Fleet.STATUS) Is Null And (Hire_Fleet.STATUS) <> ""All"")) " & _
"ORDER BY Hire_Fleet.STATUS"
Set objRSStatus = Server.CreateObject("ADODB.Recordset")
objRSStatus.Open msqlStatus, objConn, , adLockOptimistic, adCmdTable
If Not objRSStatus.EOF Then
Do Until objRSStatus.EOF
%>
<option value="<%= objRSStatus.fields("STATUS")%>"><%= objRSStatus.fields("STATUS")%></option>
<%
objRSStatus.MoveNext
Loop
End If
objRSStatus.Close
Set objRSStatus = Nothing
%>
</select></td>
</tr>
<tr>
<td align="right" valign="middle">Reg No</td>
<td align="left" valign="middle"><input type="text" name="RegNo" id="RegNo" class="style2" style="width:73px" /></td>
<td colspan="2" align="center" valign="middle"><input type="button" name="ShowSelectedButton" id="ShowSelectedButton" value="Show Selected" class="style2" style="width:90px; height:20px" /></td>
</tr>
<tr>
<td align="right" valign="middle"> </td>
<td align="left" valign="middle"> </td>
<td colspan="2" align="center" valign="middle"><input type="reset" name="ShowAllButton" id="ShowAllButton" value="Show All" class="style2" style="width:56px; height:20px" /><input type="button" name="PrintButton" id="PrintButton" value="Print" class="style2" style="width:34px; height:20px" disabled="disabled" /></td>
</tr>
</table>
</fieldset>
</td>
</tr>
</table>
</form>
<table width="250" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="148" align="right" valign="middle" style="padding-top:5px"><input type="button" name="CaseRecChasesButton" id="CaseRecChasesButton" value="Cost Reclamation - Chases" class="style2" style="width:140px; height:20px" disabled="disabled" /></td>
<td valign="middle" style="padding-top:5px"><input type="button" name="SpecialChasesButton" id="SpecialChasesButton" value="Special - Chases" class="style2" style="width:90px; height:20px" disabled="disabled" /></td>
</tr>
</table>
<table width="250" border="0" cellspacing="0" cellpadding="1">
<tr>
<td align="right" valign="middle" style="padding-top:5px; padding-bottom:5px"><input type="button" name="TaxDiscsExpiringButton" id="TaxDiscsExpiringButton" value="Tax Discs Expiring" class="style2" style="width:98px; height:20px" disabled="disabled" /></td>
<td width="140" valign="middle" style="padding-top:5px; padding-bottom:5px"><input type="button" name="ExceededMileagesButton" id="ExceededMileagesButton" value="Exceeded Mileages" class="style2" style="width:132px; height:20px" disabled="disabled" /></td>
</tr>
</table>
<table width="248" border="0" cellspacing="0" cellpadding="1" bgcolor="#42060F">
<tr>
<td align="center" valign="middle" class="style6">Select Vehicle</td>
</tr>
</table>
<select name="VehList" size="20" class="style9" id="VehList" style="width:250px">
<%
Dim objRSVehList, msqlVehList, strWHERE
If strOnFleet <> "" AND strGroup = "" Then
strWHERE = "WHERE (((Hire_Fleet.On_Fleet) = """ & strOnFleet & """)) "
Else
If strGroup <> "" Then
strWHERE = "WHERE (((Hire_Fleet.[Group]) = """ & strGroup & """)) "
End If
End If
msqlVehList = "SELECT Hire_Fleet.ID, Hire_Fleet.[Group], Hire_Fleet.[Reg No] AS Expr1, Hire_Fleet.[Make] & "" "" & Hire_Fleet.[Model] AS Expr2 " & _
"FROM Hire_Fleet " & _
strWHERE & _
"ORDER BY Hire_Fleet.[Group], Hire_Fleet.[Reg No]"
Set objRSVehList = Server.CreateObject("ADODB.Recordset")
objRSVehList.Open msqlVehList, objConn, , adLockOptimistic, adCmdTable
If Not objRSVehList.EOF Then
Do Until objRSVehList.EOF
%>
<option value="<%= objRSVehList.fields("ID")%>"<%If strVehList = objRSVehList.fields("ID") Then Response.Write(" selected")%>><%= objRSVehList.fields("Group") & ": " & objRSVehList.fields("Expr1") & ": " & objRSVehList.fields("Expr2")%></option>
<%
objRSVehList.MoveNext
Loop
End If
objRSVehList.Close
Set objRSVehList = Nothing
%>
</select>
<table width="250" border="0" cellspacing="0" cellpadding="0" style="margin-top:5px">
<tr>
<td align="center" valign="middle"><input name="AddButton" type="button" class="style9" id="AddButton" value="Add" style="width:50px" disabled="disabled" /></td>
<td align="center" valign="middle"><input name="DeleteButton" type="button" class="style9" id="DeleteButton" value="Delete" style="width:50px" disabled="disabled" /></td>
<td align="center" valign="middle"><input name="CloseButton" type="button" class="style9" id="CloseButton" value="Close" style="width:50px" /></td>
</tr>
</table>
</body>
</html>
|