| Line 20... |
Line 20... |
| 20 |
<!--#include file="_access_control_general.asp"-->
|
20 |
<!--#include file="_access_control_general.asp"-->
|
| 21 |
<%
|
21 |
<%
|
| 22 |
'------------ Variable Definition -------------
|
22 |
'------------ Variable Definition -------------
|
| 23 |
Dim parPkg_id
|
23 |
Dim parPkg_id
|
| 24 |
Dim parPkg_name
|
24 |
Dim parPkg_name
|
| 25 |
Dim parRfield
|
- |
|
| 26 |
Dim parPv_id
|
25 |
Dim parPv_id
|
| 27 |
Dim rsLatest
|
26 |
Dim rsLatest
|
| 28 |
Dim parHidePatches
|
27 |
Dim parHidePatches
|
| 29 |
Dim aVersions
|
28 |
Dim aVersions
|
| 30 |
Dim lastRow, i
|
29 |
Dim lastRow, i
|
| 31 |
Dim objSortHelper
|
30 |
Dim objSortHelper
|
| 32 |
'------------ Constants Declaration -----------
|
31 |
'------------ Constants Declaration -----------
|
| 33 |
'------------ Variable Init -------------------
|
32 |
'------------ Variable Init -------------------
|
| 34 |
parPkg_id = QStrPar("pkg_id")
|
33 |
parPkg_id = QStrPar("pkg_id")
|
| 35 |
parPkg_name = QStrPar("pkg_name")
|
34 |
parPkg_name = QStrPar("pkg_name")
|
| 36 |
parRfield = QStrPar("rfield")
|
- |
|
| 37 |
If Request("pv_id") <> "" Then
|
35 |
If Request("pv_id") <> "" Then
|
| 38 |
parPv_id = Request("pv_id")
|
36 |
parPv_id = Request("pv_id")
|
| 39 |
Else
|
37 |
Else
|
| 40 |
parPv_id = -1
|
38 |
parPv_id = -1
|
| 41 |
End If
|
39 |
End If
|
| 42 |
parHidePatches = Request("hidepatches")
|
40 |
parHidePatches = Request("hidepatches")
|
| 43 |
'----------------------------------------------
|
41 |
'----------------------------------------------
|
| 44 |
%>
|
42 |
%>
|
| 45 |
<%
|
43 |
<%
|
| 46 |
Sub Get_Pkg_Info_From_Rel ( SSrtag_id, SSpv_id )
|
44 |
Sub Get_Pkg_Info_From_Rel ( SSrtag_id, SSpv_id )
|
| 47 |
Dim rsTemp, Query_String
|
45 |
Dim rsTemp, Query_String
|
| 48 |
|
46 |
|
| 49 |
Query_String = _
|
47 |
Query_String = _
|
| 50 |
" SELECT pkg.pkg_name, pv.pkg_version, gr.group_id"&_
|
48 |
" SELECT pkg.pkg_name, pv.pkg_version, gr.group_id"&_
|
| 51 |
" FROM PACKAGES pkg, package_versions pv, release_content rc, GROUPS gr"&_
|
49 |
" FROM PACKAGES pkg, package_versions pv, release_content rc, GROUPS gr"&_
|
| 52 |
" WHERE pkg.pkg_id = pv.pkg_id"&_
|
50 |
" WHERE pkg.pkg_id = pv.pkg_id"&_
|
| 53 |
" AND pv.pv_id = rc.pv_id"&_
|
51 |
" AND pv.pv_id = rc.pv_id"&_
|
| 54 |
" AND gr.group_id = rc.group_id"&_
|
52 |
" AND gr.group_id = rc.group_id"&_
|
| 55 |
" AND rc.rtag_id = "& SSrtag_id &_
|
53 |
" AND rc.rtag_id = "& SSrtag_id &_
|
| 56 |
" AND rc.pv_id = "& SSpv_id
|
54 |
" AND rc.pv_id = "& SSpv_id
|
| 57 |
|
55 |
|
| 58 |
Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
|
56 |
Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
|
| 59 |
|
57 |
|
| 60 |
If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
|
58 |
If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
|
| 61 |
pkgInfoHash.Add "pkg_name", (rsTemp.Fields("pkg_name"))
|
59 |
pkgInfoHash.Add "pkg_name", (rsTemp.Fields("pkg_name"))
|
| 62 |
pkgInfoHash.Add "pkg_version", (rsTemp.Fields("pkg_version"))
|
60 |
pkgInfoHash.Add "pkg_version", (rsTemp.Fields("pkg_version"))
|
| 63 |
pkgInfoHash.Add "group_id", (rsTemp.Fields("group_id"))
|
61 |
pkgInfoHash.Add "group_id", (rsTemp.Fields("group_id"))
|
| 64 |
End If
|
62 |
End If
|
| 65 |
|
63 |
|
| 66 |
rsTemp.Close
|
64 |
rsTemp.Close
|
| 67 |
Set rsTemp = nothing
|
65 |
Set rsTemp = nothing
|
| 68 |
End Sub
|
66 |
End Sub
|
| 69 |
|
67 |
|
| 70 |
|
68 |
|
| Line 72... |
Line 70... |
| 72 |
Get_Latest_All_Ext = _
|
70 |
Get_Latest_All_Ext = _
|
| 73 |
" SELECT pv.pkg_version, pv.dlocked,"&_
|
71 |
" SELECT pv.pkg_version, pv.dlocked,"&_
|
| 74 |
" DECODE ( pv.pv_id, "& nPv_id &", 'selected', NULL ) AS selected"&_
|
72 |
" DECODE ( pv.pv_id, "& nPv_id &", 'selected', NULL ) AS selected"&_
|
| 75 |
" FROM PACKAGES pkg, package_versions pv"&_
|
73 |
" FROM PACKAGES pkg, package_versions pv"&_
|
| 76 |
" WHERE pkg.pkg_id = pv.pkg_id AND pkg.pkg_id = "& NNpkg_id
|
74 |
" WHERE pkg.pkg_id = pv.pkg_id AND pkg.pkg_id = "& NNpkg_id
|
| 77 |
|
75 |
|
| 78 |
If parHidePatches <> "" Then Get_Latest_All_Ext = Get_Latest_All_Ext &" AND pv.is_patch IS NULL"
|
76 |
If parHidePatches <> "" Then Get_Latest_All_Ext = Get_Latest_All_Ext &" AND pv.is_patch IS NULL"
|
| 79 |
|
77 |
|
| 80 |
'Get_Latest_All_Ext = Get_Latest_All_Ext &" ORDER BY pv.v_ext ASC, pv.pkg_version ASC"
|
78 |
'Get_Latest_All_Ext = Get_Latest_All_Ext &" ORDER BY pv.v_ext ASC, pv.pkg_version ASC"
|
| 81 |
'Response.write Get_Latest_All_Ext
|
79 |
'Response.write Get_Latest_All_Ext
|
| 82 |
End Function
|
80 |
End Function
|
| 83 |
|
81 |
|
| 84 |
'------------------------------------------------------------------------------------------------------------------
|
82 |
'------------------------------------------------------------------------------------------------------------------
|
| Line 92... |
Line 90... |
| 92 |
Dim i,j
|
90 |
Dim i,j
|
| 93 |
Response.Write "<table border=""1"" cellspacing=""0"">"
|
91 |
Response.Write "<table border=""1"" cellspacing=""0"">"
|
| 94 |
For i = lo to hi
|
92 |
For i = lo to hi
|
| 95 |
Response.Write "<tr>"
|
93 |
Response.Write "<tr>"
|
| 96 |
For j = 0 to Ubound(vec,1)
|
94 |
For j = 0 to Ubound(vec,1)
|
| 97 |
If j = mark then
|
95 |
If j = mark then
|
| 98 |
Response.Write "<td bgcolor=""FFFFCC"">"
|
96 |
Response.Write "<td bgcolor=""FFFFCC"">"
|
| 99 |
Else
|
97 |
Else
|
| 100 |
Response.Write "<td>"
|
98 |
Response.Write "<td>"
|
| 101 |
End If
|
99 |
End If
|
| 102 |
Response.Write vec(j,i) & "</td>"
|
100 |
Response.Write vec(j,i) & "</td>"
|
| 103 |
Next
|
101 |
Next
|
| 104 |
Response.Write "</tr>"
|
102 |
Response.Write "</tr>"
|
| Line 115... |
Line 113... |
| 115 |
<link rel="stylesheet" href="images/navigation.css" type="text/css">
|
113 |
<link rel="stylesheet" href="images/navigation.css" type="text/css">
|
| 116 |
<script language="JavaScript" src="images/tipster.js"></script>
|
114 |
<script language="JavaScript" src="images/tipster.js"></script>
|
| 117 |
<script language="JavaScript" src="images/_help_tips.js"></script>
|
115 |
<script language="JavaScript" src="images/_help_tips.js"></script>
|
| 118 |
<script language="JavaScript">
|
116 |
<script language="JavaScript">
|
| 119 |
<!--
|
117 |
<!--
|
| 120 |
function updateParent( ) {
|
118 |
function updateParent(cancelled) {
|
| 121 |
var cv;
|
- |
|
| 122 |
cv = document.NewVersion.FRpkgver.value;
|
119 |
window.opener.updateFields("<%=parPv_id%>","<%=parPkg_id%>",document.NewVersion.FRpkgver.value,cancelled);
|
| 123 |
window.opener.document.<%=parRfield%>.value = cv;
|
- |
|
| 124 |
window.opener.document.<%=parRfield%>.focus();
|
- |
|
| 125 |
self.close();
|
120 |
self.close();
|
| 126 |
return false;
|
121 |
return false;
|
| 127 |
}
|
122 |
}
|
| 128 |
// -->
|
123 |
// -->
|
| 129 |
</script>
|
124 |
</script>
|
| 130 |
|
125 |
|
| 131 |
</head>
|
126 |
</head>
|
| 132 |
|
127 |
|
| 133 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
|
128 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
|
| 134 |
<form name="NewVersion" >
|
129 |
<form name="NewVersion" >
|
| 135 |
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
|
130 |
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
|
| 136 |
<tr>
|
131 |
<tr>
|
| 137 |
<td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="22" height="25" hspace="5"></td>
|
132 |
<td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="22" height="25" hspace="5"></td>
|
| 138 |
<td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl"> Get Package Version</td>
|
133 |
<td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl"> Get Package Version</td>
|
| 139 |
<td background="images/lbox_bg_blue.gif" align="right" width="50%">
|
134 |
<td background="images/lbox_bg_blue.gif" align="right" width="50%">
|
| 140 |
<input type="reset" name="btn" value=" Get " class="form_btn_comp" onClick="return updateParent();">
|
135 |
<input type="reset" name="btn" value=" Get " class="form_btn_comp" onClick="return updateParent(false);">
|
| 141 |
<input type="reset" name="btn" value="Cancel" class="form_btn_comp" onClick="self.close()">
|
136 |
<input type="reset" name="btn" value="Cancel" class="form_btn_comp" onClick="return updateParent(true);">
|
| 142 |
</td>
|
137 |
</td>
|
| 143 |
<td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
|
138 |
<td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
|
| 144 |
<img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
|
139 |
<img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
|
| 145 |
</tr>
|
140 |
</tr>
|
| 146 |
<tr>
|
141 |
<tr>
|
| 147 |
<td height="100%" width="1%"> </td>
|
142 |
<td height="100%" width="1%"> </td>
|
| 148 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
143 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
| 149 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
144 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
| 150 |
<tr>
|
145 |
<tr>
|
| 151 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
|
146 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
|
| 152 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
147 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
| 153 |
<td nowrap width="100%"> </td>
|
148 |
<td nowrap width="100%"> </td>
|
| 154 |
</tr>
|
149 |
</tr>
|
| 155 |
<tr>
|
150 |
<tr>
|
| 156 |
<td width="1%"> </td>
|
151 |
<td width="1%"> </td>
|
| 157 |
<td width="1%" nowrap class="form_item" background="images/bg_form_lightbluedark.gif"><%=parPkg_name%></td>
|
152 |
<td width="1%" nowrap class="form_item" background="images/bg_form_lightbluedark.gif"><%=parPkg_name%></td>
|
| 158 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
|
153 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
|
| 159 |
<select name="FRpkgver" class="form_item">
|
154 |
<select name="FRpkgver" class="form_item">
|
| 160 |
<option value=""></option>
|
155 |
<option value=""></option>
|
| 161 |
<%Set rsLatest = OraDatabase.DbCreateDynaset( Get_Latest_All_Ext( parPkg_id, parPv_id ), cint(0))
|
156 |
<%Set rsLatest = OraDatabase.DbCreateDynaset( Get_Latest_All_Ext( parPkg_id, parPv_id ), cint(0))
|
| 162 |
|
157 |
|
| 163 |
If rsLatest.RecordCount > 0 Then
|
158 |
If rsLatest.RecordCount > 0 Then
|
| 164 |
|
159 |
|
| 165 |
aVersions = rsLatest.GetRows()
|
160 |
aVersions = rsLatest.GetRows()
|
| 166 |
lastRow = UBound( aVersions, 2 )
|
161 |
lastRow = UBound( aVersions, 2 )
|
| 167 |
|
162 |
|
| 168 |
Set objSortHelper = New SortHelper
|
163 |
Set objSortHelper = New SortHelper
|
| 169 |
|
164 |
|
| 170 |
' Sort versions
|
165 |
' Sort versions
|
| 171 |
Call objSortHelper.VersionSort( aVersions, 0, lastRow, rsLatest.FieldIndex("pkg_version") )
|
166 |
Call objSortHelper.VersionSort( aVersions, 0, lastRow, rsLatest.FieldIndex("pkg_version") )
|
| 172 |
|
167 |
|
| 173 |
' Descending order
|
168 |
' Descending order
|
| 174 |
For i = lastRow To 0 Step -1
|
169 |
For i = lastRow To 0 Step -1
|
| 175 |
%>
|
170 |
%>
|
| 176 |
<option value="<%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%>" <%=aVersions( rsLatest.FieldIndex("selected"), i )%>><%If aVersions( rsLatest.FieldIndex("dlocked"), i ) = "Y" Then%>R <%Else%> <%End If%><%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%></option>
|
171 |
<option value="<%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%>" <%=aVersions( rsLatest.FieldIndex("selected"), i )%>><%If aVersions( rsLatest.FieldIndex("dlocked"), i ) = "Y" Then%>R <%Else%> <%End If%><%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%></option>
|
| 177 |
<%
|
172 |
<%
|
| 178 |
Next
|
173 |
Next
|
| 179 |
|
174 |
|
| 180 |
Set objSortHelper = nothing
|
175 |
Set objSortHelper = nothing
|
| 181 |
|
176 |
|
| 182 |
End If
|
177 |
End If
|
| 183 |
%>
|
178 |
%>
|
| 184 |
</select>
|
179 |
</select>
|
| 185 |
</td>
|
180 |
</td>
|
| 186 |
</tr>
|
181 |
</tr>
|
| 187 |
<tr>
|
182 |
<tr>
|
| 188 |
<td width="1%"> </td>
|
183 |
<td width="1%"> </td>
|
| 189 |
<td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
|
184 |
<td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
|
| 190 |
<td nowrap width="100%"></td>
|
185 |
<td nowrap width="100%"></td>
|
| 191 |
</tr>
|
186 |
</tr>
|
| 192 |
<tr>
|
187 |
<tr>
|
| 193 |
<td width="1%"> </td>
|
188 |
<td width="1%"> </td>
|
| 194 |
<td width="1%" nowrap class="form_field" colspan="2">R = Released</td>
|
189 |
<td width="1%" nowrap class="form_field" colspan="2">R = Released</td>
|
| 195 |
</tr>
|
190 |
</tr>
|
| 196 |
</table>
|
191 |
</table>
|
| 197 |
</td>
|
192 |
</td>
|
| Line 208... |
Line 203... |
| 208 |
</body>
|
203 |
</body>
|
| 209 |
</html>
|
204 |
</html>
|
| 210 |
|
205 |
|
| 211 |
|
206 |
|
| 212 |
<!-- DESTRUCTOR ------->
|
207 |
<!-- DESTRUCTOR ------->
|
| 213 |
<!--#include file="common/destructor.asp"-->
|
- |
|
| 214 |
|
208 |
<!--#include file="common/destructor.asp"-->
|
| - |
|
209 |
|