Subversion Repositories DevTools

Rev

Rev 6579 | Rev 7290 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5357 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|				        view by file			     |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
' Good idea to set when using redirect
12
Response.Expires = 0	' always load the page, dont store
13
%>
14
<!--#include file="common/conf.asp"-->
15
<!--#include file="common/globals.asp"-->
16
<!--#include file="common/formating.asp"-->
17
<!--#include file="common/qstr.asp"-->
18
<!--#include file="common/common_subs.asp"-->
19
<%
20
'------------ ACCESS CONTROL ------------------
21
%>
6181 dpurdie 22
<!--#include file="_access_control_login_optional.asp"-->
5357 dpurdie 23
<!--#include file="_access_control_general.asp"-->
24
<%
25
'------------ Variable Definition -------------
26
Dim rsRep
27
Dim parKeyword
28
Dim parFPkgName, parFPkgVersion
29
Dim FileName
30
Dim sLink
31
'------------ Constants Declaration -----------
32
Const MaxRows = 100
33
'------------ Variable Init -------------------
34
parKeyword = Request("filename")
35
 
36
parFPkgName = Request("fpkgname")
37
If parFPkgName = "" Then  parFPkgName = "*"
38
 
39
parFPkgVersion = Request("fpkgversion")
40
If parFPkgVersion = "" Then  parFPkgVersion = "*"
41
 
42
'----------------------------------------------
43
%>
44
<%
45
'-----------------------------------------------------------------------------------------------------------------------
46
'-----------------------------------------------------------------------------------------------------------------------
47
%>
48
<%
49
'==================== MAIN LINE ===============================
5957 dpurdie 50
If (parKeyword = "") Then 
51
    Call Destroy_All_Objects
52
    Response.Redirect ("index.asp")
53
End If
5357 dpurdie 54
'==============================================================
55
%>
56
<html>
57
<head>
58
<title>Release Manager</title>
59
<link rel="shortcut icon" href="<%=FavIcon%>"/>
60
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
61
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 62
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
63
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
64
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
5983 dpurdie 65
<!--#include file="_jquery_includes.asp"-->
5357 dpurdie 66
<!-- DROPDOWN MENUS -->
67
<!--#include file="_menu_def.asp"-->
6579 dpurdie 68
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
5357 dpurdie 69
</head>
70
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
71
<!-- HEADER -->
72
<!--#include file="_header.asp"-->
73
<!-- BODY ---->
74
<table width="100%" border="0" cellspacing="0" cellpadding="0">
75
  <tr> 
6876 dpurdie 76
    <td class='bg_panel'>
5357 dpurdie 77
      <!--#include file="_front_explorer.asp"-->
78
    </td>
79
    <td rowspan="2" valign="top"> 
80
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
81
        <tr> 
82
          <td >
83
 
84
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
85
			<tr> 
86
			  <td width="1%"></td>
87
			  <td width="100%" align="right"><img src="images/h_trsp_dot.gif" width="1" height="20"></td>
88
			  <td width="1%"></td>
89
			</tr>
90
			<tr> 
91
			  <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="500"></td>
92
			  <td bgcolor="#FFFFFF" valign="top"> 
93
				<!-- PACKAGE SEARCH ------------------------------------------------>
94
				<%
95
				' Format keyword for search
96
				If InStr( parKeyword, "*" ) > 0 Then
97
					' Use wild cards
98
					FileName = Replace( parKeyword, "*", "%")
99
				Else
100
					' Wildcard is not used, hence append card to the end for better results
101
					FileName = parKeyword & "%"
102
				End If
103
 
104
 
105
				OraDatabase.Parameters.Add "FILE_NAME", 	FileName, ORAPARM_INPUT, ORATYPE_VARCHAR2
106
				OraDatabase.Parameters.Add "PKG_NAME", 		Replace( parFPkgName, "*", "%" ), ORAPARM_INPUT, ORATYPE_VARCHAR2
107
				OraDatabase.Parameters.Add "PKG_VERSION", 	Replace( parFPkgVersion, "*", "%" ), ORAPARM_INPUT, ORATYPE_VARCHAR2
108
				OraDatabase.Parameters.Add "PAGE_SIZE", 	MaxRows, ORAPARM_INPUT, ORATYPE_NUMBER
109
 
110
			  	Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindFiles.sql"), 0 )
111
 
112
				OraDatabase.Parameters.Remove "FILE_NAME"
113
				OraDatabase.Parameters.Remove "PKG_NAME"
114
				OraDatabase.Parameters.Remove "PKG_VERSION"
115
				OraDatabase.Parameters.Remove "PAGE_SIZE"
116
 
117
				%>
118
 
119
				<table width="100%"  border="0" cellspacing="0" cellpadding="5">
120
				  <tr>
121
                    <td class="body_sect">Files</td>
122
                  </tr>
123
                  <tr>
124
                    <td nowrap bgcolor="#E4E9EC" class="body_txt">
125
						Results for <b><%=parKeyword%></b>. Showing max. <%=MaxRows%> results.
126
					</td>
127
                  </tr>
128
                </table>
129
 
130
 
131
 
132
				<table width="100%" border="0" cellspacing="1" cellpadding="5">
133
				<form name="file_search" method="get" action="<%=ScriptName%>">
134
				  <input type="hidden" name="filename" value="<%=parKeyword%>">
135
				  <input type="hidden" name="listby" value="<%=parListBy%>">
136
				 <tr>
137
                    <td width="20%" nowrap class="body_col" bgcolor="#E4E9EC">File</td>
138
					<td width="40%" nowrap class="body_col" bgcolor="#E4E9EC">Path</td>
139
					<td width="20%" nowrap class="body_col" bgcolor="#E4E9EC">Package Name</td>
140
					<td width="20%" nowrap class="body_col" bgcolor="#E4E9EC">Version</td>
141
					<td width="1%" nowrap class="body_col" bgcolor="#E4E9EC">CheckSum&nbsp;(CKSUM)</td>
142
                  </tr>
143
				  <tr>
144
                    <td nowrap class="body_col" bgcolor="#E4E9EC"></td>
145
					<td nowrap class="body_col" bgcolor="#E4E9EC"></td>
146
					<td nowrap bgcolor="#E4E9EC"><input name="fpkgname" type="text" class="form_item" size="10" value="<%=parFPkgName%>"></td>
147
					<td nowrap bgcolor="#E4E9EC"><input name="fpkgversion" type="text" class="form_item" size="10" value="<%=parFPkgVersion%>"></td>
148
					<td nowrap bgcolor="#E4E9EC"><input name="btn" type="image" src="images/spacer.gif" width="1" height="1" border="0"></td>
149
                  </tr>
150
				  <%
151
				  If rsRep.RecordCount = 0 Then
152
					With Response
153
						.write "<tr>"
154
						.write "<td colspan='5' class='body_row'>Your search <b>"& parKeyword &"</b> did not match any file names.</td>"
155
						.write "</tr>"
156
					End With
157
				  End If
158
 
159
				  Do While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) 
160
				  	sLink = dpkg_archiveURL & rsRep("pkg_name") &"/"& rsRep("pkg_version") &"/"& Replace( rsRep("file_path") & rsRep("file_name"), "\", "/" )
161
				  %>
162
					  <tr> 
163
						<td nowrap class="body_row"  bgcolor="#F5F5F5"><a href="<%=sLink%>" class="body_link"><img src='images/rex_images/ext_blank.gif' border='0' hspace='2' align='absmiddle'><%=Highlight_Substring( rsRep("file_name"), parKeyword )%></a></td>
164
						<td nowrap class="body_row"  bgcolor="#F5F5F5"><%=rsRep("file_path")%></td>
165
						<td nowrap class="body_row"  bgcolor="#F5F5F5"><%=rsRep("pkg_name")%></td>
166
						<td nowrap class="body_row"  bgcolor="#F5F5F5"><a href="dependencies.asp?pv_id=<%=rsRep("pv_id")%>" class="body_link"><%=rsRep("pkg_version")%></a></td>
167
						<td nowrap class="body_txt_gray"  bgcolor="#F5F5F5"><%=rsRep("crc_cksum")%></td>
168
					  </tr>
169
				  <%  
170
					  rsRep.MoveNext
171
				  Loop
172
 
173
				  rsRep.Close()
174
				  %>
175
				  <tr> 
176
					<td colspan="5" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
177
				  </tr>
178
 
179
				  </form>
180
				</table>
181
				<br>
182
				<!------------------------------------------------------------>			
183
 
184
 
185
				</td>
186
			  <td background="images/lbox_bgside_white.gif">&nbsp;</td>
187
			</tr>
188
		  </table>
189
 
190
		  </td>
191
        </tr>
192
      </table>
193
    </td>
194
    <td width="11%">&nbsp;</td>
195
  </tr>
196
  <tr> 
6876 dpurdie 197
    <td class='bg_panel_btm'><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
5357 dpurdie 198
    <td>&nbsp;</td>
199
  </tr>
200
</table>
201
<!-- FOOTER -->
202
<!--#include file="_footer.asp"-->
203
</body>
204
</html>