Subversion Repositories DevTools

Rev

Rev 2365 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2365 Rev 5357
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
'=====================================================
 3 
'=====================================================
4 
'|                                                   |
 4 
'|                                                   |
5 
'|				        view by package			     |
 5 
'|				        view by package			     |
6 
'|                                                   |
 6 
'|                                                   |
7 
'=====================================================
 7 
'=====================================================
8 
%>
 8 
%>
9 
<%
 9 
<%
10 
Option explicit
 10 
Option explicit
11 
' Good idea to set when using redirect
 11 
' Good idea to set when using redirect
12 
Response.Expires = 0	' always load the page, dont store
 12 
Response.Expires = 0	' always load the page, dont store
13 
%>
 13 
%>
14 
<!--#include file="common/conf.asp"-->
 14 
<!--#include file="common/conf.asp"-->
15 
<!--#include file="common/globals.asp"-->
 15 
<!--#include file="common/globals.asp"-->
16 
<!--#include file="common/formating.asp"-->
 16 
<!--#include file="common/formating.asp"-->
17 
<!--#include file="common/qstr.asp"-->
 17 
<!--#include file="common/qstr.asp"-->
18 
<!--#include file="common/common_subs.asp"-->
 18 
<!--#include file="common/common_subs.asp"-->
19 
<%
 19 
<%
20 
'------------ ACCESS CONTROL ------------------
 20 
'------------ ACCESS CONTROL ------------------
21 
%>
 21 
%>
22 
<!--#include file="_access_control_general.asp"-->
 22 
<!--#include file="_access_control_general.asp"-->
23 
<%
 23 
<%
24 
'------------ Variable Definition -------------
 24 
'------------ Variable Definition -------------
25 
Dim rsRep
 25 
Dim rsRep
26 
Dim parKeyword
 26 
Dim parKeyword
27 
Dim parBrowse
 27 
Dim parBrowse
28 
'------------ Constants Declaration -----------
 28 
'------------ Constants Declaration -----------
29 
'------------ Variable Init -------------------
 29 
'------------ Variable Init -------------------
30 
parKeyword = Request("pkgname")
 30 
parKeyword = Request("pkgname")
31 
parBrowse = Request("browse")
 31 
parBrowse = Request("browse")
32 
'----------------------------------------------
 32 
'----------------------------------------------
33 
%>
 33 
%>
34 
<%
 34 
<%
35 
'-----------------------------------------------------------------------------------------------------------------------
 35 
'-----------------------------------------------------------------------------------------------------------------------
36 
'-----------------------------------------------------------------------------------------------------------------------
 36 
'-----------------------------------------------------------------------------------------------------------------------
37 
%>
 37 
%>
38 
<%
 38 
<%
39 
'==================== MAIN LINE ===============================
 39 
'==================== MAIN LINE ===============================
40 
If (parKeyword = "") AND (parBrowse = "") Then Response.Redirect ("index.asp")
 40 
If (parKeyword = "") AND (parBrowse = "") Then Response.Redirect ("index.asp")
41 
'==============================================================
 41 
'==============================================================
42 
%>
 42 
%>
43 
<html>
 43 
<html>
44 
<head>
 44 
<head>
45 
<title>Release Manager</title>
 45 
<title>Release Manager</title>
46 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
 46 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
47 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 47 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
48 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
 48 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
49 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
 49 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
50 
<script language="JavaScript" src="images/common.js"></script>
 50 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
51 
<!-- DROPDOWN MENUS -->
 51 
<script language="JavaScript" src="images/common.js"></script>
52 
<!--#include file="_menu_def.asp"-->
 52 
<!-- DROPDOWN MENUS -->
53 
<script language="JavaScript1.2" src="images/popup_menu.js"></script>
 53 
<!--#include file="_menu_def.asp"-->
54 
</head>
 54 
<script language="JavaScript1.2" src="images/popup_menu.js"></script>
55 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
 55 
</head>
56 
<!-- MENU LAYERS -------------------------------------->
 56 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
57 
<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)">
57 
<!-- MENU LAYERS -------------------------------------->
58 
</div>
 58 
<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)">
59 
<!-- HEADER -->
 59 
</div>
60 
<!--#include file="_header.asp"-->
 60 
<!-- HEADER -->
61 
<!-- BODY ---->
 61 
<!--#include file="_header.asp"-->
62 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
 62 
<!-- BODY ---->
63 
  <tr>
63 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
64 
    <td width="1%" background="images/bg_home_orange.gif" valign="top">
 64 
  <tr>
65 
      <!--#include file="_front_explorer.asp"-->
 65 
    <td width="1%" background="images/bg_home_orange.gif" valign="top">
66 
    </td>
 66 
      <!--#include file="_front_explorer.asp"-->
67 
    <td rowspan="2" width="1%" valign="top">
67 
    </td>
68 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
 68 
    <td rowspan="2" width="1%" valign="top">
69 
        <tr>
69 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
70 
          <td width="1%">
 70 
        <tr>
71
71 
          <td width="1%">
72 
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
 72
73 
			<tr>
73 
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
74 
			  <td width="1%"></td>
 74 
			<tr>
75 
			  <td width="100%" align="right"><img src="images/h_trsp_dot.gif" width="1" height="20"></td>
 75 
			  <td width="1%"></td>
76 
			  <td width="1%"></td>
 76 
			  <td width="100%" align="right"><img src="images/h_trsp_dot.gif" width="1" height="20"></td>
77 
			</tr>
 77 
			  <td width="1%"></td>
78 
			<tr>
78 
			</tr>
79 
			  <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="480"></td>
 79 
			<tr>
80 
			  <td bgcolor="#FFFFFF" valign="top">
80 
			  <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="480"></td>
81 
				<!-- PACKAGE SEARCH ------------------------------------------------>
 81 
			  <td bgcolor="#FFFFFF" valign="top">
82 
				<%
 82 
				<!-- PACKAGE SEARCH ------------------------------------------------>
83 
				  OraDatabase.Parameters.Add "KEYWORD", Trim(parKeyword), ORAPARM_INPUT, ORATYPE_VARCHAR2
 83 
				<%
84 
				  OraDatabase.Parameters.Add "BROWSE", parBrowse, ORAPARM_INPUT, ORATYPE_VARCHAR2
 84 
				  OraDatabase.Parameters.Add "KEYWORD", Trim(parKeyword), ORAPARM_INPUT, ORATYPE_VARCHAR2
85
85 
				  OraDatabase.Parameters.Add "BROWSE", parBrowse, ORAPARM_INPUT, ORATYPE_VARCHAR2
86 
				  If parBrowse = "" Then
 86
87 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindPackageName.sql"), 0 )
 87 
				  If parBrowse = "" Then
88 
				  Else
 88 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindPackageName.sql"), 0 )
89 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("BrowsePackageName.sql"), 0 )
 89 
				  Else
90 
				  End If
 90 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("BrowsePackageName.sql"), 0 )
91
91 
				  End If
92 
				  OraDatabase.Parameters.Remove "KEYWORD"
 92
93 
				  OraDatabase.Parameters.Remove "BROWSE"
 93 
				  OraDatabase.Parameters.Remove "KEYWORD"
94 
				%>
 94 
				  OraDatabase.Parameters.Remove "BROWSE"
95
95 
				%>
96 
				<table width="100%"  border="0" cellspacing="0" cellpadding="5">
 96
97 
				  <tr>
 97 
				<table width="100%"  border="0" cellspacing="0" cellpadding="5">
98 
                    <td><span class="body_sect">Package Names</span><img src="images/spacer.gif" width="600" height="1"></td>
 98 
				  <tr>
99 
                  </tr>
 99 
                    <td><span class="body_sect">Package Names</span><img src="images/spacer.gif" width="600" height="1"></td>
100 
                  <tr>
 100 
                  </tr>
101 
                    <td nowrap bgcolor="#E4E9EC" class="body_txt">
 101 
                  <tr>
102 
					<%If parBrowse <> "" Then%>
 102 
                    <td nowrap bgcolor="#E4E9EC" class="body_txt">
103 
						Index <b><%=parBrowse%></b>
 103 
					<%If parBrowse <> "" Then%>
104 
					<%Else%>
 104 
						Index <b><%=parBrowse%></b>
105 
						Results for <b><%=parKeyword%></b>
105 
					<%Else%>
106 
					<%End If%>
 106 
						Results for <b><%=parKeyword%></b>
107 
					</td>
 107 
					<%End If%>
108 
                  </tr>
 108 
					</td>
109 
                </table>
 109 
                  </tr>
110
110 
                </table>
111
111
112
112
113 
				<table width="100%" border="0" cellspacing="1" cellpadding="5">
 113
114 
				  <%
 114 
				<table width="100%" border="0" cellspacing="1" cellpadding="5">
115 
				  If rsRep.RecordCount = 0 Then
 115 
				  <%
116 
					With Response
 116 
				  If rsRep.RecordCount = 0 Then
117 
						.write "<tr>"
 117 
					With Response
118 
						.write "<td class='body_row'>Your search <b>"& parKeyword &"</b> did not match any packages.</td>"
 118 
						.write "<tr>"
119 
						.write "</tr>"
 119 
						.write "<td class='body_row'>Your search <b>"& parKeyword &"</b> did not match any packages.</td>"
120 
					End With
 120 
						.write "</tr>"
121 
				  End If
 121 
					End With
122
122 
				  End If
123 
				  While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) %>
 123
124 
					  <tr>
124 
				  While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) %>
125 
						<td nowrap class="body_row" valign="top" bgcolor="#F5F5F5"><a href="view_by_version.asp?pkg_id=<%=rsRep("pkg_id")%>&listby=<%=parListBy%>" class="body_link"><%=Highlight_Substring( rsRep("pkg_name"), parKeyword )%></a></td>
 125 
					  <tr>
126 
					  </tr>
 126 
						<td nowrap class="body_row" valign="top" bgcolor="#F5F5F5"><a href="view_by_version.asp?pkg_id=<%=rsRep("pkg_id")%>&listby=<%=parListBy%>" class="body_link"><%=Highlight_Substring( rsRep("pkg_name"), parKeyword )%></a></td>
127 
				  <%  rsRep.MoveNext
 127 
					  </tr>
128 
				  WEnd
 128 
				  <%  rsRep.MoveNext
129
129 
				  WEnd
130 
				  rsRep.Close()
 130
131 
				  %>
 131 
				  rsRep.Close()
132 
				  <tr>
132 
				  %>
133 
					<td background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 133 
				  <tr>
134 
				  </tr>
 134 
					<td background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
135 
				</table>
 135 
				  </tr>
136 
				<br>
 136 
				</table>
137 
				<!------------------------------------------------------------>
137 
				<br>
138
138 
				<!------------------------------------------------------------>
139
139
140 
				</td>
 140
141 
			  <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
 141 
				</td>
142 
			</tr>
 142 
			  <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
143 
		  </table>
 143 
			</tr>
144
144 
		  </table>
145 
		  </td>
 145
146 
        </tr>
 146 
		  </td>
147 
      </table>
 147 
        </tr>
148 
    </td>
 148 
      </table>
149 
    <td width="100%">&nbsp;</td>
 149 
    </td>
150 
  </tr>
 150 
    <td width="100%">&nbsp;</td>
151 
  <tr>
151 
  </tr>
152 
    <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
 152 
  <tr>
153 
    <td>&nbsp;</td>
 153 
    <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
154 
  </tr>
 154 
    <td>&nbsp;</td>
155 
</table>
 155 
  </tr>
156 
<!-- FOOTER -->
 156 
</table>
157 
<!--#include file="_footer.asp"-->
 157 
<!-- FOOTER -->
158 
</body>
 158 
<!--#include file="_footer.asp"-->
159 
</html>
 159 
</body>
- 
 
 160 
</html>